Risk-Aware Code Review: Auto Approve Low-Risk Changes
LiveReview LiveReview LiveReview - Free, Risk-Aware Code Review: Auto Approve Low-Risk Changes | Product Hunt LiveReview - Free, Risk-Aware Code Review: Auto Approve Low-Risk Changes | Product Hunt GitHub Install Now

We'd appreciate a star

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

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 “schemadocunlockset(p_set_id integer)” [not available as a man page].

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 re‐ moved from each table that reject table updates.

Name

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

Slonik Event Confirmation Behaviour

Slonik does not wait for event confirmations before performing this command.

Synopsis

UNLOCKSET(options);

Version Information

This command was introduced in Slony-I 1.0 19 September 2024 SLONIKUNLOCKSET(7)

See Also