'\" -*- coding: us-ascii -*-
.if \n(.g .ds T< \\FC
.if \n(.g .ds T> \\F[\n[.fam]]
.de URL
\\$2 \(la\\$1\(ra\\$3
..
.if \n(.g .mso www.tmac
.TH "SLONIK UNLOCK SET" 7 "24 July 2014" "" "Slony-I 2.2.3 Documentation"
.SH NAME
UNLOCK SET \- Unlock a Slony-I set that was locked 
.SH SYNOPSIS
'nh
.fi
.ad l
\fBUNLOCK SET (options);\fR \kx
.if (\nx>(\n(.l/2)) .nr x (\n(.l/5)
'in \n(.iu+\nxu
'in \n(.iu-\nxu
.ad b
'hy
.SH DESCRIPTION
Unlocks a previously locked set.
.TP 
\*(T<ID = ival \*(T>
ID of the set to unlock
.TP 
\*(T<ORIGIN = ival \*(T>
Node ID of the current set origin
.PP
This uses \(lqschemadocunlockset(p_set_id integer)\(rq [not available as a man page]. 
.SH EXAMPLE
.nf
\*(T<UNLOCK SET (
   ID = 1,
   ORIGIN = 3
);
    \*(T>
.fi
.SH "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. 
.SH "SLONIK EVENT CONFIRMATION BEHAVIOUR "
Slonik does not wait for event confirmations before 
performing this command.
.SH "VERSION INFORMATION "
This command was introduced in Slony-I 1.0