Christopher B. Browne's Home Page
cbbrowne@acm.org

SLONIK UNLOCK SET

Name

UNLOCK SET --  Unlock a Slony-I set that was locked

Synopsis

UNLOCK SET (options);

Description

Unlocks a previously locked set.

ID = ival

ID of the set to unlock

ORIGIN = ival

Node ID of the current set origin

This uses unlockset(integer).

Example

    UNLOCK SET (
       ID = 1,
       ORIGIN = 3
    );
        

Locking Behaviour

Exclusive locks on each replicated table will be taken out on the origin node, as the triggers are removed from each table that reject table updates.

Version Information

This command was introduced in Slony-I 1.0

Google

If this was useful, let others know by an Affero rating

Contact me at cbbrowne@acm.org