{"Entry":{"collection":"func","key":"pg-advisory-unlock-shared","name":"pg_advisory_unlock_shared","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.1","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.2"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"9.1"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"86c97b3808156d5de40f5c39d5ce092dcb940a486df783634257c6daa94f03e0","first_version":"8.2","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.434782+08:00","last_version":"20","name":"pg_advisory_unlock_shared","name_key":"pg_advisory_unlock_shared","position":29009,"present_in":["8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_advisory_unlock_shared ( key bigint ) → boolean","signature_count":2,"slug":"pg-advisory-unlock-shared","source_rev":"b7bd9cda","summary":"Releases a previously-acquired shared session-level advisory lock.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-advisory-unlock-shared","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-advisory-unlock-shared","SourceRevision":"b7bd9cda","Facts":{"description":"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.","description_html":"Releases a previously-acquired shared session-level advisory lock. Returns \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the lock is successfully released. If the lock was not held, \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e is returned, and in addition, an SQL warning will be reported by the server.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADVISORY-LOCKS-TABLE","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"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.","description_html":"Releases a previously-acquired shared session-level advisory lock. Returns \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the lock is successfully released. If the lock was not held, \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e is returned, and in addition, an SQL warning will be reported by the server.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_advisory_unlock_shared\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003ekey\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_advisory_unlock_shared ( key bigint ) → boolean","zh_from":""},{"description":"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.","description_html":"Releases a previously-acquired shared session-level advisory lock. Returns \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the lock is successfully released. If the lock was not held, \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e is returned, and in addition, an SQL warning will be reported by the server.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_advisory_unlock_shared\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003ekey1\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ekey2\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_advisory_unlock_shared ( key1 integer, key2 integer ) → boolean","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADVISORY-LOCKS-TABLE","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-advisory-unlock-shared","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_advisory_unlock_shared","Summary":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回true。如果锁没有被持有，则返回false，此外，服务器将报告一个SQL警告。","BodyHTML":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回\u003ccode\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回\u003ccode\u003efalse\u003c/code\u003e，此外，服务器将报告一个SQL警告。\u003cpre\u003epg_advisory_unlock_shared ( key bigint ) → boolean\u003c/pre\u003e释放以前获取的共享会话级咨询锁。如果锁成功释放则返回\u003ccode\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回\u003ccode\u003efalse\u003c/code\u003e，此外，服务器将报告一个SQL警告。\u003cpre\u003epg_advisory_unlock_shared ( key1 integer, key2 integer ) → boolean\u003c/pre\u003e释放以前获取的共享会话级咨询锁。如果锁成功释放则返回\u003ccode\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回\u003ccode\u003efalse\u003c/code\u003e，此外，服务器将报告一个SQL警告。","SourceRevision":"ca936764","ContentHash":"94482f32fbabbd47f72b98caf5e3860c7aed60359e30104244718b5c19a5124d","Payload":{"description_zh":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回true。如果锁没有被持有，则返回false，此外，服务器将报告一个SQL警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个SQL警告。","signatures":[{"description_zh":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回true。如果锁没有被持有，则返回false，此外，服务器将报告一个SQL警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个SQL警告。","returns":"boolean","text":"pg_advisory_unlock_shared ( key bigint ) → boolean","zh_from":"doc"},{"description_zh":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回true。如果锁没有被持有，则返回false，此外，服务器将报告一个SQL警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个SQL警告。","returns":"boolean","text":"pg_advisory_unlock_shared ( key1 integer, key2 integer ) → boolean","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"6ad769be489538c11444d637fdad7eb38e94d6ab414e3453ca3276b2b6184208","Text":"pg_advisory_unlock_shared ( key bigint ) → boolean","Returns":"boolean","Payload":{"description":"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.","description_html":"Releases a previously-acquired shared session-level advisory lock. Returns \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the lock is successfully released. If the lock was not held, \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e is returned, and in addition, an SQL warning will be reported by the server.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_advisory_unlock_shared\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003ekey\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_advisory_unlock_shared ( key bigint ) → boolean","zh_from":""}},{"Version":"18","Ordinal":1,"Hash":"daf17e22e44faeb6ce620bbe8e95b0578e2cba4da8ff3e765fa9b53f141452c5","Text":"pg_advisory_unlock_shared ( key1 integer, key2 integer ) → boolean","Returns":"boolean","Payload":{"description":"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.","description_html":"Releases a previously-acquired shared session-level advisory lock. Returns \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the lock is successfully released. If the lock was not held, \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e is returned, and in addition, an SQL warning will be reported by the server.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_advisory_unlock_shared\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003ekey1\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ekey2\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_advisory_unlock_shared ( key1 integer, key2 integer ) → boolean","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}