Horton

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

Jehan-Guillaume de Rorthais <jgdr@dalibo.com>

View thread View on postgr.es
From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Tender Wang <tndrwang@gmail.com>, Junwang Zhao <zhjwpku@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, Alexander Lakhin <exclusion@gmail.com>, Guillaume Lelarge <guillaume@lelarge.info>, Michael Paquier <michael@paquier.xyz>
Date: 2024-09-25T14:14:07Z
Lists: pgsql-hackers

Attachments

On Wed, 25 Sep 2024 14:42:40 +0200
Jehan-Guillaume de Rorthais <jgdr@dalibo.com> wrote:

> On Thu, 5 Sep 2024 00:57:28 +0200
> Jehan-Guillaume de Rorthais <jgdr@dalibo.com> wrote:
[…]
> > 
> > Please, find in attachment a patch implementing this idea.  
> 
> Please, find in attachment a set of patch based on the previous one.

Please, find in attachment the same set of patch for REL_17_STABLE.

Regards,

Commits

  1. Fix some more bugs in foreign keys connecting partitioned tables

  2. Restructure foreign key handling code for ATTACH/DETACH

  3. Create foreign key triggers in partitioned tables too