Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails

Tender Wang <tndrwang@gmail.com>

From: Tender Wang <tndrwang@gmail.com>

To: Alvaro Herrera <alvherre@alvh.no-ip.org>

Cc: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, Alexander Lakhin <exclusion@gmail.com>

Date: 2024-07-23T02:15:47Z

Lists: pgsql-hackers

Alvaro Herrera <alvherre@alvh.no-ip.org> 于2024年7月19日周五 21:18写道：

>
> I find this pair of queries useful; they show which constraints exist
> and which triggers belong to each.  We need to make the constraints and
> triggers match after a detach right as things would be if the
> just-detached partition were an individual table having the same foreign
> key.
>

I don't find the useful queries in your last email. Can you provide them.
Thanks.


-- 
Tender Wang

Commits

Fix some more bugs in foreign keys connecting partitioned tables
- f7d510a38245 16.5 landed
- 936ab6de9595 17.1 landed
- 2d5fe514052a 18.0 landed
- 1b216fceffe3 15.9 landed
Restructure foreign key handling code for ATTACH/DETACH
- d20194cead75 13.17 landed
- 5d83bad6b87d 15.9 landed
- 5914a22f6ea5 17.1 landed
- 53af9491a043 18.0 landed
- 46a8c27a7226 14.14 landed
- 2aaf2a28b87e 16.5 landed
Create foreign key triggers in partitioned tables too
- f4566345cf40 15.0 cited