Blast-Radius Aware AI Code Review for Business-Critical Systems
LiveReview LiveReview Explore LiveReview

SET DROP SEQUENCE - Remove a sequence from a Slony-I replication set

Description

       Drops an existing user sequence from a replication set.

       ORIGIN = ival
              Origin node for the set. A future version of slonik might figure out this information by itself.

       ID = ival
              Unique ID of the sequence.

       This uses “schemadocsetdropsequence(p_seq_id integer)” [not available as a man page].

Example

            SET DROP SEQUENCE (
            ORIGIN = 1,
            ID = 20
            );

Locking Behaviour

       No application-visible locking should take place.

Name

       SET DROP SEQUENCE - Remove a sequence from a Slony-I replication set

Slonik Event Confirmation Behaviour

       Slonik  waits for the command submitted to the previous event node to be confirmed on the specified event
       node before submitting this command.

Synopsis

SETDROPSEQUENCE(options);

Version Information

       This command was introduced in Slony-I 1.0.5

                                                19 September 2024                    SLONIKSETDROPSEQUENCE(7)

See Also