SET_ADD_SEQUENCE(7)

Usage

SET ADD SEQUENCE (options);

Overview

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.

FCSET ID = ival F[0]: ID of the set to which the sequence is to be added.

FCORIGIN = ival F[0]: Origin node for the set. A future version of slonik might figure out this information by itself.

FCID = ival F[0]: 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.

FCFULLY QUALIFIED NAME = 'string' F[0]: The full sequence name as described in < linkend="stmttableaddkey">.

FCCOMMENT = 'string' F[0]: A descriptive text added to the sequence entry.

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

Examples

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

Locking behaviour

No application-visible locking should take place.

Version information

This command was introduced in Slony-I 1.0

History

Debian 5.0 (Lenny): the text shown here
Debian 4.0 (Etch)