MIME-Version: 1.0
From: Peter Smith <smithpb2250@gmail.com>
Date: Thu, 25 Jun 2026 12:51:44 +1200
Message-ID: 
 <CAHut+PsrVntfrJ8gV45+6=1bs5dTWD5mU7Q6aKrBnf1vmyZQkQ@mail.gmail.com>
Subject: DOCS - clarify CREATE SUBSCRIPTION only synchronizes sequences when
 copy_data=true
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
 vignesh C <vignesh21@gmail.com>
Content-Type: multipart/mixed; boundary="00000000000006802e0655096744"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHut%2BPsrVntfrJ8gV45%2B6%3D1bs5dTWD5mU7Q6aKrBnf1vmyZQkQ%40mail.gmail.com>
Precedence: bulk

--00000000000006802e0655096744
Content-Type: text/plain; charset="UTF-8"

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.

======
[1] https://www.postgresql.org/docs/19/logical-replication-sequences.html

Kind Regards,
Peter Smith.
Fujitsu Australia

--00000000000006802e0655096744
Content-Type: application/octet-stream;
	name="v1-0001-DOCS-clarify-copy_data-is-needed-to-synchronise-s.patch"
Content-Disposition: attachment;
	filename="v1-0001-DOCS-clarify-copy_data-is-needed-to-synchronise-s.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mqssalud0>
X-Attachment-Id: f_mqssalud0

RnJvbSAyZjI0YzY2Y2I4ZmRhYTBkNDRhZWFiYTE0MzdlZjFmMTIzYzcwYTk2IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBTbWl0aCA8cGV0ZXIuYi5zbWl0aEBmdWppdHN1LmNv
bT4KRGF0ZTogVGh1LCAyNSBKdW4gMjAyNiAxMjo0NDoxOCArMTIwMApTdWJqZWN0OiBbUEFUQ0gg
djFdIERPQ1MgLSBjbGFyaWZ5IGNvcHlfZGF0YSBpcyBuZWVkZWQgdG8gc3luY2hyb25pc2UKIHNl
cXVlbmNlcwoKLS0tCiBkb2Mvc3JjL3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sIHwgNSAr
KystLQogMSBmaWxlIGNoYW5nZWQsIDMgaW5zZXJ0aW9ucygrKSwgMiBkZWxldGlvbnMoLSkKCmRp
ZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sIGIvZG9jL3Ny
Yy9zZ21sL2xvZ2ljYWwtcmVwbGljYXRpb24uc2dtbAppbmRleCA5ZTc4Njg0ODdkZS4uYzE3MjFi
YTExYjYgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9sb2dpY2FsLXJlcGxpY2F0aW9uLnNnbWwK
KysrIGIvZG9jL3NyYy9zZ21sL2xvZ2ljYWwtcmVwbGljYXRpb24uc2dtbApAQCAtMTc2OCw4ICsx
NzY4LDkgQEAgSW5jbHVkZWQgaW4gcHVibGljYXRpb25zOgogICAgPGl0ZW1pemVkbGlzdD4KICAg
ICA8bGlzdGl0ZW0+CiAgICAgIDxwYXJhPgotICAgICAgdXNlIDxsaW5rIGxpbmtlbmQ9InNxbC1j
cmVhdGVzdWJzY3JpcHRpb24iPjxjb21tYW5kPkNSRUFURSBTVUJTQ1JJUFRJT048L2NvbW1hbmQ+
PC9saW5rPgotICAgICAgdG8gaW5pdGlhbGx5IHN5bmNocm9uaXplIHRoZSBwdWJsaXNoZWQgc2Vx
dWVuY2VzLgorICAgICAgdXNlIDxsaW5rIGxpbmtlbmQ9InNxbC1jcmVhdGVzdWJzY3JpcHRpb24t
cGFyYW1zLXdpdGgtY29weS1kYXRhIj4KKyAgICAgIDxjb21tYW5kPkNSRUFURSBTVUJTQ1JJUFRJ
T04gLi4uIFdJVEggKGNvcHlfZGF0YSA9IHRydWUpPC9jb21tYW5kPgorICAgICAgPC9saW5rPnRv
IGluaXRpYWxseSBzeW5jaHJvbml6ZSB0aGUgcHVibGlzaGVkIHNlcXVlbmNlcy4KICAgICAgPC9w
YXJhPgogICAgIDwvbGlzdGl0ZW0+CiAgICAgPGxpc3RpdGVtPgotLSAKMi40Ny4zCgo=
--00000000000006802e0655096744--