MIME-Version: 1.0
References: 
 <CAHut+PtFkGvZNihGRDoghWNKMfJufEpR9+thbG_8qPQ7RyVN4w@mail.gmail.com>
In-Reply-To: 
 <CAHut+PtFkGvZNihGRDoghWNKMfJufEpR9+thbG_8qPQ7RyVN4w@mail.gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Thu, 2 Jul 2026 12:18:16 +0530
Message-ID: 
 <CAA4eK1Jr-f1fhELi2XxF=u8NNBBNOPv7dQiNPFsd3twC1w98BA@mail.gmail.com>
Subject: Re: DOCS - Clarify that REFRESH SEQUENCES might be using stale
 publication data
To: Peter Smith <smithpb2250@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000000f8dd806559b32df"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA4eK1Jr-f1fhELi2XxF%3Du8NNBBNOPv7dQiNPFsd3twC1w98BA%40mail.gmail.com>
Precedence: bulk

--0000000000000f8dd806559b32df
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Jul 2, 2026 at 8:29=E2=80=AFAM Peter Smith <smithpb2250@gmail.com> =
wrote:
>
> The docs do refer to "currently subscribed sequences" but do not
> explicitly warn about this gotcha.
>
> PSA: a patch to add a clarifying sentence.
>

It does not add or remove
       sequences from the subscription to match the publication.
      </para>
+     <para>
+      If the publication's sequence membership has changed,
+      <link linkend=3D"sql-altersubscription-params-refresh-publication">
+      <command>ALTER SUBSCRIPTION ... REFRESH PUBLICATION</command></link>
+      should be run before <literal>REFRESH SEQUENCES</literal> to ensure =
the
+      subscription's known sequence list is current.
+     </para>

It is already mentioned that this command "does not add or remove
sequences from the subscription to match the publication.". Adding
more information, especially a separate para for the same, appears
like bloating the text in docs. OTOH, I see your point of running
REFRESH PUBLICATION before REFRESH SEQUENCES which I tried to cover in
the existing paragraph. Apart from that, I have merged your
doc-changes from another thread [1] which is on the same topic. Let's
commit them together.

[1] - https://www.postgresql.org/message-id/CAHut%2BPsrVntfrJ8gV45%2B6%3D1b=
s5dTWD5mU7Q6aKrBnf1vmyZQkQ%40mail.gmail.com

--=20
With Regards,
Amit Kapila.

--0000000000000f8dd806559b32df
Content-Type: application/octet-stream;
	name="v2-0001-doc-Clarify-sequence-synchronization-commands.patch"
Content-Disposition: attachment;
	filename="v2-0001-doc-Clarify-sequence-synchronization-commands.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mr354h0a0>
X-Attachment-Id: f_mr354h0a0

