Feedback-ID: ia2694551:Fastmail
Date: Tue, 5 Nov 2024 13:02:55 +0100
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Robert Haas <robertmhaas@gmail.com>, 
	Amit Langote <amitlangote09@gmail.com>
Subject: Re: doc fail about ALTER TABLE ATTACH re. NO INHERIT
Message-ID: <202411051202.enhnrcu2cyf3@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="tal3pbhdxaiv6u7z"
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <202411051201.zody6mld7vkw@alvherre.pgsql>
Archived-At: <https://www.postgresql.org/message-id/202411051202.enhnrcu2cyf3%40alvherre.pgsql>
Precedence: bulk


--tal3pbhdxaiv6u7z
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit

On 2024-Nov-05, Alvaro Herrera wrote:

> All in all, I think this text serves no purpose and should be removed
> (from all live branches), as in the attached patch.

Attached here.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"Los cuentos de hadas no dan al niño su primera idea sobre los monstruos.
Lo que le dan es su primera idea de la posible derrota del monstruo."
                                                   (G. K. Chesterton)

--tal3pbhdxaiv6u7z
Content-Type: text/x-diff; charset=utf-8
Content-Disposition: attachment;
	filename="0001-doc-Remove-incorrect-assertion-about-ALTER-TABLE-fai.patch"

From 718c3e17a76f4adf219f4e1d1aaf79766efaeb02 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?=C3=81lvaro=20Herrera?= <alvherre@alvh.no-ip.org>
Date: Tue, 5 Nov 2024 12:52:47 +0100
Subject: [PATCH] doc: Remove incorrect assertion about ALTER TABLE failing

---
 doc/src/sgml/ref/alter_table.sgml | 4 ----
 1 file changed, 4 deletions(-)

diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml
index 36770c012a6..c054530e723 100644
--- a/doc/src/sgml/ref/alter_table.sgml
+++ b/doc/src/sgml/ref/alter_table.sgml
@@ -1026,10 +1026,6 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
       <literal>UNIQUE</literal> and <literal>PRIMARY KEY</literal> constraints
       from the parent table will be created in the partition, if they don't
       already exist.
-      If any of the <literal>CHECK</literal> constraints of the table being
-      attached are marked <literal>NO INHERIT</literal>, the command will fail;
-      such constraints must be recreated without the
-      <literal>NO INHERIT</literal> clause.
      </para>
 
      <para>
-- 
2.39.5


--tal3pbhdxaiv6u7z--