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.

VERSION INFORMATION

This command was introduced in Slony-I 1.0.5