Commits on Aug 22, 2026
-
Support EXCEPT for ALL SEQUENCES in CREATE PUBLICATION
Extend CREATE PUBLICATION ... FOR ALL SEQUENCES to support the EXCEPT syntax. This allows one or more sequences to be excluded. The publisher will not send the data of excluded sequences to the subscriber. Example: CREATE PUBLICATION pub1 FOR ALL SEQUENCES EXCEPT (SEQUENCE s1, s2);
-
Support EXCEPT for ALL SEQUENCES in ALTER PUBLICATION
Extend ALTER PUBLICATION to support an EXCEPT clause when using ALL SEQUENCES, allowing specific sequences to be excluded from the publication. If the EXCEPT clause is specified, the existing exclusion list for the publication is replaced with the provided sequences. If the EXCEPT clause is omitted, any existing exclusions for sequences are cleared. Example: ALTER PUBLICATION pub1 SET ALL SEQUENCES; This clears any existing sequence exclusions for the publication. ALTER PUBLICATION pub1 SET ALL SEQUENCES EXCEPT (SEQUENCE s1, s2); This sets the exclusion list to the specified sequences.
skkyal authored and Commitfest Bot committed
Aug 22, 2026