Obtains 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.
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_lock ( key bigint ) → boolean → 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.pg_try_advisory_lock ( key1 integer, key2 integer ) → boolean → 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.{"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:7ab7cd2d5cb2850099856989e09f869cdb4223b0241d52a4618140f583b225b6
Text language: en · wiki-repair-20261023:7ab7cd2d5cb2850099856989e09f869cdb4223b0241d52a4618140f583b225b6