RnJvbSAzOGM2YjM4ZmIzNmNjYTdjZTlmMmRlMGY3ODdlM2EzYThmZWMyYjNiIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBBbWl0IEthcGlsYSA8YWthcGlsYUBwb3N0Z3Jlc3FsLm9yZz4K
RGF0ZTogVGh1LCAyIEp1bCAyMDI2IDExOjM1OjE2ICswNTMwClN1YmplY3Q6IFtQQVRDSCB2Ml0g
ZG9jOiBDbGFyaWZ5IHNlcXVlbmNlIHN5bmNocm9uaXphdGlvbiBjb21tYW5kcy4KCkltcHJvdmUg
dGhlIFJFRlJFU0ggU0VRVUVOQ0VTIGRlc2NyaXB0aW9uIGluIEFMVEVSIFNVQlNDUklQVElPTiB0
byBtb3JlCmFjY3VyYXRlbHkgZXhwbGFpbiBob3cgaXQgZGlmZmVycyBmcm9tIFJFRlJFU0ggUFVC
TElDQVRJT046IFJFRlJFU0gKUFVCTElDQVRJT04gc3luY2hyb25pemVzIHRoZSBzdWJzY3JpcHRp
b24ncyBzZXQgb2Ygc2VxdWVuY2VzIHdpdGggdGhlCnB1YmxpY2F0aW9uIChhZGRpbmcgbmV3IGFu
ZCByZW1vdmluZyBkcm9wcGVkIHNlcXVlbmNlcyksIHdoZXJlYXMgUkVGUkVTSApTRVFVRU5DRVMg
b25seSByZS1zeW5jaHJvbml6ZXMgZGF0YSBmb3IgdGhlIGN1cnJlbnRseSBzdWJzY3JpYmVkIHNl
cXVlbmNlcwp3aXRob3V0IGNoYW5naW5nIHdoaWNoIHNlcXVlbmNlcyBhcmUgc3Vic2NyaWJlZC4g
IEFsc28gYWR2aXNlIHJ1bm5pbmcKUkVGUkVTSCBQVUJMSUNBVElPTiBmaXJzdCB3aGVuIHRoZSBw
dWJsaWNhdGlvbidzIHNldCBvZiBzZXF1ZW5jZXMgaGFzCmNoYW5nZWQuCgpJbiB0aGUgIlJlcGxp
Y2F0aW5nIFNlcXVlbmNlcyIgc2VjdGlvbiwgbm90ZSB0aGF0IENSRUFURSBTVUJTQ1JJUFRJT04K
dXNlcyBjb3B5X2RhdGEgPSB0cnVlICh0aGUgZGVmYXVsdCkgdG8gY29weSB0aGUgaW5pdGlhbCBz
ZXF1ZW5jZSB2YWx1ZXMsCmFuZCBsaW5rIHRvIHRoZSBjb3B5X2RhdGEgcGFyYW1ldGVyLgotLS0K
IGRvYy9zcmMvc2dtbC9sb2dpY2FsLXJlcGxpY2F0aW9uLnNnbWwgICAgfCAgNCArKystCiBkb2Mv
c3JjL3NnbWwvcmVmL2FsdGVyX3N1YnNjcmlwdGlvbi5zZ21sIHwgMTAgKysrKysrLS0tLQogMiBm
aWxlcyBjaGFuZ2VkLCA5IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0
IGEvZG9jL3NyYy9zZ21sL2xvZ2ljYWwtcmVwbGljYXRpb24uc2dtbCBiL2RvYy9zcmMvc2dtbC9s
b2dpY2FsLXJlcGxpY2F0aW9uLnNnbWwKaW5kZXggZjIxMjM5YWY2YjguLjYzOTM1ZmEyZWIzIDEw
MDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sCisrKyBiL2Rv
Yy9zcmMvc2dtbC9sb2dpY2FsLXJlcGxpY2F0aW9uLnNnbWwKQEAgLTE3ODQsNyArMTc4NCw5IEBA
IEluY2x1ZGVkIGluIHB1YmxpY2F0aW9uczoKICAgICA8bGlzdGl0ZW0+CiAgICAgIDxwYXJhPgog
ICAgICAgdXNlIDxsaW5rIGxpbmtlbmQ9InNxbC1jcmVhdGVzdWJzY3JpcHRpb24iPjxjb21tYW5k
PkNSRUFURSBTVUJTQ1JJUFRJT048L2NvbW1hbmQ+PC9saW5rPgotICAgICAgdG8gaW5pdGlhbGx5
IHN5bmNocm9uaXplIHRoZSBwdWJsaXNoZWQgc2VxdWVuY2VzLgorICAgICAgd2l0aCA8bGluayBs
aW5rZW5kPSJzcWwtY3JlYXRlc3Vic2NyaXB0aW9uLXBhcmFtcy13aXRoLWNvcHktZGF0YSI+Cisg
ICAgICA8bGl0ZXJhbD5jb3B5X2RhdGEgPSB0cnVlPC9saXRlcmFsPjwvbGluaz4gKHRoZSBkZWZh
dWx0KSB0byBjb3B5IHRoZQorICAgICAgaW5pdGlhbCBzZXF1ZW5jZSB2YWx1ZXMgZnJvbSB0aGUg
cHVibGlzaGVyLgogICAgICA8L3BhcmE+CiAgICAgPC9saXN0aXRlbT4KICAgICA8bGlzdGl0ZW0+
CmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3N1YnNjcmlwdGlvbi5zZ21sIGIv
ZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl9zdWJzY3JpcHRpb24uc2dtbAppbmRleCBmYWQxZjkwOTU2
YS4uOGQ2NDc0NDM3NWEgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfc3Vic2Ny
aXB0aW9uLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl9zdWJzY3JpcHRpb24uc2dt
bApAQCAtMjM3LDExICsyMzcsMTMgQEAgQUxURVIgU1VCU0NSSVBUSU9OIDxyZXBsYWNlYWJsZSBj
bGFzcz0icGFyYW1ldGVyIj5uYW1lPC9yZXBsYWNlYWJsZT4gUkVOQU1FIFRPIDwKICAgICAgPHBh
cmE+CiAgICAgICBSZS1zeW5jaHJvbml6ZSBzZXF1ZW5jZSBkYXRhIHdpdGggdGhlIHB1Ymxpc2hl
ci4gVW5saWtlCiAgICAgICA8bGluayBsaW5rZW5kPSJzcWwtYWx0ZXJzdWJzY3JpcHRpb24tcGFy
YW1zLXJlZnJlc2gtcHVibGljYXRpb24iPgotICAgICAgPGNvbW1hbmQ+QUxURVIgU1VCU0NSSVBU
SU9OIC4uLiBSRUZSRVNIIFBVQkxJQ0FUSU9OPC9jb21tYW5kPjwvbGluaz4gd2hpY2gKLSAgICAg
IG9ubHkgaGFzIHRoZSBhYmlsaXR5IHRvIHN5bmNocm9uaXplIG5ld2x5IGFkZGVkIHNlcXVlbmNl
cywKKyAgICAgIDxjb21tYW5kPkFMVEVSIFNVQlNDUklQVElPTiAuLi4gUkVGUkVTSCBQVUJMSUNB
VElPTjwvY29tbWFuZD48L2xpbms+LAorICAgICAgd2hpY2ggc3luY2hyb25pemVzIHRoZSBzdWJz
Y3JpcHRpb24ncyBzZXQgb2Ygc2VxdWVuY2VzIHdpdGggdGhlCisgICAgICBwdWJsaWNhdGlvbiAo
YWRkaW5nIG5ldyBhbmQgcmVtb3ZpbmcgZHJvcHBlZCBzZXF1ZW5jZXMpLAogICAgICAgPGxpdGVy
YWw+UkVGUkVTSCBTRVFVRU5DRVM8L2xpdGVyYWw+IHdpbGwgcmUtc3luY2hyb25pemUgdGhlIHNl
cXVlbmNlCi0gICAgICBkYXRhIGZvciBhbGwgY3VycmVudGx5IHN1YnNjcmliZWQgc2VxdWVuY2Vz
LiBJdCBkb2VzIG5vdCBhZGQgb3IgcmVtb3ZlCi0gICAgICBzZXF1ZW5jZXMgZnJvbSB0aGUgc3Vi
c2NyaXB0aW9uIHRvIG1hdGNoIHRoZSBwdWJsaWNhdGlvbi4KKyAgICAgIGRhdGEgZm9yIGFsbCBj
dXJyZW50bHkgc3Vic2NyaWJlZCBzZXF1ZW5jZXMgd2l0aG91dCBjaGFuZ2luZyB3aGljaAorICAg
ICAgc2VxdWVuY2VzIGFyZSBzdWJzY3JpYmVkLiBSdW4gPGxpdGVyYWw+UkVGUkVTSCBQVUJMSUNB
VElPTjwvbGl0ZXJhbD4KKyAgICAgIGZpcnN0IGlmIHRoZSBwdWJsaWNhdGlvbidzIHNldCBvZiBz
ZXF1ZW5jZXMgaGFzIGNoYW5nZWQuCiAgICAgIDwvcGFyYT4KICAgICAgPHBhcmE+CiAgICAgICBT
ZWUgPHhyZWYgbGlua2VuZD0ic2VxdWVuY2UtZGVmaW5pdGlvbi1taXNtYXRjaGVzIi8+IGZvcgot
LSAKMi41NC4wCgo=
--0000000000000f8dd806559b32df--