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

Commitd83981c

Browse files
committed
doc PG 18 relnotes: move and clarify constraint items
Reported-by: Álvaro HerreraDiscussion:https://postgr.es/m/202505041135.cpo7zgdcya2u@alvherre.pgsql
1 parent8c9eec5 commitd83981c

File tree

1 file changed

+35
-36
lines changed

1 file changed

+35
-36
lines changed

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

Lines changed: 35 additions & 36 deletions
Original file line numberDiff line numberDiff line change
@@ -1530,23 +1530,6 @@ This is specified by WITHOUT OVERLAPS on the last column.
15301530
</para>
15311531
</listitem>
15321532

1533-
1534-
<!--
1535-
Author: Peter Eisentraut <peter@eisentraut.org>
1536-
2024-11-15 [9321d2fdf] Fix collation handling for foreign keys
1537-
-->
1538-
1539-
<listitem>
1540-
<para>
1541-
Require primary/foreign key relationships to use either deterministic collations or the the same nondeterministic collations (Peter Eisentraut)
1542-
<ulink url="&commit_baseurl;9321d2fdf">&sect;</ulink>
1543-
</para>
1544-
1545-
<para>
1546-
The restore of a pg_dump, also used by pg_upgrade, will fail if these requirements are not met; schema changes must be made for these upgrade methods to succeed.
1547-
</para>
1548-
</listitem>
1549-
15501533
<!--
15511534
Author: Peter Eisentraut <peter@eisentraut.org>
15521535
2025-01-11 [ca87c415e] Add support for NOT ENFORCED in CHECK constraints
@@ -1567,42 +1550,46 @@ This also adds column pg_constraint.conenforced.
15671550
</listitem>
15681551

15691552
<!--
1570-
Author:Álvaro Herrera <alvherre@alvh.no-ip.org>
1571-
2025-04-07 [a379061a2] Allow NOT NULL constraints to be added as NOT VALID
1553+
Author:Peter Eisentraut <peter@eisentraut.org>
1554+
2024-11-15 [9321d2fdf] Fix collation handling for foreign keys
15721555
-->
15731556

15741557
<listitem>
15751558
<para>
1576-
Allow ALTER TABLE to set the NOT VALID attribute of NOT NULL constraints (Rushabh Lathia, Jian He)
1577-
<ulink url="&commit_baseurl;a379061a2">&sect;</ulink>
1559+
Require primary/foreign key relationships to use either deterministic collations or the the same nondeterministic collations (Peter Eisentraut)
1560+
<ulink url="&commit_baseurl;9321d2fdf">&sect;</ulink>
1561+
</para>
1562+
1563+
<para>
1564+
The restore of a pg_dump, also used by pg_upgrade, will fail if these requirements are not met; schema changes must be made for these upgrade methods to succeed.
15781565
</para>
15791566
</listitem>
15801567

15811568
<!--
15821569
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
1583-
2025-01-23 [b663b9436] Allow NOT VALID foreign key constraints on partitioned t
1570+
2024-11-08 [14e87ffa5] Add pg_constraint rows for not-null constraints
15841571
-->
15851572

15861573
<listitem>
15871574
<para>
1588-
Allow NOT VALID foreign key constraints on partitioned tables (Amul Sul)
1589-
<ulink url="&commit_baseurl;b663b9436">&sect;</ulink>
1575+
Store column NOT NULL specifications in pg_constraint (Álvaro Herrera, Bernd Helmle)
1576+
<ulink url="&commit_baseurl;14e87ffa5">&sect;</ulink>
1577+
</para>
1578+
1579+
<para>
1580+
This allows names to be specified for NOT NULL constraint. This also adds NOT NULL constraints to foreign tables and NOT NULL inheritance control to local tables.
15901581
</para>
15911582
</listitem>
15921583

15931584
<!--
15941585
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
1595-
2024-09-30 [4dea33ce7] Don't disallow DROP ofconstraintsONLY on partitioned t
1586+
2025-04-07 [a379061a2] Allow NOT NULLconstraintsto be added as NOT VALID
15961587
-->
15971588

15981589
<listitem>
15991590
<para>
1600-
Allow dropping of constraints ONLY on partitioned tables (Álvaro Herrera)
1601-
<ulink url="&commit_baseurl;4dea33ce7">&sect;</ulink>
1602-
</para>
1603-
1604-
<para>
1605-
This was previously erroneously prohibited.
1591+
Allow ALTER TABLE to set the NOT VALID attribute of NOT NULL constraints (Rushabh Lathia, Jian He)
1592+
<ulink url="&commit_baseurl;a379061a2">&sect;</ulink>
16061593
</para>
16071594
</listitem>
16081595

@@ -1615,7 +1602,7 @@ Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
16151602

16161603
<listitem>
16171604
<para>
1618-
Allow modification of the inheritability of constraints (Suraj Kharage, Álvaro Herrera)
1605+
Allow modification of the inheritability ofNOT NULLconstraints (Suraj Kharage, Álvaro Herrera)
16191606
<ulink url="&commit_baseurl;f4e53e10b">&sect;</ulink>
16201607
<ulink url="&commit_baseurl;4a02af8b1">&sect;</ulink>
16211608
</para>
@@ -1627,17 +1614,29 @@ The syntax is ALTER TABLE ... ALTER CONSTRAINT ... [NO] INHERIT.
16271614

16281615
<!--
16291616
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
1630-
2024-11-08 [14e87ffa5] Add pg_constraint rows for not-null constraints
1617+
2025-01-23 [b663b9436] Allow NOT VALID foreign key constraints on partitioned t
16311618
-->
16321619

16331620
<listitem>
16341621
<para>
1635-
Store columnNOTNULL specifications in pg_constraint (Álvaro Herrera, Bernd Helmle)
1636-
<ulink url="&commit_baseurl;14e87ffa5">&sect;</ulink>
1622+
AllowNOTVALID foreign key constraints on partitioned tables (Amul Sul)
1623+
<ulink url="&commit_baseurl;b663b9436">&sect;</ulink>
16371624
</para>
1625+
</listitem>
1626+
1627+
<!--
1628+
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
1629+
2024-09-30 [4dea33ce7] Don't disallow DROP of constraints ONLY on partitioned t
1630+
-->
16381631

1632+
<listitem>
16391633
<para>
1640-
This allows names to be specified for NOT NULL constraint. This also adds NOT NULL constraints to foreign tables and NOT NULL inheritance control to local tables.
1634+
Allow dropping of constraints ONLY on partitioned tables (Álvaro Herrera)
1635+
<ulink url="&commit_baseurl;4dea33ce7">&sect;</ulink>
1636+
</para>
1637+
1638+
<para>
1639+
This was previously erroneously prohibited.
16411640
</para>
16421641
</listitem>
16431642

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp