|
23 | 23 | </para> |
24 | 24 |
|
25 | 25 | <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. |
28 | 35 | </para> |
29 | 36 |
|
30 | 37 | <para> |
|
40 | 47 |
|
41 | 48 | <listitem> |
42 | 49 | <!-- |
| 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">§</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 | +<!-- |
43 | 83 | Author: Tomas Vondra <tomas.vondra@postgresql.org> |
44 | 84 | Branch: master [818245506] 2025-03-26 17:01:41 +0100 |
45 | 85 | 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 |
252 | 292 | --> |
253 | 293 | <para> |
254 | 294 | 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) |
256 | 297 | <ulink url="&commit_baseurl;d6dd2a02b">§</ulink> |
257 | 298 | <ulink url="&commit_baseurl;0941aadcd">§</ulink> |
258 | 299 | </para> |
@@ -694,38 +735,6 @@ Branch: REL_17_STABLE [727bc6ac3] 2025-02-19 10:04:44 +0900 |
694 | 735 |
|
695 | 736 | <listitem> |
696 | 737 | <!-- |
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 | | -<!-- |
729 | 738 | Author: Masahiko Sawada <msawada@postgresql.org> |
730 | 739 | Branch: master [fd09c1316] 2025-04-03 10:30:00 -0700 |
731 | 740 | 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 |
939 | 948 |
|
940 | 949 | <listitem> |
941 | 950 | <!-- |
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 | | -<!-- |
953 | 951 | Author: Michael Paquier <michael@paquier.xyz> |
954 | 952 | Branch: master [1f7878c33] 2025-04-23 13:53:29 +0900 |
955 | 953 | 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 |
1137 | 1135 |
|
1138 | 1136 | <listitem> |
1139 | 1137 | <!-- |
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 | | -<!-- |
1164 | 1138 | Author: Tom Lane <tgl@sss.pgh.pa.us> |
1165 | 1139 | Branch: master [d05996340] 2025-04-19 16:37:42 -0400 |
1166 | 1140 | Branch: REL_17_STABLE [ecb8e5641] 2025-04-19 16:37:42 -0400 |
|