On Mon, Aug 24, 2026 at 3:25 PM shveta malik <[email protected]> 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.
