pg_try_advisory_lock ( key bigint ) → booleanObtains an exclusive session-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.Functions / System Administration Functions
pg_try_advisory_lock
Read the PG 18 manualObtains an exclusive session-level advisory lock if available.
Reading PG 18current·documented in 21 of 27 versions, 8.2 to 20
Signatures & examples
pg_try_advisory_lock ( key1 integer, key2 integer ) → booleanObtains an exclusive session-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