{"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","derived_content_hash":"28c86b70c409abb35ab95e660d271110f2ffcd603e03e6fc3567d2c583e7a02b","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:0ee0901256db8fd78cda1795ee5ff3f1eabd03ce3fc2425e3db40976fd333a7c","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"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"],"repair_provenance":{"original_source_revision":"wiki-repair-20261023:30f2923f0f276de151d07914d27ac0fdb91d3b725e94787558f901b27c33c39b","receipt_sha256":"91720fb86e1ab505a3b10bb9f6d2683e533878d0a52260f54976c81d1527e965","repair":"wiki-repair-20261023"},"signature":"pg_advisory_unlock_shared ( key bigint ) → boolean","signature_count":2,"slug":"pg-advisory-unlock-shared","source_rev":"wiki-repair-20261023:0ee0901256db8fd78cda1795ee5ff3f1eabd03ce3fc2425e3db40976fd333a7c","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":"wiki-repair-20261023:0ee0901256db8fd78cda1795ee5ff3f1eabd03ce3fc2425e3db40976fd333a7c","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":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 true。如果锁没有被持有，则返回 false，此外，服务器将报告一个 SQL 警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个 SQL 警告。","doc":{"anchor":"FUNCTIONS-ADVISORY-LOCKS-TABLE","file":"functions-admin.html","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","slug":"18"},"documentation_revision":{"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"},"group":"admin","group_label":"系统管理函数","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":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 true。如果锁没有被持有，则返回 false，此外，服务器将报告一个 SQL 警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个 SQL 警告。","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":"same-version-manual"},{"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":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 true。如果锁没有被持有，则返回 false，此外，服务器将报告一个 SQL 警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个 SQL 警告。","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":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-admin.html","sha256":"b4fab9daceb7883fd75b32b6eb5398f2bbbfbbed5c83d1b2bf99cc8d842cdaf7"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADVISORY-LOCKS-TABLE","file":"functions-admin.html","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-advisory-unlock-shared","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_advisory_unlock_shared","Summary":"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.","BodyHTML":"Releases a previously-acquired shared session-level advisory lock. Returns \u003ccode\u003etrue\u003c/code\u003e if the lock is successfully released. If the lock was not held, \u003ccode\u003efalse\u003c/code\u003e is returned, and in addition, an SQL warning will be reported by the server.","SourceRevision":"wiki-repair-20261023:0ee0901256db8fd78cda1795ee5ff3f1eabd03ce3fc2425e3db40976fd333a7c","ContentHash":"a5aec209a34d8e4667a1b6b4c5485ce34b6b7b748e7d17e6d6e05b97ac00582c","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.","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":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 true。如果锁没有被持有，则返回 false，此外，服务器将报告一个 SQL 警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个 SQL 警告。","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":"same-version-manual"},{"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":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 true。如果锁没有被持有，则返回 false，此外，服务器将报告一个 SQL 警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个 SQL 警告。","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":"same-version-manual"}]}},"RequestedLocale":"en","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":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 true。如果锁没有被持有，则返回 false，此外，服务器将报告一个 SQL 警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个 SQL 警告。","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":"same-version-manual"}},{"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":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 true。如果锁没有被持有，则返回 false，此外，服务器将报告一个 SQL 警告。","description_zh_html":"释放以前获取的共享会话级咨询锁。如果锁成功释放则返回 \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e。如果锁没有被持有，则返回 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，此外，服务器将报告一个 SQL 警告。","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":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}