SLONIK SET ADD SEQUENCE

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 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 as described in < linkend="stmttableaddkey">.

COMMENT = 'string'

A descriptive text added to the sequence entry.

This uses schemadocsetaddsequence( 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