Functions / System Administration Functions
Obtains an exclusive transaction-level advisory lock if available.
Reading PG 18current·documented in 17 of 27 versions, 9.1 to 20
pg_try_advisory_xact_lock ( key bigint ) → booleanObtains an exclusive transaction-level advisory lock if available. This will either obtain the lock immediately and return
true, or return false without waiting if the lock cannot be acquired immediately.pg_try_advisory_xact_lock ( key1 integer, key2 integer ) → booleanObtains an exclusive transaction-level advisory lock if available. This will either obtain the lock immediately and return
true, or return false without waiting if the lock cannot be acquired immediately.Definition snapshot: b7bd9cda · English manual source