Re: Support EXCEPT for ALL SEQUENCES publications

[Ashutosh Sharma]

Hi,

On Thu, Jul 2, 2026 at 11:53 AM Shlok Kyal <shlok.kyal....@gmail.com> wrote:
>
> Please find the updated v17 patch attached.
>

Thank you for the updated patches. I see that the following command
works with your patch:

CREATE PUBLICATION combined_seq_pub_1
  FOR ALL SEQUENCES
  EXCEPT (SEQUENCE ONLY s1_seq);

May I know what the purpose of ONLY is here?

AFAIU, for FOR ALL TABLES, ONLY was added to handle inherited tables.
However, sequences do not have inheritance, so I am not sure what
semantics ONLY is intended to provide for sequences. Could you please
clarify?

--
With Regards,
Ashutosh Sharma.