Rechercher une page de manuel
DROP_SET
Langue: en
Version: 17 November 2008 (ubuntu - 08/07/09)
Section: 7 (Divers)
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( 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.0Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre