---
name: "SET_ADD_SEQUENCE"
section: "7"
platform: "linux"
package: "slony1-doc"
version: "1.2.15-1"
release: "Debian 5.0 (Lenny)"
platforms: ["linux"]
url: "https://new.carta.tech/SET_ADD_SEQUENCE"
---

# SET\_ADD\_SEQUENCE(7)

Add a sequence to a Slony-I replication set

## 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 **MERGE** [**SET**(7)](/SET/7.md) 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\].

## EXAMPLE

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