On Thu, 25 Jun 2026 at 06:22, Peter Smith <[email protected]> wrote: > > While reviewing another patch I referred to the information of "29.7. > Replicating Sequences #" [1] which says: > "use CREATE SUBSCRIPTION to initially synchronize the published sequences." > > AFAIK, that is not entirely correct -- synchronisation of sequences > happens only when the "copy_data" option is true. Although copy_data > default is true, the original text was misleading. Anyway, it misled > me. > > PSA a patch to clarify that "copy_data = true" is needed.
Let's include this to avoid confusion. Few comments: 1) There should be a space after </link>: + use <link linkend="sql-createsubscription-params-with-copy-data"> + <command>CREATE SUBSCRIPTION ... WITH (copy_data = true)</command> + </link>to initially synchronize the published sequences. 2) copy_data = true is the default, so it may mislead users into thinking they must explicitly specify it. How about changing it to: use CREATE SUBSCRIPTION with the default copy_data = true behavior to initially synchronize the published sequences. Regards, Vignesh
