carta
UNLOCK_SET(7)

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)

From slony1-doc 1.2.15-1 in Debian 5.0 (Lenny). Parsed by carta from the page's man source.