Skip to content

Commit 09fac4a

Browse files
tglsfdctglsfdc
committed
Release notes for 17.5, 16.9, 15.13, 14.18, 13.21.
1 parent ee24869 commit 09fac4a

File tree

1 file changed

+44
-70
lines changed

1 file changed

+44
-70
lines changed

‎doc/src/sgml/release-17.sgml

Lines changed: 44 additions & 70 deletions
Original file line numberDiff line numberDiff line change
@@ -23,8 +23,15 @@
2323
</para>
2424

2525
<para>
26-
However, if you have any BRIN bloom indexes, it may be advisable to
27-
reindex them after updating. See the first changelog entry below.
26+
However, if you have any self-referential foreign key constraints on
27+
partitioned tables, it may be necessary to recreate those constraints
28+
to ensure that they are being enforced correctly. See the first
29+
changelog entry below.
30+
</para>
31+
32+
<para>
33+
Also, if you have any BRIN bloom indexes, it may be advisable to
34+
reindex them after updating. See the second changelog entry below.
2835
</para>
2936

3037
<para>
@@ -40,6 +47,39 @@
4047

4148
<listitem>
4249
<!--
50+
Author: Álvaro Herrera <alvherre@kurilemu.de>
51+
Branch: master [c83a38758] 2025-05-02 21:25:50 +0200
52+
Branch: REL_17_STABLE [f51ae3187] 2025-05-02 21:25:50 +0200
53+
Branch: REL_16_STABLE [1817d62ec] 2025-05-02 21:25:50 +0200
54+
Branch: REL_15_STABLE [6ba979cf5] 2025-05-02 21:25:50 +0200
55+
Branch: REL_14_STABLE [1649d153a] 2025-05-02 21:25:50 +0200
56+
Branch: REL_13_STABLE [b3a9c536d] 2025-05-02 21:25:50 +0200
57+
-->
58+
<para>
59+
Handle self-referential foreign keys on partitioned tables correctly
60+
(Álvaro Herrera)
61+
<ulink url="&commit_baseurl;f51ae3187">&sect;</ulink>
62+
</para>
63+
64+
<para>
65+
Creating or attaching partitions failed to make the required catalog
66+
entries for a foreign-key constraint, if the table referenced by the
67+
constraint was the same partitioned table. This resulted in failure
68+
to enforce the constraint fully.
69+
</para>
70+
71+
<para>
72+
To fix this, you should drop and recreate any self-referential
73+
foreign keys on partitioned tables, if partitions have been created
74+
or attached since the constraint was created. Bear in mind that
75+
violating rows might already be present, in which case recreating
76+
the constraint will fail, and you'll need to fix up those rows
77+
before trying again.
78+
</para>
79+
</listitem>
80+
81+
<listitem>
82+
<!--
4383
Author: Tomas Vondra <tomas.vondra@postgresql.org>
4484
Branch: master [818245506] 2025-03-26 17:01:41 +0100
4585
Branch: REL_17_STABLE [cb0ad70b8] 2025-03-26 17:02:17 +0100
@@ -252,7 +292,8 @@ Branch: REL_13_STABLE [dd34cbfce] 2025-04-02 11:13:01 -0400
252292
-->
253293
<para>
254294
Fix <literal>ALTER TABLE ADD COLUMN</literal> to correctly handle
255-
the case of a domain type that has a default (Tom Lane, Tender Wang)
295+
the case of a domain type that has a default
296+
(Jian He, Tom Lane, Tender Wang)
256297
<ulink url="&commit_baseurl;d6dd2a02b">&sect;</ulink>
257298
<ulink url="&commit_baseurl;0941aadcd">&sect;</ulink>
258299
</para>
@@ -694,38 +735,6 @@ Branch: REL_17_STABLE [727bc6ac3] 2025-02-19 10:04:44 +0900
694735

