On Wed, Apr 1, 2026 at 12:35 PM shveta malik <[email protected]> wrote: > > 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. >
Pushed. -- With Regards, Amit Kapila.
