aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2020-02-09 14:14:18 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2020-02-09 14:14:18 -0500
commit3c5036dba8f145b42edb28cfa49d7fe0d612aad1 (patch)
tree865a0c19d36318e0573faf0ada4ca301d38d5782
parentf91706b00cf93414ab20c373888f74e92365566a (diff)
downloadpostgresql-3c5036dba8f145b42edb28cfa49d7fe0d612aad1.tar.gz
postgresql-3c5036dba8f145b42edb28cfa49d7fe0d612aad1.zip
Release notes for 12.2, 11.7, 10.12, 9.6.17, 9.5.21, 9.4.26.
-rw-r--r--doc/src/sgml/release-11.sgml1152
1 files changed, 1152 insertions, 0 deletions
diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml
index 6be615f04a3..6785fbb0ad3 100644
--- a/doc/src/sgml/release-11.sgml
+++ b/doc/src/sgml/release-11.sgml
@@ -1,6 +1,1158 @@
<!-- doc/src/sgml/release-11.sgml -->
<!-- See header comment in release.sgml about typical markup -->
+ <sect1 id="release-11-7">
+ <title>Release 11.7</title>
+
+ <formalpara>
+ <title>Release date:</title>
+ <para>2020-02-13</para>
+ </formalpara>
+
+ <para>
+ This release contains a variety of fixes from 11.6.
+ For information about new features in major release 11, see
+ <xref linkend="release-11"/>.
+ </para>
+
+ <sect2>
+ <title>Migration to Version 11.7</title>
+
+ <para>
+ A dump/restore is not required for those running 11.X.
+ </para>
+
+ <para>
+ However, if you are upgrading from a version earlier than 11.6,
+ see <xref linkend="release-11-6"/>.
+ </para>
+ </sect2>
+
+ <sect2>
+ <title>Changes</title>
+
+ <itemizedlist>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [1fa846f1c] 2020-01-02 17:04:24 -0300
+Branch: REL_12_STABLE [d73214839] 2020-01-02 17:04:24 -0300
+Branch: REL_11_STABLE [adc9cb6f2] 2020-01-02 17:04:24 -0300
+-->
+ <para>
+ Ensure that row triggers on partitioned tables are correctly
+ cloned to sub-partitions when appropriate
+ (&Aacute;lvaro Herrera)
+ </para>
+
+ <para>
+ User-defined triggers (but not triggers for foreign key or deferred
+ unique constraints) might be missed when creating or attaching a
+ partition.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Peter Eisentraut <peter@eisentraut.org>
+Branch: master [b9c130a1f] 2020-01-06 08:40:00 +0100
+Branch: REL_12_STABLE [8c2bfd9f9] 2020-01-06 10:43:55 +0100
+Branch: REL_11_STABLE [7474393e0] 2020-01-06 11:38:24 +0100
+Branch: REL_10_STABLE [66fd0adc7] 2020-01-06 11:38:33 +0100
+-->
+ <para>
+ Fix logical replication subscriber code to execute
+ per-column <literal>UPDATE</literal> triggers when appropriate
+ (Peter Eisentraut)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Amit Kapila <akapila@postgresql.org>
+Branch: master [d20703805] 2020-01-02 11:41:04 +0530
+Branch: REL_12_STABLE [f8a6d8e71] 2020-01-02 11:53:53 +0530
+Branch: REL_11_STABLE [3e3a79735] 2020-01-02 12:04:13 +0530
+Branch: REL_10_STABLE [27b5f48c7] 2020-01-02 12:11:55 +0530
+Branch: REL9_6_STABLE [ba5b4e506] 2020-01-02 11:29:50 +0530
+Branch: REL9_5_STABLE [a6f4f407a] 2020-01-02 12:28:02 +0530
+Branch: REL9_4_STABLE [1ad47e875] 2020-01-02 12:38:29 +0530
+Branch: master [ed7bb5c31] 2020-01-14 07:53:50 +0530
+Branch: REL_12_STABLE [fa1eaebfa] 2020-01-14 08:05:05 +0530
+Branch: REL_11_STABLE [17869eca7] 2020-01-14 08:12:12 +0530
+Branch: REL_10_STABLE [f9e95252a] 2020-01-14 08:20:11 +0530
+-->
+ <para>
+ Avoid failure in logical decoding when a large transaction must be
+ spilled into many separate temporary files (Amit Khandekar)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [4d9ceb001] 2019-11-22 11:31:19 -0500
+Branch: REL_12_STABLE [a2aa224e0] 2019-11-22 11:31:19 -0500
+Branch: REL_11_STABLE [b72a44c51] 2019-11-22 11:31:19 -0500
+Branch: REL_10_STABLE [5d3fcb53a] 2019-11-22 11:31:19 -0500
+-->
+ <para>
+ Fix possible crash or data corruption when a logical replication
+ subscriber processes a row update (Tom Lane, Tomas Vondra)
+ </para>
+
+ <para>
+ This bug caused visible problems only if the subscriber's table
+ contained columns that were not being copied from the publisher and
+ had pass-by-reference data types.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Amit Kapila <akapila@postgresql.org>
+Branch: master [04c8a69c0] 2019-12-18 07:49:18 +0530
+Branch: REL_12_STABLE [c74111d8b] 2019-12-18 07:57:01 +0530
+Branch: REL_11_STABLE [046830164] 2019-12-18 08:16:31 +0530
+Branch: REL_10_STABLE [d6eca4958] 2019-12-18 08:27:41 +0530
+-->
+ <para>
+ Fix crash in logical replication subscriber after DDL changes on a
+ subscribed relation (Jehan-Guillaume de Rorthais, Vignesh C)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [15cac3a52] 2020-01-17 18:00:39 -0300
+Branch: REL_12_STABLE [bc2140627] 2020-01-17 18:00:39 -0300
+Branch: REL_11_STABLE [fe955ebee] 2020-01-17 18:00:39 -0300
+Branch: REL_10_STABLE [e3154aae3] 2020-01-17 18:00:39 -0300
+Branch: REL9_6_STABLE [cdb14154b] 2020-01-17 18:00:39 -0300
+Branch: REL9_5_STABLE [58997ace5] 2020-01-17 18:00:39 -0300
+Branch: REL9_4_STABLE [20a1dc1e3] 2020-01-17 18:00:39 -0300
+-->
+ <para>
+ Fix failure in logical replication publisher after a database crash
+ and restart (Vignesh C)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [b0afdcad2] 2020-01-30 11:14:02 +0900
+Branch: REL_12_STABLE [3228512b7] 2020-01-30 11:15:28 +0900
+Branch: REL_11_STABLE [374464c3e] 2020-01-30 11:15:35 +0900
+Branch: master [7ca8c9706] 2020-01-31 13:57:56 +0900
+Branch: REL_12_STABLE [706ad6a4d] 2020-01-31 13:58:05 +0900
+Branch: REL_11_STABLE [8b29c75f6] 2020-01-31 13:58:11 +0900
+-->
+ <para>
+ Ensure that the effect
+ of <function>pg_replication_slot_advance()</function> on a physical
+ replication slot will persist across restarts (Alexey Kondratov,
+ Michael Paquier)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [1c7a0b387] 2020-02-03 18:59:12 -0300
+Branch: REL_12_STABLE [42e3187a8] 2020-02-03 18:59:12 -0300
+Branch: REL_11_STABLE [beefab654] 2020-02-03 18:59:12 -0300
+Branch: REL_10_STABLE [380bc8829] 2020-02-03 18:59:12 -0300
+-->
+ <para>
+ Improve efficiency of logical replication with <literal>REPLICA
+ IDENTITY FULL</literal> (Konstantin Knizhnik)
+ </para>
+
+ <para>
+ When searching for an existing tuple during an update or delete
+ operation, return the first matching tuple not the last one.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Thomas Munro <tmunro@postgresql.org>
+Branch: master [76cbfcdf3] 2019-11-16 10:11:30 +1300
+Branch: REL_12_STABLE [24897e1a1] 2019-11-16 10:18:45 +1300
+Branch: REL_11_STABLE [bc049d0d4] 2019-11-16 10:19:16 +1300
+-->
+ <para>
+ Ensure parallel plans are always shut down at the correct time
+ (Kyotaro Horiguchi)
+ </para>
+
+ <para>
+ This oversight is known to result in <quote>temporary file
+ leak</quote> warnings from multi-batch parallel hash joins.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Amit Kapila <akapila@postgresql.org>
+Branch: master [080313f82] 2019-11-26 08:30:24 +0530
+Branch: REL_12_STABLE [1cc3a90c7] 2019-11-26 08:55:06 +0530
+Branch: REL_11_STABLE [d0ccfa9d6] 2019-11-26 09:07:35 +0530
+Branch: REL_10_STABLE [f7ae68aac] 2019-11-26 09:23:45 +0530
+Branch: REL9_6_STABLE [1ad0df67c] 2019-11-26 09:41:41 +0530
+-->
+ <para>
+ Prevent premature shutdown of a Gather or GatherMerge plan node that
+ is underneath a Limit node (Amit Kapila)
+ </para>
+
+ <para>
+ This avoids failure if such a plan node needs to be scanned more
+ than once, as for instance if it is on the inside of a nestloop.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Thomas Munro <tmunro@postgresql.org>
+Branch: master [3e4818e9d] 2020-01-27 15:07:03 +1300
+Branch: REL_12_STABLE [f9d0be241] 2020-01-27 14:11:24 +1300
+Branch: REL_11_STABLE [6a9fc75d0] 2020-01-27 14:12:18 +1300
+-->
+ <para>
+ Improve efficiency of parallel hash join on CPUs with many cores
+ (Gang Deng, Thomas Munro)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Thomas Munro <tmunro@postgresql.org>
+Branch: master [74618e77b] 2020-01-31 10:25:34 +1300
+Branch: REL_12_STABLE [1fcf62e0b] 2020-01-31 10:27:53 +1300
+Branch: REL_11_STABLE [2c56b3ac4] 2020-01-31 11:12:21 +1300
+Branch: master [d9fe702a2] 2020-02-05 12:27:00 +1300
+Branch: REL_12_STABLE [2e2351bd6] 2020-02-05 12:28:33 +1300
+Branch: REL_11_STABLE [c4a2041a4] 2020-02-05 12:30:06 +1300
+-->
+ <para>
+ Avoid crash in parallel <command>CREATE INDEX</command> when there
+ are no free dynamic shared memory slots (Thomas Munro)
+ </para>
+
+ <para>
+ Fall back to a non-parallel index build, instead.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Thomas Munro <tmunro@postgresql.org>
+Branch: master [93745f1e0] 2020-02-01 14:29:13 +1300
+Branch: REL_12_STABLE [24dd34af1] 2020-02-01 14:49:57 +1300
+Branch: REL_11_STABLE [600387f5d] 2020-02-01 22:57:46 +1300
+Branch: REL_10_STABLE [aab30cd4e] 2020-02-01 14:54:48 +1300
+Branch: REL9_6_STABLE [93be45245] 2020-02-01 14:57:40 +1300
+Branch: REL9_5_STABLE [a5f45c3dd] 2020-02-01 14:59:58 +1300
+Branch: REL9_4_STABLE [95936c795] 2020-02-01 15:10:20 +1300
+-->
+ <para>
+ Avoid memory leak when there are no free dynamic shared memory slots
+ (Thomas Munro)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [a904abe2e] 2020-01-22 09:49:18 +0900
+Branch: REL_12_STABLE [817a1b88a] 2020-01-22 09:49:24 +0900
+Branch: REL_11_STABLE [5b4b07fa9] 2020-01-22 09:49:28 +0900
+Branch: REL_10_STABLE [9055344b4] 2020-01-22 09:49:33 +0900
+Branch: REL9_6_STABLE [ef33edeb5] 2020-01-22 09:49:39 +0900
+Branch: REL9_5_STABLE [c39f45598] 2020-01-22 09:49:44 +0900
+Branch: REL9_4_STABLE [d76652edc] 2020-01-22 09:49:48 +0900
+-->
+ <para>
+ Ignore the <literal>CONCURRENTLY</literal> option when performing an
+ index creation, drop, or rebuild on a temporary table (Michael
+ Paquier, Heikki Linnakangas, Andres Freund)
+ </para>
+
+ <para>
+ This avoids strange failures if the temporary table has
+ an <literal>ON COMMIT</literal> action. There is no benefit in
+ using <literal>CONCURRENTLY</literal> for a temporary table anyway,
+ since other sessions cannot access the table, making the extra
+ processing pointless.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [c35b714ca] 2019-12-01 13:09:26 -0500
+Branch: REL_12_STABLE [b154d70f7] 2019-12-01 13:09:26 -0500
+Branch: REL_11_STABLE [768a401e2] 2019-12-01 13:09:26 -0500
+Branch: REL_10_STABLE [25c7183c0] 2019-12-01 13:09:27 -0500
+Branch: REL9_6_STABLE [283f095d0] 2019-12-01 13:09:27 -0500
+Branch: REL9_5_STABLE [cfffa8a6b] 2019-12-01 13:09:27 -0500
+Branch: REL9_4_STABLE [0c84e992c] 2019-12-01 13:09:27 -0500
+-->
+ <para>
+ Fix possible failure when resetting expression indexes on temporary
+ tables that are marked <literal>ON COMMIT DELETE ROWS</literal>
+ (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
+Branch: master [4c8701098] 2020-01-20 10:36:35 +0200
+Branch: REL_12_STABLE [fd436bba0] 2020-01-20 10:36:45 +0200
+Branch: REL_11_STABLE [da7abcf0f] 2020-01-20 10:36:47 +0200
+Branch: REL_10_STABLE [ff0c567cb] 2020-01-20 10:36:50 +0200
+Branch: REL9_6_STABLE [e96f30d89] 2020-01-20 10:36:52 +0200
+Branch: REL9_5_STABLE [98f0d2837] 2020-01-20 10:36:55 +0200
+-->
+ <para>
+ Fix possible crash in BRIN index operations
+ with <type>box</type>, <type>range</type> and <type>inet</type> data
+ types (Heikki Linnakangas)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alexander Korotkov <akorotkov@postgresql.org>
+Branch: master [b10714080] 2019-11-20 00:12:33 +0300
+Branch: REL_12_STABLE [a64e7e05a] 2019-11-20 00:17:58 +0300
+Branch: REL_11_STABLE [7d467dee0] 2019-11-20 00:18:02 +0300
+Branch: master [e14641197] 2019-11-20 00:04:09 +0300
+Branch: REL_12_STABLE [051c50c01] 2019-11-20 00:04:53 +0300
+Branch: REL_11_STABLE [9f2927989] 2019-11-20 00:05:12 +0300
+Branch: REL_10_STABLE [21ad61ab3] 2019-11-20 00:05:35 +0300
+Branch: master [d5ad7a09a] 2019-11-20 00:04:22 +0300
+Branch: REL_12_STABLE [ee437ca74] 2019-11-20 00:05:01 +0300
+Branch: REL_11_STABLE [c0bf35421] 2019-11-20 00:05:21 +0300
+Branch: REL_10_STABLE [ab64b474d] 2019-11-20 00:05:42 +0300
+Branch: REL9_6_STABLE [99f5888d3] 2019-11-19 23:47:29 +0300
+Branch: REL9_5_STABLE [4fc485684] 2019-11-20 00:01:55 +0300
+Branch: REL9_4_STABLE [1414821e1] 2019-11-20 00:03:04 +0300
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [4093ff573] 2020-02-09 12:02:57 -0500
+Branch: REL_12_STABLE [baf487123] 2020-02-09 12:02:57 -0500
+Branch: REL_11_STABLE [f91706b00] 2020-02-09 12:02:57 -0500
+-->
+ <para>
+ Fix handling of deleted pages in GIN indexes (Alexander Korotkov)
+ </para>
+
+ <para>
+ Avoid possible deadlocks, incorrect updates of a deleted page's
+ state, and failure to traverse through a recently-deleted page.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [41c6f9db2] 2020-01-17 16:17:31 -0500
+Branch: REL_12_STABLE [2e2646060] 2020-01-17 16:17:32 -0500
+Branch: REL_11_STABLE [d8e877b86] 2020-01-17 16:17:33 -0500
+Branch: REL_10_STABLE [167fd022f] 2020-01-17 16:17:35 -0500
+Branch: REL9_6_STABLE [45f03cfa5] 2020-01-17 16:17:36 -0500
+Branch: REL9_5_STABLE [396472278] 2020-01-17 16:17:37 -0500
+Branch: REL9_4_STABLE [eb9d1f050] 2020-01-17 16:17:39 -0500
+-->
+ <para>
+ Fix possible crash with a SubPlan (sub-<literal>SELECT</literal>)
+ within a multi-row <literal>VALUES</literal> list (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andrew Gierth <rhodiumtoad@postgresql.org>
+Branch: master [bf6cc19e3] 2020-02-05 20:21:20 +0000
+Branch: REL_12_STABLE [0e37489ed] 2020-02-05 20:08:11 +0000
+Branch: REL_11_STABLE [d8f1c03a4] 2020-02-05 20:15:13 +0000
+-->
+ <para>
+ Fix failure to insert default values for <quote>missing</quote>
+ attributes during tuple conversion (Vik Fearing, Andrew Gierth)
+ </para>
+
+ <para>
+ This could result in values incorrectly reading as NULL, when
+ they come from columns that had been added by <literal>ALTER
+ TABLE ADD COLUMN</literal> with a constant default.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Noah Misch <noah@leadboat.com>
+Branch: master [38fc05607] 2020-01-10 18:31:22 -0800
+Branch: REL_12_STABLE [93078e63f] 2020-01-10 18:31:25 -0800
+Branch: REL_11_STABLE [2e86e154d] 2020-01-10 18:31:26 -0800
+Branch: REL_10_STABLE [cb9774245] 2020-01-10 18:31:26 -0800
+-->
+ <para>
+ Fix crash after FileClose() failure (Noah Misch)
+ </para>
+
+ <para>
+ This issue could only be observed
+ with <varname>data_sync_retry</varname> enabled, since otherwise
+ FileClose() failure would be reported as a PANIC.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andres Freund <andres@anarazel.de>
+Branch: master [affdde2e1] 2020-01-20 23:26:51 -0800
+Branch: REL_12_STABLE [21fdfd0e8] 2020-01-20 23:29:35 -0800
+Branch: REL_11_STABLE [c8e0e560e] 2020-01-20 23:29:38 -0800
+Branch: REL_10_STABLE [8bb006a41] 2020-01-20 23:30:47 -0800
+Branch: REL9_6_STABLE [d4c339924] 2020-01-20 23:31:48 -0800
+Branch: REL9_5_STABLE [f651976d9] 2020-01-20 23:31:52 -0800
+Branch: REL9_4_STABLE [ba1dfbe22] 2020-01-20 23:32:21 -0800
+-->
+ <para>
+ Fix unlikely crash with pass-by-reference aggregate transition
+ states (Andres Freund, Teodor Sigaev)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [4c70098ff] 2020-01-23 13:42:09 -0500
+Branch: REL_12_STABLE [be13f227f] 2020-01-23 13:42:10 -0500
+Branch: REL_11_STABLE [fb12aefaa] 2020-01-23 13:42:10 -0500
+Branch: REL_10_STABLE [212b870d6] 2020-01-23 13:42:10 -0500
+Branch: REL9_6_STABLE [9e24575f6] 2020-01-23 13:42:10 -0500
+Branch: REL9_5_STABLE [a576f2a8f] 2020-01-23 13:42:10 -0500
+Branch: REL9_4_STABLE [600b953d7] 2020-01-23 13:42:10 -0500
+Branch: master [9a3a75cb8] 2020-01-23 16:15:32 -0500
+Branch: REL_12_STABLE [f309c812e] 2020-01-23 16:15:32 -0500
+Branch: REL_11_STABLE [7a9fef299] 2020-01-23 16:15:32 -0500
+Branch: REL_10_STABLE [d6a9548b2] 2020-01-23 16:15:32 -0500
+Branch: REL9_6_STABLE [451f50813] 2020-01-23 16:15:32 -0500
+Branch: REL9_5_STABLE [0e63d9641] 2020-01-23 16:15:32 -0500
+Branch: REL9_4_STABLE [8fc33e6cc] 2020-01-23 16:15:32 -0500
+-->
+ <para>
+ Improve error reporting in <function>to_date()</function>
+ and <function>to_timestamp()</function>
+ (Tom Lane, &Aacute;lvaro Herrera)
+ </para>
+
+ <para>
+ Reports about incorrect month or day names in input strings could
+ truncate the input in the middle of a multi-byte character, leading
+ to an improperly encoded error message that could cause follow-on
+ failures. Truncate at the next whitespace instead.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [1a3efa1eb] 2019-12-12 12:30:43 -0500
+Branch: REL_12_STABLE [07c4b6ac7] 2019-12-12 12:30:44 -0500
+Branch: REL_11_STABLE [332584da9] 2019-12-12 12:30:44 -0500
+Branch: REL_10_STABLE [c965c42a5] 2019-12-12 12:30:44 -0500
+Branch: REL9_6_STABLE [6e2ac8d66] 2019-12-12 12:30:44 -0500
+Branch: REL9_5_STABLE [323c47925] 2019-12-12 12:30:44 -0500
+Branch: REL9_4_STABLE [6aa126311] 2019-12-12 12:30:44 -0500
+-->
+ <para>
+ Fix off-by-one result for <literal>EXTRACT(ISOYEAR
+ FROM <replaceable>timestamp</replaceable>)</literal> for BC dates
+ (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [4a0aab14d] 2019-11-21 16:21:43 -0500
+Branch: REL_12_STABLE [5186f7625] 2019-11-21 16:21:43 -0500
+Branch: REL_11_STABLE [669138ebd] 2019-11-21 16:21:44 -0500
+Branch: REL_10_STABLE [b9f3d7a53] 2019-11-21 16:21:44 -0500
+Branch: REL9_6_STABLE [52434ba73] 2019-11-21 16:21:44 -0500
+Branch: REL9_5_STABLE [bcd541897] 2019-11-21 16:21:44 -0500
+Branch: REL9_4_STABLE [f09829017] 2019-11-21 16:21:44 -0500
+-->
+ <para>
+ Avoid stack overflow in <literal>information_schema</literal> views
+ when a self-referential view exists in the system catalogs
+ (Tom Lane)
+ </para>
+
+ <para>
+ A self-referential view can't work; it will always result in
+ infinite recursion. We handled that situation correctly when
+ trying to execute the view, but not when inquiring whether it is
+ automatically updatable.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [b175bd59f] 2020-01-07 17:38:48 -0300
+Branch: REL_12_STABLE [fce9ba819] 2020-01-07 17:38:48 -0300
+Branch: REL_11_STABLE [896db774e] 2020-01-07 17:38:48 -0300
+Branch: REL_10_STABLE [8de3b68fa] 2020-01-07 17:55:21 -0300
+Branch: master [f5d28710c] 2020-01-08 14:33:49 -0300
+Branch: REL_12_STABLE [20c4df8c8] 2020-01-08 14:33:49 -0300
+Branch: REL_11_STABLE [af43581e8] 2020-01-08 14:33:49 -0300
+Branch: REL_10_STABLE [da42b9f3f] 2020-01-08 14:33:49 -0300
+-->
+ <para>
+ Ensure that walsender processes always show NULL for transaction
+ start time in <structname>pg_stat_activity</structname>
+ (&Aacute;lvaro Herrera)
+ </para>
+
+ <para>
+ Previously, the <structfield>xact_start</structfield> column would
+ sometimes show the process start time.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Thomas Munro <tmunro@postgresql.org>
+Branch: master [e69d64454] 2019-12-24 13:05:43 +1300
+Branch: REL_12_STABLE [8052aaf52] 2019-12-24 13:07:54 +1300
+Branch: REL_11_STABLE [9e551a14c] 2019-12-24 13:09:56 +1300
+Branch: REL_10_STABLE [8e89bc6df] 2019-12-24 13:11:13 +1300
+Branch: REL9_6_STABLE [15861deb6] 2019-12-24 13:12:50 +1300
+Branch: REL9_5_STABLE [893eaf0be] 2019-12-24 13:13:13 +1300
+Branch: REL9_4_STABLE [5c0a132cf] 2019-12-24 13:13:30 +1300
+-->
+ <para>
+ Improve performance of hash joins with very large inner relations
+ (Thomas Munro)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [7d91b604d] 2020-02-04 13:07:13 -0500
+Branch: REL_12_STABLE [9a85860e1] 2020-02-04 13:07:13 -0500
+Branch: REL_11_STABLE [842a23efa] 2020-02-04 13:07:13 -0500
+-->
+ <para>
+ Fix placement of <quote>Subplans Removed</quote> field
+ in <command>EXPLAIN</command> output (Daniel Gustafsson, Tom Lane)
+ </para>
+
+ <para>
+ In non-text output formats, this field was emitted inside
+ the <quote>Plans</quote> sub-group, resulting in syntactically
+ invalid output. Attach it to the parent Append or MergeAppend plan
+ node as intended. This causes the field to change position in text
+ output format too: if there are any InitPlans attached to the same
+ plan node, <quote>Subplans Removed</quote> will now appear before
+ those.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [553d2ec27] 2019-11-26 14:41:48 -0500
+Branch: REL_12_STABLE [21a4edd12] 2019-11-26 14:41:48 -0500
+Branch: REL_11_STABLE [1d9056f56] 2019-11-26 14:41:48 -0500
+-->
+ <para>
+ Allow the planner to apply potentially-leaky tests to child-table
+ statistics, if the user can read the corresponding column of the
+ table that's actually named in the query (Dilip Kumar, Amit Langote)
+ </para>
+
+ <para>
+ This change fixes a performance problem for partitioned tables that
+ was created by the fix for CVE-2017-7484. That security fix
+ disallowed applying leaky operators to statistics for columns that
+ the current user doesn't have permission to read directly. However,
+ it's somewhat common to grant permissions only on the parent
+ partitioned table and not bother to do so on individual partitions.
+ In such cases, the user can read the column via the parent, so
+ there's no point in this security restriction; it only results in
+ poorer planner estimates than necessary.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [652686a33] 2020-01-12 14:36:59 -0500
+Branch: REL_12_STABLE [70c17a812] 2020-01-12 14:37:00 -0500
+Branch: REL_11_STABLE [5832be6ca] 2020-01-12 14:37:00 -0500
+Branch: REL_10_STABLE [8c8b456b5] 2020-01-12 14:37:00 -0500
+Branch: REL9_6_STABLE [2dd10477c] 2020-01-12 14:37:00 -0500
+Branch: REL9_5_STABLE [784c58da1] 2020-01-12 14:37:00 -0500
+Branch: REL9_4_STABLE [6bd567b65] 2020-01-12 14:37:00 -0500
+-->
+ <para>
+ Fix edge-case crashes and misestimations in selectivity calculations
+ for the <literal>&lt;@</literal> and <literal>@&gt;</literal> range
+ operators (Michael Paquier, Andrey Borodin, Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tomas Vondra <tomas.vondra@postgresql.org>
+Branch: master [d482f7f86] 2019-11-16 01:17:15 +0100
+Branch: REL_12_STABLE [28555a53c] 2019-11-16 01:25:14 +0100
+Branch: REL_11_STABLE [25a9ff6ca] 2019-11-16 01:58:38 +0100
+Branch: REL_10_STABLE [0b0f281cc] 2019-11-16 01:42:20 +0100
+-->
+ <para>
+ Ignore system columns when applying most-common-value
+ extended statistics (Tomas Vondra)
+ </para>
+
+ <para>
+ This prevents <quote>negative bitmapset member not allowed</quote>
+ planner errors for affected queries.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [168d20640] 2019-11-21 10:23:28 +0900
+Branch: REL_12_STABLE [c644407f7] 2019-11-21 10:23:38 +0900
+Branch: REL_11_STABLE [62074a343] 2019-11-21 10:23:43 +0900
+Branch: REL_10_STABLE [f4095026c] 2019-11-21 10:23:49 +0900
+-->
+ <para>
+ Fix BRIN index logic to support hypothetical BRIN indexes
+ (Julien Rouhaud, Heikki Linnakangas)
+ </para>
+
+ <para>
+ Previously, if an <quote>index adviser</quote> extension tried to
+ get the planner to produce a plan involving a hypothetical BRIN
+ index, that would fail, because the BRIN cost estimation code would
+ always try to physically access the index's metapage. Now it checks
+ to see if the index is only hypothetical, and uses default
+ assumptions about the index parameters if so.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Dean Rasheed <dean.a.rasheed@gmail.com>
+Branch: master [d751ba523] 2020-01-14 09:52:21 +0000
+Branch: REL_12_STABLE [fd5476b79] 2020-01-14 09:51:28 +0000
+Branch: REL_11_STABLE [9bdb1f0e3] 2020-01-14 09:50:51 +0000
+Branch: REL_10_STABLE [353cd826f] 2020-01-14 09:50:13 +0000
+Branch: REL9_6_STABLE [fd87262de] 2020-01-14 09:49:23 +0000
+Branch: REL9_5_STABLE [bb09a9414] 2020-01-14 09:48:44 +0000
+Branch: REL9_4_STABLE [9be6fcb3e] 2020-01-14 09:47:44 +0000
+-->
+ <para>
+ Improve error reporting for attempts to use automatic updating of
+ views with conditional <literal>INSTEAD</literal> rules (Dean Rasheed)
+ </para>
+
+ <para>
+ This has never been supported, but previously the error was thrown
+ only at execution time, so that it could be masked by planner errors.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [fc7695891] 2019-12-23 12:08:23 -0500
+Branch: REL_12_STABLE [976cb11f6] 2019-12-23 12:08:23 -0500
+Branch: REL_11_STABLE [31dfa40a8] 2019-12-23 12:08:24 -0500
+Branch: REL_10_STABLE [4af2531d0] 2019-12-23 12:08:24 -0500
+Branch: REL9_6_STABLE [354d913f9] 2019-12-23 12:08:24 -0500
+Branch: REL9_5_STABLE [6609c3ad9] 2019-12-23 12:08:24 -0500
+Branch: REL9_4_STABLE [0d245d13c] 2019-12-23 12:08:24 -0500
+Branch: master [74b35eb46] 2020-01-31 17:03:55 -0500
+Branch: REL_12_STABLE [65aa15513] 2020-01-31 17:03:55 -0500
+Branch: REL_11_STABLE [25dc267a1] 2020-01-31 17:03:55 -0500
+Branch: REL_10_STABLE [de3d2df75] 2020-01-31 17:03:55 -0500
+Branch: REL9_6_STABLE [742c646c1] 2020-01-31 17:03:55 -0500
+Branch: REL9_5_STABLE [59047b6d0] 2020-01-31 17:03:55 -0500
+Branch: REL9_4_STABLE [f521ef0ae] 2020-01-31 17:03:55 -0500
+-->
+ <para>
+ Prevent a composite type from being included in itself indirectly
+ via a range type (Tom Lane, Julien Rouhaud)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [39ebb943d] 2019-12-23 12:53:12 -0500
+Branch: REL_12_STABLE [7fbb39a96] 2019-12-23 12:53:13 -0500
+Branch: REL_11_STABLE [281dd22ac] 2019-12-23 12:53:13 -0500
+Branch: REL_10_STABLE [ea1205a02] 2019-12-23 12:53:13 -0500
+-->
+ <para>
+ Disallow partition key expressions that return pseudo-types, such
+ as <type>record</type> (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [2acab054b] 2019-12-17 17:44:27 -0500
+Branch: REL_12_STABLE [97ba30fab] 2019-12-17 17:44:28 -0500
+Branch: REL_11_STABLE [fc449abc3] 2019-12-17 17:44:28 -0500
+Branch: REL_10_STABLE [5c5a268c6] 2019-12-17 17:44:28 -0500
+Branch: REL9_6_STABLE [275a8ac4f] 2019-12-17 17:44:28 -0500
+Branch: REL9_5_STABLE [da5dd4218] 2019-12-17 17:44:28 -0500
+Branch: REL9_4_STABLE [298d056d9] 2019-12-17 17:44:28 -0500
+-->
+ <para>
+ Fix error reporting for index expressions of prohibited types
+ (Amit Langote)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [bf2efc55d] 2019-11-16 20:00:19 -0500
+Branch: REL_12_STABLE [fcaf29d87] 2019-11-16 20:00:19 -0500
+Branch: REL_11_STABLE [d898edf4f] 2019-11-16 20:00:19 -0500
+Branch: REL_10_STABLE [a1b2cf095] 2019-11-16 20:00:19 -0500
+Branch: REL9_6_STABLE [e4865bbdc] 2019-11-16 20:00:19 -0500
+Branch: REL9_5_STABLE [ecb533af6] 2019-11-16 20:00:20 -0500
+Branch: REL9_4_STABLE [65da6dd1d] 2019-11-16 20:00:20 -0500
+-->
+ <para>
+ Fix dumping of views that contain only a <literal>VALUES</literal>
+ list to handle cases where a view output column has been renamed
+ (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [2c7b5dad6] 2019-11-13 12:11:49 -0500
+Branch: REL_12_STABLE [eec569fac] 2019-11-13 12:11:49 -0500
+Branch: REL_11_STABLE [94a9cb43f] 2019-11-13 12:11:49 -0500
+Branch: REL_10_STABLE [e25c4b3b2] 2019-11-13 12:11:50 -0500
+-->
+ <para>
+ Ensure that data types and collations used
+ in <literal>XMLTABLE</literal> constructs are accounted for when
+ computing dependencies of a view or rule (Tom Lane)
+ </para>
+
+ <para>
+ Previously it was possible to break a view
+ using <literal>XMLTABLE</literal> by dropping a type, if the type
+ was not otherwise referenced in the view. This fix does not
+ correct the dependencies already recorded for existing views, only
+ for newly-created ones.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [7618eaf5f] 2019-11-13 13:41:04 -0500
+Branch: REL_12_STABLE [d9802590a] 2019-11-13 13:41:04 -0500
+Branch: REL_11_STABLE [d66e68207] 2019-11-13 13:41:04 -0500
+Branch: REL_10_STABLE [4be69e2ea] 2019-11-13 13:41:04 -0500
+-->
+ <para>
+ Prevent unwanted downcasing and truncation of RADIUS authentication
+ parameters (Marcos David)
+ </para>
+
+ <para>
+ The <filename>pg_hba.conf</filename> parser mistakenly treated these
+ fields as SQL identifiers, which in general they aren't.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [790026972] 2019-11-24 14:42:59 -0500
+Branch: REL_12_STABLE [c47f498c9] 2019-11-24 14:42:59 -0500
+Branch: REL_11_STABLE [377d1b95b] 2019-11-24 14:42:59 -0500
+Branch: REL_10_STABLE [dbe15524b] 2019-11-24 14:42:59 -0500
+Branch: REL9_6_STABLE [111298aa6] 2019-11-24 14:42:59 -0500
+-->
+ <para>
+ Transmit incoming <command>NOTIFY</command> messages to the client
+ before sending <literal>ReadyForQuery</literal>, rather than after
+ (Tom Lane)
+ </para>
+
+ <para>
+ This change ensures that, with libpq and other client libraries that
+ act similarly to it, any notifications received during a transaction
+ will be available by the time the client thinks the transaction is
+ complete. This probably makes no difference in practical
+ applications (which would need to cope with asynchronous
+ notifications in any case); but it makes it easier to build test
+ cases with reproducible behavior.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [e60b480d3] 2019-12-20 15:34:07 -0500
+Branch: REL_12_STABLE [e8f60e6fe] 2019-12-20 15:34:07 -0500
+Branch: REL_11_STABLE [1a77ea02d] 2019-12-20 15:34:08 -0500
+Branch: REL_10_STABLE [d09cfa3e2] 2019-12-20 15:34:08 -0500
+Branch: REL9_6_STABLE [c11bd6c10] 2019-12-20 15:34:08 -0500
+Branch: REL9_5_STABLE [5e22a1111] 2019-12-20 15:34:08 -0500
+Branch: REL9_4_STABLE [875c7d70d] 2019-12-20 15:34:08 -0500
+-->
+ <para>
+ Allow <application>libpq</application> to parse all GSS-related
+ connection parameters even when the GSSAPI code hasn't been compiled
+ in (Tom Lane)
+ </para>
+
+ <para>
+ This makes the behavior similar to our SSL support, where it was
+ long ago deemed to be a good idea to always accept all the related
+ parameters, even if some are ignored or restricted due to lack of
+ the feature in a particular build.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tomas Vondra <tomas.vondra@postgresql.org>
+Branch: master [3ff660bbe] 2019-11-30 14:51:27 +0100
+Branch: REL_12_STABLE [0dafed6fe] 2019-11-30 15:04:02 +0100
+Branch: REL_11_STABLE [9668bf5d5] 2019-11-30 15:05:31 +0100
+Branch: REL_10_STABLE [f71b22f53] 2019-11-30 15:07:47 +0100
+Branch: REL9_6_STABLE [c59414da7] 2019-11-30 15:10:14 +0100
+Branch: REL9_5_STABLE [a17602de1] 2019-11-30 15:14:12 +0100
+Branch: REL9_4_STABLE [d9b974e99] 2019-11-30 15:16:58 +0100
+-->
+ <para>
+ Fix incorrect handling of <literal>%b</literal>
+ and <literal>%B</literal> format codes
+ in <application>ecpg</application>'s
+ <function>PGTYPEStimestamp_fmt_asc()</function> function
+ (Tomas Vondra)
+ </para>
+
+ <para>
+ Due to an off-by-one error, these codes would print the wrong month
+ name, or possibly crash.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [2425f8f71] 2020-01-31 14:41:49 -0500
+Branch: REL_12_STABLE [0c84199f7] 2020-01-31 14:41:49 -0500
+Branch: REL_11_STABLE [63634883f] 2020-01-31 14:41:49 -0500
+Branch: REL_10_STABLE [8b1d447a7] 2020-01-31 14:41:49 -0500
+Branch: REL9_6_STABLE [cb4c04a4e] 2020-01-31 14:41:49 -0500
+Branch: REL9_5_STABLE [1b78759a6] 2020-01-31 14:41:49 -0500
+Branch: REL9_4_STABLE [5d60df830] 2020-01-31 14:41:49 -0500
+-->
+ <para>
+ Fix
+ parallel <application>pg_dump</application>/<application>pg_restore</application>
+ to more gracefully handle failure to create worker processes
+ (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [cd23a2019] 2020-01-20 12:57:17 -0500
+Branch: REL_12_STABLE [71b121f42] 2020-01-20 12:57:17 -0500
+Branch: REL_11_STABLE [4ea5cf403] 2020-01-20 12:57:17 -0500
+Branch: REL_10_STABLE [6f6daa1be] 2020-01-20 12:57:17 -0500
+Branch: REL9_6_STABLE [208e262f9] 2020-01-20 12:57:17 -0500
+Branch: REL9_5_STABLE [b1392a950] 2020-01-20 12:57:17 -0500
+Branch: REL9_4_STABLE [42e538fe6] 2020-01-20 12:57:18 -0500
+-->
+ <para>
+ Prevent possible crash or lockup when attempting to terminate a
+ parallel <application>pg_dump</application>/<application>pg_restore</application>
+ run via a signal (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [29aeda6e4] 2019-11-13 11:35:37 -0500
+Branch: REL_12_STABLE [1cd57b05e] 2019-11-13 11:35:37 -0500
+Branch: REL_11_STABLE [8e4ef3287] 2019-11-13 11:35:37 -0500
+Branch: REL_10_STABLE [c443e3c43] 2019-11-13 11:35:37 -0500
+Branch: REL9_6_STABLE [f378d4dac] 2019-11-13 11:35:37 -0500
+Branch: REL9_5_STABLE [fb26754af] 2019-11-13 11:35:37 -0500
+Branch: REL9_4_STABLE [56c06999d] 2019-11-13 11:35:37 -0500
+-->
+ <para>
+ In <application>pg_upgrade</application>, look inside arrays and
+ ranges while searching for non-upgradable data types in tables
+ (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [4ba4bfaf2] 2019-12-26 15:19:39 -0500
+Branch: REL_12_STABLE [883c27a1c] 2019-12-26 15:19:39 -0500
+Branch: REL_11_STABLE [ee206cb83] 2019-12-26 15:19:39 -0500
+-->
+ <para>
+ Cope with changes of the specific type referenced by a PL/pgSQL
+ composite-type variable in more cases (Ashutosh Sharma, Tom Lane)
+ </para>
+
+ <para>
+ Dropping and re-creating the composite type referenced by a PL/pgSQL
+ variable could lead to <quote>could not open relation with
+ OID <replaceable>NNNN</replaceable></quote> errors.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [215824f91] 2020-01-26 14:31:08 -0500
+Branch: REL_12_STABLE [7294f99a0] 2020-01-26 14:31:08 -0500
+Branch: REL_11_STABLE [5220ced0d] 2020-01-26 14:31:08 -0500
+Branch: REL_10_STABLE [603e03b4c] 2020-01-26 14:31:08 -0500
+Branch: REL9_6_STABLE [43a648f57] 2020-01-26 14:31:08 -0500
+-->
+ <para>
+ Avoid crash in <filename>postgres_fdw</filename> when trying to
+ send a command like <literal>UPDATE remote_tab SET (x,y) = (SELECT
+ ...)</literal> to the remote server (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tomas Vondra <tomas.vondra@postgresql.org>
+Branch: master [b52739436] 2019-12-03 18:40:07 +0100
+Branch: REL_12_STABLE [a8a8c6b29] 2019-12-03 18:40:48 +0100
+Branch: REL_11_STABLE [267eb954c] 2019-12-03 18:41:29 +0100
+Branch: REL_10_STABLE [46ce37b67] 2019-12-03 18:41:50 +0100
+Branch: REL9_6_STABLE [fabdad822] 2019-12-03 18:42:25 +0100
+Branch: REL9_5_STABLE [a2fdeb786] 2019-12-03 18:42:54 +0100
+Branch: REL9_4_STABLE [44381b1af] 2019-12-03 18:43:15 +0100
+-->
+ <para>
+ In <filename>contrib/dict_int</filename>,
+ reject <varname>maxlen</varname> settings less than one
+ (Tomas Vondra)
+ </para>
+
+ <para>
+ This prevents a possible crash with silly settings for that parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Joe Conway <mail@joeconway.com>
+Branch: master [d5b9c2baf] 2019-12-23 13:33:25 -0500
+Branch: REL_12_STABLE [b5e7569dd] 2019-12-23 13:33:34 -0500
+Branch: REL_11_STABLE [f49e5efbc] 2019-12-23 13:33:42 -0500
+Branch: REL_10_STABLE [81be0c57e] 2019-12-23 13:33:50 -0500
+Branch: REL9_6_STABLE [3757c1640] 2019-12-23 13:33:57 -0500
+Branch: REL9_5_STABLE [70fc6c4ef] 2019-12-23 13:34:05 -0500
+Branch: REL9_4_STABLE [4a3cdb531] 2019-12-23 13:34:12 -0500
+-->
+ <para>
+ Disallow NULL category values
+ in <filename>contrib/tablefunc</filename>'s
+ <function>crosstab()</function> function (Joe Conway)
+ </para>
+
+ <para>
+ This case never worked usefully, and it would crash on some
+ platforms.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [7d0bcb047] 2019-12-06 15:13:55 +0900
+Branch: REL_12_STABLE [902276ff1] 2019-12-06 15:14:26 +0900
+Branch: REL_11_STABLE [7ad544fd8] 2019-12-06 15:14:31 +0900
+-->
+ <para>
+ Fix <application>configure</application>'s probe for
+ OpenSSL's <function>SSL_clear_options()</function> function so that
+ it works with OpenSSL versions before 1.1.0 (Michael Paquier, Daniel
+ Gustafsson)
+ </para>
+
+ <para>
+ This problem could lead to failure to set the SSL compression option
+ as desired, when <productname>PostgreSQL</productname> is built against
+ an old version of OpenSSL.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [62c9b5223] 2020-01-21 13:46:39 +0900
+Branch: REL_12_STABLE [ef8e6b2c2] 2020-01-21 13:46:55 +0900
+Branch: REL_11_STABLE [7c7026bb7] 2020-01-21 13:47:01 +0900
+Branch: REL_10_STABLE [1ef7332b7] 2020-01-21 13:47:05 +0900
+Branch: REL9_6_STABLE [9740cdbe5] 2020-01-21 13:47:10 +0900
+Branch: REL9_5_STABLE [4a49149b9] 2020-01-21 13:47:13 +0900
+Branch: REL9_4_STABLE [dbe405b78] 2020-01-21 13:47:17 +0900
+-->
+ <para>
+ Mark some timeout and statistics-tracking GUC variables
+ as <literal>PGDLLIMPORT</literal>, to allow extensions to access
+ them on Windows (Pascal Legrand)
+ </para>
+
+ <para>
+ This applies to
+ <literal>idle_in_transaction_session_timeout</literal>,
+ <literal>lock_timeout</literal>,
+ <literal>statement_timeout</literal>,
+ <literal>track_activities</literal>,
+ <literal>track_counts</literal>, and
+ <literal>track_functions</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tomas Vondra <tomas.vondra@postgresql.org>
+Branch: master [543852fd8] 2020-01-17 15:29:11 +0100
+Branch: REL_12_STABLE [162c951df] 2020-01-17 15:30:51 +0100
+Branch: REL_11_STABLE [8c37e4469] 2020-01-17 15:31:33 +0100
+Branch: REL_10_STABLE [a801452c9] 2020-01-17 15:32:03 +0100
+-->
+ <para>
+ Avoid memory leak in sanity checks for <quote>slab</quote> memory
+ contexts (Tomas Vondra)
+ </para>
+
+ <para>
+ This isn't an issue for production builds, since they wouldn't
+ ordinarily have memory context checking enabled; but the leak could
+ be quite severe in a debug build.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Fujii Masao <fujii@postgresql.org>
+Branch: master [3ccc66dac] 2020-02-06 14:43:21 +0900
+Branch: REL_12_STABLE [3d214a8e5] 2020-02-06 14:44:22 +0900
+Branch: REL_11_STABLE [ac25e1044] 2020-02-06 14:44:40 +0900
+Branch: REL_10_STABLE [c17abac60] 2020-02-06 14:44:59 +0900
+-->
+ <para>
+ Fix multiple statistics entries reported by the LWLock statistics
+ mechanism (Fujii Masao)
+ </para>
+
+ <para>
+ The LWLock statistics code (which is not built by default; it
+ requires compiling with <option>-DLWLOCK_STATS</option>)
+ could report multiple entries for the same LWLock and backend
+ process, as a result of faulty hashtable key creation.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [28e6a2fd6] 2019-12-09 15:03:51 -0500
+Branch: REL_12_STABLE [001362cfd] 2019-12-09 15:03:51 -0500
+Branch: REL_11_STABLE [2ed302ab9] 2019-12-09 15:03:51 -0500
+Branch: REL_10_STABLE [096ea540e] 2019-12-09 15:03:52 -0500
+Branch: REL9_6_STABLE [df44e411c] 2019-12-09 15:03:52 -0500
+Branch: REL9_5_STABLE [1a0c65120] 2019-12-09 15:03:52 -0500
+Branch: REL9_4_STABLE [7309e75fa] 2019-12-09 15:03:52 -0500
+-->
+ <para>
+ Fix race condition that led to delayed delivery of interprocess
+ signals on Windows (Amit Kapila)
+ </para>
+
+ <para>
+ This caused visible timing oddities in <command>NOTIFY</command>,
+ and perhaps other misbehavior.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [6d7547c21] 2019-12-16 15:10:55 -0500
+Branch: REL_12_STABLE [95f43fee9] 2019-12-16 15:10:55 -0500
+Branch: REL_11_STABLE [2cf51809b] 2019-12-16 15:10:55 -0500
+Branch: REL_10_STABLE [81b052c31] 2019-12-16 15:10:55 -0500
+Branch: REL9_6_STABLE [65cb25e4f] 2019-12-16 15:10:55 -0500
+Branch: REL9_5_STABLE [cd0380351] 2019-12-16 15:10:55 -0500
+Branch: REL9_4_STABLE [cfb2a4cce] 2019-12-16 15:10:56 -0500
+Branch: master [5406513e9] 2019-12-21 17:39:36 -0500
+Branch: REL_12_STABLE [90281a3a2] 2019-12-21 17:39:36 -0500
+Branch: REL_11_STABLE [b3c4e2418] 2019-12-21 17:39:36 -0500
+Branch: REL_10_STABLE [a69f5697a] 2019-12-21 17:39:36 -0500
+Branch: REL9_6_STABLE [739201b0e] 2019-12-21 17:39:36 -0500
+Branch: REL9_5_STABLE [35b28d983] 2019-12-21 17:39:37 -0500
+Branch: REL9_4_STABLE [f1a4020ef] 2019-12-21 17:39:37 -0500
+-->
+ <para>
+ On Windows, retry a few times after
+ an <literal>ERROR_ACCESS_DENIED</literal> file access failure
+ (Alexander Lakhin, Tom Lane)
+ </para>
+
+ <para>
+ This helps cope with cases where a file open attempt fails because
+ the targeted file is flagged for deletion but not yet actually gone.
+ <application>pg_ctl</application>, for example, frequently failed
+ with such an error when probing to see if the postmaster had shut
+ down yet.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </sect2>
+ </sect1>
+
<sect1 id="release-11-6">
<title>Release 11.6</title>