695736
<listitem>
696737
<!--
697-
Author: Noah Misch <noah@leadboat.com>
698-
Branch: REL_14_STABLE [3635a0a35] 2025-04-06 15:40:44 +0900
699-
Branch: REL_13_STABLE [69a498eb6] 2025-04-06 15:42:30 +0900
700-
Branch: REL_14_STABLE [014a50800] 2025-04-06 15:37:53 +0900
701-
Branch: REL_13_STABLE [a5b0c06da] 2025-04-06 15:40:15 +0900
702-
Branch: REL_14_STABLE [675b771ca] 2025-04-06 15:26:23 +0900
703-
Branch: REL_13_STABLE [cbed472a9] 2025-04-06 15:27:34 +0900
704-
Branch: REL_14_STABLE [b494640e8] 2025-04-06 14:46:31 +0900
705-
Branch: REL_13_STABLE [d0b6acaf0] 2025-04-06 14:48:01 +0900
706-
Branch: REL_14_STABLE [8967dddf0] 2025-04-06 14:36:08 +0900
707-
Branch: REL_13_STABLE [20e5ef3ca] 2025-04-06 14:38:34 +0900
708-
Branch: REL_14_STABLE [6b168c129] 2025-04-06 14:12:12 +0900
709-
Branch: REL_13_STABLE [df8ec9634] 2025-04-06 14:22:46 +0900
710-
Author: Michael Paquier <michael@paquier.xyz>
711-
Branch: REL_14_STABLE [47d2d2982] 2025-04-06 15:14:52 +0900
712-
Branch: REL_13_STABLE [e77d9cd4f] 2025-04-06 15:15:13 +0900
713-
-->
714-
<para>
715-
Skip WAL recycling and preallocation during archive recovery, to
716-
avoid corruption of WAL files that were restored from the archive
717-
(Noah Misch, Arun Thirupathi)
718-
</para>
719-
720-
<para>
721-
This change back-patches v15-era fixes that were considered largely
722-
cosmetic at the time, but turn out to prevent data corruption in the
723-
wake of subsequent fixes.
724-
</para>
725-
</listitem>
726-
727-
<listitem>
728-
<!--
729738
Author: Masahiko Sawada <msawada@postgresql.org>
730739
Branch: master [fd09c1316] 2025-04-03 10:30:00 -0700
731740
Branch: REL_17_STABLE [a4309e85f] 2025-04-03 10:30:02 -0700
@@ -939,17 +948,6 @@ Branch: REL_17_STABLE [ee578921b] 2025-03-18 13:44:10 -0400
939948

940949
<listitem>
941950
<!--
942-
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
943-
Branch: REL_15_STABLE [0f404c581] 2025-04-30 20:36:24 +0200
944-
Branch: REL_14_STABLE [7be51eb4e] 2025-04-30 20:36:23 +0200
945-
-->
946-
<para>
947-
Fix assertion failure in snapshot building (Masahiko Sawada)
948-
</para>
949-
</listitem>
950-
951-
<listitem>
952-
<!--
953951
Author: Michael Paquier <michael@paquier.xyz>
954952
Branch: master [1f7878c33] 2025-04-23 13:53:29 +0900
955953
Branch: REL_17_STABLE [4b6331e0f] 2025-04-23 13:54:53 +0900
@@ -1137,30 +1135,6 @@ Branch: REL_17_STABLE [09ef2f8df] 2025-03-16 13:29:20 +0200
11371135

11381136
<listitem>
11391137
<!--
1140-
Author: Noah Misch <noah@leadboat.com>
1141-
Branch: REL_16_STABLE [82a8f0f46] 2025-04-03 09:33:58 -0700
1142-
Branch: REL_15_STABLE [63f6ecb6b] 2025-04-03 09:34:01 -0700
1143-
Branch: REL_14_STABLE [a8a918937] 2025-04-03 09:34:01 -0700
1144-
Branch: REL_13_STABLE [186c586c3] 2025-04-03 09:34:02 -0700
1145-
Author: Andres Freund <andres@anarazel.de>
1146-
Branch: REL_15_STABLE [9e129a224] 2025-04-03 09:34:01 -0700
1147-
Branch: REL_14_STABLE [aa435d7c4] 2025-04-03 09:34:01 -0700
1148-
Branch: REL_13_STABLE [5a3d5c083] 2025-04-03 09:34:02 -0700
1149-
-->
1150-
<para>
1151-
Allow <filename>contrib/dblink</filename> queries to be interrupted
1152-
by query cancel (Noah Misch)
1153-
</para>
1154-
1155-
<para>
1156-
This change back-patches a v17-era fix. It prevents possible hangs
1157-
in <command>CREATE DATABASE</command> and <command>DROP
1158-
DATABASE</command> due to failure to detect deadlocks.
1159-
</para>
1160-
</listitem>
1161-
1162-
<listitem>
1163-
<!--
11641138
Author: Tom Lane <tgl@sss.pgh.pa.us>
11651139
Branch: master [d05996340] 2025-04-19 16:37:42 -0400
11661140
Branch: REL_17_STABLE [ecb8e5641] 2025-04-19 16:37:42 -0400

0 commit comments

Comments
 (0)