MIME-Version: 1.0
From: Peter Smith <smithpb2250@gmail.com>
Date: Wed, 1 Apr 2026 15:59:54 +1100
Message-ID: 
 <CAHut+Pv1UKR_bxmN7wcCCpQveHoYprvH-hbdFq8gsaH1Ye7B_w@mail.gmail.com>
Subject: DOC: pg_publication_rel.prrelid says sequences are possible
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000f24189064e5ef532"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHut%2BPv1UKR_bxmN7wcCCpQveHoYprvH-hbdFq8gsaH1Ye7B_w%40mail.gmail.com>
Precedence: bulk

--000000000000f24189064e5ef532
Content-Type: text/plain; charset="UTF-8"

Hi.

It is my understanding that only tables can exist in the
'pg_publication_rel' catalog.

e.g. only for these scenarios:
* included tables - when pg_publication.puballtables is false, these
are the specified FOR TABLE ... tables
* excluded tables - when pg_publication.puballtables is true, these
are the specified FOR ALL TABLES EXCEPT (TABLE ...) tables

In particular, AFAIK there is no way for sequences to be in the
'pg_publication_rel' catalog. e.g.
PG19 only supports "CREATE PUBLICATION ... FOR ALL SEQUENCES", which
is indicated by pg_publication.puballsequences.
PG19 has no support for "CREATE PUBLICATION ... FOR SEQUENCE seq1,seq2".

~~

Meanwhile, the DOCS page for 'pg_publication_rel' catalog [1] since
commit 55cefad says that sequences are also possible [2]:
------
prrelid oid (references pg_class.oid)
Reference to table or sequence
------

How are sequences possible? PSA a patch to correct it.

Or, am I mistaken here?

======
[1] https://www.postgresql.org/docs/devel/catalog-pg-publication-rel.html
[2] https://github.com/postgres/postgres/commit/55cefadde874e52b57f7b3c2232744e331f9d6bb#diff-686ae8747787a3c04698ca610350c2b7dc84618c5b28d4b90e94f6f8cd47bd8eR6571

Kind Regards,
Peter Smith.
Fujitsu Australia

--000000000000f24189064e5ef532
Content-Type: application/octet-stream;
	name="v1-0001-DOCS-pg_publication_rel.prrelid.patch"
Content-Disposition: attachment;
	filename="v1-0001-DOCS-pg_publication_rel.prrelid.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnfkjubq0>
X-Attachment-Id: f_mnfkjubq0

RnJvbSA5NWRkZmJkZGU2N2UzNGEyN2FjMmUxNTBiMDIwYzIwOGE3ZGZjNzg0IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBTbWl0aCA8cGV0ZXIuYi5zbWl0aEBmdWppdHN1LmNv
bT4KRGF0ZTogV2VkLCAxIEFwciAyMDI2IDE1OjI1OjUyICsxMTAwClN1YmplY3Q6IFtQQVRDSCB2
MV0gRE9DUyAtIHBnX3B1YmxpY2F0aW9uX3JlbC5wcnJlbGlkCgotLS0KIGRvYy9zcmMvc2dtbC9j
YXRhbG9ncy5zZ21sIHwgMiArLQogMSBmaWxlIGNoYW5nZWQsIDEgaW5zZXJ0aW9uKCspLCAxIGRl
bGV0aW9uKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL2NhdGFsb2dzLnNnbWwgYi9kb2Mv
c3JjL3NnbWwvY2F0YWxvZ3Muc2dtbAppbmRleCA5MmQxNzliNWVlMC4uMGIzZTYzMDhkNTYgMTAw
NjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9j
YXRhbG9ncy5zZ21sCkBAIC03MDg2LDcgKzcwODYsNyBAQCBTQ1JBTS1TSEEtMjU2JDxyZXBsYWNl
YWJsZT4mbHQ7aXRlcmF0aW9uIGNvdW50Jmd0OzwvcmVwbGFjZWFibGU+OjxyZXBsYWNlYWJsZT4m
bAogICAgICAgIChyZWZlcmVuY2VzIDxsaW5rIGxpbmtlbmQ9ImNhdGFsb2ctcGctY2xhc3MiPjxz
dHJ1Y3RuYW1lPnBnX2NsYXNzPC9zdHJ1Y3RuYW1lPjwvbGluaz4uPHN0cnVjdGZpZWxkPm9pZDwv
c3RydWN0ZmllbGQ+KQogICAgICAgPC9wYXJhPgogICAgICAgPHBhcmE+Ci0gICAgICAgUmVmZXJl
bmNlIHRvIHRhYmxlIG9yIHNlcXVlbmNlCisgICAgICAgUmVmZXJlbmNlIHRvIHRhYmxlCiAgICAg
ICA8L3BhcmE+PC9lbnRyeT4KICAgICAgPC9yb3c+CiAKLS0gCjIuNDcuMwoK
--000000000000f24189064e5ef532--