SET ADD SEQUENCE -- Add a sequence to a
edb-async-replic 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
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.
Example
SET ADD SEQUENCE (
SET ID = 1,
ORIGIN = 1,
ID = 20,
FULLY QUALIFIED NAME = 'public.tracker_ticket_id_seq',
COMMENT = 'Support ticket ID sequence'
);