Re: Fix sequence membership command in PG19 release notes

From: vignesh C <vignesh21(at)gmail(dot)com>
To: rh(at)vonng(dot)com
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Fix sequence membership command in PG19 release notes
Date: 2026-10-22 15:58:31
Message-ID: CALDaNm1agomELtDDqdF4KnAp6s6nKBMjU7VpmKQGh_o69XQTkg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Fri, 16 Oct 2026 at 17:03, <rh(at)vonng(dot)com> wrote:
>
> The PG19 release-note entry about synchronizing sequence membership [1]
> attributes that operation to REFRESH SEQUENCES. It should refer to
> REFRESH PUBLICATION.
>
> REFRESH PUBLICATION adds and removes sequence entries in
> pg_subscription_rel. REFRESH SEQUENCES instead resets existing sequence
> entries to INIT for value resynchronization, without changing which
> sequences are subscribed.
>
> This matches the ALTER SUBSCRIPTION reference [2] and the documentation
> clarification committed as 19fbb47ef685 [3]. That commit did not update
> release-19.sgml.
>
> The attached one-line patch changes the command name in that sentence.
> It is based on REL_19_STABLE at a66ab9a9d382 and passes git apply --check.

Thanks for the patch, one suggestion, how about we mention something like:
This is done by REFRESH PUBLICATION and by ADD PUBLICATION, DROP
PUBLICATION, and SET PUBLICATION, which add newly published sequences
to the subscription and remove dropped ones. REFRESH SEQUENCES does
not change which sequences are subscribed.

Regards,
Vignesh

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2026-10-23 04:37:38 Re: Fixes for create subscription page
Previous Message Matemática A3K 2026-10-21 14:09:03 Re: [Minor] Improvement on random functions doc