Re: Dropping publication breaks logical replication

From: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
To: vignesh C <vignesh21(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-04 13:53:38
Message-ID: CAExHW5u4hyqANz7SfPV_WQEy_GJMfhBYWsOSHc8pHMxHuSs=Vg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Aug 4, 2025 at 4:08 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:
>
> 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.
>
> Currently, the test across all branches except PG13 is the same test
> used in the master branch. For PG13, since there was no existing
> subscription, I modified the test slightly to accommodate that. If I
> handle the comment you suggest, the test in master and the backbranch
> will be different. Should we keep the test similar to the master or is
> it ok to address your above comment and keep it different?

IMO we should modify the test on master as well and either backpatch
both commits or backpatch after combining those two commits.

--
Best Wishes,
Ashutosh Bapat

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2025-08-04 14:10:23 Typo in create_index regression test
Previous Message Tom Lane 2025-08-04 13:51:01 Re: GB18030-2022 Support in PostgreSQL