Re: Support EXCEPT for TABLES IN SCHEMA publications

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
Cc: shveta malik <shveta(dot)malik(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Support EXCEPT for TABLES IN SCHEMA publications
Date: 2026-07-17 04:19:53
Message-ID: CAHut+PtzpgpeWkay9v_zfsLLeO7GirZnGqTUWm_hix+yFNiDvw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Nisha.

I noticed multiple places where these patches want to discover the
root partition table OID, but they are not interested in the ancestor
tree.

I've created another thread/patch [1] to introduce a
`get_partition_root` C function. I think this could simplify some of
your code by removing the requirement to declare and free the unwanted
ancestor lists.

Please take a look and give your +1 there if you think it would be useful.

======
[1] https://www.postgresql.org/message-id/CAHut%2BPtc73UpWSn4teMyMxQoHwGJjRwhWiu%3DhGJqAj5k2AOXEw%40mail.gmail.com

Kind Regards,
Peter Smith.
Fujitsu Australia

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2026-07-17 05:17:08 Re: sequencesync worker race with REFRESH SEQUENCES
Previous Message Denis Smirnov 2026-07-17 04:17:26 Re: Batching in executor