SYNOPSIS

SET DROP SEQUENCE (options); \kx

DESCRIPTION

Drops an existing user sequence from a replication set.

\*(T<ORIGIN = ival \*(T>

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

\*(T<ID = ival \*(T>

Unique ID of the sequence.

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

EXAMPLE

\*(T<     SET DROP SEQUENCE (
     ORIGIN = 1,
     ID = 20
     );\*(T>

LOCKING BEHAVIOUR

No application-visible locking should take place.

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.

VERSION INFORMATION

This command was introduced in Slony-I 1.0.5