Horton
Menu

Re: BUG #18741: Detaching a partition referencing a partitioned table fails with a trigger-related error

Tender Wang <tndrwang@gmail.com>

View thread
From: Tender Wang <tndrwang@gmail.com>
To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2025-05-03T01:22:48Z
Lists: pgsql-bugs 
PG Bug reporting form <noreply@postgresql.org> 于2024年12月8日周日 22:43写道：

> The following bug has been logged on the website:
>
> Bug reference:      18741
> Logged by:          Alexander Lakhin
> Email address:      exclusion@gmail.com
> PostgreSQL version: 17.2
> Operating system:   Ubuntu 22.04
> Description:
>
> The following script:
> CREATE TABLE pt1 (a int PRIMARY KEY) PARTITION BY RANGE (a);
> CREATE TABLE p1 PARTITION OF pt1 FOR VALUES FROM (0) TO (1);
>
> CREATE TABLE pt2 (a int) PARTITION BY RANGE (a);
> CREATE TABLE p2 (a int, FOREIGN KEY (a) REFERENCES pt1);
>
> ALTER TABLE pt2 ATTACH PARTITION p2 FOR VALUES FROM (0) TO (1);
> ALTER TABLE pt2 DETACH PARTITION p2;
>
> fails with:
> ERROR:  XX000: could not find ON INSERT check triggers of foreign key
> constraint 16404
> LOCATION:  GetForeignKeyCheckTriggers, tablecmds.c:11355
>
> Reproduced on REL_15_STABLE (starting from f4566345c) .. master.
>
>
Hi,

This issue can't be reproduced on HEAD. I guess a commit happened to solve
this problem.
-- 
Thanks,
Tender Wang