Christopher B. Browne's Home Page
cbbrowne@acm.org

SLONIK SET ADD SEQUENCE

Name

SET ADD SEQUENCE --  Add a sequence to a Slony-I replication set

Synopsis

SET ADD SEQUENCE (options);

Description

Add an existing user sequence to a replication set. The set cannot currently be subscribed by any other node - that functionality is supported by the SLONIK MERGE SET(7) command.

SET ID = ival

ID of the set to which the sequence is to be added.

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.

Note

Note that this ID needs to be unique across sequences throughout the cluster; the numbering of tables is separate, so you might have a table with ID 20 and a sequence with ID 20, and they would be recognized as separate.

FULLY QUALIFIED NAME = 'string'

The full sequence name including schema name.

COMMENT = 'string'

A descriptive text added to the sequence entry.

This uses setaddsequence(integer, integer, text, text).

Example

         SET ADD SEQUENCE (
         SET ID = 1,
         ORIGIN = 1,
         ID = 20,
         FULLY QUALIFIED NAME = 'public.tracker_ticket_id_seq',
         COMMENT = 'Support ticket ID sequence'
         );
        

Locking Behaviour

No application-visible locking should take place.

Version Information

This command was introduced in Slony-I 1.0

Google
Contact me at cbbrowne@acm.org