diff options
| -rw-r--r-- | doc/src/sgml/release-14.sgml | 330 |
1 files changed, 16 insertions, 314 deletions
diff --git a/doc/src/sgml/release-14.sgml b/doc/src/sgml/release-14.sgml index 981993e70e3..e7da94b025a 100644 --- a/doc/src/sgml/release-14.sgml +++ b/doc/src/sgml/release-14.sgml @@ -58,6 +58,14 @@ Branch: REL_13_STABLE [b76e136ce] 2022-07-29 18:17:36 -0400 Branch: REL_12_STABLE [4349a7615] 2022-07-29 18:17:42 -0400 Branch: REL_11_STABLE [3f9c20536] 2022-07-29 18:17:49 -0400 Branch: REL_10_STABLE [c308003d2] 2022-07-29 18:17:55 -0400 +Author: Alvaro Herrera <alvherre@alvh.no-ip.org> +Branch: master [6c1c9f88a] 2022-08-06 15:52:10 +0200 +Branch: REL_15_STABLE [6390bc740] 2022-08-06 15:52:10 +0200 +Branch: REL_14_STABLE [9d5c96d9b] 2022-08-06 15:52:10 +0200 +Branch: REL_13_STABLE [8c5d9ccca] 2022-08-06 15:52:10 +0200 +Branch: REL_12_STABLE [782e5631e] 2022-08-06 15:52:10 +0200 +Branch: REL_11_STABLE [772e6383d] 2022-08-06 15:52:10 +0200 +Branch: REL_10_STABLE [ad0e08394] 2022-08-06 15:52:10 +0200 --> <para> Fix replay of <command>CREATE DATABASE</command> WAL @@ -189,39 +197,6 @@ Branch: REL_10_STABLE [4822b4627] 2022-06-27 08:24:38 +0300 <listitem> <!-- Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [1218780cc] 2022-06-10 10:35:57 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [77c1d92cb] 2022-06-10 10:35:57 -0400 -Branch: REL_13_STABLE [254cd7f31] 2022-06-10 10:35:57 -0400 -Branch: REL_12_STABLE [d3ef5c3ef] 2022-06-10 10:35:57 -0400 -Branch: REL_11_STABLE [199aac8b2] 2022-06-10 10:35:57 -0400 ---> - <para> - Fix queries in which a <quote>whole-row variable</quote> references - the result of a function that returns a domain over composite type - (Tom Lane) - </para> - </listitem> - - <listitem> -<!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [79b58c6f6] 2022-05-12 11:31:46 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [ac51c9fba] 2022-05-12 11:31:46 -0400 -Branch: REL_13_STABLE [b7579b25c] 2022-05-12 11:31:46 -0400 -Branch: REL_12_STABLE [301b91c56] 2022-05-12 11:31:46 -0400 -Branch: REL_11_STABLE [7f7f1750d] 2022-05-12 11:31:46 -0400 -Branch: REL_10_STABLE [b53442f6f] 2022-05-12 11:31:46 -0400 ---> - <para> - Fix <quote>variable not found in subplan target list</quote> planner - error when pulling up a sub-<literal>SELECT</literal> that's - referenced in a <literal>GROUPING</literal> function (Richard Guo) - </para> - </listitem> - - <listitem> -<!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> Branch: master [1aa8dad41] 2022-08-03 17:33:42 -0400 Branch: REL_15_STABLE [14168d57b] 2022-08-03 17:33:42 -0400 Branch: REL_14_STABLE [445b9020c] 2022-08-03 17:33:42 -0400 @@ -359,23 +334,6 @@ Branch: REL_12_STABLE [2cf875a4b] 2022-07-03 17:17:08 -0400 <listitem> <!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [bf4717b09] 2022-06-07 15:34:30 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [5c3b5f7db] 2022-06-07 15:34:30 -0400 -Branch: REL_13_STABLE [a36196972] 2022-06-07 15:34:30 -0400 -Branch: REL_12_STABLE [435251b85] 2022-06-07 15:34:30 -0400 -Branch: REL_11_STABLE [d628ce048] 2022-06-07 15:34:30 -0400 -Branch: REL_10_STABLE [fb646cbd5] 2022-06-07 15:34:30 -0400 ---> - <para> - Prevent <function>pg_stat_get_subscription()</function> from - possibly returning an extra row containing garbage values - (Kuntal Ghosh) - </para> - </listitem> - - <listitem> -<!-- Author: Fujii Masao <fujii@postgresql.org> Branch: master [b24b2be11] 2022-07-20 09:57:01 +0900 Branch: REL_15_STABLE [0829cc43e] 2022-07-20 09:57:07 +0900 @@ -432,29 +390,6 @@ Branch: REL_10_STABLE [8ace122d4] 2022-07-07 13:07:51 +0100 <listitem> <!-- -Author: Alvaro Herrera <alvherre@alvh.no-ip.org> -Branch: master Release: REL_15_BR [0fbf01120] 2022-05-18 20:28:31 +0200 -Branch: REL_14_STABLE Release: REL_14_4 [94edb85d2] 2022-05-18 20:28:31 +0200 -Branch: REL_13_STABLE [80656f00f] 2022-05-18 20:28:31 +0200 -Branch: REL_12_STABLE [ade17703d] 2022-05-18 20:28:31 +0200 -Branch: REL_11_STABLE [ba83de8ad] 2022-05-18 20:28:31 +0200 -Branch: REL_10_STABLE [16cb7db34] 2022-05-18 20:28:31 +0200 -Branch: master Release: REL_15_BR [62221ef18] 2022-05-18 23:19:53 +0200 -Branch: REL_14_STABLE Release: REL_14_4 [e8b93c6e2] 2022-05-18 23:19:53 +0200 -Branch: REL_13_STABLE [5139db556] 2022-05-18 23:19:53 +0200 -Branch: REL_12_STABLE [0ebd20e20] 2022-05-18 23:19:53 +0200 -Branch: REL_11_STABLE [50bf3157a] 2022-05-18 23:19:53 +0200 -Branch: REL_10_STABLE [29d111518] 2022-05-18 23:19:53 +0200 ---> - <para> - Avoid crashing if too many column aliases are attached to - an <literal>XMLTABLE</literal> or <literal>JSON_TABLE</literal> - construct (Álvaro Herrera) - </para> - </listitem> - - <listitem> -<!-- Author: Tom Lane <tgl@sss.pgh.pa.us> Branch: master [fd96d14d9] 2022-07-29 13:31:10 -0400 Branch: REL_15_STABLE [e6e804aa2] 2022-07-29 13:31:11 -0400 @@ -488,29 +423,6 @@ Branch: REL_10_STABLE [d54fc7e67] 2022-08-01 12:22:35 -0400 <listitem> <!-- Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [c7461fc25] 2022-05-21 14:45:58 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [6f7eec119] 2022-05-21 14:45:58 -0400 -Branch: REL_13_STABLE [fefd54631] 2022-05-21 14:45:58 -0400 -Branch: REL_12_STABLE [bb2c04676] 2022-05-21 14:45:58 -0400 -Branch: REL_11_STABLE [f3b8d7244] 2022-05-21 14:45:58 -0400 -Branch: REL_10_STABLE [7686403b4] 2022-05-21 14:45:58 -0400 ---> - <para> - When decompiling a view or rule, show a <command>SELECT</command> - output column's <literal>AS "?column?"</literal> alias clause - if it could be referenced elsewhere (Tom Lane) - </para> - - <para> - Previously, this auto-generated alias was always hidden; but there - are corner cases where doing so results in a non-restorable view or - rule definition. - </para> - </listitem> - - <listitem> -<!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> Branch: master [b9654cece] 2022-07-21 13:56:02 -0400 Branch: REL_15_STABLE [c1d1e8469] 2022-07-21 13:56:05 -0400 Branch: REL_14_STABLE [da9a28fd5] 2022-07-21 13:56:02 -0400 @@ -534,75 +446,6 @@ Branch: REL_10_STABLE [6bceacfe8] 2022-07-21 13:56:02 -0400 <listitem> <!-- -Author: Alvaro Herrera <alvherre@alvh.no-ip.org> -Branch: master Release: REL_15_BR [602986191] 2022-05-20 18:52:55 +0200 -Branch: REL_14_STABLE Release: REL_14_4 [58b088a9b] 2022-05-20 18:52:55 +0200 -Branch: REL_13_STABLE [3753a169e] 2022-05-20 18:52:55 +0200 -Branch: REL_12_STABLE [4492e73a6] 2022-05-20 18:52:55 +0200 -Branch: REL_11_STABLE [6c6ea6ea8] 2022-05-20 18:52:55 +0200 -Branch: REL_10_STABLE [70f70d7d3] 2022-05-20 18:52:55 +0200 -Branch: REL_10_STABLE [8c47622bb] 2022-05-20 19:05:55 +0200 ---> - <para> - Report implicitly-created operator families to event triggers - (Masahiko Sawada) - </para> - - <para> - If <command>CREATE OPERATOR CLASS</command> results in the implicit - creation of an operator family, that object was not reported to - event triggers that should capture such events. - </para> - </listitem> - - <listitem> -<!-- -Author: Michael Paquier <michael@paquier.xyz> -Branch: REL_14_STABLE Release: REL_14_4 [6dced63b4] 2022-05-16 11:26:22 +0900 -Branch: REL_13_STABLE [2e9559b30] 2022-05-16 11:26:26 +0900 -Branch: REL_12_STABLE [7e59b1219] 2022-05-16 11:26:30 +0900 -Branch: REL_11_STABLE [4525151d4] 2022-05-16 11:26:36 +0900 -Branch: REL_10_STABLE [60e956eb8] 2022-05-16 11:26:41 +0900 ---> - <para> - Fix control file updates made when a restartpoint is running during - promotion of a standby server (Kyotaro Horiguchi) - </para> - - <para> - Previously, when the restartpoint completed it could incorrectly - update the last-checkpoint fields of the control file, potentially - leading to PANIC and failure to restart if the server crashes before - the next normal checkpoint completes. - </para> - </listitem> - - <listitem> -<!-- -Author: Amit Kapila <akapila@postgresql.org> -Branch: master Release: REL_15_BR [f95d53ede] 2022-05-11 11:11:44 +0530 -Branch: REL_14_STABLE Release: REL_14_4 [d6da71fa8] 2022-05-11 10:51:04 +0530 -Branch: REL_13_STABLE [55558df23] 2022-05-11 10:41:24 +0530 -Branch: REL_12_STABLE [f832b5007] 2022-05-11 10:25:56 +0530 -Branch: REL_11_STABLE [87c1dd246] 2022-05-11 10:12:23 +0530 -Branch: REL_10_STABLE [a4015ec03] 2022-05-11 10:01:35 +0530 ---> - <para> - Prevent triggering of - standby's <varname>wal_receiver_timeout</varname> during logical - replication of large transactions (Wang Wei, Amit Kapila) - </para> - - <para> - If a large transaction on the primary server sends no data to the - standby (perhaps because no table it changes is published), it was - possible for the standby to timeout. Fix that by ensuring we send - keepalive messages periodically in such situations. - </para> - </listitem> - - <listitem> -<!-- Author: Fujii Masao <fujii@postgresql.org> Branch: master [ee7964776] 2022-07-20 09:56:42 +0900 Branch: REL_15_STABLE [286793b98] 2022-07-20 09:56:52 +0900 @@ -673,68 +516,6 @@ Branch: REL_13_STABLE [16f5a8da7] 2022-06-15 10:16:35 +0530 <listitem> <!-- -Author: Amit Kapila <akapila@postgresql.org> -Branch: REL_10_STABLE [37fd181d6] 2022-06-03 08:15:00 +0530 ---> - <para> - Ignore heap-rewrite temporary tables for materialized views in - logical replication (Euler Taveira) - </para> - - <para> - A <literal>FOR ALL TABLES</literal> publication will try to publish - temporary tables if left to its own devices. There is a heuristic - to suppress these, but it failed to cover internal temporary tables - created while rewriting a materialized view. This created a risk of - <quote>logical replication target relation ... does not - exist</quote> failures during <command>REFRESH MATERIALIZED - VIEW</command>. - </para> - </listitem> - - <listitem> -<!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [16c80e7d0] 2022-05-31 14:47:44 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [c47a55852] 2022-05-31 14:47:44 -0400 -Branch: REL_13_STABLE [c73748b68] 2022-05-31 14:47:44 -0400 -Branch: REL_12_STABLE [a3faebd6a] 2022-05-31 14:47:44 -0400 -Branch: REL_11_STABLE [ae758e603] 2022-05-31 14:47:44 -0400 -Branch: REL_10_STABLE [2114910ca] 2022-05-31 14:47:44 -0400 ---> - <para> - Prevent open-file leak when reading an invalid timezone abbreviation - file (Kyotaro Horiguchi) - </para> - - <para> - Such cases could result in harmless warning messages. - </para> - </listitem> - - <listitem> -<!-- -Author: Michael Paquier <michael@paquier.xyz> -Branch: master Release: REL_15_BR [f1431f3bf] 2022-05-28 12:12:40 +0900 -Branch: REL_14_STABLE Release: REL_14_4 [fe441a031] 2022-05-28 12:12:46 +0900 -Branch: REL_13_STABLE [1e6802990] 2022-05-28 12:12:51 +0900 -Branch: REL_12_STABLE [ae236bf66] 2022-05-28 12:12:55 +0900 -Branch: REL_11_STABLE [c3db8a2e2] 2022-05-28 12:12:58 +0900 -Branch: REL_10_STABLE [1b40ceea2] 2022-05-28 12:13:02 +0900 ---> - <para> - Allow custom server parameters to have short descriptions that are - NULL (Steve Chavez) - </para> - - <para> - Previously, although extensions could choose to create such - settings, some code paths would crash while processing them. - </para> - </listitem> - - <listitem> -<!-- Author: Alvaro Herrera <alvherre@alvh.no-ip.org> Branch: master [e44dae07f] 2022-08-05 18:00:17 +0200 Branch: REL_15_STABLE [2cff30259] 2022-08-05 18:00:17 +0200 @@ -743,6 +524,14 @@ Branch: REL_13_STABLE [de31e6f81] 2022-08-05 18:00:17 +0200 Branch: REL_12_STABLE [49b85e481] 2022-08-05 18:00:17 +0200 Branch: REL_11_STABLE [39e45d3ce] 2022-08-05 18:00:17 +0200 Branch: REL_10_STABLE [e797c7a6f] 2022-08-05 18:00:17 +0200 +Author: Alvaro Herrera <alvherre@alvh.no-ip.org> +Branch: master [afe58c8b7] 2022-08-07 10:19:40 +0200 +Branch: REL_15_STABLE [9c3006000] 2022-08-07 10:19:40 +0200 +Branch: REL_14_STABLE [f4beef1c2] 2022-08-07 10:19:40 +0200 +Branch: REL_13_STABLE [1626590f2] 2022-08-07 10:19:40 +0200 +Branch: REL_12_STABLE [3aafd5da7] 2022-08-07 10:19:40 +0200 +Branch: REL_11_STABLE [61904503b] 2022-08-07 10:19:40 +0200 +Branch: REL_10_STABLE [8e5874964] 2022-08-07 10:19:40 +0200 --> <para> Fix WAL consistency checking logic to correctly @@ -826,30 +615,6 @@ Branch: REL_11_STABLE [6d61aef5d] 2022-07-18 19:38:24 +0200 <listitem> <!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [2b65de7fc] 2022-05-26 14:14:05 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [b4be4a082] 2022-05-26 14:14:05 -0400 -Branch: REL_13_STABLE [9e3dbc6fd] 2022-05-26 14:14:05 -0400 -Branch: REL_12_STABLE [01ab9fb7d] 2022-05-26 14:14:05 -0400 -Branch: REL_11_STABLE [a44bc8b8f] 2022-05-26 14:14:05 -0400 -Branch: REL_10_STABLE [ef54a6576] 2022-05-26 14:14:05 -0400 ---> - <para> - Remove misguided SSL key file ownership check - in <application>libpq</application> (Tom Lane) - </para> - - <para> - In the previous minor releases, we copied the server's permission - checking rules for SSL private key files into libpq. But we should - not have also copied the server's file-ownership check. While that - works in normal use-cases, it can result in an unexpected failure - for clients running as root, and perhaps in other cases. - </para> - </listitem> - - <listitem> -<!-- Author: Alvaro Herrera <alvherre@alvh.no-ip.org> Branch: master [054325c5e] 2022-07-05 14:21:20 +0200 Branch: REL_15_STABLE [93cf9233c] 2022-07-05 14:21:20 +0200 @@ -873,29 +638,6 @@ Branch: REL_14_STABLE [9e038d690] 2022-07-13 12:10:03 +0200 <listitem> <!-- Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [6d157e7cb] 2022-06-06 11:20:21 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [a5dbca460] 2022-06-06 11:20:31 -0400 -Branch: REL_13_STABLE [16d68007c] 2022-06-06 11:20:36 -0400 -Branch: REL_12_STABLE [02026cadb] 2022-06-06 11:20:41 -0400 -Branch: REL_11_STABLE [d82ed5b2f] 2022-06-06 11:20:46 -0400 -Branch: REL_10_STABLE [89254606b] 2022-06-06 11:20:52 -0400 ---> - <para> - Ensure <application>ecpg</application> reports server connection loss - sanely (Tom Lane) - </para> - - <para> - Misprocessing of a libpq-generated error result, such as a report of - lost connection, would lead to printing <quote>(null)</quote> - instead of a useful error message; or in older releases it would - lead to a crash. - </para> - </listitem> - - <listitem> -<!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> Branch: master Release: REL_15_BR [ba412c905] 2022-06-14 18:16:46 -0400 Branch: REL_14_STABLE [7bc21ed8c] 2022-06-14 18:16:46 -0400 Branch: REL_13_STABLE [12b8fb34a] 2022-06-14 18:16:46 -0400 @@ -1155,46 +897,6 @@ Branch: REL_14_STABLE [e086b5538] 2022-06-26 11:00:04 +1200 </para> </listitem> - <listitem> -<!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [eb39610f8] 2022-06-01 16:15:47 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [1072e4c45] 2022-06-01 16:15:47 -0400 -Branch: REL_13_STABLE [eeac7dd9f] 2022-06-01 16:15:47 -0400 -Branch: REL_12_STABLE [c08538734] 2022-06-01 16:15:47 -0400 -Branch: REL_11_STABLE [b5265196e] 2022-06-01 16:15:47 -0400 -Branch: REL_10_STABLE [d5e1d5ed9] 2022-06-01 16:15:47 -0400 -Branch: REL9_6_STABLE [d4c161842] 2022-06-01 16:15:47 -0400 -Branch: REL9_5_STABLE [9fdeae848] 2022-06-01 16:15:47 -0400 -Branch: REL9_4_STABLE [b53780e1b] 2022-06-01 16:15:47 -0400 -Branch: REL9_3_STABLE [a3b685fdd] 2022-06-01 16:15:47 -0400 -Branch: REL9_2_STABLE [6f9ea6cf3] 2022-06-01 16:15:47 -0400 ---> - <para> - Adjust PL/Perl test case so it will work under Perl 5.36 - (Dagfinn Ilmari MannsÃ¥ker) - </para> - </listitem> - - <listitem> -<!-- -Author: Tom Lane <tgl@sss.pgh.pa.us> -Branch: master Release: REL_15_BR [aff45c879] 2022-05-10 18:42:02 -0400 -Branch: REL_14_STABLE Release: REL_14_4 [12736e7dc] 2022-05-10 18:42:02 -0400 -Branch: REL_13_STABLE [af9b96767] 2022-05-10 18:42:02 -0400 -Branch: REL_12_STABLE [8ed13fb93] 2022-05-10 18:42:02 -0400 -Branch: REL_11_STABLE [36d76da81] 2022-05-10 18:42:02 -0400 -Branch: REL_10_STABLE [c61f36d99] 2022-05-10 18:42:02 -0400 ---> - <para> - Avoid incorrectly using an - out-of-date <application>libldap_r</application> library when - multiple <productname>OpenLDAP</productname> installations are - present while building <productname>PostgreSQL</productname> - (Tom Lane) - </para> - </listitem> - </itemizedlist> </sect2> |