skkyal · GitHub

Commits on Aug 22, 2026

  1. 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);

    authored and Commitfest Bot committed

    Aug 22, 2026
    Configuration menu

    Browse the repository at this point in the history

  2. 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
    Configuration menu

    Browse the repository at this point in the history

  3. Configuration menu

    Browse the repository at this point in the history

Read the original on github.com ↗