SET_ADD_SEQUENCE

Langue: en

Version: 17 November 2008 (ubuntu - 08/07/09)

Section: 7 (Divers)

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 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 as described in < linkend="stmttableaddkey">.
COMMENT = 'string'
A descriptive text added to the sequence entry.

This uses "schemadocsetaddsequence( integer, integer, text, text )" [not available as a man page].

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