Re: Logical Replication of sequences - Mailing list pgsql-hackers

From Peter Smith
Subject Re: Logical Replication of sequences
Date
Msg-id CAHut+PtNW1WfbWWpOk480PM3oVxsvufQuADYsk=RHeZe3NzQgg@mail.gmail.com
Whole thread Raw
In response to Re: Logical Replication of sequences  (vignesh C <vignesh21@gmail.com>)
List pgsql-hackers
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.

======
Kind Regards,
Peter Smith.
Fujitsu Australia



pgsql-hackers by date:

Previous
From: Steve Chavez
Date:
Subject: Re: Allow database owners to CREATE EVENT TRIGGER
Next
From: Noah Misch
Date:
Subject: Re: type cache cleanup improvements