8000 doc PG 18 relnotes: move and clarify constraint items · postgres/postgres@d83981c · GitHub
[go: up one dir, main page]
Skip to content

Commit d83981c

Browse files
bmomjianbmomjian
committed
doc PG 18 relnotes: move and clarify constraint items
Reported-by: Álvaro Herrera Discussion: https://postgr.es/m/202505041135.cpo7zgdcya2u@alvherre.pgsql
1 parent 8c9eec5 commit d83981c

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 of constraints ONLY on partitioned t
1586+
2025-04-07 [a379061a2] Allow NOT NULL constraints to 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 of NOT NULL constraints (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 column NOT NULL specifications in pg_constraint (Álvaro Herrera, Bernd Helmle)
1636-
<ulink url="&commit_baseurl;14e87ffa5">&sect;</ulink>
1622+
Allow NOT VALID 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)
0