Re: Logical Replication of sequences - Mailing list pgsql-hackers

From vignesh C
Subject Re: Logical Replication of sequences
Date
Msg-id CALDaNm2ONtf7s2kfwxdj+K1dqhNJKWkG=26g1n+Xz32r4_K=+Q@mail.gmail.com
Whole thread Raw
In response to Re: Logical Replication of sequences  (Dilip Kumar <dilipbalaut@gmail.com>)
Responses Re: Logical Replication of sequences
List pgsql-hackers
On Mon, 21 Jul 2025 at 10:36, 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

I have intentionally left this out for now. Once the current patch is
committed, we can extend it.

Regards,
Vignesh



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: Log prefix missing for subscriber log messages received from publisher
Next
From: Nazir Bilal Yavuz
Date:
Subject: Re: Improve error reporting in 027_stream_regress test