Re: Logical Replication of sequences

On Mon, Jul 21, 2025 at 10:36 AM Dilip Kumar <dilipbalaut@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