DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY
Date: 2026-04-16 23:55:44
Message-ID: CAHut+PuVZsm4-Xq4ufDDzJiXbCsSuwO4cJd5Fia3Uc9VBUk5Xw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Currently, the EXCEPT (TABLE ...) part mentions how 'ONLY' and '*'
work for inheritance tables, but how they have no effect for
partitioned tables [1].

It seems we accidentally missed saying that these also have no effect
for *regular* tables.

PSA: a patch to clarify this.

======
[1] https://www.postgresql.org/docs/devel/sql-createpublication.html#SQL-CREATEPUBLICATION-PARAMS-FOR-EXCEPT-TABLE

Kind Regards,
Peter Smith.
Fujitsu Australia

Attachment Content-Type Size
v1-0001-Fix-note-about-ONLY-to-mention-regular-tables-too.patch application/octet-stream 1.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Kupershmidt 2026-04-17 00:47:00 pg_dump: eliminate tmpfile double-write in tar format output
Previous Message Amit Langote 2026-04-16 23:46:07 Re: Reject invalid databases in pg_get_database_ddl()