On Sat, Aug 7, 2021 at 6:53 PM houzj.f...@fujitsu.com <houzj.f...@fujitsu.com> wrote: > > On Sat, Aug 7, 2021 1:36 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > On Fri, Aug 6, 2021 at 9:57 PM Japin Li <japi...@hotmail.com> wrote: > > > > Do you mean to say that do it for both Add and Drop or just for Drop? > > Actually, doing it both will make the behavior consistent but doing it just > > for > > Drop might be preferable by some users. I think it is better to be > > consistent here > > but I am fine if you and others feel it is better to refresh all > > publications only in > > Drop case. > > 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. >
There is a bug reported on pgsql-bugs [1] which seems to be happening due to the same reason. Can you please test that the other bug is also fixed with your patch? [1] - https://www.postgresql.org/message-id/17132-6a702189086c6243%40postgresql.org -- With Regards, Amit Kapila.