{"Entry":{"collection":"func","key":"pg-advisory-unlock","name":"pg_advisory_unlock","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":"bb0c44b008ae7bc32903452578313c45e0a1295d8ef74cf41d2fd86d5ef325dc","derived_content_hash":"c463b57012fe2d65786685fd8a9fe05d242a67bc4c5191f103d779fc1d53c7cf","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:7c280201de5a327b7c7cdbcd9f330b42af8f2d9a861f740ab21620082c00a284","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.429107+08:00","last_version":"20","name":"pg_advisory_unlock","name_key":"pg_advisory_unlock","position":29007,"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:5a4df92a4bdf974c6acacdc1d550ce5720cc479bc301738482d6058e005bb08a","receipt_sha256":"39c44fba3f78b08c956a65b57a27ab93b06e14813c78443e35ea7eaf8b522087","repair":"wiki-repair-20261023"},"signature":"pg_advisory_unlock ( key bigint ) → boolean","signature_count":2,"slug":"pg-advisory-unlock","source_rev":"wiki-repair-20261023:7c280201de5a327b7c7cdbcd9f330b42af8f2d9a861f740ab21620082c00a284","summary":"Releases a previously-acquired exclusive session-level advisory lock.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-advisory-unlock","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-advisory-unlock","SourceRevision":"wiki-repair-20261023:7c280201de5a327b7c7cdbcd9f330b42af8f2d9a861f740ab21620082c00a284","Facts":{"description":"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.","description_html":"Releases a previously-acquired exclusive 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 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.","description_html":"Releases a previously-acquired exclusive 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\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 ( key bigint ) → boolean","zh_from":"same-version-manual"},{"description":"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.","description_html":"Releases a previously-acquired exclusive 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\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 ( 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","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_advisory_unlock","Summary":"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.","BodyHTML":"Releases a previously-acquired exclusive 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:7c280201de5a327b7c7cdbcd9f330b42af8f2d9a861f740ab21620082c00a284","ContentHash":"65e3d7bd4498d9f294f3af361e1165bde9a2491f8fdc19ea54a1bee9d5173825","Payload":{"description":"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.","description_html":"Releases a previously-acquired exclusive 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 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.","description_html":"Releases a previously-acquired exclusive 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\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 ( key bigint ) → boolean","zh_from":"same-version-manual"},{"description":"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.","description_html":"Releases a previously-acquired exclusive 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\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 ( 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":"8a88052b1191dace6987eb1cc7670db01926436af8daedd4a2a980367783caeb","Text":"pg_advisory_unlock ( key bigint ) → boolean","Returns":"boolean","Payload":{"description":"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.","description_html":"Releases a previously-acquired exclusive 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\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 ( key bigint ) → boolean","zh_from":"same-version-manual"}},{"Version":"18","Ordinal":1,"Hash":"4fb2a2ceaed15cf3a8f928f278ad1c90ffe9fc6f3316dbc82c3a36d50043d3a1","Text":"pg_advisory_unlock ( key1 integer, key2 integer ) → boolean","Returns":"boolean","Payload":{"description":"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.","description_html":"Releases a previously-acquired exclusive 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\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 ( key1 integer, key2 integer ) → boolean","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}