| 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 |
| 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:18:49 | Re: pgsql: Implement pg_wal_replay_wait() stored procedure |