Re: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
Japin Li <japinli@hotmail.com>
Date: 2021-08-23T12:01:17Z
Lists: pgsql-hackers
Attachments
- v6-0001-Fix-Alter-Subscription-Add-Drop-Publication-refre.patch (application/octet-stream) patch v6-0001
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. -- 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