Re: Support EXCEPT for ALL SEQUENCES publications - Mailing list pgsql-hackers

From Ashutosh Sharma
Subject Re: Support EXCEPT for ALL SEQUENCES publications
Date
Msg-id CAE9k0PndRsogmPEpYrm5CrT1wWHO5dWaq90vcsP_po_zaYo37A@mail.gmail.com
Whole thread
In response to Re: Support EXCEPT for ALL SEQUENCES publications  (Shlok Kyal <shlok.kyal.oss@gmail.com>)
Responses Re: Support EXCEPT for ALL SEQUENCES publications
List pgsql-hackers
Hi,

On Thu, Jul 2, 2026 at 11:53 AM Shlok Kyal <shlok.kyal.oss@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.



pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Re-read subscription state after lock in AlterSubscription
Next
From: Feng Wu
Date:
Subject: Re: [PATCH v2] Avoid internal error for invalid interval typmods