Re: DOCS - Clarify behaviour when EXCEPT tables are moved/renamed

On Wed, Jun 17, 2026 at 11:34 AM Peter Smith <smithpb2250@gmail.com> wrote:

> Hi,
>
> A documentation gap was identified [1] regarding the new publication
> FOR ALL TABLES EXCEPT behaviour. e.g. what happens if an excluded
> table is renamed or moved?
>
> This patch addresses that gap.
>
> Note that the patch uses different text from what was previously
> suggested because, when I checked with AI, it proposed this much
> simpler wording.
>
> ======
> [1]
> https://www.postgresql.org/message-id/CAA4eK1J_QP8CXCshaCy_01ALQQrDSzoTHfXKcAbjiEvV-RkOOw%40mail.gmail.com
>
> Kind Regards,
> Peter Smith.
> Fujitsu Australia
>

I think this is an improvement. AFAIK, the EXCEPT behavior is based on the
table OID, and renaming a table or setting its schema does not change the
table’s OID, so the defined EXCEPT for the table is not affected.

The doc patch looks good.

Regards,
Yingying Chen