---
name: "SET_MOVE_TABLE"
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_MOVE_TABLE"
---

# SET\_MOVE\_TABLE(7)

Move a table from one Slony-I replication set to another

## NAME

SET MOVE TABLE - Move a table from one Slony-I replication set to another

## SYNOPSIS

**SET MOVE TABLE (options);**

## DESCRIPTION

Change the set a table belongs to. The current set and the new set must origin 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 tables. Moving a table too early to a new set causes the subscriber to try and add the table already during the subscription process, which fails with a duplicate key error and breaks replication.

- FCORIGIN = ival F\[0\]

  Current origin of the set. A future version of slonik might figure out this information by itself.

- FCID = ival F\[0\]

  Unique ID of the table.

- FCNEW SET = ival F\[0\]

  Unique ID of the set to which the table should be added.

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

## EXAMPLE

```
FCSET MOVE TABLE (
    ORIGIN = 1,
    ID = 20,
    NEW SET = 3
);
    F[0]
```

## LOCKING BEHAVIOUR

No application-visible locking should take place.

## VERSION INFORMATION

This command was introduced in Slony-I 1.0.5