DOCS - CREATE PUBLICATION ... EXCEPT has no mention on what happens after drop/create tables

From: SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: DOCS - CREATE PUBLICATION ... EXCEPT has no mention on what happens after drop/create tables
Date: 2026-05-10 15:01:44
Message-ID: CAHg+QDdj69U+vb0f6M8WWvKAoCP=roBtQHGvozOT3833+gcA4w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

The docs say EXCEPT "This clause specifies a list of tables to be excluded
from the publication. "
with no time qualifier. In case of drop/create the table automatically
includes in the publication. Given the
filter is based on OIDs this is expected. Should we enhance the
documentation to mention this case?

Thanks,
Satya

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexandre Felipe 2026-05-10 15:53:49 Re: SLOPE - Planner optimizations on monotonic expressions.
Previous Message Alexander Lakhin 2026-05-10 15:00:00 Re: Random pg_upgrade 004_subscription test failure on drongo