Rechercher une page de manuel
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 setSYNOPSIS
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.
- Note
- 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.0Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre