On Wed, Apr 1, 2026 at 10:30 AM Peter Smith <[email protected]> wrote: > > 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? >
You are right, pg_publication_rel can never have a seq entry while pg_subscription_rel can have. The patch LGTM. thanks Shveta
