From 8aad797362fbba1f2f613c12bbc6a4a06bd58f75 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 12 May 2010 23:20:49 +0000 Subject: [PATCH] Preliminary release notes for releases 8.4.4, 8.3.11, 8.2.17, 8.1.21, 8.0.25, 7.4.29. --- doc/src/sgml/release-7.4.sgml | 106 +++++++++++++- doc/src/sgml/release-8.0.sgml | 122 +++++++++++++++- doc/src/sgml/release-8.1.sgml | 116 +++++++++++++++- doc/src/sgml/release-8.2.sgml | 163 +++++++++++++++++++++- doc/src/sgml/release-8.3.sgml | 191 ++++++++++++++++++++++++- doc/src/sgml/release-8.4.sgml | 253 +++++++++++++++++++++++++++++++++- 6 files changed, 945 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/release-7.4.sgml b/doc/src/sgml/release-7.4.sgml index 615d891dac..f6ae8e79ba 100644 --- a/doc/src/sgml/release-7.4.sgml +++ b/doc/src/sgml/release-7.4.sgml @@ -1,6 +1,110 @@ - + + + Release 7.4.29 + + + Release date + 2010-05-17 + + + + This release contains a variety of fixes from 7.4.28. + For information about new features in the 7.4 major release, see + . + + + + The PostgreSQL community will stop releasing updates + for the 7.4.X release series in July 2010. + Users are encouraged to update to a newer release branch soon. + + + + Migration to Version 7.4.29 + + + A dump/restore is not required for those running 7.4.X. + However, if you are upgrading from a version earlier than 7.4.26, + see the release notes for 7.4.26. + + + + + + Changes + + + + + + Do not allow an unprivileged user to reset superuser-only parameter + settings (Alvaro) + + + + Previously, if an unprivileged user ran ALTER USER ... RESET + ALL for himself, or ALTER DATABASE ... RESET ALL for + a database he owns, this would remove all special parameter settings + for the user or database, even ones that are only supposed to be + changeable by a superuser. Now, the ALTER will only + remove the parameters that the user has permission to change. + + + + + + Avoid possible crash during backend shutdown if shutdown occurs + when a CONTEXT addition would be made to log entries (Tom) + + + + In some cases the context-printing function would fail because the + current transaction had already been rolled back when it came time + to print a log message. + + + + + + Update pl/perl's ppport.h for modern Perl versions + (Andrew) + + + + + + Fix assorted memory leaks in pl/python (Andreas Freund, Tom) + + + + + + Ensure that contrib/pgstattuple functions respond to cancel + interrupts promptly (Tatsuhito Kasahara) + + + + + + Make server startup deal properly with the case that + shmget() returns EINVAL for an existing + shared memory segment (Tom) + + + + This behavior has been observed on BSD-derived kernels including OS X. + It resulted in an entirely-misleading startup failure complaining that + the shared memory request size was too large. + + + + + + + + Release 7.4.28 diff --git a/doc/src/sgml/release-8.0.sgml b/doc/src/sgml/release-8.0.sgml index d0ab8b3ff0..ed2aa5ca76 100644 --- a/doc/src/sgml/release-8.0.sgml +++ b/doc/src/sgml/release-8.0.sgml @@ -1,6 +1,126 @@ - + + + Release 8.0.25 + + + Release date + 2010-05-17 + + + + This release contains a variety of fixes from 8.0.24. + For information about new features in the 8.0 major release, see + . + + + + The PostgreSQL community will stop releasing updates + for the 8.0.X release series in July 2010. + Users are encouraged to update to a newer release branch soon. + + + + Migration to Version 8.0.25 + + + A dump/restore is not required for those running 8.0.X. + However, if you are upgrading from a version earlier than 8.0.22, + see the release notes for 8.0.22. + + + + + + Changes + + + + + + Do not allow an unprivileged user to reset superuser-only parameter + settings (Alvaro) + + + + Previously, if an unprivileged user ran ALTER USER ... RESET + ALL for himself, or ALTER DATABASE ... RESET ALL for + a database he owns, this would remove all special parameter settings + for the user or database, even ones that are only supposed to be + changeable by a superuser. Now, the ALTER will only + remove the parameters that the user has permission to change. + + + + + + Avoid possible crash during backend shutdown if shutdown occurs + when a CONTEXT addition would be made to log entries (Tom) + + + + In some cases the context-printing function would fail because the + current transaction had already been rolled back when it came time + to print a log message. + + + + + + Update pl/perl's ppport.h for modern Perl versions + (Andrew) + + + + + + Fix assorted memory leaks in pl/python (Andreas Freund, Tom) + + + + + + Prevent infinite recursion in psql when expanding + a variable that refers to itself (Tom) + + + + + + Ensure that contrib/pgstattuple functions respond to cancel + interrupts promptly (Tatsuhito Kasahara) + + + + + + Make server startup deal properly with the case that + shmget() returns EINVAL for an existing + shared memory segment (Tom) + + + + This behavior has been observed on BSD-derived kernels including OS X. + It resulted in an entirely-misleading startup failure complaining that + the shared memory request size was too large. + + + + + + Update time zone data files to tzdata release 2010j + for DST law changes in Argentina, Australian Antarctic, Bangladesh, + Mexico, Morocco, Pakistan, Palestine, Russia, Syria, Tunisia; + also historical corrections for Taiwan. + + + + + + + + Release 8.0.24 diff --git a/doc/src/sgml/release-8.1.sgml b/doc/src/sgml/release-8.1.sgml index 34ea096548..187dfcd763 100644 --- a/doc/src/sgml/release-8.1.sgml +++ b/doc/src/sgml/release-8.1.sgml @@ -1,6 +1,120 @@ - + + + Release 8.1.21 + + + Release date + 2010-05-17 + + + + This release contains a variety of fixes from 8.1.20. + For information about new features in the 8.1 major release, see + . + + + + Migration to Version 8.1.21 + + + A dump/restore is not required for those running 8.1.X. + However, if you are upgrading from a version earlier than 8.1.18, + see the release notes for 8.1.18. + + + + + + Changes + + + + + + Do not allow an unprivileged user to reset superuser-only parameter + settings (Alvaro) + + + + Previously, if an unprivileged user ran ALTER USER ... RESET + ALL for himself, or ALTER DATABASE ... RESET ALL for + a database he owns, this would remove all special parameter settings + for the user or database, even ones that are only supposed to be + changeable by a superuser. Now, the ALTER will only + remove the parameters that the user has permission to change. + + + + + + Avoid possible crash during backend shutdown if shutdown occurs + when a CONTEXT addition would be made to log entries (Tom) + + + + In some cases the context-printing function would fail because the + current transaction had already been rolled back when it came time + to print a log message. + + + + + + Update pl/perl's ppport.h for modern Perl versions + (Andrew) + + + + + + Fix assorted memory leaks in pl/python (Andreas Freund, Tom) + + + + + + Prevent infinite recursion in psql when expanding + a variable that refers to itself (Tom) + + + + + + Ensure that contrib/pgstattuple functions respond to cancel + interrupts promptly (Tatsuhito Kasahara) + + + + + + Make server startup deal properly with the case that + shmget() returns EINVAL for an existing + shared memory segment (Tom) + + + + This behavior has been observed on BSD-derived kernels including OS X. + It resulted in an entirely-misleading startup failure complaining that + the shared memory request size was too large. + + + + + + Update time zone data files to tzdata release 2010j + for DST law changes in Argentina, Australian Antarctic, Bangladesh, + Mexico, Morocco, Pakistan, Palestine, Russia, Syria, Tunisia; + also historical corrections for Taiwan. + + + + + + + + Release 8.1.20 diff --git a/doc/src/sgml/release-8.2.sgml b/doc/src/sgml/release-8.2.sgml index 48931779b8..ac5c2c2550 100644 --- a/doc/src/sgml/release-8.2.sgml +++ b/doc/src/sgml/release-8.2.sgml @@ -1,6 +1,167 @@ - + + + Release 8.2.17 + + + Release date + 2010-05-17 + + + + This release contains a variety of fixes from 8.2.16. + For information about new features in the 8.2 major release, see + . + + + + Migration to Version 8.2.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.14, + see the release notes for 8.2.14. + + + + + + Changes + + + + + + Fix possible crash if a cache reset message is received during + rebuild of a relcache entry (Heikki) + + + + This error was introduced in 8.2.16 while fixing a related failure. + + + + + + Do not allow an unprivileged user to reset superuser-only parameter + settings (Alvaro) + + + + Previously, if an unprivileged user ran ALTER USER ... RESET + ALL for himself, or ALTER DATABASE ... RESET ALL for + a database he owns, this would remove all special parameter settings + for the user or database, even ones that are only supposed to be + changeable by a superuser. Now, the ALTER will only + remove the parameters that the user has permission to change. + + + + + + Avoid possible crash during backend shutdown if shutdown occurs + when a CONTEXT addition would be made to log entries (Tom) + + + + In some cases the context-printing function would fail because the + current transaction had already been rolled back when it came time + to print a log message. + + + + + + Update pl/perl's ppport.h for modern Perl versions + (Andrew) + + + + + + Fix assorted memory leaks in pl/python (Andreas Freund, Tom) + + + + + + Prevent infinite recursion in psql when expanding + a variable that refers to itself (Tom) + + + + + + Fix psql's \copy to not add spaces around + a dot within \copy (select ...) (Tom) + + + + Addition of spaces around the decimal point in a numeric literal would + result in a syntax error. + + + + + + Ensure that contrib/pgstattuple functions respond to cancel + interrupts promptly (Tatsuhito Kasahara) + + + + + + Make server startup deal properly with the case that + shmget() returns EINVAL for an existing + shared memory segment (Tom) + + + + This behavior has been observed on BSD-derived kernels including OS X. + It resulted in an entirely-misleading startup failure complaining that + the shared memory request size was too large. + + + + + + Avoid possible crashes in syslogger process on Windows (Heikki) + + + + + + Deal more robustly with incomplete time zone information in the + Windows registry (Magnus) + + + + + + Update the set of known Windows time zone names (Magnus) + + + + + + Update time zone data files to tzdata release 2010j + for DST law changes in Argentina, Australian Antarctic, Bangladesh, + Mexico, Morocco, Pakistan, Palestine, Russia, Syria, Tunisia; + also historical corrections for Taiwan. + + + + Also, add PKST (Pakistan Summer Time) to the default set of + timezone abbreviations. + + + + + + + + Release 8.2.16 diff --git a/doc/src/sgml/release-8.3.sgml b/doc/src/sgml/release-8.3.sgml index 2ebba8939f..cac48eebc5 100644 --- a/doc/src/sgml/release-8.3.sgml +++ b/doc/src/sgml/release-8.3.sgml @@ -1,6 +1,195 @@ - + + + Release 8.3.11 + + + Release date + 2010-05-17 + + + + This release contains a variety of fixes from 8.3.10. + For information about new features in the 8.3 major release, see + . + + + + Migration to Version 8.3.11 + + + A dump/restore is not required for those running 8.3.X. + However, if you are upgrading from a version earlier than 8.3.8, + see the release notes for 8.3.8. + + + + + + Changes + + + + + + Fix possible crash if a cache reset message is received during + rebuild of a relcache entry (Heikki) + + + + This error was introduced in 8.3.10 while fixing a related failure. + + + + + + Apply per-function GUC settings while running the language validator + for the function (Itagaki Takahiro) + + + + This avoids failures if the function's code is invalid without the + setting; an example is that SQL functions may not parse if the + search_path is not correct. + + + + + + Do not allow an unprivileged user to reset superuser-only parameter + settings (Alvaro) + + + + Previously, if an unprivileged user ran ALTER USER ... RESET + ALL for himself, or ALTER DATABASE ... RESET ALL for + a database he owns, this would remove all special parameter settings + for the user or database, even ones that are only supposed to be + changeable by a superuser. Now, the ALTER will only + remove the parameters that the user has permission to change. + + + + + + Avoid possible crash during backend shutdown if shutdown occurs + when a CONTEXT addition would be made to log entries (Tom) + + + + In some cases the context-printing function would fail because the + current transaction had already been rolled back when it came time + to print a log message. + + + + + + Ensure the archiver process responds to changes in + archive_command as soon as possible (Tom) + + + + + + Update pl/perl's ppport.h for modern Perl versions + (Andrew) + + + + + + Fix assorted memory leaks in pl/python (Andreas Freund, Tom) + + + + + + Prevent infinite recursion in psql when expanding + a variable that refers to itself (Tom) + + + + + + Fix psql's \copy to not add spaces around + a dot within \copy (select ...) (Tom) + + + + Addition of spaces around the decimal point in a numeric literal would + result in a syntax error. + + + + + + Fix unnecessary GIN indexes do not support whole-index scans + errors for unsatisfiable queries using contrib/intarray + operators (Tom) + + + + + + Ensure that contrib/pgstattuple functions respond to cancel + interrupts promptly (Tatsuhito Kasahara) + + + + + + Make server startup deal properly with the case that + shmget() returns EINVAL for an existing + shared memory segment (Tom) + + + + This behavior has been observed on BSD-derived kernels including OS X. + It resulted in an entirely-misleading startup failure complaining that + the shared memory request size was too large. + + + + + + Avoid possible crashes in syslogger process on Windows (Heikki) + + + + + + Deal more robustly with incomplete time zone information in the + Windows registry (Magnus) + + + + + + Update the set of known Windows time zone names (Magnus) + + + + + + Update time zone data files to tzdata release 2010j + for DST law changes in Argentina, Australian Antarctic, Bangladesh, + Mexico, Morocco, Pakistan, Palestine, Russia, Syria, Tunisia; + also historical corrections for Taiwan. + + + + Also, add PKST (Pakistan Summer Time) to the default set of + timezone abbreviations. + + + + + + + + Release 8.3.10 diff --git a/doc/src/sgml/release-8.4.sgml b/doc/src/sgml/release-8.4.sgml index 74ce90374e..b3b7267e05 100644 --- a/doc/src/sgml/release-8.4.sgml +++ b/doc/src/sgml/release-8.4.sgml @@ -1,6 +1,257 @@ - + + + Release 8.4.4 + + + Release date + 2010-05-17 + + + + This release contains a variety of fixes from 8.4.3. + For information about new features in the 8.4 major release, see + . + + + + Migration to Version 8.4.4 + + + A dump/restore is not required for those running 8.4.X. + However, if you are upgrading from a version earlier than 8.4.2, + see the release notes for 8.4.2. + + + + + + Changes + + + + + + Fix error during WAL replay of ALTER ... SET TABLESPACE + (Tom) + + + + When archive_mode is on, ALTER ... SET TABLESPACE + generates a WAL record whose replay logic was incorrect. It could write + the data to the wrong place, leading to possibly-unrecoverable data + corruption. Data corruption would be observed on standby slaves, and + could occur on the master as well if a database crash and recovery + occurred after committing the ALTER and before the next + checkpoint. + + + + + + Fix possible crash if a cache reset message is received during + rebuild of a relcache entry (Heikki) + + + + This error was introduced in 8.4.3 while fixing a related failure. + + + + + + Apply per-function GUC settings while running the language validator + for the function (Itagaki Takahiro) + + + + This avoids failures if the function's code is invalid without the + setting; an example is that SQL functions may not parse if the + search_path is not correct. + + + + + + Do constraint exclusion for inherited UPDATE and + DELETE target tables when + constraint_exclusion = partition (Tom) + + + + Due to an oversight, this setting previously only caused constraint + exclusion to be checked in SELECT commands. + + + + + + Do not allow an unprivileged user to reset superuser-only parameter + settings (Alvaro) + + + + Previously, if an unprivileged user ran ALTER USER ... RESET + ALL for himself, or ALTER DATABASE ... RESET ALL for + a database he owns, this would remove all special parameter settings + for the user or database, even ones that are only supposed to be + changeable by a superuser. Now, the ALTER will only + remove the parameters that the user has permission to change. + + + + + + Avoid possible crash during backend shutdown if shutdown occurs + when a CONTEXT addition would be made to log entries (Tom) + + + + In some cases the context-printing function would fail because the + current transaction had already been rolled back when it came time + to print a log message. + + + + + + Fix erroneous handling of %r parameter in + recovery_end_command (Heikki) + + + + The value always came out zero. + + + + + + Ensure the archiver process responds to changes in + archive_command as soon as possible (Tom) + + + + + + Fix pl/pgsql's CASE statement to not fail when the + case expression is a query that returns no rows (Tom) + + + + + + Update pl/perl's ppport.h for modern Perl versions + (Andrew) + + + + + + Fix assorted memory leaks in pl/python (Andreas Freund, Tom) + + + + + + Handle empty-string connect parameters properly in ecpg (Michael) + + + + + + Prevent infinite recursion in psql when expanding + a variable that refers to itself (Tom) + + + + + + Fix psql's \copy to not add spaces around + a dot within \copy (select ...) (Tom) + + + + Addition of spaces around the decimal point in a numeric literal would + result in a syntax error. + + + + + + Avoid formatting failure in psql when running in a + locale context that doesn't match the client_encoding + (Tom) + + + + + + Fix unnecessary GIN indexes do not support whole-index scans + errors for unsatisfiable queries using contrib/intarray + operators (Tom) + + + + + + Ensure that contrib/pgstattuple functions respond to cancel + interrupts promptly (Tatsuhito Kasahara) + + + + + + Make server startup deal properly with the case that + shmget() returns EINVAL for an existing + shared memory segment (Tom) + + + + This behavior has been observed on BSD-derived kernels including OS X. + It resulted in an entirely-misleading startup failure complaining that + the shared memory request size was too large. + + + + + + Avoid possible crashes in syslogger process on Windows (Heikki) + + + + + + Deal more robustly with incomplete time zone information in the + Windows registry (Magnus) + + + + + + Update the set of known Windows time zone names (Magnus) + + + + + + Update time zone data files to tzdata release 2010j + for DST law changes in Argentina, Australian Antarctic, Bangladesh, + Mexico, Morocco, Pakistan, Palestine, Russia, Syria, Tunisia; + also historical corrections for Taiwan. + + + + Also, add PKST (Pakistan Summer Time) to the default set of + timezone abbreviations. + + + + + + + + Release 8.4.3 -- 2.40.0