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-26T08:48:35Z
Lists: pgsql-hackers

Attachments

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

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

The set of patch for REL_17_STABLE apply on REL_16_STABLE with no effort.

I've been able to backpatch on REL_15_STABLE with minimal effort. See
attachments.

REL_14_STABLE backport doesn't seem trivial, so I'll wait for some feedback,
review & decision before going further down in backpatching.

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