NAME¶
SET DROP SEQUENCE - Remove a sequence from a Slony-I replication set
SYNOPSIS¶
SET DROP SEQUENCE (options);
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.
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.
This command was introduced in Slony-I 1.0.5