Re: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
Japin Li <japinli@hotmail.com>
Date: 2021-08-24T08:37:59Z
Lists: pgsql-hackers
On Tue, Aug 24, 2021 at 7:13 AM Masahiko Sawada <sawada.mshk@gmail.com> wrote: > > On Tue, Aug 24, 2021 at 10:01 AM houzj.fnst@fujitsu.com > <houzj.fnst@fujitsu.com> wrote: > > > > > > > > > -----Original Message----- > > > From: Masahiko Sawada <sawada.mshk@gmail.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.
Commits
-
Fix Alter Subscription's Add/Drop Publication behavior.
- 5cfcd46e9d29 14.0 landed
- 1046a69b3087 15.0 landed
-
ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION
- 82ed7748b710 14.0 cited