PostgreSQL 全球開發者今天發布了所有活動版本分支的補丁修復版本,涉及版本包括:9.1.2, 9.0.6, 8.4.10, 8.3.17 和 8.2.23. 如果你正在使用這些版本,而且正在使用二進位複製功能,那麼請儘快升級。
此次更新同時包括已經宣布 End-Of-Life 的 8.2 版本分支。當然還是建議 8.2 版本用戶儘快升級到 8.3.
此次 bug 補丁修復主要涉及的功能包括:二進位複製、hot standby, GIN indexes, citext 擴展, pg_upgrade, window function aggregate sorting, self-referential foreign keys, PL/perl, and general Extension handling. 所有使用到上述功能的用戶都應該儘快升級。
此次更新為 9.1 版本修復了 52 個bug,包括:
Fix bugs in information_schema.referential_constraints view**Correct collations for citext columns and indexes**Prevent possible crash when joining to a scalar functionPrevent transitory data corruption of GIN indexes after a crashPrevent data corruption on TOAST columns when copying dataFix failures during hot standby startupCorrect another "variable not found in subplan target list" bugFix bug with sorting on aggregate expressions in windowing functionsMultiple bug fixes for pg_upgradeChange Foreign Key creation order to better support self-referential keys**Multiple bug fixes to CREATE EXTENSIONEnsure that function return type and data returned from PL/perl agreeEnsure that PL/perl strings are always UTF-8Assorted bug fixes for various ExtensionsUpdates to the time zone database, particularly to CST6完整的改進記錄請看 release notes
相關下載地址: