Releases a previously-acquired shared session-level advisory lock. Returns true if the lock is successfully released. If the lock was not held, false is returned, and in addition, an SQL warning will be reported by the server.
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 if the lock is successfully released. If the lock was not held, false is returned, and in addition, an SQL warning will be reported by the server.pg_advisory_unlock_shared ( key bigint ) → boolean → booleanReleases a previously-acquired shared session-level advisory lock. Returns
true if the lock is successfully released. If the lock was not held, false is returned, and in addition, an SQL warning will be reported by the server.pg_advisory_unlock_shared ( key1 integer, key2 integer ) → boolean → booleanReleases a previously-acquired shared session-level advisory lock. Returns
true if the lock is successfully released. If the lock was not held, false is returned, and in addition, an SQL warning will be reported by the server.{"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:0ee0901256db8fd78cda1795ee5ff3f1eabd03ce3fc2425e3db40976fd333a7c
Text language: en · wiki-repair-20261023:0ee0901256db8fd78cda1795ee5ff3f1eabd03ce3fc2425e3db40976fd333a7c