Horton

Re: BUG #18541: Reattaching a partition referenced by a foreign key fails with an error

Tender Wang <tndrwang@gmail.com>

View thread View on postgr.es
From: Tender Wang <tndrwang@gmail.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2024-08-08T14:27:49Z
Lists: pgsql-bugs 
Alvaro Herrera <alvherre@alvh.no-ip.org> 于2024年8月8日周四 06:22写道：

> 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.
>

Thanks for explanation. The attached patch looks good to me.


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

-- 
Tender Wang

Commits

  1. Restructure foreign key handling code for ATTACH/DETACH

  2. Refuse ATTACH of a table referenced by a foreign key