From 4b59252dce08bbb8c15ce4f35ed21c7ec52da99e Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 4 Jun 2008 03:17:01 +0000 Subject: [PATCH] Draft release notes for upcoming back-branch updates. --- doc/src/sgml/release.sgml | 1474 +++++++++++++++++++++++++++++++++---- 1 file changed, 1333 insertions(+), 141 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 40ed101d24..01a77c1147 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -63,6 +63,371 @@ do it for earlier branch release files. review, so each item is truly a community effort. + + Release 8.3.2 + + + Release date + 2008-06-09 + + + + This release contains a variety of fixes from 8.3.1. + For information about new features in the 8.3 major release, see + . + + + + Migration to Version 8.3.2 + + + 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. + + + + + + Changes + + + + + + Fix ERRORDATA_STACK_SIZE exceeded crash that + occurred on Windows when using UTF-8 database encoding and a different + client encoding (Tom) + + + + + + Fix incorrect archive truncation point calculation for the + %r macro in recovery_command parameters + (Simon) + + + + This could lead to data loss if a warm-standby script relied on + %r to decide when to throw away WAL segment files. + + + + + + Fix ALTER TABLE ADD COLUMN ... PRIMARY KEY so that the new + column is correctly checked to see if it's been initialized to all + non-nulls (Brendan Jurd) + + + + Previous versions neglected to check this requirement at all. + + + + + + Fix REASSIGN OWNED so that it works on procedural + languages too (Alvaro) + + + + + + Fix problems with SELECT FOR UPDATE/SHARE occurring as a + subquery in a query with a non-SELECT top-level operation + (Tom) + + + + + + Fix possible CREATE TABLE failure when inheriting the + same constraint from multiple parent relations that + inherited that constraint from a common ancestor (Tom) + + + + + + Fix pg_get_ruledef() to show the alias, if any, attached + to the target table of an UPDATE or DELETE + (Tom) + + + + + + Restore the pre-8.3 behavior that an out-of-range block number in a + TID being used in a TidScan plan results in silently not matching any + rows (Tom) + + + + 8.3.0 and 8.3.1 threw an error instead. + + + + + + Fix GIN bug that could result in a too many LWLocks + taken failure (Teodor) + + + + + + Fix broken GiST comparison function for tsquery (Teodor) + + + + + + Fix tsvector_update_trigger() and ts_stat() + to accept domains over the types they expect to work with (Tom) + + + + + + Fix failure to support enum data types as foreign keys (Tom) + + + + + + Avoid possible crash when decompressing corrupted data + (Zdenek Kotala) + + + + + + Fix race conditions between delayed unlinks and DROP + DATABASE (Heikki) + + + + In the worst case this could result in deleting a newly created table + in a new database that happened to get the same OID as the + recently-dropped one; but of course that is an extremely + low-probability scenario. + + + + + + Repair two places where SIGTERM exit of a backend could leave corrupted + state in shared memory (Tom) + + + + Neither case is very important if SIGTERM is used to shut down the + whole database cluster together, but there was a problem if someone + tried to SIGTERM individual backends. + + + + + + Fix possible crash due to incorrect plan generated for an + x IN (SELECT y + FROM ...) clause when x and y + have different data types; and make sure the behavior is semantically + correct when the conversion from y's type to + x's type is lossy (Tom) + + + + + + Fix oversight that prevented the planner from substituting known Param + values as if they were constants (Tom) + + + + This mistake partially disabled optimization of unnamed + extended-Query statements in 8.3.0 and 8.3.1: in particular the + LIKE-to-indexscan optimization would never be applied if the LIKE + pattern was passed as a parameter, and constraint exclusion + depending on a parameter value didn't work either. + + + + + + Fix planner failure when an indexable MIN or + MAX aggregate is used with DISTINCT or + ORDER BY (Tom) + + + + + + Fix planner to ensure it never uses a physical tlist for a + plan node that is feeding a Sort node (Tom) + + + + This led to the sort having to push around more data than it really + needed to, since unused column values were included in the sorted + data. + + + + + + Avoid unnecessary copying of query strings (Tom) + + + + This fixes a performance problem introduced in 8.3.0 when a very large + number of commands are submitted as a single query string. + + + + + + Make TransactionIdIsCurrentTransactionId() use binary + search instead of linear search when checking child-transaction XIDs + (Heikki) + + + + This fixes some cases in which 8.3.0 was significantly + slower than earlier releases. + + + + + + Fix conversions between ISO-8859-5 and other encodings to handle + Cyrillic Yo characters (e and E with + two dots) (Sergey Burladyan) + + + + + + Fix several datatype input functions, notably array_in(), + that were allowing unused bytes in their results to contain + uninitialized, unpredictable values (Tom) + + + + This could lead to failures in which two apparently identical literal + values were not seen as equal, resulting in the parser complaining + about unmatched ORDER BY and DISTINCT + expressions. + + + + + + Fix a corner case in regular-expression substring matching + (substring(string from + pattern)) (Tom) + + + + The problem occurs when there is a match to the pattern overall but + the user has specified a parenthesized subexpression and that + subexpression hasn't got a match. An example is + substring('foo' from 'foo(bar)?'). + This should return NULL, since (bar) isn't matched, but + it was mistakenly returning the whole-pattern match instead (ie, + foo). + + + + + + Prevent cancellation of an auto-vacuum that was launched to prevent + XID wraparound (Alvaro) + + + + + + Improve ANALYZE's handling of in-doubt tuples (those + inserted or deleted by a not-yet-committed transaction) so that the + counts it reports to the stats collector are more likely to be correct + (Pavan Deolasee) + + + + + + Fix initdb to reject a relative path for its + --xlogdir (-X) option (Tom) + + + + + + Make psql print tab characters as an appropriate + number of spaces, rather than \x09 as was done in + 8.3.0 and 8.3.1 (Bruce) + + + + + + Update time zone data files to tzdata release 2008c (for + DST law changes in Morocco, Iraq, Choibalsan, Pakistan, Syria, Cuba, and + Argentina/San_Luis) + + + + + + Add ECPGget_PGconn() function to + ecpglib (Michael) + + + + + + Fix incorrect result from ecpg's + PGTYPEStimestamp_sub() function (Michael) + + + + + + Fix handling of continuation line markers in ecpg + (Michael) + + + + + + Fix possible crashes in contrib/cube functions (Tom) + + + + + + Fix core dump in contrib/xml2's + xpath_table() function when the input query returns a + NULL value (Tom) + + + + + + Fix contrib/xml2's makefile to not override + CFLAGS, and make it auto-configure properly for + libxslt present or not (Tom) + + + + + + + + Release 8.3.1 @@ -212,7 +577,7 @@ do it for earlier branch release files. - This was formerly allowed but trying to do it had various unpleasant + This was formerly allowed but trying to do it had various unpleasant consequences, notably that the originating backend could not exit as long as an UNLISTEN remained uncommitted. @@ -2944,43 +3309,238 @@ current_date < 2017-11-17 - - - Update OS/X startup scripts in - contrib/start-scripts (Mark Cotner, David - Fetter) - - + + + Update OS/X startup scripts in + contrib/start-scripts (Mark Cotner, David + Fetter) + + + + + + Restrict pgrowlocks() and + dblink_get_pkey() to users who have + SELECT privilege on the target table (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.8 + + + Release date + 2008-06-09 + + + + This release contains a variety of fixes from 8.2.7. + For information about new features in the 8.2 major release, see + . + + + + Migration to Version 8.2.8 + + + 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. + + + + + + Changes + + + + + + Fix ERRORDATA_STACK_SIZE exceeded crash that + occurred on Windows when using UTF-8 database encoding and a different + client encoding (Tom) + + + + + + Fix ALTER TABLE ADD COLUMN ... PRIMARY KEY so that the new + column is correctly checked to see if it's been initialized to all + non-nulls (Brendan Jurd) + + + + Previous versions neglected to check this requirement at all. + + + + + + Fix possible CREATE TABLE failure when inheriting the + same constraint from multiple parent relations that + inherited that constraint from a common ancestor (Tom) + + + + + + Fix pg_get_ruledef() to show the alias, if any, attached + to the target table of an UPDATE or DELETE + (Tom) + + + + + + Fix GIN bug that could result in a too many LWLocks + taken failure (Teodor) + + + + + + Avoid possible crash when decompressing corrupted data + (Zdenek Kotala) + + + + + + Repair two places where SIGTERM exit of a backend could leave corrupted + state in shared memory (Tom) + + + + Neither case is very important if SIGTERM is used to shut down the + whole database cluster together, but there was a problem if someone + tried to SIGTERM individual backends. + + + + + + Fix conversions between ISO-8859-5 and other encodings to handle + Cyrillic Yo characters (e and E with + two dots) (Sergey Burladyan) + + + + + + Fix several datatype input functions, notably array_in(), + that were allowing unused bytes in their results to contain + uninitialized, unpredictable values (Tom) + + + + This could lead to failures in which two apparently identical literal + values were not seen as equal, resulting in the parser complaining + about unmatched ORDER BY and DISTINCT + expressions. + + + + + + Fix a corner case in regular-expression substring matching + (substring(string from + pattern)) (Tom) + + + + The problem occurs when there is a match to the pattern overall but + the user has specified a parenthesized subexpression and that + subexpression hasn't got a match. An example is + substring('foo' from 'foo(bar)?'). + This should return NULL, since (bar) isn't matched, but + it was mistakenly returning the whole-pattern match instead (ie, + foo). + + + + + + Update time zone data files to tzdata release 2008c (for + DST law changes in Morocco, Iraq, Choibalsan, Pakistan, Syria, Cuba, and + Argentina/San_Luis) + + + + + + Fix incorrect result from ecpg's + PGTYPEStimestamp_sub() function (Michael) + + + + + + Fix broken GiST comparison function for contrib/tsearch2's + tsquery type (Teodor) + + - - - Restrict pgrowlocks() and - dblink_get_pkey() to users who have - SELECT privilege on the target table (Tom) - - + + + Fix possible crashes in contrib/cube functions (Tom) + + - - - Restrict contrib/pgstattuple functions to - superusers (Tom) - - + + + Fix core dump in contrib/xml2's + xpath_table() function when the input query returns a + NULL value (Tom) + + - - - contrib/xml2 is deprecated and planned for - removal in 8.4 (Peter) - + + + Fix contrib/xml2's makefile to not override + CFLAGS (Tom) + + - - The new XML support in core PostgreSQL supersedes this module. - - + + + Fix DatumGetBool macro to not fail with gcc + 4.3 (Tom) + - + + This problem affects old style (V0) C functions that + return boolean. The fix is already in 8.3, but the need to + back-patch it was not realized at the time. + + + + - @@ -3068,7 +3628,7 @@ current_date < 2017-11-17 - This was formerly allowed but trying to do it had various unpleasant + This was formerly allowed but trying to do it had various unpleasant consequences, notably that the originating backend could not exit as long as an UNLISTEN remained uncommitted. @@ -3244,7 +3804,7 @@ current_date < 2017-11-17 This failure has only been observed to occur when a user-defined datatype's output routine issues a NOTICE, but there is no - guaranteee it couldn't happen due to other causes. + guarantee it couldn't happen due to other causes. @@ -6714,50 +7274,300 @@ current_date < 2017-11-17 - - - Improvements to cube module (Joshua Reich) - + + + Improvements to cube module (Joshua Reich) + + + + New functions are cube(float[]), + cube(float[], float[]), and + cube_subset(cube, int4[]). + + + + + + Add async query capability to dblink (Kai Londenberg, + Joe Conway) + + + + + + New operators for array-subset comparisons (@>, + <@, &&) (Tom) + + + + Various contrib packages already had these operators for their + datatypes, but the naming wasn't consistent. We have now added + consistently named array-subset comparison operators to the core code + and all the contrib packages that have such functionality. + (The old names remain available, but are deprecated.) + + + + + + Add uninstall scripts for all contrib packages that have install + scripts (David, Josh Drake) + + + + + + + + + + + + Release 8.1.12 + + + Release date + 2008-06-09 + + + + This release contains a variety of fixes from 8.1.11. + For information about new features in the 8.1 major release, see + . + + + + Migration to Version 8.1.12 + + + 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. + + + + + + Changes + + + + + + Fix ALTER TABLE ADD COLUMN ... PRIMARY KEY so that the new + column is correctly checked to see if it's been initialized to all + non-nulls (Brendan Jurd) + + + + Previous versions neglected to check this requirement at all. + + + + + + Fix possible CREATE TABLE failure when inheriting the + same constraint from multiple parent relations that + inherited that constraint from a common ancestor (Tom) + + + + + + Fix conversions between ISO-8859-5 and other encodings to handle + Cyrillic Yo characters (e and E with + two dots) (Sergey Burladyan) + + + + + + Fix a few datatype input functions + that were allowing unused bytes in their results to contain + uninitialized, unpredictable values (Tom) + + + + This could lead to failures in which two apparently identical literal + values were not seen as equal, resulting in the parser complaining + about unmatched ORDER BY and DISTINCT + expressions. + + + + + + Fix a corner case in regular-expression substring matching + (substring(string from + pattern)) (Tom) + + + + The problem occurs when there is a match to the pattern overall but + the user has specified a parenthesized subexpression and that + subexpression hasn't got a match. An example is + substring('foo' from 'foo(bar)?'). + This should return NULL, since (bar) isn't matched, but + it was mistakenly returning the whole-pattern match instead (ie, + foo). + + + + + + Update time zone data files to tzdata release 2008c (for + DST law changes in Morocco, Iraq, Choibalsan, Pakistan, Syria, Cuba, + Argentina/San_Luis, and Chile) + + + + + + Fix incorrect result from ecpg's + PGTYPEStimestamp_sub() function (Michael) + + + + + + Fix core dump in contrib/xml2's + xpath_table() function when the input query returns a + NULL value (Tom) + + + + + + Fix contrib/xml2's makefile to not override + CFLAGS (Tom) + + + + + + Fix DatumGetBool macro to not fail with gcc + 4.3 (Tom) + + + + This problem affects old style (V0) C functions that + return boolean. The fix is already in 8.3, but the need to + back-patch it was not realized at the time. + + + + + + Fix longstanding LISTEN/NOTIFY + race condition (Tom) + + + + In rare cases a session that had just executed a + LISTEN might not get a notification, even though + one would be expected because the concurrent transaction executing + NOTIFY was observed to commit later. + + + + A side effect of the fix is that a transaction that has executed + a not-yet-committed LISTEN command will not see any + row in pg_listener for the LISTEN, + should it choose to look; formerly it would have. This behavior + was never documented one way or the other, but it is possible that + some applications depend on the old behavior. + + + + + + Disallow LISTEN and UNLISTEN within a + prepared transaction (Tom) + + + + This was formerly allowed but trying to do it had various unpleasant + consequences, notably that the originating backend could not exit + as long as an UNLISTEN remained uncommitted. + + + + + + Fix rare crash when an error occurs during a query using a hash index + (Heikki) + + + + + + Fix input of datetime values for February 29 in years BC (Tom) + + + + The former coding was mistaken about which years were leap years. + + + + + + Fix unrecognized node type error in some variants of + ALTER OWNER (Tom) + + + + + + Fix pg_ctl to correctly extract the postmaster's port + number from command-line options (Itagaki Takahiro, Tom) + + + + Previously, pg_ctl start -w could try to contact the + postmaster on the wrong port, leading to bogus reports of startup + failure. + + - - New functions are cube(float[]), - cube(float[], float[]), and - cube_subset(cube, int4[]). - - + + + Use - - - Add async query capability to dblink (Kai Londenberg, - Joe Conway) - - + + This is known to be necessary when building PostgreSQL + with gcc 4.3 or later. + + - - - New operators for array-subset comparisons (@>, - <@, &&) (Tom) - + + + Fix display of constant expressions in ORDER BY + and GROUP BY (Tom) + - - Various contrib packages already had these operators for their - datatypes, but the naming wasn't consistent. We have now added - consistently named array-subset comparison operators to the core code - and all the contrib packages that have such functionality. - (The old names remain available, but are deprecated.) - - + + An explictly casted constant would be shown incorrectly. This could + for example lead to corruption of a view definition during + dump and reload. + + - - - Add uninstall scripts for all contrib packages that have install - scripts (David, Josh Drake) - - + + + Fix libpq to handle NOTICE messages correctly + during COPY OUT (Tom) + - + + This failure has only been observed to occur when a user-defined + datatype's output routine issues a NOTICE, but there is no + guarantee it couldn't happen due to other causes. + + - + @@ -10104,88 +10914,325 @@ psql -t -f fixseq.sql db1 | psql -e db1 - - - Move /contrib/findoidjoins to - /src/tools (Tom) - - + + + Move /contrib/findoidjoins to + /src/tools (Tom) + + + + + + Remove the <<, >>, + &<, and &> operators from + /contrib/cube + + + These operators were not useful. + + + + + + Improve /contrib/btree_gist (Janko Richter) + + + + + + Improve /contrib/pgbench (Tomoaki Sato, Tatsuo) + + + There is now a facility for testing with SQL command scripts given + by the user, instead of only a hard-wired command sequence. + + + + + + Improve /contrib/pgcrypto (Marko Kreen) + + + + + + + Implementation of OpenPGP symmetric-key and public-key encryption + + + Both RSA and Elgamal public-key algorithms are supported. + + + + + + Stand alone build: include SHA256/384/512 hashes, Fortuna PRNG + + + + + + OpenSSL build: support 3DES, use internal AES with OpenSSL < 0.9.7 + + + + + + Take build parameters (OpenSSL, zlib) from configure result + + + There is no need to edit the Makefile anymore. + + + + + + Remove support for libmhash and libmcrypt + + + + + + + + + + + + + + Release 8.0.16 + + + Release date + 2008-06-09 + + + + This release contains a variety of fixes from 8.0.15. + For information about new features in the 8.0 major release, see + . + + + + Migration to Version 8.0.16 + + + 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 + + + + + + Fix ALTER TABLE ADD COLUMN ... PRIMARY KEY so that the new + column is correctly checked to see if it's been initialized to all + non-nulls (Brendan Jurd) + + + + Previous versions neglected to check this requirement at all. + + + + + + Fix possible CREATE TABLE failure when inheriting the + same constraint from multiple parent relations that + inherited that constraint from a common ancestor (Tom) + + + + + + Fix conversions between ISO-8859-5 and other encodings to handle + Cyrillic Yo characters (e and E with + two dots) (Sergey Burladyan) + + + + + + Fix a few datatype input functions + that were allowing unused bytes in their results to contain + uninitialized, unpredictable values (Tom) + + + + This could lead to failures in which two apparently identical literal + values were not seen as equal, resulting in the parser complaining + about unmatched ORDER BY and DISTINCT + expressions. + + + + + + Fix a corner case in regular-expression substring matching + (substring(string from + pattern)) (Tom) + + + + The problem occurs when there is a match to the pattern overall but + the user has specified a parenthesized subexpression and that + subexpression hasn't got a match. An example is + substring('foo' from 'foo(bar)?'). + This should return NULL, since (bar) isn't matched, but + it was mistakenly returning the whole-pattern match instead (ie, + foo). + + + + + + Update time zone data files to tzdata release 2008c (for + DST law changes in Morocco, Iraq, Choibalsan, Pakistan, Syria, Cuba, + Argentina/San_Luis, and Chile) + + + + + + Fix incorrect result from ecpg's + PGTYPEStimestamp_sub() function (Michael) + + + + + + Fix core dump in contrib/xml2's + xpath_table() function when the input query returns a + NULL value (Tom) + + + + + + Fix contrib/xml2's makefile to not override + CFLAGS (Tom) + + + + + + Fix DatumGetBool macro to not fail with gcc + 4.3 (Tom) + + + + This problem affects old style (V0) C functions that + return boolean. The fix is already in 8.3, but the need to + back-patch it was not realized at the time. + + + + + + Fix longstanding LISTEN/NOTIFY + race condition (Tom) + + + + In rare cases a session that had just executed a + LISTEN might not get a notification, even though + one would be expected because the concurrent transaction executing + NOTIFY was observed to commit later. + + + + A side effect of the fix is that a transaction that has executed + a not-yet-committed LISTEN command will not see any + row in pg_listener for the LISTEN, + should it choose to look; formerly it would have. This behavior + was never documented one way or the other, but it is possible that + some applications depend on the old behavior. + + - - - Remove the <<, >>, - &<, and &> operators from - /contrib/cube - - - These operators were not useful. - - + + + Fix rare crash when an error occurs during a query using a hash index + (Heikki) + + - - - Improve /contrib/btree_gist (Janko Richter) - - + + + Fix input of datetime values for February 29 in years BC (Tom) + - - - Improve /contrib/pgbench (Tomoaki Sato, Tatsuo) - - - There is now a facility for testing with SQL command scripts given - by the user, instead of only a hard-wired command sequence. - - + + The former coding was mistaken about which years were leap years. + + - - - Improve /contrib/pgcrypto (Marko Kreen) - + + + Fix unrecognized node type error in some variants of + ALTER OWNER (Tom) + + - + + + Fix pg_ctl to correctly extract the postmaster's port + number from command-line options (Itagaki Takahiro, Tom) + - - - Implementation of OpenPGP symmetric-key and public-key encryption - - - Both RSA and Elgamal public-key algorithms are supported. - - + + Previously, pg_ctl start -w could try to contact the + postmaster on the wrong port, leading to bogus reports of startup + failure. + + - - - Stand alone build: include SHA256/384/512 hashes, Fortuna PRNG - - + + + Use - - - OpenSSL build: support 3DES, use internal AES with OpenSSL < 0.9.7 - - + + This is known to be necessary when building PostgreSQL + with gcc 4.3 or later. + + - - - Take build parameters (OpenSSL, zlib) from configure result - - - There is no need to edit the Makefile anymore. - - + + + Fix display of constant expressions in ORDER BY + and GROUP BY (Tom) + - - - Remove support for libmhash and libmcrypt - - + + An explictly casted constant would be shown incorrectly. This could + for example lead to corruption of a view definition during + dump and reload. + + - - + + + Fix libpq to handle NOTICE messages correctly + during COPY OUT (Tom) + - - + + This failure has only been observed to occur when a user-defined + datatype's output routine issues a NOTICE, but there is no + guarantee it couldn't happen due to other causes. + + + + @@ -14047,6 +15094,151 @@ typedefs (Michael) + + Release 7.4.20 + + + Release date + 2008-06-09 + + + + This release contains a variety of fixes from 7.4.19. + For information about new features in the 7.4 major release, see + . + + + + Migration to Version 7.4.20 + + + 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 + + + + + + Fix conversions between ISO-8859-5 and other encodings to handle + Cyrillic Yo characters (e and E with + two dots) (Sergey Burladyan) + + + + + + Fix a few datatype input functions + that were allowing unused bytes in their results to contain + uninitialized, unpredictable values (Tom) + + + + This could lead to failures in which two apparently identical literal + values were not seen as equal, resulting in the parser complaining + about unmatched ORDER BY and DISTINCT + expressions. + + + + + + Fix a corner case in regular-expression substring matching + (substring(string from + pattern)) (Tom) + + + + The problem occurs when there is a match to the pattern overall but + the user has specified a parenthesized subexpression and that + subexpression hasn't got a match. An example is + substring('foo' from 'foo(bar)?'). + This should return NULL, since (bar) isn't matched, but + it was mistakenly returning the whole-pattern match instead (ie, + foo). + + + + + + Fix incorrect result from ecpg's + PGTYPEStimestamp_sub() function (Michael) + + + + + + Fix DatumGetBool macro to not fail with gcc + 4.3 (Tom) + + + + This problem affects old style (V0) C functions that + return boolean. The fix is already in 8.3, but the need to + back-patch it was not realized at the time. + + + + + + Fix longstanding LISTEN/NOTIFY + race condition (Tom) + + + + In rare cases a session that had just executed a + LISTEN might not get a notification, even though + one would be expected because the concurrent transaction executing + NOTIFY was observed to commit later. + + + + A side effect of the fix is that a transaction that has executed + a not-yet-committed LISTEN command will not see any + row in pg_listener for the LISTEN, + should it choose to look; formerly it would have. This behavior + was never documented one way or the other, but it is possible that + some applications depend on the old behavior. + + + + + + Fix display of constant expressions in ORDER BY + and GROUP BY (Tom) + + + + An explictly casted constant would be shown incorrectly. This could + for example lead to corruption of a view definition during + dump and reload. + + + + + + Fix libpq to handle NOTICE messages correctly + during COPY OUT (Tom) + + + + This failure has only been observed to occur when a user-defined + datatype's output routine issues a NOTICE, but there is no + guarantee it couldn't happen due to other causes. + + + + + + + + Release 7.4.19 -- 2.39.5