Releases a previously-acquired exclusive 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 ( key bigint ) → boolean → booleanReleases a previously-acquired exclusive 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 ( key1 integer, key2 integer ) → boolean → booleanReleases a previously-acquired exclusive 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:7c280201de5a327b7c7cdbcd9f330b42af8f2d9a861f740ab21620082c00a284
Text language: en · wiki-repair-20261023:7c280201de5a327b7c7cdbcd9f330b42af8f2d9a861f740ab21620082c00a284