选择 打开 改范围 完整检索页

pgsql.cc 提供对 postgresql.org 官网内容的中文翻译,由 Pigsty 团队维护。

不受支持的版本: 9.3 / 9.2 / 9.1 / 9.0
历史版本PostgreSQL 9.2 已于 2017 年 11 月结束社区维护,本页译文保留供仍在使用旧版本的读者参考。新系统请看当前版本手册首页

E.218. Release 7.4.9 #

Release date: 2005-10-04

This release contains a variety of fixes from 7.4.8. For information about new features in the 7.4 major release, see 第 E.227 节.

E.218.1. Migration to Version 7.4.9

A dump/restore is not required for those running 7.4.X. However, if you are upgrading from a version earlier than 7.4.8, see 第 E.219 节.

E.218.2. Changes

  • Fix error that allowed VACUUM to remove ctid chains too soon, and add more checking in code that follows ctid links

    This fixes a long-standing problem that could cause crashes in very rare circumstances.

  • Fix CHAR() to properly pad spaces to the specified length when using a multiple-byte character set (Yoshiyuki Asaba)

    In prior releases, the padding of CHAR() was incorrect because it only padded to the specified number of bytes without considering how many characters were stored.

  • Fix the sense of the test for read-only transaction in COPY

    The code formerly prohibited COPY TO, where it should prohibit COPY FROM.

  • Fix planning problem with outer-join ON clauses that reference only the inner-side relation

  • Further fixes for x FULL JOIN y ON true corner cases

  • Make array_in and array_recv more paranoid about validating their OID parameter

  • Fix missing rows in queries like UPDATE a=... WHERE a... with GiST index on column a

  • Improve robustness of datetime parsing

  • Improve checking for partially-written WAL pages

  • Improve robustness of signal handling when SSL is enabled

  • Don't try to open more than max_files_per_process files during postmaster startup

  • Various memory leakage fixes

  • Various portability improvements

  • Fix PL/pgSQL to handle var := var correctly when the variable is of pass-by-reference type

  • Update contrib/tsearch2 to use current Snowball code

提交更正

译文有误、术语不当或页面显示问题,请到译文仓库 pgsty/pgdoc 报告译文问题。 英文原文本身的问题,请在当前版本的对应页面向上游反馈;上游不再修订已结束维护的版本。