From d83981c24be76b64205158b59b6c05cf118187c3 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Sun, 4 May 2025 22:08:20 -0400
Subject: doc PG 18 relnotes: move and clarify constraint items
Reported-by: Álvaro Herrera
Discussion: https://postgr.es/m/202505041135.cpo7zgdcya2u@alvherre.pgsql
---
doc/src/sgml/release-18.sgml | 71 ++++++++++++++++++++++----------------------
1 file changed, 35 insertions(+), 36 deletions(-)
(limited to 'doc/src')
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml
index bd2b2ed6315..764c929823f 100644
--- a/doc/src/sgml/release-18.sgml
+++ b/doc/src/sgml/release-18.sgml
@@ -1530,23 +1530,6 @@ This is specified by WITHOUT OVERLAPS on the last column.
-
-
-
-
-
-Require primary/foreign key relationships to use either deterministic collations or the the same nondeterministic collations (Peter Eisentraut)
-§
-
-
-
-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.
-
-
-
-Allow ALTER TABLE to set the NOT VALID attribute of NOT NULL constraints (Rushabh Lathia, Jian He)
-§
+Require primary/foreign key relationships to use either deterministic collations or the the same nondeterministic collations (Peter Eisentraut)
+§
+
+
+
+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.
-Allow NOT VALID foreign key constraints on partitioned tables (Amul Sul)
-§
+Store column NOT NULL specifications in pg_constraint (Álvaro Herrera, Bernd Helmle)
+§
+
+
+
+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.
-Allow dropping of constraints ONLY on partitioned tables (Álvaro Herrera)
-§
-
-
-
-This was previously erroneously prohibited.
+Allow ALTER TABLE to set the NOT VALID attribute of NOT NULL constraints (Rushabh Lathia, Jian He)
+§
@@ -1615,7 +1602,7 @@ Author: Álvaro Herrera
-Allow modification of the inheritability of constraints (Suraj Kharage, Álvaro Herrera)
+Allow modification of the inheritability of NOT NULL constraints (Suraj Kharage, Álvaro Herrera)
§
§
@@ -1627,17 +1614,29 @@ The syntax is ALTER TABLE ... ALTER CONSTRAINT ... [NO] INHERIT.
-Store column NOT NULL specifications in pg_constraint (Álvaro Herrera, Bernd Helmle)
-§
+Allow NOT VALID foreign key constraints on partitioned tables (Amul Sul)
+§
+
+
+
+
-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.
+Allow dropping of constraints ONLY on partitioned tables (Álvaro Herrera)
+§
+
+
+
+This was previously erroneously prohibited.
--
cgit v1.2.3