On Tue, Jun 24, 2025 at 6:44 PM Shlok Kyal <shlok.kyal....@gmail.com> wrote: > > > 1. Initially, I have created a publication on sequence s1. > postgres=# CREATE PUBLICATION pub1 FOR ALL SEQUENCES; > CREATE PUBLICATION > postgres=# ALTER PUBLICATION pub1 SET TABLE t1; > ALTER PUBLICATION > postgres=# \d s1 > Sequence "public.s1" > Type | Start | Minimum | Maximum | Increment | Cycles? | Cache > --------+-------+---------+---------------------+-----------+---------+------- > bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1 > Publications: > "pub1" > postgres=# select * from pg_publication_rel; > oid | prpubid | prrelid | prqual | prattrs > -------+---------+---------+--------+--------- > 16415 | 16414 | 16388 | | > (1 row) > > Here, we can set the publication to TABLE or TABLES FOR SCHEMA. Should > this be allowed? > If a publication is created on FOR ALL TABLES, such an operation is not > allowed. >
Good catch. IMO, this should not be allowed as currently we strictly support either ALL SEQUENCES or ALL SEQUENCES with ALL TABLES alone. thanks Shveta