Obtains a shared 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_shared ( key bigint ) → boolean → booleanObtains a shared 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_shared ( key1 integer, key2 integer ) → boolean → booleanObtains a shared 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:e1c3e4e896383d8a3c84e09d739286aa3d2a51e9cc3ae07732c74376704704fb
Text language: en · wiki-repair-20261023:e1c3e4e896383d8a3c84e09d739286aa3d2a51e9cc3ae07732c74376704704fb