Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit0522d6f

Browse files
committed
Release notes for 12.2, 11.7, 10.12, 9.6.17, 9.5.21, 9.4.26.
1 parentbaf4871 commit0522d6f

File tree

1 file changed

+35
-7
lines changed

1 file changed

+35
-7
lines changed

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

Lines changed: 35 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -23,10 +23,9 @@
2323
</para>
2424

2525
<para>
26-
However, if you have done any
27-
partition-level <command>TRUNCATE</command> commands affecting
28-
partitioned tables that have foreign-key references, see the entry
29-
below about that.
26+
However, if you have any foreign key constraints referencing
27+
partitioned tables, see the two entries below about bugs in that
28+
feature.
3029
</para>
3130
</sect2>
3231

@@ -60,8 +59,32 @@ Branch: REL_12_STABLE [ce054a8cd] 2020-02-07 17:09:36 -0300
6059
tables, and you have done any
6160
partition-level <command>TRUNCATE</command> on the referenced table,
6261
you should check to see if any foreign key violations exist. The
63-
simplest way is to drop and re-add the foreign key constraint,
64-
though this may be unduly expensive.
62+
simplest way is to add a new instance of the foreign key constraint
63+
(and, once that succeeds, drop it or the original constraint).
64+
That may be prohibitive from a locking standpoint, however, in which
65+
case you might prefer to manually query for unmatched rows.
66+
</para>
67+
</listitem>
68+
69+
<listitem>
70+
<!--
71+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
72+
Branch: master [55173d2e6] 2020-02-07 18:27:18 -0300
73+
Branch: REL_12_STABLE [2c80a656c] 2020-02-07 18:27:18 -0300
74+
-->
75+
<para>
76+
Fix failure to attach foreign key constraints to sub-partitions
77+
(Jehan-Guillaume de Rorthais)
78+
</para>
79+
80+
<para>
81+
When adding a partition to a level below the first level of a
82+
multi-level partitioned table, foreign key constraints referencing
83+
the top partitioned table were not cloned to the new partition,
84+
leading to possible constraint violations later. Detaching and
85+
re-attaching the new partition is the cheapest way to fix this.
86+
However, if there are many partitions to be fixed, adding a new
87+
instance of the foreign key constraint might be preferable.
6588
</para>
6689
</listitem>
6790

@@ -413,6 +436,10 @@ Branch: REL_10_STABLE [ab64b474d] 2019-11-20 00:05:42 +0300
413436
Branch: REL9_6_STABLE [99f5888d3] 2019-11-19 23:47:29 +0300
414437
Branch: REL9_5_STABLE [4fc485684] 2019-11-20 00:01:55 +0300
415438
Branch: REL9_4_STABLE [1414821e1] 2019-11-20 00:03:04 +0300
439+
Author: Tom Lane <tgl@sss.pgh.pa.us>
440+
Branch: master [4093ff573] 2020-02-09 12:02:57 -0500
441+
Branch: REL_12_STABLE [baf487123] 2020-02-09 12:02:57 -0500
442+
Branch: REL_11_STABLE [f91706b00] 2020-02-09 12:02:57 -0500
416443
-->
417444
<para>
418445
Fix handling of deleted pages in GIN indexes (Alexander Korotkov)
@@ -605,6 +632,7 @@ Branch: REL_12_STABLE [5a6eea092] 2019-11-13 15:53:53 -0500
605632
Author: Fujii Masao <fujii@postgresql.org>
606633
Branch: master [cb5b28613] 2020-02-07 22:06:31 +0900
607634
Branch: REL_12_STABLE [598b466e8] 2020-02-07 22:07:44 +0900
635+
Branch: REL_12_STABLE [4faea7fdf] 2020-02-08 12:29:38 +0900
608636
-->
609637
<para>
610638
Avoid treating TID scans as sequential scans (Tatsuhito Kasahara)
@@ -1262,7 +1290,7 @@ Branch: REL_11_STABLE [7ad544fd8] 2019-12-06 15:14:31 +0900
12621290
Fix <application>configure</application>'s probe for
12631291
OpenSSL's <function>SSL_clear_options()</function> function so that
12641292
it works with OpenSSL versions before 1.1.0 (Michael Paquier, Daniel
1265-
Gustaffson)
1293+
Gustafsson)
12661294
</para>
12671295

12681296
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp