E.7. 版本 7.4.1

E.7.1. 移植到版本 7.4.1

那些執行 7.4 的用戶不需要轉儲/恢復。

如果您想在訊息模式裡安裝補丁，您需要把它重載到資料庫。 這個要麼是透過執行 initdb 初始化一個新庫， 要麼是在安裝玩新版本後，在 psql 裡以超級用戶在每個資料庫裡執行下面的 SQL 命令實現的 （最好包括 template1），

DROP SCHEMA information_schema CASCADE;
\i /usr/local/pgsql/share/information_schema.sql

在第二個命令裡替換您的安裝路徑。

E.7.2. 修改

• Fixed bug in CREATE SCHEMA parsing in ECPG (Michael)

• Fix compile error when --enable-thread-safety and --with-perl are used together (Peter)

• Fix for subqueries that used hash joins (Tom)

  Certain subqueries that used hash joins would crash because of improperly shared structures.

• Fix free space map compaction bug (Tom)

  This fixes a bug where compaction of the free space map could lead to a database server shutdown.

• Fix for Borland compiler build of libpq (Bruce)

• Fix netmask() and hostmask() to return the maximum-length masklen (Tom)

  Fix these functions to return values consistent with pre-7.4 releases.

• Several contrib/pg_autovacuum fixes

  Fixes include improper variable initialization, missing vacuum after TRUNCATE, and duration computation overflow for long vacuums.

• Allow compile of contrib/cube under Cygwin (Jason Tishler)

• Fix Solaris use of password file when no passwords are defined (Tom)

  Fix crash on Solaris caused by use of any type of password authentication when no passwords were defined.

• JDBC fix for thread problems, other fixes

• Fix for bytea index lookups (Joe)

• Fix information schema for bit data types (Peter)

• Force zero_damaged_pages to be on during recovery from WAL

• Prevent some obscure cases of "variable not in subplan target lists"

• Make PQescapeBytea and byteaout consistent with each other (Joe)

• Escape bytea output for bytes > 0x7e(Joe)

  If different client encodings are used for bytea output and input, it is possible for bytea values to be corrupted by the differing encodings. This fix escapes all bytes that might be affected.

• Added missing SPI_finish() calls to dblink's get_tuple_of_interest() (Joe)

• New Czech FAQ

• Fix information schema view constraint_column_usage for foreign keys (Peter)

• ECPG fixes (Michael)

• Fix bug with multiple IN subqueries and joins in the subqueries (Tom)

• Alllow COUNT('x') to work (Tom)

• Install ECPG include files for Informix compatibility into separate directory (Peter)

  Some names of ECPG include files for Informix compatibility conflicted with operating system include files. By installing them in their own directory, name conflicts have been reduced.

• Fix SSL memory leak (Neil)

  This release fixes a bug in 7.4 where SSL didn't free all memory it allocated.

• Prevent pg_service.conf from using service name as default dbname (Bruce)

• Fix local ident authentication on FreeBSD (Tom)