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

NAME

       SET MOVE SEQUENCE - Move a sequence from one Slony-I replication set to
       another

SYNOPSIS

       SET MOVE SEQUENCE (options);

DESCRIPTION

       Change the set a sequence belongs to. The current set and the  new  set
       must originate on the same node and subscribed by the same nodes.
              Caution

              Due  to  the  way  subscribing to new sets works make absolutely
              sure  that  the  subscription  of  all  nodes  to  the  sets  is
              completely  processed before moving sequences. Moving a sequence
              too early to a new set causes the subscriber to try and add  the
              sequence  already  during  the subscription process, which fails
              with a duplicate key error and breaks replication.

       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.

       NEW SET = ival
              Unique ID of the set to which the sequence should be moved.

       This uses “schemadocsetmovesequence( integer, integer )” [not available
       as a man page].

EXAMPLE

       SET MOVE SEQUENCE (
           ORIGIN = 1,
           ID = 20,
           NEW SET = 3
       );

LOCKING BEHAVIOUR

       No application-visible locking should take place.

VERSION INFORMATION

       This command was introduced in Slony-I 1.0.5

                               17 November 2008           SET MOVE SEQUENCE(7)