Slony-I 2.2.11 Documentation
Prev | Fast Backward |  | Fast Forward | Next

# SLONIK SET DROP SEQUENCE

## 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).

## 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

Prev | Home | Next
SLONIK SET DROP TABLE | Up | SLONIK SET MOVE TABLE