Obtains 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.
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
true, or return false without waiting if the lock cannot be acquired immediately.pg_try_advisory_xact_lock ( key bigint ) → boolean → 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 ) → boolean → 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.{"inputs":[{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","version":"18.7"},{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"830e894d29fec30b7c350c915fcaed4a63b24d57f2c96150bf25fa07fb43849c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:5924288ca98146882b79f8cde4f5f0ee97263f99f82be42969ae63020e369d09
Text language: en · wiki-repair-20261023:5924288ca98146882b79f8cde4f5f0ee97263f99f82be42969ae63020e369d09