{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2020-05-14", "build": "11.8", "major": "11", "minor": 8, "manual": "11", "status": "stable", "doc_git": "", "version": "11.8", "eol_date": "2023-11-09", "date_text": "2020-05-14", "supported": false, "manual_url": "/docs/11/release-11-8.html", "source_url": "/docs/release/11.8/", "entry_count": 55, "placeholder": false, "content_hash": "651761c222050d60303a4c201cacad1bffc5cf1390c84e7624a8f3d4e372c30e", "manual_build": "11.22", "source_as_of": "", "changes_count": 55, "doc_loaded_at": "2026-09-26T02:56:42.383207", "migration_html": "

对于运行 11.X 的用户，不需要执行导出/恢复。

\n

但是，如果是从早于 11.6 的版本升级，请参见第 E.17 节。

", "compatibility_count": 0, "label": "11.8", "status_label": "历史版本", "eol": "2023-11-09", "age_days": 2330, "support_days": -1056}, "groups": [{"date": "2020-05-14", "build": "11.8", "major": "11", "minor": 8, "manual": "11", "status": "stable", "doc_git": "", "version": "11.8", "eol_date": "2023-11-09", "date_text": "2020-05-14", "supported": false, "manual_url": "/docs/11/release-11-8.html", "source_url": "/docs/release/11.8/", "entry_count": 55, "placeholder": false, "content_hash": "651761c222050d60303a4c201cacad1bffc5cf1390c84e7624a8f3d4e372c30e", "manual_build": "11.22", "source_as_of": "", "changes_count": 55, "doc_loaded_at": "2026-09-26T02:56:42.383207", "migration_html": "

对于运行 11.X 的用户，不需要执行导出/恢复。

\n

但是，如果是从早于 11.6 的版本升级，请参见第 E.17 节。

", "compatibility_count": 0, "label": "11.8", "status_label": "历史版本", "eol": "2023-11-09", "age_days": 2330, "support_days": -1056, "entries": [{"id": "11.8-2ae223d6abd90ea5", "cves": [], "html": "

将 ALTER TABLE ... SET STORAGE 传播到索引（Peter Eisentraut）

\n

非表达式索引列在创建时一直会复制对应表列的 attstorage 属性。现在执行 ALTER TABLE ... SET STORAGE 时也更新它们，以保持一致。

", "text": "将 ALTER TABLE ... SET STORAGE 传播到索引（Peter Eisentraut） 非表达式索引列在创建时一直会复制对应表列的 attstorage 属性。现在执行 ALTER TABLE ... SET STORAGE 时也更新它们，以保持一致。", "title": "将 ALTER TABLE ... SET STORAGE 传播到索引", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "061d8e62f8457eb82ce80efc501d97da4318c929519e10eceb1ae355a3d32e5b", "section_path": ["变更"], "commit_groups": [["03a8a5f2d", "501e41dd3", "bf7233ee4"]], "identity_text": "Propagate ALTER TABLE ... SET STORAGE to indexes (Peter Eisentraut) Non-expression index columns have always copied the attstorage property of their table column at creation. Update them when ALTER TABLE ... SET STORAGE is done, to maintain consistency.", "commit_aliases": ["03a8a5f2d", "501e41dd3", "bf7233ee4"], "source_commits": ["03a8a5f2d"], "source_entry_id": "11.8/changes/001", "db_id": "b9817aec6ce17c286e3af1d9783a9d38", "patch_ids": ["d7bee350e520ba1606c6b3f1a4bbad70"], "statement_hash": "3e6a75b342dba11a67fbb8065d9d3692eeffd168709496ccd45813b2330c2fcc", "relations": [{"rule": 2, "type": "equivalent", "target": "b91643f557d7901aca54b7885283b302", "evidence": {"same_day": true, "patch_ids": ["d7bee350e520ba1606c6b3f1a4bbad70"], "statement_hash": "3e6a75b342dba11a67fbb8065d9d3692eeffd168709496ccd45813b2330c2fcc"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b91643f557d7901aca54b7885283b302", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "将 ALTER TABLE ... SET STORAGE 传播到索引", "evidence": {"same_day": true, "patch_ids": ["d7bee350e520ba1606c6b3f1a4bbad70"], "statement_hash": "3e6a75b342dba11a67fbb8065d9d3692eeffd168709496ccd45813b2330c2fcc"}, "url": "/docs/compare/?release=12.3#12.3-e7bf713e133ebea8", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-3a0eef37db292531", "cves": [], "html": "

保留由 ALTER TABLE 重写的索引的 indisclustered 设置（Amit Langote，Justin Pryzby）

\n

以前，ALTER TABLE 会丢失哪个索引曾用于 CLUSTER 的信息。

", "text": "保留由 ALTER TABLE 重写的索引的 indisclustered 设置（Amit Langote，Justin Pryzby） 以前，ALTER TABLE 会丢失哪个索引曾用于 CLUSTER 的信息。", "title": "保留由 ALTER TABLE 重写的索引的 indisclustered 设置", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["41faafbd7"], "source_entry_id": "11.8/changes/002", "db_id": "d107db295029a5527f462c1bff6c1a27", "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": "65a191e2b5bcc36adf6eefaa83040fa7", "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"}}], "version": "11.8", "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": "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"}, {"db_id": "65a191e2b5bcc36adf6eefaa83040fa7", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "保留被 ALTER TABLE 重写的索引的 indisclustered 设置", "evidence": {"same_day": true, "patch_ids": ["a3d58f3f9a0ced8f81a46512e08d0142"], "statement_hash": "e73380b336aeae9f134a2fa1551a90fbac46f24486c0d1fb70a63a39782adaa4"}, "url": "/docs/compare/?release=9.5.22#9.5.22-78ac153ed45e974e", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-dc3633495c3ae37e", "cves": [], "html": "

保留由 ALTER TABLE 重写的索引的复制标识属性（Quan Zongliang，Peter Eisentraut）

", "text": "保留由 ALTER TABLE 重写的索引的复制标识属性（Quan Zongliang，Peter Eisentraut）", "title": "保留由 ALTER TABLE 重写的索引的复制标识属性", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["15cbbf81a"], "source_entry_id": "11.8/changes/003", "db_id": "7524e5da19e7e21429f369e719cc627b", "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0", "relations": [{"rule": 2, "type": "equivalent", "target": "7c7f78d697ceda39bbb2282b08683ed2", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}}, {"rule": 2, "type": "equivalent", "target": "9189c4123c00f9dbcd0c24c57151433f", "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": "11.8", "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": "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"}, {"db_id": "9189c4123c00f9dbcd0c24c57151433f", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "保留被 ALTER TABLE 重写的索引的副本身份属性", "evidence": {"same_day": true, "patch_ids": ["5f143403ac7ede3cb9b05827102dbcb6"], "statement_hash": "26c3931f188a2f7417a8997ea1bf534b497c5060c4316ab69ac7e12c8700e8f0"}, "url": "/docs/compare/?release=9.5.22#9.5.22-9c4d55e6730370e2", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-a169fd265e1fb8da", "cves": [], "html": "

在 DROP OWNED BY 期间更早地锁定对象（Álvaro Herrera）

\n

这可以避免另一个会话同时删除部分相同对象时，因竞争条件而发生的失败。

", "text": "在 DROP OWNED BY 期间更早地锁定对象（Álvaro Herrera） 这可以避免另一个会话同时删除部分相同对象时，因竞争条件而发生的失败。", "title": "在 DROP OWNED BY 期间更早地锁定对象", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["59273a7ce"], "source_entry_id": "11.8/changes/004", "db_id": "caabcd93149b6e748a51634556714b66", "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d", "relations": [{"rule": 2, "type": "equivalent", "target": "4daaa443285739f9d53ae1c69016a44d", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}}, {"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"}}], "version": "11.8", "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": "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"}, {"db_id": "4daaa443285739f9d53ae1c69016a44d", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "在 DROP OWNED BY 期间更早地锁定对象", "evidence": {"same_day": true, "patch_ids": ["eee91683461656e730a1b3106c0ccf9e"], "statement_hash": "5ed4dd630b92c11eae811699b77ba32efff981ca47302abf11390ec5c837420d"}, "url": "/docs/compare/?release=9.5.22#9.5.22-a169fd265e1fb8da", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-5faff5e0ce585418", "cves": [], "html": "

修复 CREATE ROLE ... IN ROLE 的错误情况处理（Andrew Gierth）

\n

某些错误情况会被报告为 “unexpected node type” 等消息，而非预期的消息。

", "text": "修复 CREATE ROLE ... IN ROLE 的错误情况处理（Andrew Gierth） 某些错误情况会被报告为 “unexpected node type” 等消息，而非预期的消息。", "title": "修复 CREATE ROLE ... IN ROLE 的错误情况处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["0f4970d1a"], "source_entry_id": "11.8/changes/005", "db_id": "ac10184120a6201dc5a23020315c9d20", "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e", "relations": [{"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"}}, {"rule": 2, "type": "equivalent", "target": "ff88690f590c6b2db573e5b359beebb7", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}}], "version": "11.8", "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": "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"}, {"db_id": "ff88690f590c6b2db573e5b359beebb7", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复 CREATE ROLE ... IN ROLE 的错误情况处理", "evidence": {"same_day": true, "patch_ids": ["fed980cc171da5b77defa2af630b4fe6"], "statement_hash": "b5a81806262ba790d024d3a37a399706e4053e6d7e1874c7e49d23d238c8159e"}, "url": "/docs/compare/?release=9.5.22#9.5.22-5faff5e0ce585418", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-078e06b0dc284736", "cves": [], "html": "

确保分离分区时移除所有从原父表克隆的触发器（Justin Pryzby）

", "text": "确保分离分区时移除所有从原父表克隆的触发器（Justin Pryzby）", "title": "确保分离分区时移除所有从原父表克隆的触发器", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "2910a9fc21319878a86173cfe23647a596c724c31eaf4ed76ff4e5024a42230a", "section_path": ["变更"], "commit_groups": [["0b83c4721", "afccd76f1", "e26c8a6b3"]], "identity_text": "Ensure that when a partition is detached, any triggers cloned from its formerly-parent table are removed (Justin Pryzby)", "commit_aliases": ["0b83c4721", "afccd76f1", "e26c8a6b3"], "source_commits": ["0b83c4721"], "source_entry_id": "11.8/changes/006", "db_id": "ef210adecbcf59994b2172f6210ca8aa", "patch_ids": ["34415bb7f9a6a80eef418abd5e1e0841"], "statement_hash": "648c100706961b6cdab370dd06c1d402daab966ed27af80af70c75a533e161b8", "relations": [{"rule": 2, "type": "equivalent", "target": "f55c467b899e71fbd885437b31e5b198", "evidence": {"same_day": true, "patch_ids": ["34415bb7f9a6a80eef418abd5e1e0841"], "statement_hash": "648c100706961b6cdab370dd06c1d402daab966ed27af80af70c75a533e161b8"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f55c467b899e71fbd885437b31e5b198", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "确保分离分区时移除所有从原父表克隆的触发器", "evidence": {"same_day": true, "patch_ids": ["34415bb7f9a6a80eef418abd5e1e0841"], "statement_hash": "648c100706961b6cdab370dd06c1d402daab966ed27af80af70c75a533e161b8"}, "url": "/docs/compare/?release=12.3#12.3-693a774103475345", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-0c5c8212b424b34a", "cves": [], "html": "

确保分区表上的唯一索引与分区键的相等语义一致（Guancheng Luo）

\n

这只会在索引操作符类采用不寻常的相等定义时成为问题，但理论上仍是错误，因此增加检查。

", "text": "确保分区表上的唯一索引与分区键的相等语义一致（Guancheng Luo） 这只会在索引操作符类采用不寻常的相等定义时成为问题，但理论上仍是错误，因此增加检查。", "title": "确保分区表上的唯一索引与分区键的相等语义一致", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "dd02baf946a9c94fcc16630800a4d069c3bc048d9a123f73752e023305e60088", "section_path": ["变更"], "commit_groups": [["501b01879", "76ddc88f4", "76ea60696"]], "identity_text": "Ensure that unique indexes over partitioned tables match the equality semantics of the partitioning key (Guancheng Luo) This would only be an issue with index opclasses that have unusual notions of equality, but it's wrong in theory, so check.", "commit_aliases": ["501b01879", "76ddc88f4", "76ea60696"], "source_commits": ["76ddc88f4"], "source_entry_id": "11.8/changes/007", "db_id": "92c422aa37a4e8d51c736f70cb3f98e0", "patch_ids": ["e6489d18739dd19993007478b8bcb4a4"], "statement_hash": "8798ba3c84429dc46d54e4887005376904b7e56901930de1d8d9027b00234b91", "relations": [{"rule": 2, "type": "equivalent", "target": "c9e14588094d7a8fb137f98b59979348", "evidence": {"same_day": true, "patch_ids": ["e6489d18739dd19993007478b8bcb4a4"], "statement_hash": "8798ba3c84429dc46d54e4887005376904b7e56901930de1d8d9027b00234b91"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "c9e14588094d7a8fb137f98b59979348", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "确保分区表上的唯一索引与分区键的相等语义一致", "evidence": {"same_day": true, "patch_ids": ["e6489d18739dd19993007478b8bcb4a4"], "statement_hash": "8798ba3c84429dc46d54e4887005376904b7e56901930de1d8d9027b00234b91"}, "url": "/docs/compare/?release=12.3#12.3-f9d861fbfff21335", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-6e0785dd6a222c98", "cves": [], "html": "

确保 pg_read_all_stats 角色的成员可以按预期读取所有统计视图（Magnus Hagander）

\n

pg_stat_progress_* 视图的底层函数以前没有遵守这一要求。

", "text": "确保 pg_read_all_stats 角色的成员可以按预期读取所有统计视图（Magnus Hagander） pg_stat_progress_* 视图的底层函数以前没有遵守这一要求。", "title": "确保 pg_read_all_stats 角色的成员可以按预期读取所有统计视图", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "d2a3300a25a546b3baedc2663db5465ac4e4634155adbc50ea08b5e0a5394108", "section_path": ["变更"], "commit_groups": [["212e712a5", "3d4652f67", "7e4e57474", "d0bb66572"]], "identity_text": "Ensure that members of the pg_read_all_stats role can read all statistics views, as expected (Magnus Hagander) The functions underlying the pg_stat_progress_* views had not gotten this memo.", "commit_aliases": ["212e712a5", "3d4652f67", "7e4e57474", "d0bb66572"], "source_commits": ["3d4652f67"], "source_entry_id": "11.8/changes/008", "db_id": "b6319d9ef4a658689f2487f3307d1484", "patch_ids": ["a99a6d54c05f45e96ee55b4aaefa9cb3"], "statement_hash": "e115c10efc5aea7805af8797bd9ac36604340eb365cbd6c7b6c047e8ed6d9e54", "relations": [{"rule": 2, "type": "equivalent", "target": "b6dbe456bc4a4752b6c3ad8e908d7026", "evidence": {"same_day": true, "patch_ids": ["a99a6d54c05f45e96ee55b4aaefa9cb3"], "statement_hash": "e115c10efc5aea7805af8797bd9ac36604340eb365cbd6c7b6c047e8ed6d9e54"}}, {"rule": 2, "type": "equivalent", "target": "d59c3bdea02bd337c93ea530018d82ed", "evidence": {"same_day": true, "patch_ids": ["a99a6d54c05f45e96ee55b4aaefa9cb3"], "statement_hash": "e115c10efc5aea7805af8797bd9ac36604340eb365cbd6c7b6c047e8ed6d9e54"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b6dbe456bc4a4752b6c3ad8e908d7026", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "确保 pg_read_all_stats 角色的成员可以按预期读取所有统计视图", "evidence": {"same_day": true, "patch_ids": ["a99a6d54c05f45e96ee55b4aaefa9cb3"], "statement_hash": "e115c10efc5aea7805af8797bd9ac36604340eb365cbd6c7b6c047e8ed6d9e54"}, "url": "/docs/compare/?release=12.3#12.3-ed638ee3f3afb2f3", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "d59c3bdea02bd337c93ea530018d82ed", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "确保 pg_read_all_stats 角色的成员可以按预期读取所有统计视图", "evidence": {"same_day": true, "patch_ids": ["a99a6d54c05f45e96ee55b4aaefa9cb3"], "statement_hash": "e115c10efc5aea7805af8797bd9ac36604340eb365cbd6c7b6c047e8ed6d9e54"}, "url": "/docs/compare/?release=10.13#10.13-6e0785dd6a222c98", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}]}, {"id": "11.8-7153d0c053c44cd0", "cves": [], "html": "

修复 information_schema.triggers 视图的性能退化（Tom Lane）

\n

此补丁重新定义了该视图，使约束表名的外层 WHERE 子句可以下推到视图内部，从而只针对目标表的触发器进行计算，而非数据库中的所有触发器。在具有大量触发器的数据库中，这会显著提高此类查询的速度。由于 v11 之前就是这样工作的，这是一处潜在的性能退化。受此问题影响的用户可以替换视图定义来修复它（或许也可以直接删除并重新安装整个 information_schema 模式）。

", "text": "修复 information_schema.triggers 视图的性能退化（Tom Lane） 此补丁重新定义了该视图，使约束表名的外层 WHERE 子句可以下推到视图内部，从而只针对目标表的触发器进行计算，而非数据库中的所有触发器。在具有大量触发器的数据库中，这会显著提高此类查询的速度。由于 v11 之前就是这样工作的，这是一处潜在的性能退化。受此问题影响的用户可以替换视图定义来修复它（或许也可以直接删除并重新安装整个 information_schema 模式）。", "title": "修复 information_schema.triggers 视图的性能退化", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "ad45fe6077987fa945945c9b4801faa2d8d3c98e280f72a6792697e4499fb486", "section_path": ["变更"], "commit_groups": [["64e49a67e", "776f6d3d0", "baf17ad9d"]], "identity_text": "Repair performance regression in information_schema.triggers view (Tom Lane) This patch redefines that view so that an outer WHERE clause constraining the table name can be pushed down into the view, allowing its calculations to be done only for triggers belonging to the table of interest rather than all triggers in the database. In a database with many triggers this would make a significant speed difference for queries of that form. Since things worked that way before v11, this is a potential performance regression. Users who find this to be a problem can fix it by replacing the view definition (or, perhaps, just deleting and reinstalling the whole information_schema schema).", "commit_aliases": ["64e49a67e", "776f6d3d0", "baf17ad9d"], "source_commits": ["776f6d3d0"], "source_entry_id": "11.8/changes/009", "db_id": "cd8cda373404ea817821ec49528fb385", "patch_ids": ["f161906d051e4cff6ab42cd2f030fa74"], "statement_hash": "f2b21e64caf70adbacdac31680314cd3e15dcfacdb3c7f6a1ae296dd12563152", "relations": [{"rule": 2, "type": "equivalent", "target": "343b41bb560af44ba703b883559175c6", "evidence": {"same_day": true, "patch_ids": ["f161906d051e4cff6ab42cd2f030fa74"], "statement_hash": "f2b21e64caf70adbacdac31680314cd3e15dcfacdb3c7f6a1ae296dd12563152"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "343b41bb560af44ba703b883559175c6", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 information_schema.triggers 视图的性能退化", "evidence": {"same_day": true, "patch_ids": ["f161906d051e4cff6ab42cd2f030fa74"], "statement_hash": "f2b21e64caf70adbacdac31680314cd3e15dcfacdb3c7f6a1ae296dd12563152"}, "url": "/docs/compare/?release=12.3#12.3-1c81ff4a1f1b993d", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-f9293e59b50f27e7", "cves": [], "html": "

修复全文检索，使其正确处理短语搜索之上的 NOT（Tom Lane）

\n

!(foo<->bar) 等查询在通过 GiST 或 GIN 索引搜索执行时，无法找到匹配行。

", "text": "修复全文检索，使其正确处理短语搜索之上的 NOT（Tom Lane） !(foo<->bar) 等查询在通过 GiST 或 GIN 索引搜索执行时，无法找到匹配行。", "title": "修复全文检索，使其正确处理短语搜索之上的 NOT", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "385acf1f82f0be7c8569064cb6c2a3986bc5e10f2f47dbaaaadc02f3811ec642", "section_path": ["变更"], "commit_groups": [["072a86327", "18f7e856c", "22dcb6c20", "98a4d6950", "e81e5741a"]], "identity_text": "Fix full text search to handle NOT above a phrase search correctly (Tom Lane) Queries such as !(foo<->bar) failed to find matching rows when implemented as a GiST or GIN index search.", "commit_aliases": ["072a86327", "18f7e856c", "22dcb6c20", "98a4d6950", "e81e5741a"], "source_commits": ["98a4d6950"], "source_entry_id": "11.8/changes/010", "db_id": "1a9756f3e2d5f6d871733a5cf6d8ea3c", "patch_ids": ["4c065a93e83d7e8ddb430e3cabeb6777"], "statement_hash": "0f9befcbc11a5c7d98250bbdebecfdd1a0ed4b0e19492da8193013d6552c9f31", "relations": [{"rule": 2, "type": "equivalent", "target": "1443887885f5eb8d02444e92c10622a7", "evidence": {"same_day": true, "patch_ids": ["4c065a93e83d7e8ddb430e3cabeb6777"], "statement_hash": "0f9befcbc11a5c7d98250bbdebecfdd1a0ed4b0e19492da8193013d6552c9f31"}}, {"rule": 2, "type": "equivalent", "target": "1a294ef8778e35fb300eb8013ef32728", "evidence": {"same_day": true, "patch_ids": ["4c065a93e83d7e8ddb430e3cabeb6777"], "statement_hash": "0f9befcbc11a5c7d98250bbdebecfdd1a0ed4b0e19492da8193013d6552c9f31"}}, {"rule": 2, "type": "equivalent", "target": "5c572a86618501d36bccafaf7df0bec9", "evidence": {"same_day": true, "patch_ids": ["4c065a93e83d7e8ddb430e3cabeb6777"], "statement_hash": "0f9befcbc11a5c7d98250bbdebecfdd1a0ed4b0e19492da8193013d6552c9f31"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "1a294ef8778e35fb300eb8013ef32728", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复全文检索，使其正确处理短语搜索之上的 NOT", "evidence": {"same_day": true, "patch_ids": ["4c065a93e83d7e8ddb430e3cabeb6777"], "statement_hash": "0f9befcbc11a5c7d98250bbdebecfdd1a0ed4b0e19492da8193013d6552c9f31"}, "url": "/docs/compare/?release=12.3#12.3-0bc4f4609693408e", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "5c572a86618501d36bccafaf7df0bec9", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复全文检索，使其正确处理短语搜索之上的 NOT", "evidence": {"same_day": true, "patch_ids": ["4c065a93e83d7e8ddb430e3cabeb6777"], "statement_hash": "0f9befcbc11a5c7d98250bbdebecfdd1a0ed4b0e19492da8193013d6552c9f31"}, "url": "/docs/compare/?release=10.13#10.13-f9293e59b50f27e7", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "1443887885f5eb8d02444e92c10622a7", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复全文搜索正确处理短语搜索之上的 NOT", "evidence": {"same_day": true, "patch_ids": ["4c065a93e83d7e8ddb430e3cabeb6777"], "statement_hash": "0f9befcbc11a5c7d98250bbdebecfdd1a0ed4b0e19492da8193013d6552c9f31"}, "url": "/docs/compare/?release=9.6.18#9.6.18-aaae68746d616ca4", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "11.8-4334394cd73d4e28", "cves": [], "html": "

修复短语搜索包含同时具有前缀匹配和权重限制的项时的全文检索（Tom Lane）

", "text": "修复短语搜索包含同时具有前缀匹配和权重限制的项时的全文检索（Tom Lane）", "title": "修复短语搜索包含同时具有前缀匹配和权重限制的项时的全文检索", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "2f3ea8dd09052869a59b1aaa0da5c11b21a4bee257c10a8aa8d935997564cf54", "section_path": ["变更"], "commit_groups": [["26cf16a93", "5db48808c", "7c9d9aa5c", "db89f0e3a", "e1d70ba43"]], "identity_text": "Fix full text search for cases where a phrase search includes an item with both prefix matching and a weight restriction (Tom Lane)", "commit_aliases": ["26cf16a93", "5db48808c", "7c9d9aa5c", "db89f0e3a", "e1d70ba43"], "source_commits": ["5db48808c"], "source_entry_id": "11.8/changes/011", "db_id": "a9860c60fe2c08be1ec64c68bc3cc4e1", "patch_ids": ["c4a10f963e4d201d72e139ffd9452a8b"], "statement_hash": "cebc232f649653b5c901b796d97b3dbf3edb719a87ddbde51ad78af32a02dc5b", "relations": [{"rule": 2, "type": "equivalent", "target": "36ae0e640041409f9bc0e542585162d9", "evidence": {"same_day": true, "patch_ids": ["c4a10f963e4d201d72e139ffd9452a8b"], "statement_hash": "cebc232f649653b5c901b796d97b3dbf3edb719a87ddbde51ad78af32a02dc5b"}}, {"rule": 2, "type": "equivalent", "target": "3b47250a54454dd03e951b3540ef1996", "evidence": {"same_day": true, "patch_ids": ["c4a10f963e4d201d72e139ffd9452a8b"], "statement_hash": "cebc232f649653b5c901b796d97b3dbf3edb719a87ddbde51ad78af32a02dc5b"}}, {"rule": 2, "type": "equivalent", "target": "7f51f7943f89609513a3c5e717ed1544", "evidence": {"same_day": true, "patch_ids": ["c4a10f963e4d201d72e139ffd9452a8b"], "statement_hash": "cebc232f649653b5c901b796d97b3dbf3edb719a87ddbde51ad78af32a02dc5b"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "3b47250a54454dd03e951b3540ef1996", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复短语搜索包含同时具有前缀匹配和权重限制的项时的全文检索", "evidence": {"same_day": true, "patch_ids": ["c4a10f963e4d201d72e139ffd9452a8b"], "statement_hash": "cebc232f649653b5c901b796d97b3dbf3edb719a87ddbde51ad78af32a02dc5b"}, "url": "/docs/compare/?release=12.3#12.3-8700ecf62b37847e", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "7f51f7943f89609513a3c5e717ed1544", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复短语搜索包含同时具有前缀匹配和权重限制的项时的全文检索", "evidence": {"same_day": true, "patch_ids": ["c4a10f963e4d201d72e139ffd9452a8b"], "statement_hash": "cebc232f649653b5c901b796d97b3dbf3edb719a87ddbde51ad78af32a02dc5b"}, "url": "/docs/compare/?release=10.13#10.13-4334394cd73d4e28", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "36ae0e640041409f9bc0e542585162d9", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复短语搜索包含同时带前缀匹配和权重限制的项时的全文搜索", "evidence": {"same_day": true, "patch_ids": ["c4a10f963e4d201d72e139ffd9452a8b"], "statement_hash": "cebc232f649653b5c901b796d97b3dbf3edb719a87ddbde51ad78af32a02dc5b"}, "url": "/docs/compare/?release=9.6.18#9.6.18-1cde8db21188f106", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "11.8-a113d40008f4681b", "cves": [], "html": "

修复 ts_headline()，使其处理短语查询时更恰当地选择摘要片段（Tom Lane）

", "text": "修复 ts_headline()，使其处理短语查询时更恰当地选择摘要片段（Tom Lane）", "title": "修复 ts_headline()，使其处理短语查询时更恰当地选择摘要片段", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "379d0b6fa7df7e948f236da5376af5ace38b342c4ef8fc861d614d778c639bcd", "section_path": ["变更"], "commit_groups": [["07453e9e3", "2e0e409e3", "9be664d71", "c2599b93d", "d9a3fe4c5"], ["1306edeae", "638519156", "afab39986", "b10f8bb9f", "ff081d6bb"], ["5f7247b3b", "841378947", "91be1d190", "c81de3a82", "c9b0c678d"]], "identity_text": "Fix ts_headline() to make better headline selections when working with phrase queries (Tom Lane)", "commit_aliases": ["07453e9e3", "1306edeae", "2e0e409e3", "5f7247b3b", "638519156", "841378947", "91be1d190", "9be664d71", "afab39986", "b10f8bb9f", "c2599b93d", "c81de3a82", "c9b0c678d", "d9a3fe4c5", "ff081d6bb"], "source_commits": ["91be1d190", "d9a3fe4c5", "ff081d6bb"], "source_entry_id": "11.8/changes/012", "db_id": "46a917c585065298c22091b1f0d58c30", "patch_ids": ["bfa46abbba45286e1f67db60b563bdb1", "fa8b0153f8be6d206f0a0f4592c0b8c2", "fe22db681fdd3ecf9e668c6e77832a4d"], "statement_hash": "f33179b5d06b6ea40df304e1a0bf3f5c33edd172261d9265d307c8b9cc03227a", "relations": [{"rule": 2, "type": "equivalent", "target": "09df5984511f6a9263a549076f9f6536", "evidence": {"same_day": true, "patch_ids": ["bfa46abbba45286e1f67db60b563bdb1", "fa8b0153f8be6d206f0a0f4592c0b8c2", "fe22db681fdd3ecf9e668c6e77832a4d"], "statement_hash": "f33179b5d06b6ea40df304e1a0bf3f5c33edd172261d9265d307c8b9cc03227a"}}, {"rule": 2, "type": "equivalent", "target": "66909ef8a0f6018c8ade0044be29d0a0", "evidence": {"same_day": true, "patch_ids": ["bfa46abbba45286e1f67db60b563bdb1", "fa8b0153f8be6d206f0a0f4592c0b8c2", "fe22db681fdd3ecf9e668c6e77832a4d"], "statement_hash": "f33179b5d06b6ea40df304e1a0bf3f5c33edd172261d9265d307c8b9cc03227a"}}, {"rule": 2, "type": "equivalent", "target": "8468f175f88b157656c21ac51f42be55", "evidence": {"same_day": true, "patch_ids": ["bfa46abbba45286e1f67db60b563bdb1", "fa8b0153f8be6d206f0a0f4592c0b8c2", "fe22db681fdd3ecf9e668c6e77832a4d"], "statement_hash": "f33179b5d06b6ea40df304e1a0bf3f5c33edd172261d9265d307c8b9cc03227a"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "09df5984511f6a9263a549076f9f6536", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 ts_headline()，使其处理短语查询时更恰当地选择摘要片段", "evidence": {"same_day": true, "patch_ids": ["bfa46abbba45286e1f67db60b563bdb1", "fa8b0153f8be6d206f0a0f4592c0b8c2", "fe22db681fdd3ecf9e668c6e77832a4d"], "statement_hash": "f33179b5d06b6ea40df304e1a0bf3f5c33edd172261d9265d307c8b9cc03227a"}, "url": "/docs/compare/?release=12.3#12.3-75ae71da6092eb23", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "66909ef8a0f6018c8ade0044be29d0a0", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复 ts_headline()，使其处理短语查询时更恰当地选择摘要片段", "evidence": {"same_day": true, "patch_ids": ["bfa46abbba45286e1f67db60b563bdb1", "fa8b0153f8be6d206f0a0f4592c0b8c2", "fe22db681fdd3ecf9e668c6e77832a4d"], "statement_hash": "f33179b5d06b6ea40df304e1a0bf3f5c33edd172261d9265d307c8b9cc03227a"}, "url": "/docs/compare/?release=10.13#10.13-a113d40008f4681b", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "8468f175f88b157656c21ac51f42be55", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复 ts_headline() 在处理短语查询时做出更好的标题选择", "evidence": {"same_day": true, "patch_ids": ["bfa46abbba45286e1f67db60b563bdb1", "fa8b0153f8be6d206f0a0f4592c0b8c2", "fe22db681fdd3ecf9e668c6e77832a4d"], "statement_hash": "f33179b5d06b6ea40df304e1a0bf3f5c33edd172261d9265d307c8b9cc03227a"}, "url": "/docs/compare/?release=9.6.18#9.6.18-e9aa75742234c75d", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "11.8-5259498d78a24be6", "cves": [], "html": "

修复 gin_fuzzy_search_limit 处理中的缺陷（Adé Heyward，Tom Lane）

\n

较小的 gin_fuzzy_search_limit 值可能导致同一个索引页被意外重复扫描多次，从而运行异常缓慢。另一个代码路径则完全没有应用预期的过滤，可能返回过多的值。

", "text": "修复 gin_fuzzy_search_limit 处理中的缺陷（Adé Heyward，Tom Lane） 较小的 gin_fuzzy_search_limit 值可能导致同一个索引页被意外重复扫描多次，从而运行异常缓慢。另一个代码路径则完全没有应用预期的过滤，可能返回过多的值。", "title": "修复 gin_fuzzy_search_limit 处理中的缺陷", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["0912fb39c", "e82b6e00a"], "source_entry_id": "11.8/changes/013", "db_id": "1e5f67b8aae46bd27e453f940f6b9eb0", "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": "93dbe527a90d99e13678426a914b3416", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}}, {"rule": 2, "type": "equivalent", "target": "f6f36ce7d2957806f7d55a306c174856", "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": "11.8", "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": "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"}, {"db_id": "f6f36ce7d2957806f7d55a306c174856", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复 gin_fuzzy_search_limit 处理中的 bug", "evidence": {"same_day": true, "patch_ids": ["b8bb0d81c60af19216ffa864a7b577c7", "de9c0320cb3de44bbd93dc8f31f6559f"], "statement_hash": "da375522d3043852049eb4ae8b368d8336f5be207db74838c2d59b3fd68c4f6e"}, "url": "/docs/compare/?release=9.5.22#9.5.22-46e30f1f6da58564", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-7bab0555f16380bd", "cves": [], "html": "

允许 circle 类型的输入按文档所述接受 “(x,y),r” 格式（David Zhang）

", "text": "允许 circle 类型的输入按文档所述接受 “(x,y),r” 格式（David Zhang）", "title": "允许 circle 类型的输入按文档所述接受 “(x,y),r” 格式", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["5fae66410"], "source_entry_id": "11.8/changes/014", "db_id": "f325785ed83a0c11f112cc710c25838e", "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94", "relations": [{"rule": 2, "type": "equivalent", "target": "02a4159dc5fe88a2758c2487d288fda8", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}}, {"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": "fa76a6a1501c7fbabbcb6ebe705a09b1", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}}], "version": "11.8", "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": "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"}, {"db_id": "02a4159dc5fe88a2758c2487d288fda8", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "允许 circle 类型的输入接受文档所述的 “(x,y),r” 格式", "evidence": {"same_day": true, "patch_ids": ["d23a6a1644d907e31f815425f7cae628"], "statement_hash": "4019857a7b00e200088e0baaf99b75a9dea6cc10e87cc83f270119e8da52da94"}, "url": "/docs/compare/?release=9.5.22#9.5.22-cdc70eed27abebe7", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-ca336e3d80787ea1", "cves": [], "html": "

使 get_bit() 和 set_bit() 函数能够处理长于 256MB 的 bytea 字符串（Movead Li）

\n

由于位编号参数只有 int4，无法使用这些函数访问长 bytea 值前 256MB 之外的位。我们将在 v13 中将该参数扩为 int8，但在此之前，先允许这些函数处理长 bytea 值的起始子串。

", "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/11.8/#id-1.11.6.19.5", "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": ["5d79fc60c"], "source_entry_id": "11.8/changes/015", "db_id": "0ea209ac716ba0f4bed1d348ba9b11e8", "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90", "relations": [{"rule": 2, "type": "related", "target": "36951132033efe9497121c46a1b696f0", "evidence": {"same_day": false, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"]}}, {"rule": 2, "type": "equivalent", "target": "73bef7cb7ccfd7e6c375b8b1bf28469a", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}}, {"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": "11.8", "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": "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"}, {"db_id": "73bef7cb7ccfd7e6c375b8b1bf28469a", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "让 get_bit() 和 set_bit() 函数应对长于 256MB 的 bytea 字符串", "evidence": {"same_day": true, "patch_ids": ["1f035cd3ed3162eae50f4cfd66d60f73"], "statement_hash": "ee54f9138685176f7db555e5d0353926be9843bbb1b3a628a40730f582e25a90"}, "url": "/docs/compare/?release=9.5.22#9.5.22-030f702a88b76b01", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-55530640e002eb3a", "cves": [], "html": "

在 pg_ls_waldir() 及相关函数中忽略文件不存在错误（Tom Lane）

\n

这可以防止文件在看到其目录项与尝试对其执行 stat() 之间被移除时，因竞争条件而发生的失败。

", "text": "在 pg_ls_waldir() 及相关函数中忽略文件不存在错误（Tom Lane） 这可以防止文件在看到其目录项与尝试对其执行 stat() 之间被移除时，因竞争条件而发生的失败。", "title": "在 pg_ls_waldir() 及相关函数中忽略文件不存在错误", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "6eaef8bf3dfb972d4828fce68654baaab0101e2a2209fc726599943da04eec7a", "section_path": ["变更"], "commit_groups": [["5b22ff764", "82e801852", "83f7761d8", "ee40e8975"]], "identity_text": "Ignore file-not-found errors in pg_ls_waldir() and allied functions (Tom Lane) This prevents a race condition failure if a file is removed between when we see its directory entry and when we attempt to stat() it.", "commit_aliases": ["5b22ff764", "82e801852", "83f7761d8", "ee40e8975"], "source_commits": ["5b22ff764"], "source_entry_id": "11.8/changes/016", "db_id": "c3a046bd183abe7fe80f7449ff764af5", "patch_ids": ["68cdcbd82ee8d01422ab71e14d44736b"], "statement_hash": "e42d8b5fb4586adb8166e493838112759a068e972c9d6dbb428e71d47d5a0a07", "relations": [{"rule": 2, "type": "equivalent", "target": "143a94e3681d0c7202e7dd63b365b1fb", "evidence": {"same_day": true, "patch_ids": ["68cdcbd82ee8d01422ab71e14d44736b"], "statement_hash": "e42d8b5fb4586adb8166e493838112759a068e972c9d6dbb428e71d47d5a0a07"}}, {"rule": 2, "type": "equivalent", "target": "f9be6f76653399b91fe4d956d1b330a4", "evidence": {"same_day": true, "patch_ids": ["68cdcbd82ee8d01422ab71e14d44736b"], "statement_hash": "e42d8b5fb4586adb8166e493838112759a068e972c9d6dbb428e71d47d5a0a07"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f9be6f76653399b91fe4d956d1b330a4", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 pg_ls_waldir() 及相关函数中忽略文件不存在错误", "evidence": {"same_day": true, "patch_ids": ["68cdcbd82ee8d01422ab71e14d44736b"], "statement_hash": "e42d8b5fb4586adb8166e493838112759a068e972c9d6dbb428e71d47d5a0a07"}, "url": "/docs/compare/?release=12.3#12.3-2930aec297e574ab", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "143a94e3681d0c7202e7dd63b365b1fb", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "在 pg_ls_waldir() 及相关函数中忽略文件不存在错误", "evidence": {"same_day": true, "patch_ids": ["68cdcbd82ee8d01422ab71e14d44736b"], "statement_hash": "e42d8b5fb4586adb8166e493838112759a068e972c9d6dbb428e71d47d5a0a07"}, "url": "/docs/compare/?release=10.13#10.13-55530640e002eb3a", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}]}, {"id": "11.8-37bd61020f50b305", "cves": [], "html": "

避免 pg_ls_dir()、pg_timezone_names()、pg_tablespace_databases() 及相关函数可能泄漏目录的打开文件描述符（Justin Pryzby）

", "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/11.8/#id-1.11.6.19.5", "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": ["13f353b0e", "63b51dfec", "819d55257"], "source_entry_id": "11.8/changes/017", "db_id": "6e4a007c94e742e531786dbfdb04e421", "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": "6518d4773783a87134e5073515347704", "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": "11.8", "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": "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"}, {"db_id": "6518d4773783a87134e5073515347704", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "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.5.22#9.5.22-16fc7a96aad45414", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-086421a9a86e829d", "cves": [], "html": "

修复多态函数的类型解析，使其仅给定 anyrange 输入时，也能正确推断 anyarray 输出的实际类型（Tom Lane）

", "text": "修复多态函数的类型解析，使其仅给定 anyrange 输入时，也能正确推断 anyarray 输出的实际类型（Tom Lane）", "title": "修复多态函数的类型解析，使其仅给定 anyrange 输入时，也能正确推断 anyarray 输出的实际类型", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["540ef37cc"], "source_entry_id": "11.8/changes/018", "db_id": "5ffb8a7e83a86ba7bf69175991f079e4", "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": "687c29378d9400cc17df64f60c36172b", "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": "11.8", "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": "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"}, {"db_id": "687c29378d9400cc17df64f60c36172b", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复多态函数类型解析，使其在只给出 anyrange 输入时正确推断 anyarray 输出的实际类型", "evidence": {"same_day": true, "patch_ids": ["eb89055136b92aff5e4993b6426c337d"], "statement_hash": "9365a05eaf0557bf6600ee8c31ed6a6d2ae3d1cd5a69114b097045cbcde8794e"}, "url": "/docs/compare/?release=9.5.22#9.5.22-0ef4214f6455de4b", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-93c1f8ea0b95db95", "cves": [], "html": "

避免 hash 子计划的 hash 表在多次执行之间泄漏（Andreas Karlsson，Tom Lane）

\n

如果查询重复执行 hash 子计划的次数足够多，这一错误可能导致严重的内存膨胀。

", "text": "避免 hash 子计划的 hash 表在多次执行之间泄漏（Andreas Karlsson，Tom Lane） 如果查询重复执行 hash 子计划的次数足够多，这一错误可能导致严重的内存膨胀。", "title": "避免 hash 子计划的 hash 表在多次执行之间泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "797fabfe6fc72e3273f2610e6b3cbc7eeae8c33673317dc004f9b75a83fe605d", "section_path": ["变更"], "commit_groups": [["58c47ccff", "96d783ae5", "9eb6b652a"]], "identity_text": "Avoid leakage of a hashed subplan's hash tables across multiple executions (Andreas Karlsson, Tom Lane) This mistake could result in severe memory bloat if a query re-executed a hashed subplan enough times.", "commit_aliases": ["58c47ccff", "96d783ae5", "9eb6b652a"], "source_commits": ["9eb6b652a"], "source_entry_id": "11.8/changes/019", "db_id": "575a00e699268fd1c7563d0896556718", "patch_ids": ["0feda9f7358659abc4f7bd06a1ae48eb"], "statement_hash": "b92bde77fd2fe1c7284cec2598eee393b2938fec62f18e3408d44759b93601b3", "relations": [{"rule": 2, "type": "equivalent", "target": "87dcdf19f968873ee3aef04f3dce202e", "evidence": {"same_day": true, "patch_ids": ["0feda9f7358659abc4f7bd06a1ae48eb"], "statement_hash": "b92bde77fd2fe1c7284cec2598eee393b2938fec62f18e3408d44759b93601b3"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "87dcdf19f968873ee3aef04f3dce202e", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "避免 hash 子计划的 hash 表在多次执行之间泄漏", "evidence": {"same_day": true, "patch_ids": ["0feda9f7358659abc4f7bd06a1ae48eb"], "statement_hash": "b92bde77fd2fe1c7284cec2598eee393b2938fec62f18e3408d44759b93601b3"}, "url": "/docs/compare/?release=12.3#12.3-67da86ac0fd30b6e", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-c287f3c512e0cfaa", "cves": [], "html": "

避免 REINDEX 被会话关闭信号终止时不太可能发生的崩溃（Tom Lane）

", "text": "避免 REINDEX 被会话关闭信号终止时不太可能发生的崩溃（Tom Lane）", "title": "避免 REINDEX 被会话关闭信号终止时不太可能发生的崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["56259c377"], "source_entry_id": "11.8/changes/020", "db_id": "d883634d5a0b645136c5e0cc28cb9dac", "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": "a8ee89fc7cc017fcf58ef70b534e8e4a", "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"}}], "version": "11.8", "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": "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"}, {"db_id": "a8ee89fc7cc017fcf58ef70b534e8e4a", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "避免 REINDEX 被会话关闭信号终止时不太可能的崩溃", "evidence": {"same_day": true, "patch_ids": ["e584c6fbf636fab8bdaa4b26a6cb8507"], "statement_hash": "4daf22f440ba785e0df9e5c6ad9f45d57e049326d5355620c17ac684f81a9abf"}, "url": "/docs/compare/?release=9.5.22#9.5.22-59284c3f3f51e4e6", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-d063f10b077765b2", "cves": [], "html": "

修复分区表中发生约束违反错误之后低概率出现的崩溃（Andres Freund）

", "text": "修复分区表中发生约束违反错误之后低概率出现的崩溃（Andres Freund）", "title": "修复分区表中发生约束违反错误之后低概率出现的崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "50f434038817ca80e868699a08766ca67fcbaa01a00e458813131b4ec868e745", "section_path": ["变更"], "commit_groups": [["44170a580", "d35631e37"]], "identity_text": "Fix low-probability crash after constraint violation errors in partitioned tables (Andres Freund)", "commit_aliases": ["44170a580", "d35631e37"], "source_commits": ["d35631e37"], "source_entry_id": "11.8/changes/021", "db_id": "144a43f525ac65f9784a50fda7250f0d", "patch_ids": ["a00056aa27ba17bfeff8b4df231599dd"], "statement_hash": "368c2b34ace4be74958fe582119e9865eda4ed830fdf8a71e17df12417b67af4", "relations": [{"rule": 2, "type": "equivalent", "target": "b736b5582e1849cfe503fca8c5131a7a", "evidence": {"same_day": true, "patch_ids": ["a00056aa27ba17bfeff8b4df231599dd"], "statement_hash": "368c2b34ace4be74958fe582119e9865eda4ed830fdf8a71e17df12417b67af4"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b736b5582e1849cfe503fca8c5131a7a", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复分区表中发生约束违反错误之后低概率出现的崩溃", "evidence": {"same_day": true, "patch_ids": ["a00056aa27ba17bfeff8b4df231599dd"], "statement_hash": "368c2b34ace4be74958fe582119e9865eda4ed830fdf8a71e17df12417b67af4"}, "url": "/docs/compare/?release=10.13#10.13-d063f10b077765b2", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}]}, {"id": "11.8-5c39232081c348b8", "cves": [], "html": "

防止 EXPLAIN 输出可能不正确的哈希连接表统计信息（Konstantin Knizhnik，Tom Lane，Thomas Munro）

", "text": "防止 EXPLAIN 输出可能不正确的哈希连接表统计信息（Konstantin Knizhnik，Tom Lane，Thomas Munro）", "title": "防止 EXPLAIN 输出可能不正确的哈希连接表统计信息", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["f3d06e524"], "source_entry_id": "11.8/changes/022", "db_id": "acb9bc74cea9bb725741f4b518b7d085", "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6", "relations": [{"rule": 2, "type": "equivalent", "target": "0b69cf96620a007e873e288dfec21e5c", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}}, {"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": "d5b3cc0f62b878c539db27f07470e4cf", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}}], "version": "11.8", "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": "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"}, {"db_id": "0b69cf96620a007e873e288dfec21e5c", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "防止 EXPLAIN 打印可能不正确的哈希连接表统计信息", "evidence": {"same_day": true, "patch_ids": ["9577a3f9e890732d3b8029b442f97a49"], "statement_hash": "6b761f25669dcf69182088dcf43cc4200c5b0afd2d993c851d926aa0844d62e6"}, "url": "/docs/compare/?release=9.5.22#9.5.22-64df1d61f3e893da", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-80b9d060d40bebed", "cves": [], "html": "

修复 VACUUM VERBOSE 对堆截断步骤耗时的报告（Tatsuhito Kasahara）

", "text": "修复 VACUUM VERBOSE 对堆截断步骤耗时的报告（Tatsuhito Kasahara）", "title": "修复 VACUUM VERBOSE 对堆截断步骤耗时的报告", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["414ed1ca2"], "source_entry_id": "11.8/changes/023", "db_id": "88c1644901e76c430dd137b8d694c8b6", "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": "8a633a7ef2133d8fa0646de0147187f2", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}}, {"rule": 2, "type": "equivalent", "target": "be137f76a1ae493f53cfb3d23ee2e247", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}}], "version": "11.8", "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": "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"}, {"db_id": "be137f76a1ae493f53cfb3d23ee2e247", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复 VACUUM VERBOSE 中堆截断步骤所用时间的报告", "evidence": {"same_day": true, "patch_ids": ["7809976285699f9f48bdae7877bd16bc"], "statement_hash": "f20cd0a369c926dc94614ecb2b6e088940f49cbdadf07ecf10c542337a4314bc"}, "url": "/docs/compare/?release=9.5.22#9.5.22-a4ad8ab2bac81621", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-22d62cab4e050bed", "cves": [], "html": "

修复 VACUUM VERBOSE 输出中可能低估已删除 B-树索引页数量的问题（Peter Geoghegan）

", "text": "修复 VACUUM VERBOSE 输出中可能低估已删除 B-树索引页数量的问题（Peter Geoghegan）", "title": "修复 VACUUM VERBOSE 输出中可能低估已删除 B-树索引页数量的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "edf612050f41b941e2a38f4fd01e60c2de480e65cb79a09304f4916b4f5294b5", "section_path": ["变更"], "commit_groups": [["40708eaaf", "73a076b03", "d3944c364"]], "identity_text": "Fix possible undercounting of deleted B-tree index pages in VACUUM VERBOSE output (Peter Geoghegan)", "commit_aliases": ["40708eaaf", "73a076b03", "d3944c364"], "source_commits": ["d3944c364"], "source_entry_id": "11.8/changes/024", "db_id": "4f5fdaead6453d5a7ffd75e98468e43e", "patch_ids": ["d1810987df0fd35de69e92589f97403f"], "statement_hash": "29186f66e6d0d71625658999f23a9d7de4dfbb2adbb284473835485c56aa4055", "relations": [{"rule": 2, "type": "equivalent", "target": "26ba0b8f47907bb308567fabb2e0db26", "evidence": {"same_day": true, "patch_ids": ["d1810987df0fd35de69e92589f97403f"], "statement_hash": "29186f66e6d0d71625658999f23a9d7de4dfbb2adbb284473835485c56aa4055"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "26ba0b8f47907bb308567fabb2e0db26", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 VACUUM VERBOSE 输出中可能低估已删除 B-树索引页数量的问题", "evidence": {"same_day": true, "patch_ids": ["d1810987df0fd35de69e92589f97403f"], "statement_hash": "29186f66e6d0d71625658999f23a9d7de4dfbb2adbb284473835485c56aa4055"}, "url": "/docs/compare/?release=12.3#12.3-0a000b4d5698a870", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-f3fbe8e320036e12", "cves": [], "html": "

修复 B-树索引中对最早删除页面的错误记录（Peter Geoghegan）

\n

这可能使有关 VACUUM 何时可以跳过索引清理扫描的判断出现细微错误，不过似乎未必有明显的用户可见影响。

", "text": "修复 B-树索引中对最早删除页面的错误记录（Peter Geoghegan） 这可能使有关 VACUUM 何时可以跳过索引清理扫描的判断出现细微错误，不过似乎未必有明显的用户可见影响。", "title": "修复 B-树索引中对最早删除页面的错误记录", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "a0e3d2ebff28cfa890fc2620b4cd4c3ce7dc3ea4f616460d90792f0f39a3301e", "section_path": ["变更"], "commit_groups": [["05b73261c", "b0229f26d", "e4fa6c929"], ["573478564", "69cf853fe", "e1477db92"]], "identity_text": "Fix wrong bookkeeping for oldest deleted page in a B-tree index (Peter Geoghegan) This could cause subtly wrong decisions about when VACUUM can skip an index cleanup scan; although it appears there may be no significant user-visible effects from that.", "commit_aliases": ["05b73261c", "573478564", "69cf853fe", "b0229f26d", "e1477db92", "e4fa6c929"], "source_commits": ["573478564", "e4fa6c929"], "source_entry_id": "11.8/changes/025", "db_id": "b019c01c727f67b327351e8447b29c12", "patch_ids": ["a19a9d507a4997cd99c1be55100afbe4", "b575e707eb220406b2325f149b5d79dc"], "statement_hash": "77fe0655956952e81926fbc8565e86624e5db1f8a0a46314ca5ec95d630bdcaa", "relations": [{"rule": 2, "type": "equivalent", "target": "ce6fc71a200878168c523633a0c81e28", "evidence": {"same_day": true, "patch_ids": ["a19a9d507a4997cd99c1be55100afbe4", "b575e707eb220406b2325f149b5d79dc"], "statement_hash": "77fe0655956952e81926fbc8565e86624e5db1f8a0a46314ca5ec95d630bdcaa"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ce6fc71a200878168c523633a0c81e28", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复 B-树索引中对最早删除页面的错误记录", "evidence": {"same_day": true, "patch_ids": ["a19a9d507a4997cd99c1be55100afbe4", "b575e707eb220406b2325f149b5d79dc"], "statement_hash": "77fe0655956952e81926fbc8565e86624e5db1f8a0a46314ca5ec95d630bdcaa"}, "url": "/docs/compare/?release=12.3#12.3-d7d54838dea2334b", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-060018bcce3226c7", "cves": [], "html": "

确保在所有读写时间线历史文件的代码路径中报告 TimelineHistoryRead 和 TimelineHistoryWrite 等待状态（Masahiro Ikeda）

", "text": "确保在所有读写时间线历史文件的代码路径中报告 TimelineHistoryRead 和 TimelineHistoryWrite 等待状态（Masahiro Ikeda）", "title": "确保在所有读写时间线历史文件的代码路径中报告 TimelineHistoryRead 和 TimelineHistoryWrite 等待状态", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "2d93d584212731813439a8077a5782425b05406ff847049377bcf612cd045790", "section_path": ["变更"], "commit_groups": [["3a48740e8", "a354d0153", "cc534fc3b", "f2ff20359"]], "identity_text": "Ensure that TimelineHistoryRead and TimelineHistoryWrite wait states are reported in all code paths that read or write timeline history files (Masahiro Ikeda)", "commit_aliases": ["3a48740e8", "a354d0153", "cc534fc3b", "f2ff20359"], "source_commits": ["cc534fc3b"], "source_entry_id": "11.8/changes/026", "db_id": "aeccc32ed0ac58ca6e395d85e904e8ce", "patch_ids": ["bcfbff2e7f59a52073ce8b5864e0ada9"], "statement_hash": "520d04cfe10a1a22518783576daa2251aced6859a0548c5e91d21866211e282d", "relations": [{"rule": 2, "type": "equivalent", "target": "432855c9c37a826e33277939749fe5fd", "evidence": {"same_day": true, "patch_ids": ["bcfbff2e7f59a52073ce8b5864e0ada9"], "statement_hash": "520d04cfe10a1a22518783576daa2251aced6859a0548c5e91d21866211e282d"}}, {"rule": 2, "type": "equivalent", "target": "b0d7bda07e7a01917d56a7ceeee9e8a6", "evidence": {"same_day": true, "patch_ids": ["bcfbff2e7f59a52073ce8b5864e0ada9"], "statement_hash": "520d04cfe10a1a22518783576daa2251aced6859a0548c5e91d21866211e282d"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "432855c9c37a826e33277939749fe5fd", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "确保在所有读写时间线历史文件的代码路径中报告 TimelineHistoryRead 和 TimelineHistoryWrite 等待状态", "evidence": {"same_day": true, "patch_ids": ["bcfbff2e7f59a52073ce8b5864e0ada9"], "statement_hash": "520d04cfe10a1a22518783576daa2251aced6859a0548c5e91d21866211e282d"}, "url": "/docs/compare/?release=12.3#12.3-93b2e0d61d0e4c0e", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "b0d7bda07e7a01917d56a7ceeee9e8a6", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "确保在所有读写时间线历史文件的代码路径中报告 TimelineHistoryRead 和 TimelineHistoryWrite 等待状态", "evidence": {"same_day": true, "patch_ids": ["bcfbff2e7f59a52073ce8b5864e0ada9"], "statement_hash": "520d04cfe10a1a22518783576daa2251aced6859a0548c5e91d21866211e282d"}, "url": "/docs/compare/?release=10.13#10.13-060018bcce3226c7", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}]}, {"id": "11.8-1973e2fb461472c9", "cves": [], "html": "

避免在进程的 PS 状态中可能两次显示 “waiting”（Masahiko Sawada）

", "text": "避免在进程的 PS 状态中可能两次显示 “waiting”（Masahiko Sawada）", "title": "避免在进程的 PS 状态中可能两次显示 “waiting”", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["e54183cb0"], "source_entry_id": "11.8/changes/027", "db_id": "9c38c588942a2de8ba8e7fb0147649d5", "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": "bc7286641728a1efd19e31a44b3cd6a2", "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": "11.8", "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": "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"}, {"db_id": "bc7286641728a1efd19e31a44b3cd6a2", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "避免进程的 PS 状态中可能两次显示 “waiting”", "evidence": {"same_day": true, "patch_ids": ["8cc2e23b39efb918497ce937a490afc6"], "statement_hash": "b2492270143de8c203a1998678437872e10fd4d369ec3ee00abba52e19fa69ea"}, "url": "/docs/compare/?release=9.5.22#9.5.22-f648cc703038394b", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-120dab4c724bb7f9", "cves": [], "html": "

避免自动清理尝试访问刚删除的临时模式时发生失败（Tom Lane）

\n

只有超级用户手动删除临时模式时才会出现这一隐患；这虽然不是常规做法，但也应该能够正常工作。

", "text": "避免自动清理尝试访问刚删除的临时模式时发生失败（Tom Lane） 只有超级用户手动删除临时模式时才会出现这一隐患；这虽然不是常规做法，但也应该能够正常工作。", "title": "避免自动清理尝试访问刚删除的临时模式时发生失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "03a54f708f4e3a518df158500f934bb856561496ce34431867c043cc422abf43", "section_path": ["变更"], "commit_groups": [["7ea20a2bc", "80d76be51", "d7684c38a"]], "identity_text": "Avoid failure if autovacuum tries to access a just-dropped temporary schema (Tom Lane) This hazard only arises if a superuser manually drops a temporary schema; which isn't normal practice, but should work.", "commit_aliases": ["7ea20a2bc", "80d76be51", "d7684c38a"], "source_commits": ["7ea20a2bc"], "source_entry_id": "11.8/changes/028", "db_id": "2417131ff80098f64937fac19ed092f7", "patch_ids": ["a65ec24e200f282fcfef49ab178234a5"], "statement_hash": "e16761537b7277da3cfc202aecfb4df2205fd14c91dc2edf1ab545da154ba366", "relations": [{"rule": 2, "type": "equivalent", "target": "9c518a09c87a41fecfd56b8ad539f159", "evidence": {"same_day": true, "patch_ids": ["a65ec24e200f282fcfef49ab178234a5"], "statement_hash": "e16761537b7277da3cfc202aecfb4df2205fd14c91dc2edf1ab545da154ba366"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "9c518a09c87a41fecfd56b8ad539f159", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "避免自动清理尝试访问刚删除的临时模式时发生失败", "evidence": {"same_day": true, "patch_ids": ["a65ec24e200f282fcfef49ab178234a5"], "statement_hash": "e16761537b7277da3cfc202aecfb4df2205fd14c91dc2edf1ab545da154ba366"}, "url": "/docs/compare/?release=12.3#12.3-62b79f744258b96c", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-a3d32e1cca66132d", "cves": [], "html": "

避免崩溃恢复期间过早回收 WAL 段（Jehan-Guillaume de Rorthais）

\n

在崩溃恢复期间变为可归档状态的 WAL 段，可能在尚未归档的情况下就被回收。

", "text": "避免崩溃恢复期间过早回收 WAL 段（Jehan-Guillaume de Rorthais） 在崩溃恢复期间变为可归档状态的 WAL 段，可能在尚未归档的情况下就被回收。", "title": "避免崩溃恢复期间过早回收 WAL 段", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["0d04e9d76", "2d24ca00b"], "source_entry_id": "11.8/changes/029", "db_id": "339630ead3e826cc8ce60a76a0891a79", "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6", "relations": [{"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": "b12c1aa5e0e23993f2ac453638df2a86", "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": "11.8", "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": "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"}, {"db_id": "b12c1aa5e0e23993f2ac453638df2a86", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "避免崩溃恢复期间过早回收 WAL 段", "evidence": {"same_day": true, "patch_ids": ["0ee7a470a5b9e090e3628d7926425f49", "f4914ad864daad2b94a0f1e6a2922dab"], "statement_hash": "b017931b378881898e4a300452eab798a7beeb68000b31d89ea1d54fffaf78a6"}, "url": "/docs/compare/?release=9.5.22#9.5.22-a3d32e1cca66132d", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-78197daaaef890ec", "cves": [], "html": "

避免归档恢复期间扫描无关的时间线（Kyotaro Horiguchi）

\n

这可以消除许多从归档存储中获取不存在的 WAL 文件的尝试，在归档访问缓慢时很有帮助。

", "text": "避免归档恢复期间扫描无关的时间线（Kyotaro Horiguchi） 这可以消除许多从归档存储中获取不存在的 WAL 文件的尝试，在归档访问缓慢时很有帮助。", "title": "避免归档恢复期间扫描无关的时间线", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["dcd1569fb"], "source_entry_id": "11.8/changes/030", "db_id": "12ca930645248f1c5424dd484b54f738", "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd", "relations": [{"rule": 2, "type": "equivalent", "target": "5534623022d01e53ee6dbef702811fac", "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": "11.8", "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": "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"}, {"db_id": "5534623022d01e53ee6dbef702811fac", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "避免归档恢复期间扫描无关时间线", "evidence": {"same_day": true, "patch_ids": ["d25704ffbad36923b683cfb9e6d1f49c"], "statement_hash": "f80a2b94b71207f2fa0359669721847ebdd99286b7efe8f407f9482a0727efcd"}, "url": "/docs/compare/?release=9.5.22#9.5.22-1a459e89e5863aa7", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-fd829a21505bdb58", "cves": [], "html": "

移除逻辑解码中不正确的 “subtransaction logged without previous top-level txn record” 错误检查（Arseny Sher，Amit Kapila）

\n

在多种场景中都可以正常出现这种情况，因此移除该检查。

", "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/11.8/#id-1.11.6.19.5", "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": ["bff456d7a"], "source_entry_id": "11.8/changes/031", "db_id": "013381b18e4797fb6c20449ccad2be10", "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25", "relations": [{"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"}}, {"rule": 2, "type": "equivalent", "target": "f1e4dd966202377068b8ccf850797012", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}}], "version": "11.8", "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": "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"}, {"db_id": "f1e4dd966202377068b8ccf850797012", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "移除逻辑解码中虚假的 “subtransaction logged without previous top-level txn record” 错误检查", "evidence": {"same_day": true, "patch_ids": ["47911020be76b484c25bd78c8fe351b6"], "statement_hash": "7064bb1ed3eb9ee61c0bc38570e493d8d4fb28a533ec04bf9a03eb9166236b25"}, "url": "/docs/compare/?release=9.5.22#9.5.22-0e828a8ecd846f2a", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-e0835f75d9ce7568", "cves": [], "html": "

确保在失败代码路径中释放复制槽的 io_in_progress_lock（Pavan Deolasee）

\n

这可能使 WAL 发送进程之后卡在等待该锁的状态。

", "text": "确保在失败代码路径中释放复制槽的 io_in_progress_lock（Pavan Deolasee） 这可能使 WAL 发送进程之后卡在等待该锁的状态。", "title": "确保在失败代码路径中释放复制槽的 io_in_progress_lock", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["250041a56", "ba4cc05ce"], "source_entry_id": "11.8/changes/032", "db_id": "49e6106f1b8c589675911ae6e8114480", "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3", "relations": [{"rule": 2, "type": "equivalent", "target": "8d5b02d64733f6ae2be77f9406700aca", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}}, {"rule": 2, "type": "equivalent", "target": "a09a60a9acd28901f8e195523cbf8280", "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": "11.8", "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": "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"}, {"db_id": "a09a60a9acd28901f8e195523cbf8280", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "确保复制槽的 io_in_progress_lock 在失败代码路径中被释放", "evidence": {"same_day": true, "patch_ids": ["073769dfbdef30ab82ee4a086842dae7", "250c289a57b7e94fadf518914341b9aa"], "statement_hash": "fe35fa7ec988e0c03d34cc7fb21c8134735fe9ad2a4b82cdd5aea88145d85cf3"}, "url": "/docs/compare/?release=9.5.22#9.5.22-1d9e9eb64368fe4a", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-44452efc7953fb6b", "cves": [], "html": "

修复同步备库管理中的竞争条件（Tom Lane）

\n

更改 synchronous_standby_names 设置期间，存在一个时间窗口，可能错误判断是否可以放行正在等待同步提交的事务。如果一个 WAL 发送进程进程退出后立即被另一个替代，也存在作出类似错误判断的隐患。

", "text": "修复同步备库管理中的竞争条件（Tom Lane） 更改 synchronous_standby_names 设置期间，存在一个时间窗口，可能错误判断是否可以放行正在等待同步提交的事务。如果一个 WAL 发送进程进程退出后立即被另一个替代，也存在作出类似错误判断的隐患。", "title": "修复同步备库管理中的竞争条件", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "e88bfae157d70b9e6683fd628f9f2753a300d4a9cd96ba69b5ee78a0b6db6d83", "section_path": ["变更"], "commit_groups": [["00ef5d52c", "63ecdaf75", "b3fa6d016", "c65c1aa82", "f332241a6"]], "identity_text": "Fix race conditions in synchronous standby management (Tom Lane) During a change in the synchronous_standby_names setting, there was a window in which wrong decisions could be made about whether it is OK to release transactions that are waiting for synchronous commit. Another hazard for similarly wrong decisions existed if a walsender process exited and was immediately replaced by another.", "commit_aliases": ["00ef5d52c", "63ecdaf75", "b3fa6d016", "c65c1aa82", "f332241a6"], "source_commits": ["b3fa6d016"], "source_entry_id": "11.8/changes/033", "db_id": "4bdc3f545b9148d6817d7438cf8b47e1", "patch_ids": ["81c6d9613c2be59166df8736bd552a1e"], "statement_hash": "3b2e79cc728e2d728a973e00c748471dc2dcdb5b728a01491d5bd55d046167c2", "relations": [{"rule": 2, "type": "equivalent", "target": "2ebb9093c6f5738e41f7b66b2a761a25", "evidence": {"same_day": true, "patch_ids": ["81c6d9613c2be59166df8736bd552a1e"], "statement_hash": "3b2e79cc728e2d728a973e00c748471dc2dcdb5b728a01491d5bd55d046167c2"}}, {"rule": 2, "type": "equivalent", "target": "34926f4569a2a531df24a36bbcb8a1bf", "evidence": {"same_day": true, "patch_ids": ["81c6d9613c2be59166df8736bd552a1e"], "statement_hash": "3b2e79cc728e2d728a973e00c748471dc2dcdb5b728a01491d5bd55d046167c2"}}, {"rule": 2, "type": "equivalent", "target": "4de61a23e2a85d85bf4191ffea954456", "evidence": {"same_day": true, "patch_ids": ["81c6d9613c2be59166df8736bd552a1e"], "statement_hash": "3b2e79cc728e2d728a973e00c748471dc2dcdb5b728a01491d5bd55d046167c2"}}], "version": "11.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "2ebb9093c6f5738e41f7b66b2a761a25", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "修复同步备库管理中的竞争条件", "evidence": {"same_day": true, "patch_ids": ["81c6d9613c2be59166df8736bd552a1e"], "statement_hash": "3b2e79cc728e2d728a973e00c748471dc2dcdb5b728a01491d5bd55d046167c2"}, "url": "/docs/compare/?release=12.3#12.3-13d10710a5b5adb5", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "34926f4569a2a531df24a36bbcb8a1bf", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "修复同步备库管理中的竞争条件", "evidence": {"same_day": true, "patch_ids": ["81c6d9613c2be59166df8736bd552a1e"], "statement_hash": "3b2e79cc728e2d728a973e00c748471dc2dcdb5b728a01491d5bd55d046167c2"}, "url": "/docs/compare/?release=10.13#10.13-44452efc7953fb6b", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "4de61a23e2a85d85bf4191ffea954456", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "修复同步备库管理中的竞态条件", "evidence": {"same_day": true, "patch_ids": ["81c6d9613c2be59166df8736bd552a1e"], "statement_hash": "3b2e79cc728e2d728a973e00c748471dc2dcdb5b728a01491d5bd55d046167c2"}, "url": "/docs/compare/?release=9.6.18#9.6.18-a57b113a3c5767d3", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "11.8-81f9c755f6992459", "cves": [], "html": "

确保备库上的 nextXid 不会倒退（Eka Palamadai）

\n

此竞争条件可能使错误的热备反馈消息被发送回主库，从而可能让主库过早执行 VACUUM。

", "text": "确保备库上的 nextXid 不会倒退（Eka Palamadai） 此竞争条件可能使错误的热备反馈消息被发送回主库，从而可能让主库过早执行 VACUUM。", "title": "确保备库上的 nextXid 不会倒退", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["a493f9334"], "source_entry_id": "11.8/changes/034", "db_id": "a2820077d8e7c05a8915fa36543d7e04", "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18", "relations": [{"rule": 2, "type": "equivalent", "target": "272601a64a732b1a4a44f7b76e926bf4", "evidence": {"same_day": true, "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18"}}, {"rule": 2, "type": "equivalent", "target": "70c6ac53973e68036f34916e0d9f1d5e", "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": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "272601a64a732b1a4a44f7b76e926bf4", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "确保备库服务器上 nextXid 不会倒退", "evidence": {"same_day": true, "patch_ids": ["3f3de0e3455c037f2437ef94a6399660"], "statement_hash": "9e9968f30cc4fe2014b90d42a4ff0e09dc036676583b5a22db13ffc767c2af18"}, "url": "/docs/compare/?release=9.5.22#9.5.22-68ac647cd62a7cc2", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-69ca7fb3ed12cfcf", "cves": [], "html": "

为几个错误报告补上缺失的 SQLSTATE 值（Sawada Masahiko）

", "text": "为几个错误报告补上缺失的 SQLSTATE 值（Sawada Masahiko）", "title": "为几个错误报告补上缺失的 SQLSTATE 值", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["18c41cb6b"], "source_entry_id": "11.8/changes/035", "db_id": "2065c32f3e3290021e9f29159ed0031b", "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79", "relations": [{"rule": 2, "type": "equivalent", "target": "6c228a9d22842aa71a7727972e8eaa10", "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": "11.8", "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": "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"}, {"db_id": "6c228a9d22842aa71a7727972e8eaa10", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "为少数错误报告补上缺失的 SQLSTATE 值", "evidence": {"same_day": true, "patch_ids": ["95fa83e84fa735fa6772c5a7cf0e20e9"], "statement_hash": "6203b18db9bc05790271f3024f22277b886efb401268603c980bfd01f6336c79"}, "url": "/docs/compare/?release=9.5.22#9.5.22-1f7df64db7301187", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-a5d07257463b709b", "cves": [], "html": "

修复 PL/pgSQL，使其可靠地拒绝将事件触发器函数作为普通函数执行（Tom Lane）

", "text": "修复 PL/pgSQL，使其可靠地拒绝将事件触发器函数作为普通函数执行（Tom Lane）", "title": "修复 PL/pgSQL，使其可靠地拒绝将事件触发器函数作为普通函数执行", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["612d207bc"], "source_entry_id": "11.8/changes/036", "db_id": "4e52c2f502c6e0897d8a1b3e9ca67efe", "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": "9387468acfa91ec955cd14175f688f42", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}}, {"rule": 2, "type": "equivalent", "target": "c6f5e3f95c20ab12d143eca9a07cb33c", "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": "11.8", "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": "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"}, {"db_id": "c6f5e3f95c20ab12d143eca9a07cb33c", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复 PL/pgSQL，使其可靠地拒绝把事件触发器函数当作普通函数执行", "evidence": {"same_day": true, "patch_ids": ["cc39e7a39baa7a5827063f9e683a9178"], "statement_hash": "b1218664b3a80ba7853a331cb331df7cb761258c8bb10c7b23779bcde812e55d"}, "url": "/docs/compare/?release=9.5.22#9.5.22-b6a18b5603ac59cb", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-30b08a02b4d835d8", "cves": [], "html": "

修复 libpq 使用 sslmode=verify-full 时的内存泄漏（Roman Peshkurov）

\n

连接启动期间的证书验证可能泄漏一些内存。如果客户端进程在其生命周期内打开大量数据库连接，这就会成为问题。

", "text": "修复 libpq 使用 sslmode=verify-full 时的内存泄漏（Roman Peshkurov） 连接启动期间的证书验证可能泄漏一些内存。如果客户端进程在其生命周期内打开大量数据库连接，这就会成为问题。", "title": "修复 libpq 使用 sslmode=verify-full 时的内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["35d08658d"], "source_entry_id": "11.8/changes/037", "db_id": "9663fe9a33076a65f15e72ec78500a20", "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": "7569ce1fedee0ca0d57987004a2130bf", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}}], "version": "11.8", "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": "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"}, {"db_id": "7569ce1fedee0ca0d57987004a2130bf", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复使用 sslmode=verify-full 时 libpq 中的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["6d68db2cc74c3575a3afa59fb55211ad"], "statement_hash": "29132bba58d823484ab45df669644623c0af1ba28d677b90d9d5630154a0450e"}, "url": "/docs/compare/?release=9.5.22#9.5.22-492272dff32caf3d", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-2774b02c4bef748f", "cves": [], "html": "

修复 ecpg，使其在所有平台上都将仅包含 “-” 的参数解释为“从 stdin 读取”（Tom Lane）

", "text": "修复 ecpg，使其在所有平台上都将仅包含 “-” 的参数解释为“从 stdin 读取”（Tom Lane）", "title": "修复 ecpg，使其在所有平台上都将仅包含 “-” 的参数解释为“从 stdin 读取”", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["aae7e8530"], "source_entry_id": "11.8/changes/038", "db_id": "819404475daf180026c644a2b44c5436", "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": "b8f1ac84fc1653c621e609a0c48e8a4c", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}}, {"rule": 2, "type": "equivalent", "target": "cff5e6ff586cca37f65f333e05c359ae", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}}], "version": "11.8", "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": "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"}, {"db_id": "cff5e6ff586cca37f65f333e05c359ae", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复 ecpg 在所有平台上都把仅为 “-” 的参数当作“从 stdin 读取”", "evidence": {"same_day": true, "patch_ids": ["eecf16befc61b5f87fa45adb19719c26"], "statement_hash": "0e2f8b5a400dc9db1aa8fb81c895cf7be77f219ebbd3b7e2f74231a86a117875"}, "url": "/docs/compare/?release=9.5.22#9.5.22-52fc5c246d4ce733", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-c9c3571e1ea6b3d0", "cves": [], "html": "

允许对 psql 的 \\gx 命令的文件名参数进行 Tab 补全（Vik Fearing）

", "text": "允许对 psql 的 \\gx 命令的文件名参数进行 Tab 补全（Vik Fearing）", "title": "允许对 psql 的 \\gx 命令的文件名参数进行 Tab 补全", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "ce1ffb4d726314d3d16f75b3b0c7afbb80cceed596c61f21e67f33eb6ec97539", "section_path": ["变更"], "commit_groups": [["08481eedd", "6a50f1af4", "7054e12e0", "a936012d6"]], "identity_text": "Allow tab-completion of the filename argument to psql's \\gx command (Vik Fearing)", "commit_aliases": ["08481eedd", "6a50f1af4", "7054e12e0", "a936012d6"], "source_commits": ["7054e12e0"], "source_entry_id": "11.8/changes/039", "db_id": "43fdbf8f08a3ffb3a236a428cb15c515", "patch_ids": ["44c50371784ab96d9d636e6eb11443d5"], "statement_hash": "bc156b7bea6864746e928a3d3678ca23421d7bd4da3303a25426af50d0b13552", "relations": [{"rule": 2, "type": "equivalent", "target": "8a2edb773aeb2472361b161d8bbfdc78", "evidence": {"same_day": true, "patch_ids": ["44c50371784ab96d9d636e6eb11443d5"], "statement_hash": "bc156b7bea6864746e928a3d3678ca23421d7bd4da3303a25426af50d0b13552"}}, {"rule": 2, "type": "equivalent", "target": "ab174f0e63685ab4fdd413913448b91d", "evidence": {"same_day": true, "patch_ids": ["44c50371784ab96d9d636e6eb11443d5"], "statement_hash": "bc156b7bea6864746e928a3d3678ca23421d7bd4da3303a25426af50d0b13552"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "ab174f0e63685ab4fdd413913448b91d", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "允许对 psql 的 \\gx 命令的文件名参数进行 Tab 补全", "evidence": {"same_day": true, "patch_ids": ["44c50371784ab96d9d636e6eb11443d5"], "statement_hash": "bc156b7bea6864746e928a3d3678ca23421d7bd4da3303a25426af50d0b13552"}, "url": "/docs/compare/?release=12.3#12.3-98610d739c1759a4", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "8a2edb773aeb2472361b161d8bbfdc78", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "允许对 psql 的 \\gx 命令的文件名参数进行 Tab 补全", "evidence": {"same_day": true, "patch_ids": ["44c50371784ab96d9d636e6eb11443d5"], "statement_hash": "bc156b7bea6864746e928a3d3678ca23421d7bd4da3303a25426af50d0b13552"}, "url": "/docs/compare/?release=10.13#10.13-c9c3571e1ea6b3d0", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}]}, {"id": "11.8-6570405611594d3c", "cves": [], "html": "

为 pg_dump 增加对 ALTER ... DEPENDS ON EXTENSION 的支持（Álvaro Herrera）

\n

pg_dump 以前忽略了以这种方式添加的依赖关系，导致它们在转储/恢复或 pg_upgrade 期间丢失。

", "text": "为 pg_dump 增加对 ALTER ... DEPENDS ON EXTENSION 的支持（Álvaro Herrera） pg_dump 以前忽略了以这种方式添加的依赖关系，导致它们在转储/恢复或 pg_upgrade 期间丢失。", "title": "为 pg_dump 增加对 ALTER ... DEPENDS ON EXTENSION 的支持", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "4959ef4f14129eabbd5ed818e519f99de6358b3f4ae260ac2ed132bdb97cf4c5", "section_path": ["变更"], "commit_groups": [["046001fe3", "55978e28c", "7984c7e9f", "c6b75b3f1", "cf72898c6"], ["2b9d70159", "b08dee24a", "d04e342ba", "e70187c9b", "f977e6dec"], ["3dfd2d6cd", "73b31e784", "7c094a11c", "899a04f5e", "b7739ebec"]], "identity_text": "Add pg_dump support for ALTER ... DEPENDS ON EXTENSION (Álvaro Herrera) pg_dump previously ignored dependencies added this way, causing them to be forgotten during dump/restore or pg_upgrade.", "commit_aliases": ["046001fe3", "2b9d70159", "3dfd2d6cd", "55978e28c", "73b31e784", "7984c7e9f", "7c094a11c", "899a04f5e", "b08dee24a", "b7739ebec", "c6b75b3f1", "cf72898c6", "d04e342ba", "e70187c9b", "f977e6dec"], "source_commits": ["55978e28c", "7c094a11c", "e70187c9b"], "source_entry_id": "11.8/changes/040", "db_id": "09d7cf6a3624acb5929f8c14a86d320b", "patch_ids": ["14fe4ec45c18e9be4475d97abba84500", "b9d0c01e4ae27a7b990254dc87619ef1", "f7eaa8c4c51d282e9625c7e21ffffc6b"], "statement_hash": "c491d88bf7cd0f1546c0dec5502016f034b2d3c24c58dafe883234e3639d6990", "relations": [{"rule": 2, "type": "equivalent", "target": "cb4d4c22e907f01398e86e346dc9c676", "evidence": {"same_day": true, "patch_ids": ["14fe4ec45c18e9be4475d97abba84500", "b9d0c01e4ae27a7b990254dc87619ef1", "f7eaa8c4c51d282e9625c7e21ffffc6b"], "statement_hash": "c491d88bf7cd0f1546c0dec5502016f034b2d3c24c58dafe883234e3639d6990"}}, {"rule": 2, "type": "equivalent", "target": "e5e6db0c574e7d072ec7a26f32ef0c29", "evidence": {"same_day": true, "patch_ids": ["14fe4ec45c18e9be4475d97abba84500", "b9d0c01e4ae27a7b990254dc87619ef1", "f7eaa8c4c51d282e9625c7e21ffffc6b"], "statement_hash": "c491d88bf7cd0f1546c0dec5502016f034b2d3c24c58dafe883234e3639d6990"}}, {"rule": 2, "type": "equivalent", "target": "f8199b9150558f0053448f93f9642254", "evidence": {"same_day": true, "patch_ids": ["14fe4ec45c18e9be4475d97abba84500", "b9d0c01e4ae27a7b990254dc87619ef1", "f7eaa8c4c51d282e9625c7e21ffffc6b"], "statement_hash": "c491d88bf7cd0f1546c0dec5502016f034b2d3c24c58dafe883234e3639d6990"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e5e6db0c574e7d072ec7a26f32ef0c29", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "为 pg_dump 增加对 ALTER ... DEPENDS ON EXTENSION 的支持", "evidence": {"same_day": true, "patch_ids": ["14fe4ec45c18e9be4475d97abba84500", "b9d0c01e4ae27a7b990254dc87619ef1", "f7eaa8c4c51d282e9625c7e21ffffc6b"], "statement_hash": "c491d88bf7cd0f1546c0dec5502016f034b2d3c24c58dafe883234e3639d6990"}, "url": "/docs/compare/?release=12.3#12.3-8dabb85d87a70973", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "cb4d4c22e907f01398e86e346dc9c676", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "为 pg_dump 增加对 ALTER ... DEPENDS ON EXTENSION 的支持", "evidence": {"same_day": true, "patch_ids": ["14fe4ec45c18e9be4475d97abba84500", "b9d0c01e4ae27a7b990254dc87619ef1", "f7eaa8c4c51d282e9625c7e21ffffc6b"], "statement_hash": "c491d88bf7cd0f1546c0dec5502016f034b2d3c24c58dafe883234e3639d6990"}, "url": "/docs/compare/?release=10.13#10.13-6570405611594d3c", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}, {"db_id": "f8199b9150558f0053448f93f9642254", "kind": "equivalent", "version": "9.6.18", "label": "9.6.18", "title": "为 pg_dump 添加 ALTER ... DEPENDS ON EXTENSION 支持", "evidence": {"same_day": true, "patch_ids": ["14fe4ec45c18e9be4475d97abba84500", "b9d0c01e4ae27a7b990254dc87619ef1", "f7eaa8c4c51d282e9625c7e21ffffc6b"], "statement_hash": "c491d88bf7cd0f1546c0dec5502016f034b2d3c24c58dafe883234e3639d6990"}, "url": "/docs/compare/?release=9.6.18#9.6.18-5e6a1bc08a502e55", "source_url": "/docs/release/9.6.18/#id-1.11.6.11.5"}]}, {"id": "11.8-45af8ee4eb6fc4b4", "cves": [], "html": "

修复 pg_dump，使其转储 RLS 策略对象上的注释（Tom Lane）

", "text": "修复 pg_dump，使其转储 RLS 策略对象上的注释（Tom Lane）", "title": "修复 pg_dump，使其转储 RLS 策略对象上的注释", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["bd2cd138f"], "source_entry_id": "11.8/changes/041", "db_id": "e859422314570f65827212ac979a8497", "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": "8006ac44eeafaedba4e129814d0deaba", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}}], "version": "11.8", "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": "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"}, {"db_id": "8006ac44eeafaedba4e129814d0deaba", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复 pg_dump 转储 RLS 策略对象上的注释", "evidence": {"same_day": true, "patch_ids": ["606311355c1c8c1d3af833d23d39feca"], "statement_hash": "5046af0d46dab82846d39781f89af0c569dc1a95b3647553bac73f3d2bd3a6d9"}, "url": "/docs/compare/?release=9.5.22#9.5.22-631ca1215d6c17dd", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-e5ac383e1f0be379", "cves": [], "html": "

在 pg_dump 中，将事件触发器的恢复推迟到最后（Fabrízio de Royes Mello，Hamid Akhtar，Tom Lane）

\n

这尽可能降低了事件触发器干扰其他对象恢复的风险。

", "text": "在 pg_dump 中，将事件触发器的恢复推迟到最后（Fabrízio de Royes Mello，Hamid Akhtar，Tom Lane） 这尽可能降低了事件触发器干扰其他对象恢复的风险。", "title": "在 pg_dump 中，将事件触发器的恢复推迟到最后", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["d050c6113", "f5d49f226"], "source_entry_id": "11.8/changes/042", "db_id": "f8e9cbf12893ff4d294069968a78257f", "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": "921238244a4ace6028c6720eaae54c6d", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}}], "version": "11.8", "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": "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"}, {"db_id": "921238244a4ace6028c6720eaae54c6d", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "在 pg_dump 中，把事件触发器的恢复推迟到最后", "evidence": {"same_day": true, "patch_ids": ["7125087871ca3469f00248abdd74d860", "bc95c0ec7766b7e38caf6e40b88c818d"], "statement_hash": "2bd7226e75e0b61b188a08034319a5c534b9c38743fdf702147e9b5444031542"}, "url": "/docs/compare/?release=9.5.22#9.5.22-e807ca1d6ba56c52", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-48ab08c94bc94a45", "cves": [], "html": "

使 pg_verify_checksums 跳过属于其他 PostgreSQL 大版本的表空间子目录（Michael Banck，Bernd Helmle）

\n

这些子目录实际上不属于我们的数据库集簇，因此不得处理它们。

", "text": "使 pg_verify_checksums 跳过属于其他 PostgreSQL 大版本的表空间子目录（Michael Banck，Bernd Helmle） 这些子目录实际上不属于我们的数据库集簇，因此不得处理它们。", "title": "使 pg_verify_checksums 跳过属于其他 PostgreSQL 大版本的表空间子目录", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "9be0503959a162ea6a89f7da38a610bc622e8642d0c7bf5e91b86eb064b4c18a", "section_path": ["变更"], "commit_groups": [["428a2609e", "8f9aba187", "f6e8e8b38"]], "identity_text": "Make pg_verify_checksums skip tablespace subdirectories that belong to a different PostgreSQL major version (Michael Banck, Bernd Helmle) Such subdirectories don't really belong to our database cluster, and so must not be processed.", "commit_aliases": ["428a2609e", "8f9aba187", "f6e8e8b38"], "source_commits": ["8f9aba187"], "source_entry_id": "11.8/changes/043", "db_id": "1841753388f262ca14c603f2f65171c2", "patch_ids": ["915cd50690eced03bae43a4b3660f67e"], "statement_hash": "c6495c930ada7558c6f35259f2f8c7bc36368d50400c34a155f57df64a2e9fb1", "relations": [{"rule": 2, "type": "equivalent", "target": "10ef5891887d6ef1c1bf1d11844ee4b5", "evidence": {"same_day": true, "patch_ids": ["915cd50690eced03bae43a4b3660f67e"]}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "10ef5891887d6ef1c1bf1d11844ee4b5", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "使 pg_checksums 跳过属于其他 PostgreSQL 大版本的表空间子目录", "evidence": {"same_day": true, "patch_ids": ["915cd50690eced03bae43a4b3660f67e"]}, "url": "/docs/compare/?release=12.3#12.3-b6528bd84442120d", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-4dd0fe183764d6cd", "cves": [], "html": "

在 pg_verify_checksums 及相关程序中忽略 pg_internal.init 的临时副本（Michael Paquier）

", "text": "在 pg_verify_checksums 及相关程序中忽略 pg_internal.init 的临时副本（Michael Paquier）", "title": "在 pg_verify_checksums 及相关程序中忽略 pg_internal.init 的临时副本", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "87425d2d1e860c1b9bc7889c8ff6227efcb5c622f6ec6546c372c0486f610db8", "section_path": ["变更"], "commit_groups": [["a8beece95", "bf883b211", "da2a7180a"]], "identity_text": "Ignore temporary copies of pg_internal.init in pg_verify_checksums and related programs (Michael Paquier)", "commit_aliases": ["a8beece95", "bf883b211", "da2a7180a"], "source_commits": ["da2a7180a"], "source_entry_id": "11.8/changes/044", "db_id": "1a980a9f586c884b568cd50bf3a0e318", "patch_ids": ["67606cf9cbc90ed96869085959eb8c54"], "statement_hash": "46a777d7d25a25888cf7f70ce0b5ce21df3015392a54d6b11ffc23f7844c4fe7", "relations": [{"rule": 2, "type": "equivalent", "target": "382d05479356364ea65e2556324e71d1", "evidence": {"same_day": true, "patch_ids": ["67606cf9cbc90ed96869085959eb8c54"]}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "382d05479356364ea65e2556324e71d1", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 pg_checksums 及相关程序中忽略 pg_internal.init 的临时副本", "evidence": {"same_day": true, "patch_ids": ["67606cf9cbc90ed96869085959eb8c54"]}, "url": "/docs/compare/?release=12.3#12.3-2ae8b145b282cba5", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-8efba8920817e6a2", "cves": [], "html": "

修复 createdb 工具中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理（Michael Paquier）

", "text": "修复 createdb 工具中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理（Michael Paquier）", "title": "修复 createdb 工具中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["83bd732eb", "8e076f4f9"], "source_entry_id": "11.8/changes/045", "db_id": "d890ca8665f057654035ee52656c258d", "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": "9631fea169d3e2bda212def89fad0300", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}}], "version": "11.8", "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": "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"}, {"db_id": "9631fea169d3e2bda212def89fad0300", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复 createdb 实用程序中 --encoding、--lc-ctype 和 --lc-collate 值的引号处理", "evidence": {"same_day": true, "patch_ids": ["992c59a6a7bca749fb7a9be60e255a10", "cac6eb876e8059ad8a904202b840f43b"], "statement_hash": "6bf2fe67a63664cc9b6ca95efe5b662add72403837d94af1ddc4f37d8e4b78d0"}, "url": "/docs/compare/?release=9.5.22#9.5.22-9896aab3c02f3e64", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-6169e3de25d3c4a5", "cves": [], "html": "

直接调用 contrib/lo 的 lo_manage() 函数，而非作为触发器调用时，会发生崩溃（Tom Lane）

", "text": "直接调用 contrib/lo 的 lo_manage() 函数，而非作为触发器调用时，会发生崩溃（Tom Lane）", "title": "直接调用 contrib/lo 的 lo_manage() 函数，而非作为触发器调用时，会发生崩溃", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["7b1552283"], "source_entry_id": "11.8/changes/046", "db_id": "72595b9ea60880022a25cf3adf9c2543", "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": "afe650853d30a9ef20f26cd2872adca2", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}}, {"rule": 2, "type": "equivalent", "target": "d832f23d03cce13f5515d8c16ded0771", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}}], "version": "11.8", "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": "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"}, {"db_id": "d832f23d03cce13f5515d8c16ded0771", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "contrib/lo 的 lo_manage() 函数在被直接调用而非作为触发器调用时崩溃", "evidence": {"same_day": true, "patch_ids": ["105321cacfa53733e73c715a8cfa6e7c"], "statement_hash": "39dd260ca6069ccc414dfaa950cfbe672f1eb396089b7ac9c0b7c44669cea5f5"}, "url": "/docs/compare/?release=9.5.22#9.5.22-e2d45b363d19ce8d", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-e84668cbe1db2ced", "cves": [], "html": "

在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出（Nikita Glukhov）

", "text": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出（Nikita Glukhov）", "title": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["5feb3d0b3"], "source_entry_id": "11.8/changes/047", "db_id": "c59013ac9aa7e195fe75c8ab58ff6641", "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": "446c6564bfb710f10301497a3a712101", "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"}}], "version": "11.8", "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": "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"}, {"db_id": "446c6564bfb710f10301497a3a712101", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "在 contrib/ltree 中，防止 ltree 和 lquery 长度字段溢出", "evidence": {"same_day": true, "patch_ids": ["1f01fc809a15a524e654d974b33b2ee6"], "statement_hash": "25e480641d9e671d47377be05227b1cca605632176f1880e634826f6b4ea6efd"}, "url": "/docs/compare/?release=9.5.22#9.5.22-e84668cbe1db2ced", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-c5561c3bb0883d5f", "cves": [], "html": "

规避 oldest_xact 值超过 2^31-1 时 contrib/pageinspect 的 bt_metap() 函数发生的失败（Peter Geoghegan）

\n

此类 XID 现在会被报告为负整数，这虽然不理想，但总比抛出错误好。v13 将把输出参数扩为 int8，以提供更合理的报告。

", "text": "规避 oldest_xact 值超过 2^31-1 时 contrib/pageinspect 的 bt_metap() 函数发生的失败（Peter Geoghegan） 此类 XID 现在会被报告为负整数，这虽然不理想，但总比抛出错误好。v13 将把输出参数扩为 int8，以提供更合理的报告。", "title": "规避 oldest_xact 值超过 2^31-1 时 contrib/pageinspect 的 bt_metap() 函数发生的失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "c94eda6d3e92206cdfb5238b6237f0fd4a35f95bfdd155cf6fb7091bb5a03a20", "section_path": ["变更"], "commit_groups": [["393b449f1", "c788115b5"]], "identity_text": "Work around failure in contrib/pageinspect's bt_metap() function when an oldest_xact value exceeds 2^31-1 (Peter Geoghegan) Such XIDs will now be reported as negative integers, which isn't great but it beats throwing an error. v13 will widen the output argument to int8 to provide saner reporting.", "commit_aliases": ["393b449f1", "c788115b5"], "source_commits": ["c788115b5"], "source_entry_id": "11.8/changes/048", "db_id": "4d24bc9ed65eea85f8b3cdbd7f932bb4", "patch_ids": ["60d301cbcb2f883794fdec51221c30a3"], "statement_hash": "d3953bd821fc0bd4ee9d54bae20205150668408c99796ec0cd77e77944a16e0d", "relations": [{"rule": 2, "type": "equivalent", "target": "8f48f00282c6ee5810d0ec8c9200f943", "evidence": {"same_day": true, "patch_ids": ["60d301cbcb2f883794fdec51221c30a3"], "statement_hash": "d3953bd821fc0bd4ee9d54bae20205150668408c99796ec0cd77e77944a16e0d"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "8f48f00282c6ee5810d0ec8c9200f943", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "规避 oldest_xact 值超过 2^31-1 时 contrib/pageinspect 的 bt_metap() 函数发生的失败", "evidence": {"same_day": true, "patch_ids": ["60d301cbcb2f883794fdec51221c30a3"], "statement_hash": "d3953bd821fc0bd4ee9d54bae20205150668408c99796ec0cd77e77944a16e0d"}, "url": "/docs/compare/?release=12.3#12.3-64c1e56eb05c2ec5", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}]}, {"id": "11.8-924229b253a1d1d9", "cves": [], "html": "

修复 contrib/sepgsql 中的缓存引用泄漏（Michael Luo）

", "text": "修复 contrib/sepgsql 中的缓存引用泄漏（Michael Luo）", "title": "修复 contrib/sepgsql 中的缓存引用泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["cc2737ab0"], "source_entry_id": "11.8/changes/049", "db_id": "0999d93b8aad134fc72404ddd8befcd2", "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8", "relations": [{"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": "ef00e736ed73f5625a760bb8c60f376b", "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": "11.8", "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": "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"}, {"db_id": "ef00e736ed73f5625a760bb8c60f376b", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "修复 contrib/sepgsql 中的缓存引用泄漏", "evidence": {"same_day": true, "patch_ids": ["60b4dc41bbad59ed833fc2e96b324160"], "statement_hash": "d36459f90623beacf2d25ca3a927be93ebc24e9ef2bbcfe4fa8c9e50f6503fe8"}, "url": "/docs/compare/?release=9.5.22#9.5.22-924229b253a1d1d9", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-596472144cb5706b", "cves": [], "html": "

避免在 Windows 上处理 Unix 风格区域设置名称时发生失败（Juan José Santamaría Flecha）

", "text": "避免在 Windows 上处理 Unix 风格区域设置名称时发生失败（Juan José Santamaría Flecha）", "title": "避免在 Windows 上处理 Unix 风格区域设置名称时发生失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["4bc3a1667"], "source_entry_id": "11.8/changes/050", "db_id": "c8d670683fce6f86d2217dcb8515de0d", "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": "cad42e7939880eaefb16481983255b17", "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": "11.8", "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": "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"}, {"db_id": "cad42e7939880eaefb16481983255b17", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "避免在 Windows 上处理 Unix 风格区域名时的失败", "evidence": {"same_day": true, "patch_ids": ["c657cd9c5478e303ec401593cb5de734"], "statement_hash": "9a8407997aa8db3c6fd5066de2675c602df794a7008f0617a54fa957b3d61cf8"}, "url": "/docs/compare/?release=9.5.22#9.5.22-111f6724f6609fc4", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-7b6894a94939304a", "cves": [], "html": "

在 configure 期间，如果 pkg-config 可用，则使用它定位 libxml2（Hugh McMaster，Tom Lane，Peter Eisentraut）

\n

如果 pkg-config 不存在，或不包含 libxml2 的信息，我们仍像以前一样查询 xml2-config。

\n

某些构建过程通过将非默认版本的 xml2-config 放入 PATH，来让 PostgreSQL 使用该版本的 libxml2；此项修改可能使这些构建过程失效。应改为设置 XML2_CONFIG，使其指向非默认的 xml2-config。这种方法对较旧和较新的 PostgreSQL 发行版都适用。

", "text": "在 configure 期间，如果 pkg-config 可用，则使用它定位 libxml2（Hugh McMaster，Tom Lane，Peter Eisentraut） 如果 pkg-config 不存在，或不包含 libxml2 的信息，我们仍像以前一样查询 xml2-config。 某些构建过程通过将非默认版本的 xml2-config 放入 PATH，来让 PostgreSQL 使用该版本的 libxml2；此项修改可能使这些构建过程失效。应改为设置 XML2_CONFIG，使其指向非默认的 xml2-config。这种方法对较旧和较新的 PostgreSQL 发行版都适用。", "title": "在 configure 期间，如果 pkg-config 可用，则使用它定位 libxml2", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "source_hash": "62ac65b613d4ed208cee02e4755d048278a01e8d90bfff65ac65443c19daa7d2", "section_path": ["变更"], "commit_groups": [["0bc8cebdb", "9af2f7dc9", "d67d7243f", "d8e7f8149"]], "identity_text": "Use pkg-config, if available, to locate libxml2 during configure (Hugh McMaster, Tom Lane, Peter Eisentraut) If pkg-config is not present or lacks knowledge of libxml2, we still query xml2-config as before. This change could break build processes that try to make PostgreSQL use a non-default version of libxml2 by putting that version's xml2-config into the PATH. Instead, set XML2_CONFIG to point to the non-default xml2-config. That method will work with either older or newer PostgreSQL releases.", "commit_aliases": ["0bc8cebdb", "9af2f7dc9", "d67d7243f", "d8e7f8149"], "source_commits": ["9af2f7dc9"], "source_entry_id": "11.8/changes/051", "db_id": "3cea6693536c03e5221d8a38925dbe51", "patch_ids": ["00c4389a3c7f9457c14ca438fee3fac5"], "statement_hash": "ee2b156e7e1e1b15df48e837ac377373a1c275f020355608adb35ac686b32c96", "relations": [{"rule": 2, "type": "equivalent", "target": "181cf5021acbd4f97607931003f4208e", "evidence": {"same_day": true, "patch_ids": ["00c4389a3c7f9457c14ca438fee3fac5"], "statement_hash": "ee2b156e7e1e1b15df48e837ac377373a1c275f020355608adb35ac686b32c96"}}, {"rule": 2, "type": "equivalent", "target": "3ec98377259244b743c78e96d9e206dd", "evidence": {"same_day": true, "patch_ids": ["00c4389a3c7f9457c14ca438fee3fac5"], "statement_hash": "ee2b156e7e1e1b15df48e837ac377373a1c275f020355608adb35ac686b32c96"}}], "version": "11.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "181cf5021acbd4f97607931003f4208e", "kind": "equivalent", "version": "12.3", "label": "12.3", "title": "在 configure 期间，如果 pkg-config 可用，则使用它定位 libxml2", "evidence": {"same_day": true, "patch_ids": ["00c4389a3c7f9457c14ca438fee3fac5"], "statement_hash": "ee2b156e7e1e1b15df48e837ac377373a1c275f020355608adb35ac686b32c96"}, "url": "/docs/compare/?release=12.3#12.3-8e9633b2cf874d7a", "source_url": "/docs/release/12.3/#id-1.11.6.25.5"}, {"db_id": "3ec98377259244b743c78e96d9e206dd", "kind": "equivalent", "version": "10.13", "label": "10.13", "title": "在 configure 期间，如果 pkg-config 可用，则使用它定位 libxml2", "evidence": {"same_day": true, "patch_ids": ["00c4389a3c7f9457c14ca438fee3fac5"], "statement_hash": "ee2b156e7e1e1b15df48e837ac377373a1c275f020355608adb35ac686b32c96"}, "url": "/docs/compare/?release=10.13#10.13-7b6894a94939304a", "source_url": "/docs/release/10.13/#id-1.11.6.15.5"}]}, {"id": "11.8-bae71a53194d4401", "cves": [], "html": "

在 MSVC 构建中，处理 Python 路径名中的空格（Victor Wagner）

", "text": "在 MSVC 构建中，处理 Python 路径名中的空格（Victor Wagner）", "title": "在 MSVC 构建中，处理 Python 路径名中的空格", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["984aca448"], "source_entry_id": "11.8/changes/052", "db_id": "f75739c9b2331c8ea9fcf7f7d98d7cbf", "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": "e1fc7c47c3f91a87315032845c953520", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}}], "version": "11.8", "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": "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"}, {"db_id": "e1fc7c47c3f91a87315032845c953520", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "在 MSVC 构建中，处理 Python 路径名中的空格", "evidence": {"same_day": true, "patch_ids": ["fe29dc1dae0fde16f1a528a87b647934"], "statement_hash": "4f3a3a43b159b6f290fa7553d5356a5d9e4c32d0ab7519b33471b8188b52d4ac"}, "url": "/docs/compare/?release=9.5.22#9.5.22-bae71a53194d4401", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-ef16d7ba22e8b874", "cves": [], "html": "

在 MSVC 构建中，修复 Visual Studio 版本检测，使其适用于更多语言设置（Andrew Dunstan）

", "text": "在 MSVC 构建中，修复 Visual Studio 版本检测，使其适用于更多语言设置（Andrew Dunstan）", "title": "在 MSVC 构建中，修复 Visual Studio 版本检测，使其适用于更多语言设置", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["758814224"], "source_entry_id": "11.8/changes/053", "db_id": "25f142bd24abd40c480b00e6c18600a0", "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": "1aa28dec243bc3fb9c3f44f7c9e3140e", "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": "11.8", "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": "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"}, {"db_id": "1aa28dec243bc3fb9c3f44f7c9e3140e", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "在 MSVC 构建中，修复 Visual Studio 版本检测以适应更多语言设置", "evidence": {"same_day": true, "patch_ids": ["ac82ac6f720233c45fd83cd116e17de9"], "statement_hash": "05bb21fcc80736a894a41c2b34ca8363926eec3584f4bd5b29711fa15ffd2524"}, "url": "/docs/compare/?release=9.5.22#9.5.22-e45b8263fca24bad", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-c2ad5dd7fb75ff22", "cves": [], "html": "

在 MSVC 构建中，对高于 3.0 的 bison 版本使用 -Wno-deprecated，与非 Windows 构建现有行为一致（Andrew Dunstan）

", "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/11.8/#id-1.11.6.19.5", "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": ["e8a6391fc"], "source_entry_id": "11.8/changes/054", "db_id": "e98154d53927ee357929e6035953a6e2", "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3", "relations": [{"rule": 2, "type": "equivalent", "target": "781b1069e93a5c87fc53cef184cd8e6b", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}}, {"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"}}], "version": "11.8", "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": "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"}, {"db_id": "781b1069e93a5c87fc53cef184cd8e6b", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "在 MSVC 构建中，对 3.0 之后的 bison 版本使用 -Wno-deprecated，与非 Windows 构建已经做的一样", "evidence": {"same_day": true, "patch_ids": ["8207380c85dae25f82a497ab4bd094bc"], "statement_hash": "80e3b843d2469cca0f95cb8d1d9051c31a80127544516155dc2273a85ebbe5e3"}, "url": "/docs/compare/?release=9.5.22#9.5.22-629774e3f0311503", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}, {"id": "11.8-d589194aabb1df08", "cves": [], "html": "

将时区数据文件更新到 tzdata 2020a 版，以反映摩洛哥和加拿大育空地区的夏令时法规变更，并修正上海的历史数据。

\n

America/Godthab 时区已更名为 America/Nuuk，以反映当前英语用法；不过，旧名称仍作为兼容性链接保留。

\n

另外，更新 initdb 的已知 Windows 时区名称列表，纳入最近新增的名称，提高在该平台上正确转换系统时区设置的可能性。

", "text": "将时区数据文件更新到 tzdata 2020a 版，以反映摩洛哥和加拿大育空地区的夏令时法规变更，并修正上海的历史数据。 America/Godthab 时区已更名为 America/Nuuk，以反映当前英语用法；不过，旧名称仍作为兼容性链接保留。 另外，更新 initdb 的已知 Windows 时区名称列表，纳入最近新增的名称，提高在该平台上正确转换系统时区设置的可能性。", "title": "将时区数据文件更新到 tzdata 2020a 版，以反映摩洛哥和加拿大育空地区的夏令时法规变更，并修正上海的历史数据。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.8/#id-1.11.6.19.5", "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": ["99c9ed224", "b31f9fd63", "eb335bc62"], "source_entry_id": "11.8/changes/055", "db_id": "37edc767b610263d920f70cc5dce0d3a", "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4", "relations": [{"rule": 2, "type": "equivalent", "target": "082e3124590e139fbc890ad8e6c1cfbb", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4"}}, {"rule": 2, "type": "equivalent", "target": "0e1d44c5c78b1de1d61e0a2e08ecd487", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"]}}, {"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": "11.8", "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": "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"}, {"db_id": "082e3124590e139fbc890ad8e6c1cfbb", "kind": "equivalent", "version": "9.5.22", "label": "9.5.22", "title": "更新时区数据文件到 tzdata 版本 2020a，涉及摩洛哥和加拿大育空的夏令时法规变更，以及上海的历史修正。", "evidence": {"same_day": true, "patch_ids": ["6b0e2eae73eff06e8b112dc510b6f46c", "a3db554c04faeca515c6443540ba2f98", "dccfdc8741e1af73db4e9ae1b3ee68ea"], "statement_hash": "5944fe8ebe5cd54625bd39c2a888b310be985f439aa5e340c2ead74544fc6ee4"}, "url": "/docs/compare/?release=9.5.22#9.5.22-20f382e14391e21c", "source_url": "/docs/release/9.5.22/#id-1.11.6.8.6"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 55}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 23}, {"key": "security", "label": "安全相关", "count": 0}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 32}], "total": 55, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 55, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}