RE: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION - Mailing list pgsql-hackers

From houzj.fnst@fujitsu.com
Subject RE: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION
Date
Msg-id OS0PR01MB57166E176291CBA84CD2060594C49@OS0PR01MB5716.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
On Mon, Aug 23, 2021 8:01 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> On Mon, Aug 23, 2021 at 2:45 PM houzj.fnst@fujitsu.com<houzj.fnst@fujitsu.com> wrote:
> >
> > On Mon, Aug 23, 2021 12:59 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> > >
> > > On Sat, Aug 7, 2021 at 6:53 PM houzj.fnst@fujitsu.com <houzj.fnst@fujitsu.com> wrote:
> > > >
> > > > Personally, I also think it will be better to make the behavior consistent.
> > > > Attach the new version patch make both ADD and DROP behave the
> > > > same as SET PUBLICATION which refresh all the publications.
> > > >
> > >
> > > I think we can have tests in the separate test file
> > > (alter_sub_pub.pl) like you earlier had in one of the versions. Use
> > > some meaningful names for tables instead of temp1, temp2 as you had in the
> previous version.
> > > Otherwise, the code changes look good to me.
> >
> > Thanks for the comment.
> > Attach new version patch which did the following changes.
> >
> > * move the tests to a separate test file (024_alter_sub_pub.pl)
> > * adjust the document of copy_data option
> > * add tab-complete for copy_data option when ALTER DROP publication.
> >
> 
> Thanks, the patch looks good to me. I have made some cosmetic changes in the
> attached version. It makes the test cases easier to understand.
> I am planning to push this tomorrow unless there are more comments or
> suggestions.

Thanks ! The patch looks good to me.

I noticed that the patch cannot be applied to PG14-stable,
so I attach a separate patch for back-patch(I didn’t change the patch for HEAD branch).

Best regards,
Hou zj



Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: .ready and .done files considered harmful
Next
From: Robert Haas
Date:
Subject: Re: Queries that should be canceled will get stuck on secure_write function