From f324144fd1c0e1430a2cab86e03bb230e99302c5 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 30 Jan 2009 00:37:29 +0000 Subject: [PATCH] Update back-branch release notes. --- doc/src/sgml/release.sgml | 824 ++++++++++++++++++++++++++++++++++++-- 1 file changed, 797 insertions(+), 27 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 1bc89c1379..bc6be17fb2 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -63,6 +63,300 @@ do it for earlier branch release files. review, so each item is truly a community effort. + + Release 8.3.6 + + + Release date + 2009-02-02 + + + + This release contains a variety of fixes from 8.3.5. + For information about new features in the 8.3 major release, see + . + + + + Migration to Version 8.3.6 + + + A dump/restore is not required for those running 8.3.X. + However, if you are upgrading from a version earlier than 8.3.5, + see the release notes for 8.3.5. + + + + + + Changes + + + + + + Make DISCARD ALL release advisory locks, in addition + to everything it already did (Tom) + + + + This was decided to be the most appropriate behavior. This could + affect existing applications, however. + + + + + + Fix whole-index GiST scans to work correctly (Teodor) + + + + This error could cause rows to be lost if a table is clustered + on a GiST index. + + + + + + Fix crash of xmlconcat(NULL) (Peter) + + + + + + Fix possible crash in ispell dictionary if high-bit-set + characters are used as flags (Teodor) + + + + This is known to be done by one widely available Norwegian dictionary, + and the same condition may exist in others. + + + + + + Fix misordering of pg_dump output for composite types + (Tom) + + + + The most likely problem was for user-defined operator classes to + be dumped after indexes or views that needed them. + + + + + + Improve handling of URLs in headline() function (Teodor) + + + + + + Improve handling of overlength headlines in headline() + function (Teodor) + + + + + + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + + + + + + Fix possible Assert failure if a statement executed in PL/pgSQL is + rewritten into another kind of statement, for example if an + INSERT is rewritten into an UPDATE (Heikki) + + + + + + Ensure that a snapshot is available to datatype input functions (Tom) + + + + This primarily affects domains that are declared with CHECK + constraints involving user-defined stable or immutable functions. Such + functions typically fail if no snapshot has been set. + + + + + + Make it safer for SPI-using functions to be used within datatype I/O; + in particular, to be used in domain check constraints (Tom) + + + + + + Avoid unnecessary locking of small tables in VACUUM + (Heikki) + + + + + + Fix a problem that sometimes kept ALTER TABLE ENABLE/DISABLE + RULE from being recognized by active sessions (Tom) + + + + + + Fix a problem that made UPDATE RETURNING tableoid + return zero instead of the correct OID (Tom) + + + + + + Allow functions declared as taking ANYARRAY to work on + the pg_statistic columns of that type (Tom) + + + + This used to work, but was unintentionally broken in 8.3. + + + + + + Fix planner misestimation of selectivity when transitive equality + is applied to an outer-join clause (Tom) + + + + This could result in bad plans for queries like + ... from a left join b on a.a1 = b.b1 where a.a1 = 42 ... + + + + + + Improve optimizer's handling of long IN lists (Tom) + + + + This change avoids wasting large amounts of time on such lists + when constraint exclusion is enabled. + + + + + + Prevent synchronous scan during GIN index build (Tom) + + + + Because GIN is optimized for inserting tuples in increasing TID order, + choosing to use a synchronous scan could slow the build by a factor of + three or more. + + + + + + Ensure that the contents of a holdable cursor don't depend on the + contents of TOAST tables (Tom) + + + + Previously, large field values in a cursor result might be represented + as TOAST pointers, which would fail if the referenced table got dropped + before the cursor is read, or if the large value is deleted and then + vacuumed away. This cannot happen with an ordinary cursor, + but it could with a cursor that is held past its creating transaction. + + + + + + Fix memory leak when a set-returning function is terminated without + reading its whole result (Tom) + + + + + + Fix encoding conversion problems in XML functions when the database + encoding isn't UTF-8 (Tom) + + + + + + Fix contrib/dblink's + dblink_get_result(text,bool) function (Joe) + + + + + + Fix possible garbage output from contrib/sslinfo functions + (Tom) + + + + + + Fix incorrect behavior of contrib/tsearch2 compatibility + trigger when it's fired more than once in a command (Teodor) + + + + + + Fix possible mis-signaling in autovacuum (Heikki) + + + + + + Support running as a service on Windows 7 beta (Dave and Magnus) + + + + + + Fix ecpg's handling of varchar structs (Michael) + + + + + + Fix configure script to properly report failure when + unable to obtain linkage information for PL/Perl (Andrew) + + + + + + Make all documentation reference pgsql-bugs and/or + pgsql-hackers as appropriate, instead of the + now-decommissioned pgsql-ports and pgsql-patches + mailing lists (Tom) + + + + + + Update time zone data files to tzdata release 2009a (for + Kathmandu and historical DST corrections in Switzerland, Cuba) + + + + + + + + Release 8.3.5 @@ -83,9 +377,9 @@ do it for earlier branch release files. A dump/restore is not required for those running 8.3.X. However, if you are upgrading from a version earlier than 8.3.1, - see the release notes for 8.3.1. If you were running a previous - 8.3.X release, REINDEX all GiST indexes after the upgrade. - + see the release notes for 8.3.1. Also, if you were running a previous + 8.3.X release, it is recommended to REINDEX all GiST + indexes after the upgrade. @@ -103,7 +397,8 @@ do it for earlier branch release files. This would result in index searches failing to find rows they - should have found. + should have found. Corrupted indexes can be fixed with + REINDEX. @@ -4000,27 +4295,206 @@ current_date < 2017-11-17 - - - Restrict contrib/pgstattuple functions to - superusers (Tom) - - + + + Restrict contrib/pgstattuple functions to + superusers (Tom) + + + + + + contrib/xml2 is deprecated and planned for + removal in 8.4 (Peter) + + + + The new XML support in core PostgreSQL supersedes this module. + + + + + + + + + + + Release 8.2.12 + + + Release date + 2009-02-02 + + + + This release contains a variety of fixes from 8.2.11. + For information about new features in the 8.2 major release, see + . + + + + Migration to Version 8.2.12 + + + A dump/restore is not required for those running 8.2.X. + However, if you are upgrading from a version earlier than 8.2.11, + see the release notes for 8.2.11. + + + + + + Changes + + + + + + Improve handling of URLs in headline() function (Teodor) + + + + + + Improve handling of overlength headlines in headline() + function (Teodor) + + + + + + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + + + + + + Fix possible Assert failure if a statement executed in PL/pgSQL is + rewritten into another kind of statement, for example if an + INSERT is rewritten into an UPDATE (Heikki) + + + + + + Ensure that a snapshot is available to datatype input functions (Tom) + + + + This primarily affects domains that are declared with CHECK + constraints involving user-defined stable or immutable functions. Such + functions typically fail if no snapshot has been set. + + + + + + Make it safer for SPI-using functions to be used within datatype I/O; + in particular, to be used in domain check constraints (Tom) + + + + + + Avoid unnecessary locking of small tables in VACUUM + (Heikki) + + + + + + Fix a problem that made UPDATE RETURNING tableoid + return zero instead of the correct OID (Tom) + + + + + + Fix planner misestimation of selectivity when transitive equality + is applied to an outer-join clause (Tom) + + + + This could result in bad plans for queries like + ... from a left join b on a.a1 = b.b1 where a.a1 = 42 ... + + + + + + Improve optimizer's handling of long IN lists (Tom) + + + + This change avoids wasting large amounts of time on such lists + when constraint exclusion is enabled. + + + + + + Ensure that the contents of a holdable cursor don't depend on the + contents of TOAST tables (Tom) + + + + Previously, large field values in a cursor result might be represented + as TOAST pointers, which would fail if the referenced table got dropped + before the cursor is read, or if the large value is deleted and then + vacuumed away. This cannot happen with an ordinary cursor, + but it could with a cursor that is held past its creating transaction. + + + + + + Fix memory leak when a set-returning function is terminated without + reading its whole result (Tom) + + + + + + Fix contrib/dblink's + dblink_get_result(text,bool) function (Joe) + + + + + + Fix possible garbage output from contrib/sslinfo functions + (Tom) + + - - - contrib/xml2 is deprecated and planned for - removal in 8.4 (Peter) - + + + Fix configure script to properly report failure when + unable to obtain linkage information for PL/Perl (Andrew) + + - - The new XML support in core PostgreSQL supersedes this module. - - + + + Make all documentation reference pgsql-bugs and/or + pgsql-hackers as appropriate, instead of the + now-decommissioned pgsql-ports and pgsql-patches + mailing lists (Tom) + + - + + + Update time zone data files to tzdata release 2009a (for + Kathmandu and historical DST corrections in Switzerland, Cuba) + + + + - @@ -4044,8 +4518,9 @@ current_date < 2017-11-17 A dump/restore is not required for those running 8.2.X. However, if you are upgrading from a version earlier than 8.2.7, - see the release notes for 8.2.7. If you were running a previous - 8.2.X release, REINDEX all GiST indexes after the upgrade. + see the release notes for 8.2.7. Also, if you were running a previous + 8.2.X release, it is recommended to REINDEX all GiST + indexes after the upgrade. @@ -4063,7 +4538,8 @@ current_date < 2017-11-17 This would result in index searches failing to find rows they - should have found. + should have found. Corrupted indexes can be fixed with + REINDEX. @@ -8477,6 +8953,126 @@ current_date < 2017-11-17 + + Release 8.1.16 + + + Release date + 2009-02-02 + + + + This release contains a variety of fixes from 8.1.15. + For information about new features in the 8.1 major release, see + . + + + + Migration to Version 8.1.16 + + + A dump/restore is not required for those running 8.1.X. + However, if you are upgrading from a version earlier than 8.1.15, + see the release notes for 8.1.15. + + + + + + Changes + + + + + + Fix crash in autovacuum (Alvaro) + + + + The crash occurs only after vacuuming a whole database for + anti-transaction-wraparound purposes, which means that it occurs + infrequently and is hard to track down. + + + + + + Improve handling of URLs in headline() function (Teodor) + + + + + + Improve handling of overlength headlines in headline() + function (Teodor) + + + + + + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + + + + + + Avoid unnecessary locking of small tables in VACUUM + (Heikki) + + + + + + Ensure that the contents of a holdable cursor don't depend on the + contents of TOAST tables (Tom) + + + + Previously, large field values in a cursor result might be represented + as TOAST pointers, which would fail if the referenced table got dropped + before the cursor is read, or if the large value is deleted and then + vacuumed away. This cannot happen with an ordinary cursor, + but it could with a cursor that is held past its creating transaction. + + + + + + Fix uninitialized variables in contrib/tsearch2's + get_covers() function (Teodor) + + + + + + Fix configure script to properly report failure when + unable to obtain linkage information for PL/Perl (Andrew) + + + + + + Make all documentation reference pgsql-bugs and/or + pgsql-hackers as appropriate, instead of the + now-decommissioned pgsql-ports and pgsql-patches + mailing lists (Tom) + + + + + + Update time zone data files to tzdata release 2009a (for + Kathmandu and historical DST corrections in Switzerland, Cuba) + + + + + + + + Release 8.1.15 @@ -8497,8 +9093,9 @@ current_date < 2017-11-17 A dump/restore is not required for those running 8.1.X. However, if you are upgrading from a version earlier than 8.1.2, - see the release notes for 8.1.2. If you were running a previous - 8.1.X release, REINDEX all GiST indexes after the upgrade. + see the release notes for 8.1.2. Also, if you were running a previous + 8.1.X release, it is recommended to REINDEX all GiST + indexes after the upgrade. @@ -8516,7 +9113,8 @@ current_date < 2017-11-17 This would result in index searches failing to find rows they - should have found. + should have found. Corrupted indexes can be fixed with + REINDEX. @@ -12548,6 +13146,92 @@ psql -t -f fixseq.sql db1 | psql -e db1 + + Release 8.0.20 + + + Release date + 2009-02-02 + + + + This release contains a variety of fixes from 8.0.19. + For information about new features in the 8.0 major release, see + . + + + + Migration to Version 8.0.20 + + + A dump/restore is not required for those running 8.0.X. + However, if you are upgrading from a version earlier than 8.0.6, + see the release notes for 8.0.6. + + + + + + Changes + + + + + + Improve handling of URLs in headline() function (Teodor) + + + + + + Improve handling of overlength headlines in headline() + function (Teodor) + + + + + + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + + + + + + Avoid unnecessary locking of small tables in VACUUM + (Heikki) + + + + + + Fix uninitialized variables in contrib/tsearch2's + get_covers() function (Teodor) + + + + + + Make all documentation reference pgsql-bugs and/or + pgsql-hackers as appropriate, instead of the + now-decommissioned pgsql-ports and pgsql-patches + mailing lists (Tom) + + + + + + Update time zone data files to tzdata release 2009a (for + Kathmandu and historical DST corrections in Switzerland, Cuba) + + + + + + + + Release 8.0.19 @@ -16941,6 +17625,92 @@ typedefs (Michael) + + Release 7.4.24 + + + Release date + 2009-02-02 + + + + This release contains a variety of fixes from 7.4.23. + For information about new features in the 7.4 major release, see + . + + + + Migration to Version 7.4.24 + + + A dump/restore is not required for those running 7.4.X. + However, if you are upgrading from a version earlier than 7.4.11, + see the release notes for 7.4.11. + + + + + + Changes + + + + + + Improve handling of URLs in headline() function (Teodor) + + + + + + Improve handling of overlength headlines in headline() + function (Teodor) + + + + + + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + + + + + + Avoid unnecessary locking of small tables in VACUUM + (Heikki) + + + + + + Fix uninitialized variables in contrib/tsearch2's + get_covers() function (Teodor) + + + + + + Fix bug in to_char()'s handling of TH + format codes (Andreas Scherbaum) + + + + + + Make all documentation reference pgsql-bugs and/or + pgsql-hackers as appropriate, instead of the + now-decommissioned pgsql-ports and pgsql-patches + mailing lists (Tom) + + + + + + + + Release 7.4.23 -- 2.39.5