{"Entry":{"collection":"func","key":"pg-advisory-unlock-all","name":"pg_advisory_unlock_all","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":"148cceac73d526da7cd9b50489cb95c616b1e1fcfe5e634dd2833ee9b42d66df","derived_content_hash":"e21e8281f7e3a5554b5bba9135686b7704959e498891ed137b6c076d5cdc0913","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:67cecafd75962142d5f317edcff0ef03168f1843801dd1b31756a22c22a1e908","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.432048+08:00","last_version":"20","name":"pg_advisory_unlock_all","name_key":"pg_advisory_unlock_all","position":29008,"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:50f8d28b77c98beb124af98bb9040e3cba07678be64690fdbaa61d39a73090c5","receipt_sha256":"a5d7966438a9a5632cfbf32aa57d63e04d4acbfd0f044116e13c143d5fbb8dd1","repair":"wiki-repair-20261023"},"signature":"pg_advisory_unlock_all () → void","signature_count":1,"slug":"pg-advisory-unlock-all","source_rev":"wiki-repair-20261023:67cecafd75962142d5f317edcff0ef03168f1843801dd1b31756a22c22a1e908","summary":"Releases all session-level advisory locks held by the current session.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-advisory-unlock-all","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-advisory-unlock-all","SourceRevision":"wiki-repair-20261023:67cecafd75962142d5f317edcff0ef03168f1843801dd1b31756a22c22a1e908","Facts":{"description":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_html":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_zh":"释放当前会话所持有的所有会话级咨询锁。（即使客户端异常断开连接，这个函数也会在会话结束时被隐式调用。）","description_zh_html":"释放当前会话所持有的所有会话级咨询锁。（即使客户端异常断开连接，这个函数也会在会话结束时被隐式调用。）","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 all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_html":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_zh":"释放当前会话所持有的所有会话级咨询锁。（即使客户端异常断开连接，这个函数也会在会话结束时被隐式调用。）","description_zh_html":"释放当前会话所持有的所有会话级咨询锁。（即使客户端异常断开连接，这个函数也会在会话结束时被隐式调用。）","examples":[],"html":"\u003ccode class=\"function\"\u003epg_advisory_unlock_all\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003evoid\u003c/code\u003e","returns":"void","text":"pg_advisory_unlock_all () → void","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-all","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_advisory_unlock_all","Summary":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","BodyHTML":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","SourceRevision":"wiki-repair-20261023:67cecafd75962142d5f317edcff0ef03168f1843801dd1b31756a22c22a1e908","ContentHash":"3c4b8b73d3c44689203b0d8feb73d9382b592b30b98ce9747895c32508a094a8","Payload":{"description":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_html":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","signatures":[{"description":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_html":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_zh":"释放当前会话所持有的所有会话级咨询锁。（即使客户端异常断开连接，这个函数也会在会话结束时被隐式调用。）","description_zh_html":"释放当前会话所持有的所有会话级咨询锁。（即使客户端异常断开连接，这个函数也会在会话结束时被隐式调用。）","examples":[],"html":"\u003ccode class=\"function\"\u003epg_advisory_unlock_all\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003evoid\u003c/code\u003e","returns":"void","text":"pg_advisory_unlock_all () → void","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":"e59ebb9e0b34446df0f18f712ab99a6652b58c7f69b7957f1229c989baa5ece3","Text":"pg_advisory_unlock_all () → void","Returns":"void","Payload":{"description":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_html":"Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)","description_zh":"释放当前会话所持有的所有会话级咨询锁。（即使客户端异常断开连接，这个函数也会在会话结束时被隐式调用。）","description_zh_html":"释放当前会话所持有的所有会话级咨询锁。（即使客户端异常断开连接，这个函数也会在会话结束时被隐式调用。）","examples":[],"html":"\u003ccode class=\"function\"\u003epg_advisory_unlock_all\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003evoid\u003c/code\u003e","returns":"void","text":"pg_advisory_unlock_all () → void","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}