Functions / System Administration Functions

pg_advisory_xact_lock

Obtains an exclusive transaction-level advisory lock, waiting if necessary.

Reading PG 18current·documented in 17 of 27 versions, 9.1 to 20

Signatures & examples

pg_advisory_xact_lock ( key bigint ) → void

Obtains an exclusive transaction-level advisory lock, waiting if necessary.

pg_advisory_xact_lock ( key1 integer, key2 integer ) → void

Obtains an exclusive transaction-level advisory lock, waiting if necessary.

Version history 2

Definition snapshot: b7bd9cda · English manual source