On Thu, Oct 9, 2025 at 12:30 PM Peter Smith <[email protected]> wrote: > > I think the "ALTER SUBSCRIPTION sub REFRESH PUBLICATION" command has > the word PUBLICATION in it because it's the PUBLICATION has changed > (stuff added/removed), so we need to refresh it. > > OTOH, the synchronisation of *existing* sequences is different - this > is more like the subscription saying "Just get me updated values for > the sequences I already know about". Therefore, I don't think the word > PUBLICATION is relevant here. > > ~~ > > So my suggestion is very different. Just this: > "ALTER SUBSCRIPTION sub REFRESH SEQUENCES" > > I feel this is entirely consistent, because: > > PUBLICATION objects have changed. Refresh me the new objects => ALTER > SUBSCRIPTION sub REFRESH PUBLICATION; > > SEQUENCE values have changed. Refresh me the new values => ALTER > SUBSCRIPTION sub REFRESH SEQUENCES;
I prefer this suggestion over the previous proposal so +1 from my side. -- Regards, Dilip Kumar Google
