NAME
DROP SET - Discard Slony-I replication set
SYNOPSIS
DROP SET (options);
DESCRIPTION
Drop a set of tables from the Slony-I configuration. This automatically
unsubscribes all nodes from the set and restores the original triggers
and rules on all subscribers.
ID = ival
ID of the set to be dropped.
ORIGIN = ival
Current origin node of the set.
This uses “schemadocdropset( integer )” [not available as a man page].
EXAMPLE
DROP SET ( ID = 5,
ORIGIN = 2 );
LOCKING BEHAVIOUR
On each node, this will require taking out exclusive locks on each
replicated table in order to modify the table schema to clean up the
triggers and rules.
VERSION INFORMATION
This command was introduced in Slony-I 1.0
12 May 2010 SLONIK DROP SET(7)