Horton
Menu

Re: Support EXCEPT for ALL SEQUENCES publications

Ashutosh Sharma <ashu.coek88@gmail.com>

View thread
From: Ashutosh Sharma <ashu.coek88@gmail.com>
To: Shlok Kyal <shlok.kyal.oss@gmail.com>
Cc: Peter Smith <smithpb2250@gmail.com>, shveta malik <shveta.malik@gmail.com>, vignesh C <vignesh21@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-07-03T05:53:52Z
Lists: 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.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Doc: Clarify that publication exclusions track table identity.

  2. Use schema-qualified names in EXCEPT clause error messages.

  3. psql: Improve describe footer titles for publications.

  4. Improve various new-to-v19 appendStringInfo calls