Re: Logical Replication of sequences

On Tue, 29 Apr 2025 at 06:15, Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
>
> Hi Vignesh.
>
> Some trivial review comments for DOCS patch v20250428-0005.
>
> ======
> doc/src/sgml/logical-replication.sgml
>
> 1.
> + Publications may currently only contain tables or sequences. Objects must be
> + added explicitly, except when a publication is created using
> + <literal>FOR TABLES IN SCHEMA</literal>, or <literal>FOR ALL
> TABLES</literal>,
> + or <literal>FOR ALL SEQUENCES</literal>. Unlike tables, the current state of
> + sequences may be synchronised at any time. For more information, refer to
> + <xref linkend="logical-replication-sequences"/>.
> </para>
>
> AFAIK the PostgreSQL documentation uses US spelling:
>
> /synchronised/synchronized/
>
> ~~~
>
> 2.
> + Incremental sequence changes are not replicated. Although the data in
> + serial or identity columns backed by sequences will of course be
> + replicated as part of the table, the sequences themselves do not replicate
> + ongoing changes. On the subscriber, a sequence will retain the last value
>
> I didn't think that you needed to say "of course" here.

Thanks for the comments, the updated patch has the changes for the same.

Regards,
Vignesh