set move table(7)
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 du
- plicate 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 .
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
- SET