Functions / System Administration Functions
Releases a previously-acquired shared session-level advisory lock.
Reading PG 18current·documented in 21 of 27 versions, 8.2 to 20
pg_advisory_unlock_shared ( key bigint ) → 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 ) → 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.Definition snapshot: b7bd9cda · English manual source