MIME-Version: 1.0
References: 
 <CAHut+Pv1UKR_bxmN7wcCCpQveHoYprvH-hbdFq8gsaH1Ye7B_w@mail.gmail.com>
In-Reply-To: 
 <CAHut+Pv1UKR_bxmN7wcCCpQveHoYprvH-hbdFq8gsaH1Ye7B_w@mail.gmail.com>
From: shveta malik <shveta.malik@gmail.com>
Date: Wed, 1 Apr 2026 12:35:34 +0530
Message-ID: 
 <CAJpy0uA9CoYcfbbtLFd9a5owsXO=fiXvOvCxdefj7kceYvhW6w@mail.gmail.com>
Subject: Re: DOC: pg_publication_rel.prrelid says sequences are possible
To: Peter Smith <smithpb2250@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAJpy0uA9CoYcfbbtLFd9a5owsXO%3DfiXvOvCxdefj7kceYvhW6w%40mail.gmail.com>
Precedence: bulk

On Wed, Apr 1, 2026 at 10:30=E2=80=AFAM Peter Smith <smithpb2250@gmail.com>=
 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