Re: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Japin Li <japinli(at)hotmail(dot)com>
Subject: Re: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION
Date: 2021-08-24 08:37:59
Message-ID: CAA4eK1L+wywmEi+oE2Rb4VBLC8HvD6HvzQ=Sb8pJcc=Ot=w0Yg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 24, 2021 at 7:13 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> On Tue, Aug 24, 2021 at 10:01 AM houzj(dot)fnst(at)fujitsu(dot)com
> <houzj(dot)fnst(at)fujitsu(dot)com> wrote:
> >
> >
> >
> > > -----Original Message-----
> > > From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
> > > Sent: Tuesday, August 24, 2021 8:52 AM
> > >
> > > Thanks. The patch for HEAD looks good to me. Regarding the patch for PG14, I
> > > think we need to update the comment as well:
> > >
> > > @@ -987,7 +986,7 @@ AlterSubscription(AlterSubscriptionStmt *stmt, bool
> > > isTopLevel)
> > > PreventInTransactionBlock(isTopLevel, "ALTER SUBSCRIPTION with
> > > refresh");
> > >
> > > /* Only refresh the added/dropped list of publications. */
> > > - sub->publications = stmt->publication;
> > > + sub->publications = publist;
> > >
> >
> > Thanks for the comment, attach new version patch which fixed it.
>
> Thank you for updating the patch! Looks good to me.
>

Pushed!

--
With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shruthi Gowda 2021-08-24 09:10:04 Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce)
Previous Message Peter Eisentraut 2021-08-24 08:28:24 Re: Mark all GUC variable as PGDLLIMPORT