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

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Tender Wang <tndrwang(at)gmail(dot)com>, Junwang Zhao <zhjwpku(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Alexander Lakhin <exclusion(at)gmail(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
Date: 2024-09-26 08:48:35
Message-ID: 20240926104835.07ae9ab5@karst
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 25 Sep 2024 16:14:07 +0200
Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com> wrote:

> On Wed, 25 Sep 2024 14:42:40 +0200
> Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com> wrote:
>
> > On Thu, 5 Sep 2024 00:57:28 +0200
> > Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)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,

Attachment Content-Type Size
v3-15-0001-Add-tests-about-FK-between-partitionned-tables.patch text/x-patch 20.9 KB
v3-15-0002-Rework-foreign-key-mangling-during-ATTACH-DETA.patch text/x-patch 23.6 KB
v3-15-0003-Use-addFkConstraint-in-addFkRecurseReferencing.patch text/x-patch 8.3 KB
v3-15-0004-Use-addFkConstraint-in-CloneFkReferencing.patch text/x-patch 10.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2024-09-26 08:56:21 Re: Clock-skew management in logical replication
Previous Message Michael Paquier 2024-09-26 08:16:07 Re: Add has_large_object_privilege function