Re: Include sequences in publications created by pg_createsubscriber - Mailing list pgsql-hackers

From vignesh C
Subject Re: Include sequences in publications created by pg_createsubscriber
Date
Msg-id CALDaNm0wW8Y-0EixBcJZZMphD1vcWg_dWdMyOjodB_U-ScxJPg@mail.gmail.com
Whole thread
In response to Re: Include sequences in publications created by pg_createsubscriber  (Peter Smith <smithpb2250@gmail.com>)
Responses Re: Include sequences in publications created by pg_createsubscriber
Re: Include sequences in publications created by pg_createsubscriber
List pgsql-hackers
On Thu, 9 Jul 2026 at 07:07, Peter Smith <smithpb2250@gmail.com> wrote:
>
> Some review comments for v8
>
> ======
> doc/src/sgml/ref/pg_createsubscriber.sgml
>
> 1.
> +   which ensures each table is brought up to a synchronized state. When using
> +   internally generated publications, the publications automatically include
> +   all sequences in the database; however, sequence values are not
> +   automatically synchronized.
>
> Maybe "automatically" 2x in the same sentence is a bit much. The rest
> can also be simpler.
>
> SUGGESTION
> Internally generated publications include all sequences in the
> database, but their values are not automatically synchronized.
>
> ~~~
>
> 2.
> +      objects defined by that publication. Otherwise,
> +      <application>pg_createsubscriber</application> creates a publication
> +      using <link linkend="sql-createpublication-params-for-all-tables">
> +      <literal>FOR ALL TABLES</literal></link> and <link
> +      linkend="sql-createpublication-params-for-all-sequences"> <literal>ALL
> +      SEQUENCES</literal></link>. These generated publications has the
> +      following name pattern:
>
> 2a.
> The space before the last <literal> tag here is probably not deliberate.
>
> ~
>
> 2b.
> typo: /has the/have the/

Thanks for the comments, the attached v9 version patch has the changes
for the same.

Regards,
Vignesh

Attachment

pgsql-hackers by date:

Previous
From: Shlok Kyal
Date:
Subject: Re: PSQL - prevent describe listing tables that are already in listed schemas
Next
From: Akshay Joshi
Date:
Subject: Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements