On Mon, Jul 21, 2025 at 11:15 AM Dilip Kumar <dilipbal...@gmail.com> wrote: > > 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
+1. I had the same concerns at [1]. It might be feasible to restrict this if we have CREATE SUB for ALL SEQ alone. But if we have ALL SEQUENCES and ALL TABLES together, then 'WITH' makes sense for tables but not for sequences. My suggestion earlier was to display a NOTICE at-least to say that WITH is not applicable to SEQUENCES (in case we can not restrict it). [1]: https://www.postgresql.org/message-id/CAJpy0uBFXJLOiFOL8QgSeS93Bf%3DZQd86BXZa%3DMeijHQo-%3Da2cA%40mail.gmail.com thanks Shveta
