UNLOCK_SET7
Unlock a slony-i set that was locked
Usage
UNLOCK SET
(options);
Overview
Unlocks a previously locked set.
- FCID = ival F[0]
-
ID of the set to unlock
- FCORIGIN = ival F[0]
-
Node ID of the current set origin
This uses “schemadocunlockset( integer )” [not available as a man page].
Examples
FCUNLOCK SET (
ID = 1,
ORIGIN = 3
);
F[0]
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
History
- Debian 5.0 (Lenny): the text shown here
- Debian 4.0 (Etch)