SLONIK DROP SET(7) | Slony-I 2.2.5 Documentation | SLONIK DROP SET(7) |
NAME¶
DROP SET - Discard Slony-I replication setSYNOPSIS¶
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(p_set_id 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.SLONIK EVENT CONFIRMATION BEHAVIOUR ¶
Slonik waits for the command submitted to the previous event node to be confirmed on the specified event node before submitting this command.VERSION INFORMATION ¶
This command was introduced in Slony-I 1.026 September 2016 |