On Mon, Jul 21, 2025 at 10:36 AM Dilip Kumar <dilipbal...@gmail.com> wrote: > > I was just trying a different test, so I realized that ALTER > PUBLICATION ADD SEQUENCE is not supported, any reason for the same? > > postgres[154731]=# ALTER PUBLICATION pub ADD sequence s1; > ERROR: 42601: invalid publication object list > LINE 1: ALTER PUBLICATION pub ADD sequence s1; > DETAIL: One of TABLE or TABLES IN SCHEMA must be specified before a > standalone table or schema name. > LOCATION: preprocess_pubobj_list, gram.y:19685 > Also I noticed that 1. We don't allow creating publication with individual sequences (e.g. CREATE PUBLICATION pub FOR SEQUENCE s1;). Is it because the main purpose of this sync is major version upgrade and we do not have scenarios for replicating a few sequences or there are some technical difficulties in achieving that or both.
2. This syntax works (CREATE PUBLICATION pub FOR ALL TABLES, SEQUENCES;) but tab completion doesn't suggest this 3. Some of the syntaxes works for sequence which doesn't make sense to me, as listed below, I think there are more postgres[154731]=# CREATE PUBLICATION insert_only FOR ALL SEQUENCES WITH (publish = 'insert'); CREATE PUBLICATION postgres[154731]=# CREATE PUBLICATION pub FOR ALL SEQUENCES WITH ( PUBLISH_VIA_PARTITION_ROOT ); CREATE PUBLICATION -- Regards, Dilip Kumar Google