public inbox for [email protected]
help / color / mirror / Atom feedFrom: Amit Kapila <[email protected]>
To: shveta malik <[email protected]>
Cc: Peter Smith <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: DOC: pg_publication_rel.prrelid says sequences are possible
Date: Thu, 2 Apr 2026 14:03:09 +0530
Message-ID: <CAA4eK1+drNVMcEjwLfK4rMPXQUjfoJcZumfouG7VGGVWUy3K4w@mail.gmail.com> (raw)
In-Reply-To: <CAJpy0uA9CoYcfbbtLFd9a5owsXO=fiXvOvCxdefj7kceYvhW6w@mail.gmail.com>
References: <CAHut+Pv1UKR_bxmN7wcCCpQveHoYprvH-hbdFq8gsaH1Ye7B_w@mail.gmail.com>
<CAJpy0uA9CoYcfbbtLFd9a5owsXO=fiXvOvCxdefj7kceYvhW6w@mail.gmail.com>
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.
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: DOC: pg_publication_rel.prrelid says sequences are possible
In-Reply-To: <CAA4eK1+drNVMcEjwLfK4rMPXQUjfoJcZumfouG7VGGVWUy3K4w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox