{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2020-05-14", "build": "9.5.22", "major": "9.5", "minor": 22, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.22", "eol_date": "2021-02-11", "date_text": "2020-05-14", "supported": false, "manual_url": "/docs/9.5/release-9-5-22.html", "source_url": "/docs/release/9.5.22/", "entry_count": 33, "placeholder": false, "content_hash": "30157d9cdb12db932469be2705ecfe5382a09e5af47390a8222bfde852c483a8", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 33, "doc_loaded_at": "2026-09-26T02:56:44.718140", "migration_html": "<p>对于运行 9.5.X 的用户，不需要转储/恢复。</p>\n<p>不过，如果你是从 9.5.20 之前的版本升级，参见<a href=\"/docs/9.5/release-9-5-20.html\" title=\"E.6. 版本 9.5.20\">第 E.6 节</a>。</p>", "compatibility_count": 0, "label": "9.5.22", "status_label": "历史版本", "eol": "2021-02-11", "age_days": 2330, "support_days": -2057}, "groups": [{"date": "2020-05-14", "build": "9.5.22", "major": "9.5", "minor": 22, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.22", "eol_date": "2021-02-11", "date_text": "2020-05-14", "supported": false, "manual_url": "/docs/9.5/release-9-5-22.html", "source_url": "/docs/release/9.5.22/", "entry_count": 33, "placeholder": false, "content_hash": "30157d9cdb12db932469be2705ecfe5382a09e5af47390a8222bfde852c483a8", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 33, "doc_loaded_at": "2026-09-26T02:56:44.718140", "migration_html": "<p>对于运行 9.5.X 的用户，不需要转储/恢复。</p>\n<p>不过，如果你是从 9.5.20 之前的版本升级，参见<a href=\"/docs/9.5/release-9-5-20.html\" title=\"E.6. 版本 9.5.20\">第 E.6 节</a>。</p>", "compatibility_count": 0, "label": "9.5.22", "status_label": "历史版本", "eol": "2021-02-11", "age_days": 2330, "support_days": -2057, "entries": [{"id": "9.5.22-78ac153ed45e974e", "cves": [], "html": "<p>保留被 <code>ALTER TABLE</code> 重写的索引的 <code>indisclustered</code> 设置（Amit Langote、Justin Pryzby）</p>\n<p>此前，<code>ALTER TABLE</code> 会丢失哪个索引用于过 <code>CLUSTER</code> 的记录。</p>", "text": "保留被 ALTER TABLE 重写的索引的 indisclustered 设置（Amit Langote、Justin Pryzby） 此前，ALTER TABLE 会丢失哪个索引用于过 CLUSTER 的记录。", "title": "保留被 ALTER TABLE 重写的索引的 indisclustered 设置", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "7642559d43ceb4ab95593d3871b37661f8e0221001061680a694f127c84274f1", "section_path": ["变更"], "commit_groups": [["3e62dd3a9", "3f77a6702", "41faafbd7", "61a161fe4", "a40caf5f8", "cef2b8d52"]], "identity_text": "Preserve the indisclustered setting of indexes rewritten by ALTER TABLE (Amit Langote, Justin Pryzby) Previously, ALTER TABLE lost track of which index had been used for CLUSTER.", "commit_aliases": ["3e62dd3a9", "3f77a6702", "41faafbd7", "61a161fe4", "a40caf5f8", "cef2b8d52"], "source_commits": ["3f77a6702"], "source_entry_id": "9.5.22/changes/001", "db_id": "65a191e2b5bcc36adf6eefaa83040fa7", "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4", "relations": [{"rule": 2, "type": "equivalent", "target": "52ecc0d4cc8abdd919ce40c9c2820454", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}}, {"rule": 2, "type": "equivalent", "target": "620d5b1e2a35bdfa579cba009111e695", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}}, {"rule": 2, "type": "equivalent", "target": "9d3feb851533a7bd7f80b46a32b96b76", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}}, {"rule": 2, "type": "equivalent", "target": "d107db295029a5527f462c1bff6c1a27", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "52ecc0d4cc8abdd919ce40c9c2820454", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "保留由 ALTER TABLE 重写的索引的 indisclustered 设置", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}, "url": "/docs/compare/?release=12.3#12.3-4d459a22fa14784c", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "d107db295029a5527f462c1bff6c1a27", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "保留由 ALTER TABLE 重写的索引的 indisclustered 设置", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}, "url": "/docs/compare/?release=11.8#11.8-3a0eef37db292531", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "620d5b1e2a35bdfa579cba009111e695", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "保留由 ALTER TABLE 重写的索引的 indisclustered 设置", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}, "url": "/docs/compare/?release=10.13#10.13-3a0eef37db292531", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "9d3feb851533a7bd7f80b46a32b96b76", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "保留被 ALTER TABLE 重写的索引的 indisclustered 设置", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}, "url": "/docs/compare/?release=9.6.18#9.6.18-78ac153ed45e974e", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-9c4d55e6730370e2", "cves": [], "html": "<p>保留被 <code>ALTER TABLE</code> 重写的索引的副本身份属性（Quan Zongliang、Peter Eisentraut）</p>", "text": "保留被 ALTER TABLE 重写的索引的副本身份属性（Quan Zongliang、Peter Eisentraut）", "title": "保留被 ALTER TABLE 重写的索引的副本身份属性", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "b859cfdb47bd44b1d58936d66c59a2467c91c00e51d6dd536830b3407ce7b817", "section_path": ["变更"], "commit_groups": [["02530da73", "15cbbf81a", "1cc9c2412", "2f0dd9d93", "c15d35041", "c9ef507e8"]], "identity_text": "Preserve the replica identity properties of indexes rewritten by ALTER TABLE (Quan Zongliang, Peter Eisentraut)", "commit_aliases": ["02530da73", "15cbbf81a", "1cc9c2412", "2f0dd9d93", "c15d35041", "c9ef507e8"], "source_commits": ["c15d35041"], "source_entry_id": "9.5.22/changes/002", "db_id": "9189c4123c00f9dbcd0c24c57151433f", "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0", "relations": [{"rule": 2, "type": "equivalent", "target": "7524e5da19e7e21429f369e719cc627b", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}}, {"rule": 2, "type": "equivalent", "target": "7c7f78d697ceda39bbb2282b08683ed2", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}}, {"rule": 2, "type": "equivalent", "target": "97f8a7f5579d633d7c8874b8cb9efc79", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}}, {"rule": 2, "type": "equivalent", "target": "984926ec824bea70185d470ecb69ee2c", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "7c7f78d697ceda39bbb2282b08683ed2", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "保留由 ALTER TABLE 重写的索引的复制标识属性", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}, "url": "/docs/compare/?release=12.3#12.3-8c748217e5dc8031", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "7524e5da19e7e21429f369e719cc627b", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "保留由 ALTER TABLE 重写的索引的复制标识属性", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}, "url": "/docs/compare/?release=11.8#11.8-dc3633495c3ae37e", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "984926ec824bea70185d470ecb69ee2c", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "保留由 ALTER TABLE 重写的索引的复制标识属性", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}, "url": "/docs/compare/?release=10.13#10.13-dc3633495c3ae37e", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "97f8a7f5579d633d7c8874b8cb9efc79", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "保留被 ALTER TABLE 重写的索引的副本身份属性", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}, "url": "/docs/compare/?release=9.6.18#9.6.18-9c4d55e6730370e2", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-a169fd265e1fb8da", "cves": [], "html": "<p>在 <code>DROP OWNED BY</code> 期间更早地锁定对象（Álvaro Herrera）</p>\n<p>这避免了另一会话正在删除部分相同对象的竞态情况下的失败。</p>", "text": "在 DROP OWNED BY 期间更早地锁定对象（Álvaro Herrera） 这避免了另一会话正在删除部分相同对象的竞态情况下的失败。", "title": "在 DROP OWNED BY 期间更早地锁定对象", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "b4f96bd66c75c73fd1ad59e03ab8ca7bec4a6adc7afbb28f7db6be9f5536fd01", "section_path": ["变更"], "commit_groups": [["2bf56f50e", "2eea49471", "4d21263ff", "59273a7ce", "5be594caf", "91d97462c"]], "identity_text": "Lock objects sooner during DROP OWNED BY (Álvaro Herrera) This avoids failures in race-condition cases where another session is deleting some of the same objects.", "commit_aliases": ["2bf56f50e", "2eea49471", "4d21263ff", "59273a7ce", "5be594caf", "91d97462c"], "source_commits": ["91d97462c"], "source_entry_id": "9.5.22/changes/003", "db_id": "4daaa443285739f9d53ae1c69016a44d", "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d", "relations": [{"rule": 2, "type": "equivalent", "target": "772e2a40689c1ca396d33ecc55e1b9c3", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}}, {"rule": 2, "type": "equivalent", "target": "90546408dd43a05d233aea11bd7febb1", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}}, {"rule": 2, "type": "equivalent", "target": "b880955b0903f08de5edd387587989cf", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}}, {"rule": 2, "type": "equivalent", "target": "caabcd93149b6e748a51634556714b66", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "772e2a40689c1ca396d33ecc55e1b9c3", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 DROP OWNED BY 期间更早地锁定对象", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}, "url": "/docs/compare/?release=12.3#12.3-7524755657239ae6", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "caabcd93149b6e748a51634556714b66", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "在 DROP OWNED BY 期间更早地锁定对象", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}, "url": "/docs/compare/?release=11.8#11.8-a169fd265e1fb8da", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "90546408dd43a05d233aea11bd7febb1", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "在 DROP OWNED BY 期间更早地锁定对象", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}, "url": "/docs/compare/?release=10.13#10.13-a169fd265e1fb8da", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "b880955b0903f08de5edd387587989cf", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "在 DROP OWNED BY 期间更早地锁定对象", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}, "url": "/docs/compare/?release=9.6.18#9.6.18-a169fd265e1fb8da", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-5faff5e0ce585418", "cves": [], "html": "<p>修复 <code>CREATE ROLE ... IN ROLE</code> 的错误情况处理（Andrew Gierth）</p>\n<p>某些错误情况会被报告为 <span>“<span>unexpected node type</span>”</span> 之类，而不是预期的消息。</p>", "text": "修复 CREATE ROLE ... IN ROLE 的错误情况处理（Andrew Gierth） 某些错误情况会被报告为 “unexpected node type” 之类，而不是预期的消息。", "title": "修复 CREATE ROLE ... IN ROLE 的错误情况处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "b746e99dcedcf958f3beec12126cc2a8c91d16f1dc326d7056dafdf951aceb52", "section_path": ["变更"], "commit_groups": [["0f4970d1a", "287f6d2d9", "86b7a4e6f", "b3824ca22", "d0360632d", "d9a4cce29"]], "identity_text": "Fix error-case processing for CREATE ROLE ... IN ROLE (Andrew Gierth) Some error cases would be reported as unexpected node type or the like, instead of the intended message.", "commit_aliases": ["0f4970d1a", "287f6d2d9", "86b7a4e6f", "b3824ca22", "d0360632d", "d9a4cce29"], "source_commits": ["b3824ca22"], "source_entry_id": "9.5.22/changes/004", "db_id": "ff88690f590c6b2db573e5b359beebb7", "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e", "relations": [{"rule": 2, "type": "equivalent", "target": "ac10184120a6201dc5a23020315c9d20", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}}, {"rule": 2, "type": "equivalent", "target": "d71b6196cb3f83fef5fcb5c4f6e84849", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}}, {"rule": 2, "type": "equivalent", "target": "f32ccadcd1b96be90e58dd86ae477aa3", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}}, {"rule": 2, "type": "equivalent", "target": "f64514781f36efd6407c638a79349547", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f64514781f36efd6407c638a79349547", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 CREATE ROLE ... IN ROLE 的错误情况处理", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}, "url": "/docs/compare/?release=12.3#12.3-1a0519cbce8717ae", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "ac10184120a6201dc5a23020315c9d20", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 CREATE ROLE ... IN ROLE 的错误情况处理", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}, "url": "/docs/compare/?release=11.8#11.8-5faff5e0ce585418", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "d71b6196cb3f83fef5fcb5c4f6e84849", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 CREATE ROLE ... IN ROLE 的错误情况处理", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}, "url": "/docs/compare/?release=10.13#10.13-5faff5e0ce585418", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "f32ccadcd1b96be90e58dd86ae477aa3", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 CREATE ROLE ... IN ROLE 的错误情况处理", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}, "url": "/docs/compare/?release=9.6.18#9.6.18-5faff5e0ce585418", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-46e30f1f6da58564", "cves": [], "html": "<p>修复 <code>gin_fuzzy_search_limit</code> 处理中的 bug（Adé Heyward、Tom Lane）</p>\n<p><code>gin_fuzzy_search_limit</code> 的值较小时，可能因无意中多次重新扫描同一索引页而导致意外缓慢。另一条代码路径则完全没有应用预期的过滤，可能返回过多的值。</p>", "text": "修复 gin_fuzzy_search_limit 处理中的 bug（Adé Heyward、Tom Lane） gin_fuzzy_search_limit 的值较小时，可能因无意中多次重新扫描同一索引页而导致意外缓慢。另一条代码路径则完全没有应用预期的过滤，可能返回过多的值。", "title": "修复 gin_fuzzy_search_limit 处理中的 bug", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "c9211a831f52431921d0b9898605156ac3882fb4e264bbcda620e350d6096600", "section_path": ["变更"], "commit_groups": [["05f4a8818", "0912fb39c", "44c763fe9", "49b0d13d7", "8150f7813", "e41955faf"], ["e82b6e00a"]], "identity_text": "Fix bugs in gin_fuzzy_search_limit processing (Adé Heyward, Tom Lane) A small value of gin_fuzzy_search_limit could result in unexpected slowness due to unintentionally rescanning the same index page many times. Another code path failed to apply the intended filtering at all, possibly returning too many values.", "commit_aliases": ["05f4a8818", "0912fb39c", "44c763fe9", "49b0d13d7", "8150f7813", "e41955faf", "e82b6e00a"], "source_commits": ["8150f7813", "e82b6e00a"], "source_entry_id": "9.5.22/changes/005", "db_id": "f6f36ce7d2957806f7d55a306c174856", "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e", "relations": [{"rule": 2, "type": "equivalent", "target": "09584b0af0680ba4e6050bf38472cff4", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}}, {"rule": 2, "type": "equivalent", "target": "1e5f67b8aae46bd27e453f940f6b9eb0", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}}, {"rule": 2, "type": "equivalent", "target": "93dbe527a90d99e13678426a914b3416", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}}, {"rule": 2, "type": "equivalent", "target": "fecd827b2710a5609eedf3dcb1d03184", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "09584b0af0680ba4e6050bf38472cff4", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 gin_fuzzy_search_limit 处理中的缺陷", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}, "url": "/docs/compare/?release=12.3#12.3-193854715e7e97a9", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "1e5f67b8aae46bd27e453f940f6b9eb0", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 gin_fuzzy_search_limit 处理中的缺陷", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}, "url": "/docs/compare/?release=11.8#11.8-5259498d78a24be6", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "fecd827b2710a5609eedf3dcb1d03184", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 gin_fuzzy_search_limit 处理中的缺陷", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}, "url": "/docs/compare/?release=10.13#10.13-5259498d78a24be6", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "93dbe527a90d99e13678426a914b3416", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 gin_fuzzy_search_limit 处理中的 bug", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}, "url": "/docs/compare/?release=9.6.18#9.6.18-46e30f1f6da58564", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-cdc70eed27abebe7", "cves": [], "html": "<p>允许 <code>circle</code> 类型的输入接受文档所述的 <span>“<span><code>(<em><code>x</code></em>,<em><code>y</code></em>),<em><code>r</code></em></code></span>”</span> 格式（David Zhang）</p>", "text": "允许 circle 类型的输入接受文档所述的 “(x,y),r” 格式（David Zhang）", "title": "允许 circle 类型的输入接受文档所述的 “(x,y),r” 格式", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "ffe165dbd6c3b5d3c760e9faeaab0a41d693ded1bde8d67ff6d34d88e63453d1", "section_path": ["变更"], "commit_groups": [["049e9f48e", "35d1eefb2", "41a194f49", "4c7a311a2", "5fae66410", "ebd194ac5"]], "identity_text": "Allow input of type circle to accept the format (x,y),r as the documentation says it does (David Zhang)", "commit_aliases": ["049e9f48e", "35d1eefb2", "41a194f49", "4c7a311a2", "5fae66410", "ebd194ac5"], "source_commits": ["ebd194ac5"], "source_entry_id": "9.5.22/changes/006", "db_id": "02a4159dc5fe88a2758c2487d288fda8", "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94", "relations": [{"rule": 2, "type": "equivalent", "target": "3f2df768da8f3bf407764cff619d1fc3", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}}, {"rule": 2, "type": "equivalent", "target": "49b648b768d3a6bc8863806258218bd0", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}}, {"rule": 2, "type": "equivalent", "target": "f325785ed83a0c11f112cc710c25838e", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}}, {"rule": 2, "type": "equivalent", "target": "fa76a6a1501c7fbabbcb6ebe705a09b1", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa76a6a1501c7fbabbcb6ebe705a09b1", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "允许 circle 类型的输入按文档所述接受 “(x,y),r” 格式", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}, "url": "/docs/compare/?release=12.3#12.3-d7d01c1a0f6d276b", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "f325785ed83a0c11f112cc710c25838e", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "允许 circle 类型的输入按文档所述接受 “(x,y),r” 格式", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}, "url": "/docs/compare/?release=11.8#11.8-7bab0555f16380bd", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "49b648b768d3a6bc8863806258218bd0", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "允许 circle 类型的输入按文档所述接受 “(x,y),r” 格式", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}, "url": "/docs/compare/?release=10.13#10.13-7bab0555f16380bd", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "3f2df768da8f3bf407764cff619d1fc3", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "允许 circle 类型的输入接受文档所述的 “(x,y),r” 格式", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}, "url": "/docs/compare/?release=9.6.18#9.6.18-cdc70eed27abebe7", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-030f702a88b76b01", "cves": [], "html": "<p>让 <code>get_bit()</code> 和 <code>set_bit()</code> 函数应对长于 256MB 的 <code>bytea</code> 字符串（Movead Li）</p>\n<p>由于位号参数只有 <code>int4</code>，不可能用这些函数访问长 <code>bytea</code> 前 256MB 之外的位。我们将在 v13 中把参数放宽为 <code>int8</code>，但在此之前，允许这些函数处理长 <code>bytea</code> 的初始子串。</p>", "text": "让 get_bit() 和 set_bit() 函数应对长于 256MB 的 bytea 字符串（Movead Li） 由于位号参数只有 int4，不可能用这些函数访问长 bytea 前 256MB 之外的位。我们将在 v13 中把参数放宽为 int8，但在此之前，允许这些函数处理长 bytea 的初始子串。", "title": "让 get_bit() 和 set_bit() 函数应对长于 256MB 的 bytea 字符串", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "89fdbda6ce157d75e71ed8eec44cfadd46f9ec9d2ab41b9db157bb71faf5714a", "section_path": ["变更"], "commit_groups": [["26a944cf2", "5d79fc60c", "6e6b74a20", "889786e0e", "dbb121038", "e40c4d491"]], "identity_text": "Make the get_bit() and set_bit() functions cope with bytea strings longer than 256MB (Movead Li) Since the bit number argument is only int4, it's impossible to use these functions to access bits beyond the first 256MB of a long bytea. We'll widen the argument to int8 in v13, but in the meantime, allow these functions to work on the initial substring of a long bytea.", "commit_aliases": ["26a944cf2", "5d79fc60c", "6e6b74a20", "889786e0e", "dbb121038", "e40c4d491"], "source_commits": ["dbb121038"], "source_entry_id": "9.5.22/changes/007", "db_id": "73bef7cb7ccfd7e6c375b8b1bf28469a", "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90", "relations": [{"rule": 2, "type": "equivalent", "target": "0ea209ac716ba0f4bed1d348ba9b11e8", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}}, {"rule": 2, "type": "related", "target": "36951132033efe9497121c46a1b696f0", "evidence": {"same_day": false, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"]}}, {"rule": 2, "type": "equivalent", "target": "bd37d88fde696a029e43ffc64a6db4aa", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}}, {"rule": 2, "type": "equivalent", "target": "c9ab8b3b22e6103c90868ddecabecbb7", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}}, {"rule": 2, "type": "equivalent", "target": "f5409b29c53848f4f3a571148b1b7a0b", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "36951132033efe9497121c46a1b696f0", "kind": "related", "version": "13.0", "label": "13.0", "title": "允许 get_bit() 和 set_bit() 设置 bytea 值前 256MB 之外的位", "evidence": {"same_day": false, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"]}, "url": "/docs/compare/?release=13.0#13.0-9211d3b40994cff4", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.7"}, {"db_id": "c9ab8b3b22e6103c90868ddecabecbb7", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "使 get_bit() 和 set_bit() 函数能够处理长于 256MB 的 bytea 字符串", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}, "url": "/docs/compare/?release=12.3#12.3-4330b9ced58daa0c", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "0ea209ac716ba0f4bed1d348ba9b11e8", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "使 get_bit() 和 set_bit() 函数能够处理长于 256MB 的 bytea 字符串", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}, "url": "/docs/compare/?release=11.8#11.8-ca336e3d80787ea1", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "f5409b29c53848f4f3a571148b1b7a0b", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "使 get_bit() 和 set_bit() 函数能够处理长于 256MB 的 bytea 字符串", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}, "url": "/docs/compare/?release=10.13#10.13-ca336e3d80787ea1", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "bd37d88fde696a029e43ffc64a6db4aa", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "让 get_bit() 和 set_bit() 函数应对长于 256MB 的 bytea 字符串", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}, "url": "/docs/compare/?release=9.6.18#9.6.18-030f702a88b76b01", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-16fc7a96aad45414", "cves": [], "html": "<p>避免 <code>pg_ls_dir()</code>、<code>pg_timezone_names()</code>、<code>pg_tablespace_databases()</code> 及相关函数可能泄漏打开的目录文件描述符（Justin Pryzby）</p>", "text": "避免 pg_ls_dir()、pg_timezone_names()、pg_tablespace_databases() 及相关函数可能泄漏打开的目录文件描述符（Justin Pryzby）", "title": "避免 pg_ls_dir()、pg_timezone_names()、pg_tablespace_databases() 及相关函数可能泄漏打开的目录文件描述符", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "a4e37edb20b10a51658209e260345a1861a5e9411f0a84095bf52b11be1650cd", "section_path": ["变更"], "commit_groups": [["05283dd5b", "085b6b667", "3c8864fc1", "63b51dfec"], ["064e029e6", "13f353b0e", "630590d6f", "a029a0641"], ["2a89455aa", "5e4a0b719", "819d55257", "b4570d33a", "cd6a05187", "da254148f"]], "identity_text": "Avoid possibly leaking an open-file descriptor for a directory in pg_ls_dir(), pg_timezone_names(), pg_tablespace_databases(), and allied functions (Justin Pryzby)", "commit_aliases": ["05283dd5b", "064e029e6", "085b6b667", "13f353b0e", "2a89455aa", "3c8864fc1", "5e4a0b719", "630590d6f", "63b51dfec", "819d55257", "a029a0641", "b4570d33a", "cd6a05187", "da254148f"], "source_commits": ["085b6b667", "a029a0641", "da254148f"], "source_entry_id": "9.5.22/changes/008", "db_id": "6518d4773783a87134e5073515347704", "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152", "relations": [{"rule": 2, "type": "equivalent", "target": "3002d0cf86be9cc1f814b6ae533276b6", "evidence": {"same_day": true, "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152"}}, {"rule": 2, "type": "equivalent", "target": "3651e77329c1b8cbf43057557a78f2f0", "evidence": {"same_day": true, "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152"}}, {"rule": 2, "type": "equivalent", "target": "6e4a007c94e742e531786dbfdb04e421", "evidence": {"same_day": true, "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152"}}, {"rule": 2, "type": "equivalent", "target": "e7671b3a3d8cfeddb3a8df698a63eea4", "evidence": {"same_day": true, "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e7671b3a3d8cfeddb3a8df698a63eea4", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "避免 pg_ls_dir()、pg_timezone_names()、pg_tablespace_databases() 及相关函数可能泄漏目录的打开文件描述符", "evidence": {"same_day": true, "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152"}, "url": "/docs/compare/?release=12.3#12.3-b44f6daddd387391", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "6e4a007c94e742e531786dbfdb04e421", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "避免 pg_ls_dir()、pg_timezone_names()、pg_tablespace_databases() 及相关函数可能泄漏目录的打开文件描述符", "evidence": {"same_day": true, "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152"}, "url": "/docs/compare/?release=11.8#11.8-37bd61020f50b305", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "3002d0cf86be9cc1f814b6ae533276b6", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "避免 pg_ls_dir()、pg_timezone_names()、pg_tablespace_databases() 及相关函数可能泄漏目录的打开文件描述符", "evidence": {"same_day": true, "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152"}, "url": "/docs/compare/?release=10.13#10.13-37bd61020f50b305", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "3651e77329c1b8cbf43057557a78f2f0", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "避免 pg_ls_dir()、pg_timezone_names()、pg_tablespace_databases() 及相关函数可能泄漏打开的目录文件描述符", "evidence": {"same_day": true, "patch_ids": ["6965fab968b0028d99d3375bf6bf3a81", "b07ac928d42a5f36e1085a6187339d06", "d35664a827be025d5e11684c5683ffbf"], "statement_hash": "8914a59000e449b21e0f0467c5e9306d9a22e8cab1a3950508d35c8873b0e152"}, "url": "/docs/compare/?release=9.6.18#9.6.18-16fc7a96aad45414", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-0ef4214f6455de4b", "cves": [], "html": "<p>修复多态函数类型解析，使其在只给出 <code>anyrange</code> 输入时正确推断 <code>anyarray</code> 输出的实际类型（Tom Lane）</p>", "text": "修复多态函数类型解析，使其在只给出 anyrange 输入时正确推断 anyarray 输出的实际类型（Tom Lane）", "title": "修复多态函数类型解析，使其在只给出 anyrange 输入时正确推断 anyarray 输出的实际类型", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "164111d68c4ae1531554d19274f4438e98f86a10eea9e9e62a9bd1d9d615d79c", "section_path": ["变更"], "commit_groups": [["30e491653", "390984f92", "4dbcb3f84", "540ef37cc", "61d14971d", "a1ef0f373"]], "identity_text": "Fix polymorphic-function type resolution to correctly infer the actual type of an anyarray output when given only an anyrange input (Tom Lane)", "commit_aliases": ["30e491653", "390984f92", "4dbcb3f84", "540ef37cc", "61d14971d", "a1ef0f373"], "source_commits": ["a1ef0f373"], "source_entry_id": "9.5.22/changes/009", "db_id": "687c29378d9400cc17df64f60c36172b", "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e", "relations": [{"rule": 2, "type": "equivalent", "target": "41354b0878062eb0c0cc0c69aa37f30f", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}}, {"rule": 2, "type": "equivalent", "target": "599c96a091f3961e0670a9ef44822842", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}}, {"rule": 2, "type": "equivalent", "target": "5ffb8a7e83a86ba7bf69175991f079e4", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}}, {"rule": 2, "type": "equivalent", "target": "ca1e27769aa9ef58d169a884cf871cfd", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "599c96a091f3961e0670a9ef44822842", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复多态函数的类型解析，使其仅给定 anyrange 输入时，也能正确推断 anyarray 输出的实际类型", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}, "url": "/docs/compare/?release=12.3#12.3-66cc4092623868fe", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "5ffb8a7e83a86ba7bf69175991f079e4", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复多态函数的类型解析，使其仅给定 anyrange 输入时，也能正确推断 anyarray 输出的实际类型", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}, "url": "/docs/compare/?release=11.8#11.8-086421a9a86e829d", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "ca1e27769aa9ef58d169a884cf871cfd", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复多态函数的类型解析，使其仅给定 anyrange 输入时，也能正确推断 anyarray 输出的实际类型", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}, "url": "/docs/compare/?release=10.13#10.13-086421a9a86e829d", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "41354b0878062eb0c0cc0c69aa37f30f", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复多态函数类型解析，使其在只给出 anyrange 输入时正确推断 anyarray 输出的实际类型", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}, "url": "/docs/compare/?release=9.6.18#9.6.18-0ef4214f6455de4b", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-59284c3f3f51e4e6", "cves": [], "html": "<p>避免 <code>REINDEX</code> 被会话关闭信号终止时不太可能的崩溃（Tom Lane）</p>", "text": "避免 REINDEX 被会话关闭信号终止时不太可能的崩溃（Tom Lane）", "title": "避免 REINDEX 被会话关闭信号终止时不太可能的崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "bceb4b70b8bedd02a318051a781c30a05d851c9875f56564624009f24e228cc5", "section_path": ["变更"], "commit_groups": [["36714f8ca", "56259c377", "5a4efd100", "5c1c27eef", "d12bdba77", "e6c17c85a"]], "identity_text": "Avoid unlikely crash when REINDEX is terminated by a session-shutdown signal (Tom Lane)", "commit_aliases": ["36714f8ca", "56259c377", "5a4efd100", "5c1c27eef", "d12bdba77", "e6c17c85a"], "source_commits": ["36714f8ca"], "source_entry_id": "9.5.22/changes/010", "db_id": "a8ee89fc7cc017fcf58ef70b534e8e4a", "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf", "relations": [{"rule": 2, "type": "equivalent", "target": "470958c617fce082ce01f09045d87294", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}}, {"rule": 2, "type": "equivalent", "target": "8e77a4cbf712530695ebc246fff6d222", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}}, {"rule": 2, "type": "equivalent", "target": "ca91ad43271b31819041e045b6c093cb", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}}, {"rule": 2, "type": "equivalent", "target": "d883634d5a0b645136c5e0cc28cb9dac", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ca91ad43271b31819041e045b6c093cb", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "避免 REINDEX 被会话关闭信号终止时不太可能发生的崩溃", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}, "url": "/docs/compare/?release=12.3#12.3-9301d33327f1df9f", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "d883634d5a0b645136c5e0cc28cb9dac", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "避免 REINDEX 被会话关闭信号终止时不太可能发生的崩溃", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}, "url": "/docs/compare/?release=11.8#11.8-c287f3c512e0cfaa", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "470958c617fce082ce01f09045d87294", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "避免 REINDEX 被会话关闭信号终止时不太可能发生的崩溃", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}, "url": "/docs/compare/?release=10.13#10.13-c287f3c512e0cfaa", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "8e77a4cbf712530695ebc246fff6d222", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "避免 REINDEX 被会话关闭信号终止时不太可能的崩溃", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}, "url": "/docs/compare/?release=9.6.18#9.6.18-59284c3f3f51e4e6", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-64df1d61f3e893da", "cves": [], "html": "<p>防止 <code>EXPLAIN</code> 打印可能不正确的哈希连接表统计信息（Konstantin Knizhnik、Tom Lane、Thomas Munro）</p>", "text": "防止 EXPLAIN 打印可能不正确的哈希连接表统计信息（Konstantin Knizhnik、Tom Lane、Thomas Munro）", "title": "防止 EXPLAIN 打印可能不正确的哈希连接表统计信息", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "5801c8cf0248e97abf166e4e1f50a8515c5e7ad705ccea23f3240df221282b49", "section_path": ["变更"], "commit_groups": [["1e6bb6125", "242ca479f", "30ce86367", "5c27bce7f", "8ffb86644", "f3d06e524"]], "identity_text": "Prevent printout of possibly-incorrect hash join table statistics in EXPLAIN (Konstantin Knizhnik, Tom Lane, Thomas Munro)", "commit_aliases": ["1e6bb6125", "242ca479f", "30ce86367", "5c27bce7f", "8ffb86644", "f3d06e524"], "source_commits": ["30ce86367"], "source_entry_id": "9.5.22/changes/011", "db_id": "0b69cf96620a007e873e288dfec21e5c", "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6", "relations": [{"rule": 2, "type": "equivalent", "target": "6ae9cf112681e0d57b773127c74e7e9a", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}}, {"rule": 2, "type": "equivalent", "target": "955099ee349d2397f1db43973f3a00cc", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}}, {"rule": 2, "type": "equivalent", "target": "acb9bc74cea9bb725741f4b518b7d085", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}}, {"rule": 2, "type": "equivalent", "target": "d5b3cc0f62b878c539db27f07470e4cf", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "6ae9cf112681e0d57b773127c74e7e9a", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "防止 EXPLAIN 输出可能不正确的哈希连接表统计信息", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}, "url": "/docs/compare/?release=12.3#12.3-33ce58e1ee58dfbb", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "acb9bc74cea9bb725741f4b518b7d085", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "防止 EXPLAIN 输出可能不正确的哈希连接表统计信息", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}, "url": "/docs/compare/?release=11.8#11.8-5c39232081c348b8", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "d5b3cc0f62b878c539db27f07470e4cf", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "防止 EXPLAIN 输出可能不正确的哈希连接表统计信息", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}, "url": "/docs/compare/?release=10.13#10.13-5c39232081c348b8", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "955099ee349d2397f1db43973f3a00cc", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "防止 EXPLAIN 打印可能不正确的哈希连接表统计信息", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}, "url": "/docs/compare/?release=9.6.18#9.6.18-64df1d61f3e893da", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-a4ad8ab2bac81621", "cves": [], "html": "<p>修复 <code>VACUUM VERBOSE</code> 中堆截断步骤所用时间的报告（Tatsuhito Kasahara）</p>", "text": "修复 VACUUM VERBOSE 中堆截断步骤所用时间的报告（Tatsuhito Kasahara）", "title": "修复 VACUUM VERBOSE 中堆截断步骤所用时间的报告", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "956489f4bffa576d5fe758f6a9c0ef39cacfe40f1301316b8a953f87cbaa5ca4", "section_path": ["变更"], "commit_groups": [["007491979", "16e6c968b", "307c27037", "414ed1ca2", "4a3f164b7", "79f344d52"]], "identity_text": "Fix reporting of elapsed time for heap truncation steps in VACUUM VERBOSE (Tatsuhito Kasahara)", "commit_aliases": ["007491979", "16e6c968b", "307c27037", "414ed1ca2", "4a3f164b7", "79f344d52"], "source_commits": ["4a3f164b7"], "source_entry_id": "9.5.22/changes/012", "db_id": "be137f76a1ae493f53cfb3d23ee2e247", "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc", "relations": [{"rule": 2, "type": "equivalent", "target": "344ea7e477af969207ab4e124de71907", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}}, {"rule": 2, "type": "equivalent", "target": "77a1e10a809727d4e8e804035b515ae8", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}}, {"rule": 2, "type": "equivalent", "target": "88c1644901e76c430dd137b8d694c8b6", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}}, {"rule": 2, "type": "equivalent", "target": "8a633a7ef2133d8fa0646de0147187f2", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "344ea7e477af969207ab4e124de71907", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 VACUUM VERBOSE 对堆截断步骤耗时的报告", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}, "url": "/docs/compare/?release=12.3#12.3-88379a7c527ad2c4", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "88c1644901e76c430dd137b8d694c8b6", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 VACUUM VERBOSE 对堆截断步骤耗时的报告", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}, "url": "/docs/compare/?release=11.8#11.8-80b9d060d40bebed", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "8a633a7ef2133d8fa0646de0147187f2", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 VACUUM VERBOSE 对堆截断步骤耗时的报告", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}, "url": "/docs/compare/?release=10.13#10.13-80b9d060d40bebed", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "77a1e10a809727d4e8e804035b515ae8", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 VACUUM VERBOSE 中堆截断步骤所用时间的报告", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}, "url": "/docs/compare/?release=9.6.18#9.6.18-a4ad8ab2bac81621", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-f648cc703038394b", "cves": [], "html": "<p>避免进程的 PS 状态中可能两次显示 <span>“<span>waiting</span>”</span>（Masahiko Sawada）</p>", "text": "避免进程的 PS 状态中可能两次显示 “waiting”（Masahiko Sawada）", "title": "避免进程的 PS 状态中可能两次显示 “waiting”", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "6e9e8db344a83e623a181aa17c8d6a654a1033a2bbe85cb1a4118024e762f269", "section_path": ["变更"], "commit_groups": [["17d3fcdc3", "82c04e483", "c9a47b81e", "d1b414e7e", "e54183cb0", "e9c4eaacd"]], "identity_text": "Avoid possibly showing waiting twice in a process's PS status (Masahiko Sawada)", "commit_aliases": ["17d3fcdc3", "82c04e483", "c9a47b81e", "d1b414e7e", "e54183cb0", "e9c4eaacd"], "source_commits": ["c9a47b81e"], "source_entry_id": "9.5.22/changes/013", "db_id": "bc7286641728a1efd19e31a44b3cd6a2", "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea", "relations": [{"rule": 2, "type": "equivalent", "target": "22918bbd723838fd326c43f73db0beb2", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}}, {"rule": 2, "type": "equivalent", "target": "4e3a1a2456aba94194356a01413e3114", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}}, {"rule": 2, "type": "equivalent", "target": "9c38c588942a2de8ba8e7fb0147649d5", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}}, {"rule": 2, "type": "equivalent", "target": "d90ea1969e6efed6f293f894e2b16d72", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "4e3a1a2456aba94194356a01413e3114", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "避免在进程的 PS 状态中可能两次显示 “waiting”", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}, "url": "/docs/compare/?release=12.3#12.3-43091f93f1eb20ec", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "9c38c588942a2de8ba8e7fb0147649d5", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "避免在进程的 PS 状态中可能两次显示 “waiting”", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}, "url": "/docs/compare/?release=11.8#11.8-1973e2fb461472c9", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "22918bbd723838fd326c43f73db0beb2", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "避免在进程的 PS 状态中可能两次显示 “waiting”", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}, "url": "/docs/compare/?release=10.13#10.13-1973e2fb461472c9", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "d90ea1969e6efed6f293f894e2b16d72", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "避免进程的 PS 状态中可能两次显示 “waiting”", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}, "url": "/docs/compare/?release=9.6.18#9.6.18-f648cc703038394b", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-a3d32e1cca66132d", "cves": [], "html": "<p>避免崩溃恢复期间过早回收 WAL 段（Jehan-Guillaume de Rorthais）</p>\n<p>崩溃恢复期间变为可归档的 WAL 段有可能在未被归档的情况下就被回收。</p>", "text": "避免崩溃恢复期间过早回收 WAL 段（Jehan-Guillaume de Rorthais） 崩溃恢复期间变为可归档的 WAL 段有可能在未被归档的情况下就被回收。", "title": "避免崩溃恢复期间过早回收 WAL 段", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "de8310288828f378f918e7c6304ef9b82688813093c9934c4750c2aa5027490c", "section_path": ["变更"], "commit_groups": [["02657c421", "22db5269b", "2d24ca00b", "4e87c4836", "9eff11653", "c2d8ae0df"], ["0d04e9d76", "11f004699", "26057550d", "3d9cae5ad", "a4726998d", "f9c1b8dba"]], "identity_text": "Avoid premature recycling of WAL segments during crash recovery (Jehan-Guillaume de Rorthais) WAL segments that become ready to be archived during crash recovery were potentially recycled without being archived.", "commit_aliases": ["02657c421", "0d04e9d76", "11f004699", "22db5269b", "26057550d", "2d24ca00b", "3d9cae5ad", "4e87c4836", "9eff11653", "a4726998d", "c2d8ae0df", "f9c1b8dba"], "source_commits": ["9eff11653", "a4726998d"], "source_entry_id": "9.5.22/changes/014", "db_id": "b12c1aa5e0e23993f2ac453638df2a86", "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6", "relations": [{"rule": 2, "type": "equivalent", "target": "339630ead3e826cc8ce60a76a0891a79", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}}, {"rule": 2, "type": "equivalent", "target": "64260b75f6c405aa52cf45d5527ccf2d", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}}, {"rule": 2, "type": "equivalent", "target": "a1cf124a3a5ff64bf30d3e3981c63683", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}}, {"rule": 2, "type": "equivalent", "target": "b5f60a1946e72223e6f7b1c0c3bfb9de", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "64260b75f6c405aa52cf45d5527ccf2d", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "避免崩溃恢复期间过早回收 WAL 段", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}, "url": "/docs/compare/?release=12.3#12.3-3e080ce59871ccc2", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "339630ead3e826cc8ce60a76a0891a79", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "避免崩溃恢复期间过早回收 WAL 段", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}, "url": "/docs/compare/?release=11.8#11.8-a3d32e1cca66132d", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "b5f60a1946e72223e6f7b1c0c3bfb9de", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "避免崩溃恢复期间过早回收 WAL 段", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}, "url": "/docs/compare/?release=10.13#10.13-a3d32e1cca66132d", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "a1cf124a3a5ff64bf30d3e3981c63683", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "避免崩溃恢复期间过早回收 WAL 段", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}, "url": "/docs/compare/?release=9.6.18#9.6.18-a3d32e1cca66132d", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-1a459e89e5863aa7", "cves": [], "html": "<p>避免归档恢复期间扫描无关时间线（Kyotaro Horiguchi）</p>\n<p>这可以消除许多从归档存储获取不存在 WAL 文件的尝试，在归档访问缓慢时很有帮助。</p>", "text": "避免归档恢复期间扫描无关时间线（Kyotaro Horiguchi） 这可以消除许多从归档存储获取不存在 WAL 文件的尝试，在归档访问缓慢时很有帮助。", "title": "避免归档恢复期间扫描无关时间线", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "3364dd19429d62393af350f7b632c779f459cbb4a0df499ffb72d06442ea751e", "section_path": ["变更"], "commit_groups": [["4bd0ad9e4", "660f1fc40", "683e0ef55", "70b597974", "dcd1569fb", "e3f5b148e"]], "identity_text": "Avoid scanning irrelevant timelines during archive recovery (Kyotaro Horiguchi) This can eliminate many attempts to fetch non-existent WAL files from archive storage, which is helpful if archive access is slow.", "commit_aliases": ["4bd0ad9e4", "660f1fc40", "683e0ef55", "70b597974", "dcd1569fb", "e3f5b148e"], "source_commits": ["e3f5b148e"], "source_entry_id": "9.5.22/changes/015", "db_id": "5534623022d01e53ee6dbef702811fac", "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd", "relations": [{"rule": 2, "type": "equivalent", "target": "12ca930645248f1c5424dd484b54f738", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}}, {"rule": 2, "type": "equivalent", "target": "5e62d45bd81c8df3ebef93b76e51df11", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}}, {"rule": 2, "type": "equivalent", "target": "80ad996d70bbd32642295566050cb53b", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}}, {"rule": 2, "type": "equivalent", "target": "d1cc31e1b4252b551f40b53f1cf377ef", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "d1cc31e1b4252b551f40b53f1cf377ef", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "避免归档恢复期间扫描无关的时间线", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}, "url": "/docs/compare/?release=12.3#12.3-12416a0b66723211", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "12ca930645248f1c5424dd484b54f738", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "避免归档恢复期间扫描无关的时间线", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}, "url": "/docs/compare/?release=11.8#11.8-78197daaaef890ec", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "5e62d45bd81c8df3ebef93b76e51df11", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "避免归档恢复期间扫描无关的时间线", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}, "url": "/docs/compare/?release=10.13#10.13-78197daaaef890ec", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "80ad996d70bbd32642295566050cb53b", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "避免归档恢复期间扫描无关时间线", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}, "url": "/docs/compare/?release=9.6.18#9.6.18-1a459e89e5863aa7", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-0e828a8ecd846f2a", "cves": [], "html": "<p>移除逻辑解码中虚假的 <span>“<span>subtransaction logged without previous top-level txn record</span>”</span> 错误检查（Arseny Sher、Amit Kapila）</p>\n<p>这一条件在各种场景下都可以合法达到，因此移除该检查。</p>", "text": "移除逻辑解码中虚假的 “subtransaction logged without previous top-level txn record” 错误检查（Arseny Sher、Amit Kapila） 这一条件在各种场景下都可以合法达到，因此移除该检查。", "title": "移除逻辑解码中虚假的 “subtransaction logged without previous top-level txn record” 错误检查", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "d04db0c135e8d1d98fb7705903f289af2953020be50ae1c71657710a3843ac8e", "section_path": ["变更"], "commit_groups": [["05555f7aa", "59112f235", "59c1a03f0", "b448aa441", "bff456d7a", "e3ff789ac"]], "identity_text": "Remove bogus subtransaction logged without previous top-level txn record error check in logical decoding (Arseny Sher, Amit Kapila) This condition is legitimately reachable in various scenarios, so remove the check.", "commit_aliases": ["05555f7aa", "59112f235", "59c1a03f0", "b448aa441", "bff456d7a", "e3ff789ac"], "source_commits": ["05555f7aa"], "source_entry_id": "9.5.22/changes/016", "db_id": "f1e4dd966202377068b8ccf850797012", "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25", "relations": [{"rule": 2, "type": "equivalent", "target": "013381b18e4797fb6c20449ccad2be10", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}}, {"rule": 2, "type": "equivalent", "target": "091f71c96c354f4647b9ebc343fb55a9", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}}, {"rule": 2, "type": "equivalent", "target": "dbd2f9061c003f5c98a421520d57c263", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}}, {"rule": 2, "type": "equivalent", "target": "e6f4e104e82b45a8ae35c2ce2581b76f", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "091f71c96c354f4647b9ebc343fb55a9", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "移除逻辑解码中不正确的 “subtransaction logged without previous top-level txn record” 错误检查", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}, "url": "/docs/compare/?release=12.3#12.3-22c28a3d58382dfb", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "013381b18e4797fb6c20449ccad2be10", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "移除逻辑解码中不正确的 “subtransaction logged without previous top-level txn record” 错误检查", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}, "url": "/docs/compare/?release=11.8#11.8-fd829a21505bdb58", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "e6f4e104e82b45a8ae35c2ce2581b76f", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "移除逻辑解码中不正确的 “subtransaction logged without previous top-level txn record” 错误检查", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}, "url": "/docs/compare/?release=10.13#10.13-fd829a21505bdb58", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "dbd2f9061c003f5c98a421520d57c263", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "移除逻辑解码中虚假的 “subtransaction logged without previous top-level txn record” 错误检查", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}, "url": "/docs/compare/?release=9.6.18#9.6.18-0e828a8ecd846f2a", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-1d9e9eb64368fe4a", "cves": [], "html": "<p>确保复制槽的 <code>io_in_progress_lock</code> 在失败代码路径中被释放（Pavan Deolasee）</p>\n<p>这可能导致 walsender 之后卡在等待该锁上。</p>", "text": "确保复制槽的 io_in_progress_lock 在失败代码路径中被释放（Pavan Deolasee） 这可能导致 walsender 之后卡在等待该锁上。", "title": "确保复制槽的 io_in_progress_lock 在失败代码路径中被释放", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "3c9c95224f594934b2d722bd26c89302864785795360d8cd2665af9c3dd33ac0", "section_path": ["变更"], "commit_groups": [["038c9bbe9", "250041a56", "3dcaea4b0", "72b2b9c52", "a9d9bdd3a", "d278d4e1a"], ["223e9c77d", "2d8597ba6", "49bf81536", "ba4cc05ce", "ce28a43ff", "f36a10434"]], "identity_text": "Ensure that a replication slot's io_in_progress_lock is released in failure code paths (Pavan Deolasee) This could result in a walsender later becoming stuck waiting for the lock.", "commit_aliases": ["038c9bbe9", "223e9c77d", "250041a56", "2d8597ba6", "3dcaea4b0", "49bf81536", "72b2b9c52", "a9d9bdd3a", "ba4cc05ce", "ce28a43ff", "d278d4e1a", "f36a10434"], "source_commits": ["72b2b9c52", "ce28a43ff"], "source_entry_id": "9.5.22/changes/017", "db_id": "a09a60a9acd28901f8e195523cbf8280", "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3", "relations": [{"rule": 2, "type": "equivalent", "target": "49e6106f1b8c589675911ae6e8114480", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}}, {"rule": 2, "type": "equivalent", "target": "8d5b02d64733f6ae2be77f9406700aca", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}}, {"rule": 2, "type": "equivalent", "target": "aefd8832d249a50994aafa4483e439d2", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}}, {"rule": 2, "type": "equivalent", "target": "b7a2a434b31db8fe9d51a32ffdcbd2c9", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "8d5b02d64733f6ae2be77f9406700aca", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "确保在失败代码路径中释放复制槽的 io_in_progress_lock", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}, "url": "/docs/compare/?release=12.3#12.3-2b91a72492c7f156", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "49e6106f1b8c589675911ae6e8114480", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "确保在失败代码路径中释放复制槽的 io_in_progress_lock", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}, "url": "/docs/compare/?release=11.8#11.8-e0835f75d9ce7568", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "aefd8832d249a50994aafa4483e439d2", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "确保在失败代码路径中释放复制槽的 io_in_progress_lock", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}, "url": "/docs/compare/?release=10.13#10.13-e0835f75d9ce7568", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "b7a2a434b31db8fe9d51a32ffdcbd2c9", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "确保复制槽的 io_in_progress_lock 在失败代码路径中被释放", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}, "url": "/docs/compare/?release=9.6.18#9.6.18-1d9e9eb64368fe4a", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-68ac647cd62a7cc2", "cves": [], "html": "<p>确保备库服务器上 <code>nextXid</code> 不会倒退（Eka Palamadai）</p>\n<p>这一竞态条件可能使错误的热备反馈消息被发回主库，可能导致主库过早运行 <code>VACUUM</code>。</p>", "text": "确保备库服务器上 nextXid 不会倒退（Eka Palamadai） 这一竞态条件可能使错误的热备反馈消息被发回主库，可能导致主库过早运行 VACUUM。", "title": "确保备库服务器上 nextXid 不会倒退", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "9a70d8dae80f48065fd95ebc80b1c4bebed9cbc0e206455ddf826449c84b7580", "section_path": ["变更"], "commit_groups": [["05e0aff58", "4e8cad2da", "a493f9334", "d22ac5378"]], "identity_text": "Ensure nextXid can't go backwards on a standby server (Eka Palamadai) This race condition could allow incorrect hot standby feedback messages to be sent back to the primary server, potentially allowing VACUUM to run too soon on the primary.", "commit_aliases": ["05e0aff58", "4e8cad2da", "a493f9334", "d22ac5378"], "source_commits": ["d22ac5378"], "source_entry_id": "9.5.22/changes/018", "db_id": "272601a64a732b1a4a44f7b76e926bf4", "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18", "relations": [{"rule": 2, "type": "equivalent", "target": "70c6ac53973e68036f34916e0d9f1d5e", "evidence": {"same_day": true, "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18"}}, {"rule": 2, "type": "equivalent", "target": "a2820077d8e7c05a8915fa36543d7e04", "evidence": {"same_day": true, "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18"}}, {"rule": 2, "type": "equivalent", "target": "b0b809dd4145aaf18e208e689f412a45", "evidence": {"same_day": true, "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "a2820077d8e7c05a8915fa36543d7e04", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "确保备库上的 nextXid 不会倒退", "evidence": {"same_day": true, "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18"}, "url": "/docs/compare/?release=11.8#11.8-81f9c755f6992459", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "b0b809dd4145aaf18e208e689f412a45", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "确保备库上的 nextXid 不会倒退", "evidence": {"same_day": true, "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18"}, "url": "/docs/compare/?release=10.13#10.13-81f9c755f6992459", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "70c6ac53973e68036f34916e0d9f1d5e", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "确保备库服务器上 nextXid 不会倒退", "evidence": {"same_day": true, "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18"}, "url": "/docs/compare/?release=9.6.18#9.6.18-68ac647cd62a7cc2", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-1f7df64db7301187", "cves": [], "html": "<p>为少数错误报告补上缺失的 SQLSTATE 值（Sawada Masahiko）</p>", "text": "为少数错误报告补上缺失的 SQLSTATE 值（Sawada Masahiko）", "title": "为少数错误报告补上缺失的 SQLSTATE 值", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "5186270cbf3a283af074aa48b126e771cdf551d12ecdf57470828941227cbece", "section_path": ["变更"], "commit_groups": [["18c41cb6b", "569f9354b", "6bdfe428d", "b4f140869", "e37824136", "fe27ce1c1"]], "identity_text": "Add missing SQLSTATE values to a few error reports (Sawada Masahiko)", "commit_aliases": ["18c41cb6b", "569f9354b", "6bdfe428d", "b4f140869", "e37824136", "fe27ce1c1"], "source_commits": ["6bdfe428d"], "source_entry_id": "9.5.22/changes/019", "db_id": "6c228a9d22842aa71a7727972e8eaa10", "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79", "relations": [{"rule": 2, "type": "equivalent", "target": "2065c32f3e3290021e9f29159ed0031b", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}}, {"rule": 2, "type": "equivalent", "target": "a15b05ed8fbbf3ab85b57e40fb4ce586", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}}, {"rule": 2, "type": "equivalent", "target": "cb9b44a4464ed285e5e6555c0074c1c4", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}}, {"rule": 2, "type": "equivalent", "target": "e9e16b73da900751d27af9717dc9cadd", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "cb9b44a4464ed285e5e6555c0074c1c4", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "为几个错误报告补上缺失的 SQLSTATE 值", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}, "url": "/docs/compare/?release=12.3#12.3-b781c8aa94e5cf99", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "2065c32f3e3290021e9f29159ed0031b", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "为几个错误报告补上缺失的 SQLSTATE 值", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}, "url": "/docs/compare/?release=11.8#11.8-69ca7fb3ed12cfcf", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "a15b05ed8fbbf3ab85b57e40fb4ce586", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "为几个错误报告补上缺失的 SQLSTATE 值", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}, "url": "/docs/compare/?release=10.13#10.13-69ca7fb3ed12cfcf", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "e9e16b73da900751d27af9717dc9cadd", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "为少数错误报告补上缺失的 SQLSTATE 值", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}, "url": "/docs/compare/?release=9.6.18#9.6.18-1f7df64db7301187", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-b6a18b5603ac59cb", "cves": [], "html": "<p>修复 PL/pgSQL，使其可靠地拒绝把事件触发器函数当作普通函数执行（Tom Lane）</p>", "text": "修复 PL/pgSQL，使其可靠地拒绝把事件触发器函数当作普通函数执行（Tom Lane）", "title": "修复 PL/pgSQL，使其可靠地拒绝把事件触发器函数当作普通函数执行", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "9a0932d3f5f760cf96dd4cbcd9d9f783dacbb6eeb4dfb93bad71da607d4929cf", "section_path": ["变更"], "commit_groups": [["32aa14d40", "3e5308969", "612d207bc", "6af63cf8c", "761a5688b", "bbefb1154"]], "identity_text": "Fix PL/pgSQL to reliably refuse to execute an event trigger function as a plain function (Tom Lane)", "commit_aliases": ["32aa14d40", "3e5308969", "612d207bc", "6af63cf8c", "761a5688b", "bbefb1154"], "source_commits": ["bbefb1154"], "source_entry_id": "9.5.22/changes/020", "db_id": "c6f5e3f95c20ab12d143eca9a07cb33c", "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d", "relations": [{"rule": 2, "type": "equivalent", "target": "345cbc43e1407eb019d6ed1f60ee8f91", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}}, {"rule": 2, "type": "equivalent", "target": "4e52c2f502c6e0897d8a1b3e9ca67efe", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}}, {"rule": 2, "type": "equivalent", "target": "9387468acfa91ec955cd14175f688f42", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}}, {"rule": 2, "type": "equivalent", "target": "f95727f67cae98416ee2b67e932b89d5", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "345cbc43e1407eb019d6ed1f60ee8f91", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 PL/pgSQL，使其可靠地拒绝将事件触发器函数作为普通函数执行", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}, "url": "/docs/compare/?release=12.3#12.3-36e71327f0690bd8", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "4e52c2f502c6e0897d8a1b3e9ca67efe", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 PL/pgSQL，使其可靠地拒绝将事件触发器函数作为普通函数执行", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}, "url": "/docs/compare/?release=11.8#11.8-a5d07257463b709b", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "9387468acfa91ec955cd14175f688f42", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 PL/pgSQL，使其可靠地拒绝将事件触发器函数作为普通函数执行", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}, "url": "/docs/compare/?release=10.13#10.13-a5d07257463b709b", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "f95727f67cae98416ee2b67e932b89d5", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 PL/pgSQL，使其可靠地拒绝把事件触发器函数当作普通函数执行", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}, "url": "/docs/compare/?release=9.6.18#9.6.18-b6a18b5603ac59cb", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-492272dff32caf3d", "cves": [], "html": "<p>修复使用 <code>sslmode=verify-full</code> 时 <span>libpq</span> 中的内存泄漏（Roman Peshkurov）</p>\n<p>连接启动期间的证书验证可能泄漏一些内存。如果客户端进程在其生命周期内打开许多数据库连接，这就会成为问题。</p>", "text": "修复使用 sslmode=verify-full 时 libpq 中的内存泄漏（Roman Peshkurov） 连接启动期间的证书验证可能泄漏一些内存。如果客户端进程在其生命周期内打开许多数据库连接，这就会成为问题。", "title": "修复使用 sslmode=verify-full 时 libpq 中的内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "502962e287e8255780f8616029ba884105524b0c2eb5a01aefce54df52a8e5b3", "section_path": ["变更"], "commit_groups": [["1bb0293d8", "27dbe1a18", "35d08658d", "c9c15790d", "e1c08722a", "e5e295d50"]], "identity_text": "Fix memory leak in libpq when using sslmode=verify-full (Roman Peshkurov) Certificate verification during connection startup could leak some memory. This would become an issue if a client process opened many database connections during its lifetime.", "commit_aliases": ["1bb0293d8", "27dbe1a18", "35d08658d", "c9c15790d", "e1c08722a", "e5e295d50"], "source_commits": ["e5e295d50"], "source_entry_id": "9.5.22/changes/021", "db_id": "7569ce1fedee0ca0d57987004a2130bf", "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e", "relations": [{"rule": 2, "type": "equivalent", "target": "4b86d16c3aa59d9c7464466f086ce6d8", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}}, {"rule": 2, "type": "equivalent", "target": "553edcbd407f274601a6a08ef3271069", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}}, {"rule": 2, "type": "equivalent", "target": "59d9303b6ecf3005ed2806e24a3ba6f4", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}}, {"rule": 2, "type": "equivalent", "target": "9663fe9a33076a65f15e72ec78500a20", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b86d16c3aa59d9c7464466f086ce6d8", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 libpq 使用 sslmode=verify-full 时的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}, "url": "/docs/compare/?release=12.3#12.3-7b36727397290db4", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "9663fe9a33076a65f15e72ec78500a20", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 libpq 使用 sslmode=verify-full 时的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}, "url": "/docs/compare/?release=11.8#11.8-30b08a02b4d835d8", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "553edcbd407f274601a6a08ef3271069", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 libpq 使用 sslmode=verify-full 时的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}, "url": "/docs/compare/?release=10.13#10.13-30b08a02b4d835d8", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "59d9303b6ecf3005ed2806e24a3ba6f4", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复使用 sslmode=verify-full 时 libpq 中的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}, "url": "/docs/compare/?release=9.6.18#9.6.18-492272dff32caf3d", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-52fc5c246d4ce733", "cves": [], "html": "<p>修复 <span>ecpg</span> 在所有平台上都把仅为 <span>“<span><code>-</code></span>”</span> 的参数当作<span>“<span>从 stdin 读取</span>”</span>（Tom Lane）</p>", "text": "修复 ecpg 在所有平台上都把仅为 “-” 的参数当作“从 stdin 读取”（Tom Lane）", "title": "修复 ecpg 在所有平台上都把仅为 “-” 的参数当作“从 stdin 读取”", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "0278da3ecbb04c38090155c5ca4c08017257ac0f27c093213b5b9e4506290cb6", "section_path": ["变更"], "commit_groups": [["036fdf6be", "5f9eace5d", "980a70b97", "aae7e8530", "c0eb57dd9", "ef7d6d79a"]], "identity_text": "Fix ecpg to treat an argument of just - as meaning read from stdin on all platforms (Tom Lane)", "commit_aliases": ["036fdf6be", "5f9eace5d", "980a70b97", "aae7e8530", "c0eb57dd9", "ef7d6d79a"], "source_commits": ["5f9eace5d"], "source_entry_id": "9.5.22/changes/022", "db_id": "cff5e6ff586cca37f65f333e05c359ae", "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875", "relations": [{"rule": 2, "type": "equivalent", "target": "42a1e53540d420214fd96dc1547d3c54", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}}, {"rule": 2, "type": "equivalent", "target": "6a4a3a091caf806f6bc9bd9b1cb2d194", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}}, {"rule": 2, "type": "equivalent", "target": "819404475daf180026c644a2b44c5436", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}}, {"rule": 2, "type": "equivalent", "target": "b8f1ac84fc1653c621e609a0c48e8a4c", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6a4a3a091caf806f6bc9bd9b1cb2d194", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 ecpg，使其在所有平台上都将仅包含 “-” 的参数解释为“从 stdin 读取”", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}, "url": "/docs/compare/?release=12.3#12.3-f9e6f47b17c5484d", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "819404475daf180026c644a2b44c5436", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 ecpg，使其在所有平台上都将仅包含 “-” 的参数解释为“从 stdin 读取”", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}, "url": "/docs/compare/?release=11.8#11.8-2774b02c4bef748f", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "b8f1ac84fc1653c621e609a0c48e8a4c", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 ecpg，使其在所有平台上都将仅包含 “-” 的参数解释为“从 stdin 读取”", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}, "url": "/docs/compare/?release=10.13#10.13-2774b02c4bef748f", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "42a1e53540d420214fd96dc1547d3c54", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 ecpg 在所有平台上都把仅为 “-” 的参数当作“从 stdin 读取”", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}, "url": "/docs/compare/?release=9.6.18#9.6.18-52fc5c246d4ce733", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-631ca1215d6c17dd", "cves": [], "html": "<p>修复 <span>pg_dump</span> 转储 RLS 策略对象上的注释（Tom Lane）</p>", "text": "修复 pg_dump 转储 RLS 策略对象上的注释（Tom Lane）", "title": "修复 pg_dump 转储 RLS 策略对象上的注释", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "6df1f163968c9afa5df2aba40a793658b29b80ec7b4c68a6cfdc204cd2186c03", "section_path": ["变更"], "commit_groups": [["3380b9931", "6da7d3630", "bd2cd138f", "d9ec8d1d7", "f31364676", "f9d7bb68d"]], "identity_text": "Fix pg_dump to dump comments on RLS policy objects (Tom Lane)", "commit_aliases": ["3380b9931", "6da7d3630", "bd2cd138f", "d9ec8d1d7", "f31364676", "f9d7bb68d"], "source_commits": ["d9ec8d1d7"], "source_entry_id": "9.5.22/changes/023", "db_id": "8006ac44eeafaedba4e129814d0deaba", "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9", "relations": [{"rule": 2, "type": "equivalent", "target": "44ee977d75639b5be3b742c340c30f16", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}}, {"rule": 2, "type": "equivalent", "target": "58313ea4c080dfe15d965f5a0df51e1d", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}}, {"rule": 2, "type": "equivalent", "target": "5f17f8c0425c4560b262fff7d341eede", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}}, {"rule": 2, "type": "equivalent", "target": "e859422314570f65827212ac979a8497", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "5f17f8c0425c4560b262fff7d341eede", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 pg_dump，使其转储 RLS 策略对象上的注释", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}, "url": "/docs/compare/?release=12.3#12.3-49a2377051f5c702", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "e859422314570f65827212ac979a8497", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 pg_dump，使其转储 RLS 策略对象上的注释", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}, "url": "/docs/compare/?release=11.8#11.8-45af8ee4eb6fc4b4", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "58313ea4c080dfe15d965f5a0df51e1d", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 pg_dump，使其转储 RLS 策略对象上的注释", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}, "url": "/docs/compare/?release=10.13#10.13-45af8ee4eb6fc4b4", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "44ee977d75639b5be3b742c340c30f16", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 pg_dump 转储 RLS 策略对象上的注释", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}, "url": "/docs/compare/?release=9.6.18#9.6.18-631ca1215d6c17dd", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-e807ca1d6ba56c52", "cves": [], "html": "<p>在 <span>pg_dump</span> 中，把事件触发器的恢复推迟到最后（Fabrízio de Royes Mello、Hamid Akhtar、Tom Lane）</p>\n<p>这能把事件触发器干扰其他对象恢复的风险降到最低。</p>", "text": "在 pg_dump 中，把事件触发器的恢复推迟到最后（Fabrízio de Royes Mello、Hamid Akhtar、Tom Lane） 这能把事件触发器干扰其他对象恢复的风险降到最低。", "title": "在 pg_dump 中，把事件触发器的恢复推迟到最后", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "16589c1cbf23d661eb59277eeda3a6b22167ef5d7cc6f44f57f8fdd56d4b41fc", "section_path": ["变更"], "commit_groups": [["0b0247644", "475b061c8", "4c40b27b5", "8728b2c70", "f5d49f226", "fab545635"], ["564c1e6d7", "778066052", "830471e0d", "983ed99a6", "a9d70c108", "d050c6113"]], "identity_text": "In pg_dump, postpone restore of event triggers till the end (Fabrízio de Royes Mello, Hamid Akhtar, Tom Lane) This minimizes the risk that an event trigger could interfere with the restoration of other objects.", "commit_aliases": ["0b0247644", "475b061c8", "4c40b27b5", "564c1e6d7", "778066052", "830471e0d", "8728b2c70", "983ed99a6", "a9d70c108", "d050c6113", "f5d49f226", "fab545635"], "source_commits": ["0b0247644", "564c1e6d7"], "source_entry_id": "9.5.22/changes/024", "db_id": "921238244a4ace6028c6720eaae54c6d", "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542", "relations": [{"rule": 2, "type": "equivalent", "target": "072107359d0067312815b12da199c072", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}}, {"rule": 2, "type": "equivalent", "target": "1f39f9ecb7b6e16f5b92519fc00c3c99", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}}, {"rule": 2, "type": "equivalent", "target": "7e97a71c98aa5c34bb8003cd9dee00e0", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}}, {"rule": 2, "type": "equivalent", "target": "f8e9cbf12893ff4d294069968a78257f", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "072107359d0067312815b12da199c072", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 pg_dump 中，将事件触发器的恢复推迟到最后", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}, "url": "/docs/compare/?release=12.3#12.3-c5def455b9cb038d", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "f8e9cbf12893ff4d294069968a78257f", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "在 pg_dump 中，将事件触发器的恢复推迟到最后", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}, "url": "/docs/compare/?release=11.8#11.8-e5ac383e1f0be379", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "1f39f9ecb7b6e16f5b92519fc00c3c99", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "在 pg_dump 中，将事件触发器的恢复推迟到最后", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}, "url": "/docs/compare/?release=10.13#10.13-e5ac383e1f0be379", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "7e97a71c98aa5c34bb8003cd9dee00e0", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "在 pg_dump 中，把事件触发器的恢复推迟到最后", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}, "url": "/docs/compare/?release=9.6.18#9.6.18-e807ca1d6ba56c52", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-9896aab3c02f3e64", "cves": [], "html": "<p>修复 <span>createdb</span> 实用程序中 <code>--encoding</code>、<code>--lc-ctype</code> 和 <code>--lc-collate</code> 值的引号处理（Michael Paquier）</p>", "text": "修复 createdb 实用程序中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理（Michael Paquier）", "title": "修复 createdb 实用程序中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "0186d54b9c5c4beb764f8efc608b6cb8334b66e66e90a1982ae0ba893ac1ec87", "section_path": ["变更"], "commit_groups": [["008cf0409", "240c7c75f", "3340034f2", "49300e4cf", "83bd732eb", "943affb3d"], ["8e076f4f9", "aeb846edb", "c4b0edb07"]], "identity_text": "Fix quoting of --encoding, --lc-ctype and --lc-collate values in createdb utility (Michael Paquier)", "commit_aliases": ["008cf0409", "240c7c75f", "3340034f2", "49300e4cf", "83bd732eb", "8e076f4f9", "943affb3d", "aeb846edb", "c4b0edb07"], "source_commits": ["49300e4cf", "c4b0edb07"], "source_entry_id": "9.5.22/changes/025", "db_id": "9631fea169d3e2bda212def89fad0300", "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0", "relations": [{"rule": 2, "type": "equivalent", "target": "0ebb156c576c2265fcbed0fd4b28f6e6", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}}, {"rule": 2, "type": "equivalent", "target": "3019b8163e1c995314dc518c40596313", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}}, {"rule": 2, "type": "equivalent", "target": "61804e0bbd8b50e13be46639d6db4196", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}}, {"rule": 2, "type": "equivalent", "target": "d890ca8665f057654035ee52656c258d", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "61804e0bbd8b50e13be46639d6db4196", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 createdb 工具中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}, "url": "/docs/compare/?release=12.3#12.3-d286099819e8671b", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "d890ca8665f057654035ee52656c258d", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 createdb 工具中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}, "url": "/docs/compare/?release=11.8#11.8-8efba8920817e6a2", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "0ebb156c576c2265fcbed0fd4b28f6e6", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 createdb 工具中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}, "url": "/docs/compare/?release=10.13#10.13-8efba8920817e6a2", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "3019b8163e1c995314dc518c40596313", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 createdb 实用程序中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}, "url": "/docs/compare/?release=9.6.18#9.6.18-9896aab3c02f3e64", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-e2d45b363d19ce8d", "cves": [], "html": "<p><code>contrib/lo</code> 的 <code>lo_manage()</code> 函数在被直接调用而非作为触发器调用时崩溃（Tom Lane）</p>", "text": "contrib/lo 的 lo_manage() 函数在被直接调用而非作为触发器调用时崩溃（Tom Lane）", "title": "contrib/lo 的 lo_manage() 函数在被直接调用而非作为触发器调用时崩溃", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "9012358325a7a047184d34c786acda10202ddf0426e12f94dbfc78c37cefb1b0", "section_path": ["变更"], "commit_groups": [["6dd9f3577", "7b1552283", "82bc56e63", "85f0d4703", "a9f821f48", "d56657c35"]], "identity_text": "contrib/lo's lo_manage() function crashed if called directly rather than as a trigger (Tom Lane)", "commit_aliases": ["6dd9f3577", "7b1552283", "82bc56e63", "85f0d4703", "a9f821f48", "d56657c35"], "source_commits": ["82bc56e63"], "source_entry_id": "9.5.22/changes/026", "db_id": "d832f23d03cce13f5515d8c16ded0771", "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5", "relations": [{"rule": 2, "type": "equivalent", "target": "30ce258b16113589c905777f61676eed", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}}, {"rule": 2, "type": "equivalent", "target": "69f9255589357b61beee5334257d8da5", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}}, {"rule": 2, "type": "equivalent", "target": "72595b9ea60880022a25cf3adf9c2543", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}}, {"rule": 2, "type": "equivalent", "target": "afe650853d30a9ef20f26cd2872adca2", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "69f9255589357b61beee5334257d8da5", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "直接调用 contrib/lo 的 lo_manage() 函数，而非作为触发器调用时，会发生崩溃", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}, "url": "/docs/compare/?release=12.3#12.3-72929a5c7fb10bf9", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "72595b9ea60880022a25cf3adf9c2543", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "直接调用 contrib/lo 的 lo_manage() 函数，而非作为触发器调用时，会发生崩溃", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}, "url": "/docs/compare/?release=11.8#11.8-6169e3de25d3c4a5", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "afe650853d30a9ef20f26cd2872adca2", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "直接调用 contrib/lo 的 lo_manage() 函数，而非作为触发器调用时，会发生崩溃", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}, "url": "/docs/compare/?release=10.13#10.13-6169e3de25d3c4a5", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "30ce258b16113589c905777f61676eed", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "contrib/lo 的 lo_manage() 函数在被直接调用而非作为触发器调用时崩溃", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}, "url": "/docs/compare/?release=9.6.18#9.6.18-e2d45b363d19ce8d", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-e84668cbe1db2ced", "cves": [], "html": "<p>在 <code>contrib/ltree</code> 中，防止 <code>ltree</code> 和 <code>lquery</code> 长度字段溢出（Nikita Glukhov）</p>", "text": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出（Nikita Glukhov）", "title": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "4b0884f28932596d931bfee886cecc33a87015f48d12aea58a186114de3c0995", "section_path": ["变更"], "commit_groups": [["2618ac6c6", "2bb6bdbe5", "39491aa0d", "5feb3d0b3", "8e1e630d0", "95f7ddfda"]], "identity_text": "In contrib/ltree, protect against overflow of ltree and lquery length fields (Nikita Glukhov)", "commit_aliases": ["2618ac6c6", "2bb6bdbe5", "39491aa0d", "5feb3d0b3", "8e1e630d0", "95f7ddfda"], "source_commits": ["8e1e630d0"], "source_entry_id": "9.5.22/changes/027", "db_id": "446c6564bfb710f10301497a3a712101", "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd", "relations": [{"rule": 2, "type": "equivalent", "target": "21b634db37867a9f6df498958edbb065", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}}, {"rule": 2, "type": "equivalent", "target": "33838ca8a9d0c94f348a51e701caa3f7", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}}, {"rule": 2, "type": "equivalent", "target": "77e2bb5ff65af969073921d3cd6c14c4", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}}, {"rule": 2, "type": "equivalent", "target": "c59013ac9aa7e195fe75c8ab58ff6641", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "77e2bb5ff65af969073921d3cd6c14c4", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}, "url": "/docs/compare/?release=12.3#12.3-6ee2a90dc57cf857", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "c59013ac9aa7e195fe75c8ab58ff6641", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}, "url": "/docs/compare/?release=11.8#11.8-e84668cbe1db2ced", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "33838ca8a9d0c94f348a51e701caa3f7", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}, "url": "/docs/compare/?release=10.13#10.13-e84668cbe1db2ced", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "21b634db37867a9f6df498958edbb065", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}, "url": "/docs/compare/?release=9.6.18#9.6.18-e84668cbe1db2ced", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-924229b253a1d1d9", "cves": [], "html": "<p>修复 <code>contrib/sepgsql</code> 中的缓存引用泄漏（Michael Luo）</p>", "text": "修复 contrib/sepgsql 中的缓存引用泄漏（Michael Luo）", "title": "修复 contrib/sepgsql 中的缓存引用泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "b3537777b7b2d019af14c81a82915ebbf92ee60eef4e4c8b346ebf1c0d655d93", "section_path": ["变更"], "commit_groups": [["3cdf2421a", "46b1b6379", "687e566b9", "cc2737ab0", "f4a420056", "fc576b7c4"]], "identity_text": "Fix cache reference leak in contrib/sepgsql (Michael Luo)", "commit_aliases": ["3cdf2421a", "46b1b6379", "687e566b9", "cc2737ab0", "f4a420056", "fc576b7c4"], "source_commits": ["46b1b6379"], "source_entry_id": "9.5.22/changes/028", "db_id": "ef00e736ed73f5625a760bb8c60f376b", "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8", "relations": [{"rule": 2, "type": "equivalent", "target": "0999d93b8aad134fc72404ddd8befcd2", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}}, {"rule": 2, "type": "equivalent", "target": "31afc388b27d37b792fe5acf81d32a91", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}}, {"rule": 2, "type": "equivalent", "target": "851de3a1319fb3a68bfa615f1d2b2ec2", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}}, {"rule": 2, "type": "equivalent", "target": "f8cd3b19cbc8066968f11767d3a43568", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "851de3a1319fb3a68bfa615f1d2b2ec2", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 contrib/sepgsql 中的缓存引用泄漏", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}, "url": "/docs/compare/?release=12.3#12.3-df348f281c986254", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "0999d93b8aad134fc72404ddd8befcd2", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "修复 contrib/sepgsql 中的缓存引用泄漏", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}, "url": "/docs/compare/?release=11.8#11.8-924229b253a1d1d9", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "f8cd3b19cbc8066968f11767d3a43568", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 contrib/sepgsql 中的缓存引用泄漏", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}, "url": "/docs/compare/?release=10.13#10.13-924229b253a1d1d9", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "31afc388b27d37b792fe5acf81d32a91", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 contrib/sepgsql 中的缓存引用泄漏", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}, "url": "/docs/compare/?release=9.6.18#9.6.18-924229b253a1d1d9", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-111f6724f6609fc4", "cves": [], "html": "<p>避免在 Windows 上处理 Unix 风格区域名时的失败（Juan José Santamaría Flecha）</p>", "text": "避免在 Windows 上处理 Unix 风格区域名时的失败（Juan José Santamaría Flecha）", "title": "避免在 Windows 上处理 Unix 风格区域名时的失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "0a804b9d5b621279b50f00aa0f81ed13cc0ab69b65feb72eea1181849b843aac", "section_path": ["变更"], "commit_groups": [["4bc3a1667", "6dac1e858", "8c49454ca", "d59e83cf5", "de5b9db36", "f15f5edee"]], "identity_text": "Avoid failures when dealing with Unix-style locale names on Windows (Juan José Santamaría Flecha)", "commit_aliases": ["4bc3a1667", "6dac1e858", "8c49454ca", "d59e83cf5", "de5b9db36", "f15f5edee"], "source_commits": ["6dac1e858"], "source_entry_id": "9.5.22/changes/029", "db_id": "cad42e7939880eaefb16481983255b17", "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8", "relations": [{"rule": 2, "type": "equivalent", "target": "618190f478bc54c146532aca2449b5fe", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}}, {"rule": 2, "type": "equivalent", "target": "c8d670683fce6f86d2217dcb8515de0d", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}}, {"rule": 2, "type": "equivalent", "target": "cf106fb69523eea8d00925bc9065d98f", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}}, {"rule": 2, "type": "equivalent", "target": "cfbd62af139b6b70b199555029cb0263", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "cfbd62af139b6b70b199555029cb0263", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "避免在 Windows 上处理 Unix 风格区域设置名称时发生失败", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}, "url": "/docs/compare/?release=12.3#12.3-be3bcce25d6a5ed8", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "c8d670683fce6f86d2217dcb8515de0d", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "避免在 Windows 上处理 Unix 风格区域设置名称时发生失败", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}, "url": "/docs/compare/?release=11.8#11.8-596472144cb5706b", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "cf106fb69523eea8d00925bc9065d98f", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "避免在 Windows 上处理 Unix 风格区域设置名称时发生失败", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}, "url": "/docs/compare/?release=10.13#10.13-596472144cb5706b", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "618190f478bc54c146532aca2449b5fe", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "避免在 Windows 上处理 Unix 风格区域名时的失败", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}, "url": "/docs/compare/?release=9.6.18#9.6.18-111f6724f6609fc4", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-bae71a53194d4401", "cves": [], "html": "<p>在 MSVC 构建中，处理 Python 路径名中的空格（Victor Wagner）</p>", "text": "在 MSVC 构建中，处理 Python 路径名中的空格（Victor Wagner）", "title": "在 MSVC 构建中，处理 Python 路径名中的空格", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "ecb6308fee8625204c03b5fe606fae255cb24fd6cc91cdfa89141031fb8bbce1", "section_path": ["变更"], "commit_groups": [["307ed98b0", "8c0939dad", "984aca448", "ad53d6efe", "beb2516e9", "e07fdc126"]], "identity_text": "In MSVC builds, cope with spaces in the path name for Python (Victor Wagner)", "commit_aliases": ["307ed98b0", "8c0939dad", "984aca448", "ad53d6efe", "beb2516e9", "e07fdc126"], "source_commits": ["ad53d6efe"], "source_entry_id": "9.5.22/changes/030", "db_id": "e1fc7c47c3f91a87315032845c953520", "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac", "relations": [{"rule": 2, "type": "equivalent", "target": "3ecc6d96e57e02bcac994f223f46c8ae", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}}, {"rule": 2, "type": "equivalent", "target": "85922ac0b7dfcf77afae9fb612ffb63f", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}}, {"rule": 2, "type": "equivalent", "target": "cab163a56507e9a58328f6d7550cc16c", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}}, {"rule": 2, "type": "equivalent", "target": "f75739c9b2331c8ea9fcf7f7d98d7cbf", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "cab163a56507e9a58328f6d7550cc16c", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 MSVC 构建中，处理 Python 路径名中的空格", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}, "url": "/docs/compare/?release=12.3#12.3-f81a271d41d259af", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "f75739c9b2331c8ea9fcf7f7d98d7cbf", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "在 MSVC 构建中，处理 Python 路径名中的空格", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}, "url": "/docs/compare/?release=11.8#11.8-bae71a53194d4401", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "3ecc6d96e57e02bcac994f223f46c8ae", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "在 MSVC 构建中，处理 Python 路径名中的空格", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}, "url": "/docs/compare/?release=10.13#10.13-bae71a53194d4401", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "85922ac0b7dfcf77afae9fb612ffb63f", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "在 MSVC 构建中，处理 Python 路径名中的空格", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}, "url": "/docs/compare/?release=9.6.18#9.6.18-bae71a53194d4401", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-e45b8263fca24bad", "cves": [], "html": "<p>在 MSVC 构建中，修复 Visual Studio 版本检测以适应更多语言设置（Andrew Dunstan）</p>", "text": "在 MSVC 构建中，修复 Visual Studio 版本检测以适应更多语言设置（Andrew Dunstan）", "title": "在 MSVC 构建中，修复 Visual Studio 版本检测以适应更多语言设置", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "3cb7630191c65531b9bf63a5028eea90f922dc531024117bce3405dda564f354", "section_path": ["变更"], "commit_groups": [["3ca17999f", "4c9239d08", "6b02bee66", "758814224", "a9659fb65", "ddac64f2d"]], "identity_text": "In MSVC builds, fix detection of Visual Studio version to work with more language settings (Andrew Dunstan)", "commit_aliases": ["3ca17999f", "4c9239d08", "6b02bee66", "758814224", "a9659fb65", "ddac64f2d"], "source_commits": ["3ca17999f"], "source_entry_id": "9.5.22/changes/031", "db_id": "1aa28dec243bc3fb9c3f44f7c9e3140e", "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524", "relations": [{"rule": 2, "type": "equivalent", "target": "00fda960ae46834024a000891161c6f4", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}}, {"rule": 2, "type": "equivalent", "target": "149da31b78f2dacb3304cbce55a58832", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}}, {"rule": 2, "type": "equivalent", "target": "25f142bd24abd40c480b00e6c18600a0", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}}, {"rule": 2, "type": "equivalent", "target": "5862a44a00581c91933761eb30883ff3", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}}], "version": "9.5.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "00fda960ae46834024a000891161c6f4", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 MSVC 构建中，修复 Visual Studio 版本检测，使其适用于更多语言设置", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}, "url": "/docs/compare/?release=12.3#12.3-0423eb9bbddb20f8", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "25f142bd24abd40c480b00e6c18600a0", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "在 MSVC 构建中，修复 Visual Studio 版本检测，使其适用于更多语言设置", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}, "url": "/docs/compare/?release=11.8#11.8-ef16d7ba22e8b874", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "149da31b78f2dacb3304cbce55a58832", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "在 MSVC 构建中，修复 Visual Studio 版本检测，使其适用于更多语言设置", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}, "url": "/docs/compare/?release=10.13#10.13-ef16d7ba22e8b874", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "5862a44a00581c91933761eb30883ff3", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "在 MSVC 构建中，修复 Visual Studio 版本检测以适应更多语言设置", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}, "url": "/docs/compare/?release=9.6.18#9.6.18-e45b8263fca24bad", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-629774e3f0311503", "cves": [], "html": "<p>在 MSVC 构建中，对 3.0 之后的 bison 版本使用 <code>-Wno-deprecated</code>，与非 Windows 构建已经做的一样（Andrew Dunstan）</p>", "text": "在 MSVC 构建中，对 3.0 之后的 bison 版本使用 -Wno-deprecated，与非 Windows 构建已经做的一样（Andrew Dunstan）", "title": "在 MSVC 构建中，对 3.0 之后的 bison 版本使用 -Wno-deprecated，与非 Windows 构建已经做的一样", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "0dbf0b58dc4626bddbb43424c76e49981dd111ef033933c14a2787ac4aae413c", "section_path": ["变更"], "commit_groups": [["3163349fd", "467b40832", "71c2fd0c0", "80370836f", "d0747714e", "e8a6391fc"]], "identity_text": "In MSVC builds, use -Wno-deprecated with bison versions newer than 3.0, as non-Windows builds already do (Andrew Dunstan)", "commit_aliases": ["3163349fd", "467b40832", "71c2fd0c0", "80370836f", "d0747714e", "e8a6391fc"], "source_commits": ["467b40832"], "source_entry_id": "9.5.22/changes/032", "db_id": "781b1069e93a5c87fc53cef184cd8e6b", "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3", "relations": [{"rule": 2, "type": "equivalent", "target": "867821c64e4237e0170771ad809d1d57", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}}, {"rule": 2, "type": "equivalent", "target": "a2b464387fc65926eb27c30151c6291c", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}}, {"rule": 2, "type": "equivalent", "target": "a63dc5011f682eb0d974c5280cbe49c8", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}}, {"rule": 2, "type": "equivalent", "target": "e98154d53927ee357929e6035953a6e2", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "a2b464387fc65926eb27c30151c6291c", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 MSVC 构建中，对高于 3.0 的 bison 版本使用 -Wno-deprecated，与非 Windows 构建现有行为一致", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}, "url": "/docs/compare/?release=12.3#12.3-85cae5c373d7ed16", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "e98154d53927ee357929e6035953a6e2", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "在 MSVC 构建中，对高于 3.0 的 bison 版本使用 -Wno-deprecated，与非 Windows 构建现有行为一致", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}, "url": "/docs/compare/?release=11.8#11.8-c2ad5dd7fb75ff22", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "867821c64e4237e0170771ad809d1d57", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "在 MSVC 构建中，对高于 3.0 的 bison 版本使用 -Wno-deprecated，与非 Windows 构建现有行为一致", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}, "url": "/docs/compare/?release=10.13#10.13-c2ad5dd7fb75ff22", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "a63dc5011f682eb0d974c5280cbe49c8", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "在 MSVC 构建中，对 3.0 之后的 bison 版本使用 -Wno-deprecated，与非 Windows 构建已经做的一样", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}, "url": "/docs/compare/?release=9.6.18#9.6.18-629774e3f0311503", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "9.5.22-20f382e14391e21c", "cves": [], "html": "<p>更新时区数据文件到 <span>tzdata</span> 版本 2020a，涉及摩洛哥和加拿大育空的夏令时法规变更，以及上海的历史修正。</p>\n<p>America/Godthab 时区已更名为 America/Nuuk 以反映当前英语用法；不过，旧名称仍作为兼容链接可用。</p>\n<p>同时，更新 <span>initdb</span> 的已知 Windows 时区名列表以包含新近添加的名称，提高它在该平台上正确翻译系统时区设置的几率。</p>", "text": "更新时区数据文件到 tzdata 版本 2020a，涉及摩洛哥和加拿大育空的夏令时法规变更，以及上海的历史修正。 America/Godthab 时区已更名为 America/Nuuk 以反映当前英语用法；不过，旧名称仍作为兼容链接可用。 同时，更新 initdb 的已知 Windows 时区名列表以包含新近添加的名称，提高它在该平台上正确翻译系统时区设置的几率。", "title": "更新时区数据文件到 tzdata 版本 2020a，涉及摩洛哥和加拿大育空的夏令时法规变更，以及上海的历史修正。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6", "source_hash": "82cb9be8f2f41f4c3b5692da862dc9245c307e1ac03bac01557317b164ce9885", "section_path": ["变更"], "commit_groups": [["1e07e3fc0", "3cdb45c54", "40d4bc5ac", "6c5f91616", "b31f9fd63", "f65f3a5d8"], ["351252904", "3f3ab184c", "4985b3b84", "99c9ed224", "a2342c658", "bd8c5cee9"], ["39006ae7a", "4cac3a49e", "66be99742", "898921a18", "c820692bd", "eb335bc62"]], "identity_text": "Update time zone data files to tzdata release 2020a for DST law changes in Morocco and the Canadian Yukon, plus historical corrections for Shanghai. The America/Godthab zone has been renamed to America/Nuuk to reflect current English usage; however, the old name remains available as a compatibility link. Also, update initdb's list of known Windows time zone names to include recent additions, improving the odds that it will correctly translate the system time zone setting on that platform.", "commit_aliases": ["1e07e3fc0", "351252904", "39006ae7a", "3cdb45c54", "3f3ab184c", "40d4bc5ac", "4985b3b84", "4cac3a49e", "66be99742", "6c5f91616", "898921a18", "99c9ed224", "a2342c658", "b31f9fd63", "bd8c5cee9", "c820692bd", "eb335bc62", "f65f3a5d8"], "source_commits": ["39006ae7a", "3cdb45c54", "3f3ab184c"], "source_entry_id": "9.5.22/changes/033", "db_id": "082e3124590e139fbc890ad8e6c1cfbb", "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4", "relations": [{"rule": 2, "type": "equivalent", "target": "0e1d44c5c78b1de1d61e0a2e08ecd487", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"]}}, {"rule": 2, "type": "equivalent", "target": "37edc767b610263d920f70cc5dce0d3a", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4"}}, {"rule": 2, "type": "equivalent", "target": "78700f89eac4464583602eff3f2efff1", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4"}}, {"rule": 2, "type": "equivalent", "target": "b34439464cb4306067e1821595585664", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4"}}], "version": "9.5.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "0e1d44c5c78b1de1d61e0a2e08ecd487", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "将时区数据文件更新到 tzdata 2020a 版，以反映摩洛哥和加拿大育空地区的夏令时法规变更，并修正上海的历史数据。", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"]}, "url": "/docs/compare/?release=12.3#12.3-93a238e676d9ea58", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "37edc767b610263d920f70cc5dce0d3a", "kind": "equivalent", "version": "11.8", "label": "11.8", "title": "将时区数据文件更新到 tzdata 2020a 版，以反映摩洛哥和加拿大育空地区的夏令时法规变更，并修正上海的历史数据。", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4"}, "url": "/docs/compare/?release=11.8#11.8-d589194aabb1df08", "source_url": "/docs/release/11.8/#id-1.11.6.19.5"}, {"db_id": "b34439464cb4306067e1821595585664", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "将时区数据文件更新到 tzdata 2020a 版，以反映摩洛哥和加拿大育空地区的夏令时法规变更，并修正上海的历史数据。", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4"}, "url": "/docs/compare/?release=10.13#10.13-d589194aabb1df08", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "78700f89eac4464583602eff3f2efff1", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "更新时区数据文件到 tzdata 版本 2020a，涉及摩洛哥和加拿大育空的夏令时法规变更，以及上海的历史修正。", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4"}, "url": "/docs/compare/?release=9.6.18#9.6.18-20f382e14391e21c", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 33}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 14}, {"key": "security", "label": "安全相关", "count": 0}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 19}], "total": 33, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 33, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}