Re: Dropping publication breaks logical replication

From: vignesh C <vignesh21(at)gmail(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Subject: Re: Dropping publication breaks logical replication
Date: 2025-08-05 11:18:32
Message-ID: CALDaNm0B9d+vB-B7up-8XKFkpOK4GUBTwHu1kY6SWP8dAHfH6Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 4 Aug 2025 at 09:47, Ashutosh Bapat
<ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> wrote:
>
> Hi Vignesh,
> Thanks for the patches.
>
> On Sat, Aug 2, 2025 at 7:10 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:
>
> > >
> > > The backport seems to be straight forward. Please let me know if you
> > > need my help in doing so, if we decide to backport the fix.
> >
> > Now that this has been reported on the back branches, we should
> > consider whether it's appropriate to backport the fix. Here are the
> > patches prepared for the back branches.
>
> PG14 and + patches do not test that DROP PUBLICATION does not disrupt
> the publication. I think we need to test that as well.

The attached v3 version patch has the changes for the same.

Regards,
Vignesh

Attachment Content-Type Size
v3_PG13-0001-Fix-ALTER-SUBSCRIPTION-.-SET-PUBLICATION.patch application/octet-stream 5.0 KB
v3_PG16-0001-Fix-ALTER-SUBSCRIPTION-.-SET-PUBLICATION-.-c.patch application/octet-stream 5.2 KB
v3_PG14-0001-Fix-ALTER-SUBSCRIPTION-.-SET-PUBLICATION-.-c.patch application/octet-stream 5.3 KB
v3_PG15-0001-Fix-ALTER-SUBSCRIPTION-.-SET-PUBLICATION-.-c.patch application/octet-stream 5.2 KB
v3_PG17-0001-Fix-ALTER-SUBSCRIPTION-.-SET-PUBLICATION-.-c.patch application/octet-stream 5.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2025-08-05 11:21:51 Re: amcheck support for BRIN indexes
Previous Message Álvaro Herrera 2025-08-05 11:09:57 don't include tableam.h in nbtree.h