SLONIK UNLOCK SET(7)

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

SYNOPSIS
\FCUNLOCK SET (options);\F[]

DESCRIPTION
Unlocks a previously locked set.

\FCID = ival \F[]
    ID of the set to unlock

\FCORIGIN = ival \F[]
    Node ID of the current set origin

This uses “schemadocunlockset(p_set_id integer)” [not available as a man page].

EXAMPLE
\FCUNLOCK SET (
   ID = 1,
   ORIGIN = 3
);
    \F[]

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.

SLONIK EVENT CONFIRMATION BEHAVIOUR
Slonik does not wait for event confirmations before performing this command.

VERSION INFORMATION
This command was introduced in Slony-I 1.0