DROP_SET

Langue: en

Version: 17 November 2008 (ubuntu - 08/07/09)

Section: 7 (Divers)

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