From 0995cefa74510ee0e38d1bf095b2eef2c1ea37c4 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 14 Jun 2019 16:56:49 -0400 Subject: [PATCH] First-draft release notes for 11.4. As usual, the release notes for other branches will be made by cutting these down, but put them up for community review first. --- doc/src/sgml/release-11.sgml | 528 +++++++++++++++++++++++++++++++++++ 1 file changed, 528 insertions(+) diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml index 9c06e1e3f5..362d68465f 100644 --- a/doc/src/sgml/release-11.sgml +++ b/doc/src/sgml/release-11.sgml @@ -1,6 +1,534 @@ + + Release 11.4 + + + Release date: + 2019-06-20 + + + + This release contains a variety of fixes from 11.3. + For information about new features in major release 11, see + . + + + + Migration to Version 11.4 + + + A dump/restore is not required for those running 11.X. + + + + However, if you are upgrading from a version earlier than 11.1, + see . + + + + + Changes + + + + + + + Fix assorted errors in run-time partition pruning logic + (Tom Lane, Amit Langote, David Rowley) + + + + These mistakes could lead to wrong answers in queries on partitioned + tables, if the comparison value used for pruning is dynamically + determined, or if multiple range-partitioned columns are involved in + pruning decisions, or if stable (not immutable) comparison operators + are involved. + + + + + + + Fix possible crash while trying to copy trigger definitions to a new + partition (Tom Lane) + + + + + + + Fix failure of ALTER TABLE ... ALTER COLUMN TYPE + when the table has a partial exclusion constraint (Tom Lane) + + + + + + + Fix failure of COMMENT command for comments on + domain constraints (Daniel Gustafsson, Michael Paquier) + + + + + + + Prevent possible memory clobber when there are duplicate columns in a + hash aggregate's hash key list (Andrew Gierth) + + + + + + + Fix incorrect argument null-ness checking during partial aggregation + of aggregates with zero or multiple arguments (David Rowley, Kyotaro + Horiguchi, Andres Freund) + + + + + + + Avoid spurious deadlock failures when upgrading a tuple lock (Oleksii + Kliukin) + + + + + + + Fix faulty generation of merge-append plans (Tom Lane) + + + + This mistake could lead to could not find pathkey item to + sort errors. + + + + + + + Fix incorrect printing of queries with duplicate join names + (Philip Dubé) + + + + This oversight caused a dump/restore failure for views containing + such queries. + + + + + + + Fix conversion of JSON string literals to JSON-type output columns + in json_to_record() + and json_populate_record() (Tom Lane) + + + + Such cases should produce the literal as a standalone JSON value, but + the code misbehaved if the literal contained any characters requiring + escaping. + + + + + + + Fix misoptimization of {1,1} quantifiers in + regular expressions (Tom Lane) + + + + Such quantifiers were treated as no-ops and optimized away; + but the documentation specifies that they impose greediness, or + non-greediness in the case of the non-greedy + variant {1,1}?, on the subexpression they're + attached to, and this did not happen. The misbehavior occurred + only if the subexpression contained capturing parentheses or a + back-reference. + + + + + + + Avoid corruption of a btree index in the unlikely case that a failure + occurs during key truncation during a page split (Peter Geoghegan) + + + + + + + Avoid possible failures while initializing a new + process's pg_stat_activity data (Tom Lane) + + + + Certain operations that could fail, such as converting strings + extracted from an SSL certificate into the database encoding, were + being performed inside a critical section. Failure there would + result in database-wide lockup due to violating the access protocol + for shared pg_stat_activity data. + + + + + + + Fix race condition in check to see whether a pre-existing shared + memory segment is still in use by a conflicting postmaster (Tom Lane) + + + + + + + Fix unsafe coding in walreceiver's signal handler (Tom Lane) + + + + This avoids rare problems in which the walreceiver process would + crash or deadlock when commanded to shut down. + + + + + + + Avoid attempting to do database accesses for parameter checking in + processes that are not connected to a specific database (Vignesh C, + Andres Freund) + + + + This error could result in failures like cannot read pg_class + without having selected a database. + + + + + + + Avoid possible hang in libpq if using SSL + and OpenSSL's pending-data buffer contains an exact multiple of 256 + bytes (David Binderman) + + + + + + + Make initdb determine the operating + system's time zone from the /etc/localtime + symbolic link, if that exists (Tom Lane) + + + + This makes initdb more likely to select + the desired time zone string when multiple identical time zones + exist. + + + + + + + Fix ordering of GRANT commands emitted + by pg_dump + and pg_dumpall for databases and + tablespaces (Nathan Bossart, Michael Paquier) + + + + If cascading grants had been issued, restore might fail due to + the GRANT commands being given in an order that + didn't respect their interdependencies. + + + + + + + Make pg_dump recreate table partitions + using CREATE TABLE then ATTACH + PARTITION, rather than including PARTITION + OF in the creation command (Álvaro Herrera, David + Rowley) + + + + This avoids problems with the partition's column order possibly being + changed to match the parent's. Also, a partition is now restorable + from the dump (as a standalone table) even if its parent table isn't + restored; the ATTACH will fail, but that can just + be ignored. + + + + + + + Fix misleading error reports + from reindexdb (Julien Rouhaud) + + + + + + + Ensure that vacuumdb returns correct + status if an error occurs while using parallel jobs + (Julien Rouhaud) + + + + + + + Fix contrib/auto_explain to not cause problems + in parallel queries (Tom Lane) + + + + Previously, a parallel worker might try to log its query even if the + parent query were not being logged + by auto_explain. This would work sometimes, but + it's confusing, and in some cases it resulted in failures + like could not find key N in shm TOC. + + + + Also, fix an off-by-one error that resulted in not necessarily + logging every query even when the sampling rate is set to 1.0. + + + + + + + In contrib/postgres_fdw, account for possible + data modifications by local BEFORE ROW UPDATE + triggers (Shohei Mochizuki) + + + + If a trigger modified a column that was otherwise not changed by the + UPDATE, the new value was not transmitted to the + remote server. + + + + + + + On Windows, avoid failure when the database encoding is set to + SQL_ASCII and we attempt to log a non-ASCII string (Noah Misch) + + + + The code had been assuming that such strings must be in UTF-8, and + would throw an error if they didn't appear to be validly encoded. + Now, just transmit the untranslated bytes to the log. + + + + + + + Make PL/pgSQL's header files C++-safe + (George Tarasov) + + + + + + + + Release 11.3 -- 2.40.0