对于运行 15.X 的用户，不需要执行导出/恢复。
\n不过，如果你在分区表上有自引用外键约束，则可能需要重新创建这些约束，以确保它们得到正确实施。见下文第二条变更记录。
\n此外，如果你有任何 BRIN bloom 索引，建议在更新后对其重建索引。见下文第三条变更记录。
\n此外，如果你从早于 15.9 的版本升级，请参见第 E.11 节。
", "compatibility_count": 0, "label": "15.13", "status_label": "受支持版本", "eol": "2027-11-11", "age_days": 506, "support_days": 411}, "groups": [{"date": "2025-05-08", "build": "15.13", "major": "15", "minor": 13, "manual": "15", "status": "stable", "doc_git": "", "version": "15.13", "eol_date": "2027-11-11", "date_text": "2025-05-08", "supported": true, "manual_url": "/docs/15/release-15-13.html", "source_url": "/docs/release/15.13/", "entry_count": 38, "placeholder": false, "content_hash": "5514e4876673db0bba94785c9918ee49bf168be4a7f89d5bdf51d9c2bdc4f132", "manual_build": "15.19", "source_as_of": "", "changes_count": 38, "doc_loaded_at": "2026-09-26T02:56:38.228564", "migration_html": "对于运行 15.X 的用户，不需要执行导出/恢复。
\n不过，如果你在分区表上有自引用外键约束，则可能需要重新创建这些约束，以确保它们得到正确实施。见下文第二条变更记录。
\n此外，如果你有任何 BRIN bloom 索引，建议在更新后对其重建索引。见下文第三条变更记录。
\n此外，如果你从早于 15.9 的版本升级，请参见第 E.11 节。
", "compatibility_count": 0, "label": "15.13", "status_label": "受支持版本", "eol": "2027-11-11", "age_days": 506, "support_days": 411, "entries": [{"id": "15.13-ac5445ebcc0439eb", "cves": ["CVE-2025-4207"], "html": "避免在检查声称为 GB18030 编码的无效编码字符串时发生单字节缓冲区越界读取（Noah Misch，Andres Freund）§ §
\n虽然可能性不大，但如果不完整的多字节字符出现在内存末尾，可能会导致 SIGSEGV 崩溃。这在服务器和使用 libpq 的应用程序中都可能发生。（CVE-2025-4207）
", "text": "避免在检查声称为 GB18030 编码的无效编码字符串时发生单字节缓冲区越界读取（Noah Misch，Andres Freund）§ § 虽然可能性不大，但如果不完整的多字节字符出现在内存末尾，可能会导致 SIGSEGV 崩溃。这在服务器和使用 libpq 的应用程序中都可能发生。（CVE-2025-4207）", "title": "避免在检查声称为 GB18030 编码的无效编码字符串时发生单字节缓冲区越界读取", "commits": ["44ba3f55f", "45fe7e08f"], "section": "变更", "category": "security", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "2367faba22c985bfdffaa6c16f365c3c6b4b0669603a5c51cf484a5013f55c69", "section_path": ["变更"], "commit_groups": [["258cde839", "45fe7e08f", "5be213caa", "617d34908", "7279e5820", "f3bb0b2c4"], ["3f2ab7393", "44ba3f55f", "627acc3ca", "cbadeaca9", "d1264948f", "ec5f89e8a"]], "identity_text": "Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding (Noah Misch, Andres Freund) While unlikely, a SIGSEGV crash could occur if an incomplete multibyte character appeared at the end of memory. This was possible both in the server and in libpq-using applications. (CVE-2025-4207)", "commit_aliases": ["258cde839", "3f2ab7393", "44ba3f55f", "45fe7e08f", "5be213caa", "617d34908", "627acc3ca", "7279e5820", "cbadeaca9", "d1264948f", "ec5f89e8a", "f3bb0b2c4"], "source_commits": ["44ba3f55f", "45fe7e08f"], "source_entry_id": "15.13/changes/001", "db_id": "324c2d77afbaedc0b35dc9fa474e1a3c", "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af", "relations": [{"rule": 2, "type": "equivalent", "target": "52b291d40b26e80bfcbda168216ed19c", "evidence": {"same_day": true, "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"}}, {"rule": 2, "type": "equivalent", "target": "90816d8cb748849f968f5acd56673365", "evidence": {"same_day": true, "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"}}, {"rule": 2, "type": "equivalent", "target": "b709e1b3e9d8624be870988b036fd152", "evidence": {"same_day": true, "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"}}, {"rule": 2, "type": "equivalent", "target": "dd8842462b8fd9529571acc51a1f45c1", "evidence": {"same_day": true, "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"}}], "version": "15.13", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "b709e1b3e9d8624be870988b036fd152", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "避免在检查声称为 GB18030 编码的无效编码字符串时发生单字节缓冲区越界读取", "evidence": {"same_day": true, "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"}, "url": "/docs/compare/?release=17.5#17.5-811aed0b2b3689f8", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "52b291d40b26e80bfcbda168216ed19c", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "避免在检查声称为 GB18030 编码的无效编码字符串时发生单字节缓冲区越界读取", "evidence": {"same_day": true, "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"}, "url": "/docs/compare/?release=16.9#16.9-9333e72b42f314f4", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "dd8842462b8fd9529571acc51a1f45c1", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "避免在检查声称为 GB18030 编码的无效编码字符串时发生单字节缓冲区越界读取", "evidence": {"same_day": true, "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"}, "url": "/docs/compare/?release=14.18#14.18-e7c0d482f98a0ba1", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "90816d8cb748849f968f5acd56673365", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "避免在检查声称为 GB18030 编码的无效编码字符串时发生单字节缓冲区越界读取", "evidence": {"same_day": true, "patch_ids": ["46c8bf47167ab191e3280201c2564861", "76df84f28287d373c8422ff9fd4dc342"], "statement_hash": "de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"}, "url": "/docs/compare/?release=13.21#13.21-bc601768f2de7a35", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-0a90d92fac91acc0", "cves": [], "html": "正确处理分区表上的自引用外键（Álvaro Herrera）§
\n创建或附加分区时未能为外键约束创建所需的目录条目，如果该约束引用的表就是同一个分区表。这会导致该约束无法被完全执行。
\n要修复此问题，如果在约束创建之后曾创建或附加过分区，则应删除并重新创建分区表上的任何自引用外键。请注意，可能已经存在违反约束的行，在这种情况下重新创建约束会失败，你需要先修复这些行后再重试。
", "text": "正确处理分区表上的自引用外键（Álvaro Herrera）§ 创建或附加分区时未能为外键约束创建所需的目录条目，如果该约束引用的表就是同一个分区表。这会导致该约束无法被完全执行。 要修复此问题，如果在约束创建之后曾创建或附加过分区，则应删除并重新创建分区表上的任何自引用外键。请注意，可能已经存在违反约束的行，在这种情况下重新创建约束会失败，你需要先修复这些行后再重试。", "title": "正确处理分区表上的自引用外键", "commits": ["6ba979cf5"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "508b5fc58577b5508afc23c50dd5a19a472515e22f3f38c2b13d011cdc27a402", "section_path": ["变更"], "commit_groups": [["1649d153a", "1817d62ec", "6ba979cf5", "b3a9c536d", "c83a38758", "f51ae3187"]], "identity_text": "Handle self-referential foreign keys on partitioned tables correctly (Álvaro Herrera) Creating or attaching partitions failed to make the required catalog entries for a foreign-key constraint, if the table referenced by the constraint was the same partitioned table. This resulted in failure to enforce the constraint fully. To fix this, you should drop and recreate any self-referential foreign keys on partitioned tables, if partitions have been created or attached since the constraint was created. Bear in mind that violating rows might already be present, in which case recreating the constraint will fail, and you'll need to fix up those rows before trying again.", "commit_aliases": ["1649d153a", "1817d62ec", "6ba979cf5", "b3a9c536d", "c83a38758", "f51ae3187"], "source_commits": ["6ba979cf5"], "source_entry_id": "15.13/changes/002", "db_id": "80e3cc10f3858300ca77df2904c1925d", "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03", "relations": [{"rule": 2, "type": "equivalent", "target": "00a212cca3e46b43408a50bfb3f001a2", "evidence": {"same_day": true, "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"}}, {"rule": 2, "type": "equivalent", "target": "1597348d9b84b108c65df5a25ccdad57", "evidence": {"same_day": true, "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"}}, {"rule": 2, "type": "equivalent", "target": "2e82178a9bafbe73cfec49a0a0c3913b", "evidence": {"same_day": true, "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"}}, {"rule": 2, "type": "equivalent", "target": "74b0b653fc4b7867d9664b6f47e83cf2", "evidence": {"same_day": true, "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "74b0b653fc4b7867d9664b6f47e83cf2", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "正确处理分区表上的自引用外键", "evidence": {"same_day": true, "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"}, "url": "/docs/compare/?release=17.5#17.5-33e46d9a26056cb4", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "2e82178a9bafbe73cfec49a0a0c3913b", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "正确处理分区表上的自引用外键", "evidence": {"same_day": true, "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"}, "url": "/docs/compare/?release=16.9#16.9-957bda7d3c81adad", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "00a212cca3e46b43408a50bfb3f001a2", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "正确处理分区表上的自引用外键", "evidence": {"same_day": true, "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"}, "url": "/docs/compare/?release=14.18#14.18-8508a57f7675f008", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "1597348d9b84b108c65df5a25ccdad57", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "正确处理分区表上的自引用外键", "evidence": {"same_day": true, "patch_ids": ["ad242ea23eebb0296f36fddb8b8111c0"], "statement_hash": "0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"}, "url": "/docs/compare/?release=13.21#13.21-5dfcd8e50f9f1cd7", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-32fb0ac8af362319", "cves": [], "html": "避免在 brin_bloom_union() 中合并压缩的 BRIN 摘要时丢失数据（Tomas Vondra）§
该代码未能考虑到解压缩结果与输入对象不完全相同的情况，这会导致未能将部分数据添加到合并后的摘要中，从而在索引搜索中遗漏行。
\n这个错误从引入 BRIN bloom 索引的 v14 就存在了，但当时这个代码路径很少被触及。在 v17 中由于并行索引构建现在使用了该代码，因此更容易被触发。
", "text": "避免在 brin_bloom_union() 中合并压缩的 BRIN 摘要时丢失数据（Tomas Vondra）§ 该代码未能考虑到解压缩结果与输入对象不完全相同的情况，这会导致未能将部分数据添加到合并后的摘要中，从而在索引搜索中遗漏行。 这个错误从引入 BRIN bloom 索引的 v14 就存在了，但当时这个代码路径很少被触及。在 v17 中由于并行索引构建现在使用了该代码，因此更容易被触发。", "title": "避免在 brin_bloom_union() 中合并压缩的 BRIN 摘要时丢失数据", "commits": ["e064b770c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "b5a564807598efe2cfa2989815f51c770515df2183e40bed90a618228df15647", "section_path": ["变更"], "commit_groups": [["6be02bbc8", "818245506", "cb0ad70b8", "e064b770c", "ebcc799a7"]], "identity_text": "Avoid data loss when merging compressed BRIN summaries in brin_bloom_union() (Tomas Vondra) The code failed to account for decompression results not being identical to the input objects, which would result in failure to add some of the data to the merged summary, leading to missed rows in index searches. This mistake was present back to v14 where BRIN bloom indexes were introduced, but this code path was only rarely reached then. It's substantially more likely to be hit in v17 because parallel index builds now use the code.", "commit_aliases": ["6be02bbc8", "818245506", "cb0ad70b8", "e064b770c", "ebcc799a7"], "source_commits": ["e064b770c"], "source_entry_id": "15.13/changes/003", "db_id": "3a11ecf5fadca551924c452d89cfd2ae", "patch_ids": ["e7679010570c027f03bd2cfeabb18277"], "statement_hash": "4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609", "relations": [{"rule": 2, "type": "equivalent", "target": "4843f13cf3d1c267a1482aff53d43829", "evidence": {"same_day": true, "patch_ids": ["e7679010570c027f03bd2cfeabb18277"], "statement_hash": "4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"}}, {"rule": 2, "type": "equivalent", "target": "485bff3c834029add3cd04127b9baf3b", "evidence": {"same_day": true, "patch_ids": ["e7679010570c027f03bd2cfeabb18277"], "statement_hash": "4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"}}, {"rule": 2, "type": "equivalent", "target": "bbe2be1a596ba923c5a319334510b4f8", "evidence": {"same_day": true, "patch_ids": ["e7679010570c027f03bd2cfeabb18277"], "statement_hash": "4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "485bff3c834029add3cd04127b9baf3b", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "避免在 brin_bloom_union() 中合并压缩的 BRIN 摘要时丢失数据", "evidence": {"same_day": true, "patch_ids": ["e7679010570c027f03bd2cfeabb18277"], "statement_hash": "4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"}, "url": "/docs/compare/?release=17.5#17.5-713c7047a302325a", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "4843f13cf3d1c267a1482aff53d43829", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "避免在 brin_bloom_union() 中合并压缩的 BRIN 摘要时丢失数据", "evidence": {"same_day": true, "patch_ids": ["e7679010570c027f03bd2cfeabb18277"], "statement_hash": "4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"}, "url": "/docs/compare/?release=16.9#16.9-00a18a3ddf7896ba", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "bbe2be1a596ba923c5a319334510b4f8", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "避免在 brin_bloom_union() 中合并压缩的 BRIN 摘要时丢失数据", "evidence": {"same_day": true, "patch_ids": ["e7679010570c027f03bd2cfeabb18277"], "statement_hash": "4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"}, "url": "/docs/compare/?release=14.18#14.18-f538b53a2f7f69ca", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}]}, {"id": "15.13-77004cecd223761f", "cves": [], "html": "修复在 UPDATE、DELETE 和 MERGE 查询中使用对视图或函数的整行表引用（在 FROM 中）时出现的意外 “attribute has wrong type” 错误（Tom Lane）§ § §
修复对带有 DO NOTHING 动作的分区表执行 MERGE 的问题（Tender Wang）§
某些情况会出现 “unknown action in MERGE WHEN clause” 错误。
", "text": "修复对带有 DO NOTHING 动作的分区表执行 MERGE 的问题（Tender Wang）§ 某些情况会出现 “unknown action in MERGE WHEN clause” 错误。", "title": "修复对带有 DO NOTHING 动作的分区表执行 MERGE 的问题", "commits": ["14a33d3f0"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "cb23be2662d950ee42c98e97b047972ba6b8a1976e419621080274287bb702be", "section_path": ["变更"], "commit_groups": [["14a33d3f0", "25303678a", "8b6a0e239", "8d4cd3b4a"]], "identity_text": "Fix MERGE into a partitioned table with DO NOTHING actions (Tender Wang) Some cases failed with unknown action in MERGE WHEN clause errors.", "commit_aliases": ["14a33d3f0", "25303678a", "8b6a0e239", "8d4cd3b4a"], "source_commits": ["14a33d3f0"], "source_entry_id": "15.13/changes/005", "db_id": "62735bf2bbcc5084c2a05ae3d376af22", "patch_ids": ["513aa4deebdf3df8839bb06bae87b2de"], "statement_hash": "5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532", "relations": [{"rule": 2, "type": "equivalent", "target": "52e2c1747d54581c28441d3730cd211c", "evidence": {"same_day": true, "patch_ids": ["513aa4deebdf3df8839bb06bae87b2de"], "statement_hash": "5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532"}}, {"rule": 2, "type": "equivalent", "target": "86af16fcd8c6b4a784b7476a3d942894", "evidence": {"same_day": true, "patch_ids": ["513aa4deebdf3df8839bb06bae87b2de"], "statement_hash": "5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532"}}], "version": "15.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "86af16fcd8c6b4a784b7476a3d942894", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "修复对带有 DO NOTHING 动作的分区表执行 MERGE 的问题", "evidence": {"same_day": true, "patch_ids": ["513aa4deebdf3df8839bb06bae87b2de"], "statement_hash": "5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532"}, "url": "/docs/compare/?release=17.5#17.5-fb1ef27e6ad12133", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "52e2c1747d54581c28441d3730cd211c", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "修复对带有 DO NOTHING 动作的分区表执行 MERGE 的问题", "evidence": {"same_day": true, "patch_ids": ["513aa4deebdf3df8839bb06bae87b2de"], "statement_hash": "5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532"}, "url": "/docs/compare/?release=16.9#16.9-e85808310d3df6a7", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}]}, {"id": "15.13-dc64f1cefed2c049", "cves": [], "html": "防止当表具有域数据类型的 GENERATED 列且该域的约束不允许空值时 INSERT 命令失败的问题（Jian He）§
即使生成表达式产生了完全正常的结果，仍会报告约束违反错误。
", "text": "防止当表具有域数据类型的 GENERATED 列且该域的约束不允许空值时 INSERT 命令失败的问题（Jian He）§ 即使生成表达式产生了完全正常的结果，仍会报告约束违反错误。", "title": "防止当表具有域数据类型的 GENERATED 列且该域的约束不允许空值时 INSERT 命令失败的问题", "commits": ["97d671672"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "945f5d2553ed524155db529f3a0bbfb16a0fe68d4e3261df7c5501175b50bc12", "section_path": ["变更"], "commit_groups": [["3c39c000c", "4604928ed", "7c8728494", "97d671672", "f04e0faa3"]], "identity_text": "Prevent failure in INSERT commands when the table has a GENERATED column of a domain data type and the domain's constraints disallow null values (Jian He) Constraint failure was reported even if the generation expression produced a perfectly okay result.", "commit_aliases": ["3c39c000c", "4604928ed", "7c8728494", "97d671672", "f04e0faa3"], "source_commits": ["97d671672"], "source_entry_id": "15.13/changes/006", "db_id": "90be6e04fee2db08987030dda7e61c1c", "patch_ids": ["511a283a7a0968a300bcd6f1f483561c"], "statement_hash": "b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1", "relations": [{"rule": 2, "type": "equivalent", "target": "1abab24628ec9d80474ca478204b54b6", "evidence": {"same_day": true, "patch_ids": ["511a283a7a0968a300bcd6f1f483561c"], "statement_hash": "b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"}}, {"rule": 2, "type": "equivalent", "target": "9968353971b2d90aabe2974ce8ca0b17", "evidence": {"same_day": true, "patch_ids": ["511a283a7a0968a300bcd6f1f483561c"], "statement_hash": "b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"}}, {"rule": 2, "type": "equivalent", "target": "a4bb8d60d9ad06081b90421ad2dae048", "evidence": {"same_day": true, "patch_ids": ["511a283a7a0968a300bcd6f1f483561c"], "statement_hash": "b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "a4bb8d60d9ad06081b90421ad2dae048", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "防止当表具有域数据类型的 GENERATED 列且该域的约束不允许空值时 INSERT 命令失败的问题", "evidence": {"same_day": true, "patch_ids": ["511a283a7a0968a300bcd6f1f483561c"], "statement_hash": "b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"}, "url": "/docs/compare/?release=17.5#17.5-6526003e508c4382", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "1abab24628ec9d80474ca478204b54b6", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "防止当表具有域数据类型的 GENERATED 列且该域的约束不允许空值时 INSERT 命令失败的问题", "evidence": {"same_day": true, "patch_ids": ["511a283a7a0968a300bcd6f1f483561c"], "statement_hash": "b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"}, "url": "/docs/compare/?release=16.9#16.9-9a8a93e856ab5a0d", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "9968353971b2d90aabe2974ce8ca0b17", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "防止当表具有域数据类型的 GENERATED 列且该域的约束不允许空值时 INSERT 命令失败的问题", "evidence": {"same_day": true, "patch_ids": ["511a283a7a0968a300bcd6f1f483561c"], "statement_hash": "b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"}, "url": "/docs/compare/?release=14.18#14.18-0db2ae0d4a6db748", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}]}, {"id": "15.13-f4e8b698cacd5fe8", "cves": [], "html": "正确处理出现在附加到 INSERT/UPDATE/DELETE/MERGE 命令（该命令本身在 WITH 内部）的 WITH 子句中对外部 CTE 名称的引用（Tom Lane）§
解析器未能检测到不允许的递归情况，也未能在将 CTE 排列为可用顺序时考虑此类引用。
", "text": "正确处理出现在附加到 INSERT/UPDATE/DELETE/MERGE 命令（该命令本身在 WITH 内部）的 WITH 子句中对外部 CTE 名称的引用（Tom Lane）§ 解析器未能检测到不允许的递归情况，也未能在将 CTE 排列为可用顺序时考虑此类引用。", "title": "正确处理出现在附加到 INSERT/UPDATE/DELETE/MERGE 命令（该命令本身在 WITH 内部）的 WITH 子句中对外部 CTE 名称的引用", "commits": ["ede29a1e4"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "73e77453389fcf3caf2b58b3839a1f143e128d7a7b98055250f0dfb3d4e8319a", "section_path": ["变更"], "commit_groups": [["1980ec2bc", "5e7be43f4", "691836405", "754a3d82d", "e276b5829", "ede29a1e4"]], "identity_text": "Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH (Tom Lane) The parser failed to detect disallowed recursion cases, nor did it account for such references when sorting CTEs into a usable order.", "commit_aliases": ["1980ec2bc", "5e7be43f4", "691836405", "754a3d82d", "e276b5829", "ede29a1e4"], "source_commits": ["ede29a1e4"], "source_entry_id": "15.13/changes/007", "db_id": "f6ef109aaf444cf2a6cefa7c247f050b", "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096", "relations": [{"rule": 2, "type": "equivalent", "target": "43ef4362d82abd89c632923c19c63abe", "evidence": {"same_day": true, "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"}}, {"rule": 2, "type": "equivalent", "target": "4e1153d84247e7968ad2cf656d1b8054", "evidence": {"same_day": true, "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"}}, {"rule": 2, "type": "equivalent", "target": "7b32eae49c92985982175f39b0e0cd4e", "evidence": {"same_day": true, "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"}}, {"rule": 2, "type": "equivalent", "target": "fe87096f3ff10f413ee4fd00bc85e2d2", "evidence": {"same_day": true, "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "fe87096f3ff10f413ee4fd00bc85e2d2", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "正确处理出现在附加到 INSERT/UPDATE/DELETE/MERGE 命令（该命令本身在 WITH 内部）的 WITH 子句中对外部 CTE 名称的引用", "evidence": {"same_day": true, "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"}, "url": "/docs/compare/?release=17.5#17.5-b36cfca9c709aa6d", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "7b32eae49c92985982175f39b0e0cd4e", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "正确处理出现在附加到 INSERT/UPDATE/DELETE/MERGE 命令（该命令本身在 WITH 内部）的 WITH 子句中对外部 CTE 名称的引用", "evidence": {"same_day": true, "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"}, "url": "/docs/compare/?release=16.9#16.9-a8bff3d57a355b2b", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "43ef4362d82abd89c632923c19c63abe", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "正确处理出现在附加到 INSERT/UPDATE/DELETE/MERGE 命令（该命令本身在 WITH 内部）的 WITH 子句中对外部 CTE 名称的引用", "evidence": {"same_day": true, "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"}, "url": "/docs/compare/?release=14.18#14.18-1dfb1187293403b9", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "4e1153d84247e7968ad2cf656d1b8054", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "正确处理出现在附加到 INSERT/UPDATE/DELETE/MERGE 命令（该命令本身在 WITH 内部）的 WITH 子句中对外部 CTE 名称的引用", "evidence": {"same_day": true, "patch_ids": ["d1ef004bfb3ff87f530f4c58b02fe0f0"], "statement_hash": "bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"}, "url": "/docs/compare/?release=13.21#13.21-a47f4cde204a1376", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-c6423740dd58b9c5", "cves": [], "html": "修复 ARRAY( 和 subquery)ARRAY[ 构造，使其在输入类型为 expression, ...]int2vector 或 oidvector 时产生合理的结果（Tom Lane）§
此补丁恢复了 PostgreSQL 9.5 之前的行为：结果类型为 int2vector[] 或 oidvector[]。
修复解析 Ispell 字典时可能错误报告无效词缀的问题（Jacob Brazeal）§
", "text": "修复解析 Ispell 字典时可能错误报告无效词缀的问题（Jacob Brazeal）§", "title": "修复解析 Ispell 字典时可能错误报告无效词缀的问题", "commits": ["e2921c0e9"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "7757c24cb916641ca1e4124f4c1d5e1765bb45982ca7ba37aa0de68731701c42", "section_path": ["变更"], "commit_groups": [["61513da08", "7fb880102", "99c01aadf", "da85544ae", "e2921c0e9", "f1c1bafcd"]], "identity_text": "Fix possible erroneous reports of invalid affixes while parsing Ispell dictionaries (Jacob Brazeal)", "commit_aliases": ["61513da08", "7fb880102", "99c01aadf", "da85544ae", "e2921c0e9", "f1c1bafcd"], "source_commits": ["e2921c0e9"], "source_entry_id": "15.13/changes/009", "db_id": "2d395b5defef434bec7ea4da45b42ad7", "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666", "relations": [{"rule": 2, "type": "equivalent", "target": "8937ea7c9fd026836a5c262c8569963e", "evidence": {"same_day": true, "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"}}, {"rule": 2, "type": "equivalent", "target": "8d306975e4b0a9c39e7fff8c8ad3613e", "evidence": {"same_day": true, "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"}}, {"rule": 2, "type": "equivalent", "target": "b921604055772bbf7e6449d7cc0b59cc", "evidence": {"same_day": true, "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"}}, {"rule": 2, "type": "equivalent", "target": "eb58cef266f21c9edb703764403f7168", "evidence": {"same_day": true, "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"}}], "version": "15.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b921604055772bbf7e6449d7cc0b59cc", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "修复解析 Ispell 字典时可能错误报告无效词缀的问题", "evidence": {"same_day": true, "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"}, "url": "/docs/compare/?release=17.5#17.5-d1d934652e8cc19f", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "8937ea7c9fd026836a5c262c8569963e", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "修复解析 Ispell 字典时可能错误报告无效词缀的问题", "evidence": {"same_day": true, "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"}, "url": "/docs/compare/?release=16.9#16.9-120195bfc62f85d9", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "8d306975e4b0a9c39e7fff8c8ad3613e", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "修复解析 Ispell 字典时可能错误报告无效词缀的问题", "evidence": {"same_day": true, "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"}, "url": "/docs/compare/?release=14.18#14.18-60d7303621919c68", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "eb58cef266f21c9edb703764403f7168", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "修复解析 Ispell 字典时可能错误报告无效词缀的问题", "evidence": {"same_day": true, "patch_ids": ["f2484a0ea37309c0a083683b6f24f404"], "statement_hash": "a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"}, "url": "/docs/compare/?release=13.21#13.21-c84be53354aebbd7", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-15397e28cacbb50b", "cves": [], "html": "修复 ALTER TABLE ADD COLUMN 以正确处理具有默认值的域类型的情况（Jian He，Tom Lane，Tender Wang）§ §
如果域类型具有默认值，在不带显式 DEFAULT 子句的情况下添加该类型的列，未能在现有行中安装域的默认值，而是将新列保留为空值。
修复外键约束的 ON DELETE SET DEFAULT 或 SET NULL 动作中存在重复列名时的异常行为（Tom Lane）§
改进对不允许的外键约束属性修改尝试的错误消息（Álvaro Herrera）§
", "text": "改进对不允许的外键约束属性修改尝试的错误消息（Álvaro Herrera）§", "title": "改进对不允许的外键约束属性修改尝试的错误消息", "commits": ["bf1e2d2db"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "ddafe2e255ca48dca80bbcc403c765d2cd82acec5f9dcae5c2e68a35ae74ee66", "section_path": ["变更"], "commit_groups": [["0f354e080", "4e026be5f", "7bbc46213", "931a1c023", "9ea5fe5b6", "bf1e2d2db"]], "identity_text": "Improve the error message for disallowed attempts to alter the properties of a foreign key constraint (Álvaro Herrera)", "commit_aliases": ["0f354e080", "4e026be5f", "7bbc46213", "931a1c023", "9ea5fe5b6", "bf1e2d2db"], "source_commits": ["bf1e2d2db"], "source_entry_id": "15.13/changes/012", "db_id": "dfe47a550f472aa86b315fdfc03d4aa5", "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e", "relations": [{"rule": 2, "type": "equivalent", "target": "0b9e876fbe15368f7eb3e73dd5bde6fd", "evidence": {"same_day": true, "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"}}, {"rule": 2, "type": "equivalent", "target": "0d1236e87dc3b61c47a965fdf13a3b6e", "evidence": {"same_day": true, "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"}}, {"rule": 2, "type": "equivalent", "target": "5627f1c1d8a4f69c29448aee864c6b84", "evidence": {"same_day": true, "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"}}, {"rule": 2, "type": "equivalent", "target": "c85aaec4454f3f6c178e25e80fc110f7", "evidence": {"same_day": true, "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "c85aaec4454f3f6c178e25e80fc110f7", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "改进对不允许的外键约束属性修改尝试的错误消息", "evidence": {"same_day": true, "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"}, "url": "/docs/compare/?release=17.5#17.5-4a57902eda945b83", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "5627f1c1d8a4f69c29448aee864c6b84", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "改进对不允许的外键约束属性修改尝试的错误消息", "evidence": {"same_day": true, "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"}, "url": "/docs/compare/?release=16.9#16.9-d72b0590a5240169", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "0b9e876fbe15368f7eb3e73dd5bde6fd", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "改进对不允许的外键约束属性修改尝试的错误消息", "evidence": {"same_day": true, "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"}, "url": "/docs/compare/?release=14.18#14.18-c2054eb401976a11", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "0d1236e87dc3b61c47a965fdf13a3b6e", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "改进对不允许的外键约束属性修改尝试的错误消息", "evidence": {"same_day": true, "patch_ids": ["728bdeda1a76ff257ed4bba316259080"], "statement_hash": "69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"}, "url": "/docs/compare/?release=13.21#13.21-5056a890e5317fea", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-aeab43b9af8c9591", "cves": [], "html": "避免在重置标记为 ON COMMIT DELETE ROWS 的临时表的 relhassubclass 标志时出错（Noah Misch）§
修复规划器在顶层表达式中无法识别多个可进行 hash 运算的 ScalarArrayOpExpr 子表达式的问题（David Geier）§
\n这导致了本可以用 hash 表处理的额外子表达式（即右侧全为常量的 IN、NOT IN 或 = ANY 子句）执行效率不必要地低下。
禁用位图堆扫描中的“跳过获取”优化（Matthias van de Meent）§
\n事实证明，当并发 vacuum 将页面标记为全部可见时，此优化可能会返回死元组。
", "text": "禁用位图堆扫描中的“跳过获取”优化（Matthias van de Meent）§ 事实证明，当并发 vacuum 将页面标记为全部可见时，此优化可能会返回死元组。", "title": "禁用位图堆扫描中的“跳过获取”优化", "commits": ["77d90d6d6"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "70ccffaea25e101ebc58df9d80425f09bbc98c6e67af9589a6a5cf18b3b5a09a", "section_path": ["变更"], "commit_groups": [["459e7bf8e", "4934d3875", "77d90d6d6", "78cb2466f", "980727b84", "b9ec8125d"]], "identity_text": "Disable skip fetch optimization in bitmap heap scan (Matthias van de Meent) It turns out that this optimization can result in returning dead tuples when a concurrent vacuum marks a page all-visible.", "commit_aliases": ["459e7bf8e", "4934d3875", "77d90d6d6", "78cb2466f", "980727b84", "b9ec8125d"], "source_commits": ["77d90d6d6"], "source_entry_id": "15.13/changes/015", "db_id": "fac79d43b3a211db66f6f7439608ee0d", "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67", "relations": [{"rule": 2, "type": "equivalent", "target": "5b84c530a1833db604577188570826f0", "evidence": {"same_day": true, "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"}}, {"rule": 2, "type": "equivalent", "target": "623c2024106007645fec5d71fb5712bb", "evidence": {"same_day": true, "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"}}, {"rule": 2, "type": "equivalent", "target": "aad339e7e9006b00a0a084b4f930d309", "evidence": {"same_day": true, "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"}}, {"rule": 2, "type": "equivalent", "target": "b694546a946a05eab3a70dbe84ca5802", "evidence": {"same_day": true, "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "623c2024106007645fec5d71fb5712bb", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "禁用位图堆扫描中的“跳过获取”优化", "evidence": {"same_day": true, "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"}, "url": "/docs/compare/?release=17.5#17.5-d0e0aee72000234f", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "b694546a946a05eab3a70dbe84ca5802", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "禁用位图堆扫描中的“跳过获取”优化", "evidence": {"same_day": true, "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"}, "url": "/docs/compare/?release=16.9#16.9-ec226192f4ec4117", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "5b84c530a1833db604577188570826f0", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "禁用位图堆扫描中的“跳过获取”优化", "evidence": {"same_day": true, "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"}, "url": "/docs/compare/?release=14.18#14.18-7fee35a12ed31c20", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "aad339e7e9006b00a0a084b4f930d309", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "禁用位图堆扫描中的“跳过获取”优化", "evidence": {"same_day": true, "patch_ids": ["24bd9f8c7d1c77a2c13ebf151d4f8c78"], "statement_hash": "8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"}, "url": "/docs/compare/?release=13.21#13.21-a23918277d20303c", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-2d5e284461370519", "cves": [], "html": "修复存在大量搜索键时 GIN 索引搜索启动的性能问题（Tom Lane，Vinod Sridharan）§ §
\n具有大量键的可索引子句（例如，jsonbcol ?| array[...] 包含数万个数组元素）启动时需要 O(N2) 的时间，并且在此期间也无法被取消。
检测 BRIN 索引操作符类中缺失的支持函数，并报告错误而不是崩溃（Álvaro Herrera）§
", "text": "检测 BRIN 索引操作符类中缺失的支持函数，并报告错误而不是崩溃（Álvaro Herrera）§", "title": "检测 BRIN 索引操作符类中缺失的支持函数，并报告错误而不是崩溃", "commits": ["5d8c58800"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "4179ab0adf5850e4626920f1cf35e3db3f2c5b3f5c43e9341eff28fc8856fc4d", "section_path": ["变更"], "commit_groups": [["17ce344f8", "5144e1f8f", "5d8c58800", "ade976f8b", "e0d8f49a3", "f5b4a0b49"]], "identity_text": "Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing (Álvaro Herrera)", "commit_aliases": ["17ce344f8", "5144e1f8f", "5d8c58800", "ade976f8b", "e0d8f49a3", "f5b4a0b49"], "source_commits": ["5d8c58800"], "source_entry_id": "15.13/changes/017", "db_id": "52095fe055fa798df8e06d9733eeeee4", "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276", "relations": [{"rule": 2, "type": "equivalent", "target": "07795445e3fa35543669ce4ac06e9c03", "evidence": {"same_day": true, "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"}}, {"rule": 2, "type": "equivalent", "target": "5013f22cc83ed83185fae40ec6f85d0c", "evidence": {"same_day": true, "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"}}, {"rule": 2, "type": "equivalent", "target": "5267301b9758c9e418c0bd305338d9d1", "evidence": {"same_day": true, "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"}}, {"rule": 2, "type": "equivalent", "target": "81a8c631d535b28a942e5afb558c8727", "evidence": {"same_day": true, "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "5267301b9758c9e418c0bd305338d9d1", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "检测 BRIN 索引操作符类中缺失的支持函数，并报告错误而不是崩溃", "evidence": {"same_day": true, "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"}, "url": "/docs/compare/?release=17.5#17.5-71d6a890dc54737c", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "81a8c631d535b28a942e5afb558c8727", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "检测 BRIN 索引操作符类中缺失的支持函数，并报告错误而不是崩溃", "evidence": {"same_day": true, "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"}, "url": "/docs/compare/?release=16.9#16.9-d751d04da9ab2a78", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "07795445e3fa35543669ce4ac06e9c03", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "检测 BRIN 索引操作符类中缺失的支持函数，并报告错误而不是崩溃", "evidence": {"same_day": true, "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"}, "url": "/docs/compare/?release=14.18#14.18-c82d8eee5284ac1f", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "5013f22cc83ed83185fae40ec6f85d0c", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "检测 BRIN 索引操作符类中缺失的支持函数，并报告错误而不是崩溃", "evidence": {"same_day": true, "patch_ids": ["a6ad3f27f4898d4cf7e1f8d5714f4623"], "statement_hash": "434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"}, "url": "/docs/compare/?release=13.21#13.21-96cb58bb59f0ca93", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-e2829c92cb9c1878", "cves": [], "html": "在等待 Append 计划节点的异步子计划时响应中断（如查询取消）（Heikki Linnakangas）§
\n之前，在某个子计划就绪之前不会发生任何事情。
", "text": "在等待 Append 计划节点的异步子计划时响应中断（如查询取消）（Heikki Linnakangas）§ 之前，在某个子计划就绪之前不会发生任何事情。", "title": "在等待 Append 计划节点的异步子计划时响应中断（如查询取消）", "commits": ["d4d34c08c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "ca6c901eaf0edc0cfa0fef4da97d3f0f4bc0773b1c011c8ce8c64a107168f7d5", "section_path": ["变更"], "commit_groups": [["004dbbd72", "af717317a", "d2fb076be", "d4d34c08c", "e731e9d5e"]], "identity_text": "Respond to interrupts (such as query cancel) while waiting for asynchronous subplans of an Append plan node (Heikki Linnakangas) Previously, nothing would happen until one of the subplans becomes ready.", "commit_aliases": ["004dbbd72", "af717317a", "d2fb076be", "d4d34c08c", "e731e9d5e"], "source_commits": ["d4d34c08c"], "source_entry_id": "15.13/changes/018", "db_id": "f65f31a24c7b824da5419e0fce1173eb", "patch_ids": ["c064a1921c86b2d8f990d5d2c678cf3f"], "statement_hash": "f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3", "relations": [{"rule": 2, "type": "equivalent", "target": "266ac90fa5b9b2152af01edeb08fb5b7", "evidence": {"same_day": true, "patch_ids": ["c064a1921c86b2d8f990d5d2c678cf3f"], "statement_hash": "f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"}}, {"rule": 2, "type": "equivalent", "target": "bc6275afdb9fe4237e597f5a8a0f7d1e", "evidence": {"same_day": true, "patch_ids": ["c064a1921c86b2d8f990d5d2c678cf3f"], "statement_hash": "f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"}}, {"rule": 2, "type": "equivalent", "target": "f96c8bb00838600eb0266dddb8c5497e", "evidence": {"same_day": true, "patch_ids": ["c064a1921c86b2d8f990d5d2c678cf3f"], "statement_hash": "f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "bc6275afdb9fe4237e597f5a8a0f7d1e", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "在等待 Append 计划节点的异步子计划时响应中断（如查询取消）", "evidence": {"same_day": true, "patch_ids": ["c064a1921c86b2d8f990d5d2c678cf3f"], "statement_hash": "f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"}, "url": "/docs/compare/?release=17.5#17.5-3b760fb385f5b7f6", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "266ac90fa5b9b2152af01edeb08fb5b7", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "在等待 Append 计划节点的异步子计划时响应中断（如查询取消）", "evidence": {"same_day": true, "patch_ids": ["c064a1921c86b2d8f990d5d2c678cf3f"], "statement_hash": "f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"}, "url": "/docs/compare/?release=16.9#16.9-43771120e2df4821", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "f96c8bb00838600eb0266dddb8c5497e", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "在等待 Append 计划节点的异步子计划时响应中断（如查询取消）", "evidence": {"same_day": true, "patch_ids": ["c064a1921c86b2d8f990d5d2c678cf3f"], "statement_hash": "f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"}, "url": "/docs/compare/?release=14.18#14.18-ebb42881c8090b7d", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}]}, {"id": "15.13-bcea9256969a7e79", "cves": [], "html": "修复启动后立即处理 synchronous_standby_names 时的竞态条件（Melnikov Maksim，Michael Paquier）§
在系统启动后的短暂时间内，即使 synchronous_standby_names 已启用，后端可能也不会等待同步提交。
修复 pg_strtof() 在空 endptr 时崩溃的问题（Alexander Lakhin，Tom Lane）§
避免在 Snowball 词干提取器遇到内存不足条件时崩溃（Maksim Korotkov）§
", "text": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃（Maksim Korotkov）§", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "commits": ["9c46d902b"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "36e7e9d216884fc64334293f71fa56a83746908631ccc8c6a4aab979da6d4330", "section_path": ["变更"], "commit_groups": [["197427fb3", "7edd2cbc5", "8388cae55", "9c46d902b", "b464e51ab", "c0c364fa1"]], "identity_text": "Avoid crash when a Snowball stemmer encounters an out-of-memory condition (Maksim Korotkov)", "commit_aliases": ["197427fb3", "7edd2cbc5", "8388cae55", "9c46d902b", "b464e51ab", "c0c364fa1"], "source_commits": ["9c46d902b"], "source_entry_id": "15.13/changes/021", "db_id": "00feddbb8384a7a8cefe4217cd497215", "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5", "relations": [{"rule": 2, "type": "equivalent", "target": "43dbc69a435522e8a12bbf37193bcbca", "evidence": {"same_day": true, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"}}, {"rule": 2, "type": "equivalent", "target": "c2850458f2850974df366bef8a85488e", "evidence": {"same_day": true, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"}}, {"rule": 2, "type": "related", "target": "d02c90e2590d4a47f73a5782496b4966", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "equivalent", "target": "d6bf0f560b8ac8cad3c1d6a070b45594", "evidence": {"same_day": true, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"}}, {"rule": 2, "type": "equivalent", "target": "fe6fa87c7f7a2f01e5226fc8b75d4395", "evidence": {"same_day": true, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"}}], "version": "15.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d02c90e2590d4a47f73a5782496b4966", "kind": "related", "version": "18.0", "label": "18.0", "title": "添加爱沙尼亚语的全文检索词干提取", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}, "url": "/docs/compare/?release=18.0#18.0-ddc75ea0db8ffc49", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES"}, {"db_id": "fe6fa87c7f7a2f01e5226fc8b75d4395", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": true, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"}, "url": "/docs/compare/?release=17.5#17.5-88fad50b7b3b2e15", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "c2850458f2850974df366bef8a85488e", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": true, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"}, "url": "/docs/compare/?release=16.9#16.9-71f38ed0f1b64f88", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "d6bf0f560b8ac8cad3c1d6a070b45594", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": true, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"}, "url": "/docs/compare/?release=14.18#14.18-813abffbc8584526", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "43dbc69a435522e8a12bbf37193bcbca", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": true, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"}, "url": "/docs/compare/?release=13.21#13.21-7de382d5402e6e82", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-bb45c4bf697c7ebc", "cves": [], "html": "防止在逻辑解码的“快进”模式中过度推进 catalog xmin（Zhijie Hou）§
\n这个错误可能导致已删除的目录条目被清理掉，即使 WAL 读取进程仍可能需要它们。
", "text": "防止在逻辑解码的“快进”模式中过度推进 catalog xmin（Zhijie Hou）§ 这个错误可能导致已删除的目录条目被清理掉，即使 WAL 读取进程仍可能需要它们。", "title": "防止在逻辑解码的“快进”模式中过度推进 catalog xmin", "commits": ["f6429bd7d"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "c099c0efc48595abb4cc7a8dbc665aa602343d35979549c80517644b7ba9c934", "section_path": ["变更"], "commit_groups": [["1f63b3626", "21a7caeeb", "36148b22e", "aaf9e95e8", "d65485b02", "f6429bd7d"]], "identity_text": "Prevent over-advancement of catalog xmin in fast forward mode of logical decoding (Zhijie Hou) This mistake could allow deleted catalog entries to be vacuumed away even though they were still potentially needed by the WAL-reading process.", "commit_aliases": ["1f63b3626", "21a7caeeb", "36148b22e", "aaf9e95e8", "d65485b02", "f6429bd7d"], "source_commits": ["f6429bd7d"], "source_entry_id": "15.13/changes/022", "db_id": "cfae289c787a92c54518341586bfbe9a", "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a", "relations": [{"rule": 2, "type": "equivalent", "target": "3ab082e1dcff51c82a077f2f62e6407c", "evidence": {"same_day": true, "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"}}, {"rule": 2, "type": "equivalent", "target": "57b3f47815396fdd9a70a193be305bf1", "evidence": {"same_day": true, "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"}}, {"rule": 2, "type": "equivalent", "target": "db9ffe506fd9139225111a635c8cd253", "evidence": {"same_day": true, "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"}}, {"rule": 2, "type": "equivalent", "target": "ddf70cdfdcf26f0a407827ed50eeab10", "evidence": {"same_day": true, "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "db9ffe506fd9139225111a635c8cd253", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "防止在逻辑解码的“快进”模式中过度推进 catalog xmin", "evidence": {"same_day": true, "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"}, "url": "/docs/compare/?release=17.5#17.5-2bb0e54648533251", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "ddf70cdfdcf26f0a407827ed50eeab10", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "防止在逻辑解码的“快进”模式中过度推进 catalog xmin", "evidence": {"same_day": true, "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"}, "url": "/docs/compare/?release=16.9#16.9-c9dae01c18776f9c", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "3ab082e1dcff51c82a077f2f62e6407c", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "防止在逻辑解码的“快进”模式中过度推进 catalog xmin", "evidence": {"same_day": true, "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"}, "url": "/docs/compare/?release=14.18#14.18-bec28c31b4951bab", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "57b3f47815396fdd9a70a193be305bf1", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "防止在逻辑解码的“快进”模式中过度推进 catalog xmin", "evidence": {"same_day": true, "patch_ids": ["c6475433b3466d0d333287697a22d76c"], "statement_hash": "31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"}, "url": "/docs/compare/?release=13.21#13.21-0d96e68077e9aca8", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-2f66029919c20aba", "cves": [], "html": "避免在不需要强锁的 DDL 操作影响正在进行逻辑复制的表时丢失数据（Shlok Kyal，Hayato Kuroda）§ §
\nDDL 命令导致的目录变更未被反映到 WAL 解码进程中，使其可能使用过期的目录数据解码后续变更，很可能导致数据损坏。
", "text": "避免在不需要强锁的 DDL 操作影响正在进行逻辑复制的表时丢失数据（Shlok Kyal，Hayato Kuroda）§ § DDL 命令导致的目录变更未被反映到 WAL 解码进程中，使其可能使用过期的目录数据解码后续变更，很可能导致数据损坏。", "title": "避免在不需要强锁的 DDL 操作影响正在进行逻辑复制的表时丢失数据", "commits": ["90bc4523f", "9f21be08e"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "f4f784af74ebed12c98ef773a87f522809ba9ff02e878337cdd8ee96286bff2a", "section_path": ["变更"], "commit_groups": [["0434033e8", "247ee9415", "4909b38af", "9a2f8b4f0", "9f21be08e", "cadaf0ac4"], ["4164d6976", "50b8ad30f", "90bc4523f", "9987c9466", "bb1bc9fa9", "d96206f25"]], "identity_text": "Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated (Shlok Kyal, Hayato Kuroda) The catalog changes caused by the DDL command were not reflected into WAL-decoding processes, allowing them to decode subsequent changes using stale catalog data, probably resulting in data corruption.", "commit_aliases": ["0434033e8", "247ee9415", "4164d6976", "4909b38af", "50b8ad30f", "90bc4523f", "9987c9466", "9a2f8b4f0", "9f21be08e", "bb1bc9fa9", "cadaf0ac4", "d96206f25"], "source_commits": ["90bc4523f", "9f21be08e"], "source_entry_id": "15.13/changes/023", "db_id": "19e936ef0715c52fd027234b084245a4", "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a", "relations": [{"rule": 2, "type": "equivalent", "target": "8e6377590f7704ee937288d5751d0fe8", "evidence": {"same_day": true, "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"}}, {"rule": 2, "type": "equivalent", "target": "db54a729c489a33329efd16078c5f632", "evidence": {"same_day": true, "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"}}, {"rule": 2, "type": "equivalent", "target": "ee4a2645d0b3d70cbf64253af5bf4bbd", "evidence": {"same_day": true, "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"}}, {"rule": 2, "type": "equivalent", "target": "f2d1d9e7b4a609d7869646462b740f14", "evidence": {"same_day": true, "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "8e6377590f7704ee937288d5751d0fe8", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "避免在不需要强锁的 DDL 操作影响正在进行逻辑复制的表时丢失数据", "evidence": {"same_day": true, "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"}, "url": "/docs/compare/?release=17.5#17.5-e21de69a327984e5", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "db54a729c489a33329efd16078c5f632", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "避免在不需要强锁的 DDL 操作影响正在进行逻辑复制的表时丢失数据", "evidence": {"same_day": true, "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"}, "url": "/docs/compare/?release=16.9#16.9-99af33434b873ed3", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "f2d1d9e7b4a609d7869646462b740f14", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "避免在不需要强锁的 DDL 操作影响正在进行逻辑复制的表时丢失数据", "evidence": {"same_day": true, "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"}, "url": "/docs/compare/?release=14.18#14.18-f53a16ec53117501", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "ee4a2645d0b3d70cbf64253af5bf4bbd", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "避免在不需要强锁的 DDL 操作影响正在进行逻辑复制的表时丢失数据", "evidence": {"same_day": true, "patch_ids": ["3b9707f5e94616c6b08bba7b727d1833", "7aa92ec4c1375172371c770fad1e069d"], "statement_hash": "5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"}, "url": "/docs/compare/?release=13.21#13.21-c43037ec57336487", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-a7ab6f2ad8ceed1e", "cves": [], "html": "避免在逻辑复制索引查找中重复创建快照（Heikki Linnakangas）§ §
", "text": "避免在逻辑复制索引查找中重复创建快照（Heikki Linnakangas）§ §", "title": "避免在逻辑复制索引查找中重复创建快照", "commits": ["50c589992", "d765226cb"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "d3a04beb07b286310d97ee7cec1598f8ce3ec44be67bb4b5912b1be8e79fdffc", "section_path": ["变更"], "commit_groups": [["136e68b46", "324e0b656", "6c1e79589", "d765226cb", "f1ef111a0", "f7c566a1a"], ["236750317", "2ef048855", "50c589992", "8171d2dae", "9b3914f18", "c1dd3a944"]], "identity_text": "Avoid duplicate snapshot creation in logical replication index lookups (Heikki Linnakangas)", "commit_aliases": ["136e68b46", "236750317", "2ef048855", "324e0b656", "50c589992", "6c1e79589", "8171d2dae", "9b3914f18", "c1dd3a944", "d765226cb", "f1ef111a0", "f7c566a1a"], "source_commits": ["50c589992", "d765226cb"], "source_entry_id": "15.13/changes/024", "db_id": "4cbd410dcacccd81b5e565436db7bc7a", "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9", "relations": [{"rule": 2, "type": "equivalent", "target": "27c56fefd26a3de8d757bbd085e3ccf7", "evidence": {"same_day": true, "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"}}, {"rule": 2, "type": "equivalent", "target": "62d7ad831c6b591f2d8c9f0a041d221b", "evidence": {"same_day": true, "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"}}, {"rule": 2, "type": "equivalent", "target": "68a6f444e2dd1111866e1692a09eaee9", "evidence": {"same_day": true, "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"}}, {"rule": 2, "type": "equivalent", "target": "c4856066739f35020574380d1ebe619e", "evidence": {"same_day": true, "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "68a6f444e2dd1111866e1692a09eaee9", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "避免在逻辑复制索引查找中重复创建快照", "evidence": {"same_day": true, "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"}, "url": "/docs/compare/?release=17.5#17.5-2069efadcbfce474", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "c4856066739f35020574380d1ebe619e", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "避免在逻辑复制索引查找中重复创建快照", "evidence": {"same_day": true, "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"}, "url": "/docs/compare/?release=16.9#16.9-844f220134ec081b", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "62d7ad831c6b591f2d8c9f0a041d221b", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "避免在逻辑复制索引查找中重复创建快照", "evidence": {"same_day": true, "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"}, "url": "/docs/compare/?release=14.18#14.18-8a94534beb8d394b", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "27c56fefd26a3de8d757bbd085e3ccf7", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "避免在逻辑复制索引查找中重复创建快照", "evidence": {"same_day": true, "patch_ids": ["1adc95ac621663bc7fa51f18ad33a68d", "809047aed79be0ed50900ccbf42f80fa"], "statement_hash": "16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"}, "url": "/docs/compare/?release=13.21#13.21-b909fdf92799340c", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "15.13-a501f629b2353dfa", "cves": [], "html": "修复关于不正确恢复时间线选择的错误消息中的检查点详情错误（David Steele）§
\n如果请求的恢复时间线不可达，报告的检查点和时间线应该是从 backup_label 中读取的值（如果有的话）。之前此消息报告的是控制文件中的值，这在没有 backup_label 从控制文件恢复时是正确的，但在有 backup_label 时则不正确。
", "text": "修复关于不正确恢复时间线选择的错误消息中的检查点详情错误（David Steele）§ 如果请求的恢复时间线不可达，报告的检查点和时间线应该是从 backup_label 中读取的值（如果有的话）。之前此消息报告的是控制文件中的值，这在没有 backup_label 从控制文件恢复时是正确的，但在有 backup_label 时则不正确。", "title": "修复关于不正确恢复时间线选择的错误消息中的检查点详情错误", "commits": ["62bed7bb0"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "b7dd6a8ea628680c582670d0ac22e704c3e2a590a9ae5c418c5bffd6b40fcc78", "section_path": ["变更"], "commit_groups": [["29cce279b", "62bed7bb0", "71f17823b", "b4969a296"]], "identity_text": "Fix wrong checkpoint details in error message about incorrect recovery timeline choice (David Steele) If the requested recovery timeline is not reachable, the reported checkpoint and timeline should be the values read from the backup_label, if there is one. This message previously reported values from the control file, which is correct when recovering from the control file without a backup_label, but not when there is a backup_label.", "commit_aliases": ["29cce279b", "62bed7bb0", "71f17823b", "b4969a296"], "source_commits": ["62bed7bb0"], "source_entry_id": "15.13/changes/025", "db_id": "54c2c91919ba0bb07a3b8c1d61f42e31", "patch_ids": ["791e0478918d750ff09e10d599952384"], "statement_hash": "e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff", "relations": [{"rule": 2, "type": "equivalent", "target": "98f7fe84bec7c123507049c72ef3a854", "evidence": {"same_day": true, "patch_ids": ["791e0478918d750ff09e10d599952384"], "statement_hash": "e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff"}}, {"rule": 2, "type": "equivalent", "target": "a246338555d823bc8f689670b84ea7a0", "evidence": {"same_day": true, "patch_ids": ["791e0478918d750ff09e10d599952384"], "statement_hash": "e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff"}}], "version": "15.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a246338555d823bc8f689670b84ea7a0", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "修复关于不正确恢复时间线选择的错误消息中的检查点详情错误", "evidence": {"same_day": true, "patch_ids": ["791e0478918d750ff09e10d599952384"], "statement_hash": "e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff"}, "url": "/docs/compare/?release=17.5#17.5-5d0c95873c035713", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "98f7fe84bec7c123507049c72ef3a854", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "修复关于不正确恢复时间线选择的错误消息中的检查点详情错误", "evidence": {"same_day": true, "patch_ids": ["791e0478918d750ff09e10d599952384"], "statement_hash": "e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff"}, "url": "/docs/compare/?release=16.9#16.9-a1968804eab98396", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}]}, {"id": "15.13-b2f3f7b8005b2c50", "cves": [], "html": "修复快照构建中的断言失败（Masahiko Sawada）§
", "text": "修复快照构建中的断言失败（Masahiko Sawada）§", "title": "修复快照构建中的断言失败", "commits": ["0f404c581"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "9a8e77a5bb302a7cff97469b03492660f55547eb34dfe4e1d1c6b693578825a9", "section_path": ["变更"], "commit_groups": [["0f404c581", "7be51eb4e"]], "identity_text": "Fix assertion failure in snapshot building (Masahiko Sawada)", "commit_aliases": ["0f404c581", "7be51eb4e"], "source_commits": ["0f404c581"], "source_entry_id": "15.13/changes/026", "db_id": "bb3cd2aeb7508cecc34d22674c04cfce", "patch_ids": ["b7fcf2471858482da835ad63c73988e0"], "statement_hash": "978d9fef615854e74284a20be4e4b29239b053483740c06da1e79a15dd4835ff", "relations": [{"rule": 2, "type": "equivalent", "target": "8c10e146eec8d58e822f99aad375b1fc", "evidence": {"same_day": true, "patch_ids": ["b7fcf2471858482da835ad63c73988e0"], "statement_hash": "978d9fef615854e74284a20be4e4b29239b053483740c06da1e79a15dd4835ff"}}], "version": "15.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "8c10e146eec8d58e822f99aad375b1fc", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "修复快照构建中的断言失败", "evidence": {"same_day": true, "patch_ids": ["b7fcf2471858482da835ad63c73988e0"], "statement_hash": "978d9fef615854e74284a20be4e4b29239b053483740c06da1e79a15dd4835ff"}, "url": "/docs/compare/?release=14.18#14.18-6f83985ff3b5be82", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}]}, {"id": "15.13-f82e2e1180369446", "cves": [], "html": "移除 pgstat_report_stat() 中不正确的断言（Michael Paquier）§
修复 gistFindCorrectParent() 中过于严格的断言（Heikki Linnakangas）§
修复当主库重启时备库中罕见的断言失败（Heikki Linnakangas）§
", "text": "修复当主库重启时备库中罕见的断言失败（Heikki Linnakangas）§", "title": "修复当主库重启时备库中罕见的断言失败", "commits": ["b30c77a0e"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "ff7b93aaf6c682e71d3860ba19de2f239302c85489729b5a1ac768109ba3ce28", "section_path": ["变更"], "commit_groups": [["2817525f0", "2f33de3cd", "302ce5bd9", "66235baab", "b30c77a0e"]], "identity_text": "Fix rare assertion failure in standby servers when the primary is restarted (Heikki Linnakangas)", "commit_aliases": ["2817525f0", "2f33de3cd", "302ce5bd9", "66235baab", "b30c77a0e"], "source_commits": ["b30c77a0e"], "source_entry_id": "15.13/changes/029", "db_id": "66b073699b174d84b287cd5ba0bb5c0b", "patch_ids": ["9563520801fea9e205ae16e82ea7855b"], "statement_hash": "e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47", "relations": [{"rule": 2, "type": "equivalent", "target": "2e5dab43fa75fedfa20b60368b606121", "evidence": {"same_day": true, "patch_ids": ["9563520801fea9e205ae16e82ea7855b"], "statement_hash": "e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"}}, {"rule": 2, "type": "equivalent", "target": "92378c11f17a7de0c034937e90f5f438", "evidence": {"same_day": true, "patch_ids": ["9563520801fea9e205ae16e82ea7855b"], "statement_hash": "e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"}}, {"rule": 2, "type": "equivalent", "target": "b243add7e25b9349d3df07b8524bbb10", "evidence": {"same_day": true, "patch_ids": ["9563520801fea9e205ae16e82ea7855b"], "statement_hash": "e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"}}], "version": "15.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "2e5dab43fa75fedfa20b60368b606121", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "修复当主库重启时备库中罕见的断言失败", "evidence": {"same_day": true, "patch_ids": ["9563520801fea9e205ae16e82ea7855b"], "statement_hash": "e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"}, "url": "/docs/compare/?release=17.5#17.5-aad4bd1803b8b133", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "b243add7e25b9349d3df07b8524bbb10", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "修复当主库重启时备库中罕见的断言失败", "evidence": {"same_day": true, "patch_ids": ["9563520801fea9e205ae16e82ea7855b"], "statement_hash": "e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"}, "url": "/docs/compare/?release=16.9#16.9-d4a51d0e3bd64212", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "92378c11f17a7de0c034937e90f5f438", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "修复当主库重启时备库中罕见的断言失败", "evidence": {"same_day": true, "patch_ids": ["9563520801fea9e205ae16e82ea7855b"], "statement_hash": "e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"}, "url": "/docs/compare/?release=14.18#14.18-c0e9cfa3a39cfe3a", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}]}, {"id": "15.13-4f40d70662d8882c", "cves": [], "html": "在 PL/pgSQL 中，避免当可滚动游标定义在简单 SELECT 查询上时出现 “unexpected plan node type” 错误（Andrei Lepikhov）§expression
在 pg_dump 的 --clean 模式中不再尝试删除单个索引分区（Jian He）§
服务器会拒绝这样的 DROP 命令。这实际上没有什么影响，因为这些分区在后续对其父表或分区索引执行 DROP 时会被自动删除。但是，尝试删除时报告的错误会在以 --single-transaction 模式恢复时造成问题。
在 pg_dumpall 中，避免在 pg_auth_members 包含无效角色 OID 时生成无效的角色 GRANT 命令（Tom Lane）§
改为打印警告并跳过该条目。这能更好地处理在后端分支中因 GRANT 和 DROP ROLE 之间的竞态条件而导致的目录损坏。
在 pg_amcheck 和 pg_upgrade 中，使用正确的函数释放由 libpq 分配的内存（Michael Paquier，Ranier Vilela）§
\n这些疏忽可能导致在某些 Windows 构建配置下崩溃，例如调试版本的 libpq 被非调试版本的调用程序使用时。
", "text": "在 pg_amcheck 和 pg_upgrade 中，使用正确的函数释放由 libpq 分配的内存（Michael Paquier，Ranier Vilela）§ 这些疏忽可能导致在某些 Windows 构建配置下崩溃，例如调试版本的 libpq 被非调试版本的调用程序使用时。", "title": "在 pg_amcheck 和 pg_upgrade 中，使用正确的函数释放由 libpq 分配的内存", "commits": ["ec741d480"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "63b069b4944b44638b27e027686ce6cb7119f9959ede6326759ebe185e4749cc", "section_path": ["变更"], "commit_groups": [["0851b6573", "57467ec7b", "945126234"], ["2a083ab80", "9ca2145b0", "ee78823ff"], ["35a591a04", "48e4ae9a0", "816149dc6", "ec741d480", "f903d4da9"]], "identity_text": "In pg_amcheck and pg_upgrade, use the correct function to free allocations made by libpq (Michael Paquier, Ranier Vilela) These oversights could result in crashes in certain Windows build configurations, such as a debug build of libpq used by a non-debug build of the calling application.", "commit_aliases": ["0851b6573", "2a083ab80", "35a591a04", "48e4ae9a0", "57467ec7b", "816149dc6", "945126234", "9ca2145b0", "ec741d480", "ee78823ff", "f903d4da9"], "source_commits": ["2a083ab80", "945126234", "ec741d480"], "source_entry_id": "15.13/changes/033", "db_id": "ec8806ac157013d5a48910bd3a2696f9", "patch_ids": ["34b26a2c0bc11f53689f56c106a22dd3", "5db415aa9fa83b6f5da048d1aaff9003", "7d2d1045e1e8db0bcdd0ec88b43e297b"], "statement_hash": "147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6", "relations": [{"rule": 2, "type": "equivalent", "target": "60340d64ebc76c76673aee7bbdf1bf84", "evidence": {"same_day": true, "patch_ids": ["34b26a2c0bc11f53689f56c106a22dd3", "5db415aa9fa83b6f5da048d1aaff9003", "7d2d1045e1e8db0bcdd0ec88b43e297b"], "statement_hash": "147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"}}, {"rule": 2, "type": "equivalent", "target": "8a119f30aebe8217bd24c84ac83c5357", "evidence": {"same_day": true, "patch_ids": ["34b26a2c0bc11f53689f56c106a22dd3", "5db415aa9fa83b6f5da048d1aaff9003", "7d2d1045e1e8db0bcdd0ec88b43e297b"], "statement_hash": "147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"}}, {"rule": 2, "type": "equivalent", "target": "ef4d0bd11b44a555d9ff5417d9062b2d", "evidence": {"same_day": true, "patch_ids": ["34b26a2c0bc11f53689f56c106a22dd3", "5db415aa9fa83b6f5da048d1aaff9003", "7d2d1045e1e8db0bcdd0ec88b43e297b"], "statement_hash": "147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"}}], "version": "15.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "8a119f30aebe8217bd24c84ac83c5357", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "在 pg_amcheck 和 pg_upgrade 中，使用正确的函数释放由 libpq 分配的内存", "evidence": {"same_day": true, "patch_ids": ["34b26a2c0bc11f53689f56c106a22dd3", "5db415aa9fa83b6f5da048d1aaff9003", "7d2d1045e1e8db0bcdd0ec88b43e297b"], "statement_hash": "147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"}, "url": "/docs/compare/?release=17.5#17.5-5ad323aca8e79aef", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "60340d64ebc76c76673aee7bbdf1bf84", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "在 pg_amcheck 和 pg_upgrade 中，使用正确的函数释放由 libpq 分配的内存", "evidence": {"same_day": true, "patch_ids": ["34b26a2c0bc11f53689f56c106a22dd3", "5db415aa9fa83b6f5da048d1aaff9003", "7d2d1045e1e8db0bcdd0ec88b43e297b"], "statement_hash": "147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"}, "url": "/docs/compare/?release=16.9#16.9-76778728b70e985f", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "ef4d0bd11b44a555d9ff5417d9062b2d", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "在 pg_amcheck 和 pg_upgrade 中，使用正确的函数释放由 libpq 分配的内存", "evidence": {"same_day": true, "patch_ids": ["34b26a2c0bc11f53689f56c106a22dd3", "5db415aa9fa83b6f5da048d1aaff9003", "7d2d1045e1e8db0bcdd0ec88b43e297b"], "statement_hash": "147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"}, "url": "/docs/compare/?release=14.18#14.18-7a70a94b4f51a3ee", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}]}, {"id": "15.13-d66f9c3e0287eec0", "cves": [], "html": "允许通过查询取消来中断 contrib/dblink 查询（Noah Misch）§ §
此变更回迁了 v17 时代的修复。它防止了由于未能检测到死锁而导致的 CREATE DATABASE 和 DROP DATABASE 可能挂起的情况。
避免在 contrib/pageinspect 的 heap_page_items() 中因损坏的输入数据而崩溃（Dmitry Kovalenko）§
防止 contrib/pg_freespacemap 的 pg_freespacemap() 中的断言失败（Tender Wang）§
对没有存储的关系（如视图）应用 pg_freespacemap() 会导致断言失败，尽管在非断言构建中没有不良影响。增加了错误检查以拒绝这种情况。
修复在 macOS 15.4 上的构建失败（Tom Lane，Peter Eisentraut）§
\n此 macOS 更新破坏了我们对 strchrnul() 的配置探测。
更新时区数据文件至 tzdata 2025b 版本，包含智利的夏令时法律变更以及伊朗的历史修正（Tom Lane）§
\n新增时区 America/Coyhaique 用于智利的 Aysén 大区，以反映其改为全年使用 UTC-03，从而与 America/Santiago 产生差异。
", "text": "更新时区数据文件至 tzdata 2025b 版本，包含智利的夏令时法律变更以及伊朗的历史修正（Tom Lane）§ 新增时区 America/Coyhaique 用于智利的 Aysén 大区，以反映其改为全年使用 UTC-03，从而与 America/Santiago 产生差异。", "title": "更新时区数据文件至 tzdata 2025b 版本，包含智利的夏令时法律变更以及伊朗的历史修正", "commits": ["a144cf145"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10", "source_hash": "553e98a52283085a81d331540e4f8cadb8fbadd3cc61776a9d1e77c4508aec80", "section_path": ["变更"], "commit_groups": [["368c3fbf9", "5d5970b9f", "9da548df3", "a144cf145", "e076120d9", "fa4244a43"]], "identity_text": "Update time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran (Tom Lane) There is a new time zone America/Coyhaique for Chile's Aysén Region, to account for it changing to UTC-03 year-round and thus diverging from America/Santiago.", "commit_aliases": ["368c3fbf9", "5d5970b9f", "9da548df3", "a144cf145", "e076120d9", "fa4244a43"], "source_commits": ["a144cf145"], "source_entry_id": "15.13/changes/038", "db_id": "2e73cf839c165cbbaf867b7175690bd0", "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4", "relations": [{"rule": 2, "type": "equivalent", "target": "85360ac1e18899dc279978e17903e0fd", "evidence": {"same_day": true, "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"}}, {"rule": 2, "type": "equivalent", "target": "89bbdc6060fef88d085afd6409e10416", "evidence": {"same_day": true, "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"}}, {"rule": 2, "type": "equivalent", "target": "b46b51b6ab58678c9616193380655da3", "evidence": {"same_day": true, "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"}}, {"rule": 2, "type": "equivalent", "target": "c1730518d55761ba90941aa06c170dfb", "evidence": {"same_day": true, "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"}}], "version": "15.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b46b51b6ab58678c9616193380655da3", "kind": "equivalent", "version": "17.5", "label": "17.5", "title": "更新时区数据文件至 tzdata 2025b 版本，包含智利的夏令时法律变更以及伊朗的历史修正", "evidence": {"same_day": true, "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"}, "url": "/docs/compare/?release=17.5#17.5-1787eeef076438cb", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "89bbdc6060fef88d085afd6409e10416", "kind": "equivalent", "version": "16.9", "label": "16.9", "title": "更新时区数据文件至 tzdata 2025b 版本，包含智利的夏令时法律变更以及伊朗的历史修正", "evidence": {"same_day": true, "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"}, "url": "/docs/compare/?release=16.9#16.9-edae619b47bafc29", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "85360ac1e18899dc279978e17903e0fd", "kind": "equivalent", "version": "14.18", "label": "14.18", "title": "更新时区数据文件至 tzdata 2025b 版本，包含智利的夏令时法律变更以及伊朗的历史修正", "evidence": {"same_day": true, "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"}, "url": "/docs/compare/?release=14.18#14.18-08e4060ba79b5c53", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "c1730518d55761ba90941aa06c170dfb", "kind": "equivalent", "version": "13.21", "label": "13.21", "title": "更新时区数据文件至 tzdata 2025b 版本，包含智利的夏令时法律变更以及伊朗的历史修正", "evidence": {"same_day": true, "patch_ids": ["37a58a33f41e391eeea747c321eac090"], "statement_hash": "c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"}, "url": "/docs/compare/?release=13.21#13.21-fa15b367f3d46c9d", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 38}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 18}, {"key": "security", "label": "安全相关", "count": 1}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 19}], "total": 38, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2025-4207", "url": "https://www.postgresql.org/support/security/CVE-2025-4207/", "fixed": {"13": "13.21", "14": "14.18", "15": "15.13", "16": "16.9", "17": "17.5"}, "score": 5.9, "title": "避免在检查声称为 GB18030 编码的无效编码字符串时发生单字节缓冲区越界读取", "vector": "AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2025-4207", "affected": {"13": "13", "14": "14", "15": "15", "16": "16", "17": "17"}, "component": "core server", "published": {"13": "2025-05-08", "14": "2025-05-08", "15": "2025-05-08", "16": "2025-05-08", "17": "2025-05-08"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Buffer over-read in PostgreSQL GB18030 encoding validation allows a database input provider to achieve temporary denial of service on platforms where a 1-byte over-read can elicit process termination. This affects the database server and also libpq. Versions before PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21 are affected.", "affected_ranges": [{"from": "0", "until": "13.21"}, {"from": "14", "until": "14.18"}, {"from": "15", "until": "15.13"}, {"from": "16", "until": "16.9"}, {"from": "17", "until": "17.5"}], "first_published": "2025-05-08", "fixed_version": "15.13"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 38, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}