## 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.

`ORIGIN = ival`

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

`ID = ival`

  Unique ID of the table.

`NEW SET = ival`

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

This uses schemadocsetmovetable( integer, integer ).

## Example

    SET MOVE TABLE (
        ORIGIN = 1,
        ID = 20,
        NEW SET = 3
    );

## Locking Behaviour

No application-visible locking should take place.

## Version Information

This command was introduced in Slony-I 1.0.5