Provided by: slony1-doc_1.2.16-1_all bug

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

                                  2 June 2009       SLONIK SET ADD SEQUENCE(7)