Feedback-ID: ia2694551:Fastmail
Date: Wed, 7 Aug 2024 18:22:39 -0400
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Tender Wang <tndrwang@gmail.com>
Cc: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18541: Reattaching a partition referenced by a foreign key
 fails with an error
Message-ID: <202408072222.icgykv5yrql5@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="oookcz4qaoqowmni"
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAHewXNkcJo3d9Qj00FGof9dpHg8A4W9x-XJx9EsfrS8w7M395Q@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/202408072222.icgykv5yrql5%40alvherre.pgsql>
Precedence: bulk


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

On 2024-Jul-15, Tender Wang wrote:

> PG Bug reporting form <noreply@postgresql.org> 于2024年7月15日周一 21:02写道：

> > The following script:
> > CREATE TABLE t1 (a int, PRIMARY KEY (a));
> > CREATE TABLE t (a int, PRIMARY KEY (a), FOREIGN KEY (a) REFERENCES t1)
> > PARTITION BY LIST (a);
> > ALTER TABLE t ATTACH PARTITION t1 FOR VALUES IN (1);

I propose to reject this with the attached patch, which I intend to
backpatch all the way down to 12.

FWIW, it's not the same problem that Jehan-Guillaume described in [1],
even though the error message being thrown is the same.

[1] https://postgr.es/m/20230705233028.2f554f73@karst

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/

--oookcz4qaoqowmni
Content-Type: text/x-diff; charset=utf-8
Content-Disposition: attachment;
	filename="0001-Refuse-ATTACH-of-a-table-referenced-by-a-foreign-key.patch"