Re: Support EXCEPT for TABLES IN SCHEMA publications

On Mon, Aug 24, 2026 at 3:25 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> Partition Case Rules:
> -----------------------------------
> a) By default, mentioning a 'partition root 'means that its entire
> partition tree is included/excluded, irrespective of schema
> boundaries, consistent with HEAD.
> b) An explicitly mentioned partition is allowed and takes precedence
> over the partition-tree exclusion.
>
> Going through the cases again:
> 1. FOR TABLES IN SCHEMA s1 EXCEPT (s1.root), TABLES IN SCHEMA s2;
> Excludes root: By default all its parition gets excluded, even the
> ones present in s2.
>
> 2. FOR TABLES IN SCHEMA s1 EXCEPT (s1.root), FOR TABLE s1.p1;
> Excludes s1.root: By default all its partitions get excluded except
> s1.p1. s1.p1 is still published as the user has explicitly mentioned
> it.
>

Both the above cases seem to fall in the same category though for the
first one the table is not explicitly mentioned but TABLES IN SCHEMA
does mean all tables in that schema. The another point I see in making
both above cases behave similar (follow what you mentioned in 2) is
that we will follow the same behavior when two different publications
(pub1 FOR TABLES IN SCHEMA s1 EXCEPT (s1.root) and pub2 FOR TABLES IN
SCHEMA s2;) that specify the two clauses separately are combined by
SUBSCRIPTION.

--
With Regards,
Amit Kapila.