<!-- doc/src/sgml/release-11.sgml -->
<!-- See header comment in release.sgml about typical markup -->
+ <sect1 id="release-11-2">
+ <title>Release 11.2</title>
+
+ <formalpara>
+ <title>Release date:</title>
+ <para>2019-02-14</para>
+ </formalpara>
+
+ <para>
+ This release contains a variety of fixes from 11.1.
+ For information about new features in major release 11, see
+ <xref linkend="release-11"/>.
+ </para>
+
+ <sect2>
+ <title>Migration to Version 11.2</title>
+
+ <para>
+ A dump/restore is not required for those running 11.X.
+ </para>
+ </sect2>
+
+ <sect2>
+ <title>Changes</title>
+
+ <itemizedlist>
+
+ <listitem>
+<!--
+Author: Thomas Munro <tmunro@postgresql.org>
+Branch: master [9ccdd7f66] 2018-11-19 17:41:26 +1300
+Branch: REL_11_STABLE [6534d544c] 2018-11-19 13:37:59 +1300
+Branch: REL_10_STABLE [afbe03f65] 2018-11-19 13:40:57 +1300
+Branch: REL9_6_STABLE [b9cce9ddf] 2018-11-19 13:54:00 +1300
+Branch: REL9_5_STABLE [312435232] 2018-11-19 14:13:22 +1300
+Branch: REL9_4_STABLE [f1ff5f51d] 2018-11-19 14:26:28 +1300
+-->
+ <para>
+ By default, panic instead of retrying
+ after <function>fsync()</function> failure, to avoid possible data
+ corruption (Craig Ringer, Thomas Munro)
+ </para>
+
+ <para>
+ Some popular operating systems discard kernel data buffers when
+ unable to write them out, reporting this
+ as <function>fsync()</function> failure. If we reissue
+ the <function>fsync()</function> request it will succeed, but in
+ fact the data has been lost, so continuing risks database
+ corruption. By raising a panic condition instead, we can replay
+ from WAL, which may contain the only remaining copy of the data in
+ such a situation. While this is surely ugly and inefficient, there
+ are few alternatives, and fortunately the case happens very rarely.
+ </para>
+
+ <para>
+ A new server parameter <xref linkend="guc-data-sync-retry"/>
+ has been added to control this; if you are certain that your
+ kernel does not discard dirty data buffers in such scenarios,
+ you can set <varname>data_sync_retry</varname>
+ to <literal>on</literal> to restore the old behavior.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [527b5ed1a] 2019-02-04 19:18:49 -0500
+Branch: REL_11_STABLE [0d13dd371] 2019-02-04 19:18:50 -0500
+Branch: REL_10_STABLE [2b2427115] 2019-02-04 19:18:50 -0500
+Branch: REL9_6_STABLE [60b1d6c2a] 2019-02-04 19:18:50 -0500
+Branch: REL9_5_STABLE [ed64db588] 2019-02-04 19:18:50 -0500
+Branch: REL9_4_STABLE [bb428cb11] 2019-02-04 19:18:50 -0500
+-->
+ <para>
+ Include each major release branch's release notes in the
+ documentation for only that branch, rather than that branch and all
+ later ones (Tom Lane)
+ </para>
+
+ <para>
+ The duplication induced by the previous policy was getting out of
+ hand. Our plan is to provide a full archive of release notes on
+ the project's web site, but not duplicate it within each release.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [0ad41cf53] 2019-01-14 19:28:10 -0300
+Branch: REL_11_STABLE [74aa7e046] 2019-01-14 19:25:19 -0300
+-->
+ <para>
+ Fix handling of unique indexes with <literal>INCLUDE</literal>
+ columns on partitioned tables (Álvaro Herrera)
+ </para>
+
+ <para>
+ The uniqueness condition was not checked properly in such cases.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [705d433fd] 2018-11-08 16:22:09 -0300
+Branch: REL_11_STABLE [e0c05bf4a] 2018-11-08 16:22:09 -0300
+Branch: REL_10_STABLE [21c9e4973] 2018-11-08 16:22:09 -0300
+-->
+ <para>
+ Ensure that <literal>NOT NULL</literal> constraints of a partitioned
+ table are honored within its partitions
+ (Álvaro Herrera, Amit Langote)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [ae366aa57] 2019-01-24 00:01:32 -0300
+Branch: REL_11_STABLE [00376eaa2] 2019-01-23 23:57:46 -0300
+Branch: master [19184fcc0] 2019-01-24 11:25:29 -0300
+Branch: REL_11_STABLE [71eba8399] 2019-01-24 11:18:35 -0300
+Branch: master [efd9366dc] 2019-01-24 14:09:56 -0300
+Branch: REL_11_STABLE [1ad521099] 2019-01-24 14:09:56 -0300
+-->
+ <para>
+ Update catalog state correctly for partition table constraints when
+ detaching their partition (Amit Langote, Álvaro Herrera)
+ </para>
+
+ <para>
+ Previously, the <structname>pg_constraint</structname>.<structfield>conislocal</structfield>
+ field for such a constraint might improperly be left
+ as <literal>false</literal>, rendering it undroppable.
+ A dump/restore or pg_upgrade would cure the problem, but
+ if necessary, the catalog field can be adjusted manually.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [0464fdf07] 2019-01-21 20:08:52 -0300
+Branch: REL_11_STABLE [123cc697a] 2019-01-21 19:59:07 -0300
+-->
+ <para>
+ Create or delete foreign key enforcement triggers correctly when
+ attaching or detaching a partition in a a partitioned table that
+ has a foreign-key constraint (Amit Langote, Álvaro Herrera)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [0325d7a59] 2019-01-18 15:00:45 -0300
+Branch: REL_11_STABLE [4dff8935f] 2019-01-18 14:57:49 -0300
+-->
+ <para>
+ Avoid useless creation of duplicate foreign key constraints
+ in partitioned tables (Álvaro Herrera)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [71a05b223] 2018-12-05 13:31:51 -0300
+Branch: REL_11_STABLE [37798a8e8] 2018-12-05 13:31:55 -0300
+-->
+ <para>
+ When an index is created on a partitioned table
+ using <literal>ONLY</literal>, and there are no partitions yet, mark
+ it valid immediately (Álvaro Herrera)
+ </para>
+
+ <para>
+ Otherwise there is no way to make it become valid.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [7b14bcc06] 2018-12-20 16:42:13 -0300
+Branch: REL_11_STABLE [053ad56d2] 2018-12-20 16:42:13 -0300
+Branch: REL_10_STABLE [1c142612c] 2018-12-20 16:42:13 -0300
+Branch: master [0c2377152] 2018-12-20 10:58:22 -0300
+Branch: REL_11_STABLE [9bb2ce5ec] 2018-12-20 11:11:13 -0300
+-->
+ <para>
+ Use a safe table lock level when detaching a partition
+ (Álvaro Herrera)
+ </para>
+
+ <para>
+ The previous locking level was too weak and might allow
+ concurrent DDL on the table, with bad results.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [319a81018] 2018-11-09 10:03:22 +0900
+Branch: REL_11_STABLE [84b4a0cf6] 2018-11-09 10:03:31 +0900
+Branch: REL_10_STABLE [52ea6a820] 2018-11-09 10:03:39 +0900
+-->
+ <para>
+ Fix problems with applying <literal>ON COMMIT DROP</literal>
+ and <literal>ON COMMIT DELETE ROWS</literal> to partitioned tables
+ and tables with inheritance children (Michael Paquier)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [5c9a5513a] 2018-11-19 11:16:28 -0300
+Branch: REL_11_STABLE [a4db7fe0f] 2018-11-19 11:16:28 -0300
+Branch: REL_10_STABLE [85efd1a04] 2018-11-19 11:16:28 -0300
+-->
+ <para>
+ Disallow <command>COPY FREEZE</command> on partitioned tables
+ (David Rowley)
+ </para>
+
+ <para>
+ This should eventually be made to work, but it may require a patch
+ that's too complicated to risk back-patching.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andres Freund <andres@anarazel.de>
+Branch: master [171e0418b] 2019-02-06 01:09:32 -0800
+Branch: REL_11_STABLE [297d627e0] 2019-02-06 01:09:42 -0800
+-->
+ <para>
+ Fix possible index corruption when the indexed column has
+ a <quote>fast default</quote> (that is, it was added
+ by <literal>ALTER TABLE ADD COLUMN</literal> with a constant
+ default value specified, after the table already contained rows)
+ (Andres Freund)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andrew Dunstan <andrew@dunslane.net>
+Branch: master [3b174b1a3] 2019-01-10 15:53:45 -0500
+Branch: REL_11_STABLE [076ffbcb5] 2019-01-10 16:24:57 -0500
+Branch: master [e33884d41] 2019-01-11 17:12:54 -0500
+Branch: REL_11_STABLE [89d52b9a3] 2019-01-11 17:16:43 -0500
+-->
+ <para>
+ Correctly adjust <quote>fast default</quote> values
+ during <command>ALTER TABLE ... ALTER COLUMN TYPE</command>
+ (Andrew Dunstan)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Amit Kapila <akapila@postgresql.org>
+Branch: master [0b8bdb3c3] 2019-02-02 15:47:00 +0530
+Branch: REL_11_STABLE [904413637] 2019-02-02 08:38:26 +0530
+Branch: REL_10_STABLE [1ca33fc7b] 2019-02-02 08:46:32 +0530
+Branch: REL9_6_STABLE [073afae81] 2019-02-02 08:54:33 +0530
+Branch: REL9_5_STABLE [6a2c9c633] 2019-02-02 09:16:35 +0530
+Branch: REL9_4_STABLE [fba0a8292] 2019-02-02 15:43:58 +0530
+-->
+ <para>
+ Avoid possible deadlock when acquiring multiple buffer locks
+ (Nishant Fnu)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alexander Korotkov <akorotkov@postgresql.org>
+Branch: master [fd83c83d0] 2018-12-13 06:55:34 +0300
+Branch: REL_11_STABLE [9aa94d853] 2018-12-13 06:15:23 +0300
+Branch: REL_10_STABLE [2e3bd064e] 2018-12-13 06:22:39 +0300
+-->
+ <para>
+ Avoid deadlock between GIN vacuuming and concurrent index insertions
+ (Alexander Korotkov, Andrey Borodin and Peter Geoghegan)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alexander Korotkov <akorotkov@postgresql.org>
+Branch: master [c6ade7a8c] 2018-12-13 06:55:34 +0300
+Branch: REL_11_STABLE [225b5c9c4] 2018-12-13 06:15:23 +0300
+Branch: REL_10_STABLE [865870374] 2018-12-13 06:22:41 +0300
+Branch: REL9_6_STABLE [80d4d8d71] 2018-12-13 06:18:13 +0300
+Branch: REL9_5_STABLE [f6c44e1b5] 2018-12-13 06:31:16 +0300
+Branch: REL9_4_STABLE [19cf52e6c] 2018-12-13 06:36:54 +0300
+Branch: REL9_4_STABLE [bf0e5a73b] 2018-12-13 22:32:05 +0300
+-->
+ <para>
+ Avoid deadlock between hot-standby queries and replay of GIN index
+ page deletion (Alexander Korotkov)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Peter Eisentraut <peter@eisentraut.org>
+Branch: master [dfa774ff9] 2019-01-30 08:49:54 +0100
+Branch: REL_11_STABLE [cf25498f7] 2019-01-30 10:06:23 +0100
+Branch: REL_10_STABLE [2bac1d8c9] 2019-01-30 10:58:28 +0100
+Branch: REL9_6_STABLE [650296f8f] 2019-01-30 11:02:47 +0100
+Branch: REL9_5_STABLE [edd8278c5] 2019-01-30 11:16:27 +0100
+Branch: REL9_4_STABLE [452253eae] 2019-01-30 11:17:05 +0100
+-->
+ <para>
+ Fix possible crashes in logical replication when index expressions
+ or predicates are in use (Peter Eisentraut)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tomas Vondra <tomas.vondra@postgresql.org>
+Branch: master [f69c959df] 2018-11-28 01:43:08 +0100
+Branch: REL_11_STABLE [f8397c955] 2018-11-28 01:43:53 +0100
+Branch: REL_10_STABLE [4e7395d83] 2018-11-28 01:44:11 +0100
+Branch: REL9_6_STABLE [b86d148ae] 2018-11-28 01:44:31 +0100
+Branch: REL9_5_STABLE [77d2815e4] 2018-11-28 01:44:43 +0100
+Branch: REL9_4_STABLE [c1a5caea8] 2018-11-28 01:53:29 +0100
+-->
+ <para>
+ Avoid useless and expensive logical decoding of TOAST data during a
+ table rewrite (Tomas Vondra)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [4c703369a] 2018-11-29 09:12:19 +0900
+Branch: REL_11_STABLE [bad41764a] 2018-11-29 09:12:40 +0900
+Branch: REL_10_STABLE [04e381a19] 2018-11-29 09:12:45 +0900
+Branch: REL9_6_STABLE [8340eba6d] 2018-11-29 09:12:53 +0900
+Branch: REL9_5_STABLE [b9bdbf8c1] 2018-11-29 09:12:57 +0900
+Branch: REL9_4_STABLE [b81d08d60] 2018-11-29 09:13:04 +0900
+-->
+ <para>
+ Fix logic for stopping a subset of WAL senders when synchronous
+ replication is enabled (Paul Guo, Michael Paquier)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [eb8c9f0bc] 2019-02-01 10:35:16 +0900
+Branch: REL_11_STABLE [47412e075] 2019-02-01 10:35:40 +0900
+Branch: REL_10_STABLE [478e0069f] 2019-02-01 10:35:46 +0900
+Branch: REL9_6_STABLE [014763e97] 2019-02-01 10:35:52 +0900
+Branch: REL9_5_STABLE [90f1ba7ec] 2019-02-01 10:35:58 +0900
+Branch: REL9_4_STABLE [05d24cf7c] 2019-02-01 10:36:02 +0900
+-->
+ <para>
+ Avoid possibly including garbage in the replica identity field of a
+ tuple deletion WAL record (Stas Kelvish)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [bf491a907] 2018-12-23 16:42:22 +0900
+Branch: REL_11_STABLE [ff9c22266] 2018-12-23 16:43:47 +0900
+Branch: REL_10_STABLE [15f69279e] 2018-12-23 16:43:56 +0900
+-->
+ <para>
+ Prevent incorrect use of WAL-skipping optimization
+ during <command>COPY</command> to a view or foreign table
+ (Amit Langote, Michael Paquier)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [b981df4cc] 2018-12-24 20:24:16 +0900
+Branch: REL_11_STABLE [a016f59d5] 2018-12-24 20:25:49 +0900
+Branch: REL_10_STABLE [085757577] 2018-12-24 20:25:57 +0900
+Branch: REL9_6_STABLE [937870124] 2018-12-24 20:26:11 +0900
+Branch: REL9_5_STABLE [37126251a] 2018-12-24 20:26:20 +0900
+-->
+ <para>
+ Make the archiver prioritize WAL history files over WAL data files
+ while choosing which file to archive next (David Steele)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [0f7ec8d9c] 2018-12-12 13:49:41 -0500
+Branch: REL_11_STABLE [302d4eee9] 2018-12-12 13:49:41 -0500
+Branch: REL_10_STABLE [f9f63ed1f] 2018-12-12 13:49:41 -0500
+Branch: REL9_6_STABLE [10bad8c0f] 2018-12-12 13:49:42 -0500
+Branch: REL9_5_STABLE [6548d62a9] 2018-12-12 13:49:42 -0500
+-->
+ <para>
+ Fix possible crash in <command>UPDATE</command> with a
+ multiple <literal>SET</literal> clause using a
+ sub-<literal>SELECT</literal> as source (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [eba2ce171] 2018-11-22 15:14:01 -0500
+Branch: REL_11_STABLE [595220a3a] 2018-11-22 15:14:01 -0500
+-->
+ <para>
+ Fix crash when zero rows are fed
+ to <function>json[b]_populate_recordset()</function>
+ or <function>json[b]_to_recordset()</function> (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [0edef16d7] 2019-02-08 13:30:42 -0500
+Branch: REL_11_STABLE [8e2956734] 2019-02-08 13:30:57 -0500
+Branch: REL_10_STABLE [0d7d71b64] 2019-02-08 13:31:04 -0500
+Branch: REL9_6_STABLE [ef922faea] 2019-02-08 13:31:09 -0500
+Branch: REL9_5_STABLE [7821a4d60] 2019-02-08 13:31:15 -0500
+Branch: REL9_4_STABLE [37f3a7751] 2019-02-08 13:31:23 -0500
+-->
+ <para>
+ Avoid crash if <application>libxml2</application> returns a null
+ error message (Sergio Conde Gómez)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andres Freund <andres@anarazel.de>
+Branch: master [b23852766] 2018-11-27 10:07:03 -0800
+Branch: REL_11_STABLE [aee085bc0] 2018-11-27 10:07:43 -0800
+-->
+ <para>
+ Fix incorrect JIT tuple deforming code for tables with
+ many columns (more than approximately 800) (Andres Freund)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andrew Gierth <rhodiumtoad@postgresql.org>
+Branch: master [d16d45387] 2019-01-17 06:46:10 +0000
+Branch: REL_11_STABLE [e74d8c508] 2019-01-17 06:24:53 +0000
+Branch: REL_10_STABLE [409230a72] 2019-01-17 06:25:55 +0000
+Branch: REL9_6_STABLE [624046abe] 2019-01-17 06:26:15 +0000
+Branch: REL9_5_STABLE [91448e7dc] 2019-01-17 06:29:43 +0000
+Branch: REL9_4_STABLE [174fab993] 2019-01-17 06:35:31 +0000
+-->
+ <para>
+ Fix spurious grouping-related parser errors caused by inconsistent
+ handling of collation assignment (Andrew Gierth)
+ </para>
+
+ <para>
+ In some cases, expressions that should be considered to match
+ were not seen as matching, if they included operations on collatable
+ data types.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Peter Eisentraut <peter@eisentraut.org>
+Branch: master [cd5afd817] 2019-02-07 08:25:47 +0100
+Branch: REL_11_STABLE [004f494b5] 2019-02-07 08:25:54 +0100
+-->
+ <para>
+ Fix parsing of collation-sensitive expressions in the arguments of
+ a <command>CALL</command> statement (Peter Eisentraut)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [f26c06a40] 2018-11-09 22:04:14 -0500
+Branch: REL_11_STABLE [8e02ee788] 2018-11-09 22:04:14 -0500
+-->
+ <para>
+ Ensure proper cleanup after detecting an error in the argument list
+ of a <command>CALL</command> statement (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [68a13f28b] 2019-01-02 16:34:04 -0500
+Branch: REL_11_STABLE [099063340] 2019-01-02 16:33:48 -0500
+Branch: REL_10_STABLE [64edc788b] 2019-01-02 16:33:48 -0500
+Branch: REL9_6_STABLE [c27c3993e] 2019-01-02 16:33:48 -0500
+Branch: REL9_5_STABLE [f8b9b8097] 2019-01-02 16:33:48 -0500
+Branch: REL9_4_STABLE [d6b37cdb6] 2019-01-02 16:33:48 -0500
+-->
+ <para>
+ Check whether the comparison function
+ underlying <function>LEAST()</function>
+ or <function>GREATEST()</function> is leakproof, rather than just
+ assuming it is (Tom Lane)
+ </para>
+
+ <para>
+ Actual information leaks from btree comparison functions are
+ typically hard to provoke, but in principle they could happen.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [1db5667ba] 2019-01-11 15:54:06 -0500
+Branch: REL_11_STABLE [05eb923ea] 2019-01-11 15:54:08 -0500
+Branch: REL_10_STABLE [2977a312d] 2019-01-11 15:54:09 -0500
+Branch: REL9_6_STABLE [4f8097499] 2019-01-11 15:53:34 -0500
+-->
+ <para>
+ Fix incorrect planning of queries involving nested loops both above
+ and below a Gather plan node (Tom Lane)
+ </para>
+
+ <para>
+ If both levels of nestloop needed to pass the same variable into
+ their right-hand sides, an incorrect plan would be generated.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [34ea1ab7f] 2019-02-07 13:11:12 -0500
+Branch: REL_11_STABLE [9d6d2b213] 2019-02-07 13:11:13 -0500
+Branch: REL_10_STABLE [e3101a031] 2019-02-07 13:11:14 -0500
+Branch: REL9_6_STABLE [d468da0d6] 2019-02-07 13:11:16 -0500
+Branch: REL9_5_STABLE [1eeee6909] 2019-02-07 13:11:17 -0500
+Branch: REL9_4_STABLE [876fd37fc] 2019-02-07 13:10:46 -0500
+-->
+ <para>
+ Fix incorrect planning of queries in which a lateral reference must
+ be evaluated at a foreign table scan (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [d364e8815] 2018-12-18 11:19:38 -0500
+Branch: REL_11_STABLE [ad425aaf0] 2018-12-18 11:19:38 -0500
+Branch: REL_10_STABLE [d16567093] 2018-12-18 11:19:39 -0500
+Branch: REL9_6_STABLE [7c2bc40b8] 2018-12-18 11:19:39 -0500
+Branch: REL9_5_STABLE [72a626e68] 2018-12-18 11:19:39 -0500
+Branch: REL9_4_STABLE [ef673a32d] 2018-12-18 11:19:39 -0500
+-->
+ <para>
+ Fix corner-case underestimation of the cost of a merge join (Tom Lane)
+ </para>
+
+ <para>
+ The planner could prefer a merge join when the outer key range is
+ much smaller than the inner key range, even if there are so many
+ duplicate keys on the inner side that this is a poor choice.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [e3f005d97] 2018-11-12 11:19:04 -0500
+Branch: REL_11_STABLE [15b9d47c8] 2018-11-12 11:19:04 -0500
+Branch: REL_10_STABLE [c6b3835c7] 2018-11-12 11:19:04 -0500
+Branch: REL9_6_STABLE [fe66fc6f9] 2018-11-12 11:19:04 -0500
+Branch: REL9_5_STABLE [92dbbe90c] 2018-11-12 11:19:04 -0500
+Branch: REL9_4_STABLE [2abc87953] 2018-11-12 11:19:04 -0500
+-->
+ <para>
+ Avoid O(N^2) planning time growth when a query contains many
+ thousands of indexable clauses (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Etsuro Fujita <efujita@postgresql.org>
+Branch: master [8d8dcead1] 2019-01-21 17:12:40 +0900
+Branch: REL_11_STABLE [b10e3bba8] 2019-01-21 17:46:15 +0900
+-->
+ <para>
+ Improve planning speed for large inheritance or partitioning table
+ groups (Amit Langote, Etsuro Fujita)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [7170268ef] 2019-01-03 17:00:08 -0500
+Branch: REL_11_STABLE [fc8adddd9] 2019-01-03 17:00:08 -0500
+Branch: REL_10_STABLE [708931c2d] 2019-01-03 17:00:08 -0500
+Branch: REL9_6_STABLE [60de80cd2] 2019-01-03 17:00:08 -0500
+Branch: REL9_5_STABLE [d2557c42a] 2019-01-03 17:00:08 -0500
+Branch: REL9_4_STABLE [3010de813] 2019-01-03 17:00:08 -0500
+-->
+ <para>
+ Improve <command>ANALYZE</command>'s handling of
+ concurrently-updated rows (Jeff Janes, Tom Lane)
+ </para>
+
+ <para>
+ Previously, rows deleted by an in-progress transaction were omitted
+ from <command>ANALYZE</command>'s sample, but this has been found to
+ lead to more inconsistency than including them would do. In effect,
+ the sample now corresponds to an MVCC snapshot as
+ of <command>ANALYZE</command>'s start time.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [1e504f01d] 2018-12-27 10:16:19 +0900
+Branch: REL_11_STABLE [b30b9dce1] 2018-12-27 10:17:09 +0900
+Branch: REL_10_STABLE [d4486700b] 2018-12-27 10:17:13 +0900
+Branch: REL9_6_STABLE [285abc8df] 2018-12-27 10:17:21 +0900
+Branch: REL9_5_STABLE [0a323ae67] 2018-12-27 10:17:26 +0900
+Branch: REL9_4_STABLE [1d7007671] 2018-12-27 10:17:42 +0900
+-->
+ <para>
+ Make <command>TRUNCATE</command> ignore inheritance child tables
+ that are temporary tables of other sessions (Amit Langote, Michael
+ Paquier)
+ </para>
+
+ <para>
+ This brings <command>TRUNCATE</command> into line with the behavior
+ of other commands.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [5deadfef2] 2018-12-07 12:11:59 -0500
+Branch: REL_11_STABLE [aedd3d4db] 2018-12-07 12:12:00 -0500
+Branch: REL_10_STABLE [54f24ab76] 2018-12-07 12:12:00 -0500
+Branch: REL9_6_STABLE [078303f79] 2018-12-07 12:12:00 -0500
+Branch: REL9_5_STABLE [4d5cfb911] 2018-12-07 12:12:00 -0500
+-->
+ <para>
+ Fix <command>TRUNCATE</command> to update the statistics counters
+ for the right table (Tom Lane)
+ </para>
+
+ <para>
+ If the truncated table had a TOAST table, that table's counters were
+ reset instead.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Greg Stark <stark@mit.edu>
+Branch: master [1075dfdaf] 2018-12-19 19:38:31 -0500
+Branch: REL_11_STABLE [128ce8e1a] 2018-12-19 19:40:25 -0500
+Branch: REL_10_STABLE [9e6cd794c] 2018-12-19 19:41:06 -0500
+Branch: REL9_6_STABLE [5668afeb6] 2018-12-19 19:41:18 -0500
+-->
+ <para>
+ Process <command>ALTER TABLE ONLY ADD COLUMN IF NOT EXISTS</command>
+ correctly (Greg Stark)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [ebfe20dc7] 2019-01-25 21:14:49 -0500
+Branch: REL_11_STABLE [c0aed6959] 2019-01-25 21:14:31 -0500
+Branch: REL_10_STABLE [e8ec19cd1] 2019-01-25 21:14:31 -0500
+Branch: REL9_6_STABLE [0d5b27351] 2019-01-25 21:14:31 -0500
+Branch: REL9_5_STABLE [741ee4890] 2019-01-25 21:14:31 -0500
+Branch: REL9_4_STABLE [549d2a238] 2019-01-25 21:14:31 -0500
+-->
+ <para>
+ Allow <command>UNLISTEN</command> in hot-standby mode
+ (Shay Rojansky)
+ </para>
+
+ <para>
+ This is necessarily a no-op, because <command>LISTEN</command>
+ isn't allowed in hot-standby mode; but allowing the dummy operation
+ simplifies session-state-reset logic in clients.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [fa2952d8e] 2018-11-09 20:42:14 -0500
+Branch: REL_11_STABLE [1b55acb2c] 2018-11-09 20:42:03 -0500
+Branch: REL_10_STABLE [2d83863ea] 2018-11-09 20:42:03 -0500
+Branch: REL9_6_STABLE [d431dff1a] 2018-11-09 20:42:03 -0500
+Branch: REL9_5_STABLE [47088c599] 2018-11-09 20:42:03 -0500
+Branch: REL9_4_STABLE [277602dfe] 2018-11-09 20:42:03 -0500
+-->
+ <para>
+ Fix missing role dependencies in some schema and data type
+ permissions lists (Tom Lane)
+ </para>
+
+ <para>
+ In some cases it was possible to drop a role to which permissions
+ had been granted. This caused no immediate problem, but a
+ subsequent dump/reload or upgrade would fail, with symptoms
+ involving attempts to grant privileges to all-numeric role names.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [c5660e0aa] 2019-01-18 09:21:44 +0900
+Branch: REL_11_STABLE [3e4fdb3bc] 2019-01-18 09:21:52 +0900
+Branch: REL_10_STABLE [b15160bc7] 2019-01-18 09:21:58 +0900
+-->
+ <para>
+ Prevent use of a session's temporary schema within a two-phase
+ transaction (Michael Paquier)
+ </para>
+
+ <para>
+ Accessing a temporary table within such a transaction has been
+ forbidden for a long time, but it was still possible to cause
+ problems with other operations on temporary objects.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: master [175544093] 2019-01-21 19:34:11 -0300
+Branch: REL_11_STABLE [a7474308c] 2019-01-21 19:34:11 -0300
+Branch: REL_10_STABLE [3037b28b8] 2019-01-21 19:34:11 -0300
+Branch: REL9_6_STABLE [4aead13a7] 2019-01-21 19:34:11 -0300
+-->
+ <para>
+ Ensure relation caches are updated properly after adding or removing
+ foreign key constraints (Álvaro Herrera)
+ </para>
+
+ <para>
+ This oversight could result in existing sessions failing to enforce
+ a newly-created constraint, or continuing to enforce a dropped one.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [b13fd344c] 2018-12-17 10:34:44 +0900
+Branch: REL_11_STABLE [25b8094d3] 2018-12-17 10:36:03 +0900
+Branch: REL_10_STABLE [da13d90a5] 2018-12-17 10:36:21 +0900
+Branch: REL9_6_STABLE [d79cd555d] 2018-12-17 10:36:29 +0900
+Branch: REL9_5_STABLE [5812be7b6] 2018-12-17 10:36:34 +0900
+Branch: REL9_4_STABLE [d5d86e2cd] 2018-12-17 10:37:24 +0900
+Branch: master [67915fb8e] 2018-12-17 12:43:00 +0900
+Branch: REL_11_STABLE [e83e0988d] 2018-12-17 12:43:39 +0900
+Branch: REL_10_STABLE [91fc2a088] 2018-12-17 12:43:48 +0900
+Branch: REL9_6_STABLE [419bd6371] 2018-12-17 12:43:57 +0900
+Branch: REL9_5_STABLE [c7567e09d] 2018-12-17 12:44:02 +0900
+Branch: REL9_4_STABLE [696c68c2b] 2018-12-17 12:44:09 +0900
+-->
+ <para>
+ Ensure relation caches are updated properly after renaming
+ constraints (Amit Langote)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
+Branch: REL_10_STABLE [a6ca47cd2] 2018-12-27 16:00:39 -0300
+Branch: REL9_6_STABLE [7fc2363a6] 2018-12-27 16:00:39 -0300
+Branch: REL9_5_STABLE [a85045ccc] 2018-12-27 16:00:39 -0300
+Branch: REL9_4_STABLE [5199abaca] 2018-12-27 16:01:36 -0300
+Branch: REL_10_STABLE [3c4ca2109] 2018-12-27 16:17:40 -0300
+Branch: REL9_6_STABLE [aa2e84d2c] 2018-12-27 16:17:40 -0300
+Branch: REL9_5_STABLE [b7258a30a] 2018-12-27 16:17:40 -0300
+Branch: REL9_4_STABLE [2602838fa] 2018-12-27 16:17:40 -0300
+-->
+ <para>
+ Make autovacuum more aggressive about removing leftover temporary
+ tables, and also remove leftover temporary tables
+ during <command>DISCARD TEMP</command> (Álvaro Herrera)
+ </para>
+
+ <para>
+ This helps ensure that remnants from a crashed session are cleaned
+ up more promptly.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alexander Korotkov <akorotkov@postgresql.org>
+Branch: master [c952eae52] 2018-12-21 02:37:37 +0300
+Branch: REL_11_STABLE [8193d6407] 2018-12-21 02:37:31 +0300
+Branch: REL_10_STABLE [e36e25275] 2018-12-21 02:33:48 +0300
+Branch: REL9_6_STABLE [1b0280745] 2018-12-21 02:33:37 +0300
+-->
+ <para>
+ Fix replay of GiST index micro-vacuum operations so that concurrent
+ hot-standby queries do not see inconsistent state (Alexander
+ Korotkov)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Alexander Korotkov <akorotkov@postgresql.org>
+Branch: master [52ac6cd2d] 2018-12-13 06:55:34 +0300
+Branch: REL_11_STABLE [dd951dc34] 2018-12-13 06:39:53 +0300
+Branch: REL_10_STABLE [a0696d295] 2018-12-13 06:41:04 +0300
+Branch: REL9_6_STABLE [cd24b4eae] 2018-12-13 06:47:38 +0300
+Branch: REL9_5_STABLE [ad6ebcfcb] 2018-12-13 06:52:33 +0300
+Branch: REL9_4_STABLE [1cf175c74] 2018-12-13 06:52:26 +0300
+-->
+ <para>
+ Prevent empty GIN index pages from being reclaimed too quickly,
+ causing failures of concurrent searches
+ (Andrey Borodin, Alexander Korotkov)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [cbdb8b4c0] 2018-11-23 20:57:11 -0500
+Branch: master [452b637d4] 2018-11-23 23:49:25 -0500
+Branch: REL_11_STABLE [e473e1f2b] 2018-11-24 12:45:49 -0500
+Branch: REL_10_STABLE [c382a2b66] 2018-11-24 12:45:49 -0500
+Branch: REL9_6_STABLE [93eec1238] 2018-11-24 12:45:50 -0500
+Branch: REL9_5_STABLE [1e78603a5] 2018-11-24 12:45:50 -0500
+Branch: REL9_4_STABLE [d5231253e] 2018-11-24 12:45:50 -0500
+Branch: REL_11_STABLE [3645d3193] 2018-11-24 13:53:12 -0500
+Branch: REL_10_STABLE [745871483] 2018-11-24 13:53:12 -0500
+Branch: REL9_6_STABLE [1f99d0867] 2018-11-24 13:53:12 -0500
+Branch: REL9_5_STABLE [298510cae] 2018-11-24 13:53:12 -0500
+Branch: REL9_4_STABLE [bf9fb00dd] 2018-11-24 13:53:12 -0500
+-->
+ <para>
+ Fix edge-case failures in float-to-integer coercions (Andrew
+ Gierth, Tom Lane)
+ </para>
+
+ <para>
+ Values very slightly above the maximum valid integer value might not
+ be rejected, and then would overflow, producing the minimum valid
+ integer instead. Also, values that should round to the minimum or
+ maximum integer value might be incorrectly rejected.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Thomas Munro <tmunro@postgresql.org>
+Branch: master [257ef3cd4] 2018-11-13 17:46:28 +1300
+Branch: REL_11_STABLE [6b6c64a96] 2018-11-13 17:47:00 +1300
+-->
+ <para>
+ Fix parsing of space-separated lists of host names in
+ the <varname>ldapserver</varname> parameter
+ of <filename>pg_hba.conf</filename> LDAP authentication entries
+ (Thomas Munro)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Thomas Munro <tmunro@postgresql.org>
+Branch: master [0f9cdd7dc] 2018-11-28 14:12:30 +1300
+Branch: REL_11_STABLE [0640d9517] 2018-11-28 14:14:40 +1300
+Branch: REL_10_STABLE [96ed0b870] 2018-11-28 14:15:00 +1300
+Branch: REL9_6_STABLE [63d835066] 2018-11-28 14:20:07 +1300
+-->
+ <para>
+ When making a PAM authentication request, don't set
+ the <varname>PAM_RHOST</varname> variable if the connection is over
+ a Unix socket (Thomas Munro)
+ </para>
+
+ <para>
+ Previously that variable would be set to <literal>[local]</literal>,
+ which is at best unhelpful, since it's supposed to be a host name.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [3d360e20c] 2018-11-08 17:33:43 -0500
+Branch: REL_11_STABLE [7b08b4a8a] 2018-11-08 17:33:44 -0500
+Branch: REL_10_STABLE [c09daa910] 2018-11-08 17:33:46 -0500
+Branch: REL9_6_STABLE [041ad9a66] 2018-11-08 17:33:26 -0500
+Branch: REL9_5_STABLE [88275ac19] 2018-11-08 17:33:26 -0500
+Branch: REL9_4_STABLE [2407d4807] 2018-11-08 17:33:26 -0500
+-->
+ <para>
+ Disallow setting <varname>client_min_messages</varname> higher
+ than <literal>ERROR</literal> (Jonah Harris, Tom Lane)
+ </para>
+
+ <para>
+ Previously, it was possible to set this variable
+ to <literal>FATAL</literal> or <literal>PANIC</literal>, which had
+ the effect of suppressing transmission of ordinary error messages to
+ the client. However, that's contrary to guarantees that are given
+ in the <productname>PostgreSQL</productname> wire protocol
+ specification, and it caused some clients to become very confused.
+ In released branches, fix this by silently treating such settings as
+ meaning <literal>ERROR</literal> instead. Release 12 and later will
+ reject those alternatives altogether.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [8eb4a9312] 2019-01-21 12:07:02 -0500
+Branch: master [ee27584c4] 2019-01-21 16:17:10 -0500
+Branch: REL_11_STABLE [f305e8457] 2019-01-21 23:18:58 -0500
+Branch: REL_10_STABLE [6106f9dd7] 2019-01-21 23:18:58 -0500
+Branch: REL9_6_STABLE [eb3e90cad] 2019-01-21 23:18:58 -0500
+Branch: REL9_5_STABLE [844d91fd6] 2019-01-21 23:18:58 -0500
+Branch: REL9_4_STABLE [c9ff6cbfc] 2019-01-21 23:18:58 -0500
+Branch: master [2cf91ccb7] 2019-01-23 22:46:45 -0500
+Branch: REL_11_STABLE [b620cf2d4] 2019-01-23 22:46:57 -0500
+Branch: REL_10_STABLE [dd815a94c] 2019-01-23 22:47:03 -0500
+Branch: REL9_6_STABLE [1d334ab6e] 2019-01-23 22:47:13 -0500
+Branch: REL9_5_STABLE [7ac0e71aa] 2019-01-23 22:47:18 -0500
+Branch: REL9_4_STABLE [773f59440] 2019-01-23 22:47:23 -0500
+-->
+ <para>
+ Fix <application>ecpglib</application> to
+ use <function>uselocale()</function>
+ or <function>_configthreadlocale()</function> in preference
+ to <function>setlocale()</function> (Michael Meskes, Tom Lane)
+ </para>
+
+ <para>
+ Since <function>setlocale()</function> is not thread-local, and
+ might not even be thread-safe, the previous coding caused problems
+ in multi-threaded <application>ecpg</application> applications.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [ecfd55795] 2018-11-13 15:46:08 -0500
+Branch: REL_11_STABLE [68393f3fd] 2018-11-13 15:46:08 -0500
+Branch: REL_10_STABLE [32060f678] 2018-11-13 15:46:08 -0500
+Branch: REL9_6_STABLE [e1f259012] 2018-11-13 15:46:08 -0500
+Branch: REL9_5_STABLE [be38945c6] 2018-11-13 15:46:08 -0500
+Branch: REL9_4_STABLE [9e5e3861c] 2018-11-13 15:46:08 -0500
+Branch: master [06c723447] 2018-11-14 11:27:47 -0500
+Branch: REL_11_STABLE [4618fdd67] 2018-11-14 11:27:30 -0500
+Branch: REL_10_STABLE [2e8ed4659] 2018-11-14 11:27:30 -0500
+Branch: REL9_6_STABLE [f9e25ba14] 2018-11-14 11:27:31 -0500
+Branch: REL9_5_STABLE [68f30638a] 2018-11-14 11:27:31 -0500
+Branch: REL9_4_STABLE [41609776f] 2018-11-14 11:27:31 -0500
+-->
+ <para>
+ Fix incorrect results for numeric data passed through
+ an <application>ecpg</application> <acronym>SQLDA</acronym>
+ (SQL Descriptor Area) (Daisuke Higuchi)
+ </para>
+
+ <para>
+ Values with leading zeroes were not copied correctly.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [6d3ede5f1] 2019-01-26 14:15:42 -0500
+Branch: REL_11_STABLE [2c50c9f23] 2019-01-26 14:15:42 -0500
+Branch: REL_10_STABLE [8e97a97b3] 2019-01-26 14:15:42 -0500
+Branch: REL9_6_STABLE [ae4c7d5ab] 2019-01-26 14:15:42 -0500
+Branch: REL9_5_STABLE [cda1e27fb] 2019-01-26 14:15:42 -0500
+-->
+ <para>
+ Fix <application>psql</application>'s <command>\g</command>
+ <replaceable>target</replaceable> meta-command to work
+ with <command>COPY TO STDOUT</command>
+ (Daniel Vérité)
+ </para>
+
+ <para>
+ Previously, the <replaceable>target</replaceable> option was
+ ignored, so that the copy data always went to the current query
+ output target.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [70d7e507e] 2018-11-26 17:32:51 -0500
+Branch: REL_11_STABLE [b352cf7a8] 2018-11-26 17:32:51 -0500
+Branch: REL_10_STABLE [815409093] 2018-11-26 17:32:51 -0500
+Branch: REL9_6_STABLE [ac305ff8c] 2018-11-26 17:32:51 -0500
+Branch: REL9_5_STABLE [18a0a8548] 2018-11-26 17:32:51 -0500
+Branch: REL9_4_STABLE [74bfb5388] 2018-11-26 17:32:51 -0500
+-->
+ <para>
+ Make <application>psql</application>'s LaTeX output formats render
+ special characters properly (Tom Lane)
+ </para>
+
+ <para>
+ Backslash and some other ASCII punctuation characters were not
+ rendered correctly, leading to document syntax errors or unexpected
+ output.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [e6c3ba7fb] 2019-01-24 11:31:54 -0500
+Branch: REL_11_STABLE [27d6bc68f] 2019-01-24 11:31:54 -0500
+-->
+ <para>
+ Make <application>pgbench</application>'s random number generation
+ fully deterministic and platform-independent
+ when <option>--random-seed=<replaceable>N</replaceable></option> is
+ specified (Fabien Coelho, Tom Lane)
+ </para>
+
+ <para>
+ On any specific platform, the sequence obtained with a particular
+ value of <replaceable>N</replaceable> will probably be different
+ from what it was before this patch.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [a1c91dd11] 2018-11-30 10:14:58 +0900
+Branch: REL_11_STABLE [85036308d] 2018-11-30 10:15:06 +0900
+Branch: master [5c9951397] 2018-11-30 10:34:45 +0900
+Branch: REL_11_STABLE [19516afdf] 2018-11-30 10:34:56 +0900
+-->
+ <para>
+ Fix <application>pg_basebackup</application>
+ and <application>pg_verify_checksums</application> to ignore
+ temporary files appropriately (Michael Banck, Michael Paquier)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [6e4d45b5f] 2019-02-04 17:20:02 -0500
+Branch: REL_11_STABLE [b8de846a5] 2019-02-04 17:20:02 -0500
+Branch: REL_10_STABLE [dc42602f1] 2019-02-04 17:20:02 -0500
+Branch: REL9_6_STABLE [16e0464a1] 2019-02-04 17:20:02 -0500
+Branch: REL9_5_STABLE [9368ba174] 2019-02-04 17:20:02 -0500
+Branch: REL9_4_STABLE [2f93b74bf] 2019-02-04 17:20:02 -0500
+-->
+ <para>
+ Fix <application>pg_dump</application>'s handling of materialized
+ views with indirect dependencies on primary keys (Tom Lane)
+ </para>
+
+ <para>
+ This led to mis-labeling of such views' dump archive entries,
+ causing harmless warnings about <quote>archive items not in correct
+ section order</quote>; less harmlessly, selective-restore options
+ depending on those labels, such as <option>--section</option>, might
+ misbehave.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [e4fca461a] 2018-12-18 09:28:16 +0900
+Branch: REL_11_STABLE [d0960eb8a] 2018-12-18 09:28:56 +0900
+-->
+ <para>
+ Make <application>pg_dump</application> include <command>ALTER INDEX
+ SET STATISTICS</command> commands (Michael Paquier)
+ </para>
+
+ <para>
+ When the ability to attach statistics targets to index expressions
+ was added, we forgot to teach <application>pg_dump</application>
+ about it, so that such settings were lost in dump/reload.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Peter Eisentraut <peter_e@gmx.net>
+Branch: master [6178f3cb7] 2018-11-13 09:41:20 +0100
+Branch: REL_11_STABLE [b72b4fafb] 2018-11-13 09:41:34 +0100
+-->
+ <para>
+ Fix <application>pg_dump</application>'s dumping of tables that have
+ OIDs (Peter Eisentraut)
+ </para>
+
+ <para>
+ The <literal>WITH OIDS</literal> clause was omitted if it needed to
+ be applied to the first table to be dumped.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Peter Geoghegan <pg@bowt.ie>
+Branch: master [eba775345] 2019-02-06 15:54:19 -0800
+Branch: REL_11_STABLE [2f5416666] 2019-02-06 15:54:17 -0800
+-->
+ <para>
+ Prevent false index-corruption reports
+ from <filename>contrib/amcheck</filename> caused by
+ inline-compressed data (Peter Geoghegan)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [ffa4cbd62] 2018-11-19 17:02:39 -0500
+Branch: REL_11_STABLE [8dc49a893] 2018-11-19 17:02:25 -0500
+Branch: REL_10_STABLE [8285fae07] 2018-11-19 17:02:25 -0500
+Branch: master [cb09903fe] 2018-11-19 17:28:04 -0500
+Branch: REL_11_STABLE [e2631255e] 2018-11-19 17:28:04 -0500
+Branch: REL_10_STABLE [0064d0e9f] 2018-11-19 17:28:05 -0500
+Branch: master [ade2d61ed] 2018-12-16 14:32:14 -0500
+Branch: REL_11_STABLE [b1894a607] 2018-12-16 14:32:14 -0500
+Branch: REL_10_STABLE [34010ac2f] 2018-12-16 14:32:14 -0500
+-->
+ <para>
+ Properly disregard <literal>EPIPE</literal> errors if <command>COPY
+ FROM PROGRAM</command> stops reading the program's output early
+ (Tom Lane)
+ </para>
+
+ <para>
+ This case isn't actually reachable directly
+ with <command>COPY</command>, but it can happen when
+ using <filename>contrib/file_fdw</filename>.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andrew Gierth <rhodiumtoad@postgresql.org>
+Branch: master [d5890f49d] 2018-11-24 09:59:49 +0000
+Branch: REL_11_STABLE [02e669c0f] 2018-11-24 21:17:08 +0000
+Branch: REL_10_STABLE [bcbb68278] 2018-11-24 21:17:09 +0000
+Branch: REL9_6_STABLE [239abfff1] 2018-11-24 21:17:09 +0000
+Branch: REL9_5_STABLE [8087788f6] 2018-11-24 21:17:09 +0000
+Branch: REL9_4_STABLE [e5a6ae97e] 2018-11-24 21:17:09 +0000
+-->
+ <para>
+ Fix <filename>contrib/hstore</filename> to calculate correct hash
+ values for empty <type>hstore</type> values that were created in
+ version 8.4 or before (Andrew Gierth)
+ </para>
+
+ <para>
+ The previous coding did not give the same result as for an
+ empty <type>hstore</type> value created by a newer version, thus
+ potentially causing wrong results in hash joins or hash
+ aggregation. It might be advisable to reindex any hash indexes
+ built on <type>hstore</type> columns.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andrew Gierth <rhodiumtoad@postgresql.org>
+Branch: master [757c5182f] 2018-11-24 08:48:36 +0000
+Branch: REL_11_STABLE [2e497ed23] 2018-11-24 08:39:29 +0000
+Branch: REL_10_STABLE [e193fb991] 2018-11-24 08:39:42 +0000
+Branch: REL9_6_STABLE [5f11a500f] 2018-11-24 08:39:55 +0000
+Branch: REL9_5_STABLE [f0bfc7a2b] 2018-11-24 08:39:58 +0000
+Branch: REL9_4_STABLE [2f30b311d] 2018-11-24 08:40:02 +0000
+-->
+ <para>
+ Avoid crashes and excessive runtime with large inputs
+ to <filename>contrib/intarray</filename>'s <literal>gist__int_ops</literal>
+ index support (Andrew Gierth)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Peter Eisentraut <peter@eisentraut.org>
+Branch: master [7291733ac] 2019-01-13 10:23:48 +0100
+Branch: REL_11_STABLE [3d498c65a] 2019-01-13 10:24:21 +0100
+Branch: REL_10_STABLE [cd1873160] 2019-01-13 10:25:23 +0100
+-->
+ <para>
+ In <application>configure</application>, look
+ for <command>python3</command> and then <command>python2</command>
+ if <command>python</command> isn't found (Peter Eisentraut)
+ </para>
+
+ <para>
+ This allows PL/Python to be configured without explicitly
+ specifying <literal>PYTHON</literal> on platforms that no longer
+ provide an unversioned <command>python</command> executable.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: REL9_5_STABLE [100535bba] 2018-11-19 14:24:51 -0500
+Branch: REL9_4_STABLE [7c86b9431] 2018-11-19 14:24:52 -0500
+-->
+ <para>
+ Adjust <application>configure</application>'s selection of
+ threading-related compiler flags and libraries to match what
+ later <productname>PostgreSQL</productname> releases do (Tom Lane)
+ </para>
+
+ <para>
+ The coding previously used in the 9.4 and 9.5 branches fails
+ outright on some newer platforms, so sync it with what 9.6 and later
+ have been doing.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andres Freund <andres@anarazel.de>
+Branch: master [5c1186751] 2019-01-28 13:51:12 -0800
+Branch: REL_11_STABLE [453be7d4d] 2019-01-28 13:53:43 -0800
+-->
+ <para>
+ Include JIT-related headers in the installed set of header files
+ (Donald Dong)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Michael Paquier <michael@paquier.xyz>
+Branch: master [ac3a9afdb] 2019-02-03 17:48:09 +0900
+Branch: REL_11_STABLE [946430da6] 2019-02-03 17:48:35 +0900
+Branch: REL_10_STABLE [da14c9b19] 2019-02-03 17:48:46 +0900
+Branch: REL9_6_STABLE [5e63df827] 2019-02-03 17:48:53 +0900
+Branch: REL9_5_STABLE [12ff406f3] 2019-02-03 17:48:59 +0900
+Branch: REL9_4_STABLE [42b204db2] 2019-02-03 17:49:04 +0900
+-->
+ <para>
+ Support new Makefile
+ variables <literal>PG_CFLAGS</literal>, <literal>PG_CXXFLAGS</literal>,
+ and <literal>PG_LDFLAGS</literal> in <application>pgxs</application>
+ builds (Christoph Berg)
+ </para>
+
+ <para>
+ This simplifies customization of extension build processes.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Andrew Dunstan <andrew@dunslane.net>
+Branch: master [f83419b73] 2019-02-05 19:27:47 -0500
+Branch: REL_11_STABLE [77173d0cc] 2019-02-05 19:33:42 -0500
+Branch: REL_10_STABLE [1a6244216] 2019-02-05 19:34:00 -0500
+Branch: REL9_6_STABLE [42345284c] 2019-02-05 19:34:17 -0500
+Branch: REL9_5_STABLE [59927f99a] 2019-02-05 19:35:07 -0500
+Branch: REL9_4_STABLE [2689e8e33] 2019-02-05 19:35:18 -0500
+Branch: master [592123efb] 2019-02-06 07:36:02 -0500
+Branch: REL_11_STABLE [11f11e1e0] 2019-02-06 07:49:07 -0500
+Branch: REL_10_STABLE [1f28906bf] 2019-02-06 07:49:27 -0500
+Branch: REL9_6_STABLE [324c92646] 2019-02-06 07:53:19 -0500
+Branch: REL9_5_STABLE [8d2741452] 2019-02-06 07:55:10 -0500
+Branch: REL9_4_STABLE [13e95662c] 2019-02-06 07:55:22 -0500
+Branch: REL9_6_STABLE [772d4b769] 2019-02-05 18:31:10 -0500
+Branch: REL9_5_STABLE [a25b04933] 2019-02-05 18:34:47 -0500
+Branch: REL9_4_STABLE [7a3763318] 2019-02-05 18:34:58 -0500
+Branch: master [f884a9681] 2019-02-05 09:59:46 -0500
+Branch: REL_11_STABLE [4e7a51302] 2019-02-05 10:04:38 -0500
+Branch: REL_10_STABLE [1fbb9bda0] 2019-02-05 10:04:58 -0500
+Branch: REL9_6_STABLE [be037c11b] 2019-02-05 10:05:17 -0500
+Branch: REL9_5_STABLE [a82ca6ffb] 2019-02-05 10:05:57 -0500
+Branch: REL9_4_STABLE [51884fa16] 2019-02-05 10:06:12 -0500
+-->
+ <para>
+ Fix Perl-coded build scripts to not
+ assume <quote><literal>.</literal></quote> is in the search path, as
+ recent Perl versions don't include that (Andrew Dunstan)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [69bcd718d] 2019-01-18 15:06:26 -0500
+Branch: REL_11_STABLE [e4ffa0dcb] 2019-01-18 15:06:26 -0500
+Branch: REL_10_STABLE [139e42742] 2019-01-18 15:06:26 -0500
+Branch: REL9_6_STABLE [167ba6b15] 2019-01-18 15:06:26 -0500
+Branch: REL9_5_STABLE [dc2dee438] 2019-01-18 15:06:26 -0500
+Branch: REL9_4_STABLE [b161ffe31] 2019-01-18 15:06:26 -0500
+-->
+ <para>
+ Fix server command-line option parsing problems on OpenBSD (Tom Lane)
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+NOTE this is already in 11.1 notes, but not 10.x !!!!
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [003c68a3b] 2018-11-06 13:25:24 -0500
+Branch: REL_11_STABLE [1f28ec6be] 2018-11-06 13:25:24 -0500
+Branch: REL_10_STABLE [b2e754c14] 2018-11-06 13:25:24 -0500
+NOTE this is already in 11.1 notes, but not 10.x !!!!
+-->
+ <para>
+ Rename red-black tree support functions to use <literal>rbt</literal>
+ prefix not <literal>rb</literal> prefix (Tom Lane)
+ </para>
+
+ <para>
+ This avoids name collisions with Ruby functions, which broke
+ PL/Ruby. It's hoped that there are no other affected extensions.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+Branch: master [d63dc0aa0] 2019-02-05 10:58:53 -0500
+Branch: REL_11_STABLE [46b454096] 2019-02-05 10:59:06 -0500
+Branch: REL_10_STABLE [09c5f045c] 2019-02-05 10:59:15 -0500
+Branch: REL9_6_STABLE [f6db9f8ab] 2019-02-05 10:59:23 -0500
+Branch: REL9_5_STABLE [4232a650b] 2019-02-05 10:59:31 -0500
+Branch: REL9_4_STABLE [a683df403] 2019-02-05 10:59:38 -0500
+-->
+ <para>
+ Update time zone data files to <application>tzdata</application>
+ release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao
+ Tome and Principe. Kazakhstan's Qyzylorda zone is split in two,
+ creating a new zone Asia/Qostanay, as some areas did not change UTC
+ offset. Historical corrections for Hong Kong and numerous Pacific
+ islands.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </sect2>
+ </sect1>
+
<sect1 id="release-11-1">
<title>Release 11.1</title>