{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2026-02-12", "build": "15.16", "major": "15", "minor": 16, "manual": "15", "status": "stable", "doc_git": "", "version": "15.16", "eol_date": "2027-11-11", "date_text": "2026-02-12", "supported": true, "manual_url": "/docs/15/release-15-16.html", "source_url": "/docs/release/15.16/", "entry_count": 40, "placeholder": false, "content_hash": "baa68daae6d661fd683064a18d150b7fb41ad9a3e245eeb937990f01841df882", "manual_build": "15.19", "source_as_of": "", "changes_count": 40, "doc_loaded_at": "2026-09-26T02:56:38.228564", "migration_html": "<p>对于运行 15.X 的用户，不需要执行导出/恢复。</p>\n<p>但是，如果你从早于 15.14 的版本升级，请参见<a href=\"/docs/15/release-15-14.html\" title=\"E.6. 发布版本 15.14\">第 E.6 节</a>。</p>", "compatibility_count": 0, "label": "15.16", "status_label": "受支持版本", "eol": "2027-11-11", "age_days": 226, "support_days": 411}, "groups": [{"date": "2026-02-12", "build": "15.16", "major": "15", "minor": 16, "manual": "15", "status": "stable", "doc_git": "", "version": "15.16", "eol_date": "2027-11-11", "date_text": "2026-02-12", "supported": true, "manual_url": "/docs/15/release-15-16.html", "source_url": "/docs/release/15.16/", "entry_count": 40, "placeholder": false, "content_hash": "baa68daae6d661fd683064a18d150b7fb41ad9a3e245eeb937990f01841df882", "manual_build": "15.19", "source_as_of": "", "changes_count": 40, "doc_loaded_at": "2026-09-26T02:56:38.228564", "migration_html": "<p>对于运行 15.X 的用户，不需要执行导出/恢复。</p>\n<p>但是，如果你从早于 15.14 的版本升级，请参见<a href=\"/docs/15/release-15-14.html\" title=\"E.6. 发布版本 15.14\">第 E.6 节</a>。</p>", "compatibility_count": 0, "label": "15.16", "status_label": "受支持版本", "eol": "2027-11-11", "age_days": 226, "support_days": 411, "entries": [{"id": "15.16-cffa85682917fc25", "cves": ["CVE-2026-2003"], "html": "<p>防止 <code>oidvector</code>/<code>int2vector</code> 出现意外的维度（Tom Lane）<a href=\"https://postgr.es/c/429aeaebd\">§</a></p>\n<p>这些数据类型预期为不含空值的一维数组，但某些类型转换路径允许违背这些预期。现已为一些原本依赖这些预期却未加验证的函数补充检查，因为它们可能因此产生错误行为。</p>\n<p><span>PostgreSQL</span> 项目感谢 Altan Birler 报告此问题。（CVE-2026-2003）</p>", "text": "防止 oidvector/int2vector 出现意外的维度（Tom Lane）§ 这些数据类型预期为不含空值的一维数组，但某些类型转换路径允许违背这些预期。现已为一些原本依赖这些预期却未加验证的函数补充检查，因为它们可能因此产生错误行为。 PostgreSQL 项目感谢 Altan Birler 报告此问题。（CVE-2026-2003）", "title": "防止 oidvector/int2vector 出现意外的维度", "commits": ["429aeaebd"], "section": "变更", "category": "security", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "4e251b25bfdfaf4fc7b6580e4720acb2ac5ae2e6527c067a9a2e06b1bca6755a", "section_path": ["变更"], "commit_groups": [["3b6588cd9", "3d160401b", "429aeaebd", "595956fc7", "60e7ae41a", "b39d38139"]], "identity_text": "Guard against unexpected dimensions of oidvector/int2vector (Tom Lane) These data types are expected to be 1-dimensional arrays containing no nulls, but there are cast pathways that permit violating those expectations. Add checks to some functions that were depending on those expectations without verifying them, and could misbehave in consequence. The PostgreSQL Project thanks Altan Birler for reporting this problem. (CVE-2026-2003)", "commit_aliases": ["3b6588cd9", "3d160401b", "429aeaebd", "595956fc7", "60e7ae41a", "b39d38139"], "source_commits": ["429aeaebd"], "source_entry_id": "15.16/changes/001", "db_id": "8db55cd2cacfbefb7d8380baee0440a5", "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787", "relations": [{"rule": 2, "type": "equivalent", "target": "020aec6d98ff35dcd4eca87ecb7d21fd", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}}, {"rule": 2, "type": "equivalent", "target": "93680dc2fc005fc9bc0a92b7d80ee23b", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}}, {"rule": 2, "type": "equivalent", "target": "d474cd2cf9a4505bba396d502fe366fe", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}}, {"rule": 2, "type": "equivalent", "target": "dadfe1bd35a127e4b2350a876ce5f39d", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}}], "version": "15.16", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "020aec6d98ff35dcd4eca87ecb7d21fd", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "防止 oidvector/int2vector 出现意外的维度", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}, "url": "/docs/compare/?release=18.2#18.2-5c52afa7301594c6", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "dadfe1bd35a127e4b2350a876ce5f39d", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "防止 oidvector/int2vector 出现意外的维度", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}, "url": "/docs/compare/?release=17.8#17.8-a1109c4f32ae03d0", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "93680dc2fc005fc9bc0a92b7d80ee23b", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "防止 oidvector/int2vector 出现意外的维度", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}, "url": "/docs/compare/?release=16.12#16.12-289361027e903f71", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "d474cd2cf9a4505bba396d502fe366fe", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "防止 oidvector/int2vector 出现意外的维度", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}, "url": "/docs/compare/?release=14.21#14.21-182abf620be79725", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-9ecdcfc6d990fa17", "cves": ["CVE-2026-2004"], "html": "<p>增强选择率估算器在被附加到接受非预期数据类型的操作符时的防护（Tom Lane）<a href=\"https://postgr.es/c/b764b26f2\">§</a> <a href=\"https://postgr.es/c/deb464a40\">§</a> <a href=\"https://postgr.es/c/3ecc84cce\">§</a></p>\n<p><code>contrib/intarray</code> 包含一个选择率估算函数；由于它未检查输入是否为预期的数据类型，该函数可被滥用来执行任意代码。第三方扩展也应检查是否存在类似风险，并采用 intarray 现在使用的技术来增加防护。由于此类扩展的修复需要时间，我们现在要求具有超级用户权限，才能将非内置的选择率估算器附加到操作符上。</p>\n<p><span>PostgreSQL</span> 项目感谢 Daniel Firer（zeroday.cloud 成员）报告此问题。（CVE-2026-2004）</p>", "text": "增强选择率估算器在被附加到接受非预期数据类型的操作符时的防护（Tom Lane）§ § § contrib/intarray 包含一个选择率估算函数；由于它未检查输入是否为预期的数据类型，该函数可被滥用来执行任意代码。第三方扩展也应检查是否存在类似风险，并采用 intarray 现在使用的技术来增加防护。由于此类扩展的修复需要时间，我们现在要求具有超级用户权限，才能将非内置的选择率估算器附加到操作符上。 PostgreSQL 项目感谢 Daniel Firer（zeroday.cloud 成员）报告此问题。（CVE-2026-2004）", "title": "增强选择率估算器在被附加到接受非预期数据类型的操作符时的防护", "commits": ["3ecc84cce", "b764b26f2", "deb464a40"], "section": "变更", "category": "security", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "850e7c71f5a877f6529a7df8d6fd635e662a2577b70aef46f1164d6c08d17f10", "section_path": ["变更"], "commit_groups": [["3ecc84cce", "9fa38c572", "d484bc260", "dbb09fd8e"], ["66ddac698", "841d42cc4", "91d7c0bfd", "b764b26f2", "bbf5bcf58", "ea3bf3498"], ["7e82d9a04", "8ebdf41c2", "b69af3dda", "c0887b39d", "dd3ad2a4d", "deb464a40"]], "identity_text": "Harden selectivity estimators against being attached to operators that accept unexpected data types (Tom Lane) contrib/intarray contained a selectivity estimation function that could be abused for arbitrary code execution, because it did not check that its input was of the expected data type. Third-party extensions should check for similar hazards and add defenses using the technique intarray now uses. Since such extension fixes will take time, we now require superuser privilege to attach a non-built-in selectivity estimator to an operator. The PostgreSQL Project thanks Daniel Firer, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2004)", "commit_aliases": ["3ecc84cce", "66ddac698", "7e82d9a04", "841d42cc4", "8ebdf41c2", "91d7c0bfd", "9fa38c572", "b69af3dda", "b764b26f2", "bbf5bcf58", "c0887b39d", "d484bc260", "dbb09fd8e", "dd3ad2a4d", "deb464a40", "ea3bf3498"], "source_commits": ["3ecc84cce", "b764b26f2", "deb464a40"], "source_entry_id": "15.16/changes/002", "db_id": "b368f952921e7f029d36869bd2860743", "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4", "relations": [{"rule": 2, "type": "equivalent", "target": "184452363a4be8fbad69f06eb60df539", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}}, {"rule": 2, "type": "equivalent", "target": "3cfe051a6ace1086d9ff67af367a40f4", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}}, {"rule": 2, "type": "equivalent", "target": "853a0accddf2290afda1b4c5d74207ed", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}}, {"rule": 2, "type": "equivalent", "target": "eb75ba70d74784578edba6ea18a6aaf9", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}}], "version": "15.16", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "853a0accddf2290afda1b4c5d74207ed", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "增强选择率估算器在被附加到接受非预期数据类型的操作符时的防护", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}, "url": "/docs/compare/?release=18.2#18.2-0a3add9d9f709ebd", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "eb75ba70d74784578edba6ea18a6aaf9", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "增强选择率估算器在被附加到接受非预期数据类型的操作符时的防护", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}, "url": "/docs/compare/?release=17.8#17.8-66e960e22441cfaa", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "184452363a4be8fbad69f06eb60df539", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "增强选择率估算器在被附加到接受非预期数据类型的操作符时的防护", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}, "url": "/docs/compare/?release=16.12#16.12-9d7c1c9d84e5292d", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "3cfe051a6ace1086d9ff67af367a40f4", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "增强选择率估算器在被附加到接受非预期数据类型的操作符时的防护", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}, "url": "/docs/compare/?release=14.21#14.21-4f1356e5a78a8982", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-55f620c5255ec99f", "cves": ["CVE-2026-2005"], "html": "<p>修复 <code>contrib/pgcrypto</code> PGP 解密函数中的缓冲区溢出问题（Michael Paquier）<a href=\"https://postgr.es/c/9a9982ec6\">§</a></p>\n<p>解密带有超长会话密钥的精心构造消息会导致缓冲区溢出，严重时甚至可能执行任意代码。</p>\n<p><span>PostgreSQL</span> 项目感谢 Team Xint Code（zeroday.cloud 成员）报告此问题。（CVE-2026-2005）</p>", "text": "修复 contrib/pgcrypto PGP 解密函数中的缓冲区溢出问题（Michael Paquier）§ 解密带有超长会话密钥的精心构造消息会导致缓冲区溢出，严重时甚至可能执行任意代码。 PostgreSQL 项目感谢 Team Xint Code（zeroday.cloud 成员）报告此问题。（CVE-2026-2005）", "title": "修复 contrib/pgcrypto PGP 解密函数中的缓冲区溢出问题", "commits": ["9a9982ec6"], "section": "变更", "category": "security", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "d3340ce33dee6b34344e29023ed13f3391144847390682bf5d5af53fecfeb57f", "section_path": ["变更"], "commit_groups": [["01de2e32d", "209f387b8", "379695d3c", "527b730f4", "7a7d9693c", "9a9982ec6"]], "identity_text": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions (Michael Paquier) Decrypting a crafted message with an overlength session key caused a buffer overrun, with consequences as bad as arbitrary code execution. The PostgreSQL Project thanks Team Xint Code, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2005)", "commit_aliases": ["01de2e32d", "209f387b8", "379695d3c", "527b730f4", "7a7d9693c", "9a9982ec6"], "source_commits": ["9a9982ec6"], "source_entry_id": "15.16/changes/003", "db_id": "e4dd47f240a98be34ae099044d8a2b56", "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307", "relations": [{"rule": 2, "type": "equivalent", "target": "bdd4104dfc3659a38e0f0389ee19b847", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}}, {"rule": 2, "type": "equivalent", "target": "d0b0ce25a07e9ad598056180477520b6", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}}, {"rule": 2, "type": "equivalent", "target": "e7bf20473d33d5835462a40fa9fd5552", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}}, {"rule": 2, "type": "equivalent", "target": "ef4c4d388861428d41d8694448d1ec90", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}}], "version": "15.16", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "ef4c4d388861428d41d8694448d1ec90", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复 contrib/pgcrypto PGP 解密函数中的缓冲区溢出问题", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}, "url": "/docs/compare/?release=18.2#18.2-c6669984145bd55c", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "d0b0ce25a07e9ad598056180477520b6", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复 contrib/pgcrypto PGP 解密函数中的缓冲区溢出问题", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}, "url": "/docs/compare/?release=17.8#17.8-ad02898fb1831e36", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "e7bf20473d33d5835462a40fa9fd5552", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复 contrib/pgcrypto PGP 解密函数中的缓冲区溢出问题", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}, "url": "/docs/compare/?release=16.12#16.12-a3ed183e10806004", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "bdd4104dfc3659a38e0f0389ee19b847", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复 contrib/pgcrypto PGP 解密函数中的缓冲区溢出问题", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}, "url": "/docs/compare/?release=14.21#14.21-8072e6858a1ccb57", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-62940c666c30fc8b", "cves": ["CVE-2026-2006"], "html": "<p>修复多字节字符长度验证不充分的问题（Thomas Munro，Noah Misch）<a href=\"https://postgr.es/c/b2c81ac86\">§</a> <a href=\"https://postgr.es/c/50863be0b\">§</a> <a href=\"https://postgr.es/c/fd82ddb67\">§</a> <a href=\"https://postgr.es/c/757bf8145\">§</a> <a href=\"https://postgr.es/c/8f8b1ffac\">§</a> <a href=\"https://postgr.es/c/6f741bcb6\">§</a></p>\n<p>多处漏洞使攻击者只要能够发出精心构造的 SQL，就可能溢出字符串缓冲区，严重时甚至可以执行任意代码。应用这些修复后，当字符串函数处理数据库中存储的无效文本时，应用程序可能会看到 <span>“<span>invalid byte sequence for encoding</span>”</span> 错误。</p>\n<p><span>PostgreSQL</span> 项目感谢 Paul Gerste 和 Moritz Sanft（zeroday.cloud 成员）报告此问题。（CVE-2026-2006）</p>", "text": "修复多字节字符长度验证不充分的问题（Thomas Munro，Noah Misch）§ § § § § § 多处漏洞使攻击者只要能够发出精心构造的 SQL，就可能溢出字符串缓冲区，严重时甚至可以执行任意代码。应用这些修复后，当字符串函数处理数据库中存储的无效文本时，应用程序可能会看到 “invalid byte sequence for encoding” 错误。 PostgreSQL 项目感谢 Paul Gerste 和 Moritz Sanft（zeroday.cloud 成员）报告此问题。（CVE-2026-2006）", "title": "修复多字节字符长度验证不充分的问题", "commits": ["50863be0b", "6f741bcb6", "757bf8145", "8f8b1ffac", "b2c81ac86", "fd82ddb67"], "section": "变更", "category": "security", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "3274362f1d5a0338f397a01e642b2e8ee1fade7f537ae5374030ed707b6e57fd", "section_path": ["变更"], "commit_groups": [["0c33d5608", "8373ed094", "8f8b1ffac", "b42709194", "d536aee55", "dc072a09a"], ["10ebc4bd6", "4c08960d9", "757bf8145", "b0f5d25bc", "c67bef3f3", "e7591254c"], ["1e7fe06c1", "319e8a644", "7b5fc85be", "cecedb912", "d837fb029", "fd82ddb67"], ["2a53db21e", "70ff9ede5", "838248b1b", "af79c30dc", "b2c81ac86", "df0852fe0"], ["4543b02af", "5301b2b7d", "6f741bcb6", "763671b74", "955433ebd", "c5dc75479"], ["50863be0b", "6ed116046", "74ee636cc", "7a522039f", "b0e3f5cf9", "efef05ba9"]], "identity_text": "Fix inadequate validation of multibyte character lengths (Thomas Munro, Noah Misch) Assorted bugs allowed an attacker able to issue crafted SQL to overrun string buffers, with consequences as bad as arbitrary code execution. After these fixes, applications may observe invalid byte sequence for encoding errors when string functions process invalid text that has been stored in the database. The PostgreSQL Project thanks Paul Gerste and Moritz Sanft, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2006)", "commit_aliases": ["0c33d5608", "10ebc4bd6", "1e7fe06c1", "2a53db21e", "319e8a644", "4543b02af", "4c08960d9", "50863be0b", "5301b2b7d", "6ed116046", "6f741bcb6", "70ff9ede5", "74ee636cc", "757bf8145", "763671b74", "7a522039f", "7b5fc85be", "8373ed094", "838248b1b", "8f8b1ffac", "955433ebd", "af79c30dc", "b0e3f5cf9", "b0f5d25bc", "b2c81ac86", "b42709194", "c5dc75479", "c67bef3f3", "cecedb912", "d536aee55", "d837fb029", "dc072a09a", "df0852fe0", "e7591254c", "efef05ba9", "fd82ddb67"], "source_commits": ["50863be0b", "6f741bcb6", "757bf8145", "8f8b1ffac", "b2c81ac86", "fd82ddb67"], "source_entry_id": "15.16/changes/004", "db_id": "e5c2b929807dffd0fc80d18ac5ef27da", "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb", "relations": [{"rule": 2, "type": "equivalent", "target": "25b98554e64d0842a180907318bd502a", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}}, {"rule": 2, "type": "equivalent", "target": "2fee65050d60d6944038f5de1fd6e77f", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}}, {"rule": 2, "type": "equivalent", "target": "66ef8e4bb930ff6d7fb76f1509e60bdb", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}}, {"rule": 2, "type": "equivalent", "target": "c7f1c767af36d148849ecf12abc7b39c", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}}], "version": "15.16", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "66ef8e4bb930ff6d7fb76f1509e60bdb", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复多字节字符长度验证不充分的问题", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}, "url": "/docs/compare/?release=18.2#18.2-b28dc0bb7dc6b053", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "2fee65050d60d6944038f5de1fd6e77f", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复多字节字符长度验证不充分的问题", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}, "url": "/docs/compare/?release=17.8#17.8-0378679c62701a5e", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "c7f1c767af36d148849ecf12abc7b39c", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复多字节字符长度验证不充分的问题", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}, "url": "/docs/compare/?release=16.12#16.12-d657c6f02bbf824f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "25b98554e64d0842a180907318bd502a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复多字节字符长度验证不充分的问题", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}, "url": "/docs/compare/?release=14.21#14.21-0170b76fb58a4a02", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-dc510262703bad79", "cves": [], "html": "<p>不允许由子查询中的 CTE 引用决定聚合函数的语义层级（Tom Lane）<a href=\"https://postgr.es/c/9f5a58aac\">§</a></p>\n<p>此变更撤销了两个小版本之前引入的一项更改；现在，如果某个子查询引用的 CTE 所处层级低于按标准 SQL 规则依据其中的列引用和聚合所判定的聚合语义层级，将抛出错误。先前的修复方案本身也带来了问题，而且目前尚不清楚应如何处理。由于 SQL 标准本就完全不允许在聚合中包含子查询，将此类情况视为错误似乎已经足够。</p>", "text": "不允许由子查询中的 CTE 引用决定聚合函数的语义层级（Tom Lane）§ 此变更撤销了两个小版本之前引入的一项更改；现在，如果某个子查询引用的 CTE 所处层级低于按标准 SQL 规则依据其中的列引用和聚合所判定的聚合语义层级，将抛出错误。先前的修复方案本身也带来了问题，而且目前尚不清楚应如何处理。由于 SQL 标准本就完全不允许在聚合中包含子查询，将此类情况视为错误似乎已经足够。", "title": "不允许由子查询中的 CTE 引用决定聚合函数的语义层级", "commits": ["9f5a58aac"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "3f3e63830f8b41c872ad80692e74acd7a00bf17a39ae022d9e575e1e52080c55", "section_path": ["变更"], "commit_groups": [["075a763e2", "12bc32917", "1c8c3206f", "35b5c62c3", "9f5a58aac", "b85397481"]], "identity_text": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions (Tom Lane) This change undoes a change made two minor releases ago, instead throwing an error if a sub-select references a CTE that's below the semantic level that standard SQL rules would assign to the aggregate based on contained column references and aggregates. The attempted fix turned out to cause problems of its own, and it's unclear what to do instead. Since sub-selects within aggregates are disallowed altogether by the SQL standard, treating such cases as errors seems sufficient.", "commit_aliases": ["075a763e2", "12bc32917", "1c8c3206f", "35b5c62c3", "9f5a58aac", "b85397481"], "source_commits": ["9f5a58aac"], "source_entry_id": "15.16/changes/005", "db_id": "4864352d8953061a7f3e2f942fd405e2", "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059", "relations": [{"rule": 2, "type": "equivalent", "target": "128a16829eb01aeea2a683fa84040725", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}}, {"rule": 2, "type": "equivalent", "target": "968c190ce539c030cfe3824a0cddc761", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}}, {"rule": 2, "type": "equivalent", "target": "cc9e6465c86b962c0dda27e8afcac193", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}}, {"rule": 2, "type": "equivalent", "target": "dcc6e6d85b35d0422b8e17422a731c4a", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "968c190ce539c030cfe3824a0cddc761", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "不允许由子查询中的 CTE 引用决定聚合函数的语义层级", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}, "url": "/docs/compare/?release=18.2#18.2-d6f0ddb2f2597bb2", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "128a16829eb01aeea2a683fa84040725", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "不允许由子查询中的 CTE 引用决定聚合函数的语义层级", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}, "url": "/docs/compare/?release=17.8#17.8-69605b7e08548aa0", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "cc9e6465c86b962c0dda27e8afcac193", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "不允许由子查询中的 CTE 引用决定聚合函数的语义层级", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}, "url": "/docs/compare/?release=16.12#16.12-e79313988f03e883", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "dcc6e6d85b35d0422b8e17422a731c4a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "不允许由子查询中的 CTE 引用决定聚合函数的语义层级", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}, "url": "/docs/compare/?release=14.21#14.21-9f3dcc608f8165a8", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-3bdf28daf1c8fa5a", "cves": [], "html": "<p>修复 CTE 查询中 <code>MERGE</code> 的触发器过渡表捕获问题（Dean Rasheed）<a href=\"https://postgr.es/c/c5824536e\">§</a></p>\n<p>当执行包含 <code>MERGE</code> 和另一个对具有语句级 <code>AFTER</code> 触发器的表的 DML 操作的数据修改 CTE 查询时，传递给触发器的过渡表将不包含 <code>MERGE</code> 影响的行，而只包含其他操作影响的行。</p>", "text": "修复 CTE 查询中 MERGE 的触发器过渡表捕获问题（Dean Rasheed）§ 当执行包含 MERGE 和另一个对具有语句级 AFTER 触发器的表的 DML 操作的数据修改 CTE 查询时，传递给触发器的过渡表将不包含 MERGE 影响的行，而只包含其他操作影响的行。", "title": "修复 CTE 查询中 MERGE 的触发器过渡表捕获问题", "commits": ["c5824536e"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "c076487b5c2d951407092c19a04c3b58c522ec725b3b8068ba761b6973f69762", "section_path": ["变更"], "commit_groups": [["b4307ae2e", "c5824536e", "c5fc17dda", "c6ce4dcf9", "e7391bbf1"]], "identity_text": "Fix trigger transition table capture for MERGE in CTE queries (Dean Rasheed) When executing a data-modifying CTE query containing both a MERGE and another DML operation on a table with statement-level AFTER triggers, the transition tables passed to the triggers would not include the rows affected by the MERGE, only those affected by the other operation(s).", "commit_aliases": ["b4307ae2e", "c5824536e", "c5fc17dda", "c6ce4dcf9", "e7391bbf1"], "source_commits": ["c5824536e"], "source_entry_id": "15.16/changes/006", "db_id": "67486d10436f31c845689f24645f975f", "patch_ids": ["9cb7a95ca83cc42e1b56a8fbc492d52e"], "statement_hash": "66d5665f7806451842ea09bab53ec96bcabb424e0cd66ec57fdd516b027ac4f9", "relations": [{"rule": 2, "type": "equivalent", "target": "d454fc992715ec69f11869ffab65efab", "evidence": {"same_day": true, "patch_ids": ["9cb7a95ca83cc42e1b56a8fbc492d52e"], "statement_hash": "66d5665f7806451842ea09bab53ec96bcabb424e0cd66ec57fdd516b027ac4f9"}}, {"rule": 2, "type": "equivalent", "target": "d4a6c61bfb31b9d9da04d2ea0c6cf39b", "evidence": {"same_day": true, "patch_ids": ["9cb7a95ca83cc42e1b56a8fbc492d52e"], "statement_hash": "66d5665f7806451842ea09bab53ec96bcabb424e0cd66ec57fdd516b027ac4f9"}}, {"rule": 2, "type": "equivalent", "target": "e753c6457f34a85baec08d989ba33d82", "evidence": {"same_day": true, "patch_ids": ["9cb7a95ca83cc42e1b56a8fbc492d52e"], "statement_hash": "66d5665f7806451842ea09bab53ec96bcabb424e0cd66ec57fdd516b027ac4f9"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e753c6457f34a85baec08d989ba33d82", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复 CTE 查询中 MERGE 的触发器过渡表捕获问题", "evidence": {"same_day": true, "patch_ids": ["9cb7a95ca83cc42e1b56a8fbc492d52e"], "statement_hash": "66d5665f7806451842ea09bab53ec96bcabb424e0cd66ec57fdd516b027ac4f9"}, "url": "/docs/compare/?release=18.2#18.2-449ed1ba9b72a08e", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "d454fc992715ec69f11869ffab65efab", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复 CTE 查询中 MERGE 的触发器过渡表捕获问题", "evidence": {"same_day": true, "patch_ids": ["9cb7a95ca83cc42e1b56a8fbc492d52e"], "statement_hash": "66d5665f7806451842ea09bab53ec96bcabb424e0cd66ec57fdd516b027ac4f9"}, "url": "/docs/compare/?release=17.8#17.8-a05a36b6df4c6b60", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "d4a6c61bfb31b9d9da04d2ea0c6cf39b", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复 CTE 查询中 MERGE 的触发器过渡表捕获问题", "evidence": {"same_day": true, "patch_ids": ["9cb7a95ca83cc42e1b56a8fbc492d52e"], "statement_hash": "66d5665f7806451842ea09bab53ec96bcabb424e0cd66ec57fdd516b027ac4f9"}, "url": "/docs/compare/?release=16.12#16.12-224692435a938225", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}]}, {"id": "15.16-fc6e34c9815a3a0c", "cves": [], "html": "<p>修复当分区目标表的所有子表在 UPDATE 或 DELETE 操作中都被剪枝时的失败问题（Amit Langote）<a href=\"https://postgr.es/c/687533b39\">§</a></p>\n<p>在这种情况下，执行器可能报告 <span>“<span>could not find junk ctid column</span>”</span> 错误，即使实际上无需执行任何操作。</p>", "text": "修复当分区目标表的所有子表在 UPDATE 或 DELETE 操作中都被剪枝时的失败问题（Amit Langote）§ 在这种情况下，执行器可能报告 “could not find junk ctid column” 错误，即使实际上无需执行任何操作。", "title": "修复当分区目标表的所有子表在 UPDATE 或 DELETE 操作中都被剪枝时的失败问题", "commits": ["687533b39"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "46a1d047b6461ac78a819f12a5fd42d39690959f92359d1d37ef800825fbfc4a", "section_path": ["变更"], "commit_groups": [["687533b39", "6d2fa44d2", "933f67fb6", "9f4b7bfc5", "f9a468c66", "fab386f74"]], "identity_text": "Fix failure when all children of a partitioned target table of an update or delete have been pruned (Amit Langote) In such cases, the executor could report could not find junk ctid column errors, even though nothing needs to be done.", "commit_aliases": ["687533b39", "6d2fa44d2", "933f67fb6", "9f4b7bfc5", "f9a468c66", "fab386f74"], "source_commits": ["687533b39"], "source_entry_id": "15.16/changes/007", "db_id": "179b2113d34cec63f6ed7d3339773014", "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3", "relations": [{"rule": 2, "type": "equivalent", "target": "4ced629daa2801c0202dec91097dd571", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}}, {"rule": 2, "type": "equivalent", "target": "63da9c3d80fbdcaacf4a6c8e130df7a3", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}}, {"rule": 2, "type": "equivalent", "target": "7a4315af35989c84209f54d435f1bc39", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}}, {"rule": 2, "type": "equivalent", "target": "f4b5a0c770a80f36d1c78eef1f635128", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f4b5a0c770a80f36d1c78eef1f635128", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复当分区目标表的所有子表在 UPDATE 或 DELETE 操作中都被剪枝时的失败问题", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}, "url": "/docs/compare/?release=18.2#18.2-6f5d6058ff3801ed", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "63da9c3d80fbdcaacf4a6c8e130df7a3", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复当分区目标表的所有子表在 UPDATE 或 DELETE 操作中都被剪枝时的失败问题", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}, "url": "/docs/compare/?release=17.8#17.8-47d93f8afe450b73", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "7a4315af35989c84209f54d435f1bc39", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复当分区目标表的所有子表在 UPDATE 或 DELETE 操作中都被剪枝时的失败问题", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}, "url": "/docs/compare/?release=16.12#16.12-4f022f27b3f533c3", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "4ced629daa2801c0202dec91097dd571", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复当分区目标表的所有子表在 UPDATE 或 DELETE 操作中都被剪枝时的失败问题", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}, "url": "/docs/compare/?release=14.21#14.21-807fef0437b28900", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-818eabd46b773ca1", "cves": [], "html": "<p>允许在部分 hash 索引上进行索引扫描，即使索引的谓词蕴含 WHERE 子句的真值（Tom Lane）<a href=\"https://postgr.es/c/f19502f04\">§</a></p>\n<p>通常我们会删除被谓词蕴含的 WHERE 子句，因为测试它没有意义——对于每个索引条目，该条件必然成立。然而，如果索引是需要在前导索引键上有 WHERE 子句的类型（如 hash 索引），这样做可能阻止创建索引扫描计划。在考虑此类索引时，不要删除被蕴含的子句。</p>", "text": "允许在部分 hash 索引上进行索引扫描，即使索引的谓词蕴含 WHERE 子句的真值（Tom Lane）§ 通常我们会删除被谓词蕴含的 WHERE 子句，因为测试它没有意义——对于每个索引条目，该条件必然成立。然而，如果索引是需要在前导索引键上有 WHERE 子句的类型（如 hash 索引），这样做可能阻止创建索引扫描计划。在考虑此类索引时，不要删除被蕴含的子句。", "title": "允许在部分 hash 索引上进行索引扫描，即使索引的谓词蕴含 WHERE 子句的真值", "commits": ["f19502f04"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "1478bf6398405397a5f5b05c225db0fbfd098fe740128f6edff994a4aab95373", "section_path": ["变更"], "commit_groups": [["5528e8d10", "9e77323fc", "a212877dc", "b497766a8", "e79b27662", "f19502f04"]], "identity_text": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause (Tom Lane) Normally we drop a WHERE clause that is implied by the predicate, since it's pointless to test it; it must hold for every index entry. However that can prevent creation of an indexscan plan if the index is one that requires a WHERE clause on the leading index key, as hash indexes do. Don't drop implied clauses when considering such an index.", "commit_aliases": ["5528e8d10", "9e77323fc", "a212877dc", "b497766a8", "e79b27662", "f19502f04"], "source_commits": ["f19502f04"], "source_entry_id": "15.16/changes/008", "db_id": "b1cd37aac266a35b85d498fbf852a341", "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac", "relations": [{"rule": 2, "type": "equivalent", "target": "46491fe43c6b06ae0b36463bb9ec508d", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}}, {"rule": 2, "type": "equivalent", "target": "be90b044d06ac445fb5ba563113882da", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}}, {"rule": 2, "type": "equivalent", "target": "ed2a57d1a47eb0ac687c6d995081429b", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}}, {"rule": 2, "type": "equivalent", "target": "f2b4b6b2c2b28f97888464f6ce6ad3fa", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed2a57d1a47eb0ac687c6d995081429b", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "允许在部分 hash 索引上进行索引扫描，即使索引的谓词蕴含 WHERE 子句的真值", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}, "url": "/docs/compare/?release=18.2#18.2-61e225cdb2ce1f36", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "46491fe43c6b06ae0b36463bb9ec508d", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "允许在部分 hash 索引上进行索引扫描，即使索引的谓词蕴含 WHERE 子句的真值", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}, "url": "/docs/compare/?release=17.8#17.8-845083cdcffc5df5", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "be90b044d06ac445fb5ba563113882da", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "允许在部分 hash 索引上进行索引扫描，即使索引的谓词蕴含 WHERE 子句的真值", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}, "url": "/docs/compare/?release=16.12#16.12-576930101da7e4de", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "f2b4b6b2c2b28f97888464f6ce6ad3fa", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "允许在部分 hash 索引上进行索引扫描，即使索引的谓词蕴含 WHERE 子句的真值", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}, "url": "/docs/compare/?release=14.21#14.21-a5950a5bc8025cc6", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-a50c7a9a9c1966f8", "cves": [], "html": "<p>不要为不记录 WAL 的 BRIN 索引生成 WAL（Kirill Reshke）<a href=\"https://postgr.es/c/460d97020\">§</a></p>\n<p>一条很少执行到的代码路径错误地为 BRIN 索引生成了 WAL 记录，即使该索引被标记为不记录 WAL。崩溃恢复时将无法重放该记录，并报告文件已存在的错误。</p>", "text": "不要为不记录 WAL 的 BRIN 索引生成 WAL（Kirill Reshke）§ 一条很少执行到的代码路径错误地为 BRIN 索引生成了 WAL 记录，即使该索引被标记为不记录 WAL。崩溃恢复时将无法重放该记录，并报告文件已存在的错误。", "title": "不要为不记录 WAL 的 BRIN 索引生成 WAL", "commits": ["460d97020"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "863d4705761a03f2ea660f22a367e7922cd2712f32e7cddc384350b3cbd751ea", "section_path": ["变更"], "commit_groups": [["460d97020", "4b6d096a0", "951b60f7a", "a5277700e", "ab4256869", "d77a5f981"]], "identity_text": "Do not emit WAL for unlogged BRIN indexes (Kirill Reshke) One seldom-taken code path incorrectly emitted a WAL record relating to a BRIN index even if the index was marked unlogged. Crash recovery would then fail to replay that record, complaining that the file already exists.", "commit_aliases": ["460d97020", "4b6d096a0", "951b60f7a", "a5277700e", "ab4256869", "d77a5f981"], "source_commits": ["460d97020"], "source_entry_id": "15.16/changes/009", "db_id": "5e595f6d6c44016c34bfdd305d261a1f", "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f", "relations": [{"rule": 2, "type": "equivalent", "target": "0937f4c4aaa8ff37a519ed8e315b4268", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}}, {"rule": 2, "type": "equivalent", "target": "293acf13040f24b30864b10bd699a3a0", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}}, {"rule": 2, "type": "equivalent", "target": "a7d18f384393c9a111537f87704719de", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}}, {"rule": 2, "type": "equivalent", "target": "e2905bab9de145b119d05715dee49169", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "0937f4c4aaa8ff37a519ed8e315b4268", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "不要为不记录 WAL 的 BRIN 索引生成 WAL", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}, "url": "/docs/compare/?release=18.2#18.2-569b26ba06e60ceb", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "293acf13040f24b30864b10bd699a3a0", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "不要为不记录 WAL 的 BRIN 索引生成 WAL", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}, "url": "/docs/compare/?release=17.8#17.8-91a20d38e502ab15", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "a7d18f384393c9a111537f87704719de", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "不要为不记录 WAL 的 BRIN 索引生成 WAL", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}, "url": "/docs/compare/?release=16.12#16.12-1d78fb1ed6b323ce", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "e2905bab9de145b119d05715dee49169", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "不要为不记录 WAL 的 BRIN 索引生成 WAL", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}, "url": "/docs/compare/?release=14.21#14.21-7a0553ecbce106c9", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-33cc5dd7a3fa872f", "cves": [], "html": "<p>防止截断未读 <code>NOTIFY</code> 消息仍然需要的 CLOG（Joel Jacobson，Heikki Linnakangas）<a href=\"https://postgr.es/c/1a469d7b5\">§</a> <a href=\"https://postgr.es/c/0c862646c\">§</a> <a href=\"https://postgr.es/c/21a9014cf\">§</a></p>\n<p>此修复防止了当后端进程吸收 <code>NOTIFY</code> 消息较慢时出现的 <span>“<span>could not access status of transaction</span>”</span> 错误。</p>", "text": "防止截断未读 NOTIFY 消息仍然需要的 CLOG（Joel Jacobson，Heikki Linnakangas）§ § § 此修复防止了当后端进程吸收 NOTIFY 消息较慢时出现的 “could not access status of transaction” 错误。", "title": "防止截断未读 NOTIFY 消息仍然需要的 CLOG", "commits": ["0c862646c", "1a469d7b5", "21a9014cf"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "d85c42cf117fed71d149a12dcfc0ea81e1764929ec810c95e194e45216bb5801", "section_path": ["变更"], "commit_groups": [["053e1868b", "1a469d7b5", "321ec5462", "8eeb4a0f7", "d02c03ddc", "eba917d36"], ["0bdc777e8", "0e8eaa218", "21a9014cf", "82fa6b78d", "84f1bf4af", "d80d5f099"], ["0c862646c", "44e8c60be", "797e9ea6e", "7b069a187", "c2682810a", "c2e58c071"]], "identity_text": "Prevent truncation of CLOG that is still needed by unread NOTIFY messages (Joel Jacobson, Heikki Linnakangas) This fix prevents could not access status of transaction errors when a backend is slow to absorb NOTIFY messages.", "commit_aliases": ["053e1868b", "0bdc777e8", "0c862646c", "0e8eaa218", "1a469d7b5", "21a9014cf", "321ec5462", "44e8c60be", "797e9ea6e", "7b069a187", "82fa6b78d", "84f1bf4af", "8eeb4a0f7", "c2682810a", "c2e58c071", "d02c03ddc", "d80d5f099", "eba917d36"], "source_commits": ["0c862646c", "1a469d7b5", "21a9014cf"], "source_entry_id": "15.16/changes/010", "db_id": "fc6cc5e241bcf4f346b4c240b4ebb59c", "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36", "relations": [{"rule": 2, "type": "equivalent", "target": "51e86dfcb154e6afc9dffcc36abdfb81", "evidence": {"same_day": true, "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36"}}, {"rule": 2, "type": "equivalent", "target": "9ff198dcfbb11c56f5a356cc045a2e21", "evidence": {"same_day": true, "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36"}}, {"rule": 2, "type": "equivalent", "target": "b59bb775aaba7282f555785a3372d9b7", "evidence": {"same_day": true, "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36"}}, {"rule": 2, "type": "equivalent", "target": "b91addf2aa923755ae6d33001e1ecedf", "evidence": {"same_day": true, "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "9ff198dcfbb11c56f5a356cc045a2e21", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "防止截断未读 NOTIFY 消息仍然需要的 CLOG", "evidence": {"same_day": true, "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36"}, "url": "/docs/compare/?release=18.2#18.2-0a2a82e68a475c0b", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "b59bb775aaba7282f555785a3372d9b7", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "防止截断未读 NOTIFY 消息仍然需要的 CLOG", "evidence": {"same_day": true, "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36"}, "url": "/docs/compare/?release=17.8#17.8-4391ac8372980d16", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "b91addf2aa923755ae6d33001e1ecedf", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "防止截断未读 NOTIFY 消息仍然需要的 CLOG", "evidence": {"same_day": true, "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36"}, "url": "/docs/compare/?release=16.12#16.12-c24c02cc9ffbeaa4", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "51e86dfcb154e6afc9dffcc36abdfb81", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "防止截断未读 NOTIFY 消息仍然需要的 CLOG", "evidence": {"same_day": true, "patch_ids": ["049c4c1146a404bda2c88a886f6a54f5", "2e0dbedb2008ef722d72cb29c205b12b", "f451d1b52bfa95906c50f2afbd378177"], "statement_hash": "5649a8930d269e6b71be2eb73aebd23736ffad2e22f4acbfe83ddfebe1ce9f36"}, "url": "/docs/compare/?release=14.21#14.21-e468ab28720aedd2", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-46172f9fd6222d05", "cves": [], "html": "<p>将 <code>NOTIFY</code> 消息处理期间发生的错误升级为 FATAL，即关闭连接（Heikki Linnakangas）<a href=\"https://postgr.es/c/b1da37de2\">§</a></p>\n<p>以前，如果后端在吸收 <code>NOTIFY</code> 消息时遇到错误，它会跳过该消息，向客户端报告错误，然后继续运行。但这种行为存在很多问题。一个主要问题是，客户端没有好的方法来知道通知丢失了，更无法知道通知的内容是什么。根据应用逻辑的不同，错过一条通知可能导致应用程序卡在等待状态。此外，剩余的消息在有人发送新的 <code>NOTIFY</code> 之前不会被处理。</p>\n<p>另外，如果连接在接收到 <code>NOTIFY</code> 信号时处于空闲状态，由于无关的原因，任何 ERROR 都会被升级为 FATAL。因此，我们选择在所有情况下都这样做，以保持一致性，并向应用程序提供一个明确的信号，表明它可能错过了一些通知。</p>", "text": "将 NOTIFY 消息处理期间发生的错误升级为 FATAL，即关闭连接（Heikki Linnakangas）§ 以前，如果后端在吸收 NOTIFY 消息时遇到错误，它会跳过该消息，向客户端报告错误，然后继续运行。但这种行为存在很多问题。一个主要问题是，客户端没有好的方法来知道通知丢失了，更无法知道通知的内容是什么。根据应用逻辑的不同，错过一条通知可能导致应用程序卡在等待状态。此外，剩余的消息在有人发送新的 NOTIFY 之前不会被处理。 另外，如果连接在接收到 NOTIFY 信号时处于空闲状态，由于无关的原因，任何 ERROR 都会被升级为 FATAL。因此，我们选择在所有情况下都这样做，以保持一致性，并向应用程序提供一个明确的信号，表明它可能错过了一些通知。", "title": "将 NOTIFY 消息处理期间发生的错误升级为 FATAL，即关闭连接", "commits": ["b1da37de2"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "807ab1df84eb2b03e4d0878dd53bdda53ffbadb563cc1d468d57a6f958bf8c5b", "section_path": ["变更"], "commit_groups": [["1b4699090", "7cb05dd2d", "aab4a84bb", "b1da37de2", "b821c9292", "c1a5bde00"]], "identity_text": "Escalate errors occurring during NOTIFY message processing to FATAL, i.e. close the connection (Heikki Linnakangas) Formerly, if a backend got an error while absorbing a NOTIFY message, it would advance past that message, report the error to the client, and move on. That behavior was fraught with problems though. One big concern is that the client has no good way to know that a notification was lost, and certainly no way to know what was in it. Depending on the application logic, missing a notification could cause the application to get stuck waiting, for example. Also, any remaining messages would not get processed until someone sent a new NOTIFY. Also, if the connection is idle at the time of receiving a NOTIFY signal, any ERROR would be escalated to FATAL anyway, due to unrelated concerns. Therefore, we've chosen to make that happen in all cases, for consistency and to provide a clear signal to the application that it might have missed some notifications.", "commit_aliases": ["1b4699090", "7cb05dd2d", "aab4a84bb", "b1da37de2", "b821c9292", "c1a5bde00"], "source_commits": ["b1da37de2"], "source_entry_id": "15.16/changes/011", "db_id": "340f3cdce36c643b1f14a964c498f497", "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343", "relations": [{"rule": 2, "type": "equivalent", "target": "2578b5de351f2e0a0f1cb1385293acf1", "evidence": {"same_day": true, "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343"}}, {"rule": 2, "type": "equivalent", "target": "2b671b11e767f32199661c5675739435", "evidence": {"same_day": true, "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343"}}, {"rule": 2, "type": "equivalent", "target": "a44a10f8650876c478bd97a4096ffb22", "evidence": {"same_day": true, "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343"}}, {"rule": 2, "type": "equivalent", "target": "d4ce5365c9cfca02e6db88e5179af61a", "evidence": {"same_day": true, "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "2578b5de351f2e0a0f1cb1385293acf1", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "将 NOTIFY 消息处理期间发生的错误升级为 FATAL，即关闭连接", "evidence": {"same_day": true, "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343"}, "url": "/docs/compare/?release=18.2#18.2-073ea8d2455d251d", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "a44a10f8650876c478bd97a4096ffb22", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "将 NOTIFY 消息处理期间发生的错误升级为 FATAL，即关闭连接", "evidence": {"same_day": true, "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343"}, "url": "/docs/compare/?release=17.8#17.8-9232f0a43f14d80d", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "2b671b11e767f32199661c5675739435", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "将 NOTIFY 消息处理期间发生的错误升级为 FATAL，即关闭连接", "evidence": {"same_day": true, "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343"}, "url": "/docs/compare/?release=16.12#16.12-29d9c9d4dad68ed2", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "d4ce5365c9cfca02e6db88e5179af61a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "将 NOTIFY 消息处理期间发生的错误升级为 FATAL，即关闭连接", "evidence": {"same_day": true, "patch_ids": ["4e4c8262cf4b59a9a0c02b859c31ba93"], "statement_hash": "205197bc16f626c3fb09afea881f30f8da7d367c145557afffb3084d4cb8e343"}, "url": "/docs/compare/?release=14.21#14.21-01ee61ebe13f940a", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-2115d7c9b8824ad6", "cves": [], "html": "<p>修复在锁定元组时跟踪更新链的错误（Jasper Smit）<a href=\"https://postgr.es/c/5d5487cd2\">§</a></p>\n<p>此代码路径忽略了检查更新链中第一个新元组的 xmin，使得在原始更新者中止且空间被 <code>VACUUM</code> 立即回收并重新使用的情况下，可能会锁定一个不相关的元组。这可能导致意外的事务延迟或死锁。与识别到错误元组相关的错误也已被观察到。</p>", "text": "修复在锁定元组时跟踪更新链的错误（Jasper Smit）§ 此代码路径忽略了检查更新链中第一个新元组的 xmin，使得在原始更新者中止且空间被 VACUUM 立即回收并重新使用的情况下，可能会锁定一个不相关的元组。这可能导致意外的事务延迟或死锁。与识别到错误元组相关的错误也已被观察到。", "title": "修复在锁定元组时跟踪更新链的错误", "commits": ["5d5487cd2"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "8b81a71160f195ca971a9f98c8c086e73d516f3441a737446d0da35617b36a1a", "section_path": ["变更"], "commit_groups": [["3e3a80f62", "5d5487cd2", "7efef18ff", "955f55068", "b6201c76e", "bb87d7fef"]], "identity_text": "Fix bug in following update chain when locking a tuple (Jasper Smit) This code path neglected to check the xmin of the first new tuple in the update chain, making it possible to lock an unrelated tuple if the original updater aborted and the space was immediately reclaimed by VACUUM and then re-used. That could cause unexpected transaction delays or deadlocks. Errors associated with having identified the wrong tuple have also been observed.", "commit_aliases": ["3e3a80f62", "5d5487cd2", "7efef18ff", "955f55068", "b6201c76e", "bb87d7fef"], "source_commits": ["5d5487cd2"], "source_entry_id": "15.16/changes/012", "db_id": "814dec09a6214d7245a3c0e86beb4e1d", "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1", "relations": [{"rule": 2, "type": "equivalent", "target": "4f4cdca5150cc29cfd55ff6bd60fa8f1", "evidence": {"same_day": true, "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1"}}, {"rule": 2, "type": "equivalent", "target": "5ccdb2c39df1f114f475423eacc2efdd", "evidence": {"same_day": true, "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1"}}, {"rule": 2, "type": "equivalent", "target": "8954f19da0659a10c8106e76f12e9ccc", "evidence": {"same_day": true, "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1"}}, {"rule": 2, "type": "equivalent", "target": "d4cc08cb8b81ba921b2e9bc0318b23a2", "evidence": {"same_day": true, "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d4cc08cb8b81ba921b2e9bc0318b23a2", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复在锁定元组时跟踪更新链的错误", "evidence": {"same_day": true, "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1"}, "url": "/docs/compare/?release=18.2#18.2-96ad5c05e88ce8b6", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "8954f19da0659a10c8106e76f12e9ccc", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复在锁定元组时跟踪更新链的错误", "evidence": {"same_day": true, "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1"}, "url": "/docs/compare/?release=17.8#17.8-50532778c9796546", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "5ccdb2c39df1f114f475423eacc2efdd", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复在锁定元组时跟踪更新链的错误", "evidence": {"same_day": true, "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1"}, "url": "/docs/compare/?release=16.12#16.12-1952a802cdfdf415", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "4f4cdca5150cc29cfd55ff6bd60fa8f1", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复在锁定元组时跟踪更新链的错误", "evidence": {"same_day": true, "patch_ids": ["e3dafdb5e648603a0ea08c3d21ee84d7"], "statement_hash": "ae47dc62dd8aef911c4966b610546ed3a91d32ad6ba6e73105bd7411263a30d1"}, "url": "/docs/compare/?release=14.21#14.21-c0f9814f19f729ee", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-3bb47161eed5f310", "cves": [], "html": "<p>修复原地更新系统目录时的问题（Noah Misch）<a href=\"https://postgr.es/c/0f69bedde\">§</a> <a href=\"https://postgr.es/c/d3e5d8950\">§</a> <a href=\"https://postgr.es/c/bcb784e7d\">§</a></p>\n<p>对于原地更新，发送非事务性的失效消息，因为此类更新在事务回滚后仍会保留。同时，确保该更新在其他会话可见之前已经写入 WAL。这些修复主要防止关系的 frozen-XID 属性出现不一致，从而避免 CLOG 被过早截断并随后出现 <span>“<span>could not access status of transaction</span>”</span> 错误。</p>", "text": "修复原地更新系统目录时的问题（Noah Misch）§ § § 对于原地更新，发送非事务性的失效消息，因为此类更新在事务回滚后仍会保留。同时，确保该更新在其他会话可见之前已经写入 WAL。这些修复主要防止关系的 frozen-XID 属性出现不一致，从而避免 CLOG 被过早截断并随后出现 “could not access status of transaction” 错误。", "title": "修复原地更新系统目录时的问题", "commits": ["0f69bedde", "bcb784e7d", "d3e5d8950"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "8e4b79aa44d37c8088720f85d7deceb05ef701bdc6d2c6d68b7bec2a3746a5e1", "section_path": ["变更"], "commit_groups": [["05d605b6c", "0f69bedde", "1d7b02711", "811422471"], ["0dfbd191a", "27e4fad98", "86091202a", "bcb784e7d"], ["20a48c156", "720e9304f", "d3e5d8950", "e4b1986b9"]], "identity_text": "Fix issues around in-place catalog updates (Noah Misch) Send a nontransactional invalidation message for an in-place update, since such an update will survive transaction rollback. Also ensure that the update is WAL-logged before other sessions can see it. These fixes primarily prevent scenarios in which relations' frozen-XID attributes become inconsistent, possibly allowing premature CLOG truncation and subsequent could not access status of transaction errors.", "commit_aliases": ["05d605b6c", "0dfbd191a", "0f69bedde", "1d7b02711", "20a48c156", "27e4fad98", "720e9304f", "811422471", "86091202a", "bcb784e7d", "d3e5d8950", "e4b1986b9"], "source_commits": ["05d605b6c", "20a48c156", "86091202a"], "source_entry_id": "15.16/changes/013", "db_id": "1a1ca89a6f8b8a26e2fdc5c3adffee40", "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a", "relations": [{"rule": 2, "type": "equivalent", "target": "24d2c263d61d870ad15e04e37b9be312", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}}, {"rule": 2, "type": "equivalent", "target": "577989fe6b9f208495ce6a7ab6b002c6", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}}, {"rule": 2, "type": "equivalent", "target": "7e9c59cfc9b17218ff9e506d4b425a25", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "577989fe6b9f208495ce6a7ab6b002c6", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复原地更新系统目录时的问题", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}, "url": "/docs/compare/?release=17.8#17.8-3bb47161eed5f310", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "24d2c263d61d870ad15e04e37b9be312", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复原地更新系统目录时的问题", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}, "url": "/docs/compare/?release=16.12#16.12-3bb47161eed5f310", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "7e9c59cfc9b17218ff9e506d4b425a25", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复原地更新系统目录时的问题", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}, "url": "/docs/compare/?release=14.21#14.21-3bb47161eed5f310", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-4db75c5b481234d4", "cves": [], "html": "<p>修复后端进程在退出时由于尝试在已取消映射的共享内存段中释放锁而可能崩溃的问题（Rahila Syed）<a href=\"https://postgr.es/c/b926ff137\">§</a></p>", "text": "修复后端进程在退出时由于尝试在已取消映射的共享内存段中释放锁而可能崩溃的问题（Rahila Syed）§", "title": "修复后端进程在退出时由于尝试在已取消映射的共享内存段中释放锁而可能崩溃的问题", "commits": ["b926ff137"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "63b81fa5065c2e020e922ac54923eee3e2f9be4a6bd9102015edd704a3fffb9b", "section_path": ["变更"], "commit_groups": [["1943ceb38", "4071fe900", "980b7c736", "9cbb1d21d", "b926ff137", "f6df78173"]], "identity_text": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment (Rahila Syed)", "commit_aliases": ["1943ceb38", "4071fe900", "980b7c736", "9cbb1d21d", "b926ff137", "f6df78173"], "source_commits": ["b926ff137"], "source_entry_id": "15.16/changes/014", "db_id": "125f7282ee77b2dbf96db553539c22c4", "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3", "relations": [{"rule": 2, "type": "equivalent", "target": "45af7190ae2808ef37392b8f701626cf", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}}, {"rule": 2, "type": "equivalent", "target": "5ad3db5c0edaa4934f3f9d9b4709c52d", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}}, {"rule": 2, "type": "equivalent", "target": "7be6eebc70de0b6a710a45541a4092f0", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}}, {"rule": 2, "type": "equivalent", "target": "d2811b8c558ee3336f69ce2dee648262", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "5ad3db5c0edaa4934f3f9d9b4709c52d", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复后端进程在退出时由于尝试在已取消映射的共享内存段中释放锁而可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}, "url": "/docs/compare/?release=18.2#18.2-c5a2be58244ca433", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "d2811b8c558ee3336f69ce2dee648262", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复后端进程在退出时由于尝试在已取消映射的共享内存段中释放锁而可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}, "url": "/docs/compare/?release=17.8#17.8-ff65f3935e08be00", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "7be6eebc70de0b6a710a45541a4092f0", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复后端进程在退出时由于尝试在已取消映射的共享内存段中释放锁而可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}, "url": "/docs/compare/?release=16.12#16.12-a697dba42d12b45f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "45af7190ae2808ef37392b8f701626cf", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复后端进程在退出时由于尝试在已取消映射的共享内存段中释放锁而可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}, "url": "/docs/compare/?release=14.21#14.21-c6d749d8181b360c", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-1c33da61822d76af", "cves": [], "html": "<p>防止崩溃后多事务日志被错误截断（Heikki Linnakangas）<a href=\"https://postgr.es/c/a563ac619\">§</a></p>", "text": "防止崩溃后多事务日志被错误截断（Heikki Linnakangas）§", "title": "防止崩溃后多事务日志被错误截断", "commits": ["a563ac619"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "1505757b8ff66f4d38f412f7dd15d96ef05f4ff72d7c4fa1a778ae1d77bab589", "section_path": ["变更"], "commit_groups": [["09532a78b", "102bdaa9b", "46be454ca", "a563ac619", "c7946e6f3", "d3ad4cef6"]], "identity_text": "Guard against incorrect truncation of the multixact log after a crash (Heikki Linnakangas)", "commit_aliases": ["09532a78b", "102bdaa9b", "46be454ca", "a563ac619", "c7946e6f3", "d3ad4cef6"], "source_commits": ["a563ac619"], "source_entry_id": "15.16/changes/015", "db_id": "98b43daf45e235647020ad11a022bebb", "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad", "relations": [{"rule": 2, "type": "equivalent", "target": "06c8d0231b48925fde45dbbe5447711a", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}}, {"rule": 2, "type": "equivalent", "target": "3a7694cde691f1c0a64647d256362d79", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}}, {"rule": 2, "type": "equivalent", "target": "423a226c0afa155ba2f8b3bf4d809b9b", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}}, {"rule": 2, "type": "equivalent", "target": "543d98a0d64e54acd061d5327cda0d92", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "3a7694cde691f1c0a64647d256362d79", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "防止崩溃后多事务日志被错误截断", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}, "url": "/docs/compare/?release=18.2#18.2-8b23c352cad22240", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "423a226c0afa155ba2f8b3bf4d809b9b", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "防止崩溃后多事务日志被错误截断", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}, "url": "/docs/compare/?release=17.8#17.8-9e854c237f5aabf9", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "543d98a0d64e54acd061d5327cda0d92", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "防止崩溃后多事务日志被错误截断", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}, "url": "/docs/compare/?release=16.12#16.12-1dcc130cbed466e7", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "06c8d0231b48925fde45dbbe5447711a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "防止崩溃后多事务日志被错误截断", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}, "url": "/docs/compare/?release=14.21#14.21-82a8e8c00098deab", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-cd833dd2d455a71f", "cves": [], "html": "<p>修复 <code>pg_stat_get_backend_activity()</code> 可能返回编码错误的结果的问题（Chao Li）<a href=\"https://postgr.es/c/300575fe2\">§</a></p>\n<p>保存会话活动字符串的共享内存缓冲区末尾可能包含不完整的多字节字符。读取者应该截断掉任何此类不完整字符，但此函数未能做到这一点。</p>", "text": "修复 pg_stat_get_backend_activity() 可能返回编码错误的结果的问题（Chao Li）§ 保存会话活动字符串的共享内存缓冲区末尾可能包含不完整的多字节字符。读取者应该截断掉任何此类不完整字符，但此函数未能做到这一点。", "title": "修复 pg_stat_get_backend_activity() 可能返回编码错误的结果的问题", "commits": ["300575fe2"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "cc9a131807ced320c2d22b56b2952a0bd74de352445f0cf9b171a0fb07cbb780", "section_path": ["变更"], "commit_groups": [["06907e864", "300575fe2", "36b8f4974", "52b27f585", "c48829ed8", "ea3524cff"]], "identity_text": "Fix possibly mis-encoded result of pg_stat_get_backend_activity() (Chao Li) The shared-memory buffer holding a session's activity string can end with an incomplete multibyte character. Readers are supposed to truncate off any such incomplete character, but this function failed to do so.", "commit_aliases": ["06907e864", "300575fe2", "36b8f4974", "52b27f585", "c48829ed8", "ea3524cff"], "source_commits": ["300575fe2"], "source_entry_id": "15.16/changes/016", "db_id": "c6e97abc5a7f6b7dd2f4f8bbf960d054", "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178", "relations": [{"rule": 2, "type": "equivalent", "target": "1d61f99b846c4ede8289346c443c6eab", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}}, {"rule": 2, "type": "equivalent", "target": "2011af15ea6d97b67e6182e61860c8c7", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}}, {"rule": 2, "type": "equivalent", "target": "3fc6fbb291fd58ddb3732e1040a55913", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}}, {"rule": 2, "type": "equivalent", "target": "962171149258cdfb98c25d6f7cda03e4", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "2011af15ea6d97b67e6182e61860c8c7", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复 pg_stat_get_backend_activity() 可能返回编码错误的结果的问题", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}, "url": "/docs/compare/?release=18.2#18.2-08c685de487e23d3", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "962171149258cdfb98c25d6f7cda03e4", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复 pg_stat_get_backend_activity() 可能返回编码错误的结果的问题", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}, "url": "/docs/compare/?release=17.8#17.8-5b4587fee1692efc", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "3fc6fbb291fd58ddb3732e1040a55913", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复 pg_stat_get_backend_activity() 可能返回编码错误的结果的问题", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}, "url": "/docs/compare/?release=16.12#16.12-5dda0d4807cb6225", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "1d61f99b846c4ede8289346c443c6eab", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复 pg_stat_get_backend_activity() 可能返回编码错误的结果的问题", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}, "url": "/docs/compare/?release=14.21#14.21-e2ab71f43353e5cd", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-c5eabf46f29ea686", "cves": [], "html": "<p>防止递归的内存上下文日志记录（Fujii Masao）<a href=\"https://postgr.es/c/0fc2f533a\">§</a></p>\n<p>持续不断的请求内存上下文日志记录的信号流可能导致日志记录代码的递归执行，理论上可能导致栈溢出。</p>", "text": "防止递归的内存上下文日志记录（Fujii Masao）§ 持续不断的请求内存上下文日志记录的信号流可能导致日志记录代码的递归执行，理论上可能导致栈溢出。", "title": "防止递归的内存上下文日志记录", "commits": ["0fc2f533a"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "a13e14917c2ad443c1071a7424836caddac6b82a07e7e3f9b75d3cd15bd0a0a3", "section_path": ["变更"], "commit_groups": [["0fc2f533a", "1a9a49699", "3853f6168", "699293d27", "b3ccb0a2c", "b863d8d87"]], "identity_text": "Guard against recursive memory context logging (Fujii Masao) A constant flow of signals requesting memory context logging could cause recursive execution of the logging code, which in theory could lead to stack overflow.", "commit_aliases": ["0fc2f533a", "1a9a49699", "3853f6168", "699293d27", "b3ccb0a2c", "b863d8d87"], "source_commits": ["0fc2f533a"], "source_entry_id": "15.16/changes/017", "db_id": "6911fcfb9b3a10c2cb527c328b7e80dd", "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4", "relations": [{"rule": 2, "type": "equivalent", "target": "69b5630e62f581864e385c3537959829", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}}, {"rule": 2, "type": "equivalent", "target": "76d6a4cdde5956fd5fdf83af6a0f6953", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}}, {"rule": 2, "type": "equivalent", "target": "cdc054743d9f7923ca54a8a0dd5eba4d", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}}, {"rule": 2, "type": "equivalent", "target": "e532d3e562a8bcd039083d7610c4fe02", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e532d3e562a8bcd039083d7610c4fe02", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "防止递归的内存上下文日志记录", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}, "url": "/docs/compare/?release=18.2#18.2-92cabc87c606add7", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "76d6a4cdde5956fd5fdf83af6a0f6953", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "防止递归的内存上下文日志记录", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}, "url": "/docs/compare/?release=17.8#17.8-a1b611399d727246", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "cdc054743d9f7923ca54a8a0dd5eba4d", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "防止递归的内存上下文日志记录", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}, "url": "/docs/compare/?release=16.12#16.12-2616fc2b052bb88f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "69b5630e62f581864e385c3537959829", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "防止递归的内存上下文日志记录", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}, "url": "/docs/compare/?release=14.21#14.21-0397158066e277a7", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-d2b6dee5909338ef", "cves": [], "html": "<p>修复重新初始化并行执行上下文时的内存上下文使用问题（Jakub Wartak，Jeevan Chalke）<a href=\"https://postgr.es/c/bd2726d3e\">§</a></p>\n<p>此错误可能由于附属数据结构的生命周期比并行上下文更短而导致崩溃。目前尚未发现仅使用 <span>PostgreSQL</span> 核心就能触发该问题的情况，但我们收到了扩展中出现问题的报告。</p>", "text": "修复重新初始化并行执行上下文时的内存上下文使用问题（Jakub Wartak，Jeevan Chalke）§ 此错误可能由于附属数据结构的生命周期比并行上下文更短而导致崩溃。目前尚未发现仅使用 PostgreSQL 核心就能触发该问题的情况，但我们收到了扩展中出现问题的报告。", "title": "修复重新初始化并行执行上下文时的内存上下文使用问题", "commits": ["bd2726d3e"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "0fee6af680f7f005af308eb548f7e49e6e0e76d974fede362ec64a4dac884e3b", "section_path": ["变更"], "commit_groups": [["12c2f843c", "1d0fc2499", "1d9f7fbba", "57df5ab80", "bd2726d3e", "f1a6e622b"]], "identity_text": "Fix memory context usage when reinitializing a parallel execution context (Jakub Wartak, Jeevan Chalke) This error could result in a crash due to a subsidiary data structure having a shorter lifespan than the parallel context. The problem is not known to be reachable using only core PostgreSQL, but we have reports of trouble in extensions.", "commit_aliases": ["12c2f843c", "1d0fc2499", "1d9f7fbba", "57df5ab80", "bd2726d3e", "f1a6e622b"], "source_commits": ["bd2726d3e"], "source_entry_id": "15.16/changes/018", "db_id": "82f0fec30baf25cedac6f47fedd86a1a", "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0", "relations": [{"rule": 2, "type": "equivalent", "target": "0e538a4d4cac5aac8cab0d86cc46e6d8", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}}, {"rule": 2, "type": "equivalent", "target": "770932eb6650d49472c43e2db5c83969", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}}, {"rule": 2, "type": "equivalent", "target": "a0538505db5e86d813d403a8571068b8", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}}, {"rule": 2, "type": "equivalent", "target": "c0e0fccdb1ff80df5a7c450903b3c742", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a0538505db5e86d813d403a8571068b8", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复重新初始化并行执行上下文时的内存上下文使用问题", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}, "url": "/docs/compare/?release=18.2#18.2-f56daebc6196999a", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "c0e0fccdb1ff80df5a7c450903b3c742", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复重新初始化并行执行上下文时的内存上下文使用问题", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}, "url": "/docs/compare/?release=17.8#17.8-cdcf22c5f5200747", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "0e538a4d4cac5aac8cab0d86cc46e6d8", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复重新初始化并行执行上下文时的内存上下文使用问题", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}, "url": "/docs/compare/?release=16.12#16.12-9d7bd150ce599d54", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "770932eb6650d49472c43e2db5c83969", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复重新初始化并行执行上下文时的内存上下文使用问题", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}, "url": "/docs/compare/?release=14.21#14.21-06477385d1974f88", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-639bc1c588a62efb", "cves": [], "html": "<p>在创建新的多事务 ID 时设置下一个多事务 ID 的偏移量，以消除在边界情况下所需的等待循环（Andrey Borodin）<a href=\"https://postgr.es/c/8cfb174a6\">§</a> <a href=\"https://postgr.es/c/b9a02b978\">§</a></p>\n<p>之前的逻辑可能会卡在等待一个永远不会发生的更新上。</p>", "text": "在创建新的多事务 ID 时设置下一个多事务 ID 的偏移量，以消除在边界情况下所需的等待循环（Andrey Borodin）§ § 之前的逻辑可能会卡在等待一个永远不会发生的更新上。", "title": "在创建新的多事务 ID 时设置下一个多事务 ID 的偏移量，以消除在边界情况下所需的等待循环", "commits": ["8cfb174a6", "b9a02b978"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "1e99c477ea99114a14a182497cd175d0a2c7bfab852a922e553770a22184a216", "section_path": ["变更"], "commit_groups": [["02ba5e3be", "489695554", "4d689a176", "4d936c3ff", "b9a02b978", "cad40cec2"], ["635166913", "789d65364", "81416e101", "8ba61bc06", "8cfb174a6", "e46041fd9"]], "identity_text": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases (Andrey Borodin) The previous logic could get stuck waiting for an update that would never occur.", "commit_aliases": ["02ba5e3be", "489695554", "4d689a176", "4d936c3ff", "635166913", "789d65364", "81416e101", "8ba61bc06", "8cfb174a6", "b9a02b978", "cad40cec2", "e46041fd9"], "source_commits": ["8cfb174a6", "b9a02b978"], "source_entry_id": "15.16/changes/019", "db_id": "2b4c07606e0901ac70bb0fbb4680ebbe", "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d", "relations": [{"rule": 2, "type": "equivalent", "target": "1d8beb2475d7ec3ee5619d442f62f4e4", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}}, {"rule": 2, "type": "equivalent", "target": "9d39be361a73eeb011b1508852d458c4", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}}, {"rule": 2, "type": "equivalent", "target": "df073012abdc28126571ebecafb9c308", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}}, {"rule": 2, "type": "equivalent", "target": "fff819d80d05a70e4ebf82ab7f9c951a", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "9d39be361a73eeb011b1508852d458c4", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "在创建新的多事务 ID 时设置下一个多事务 ID 的偏移量，以消除在边界情况下所需的等待循环", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}, "url": "/docs/compare/?release=18.2#18.2-0eb611cc5bc18380", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "df073012abdc28126571ebecafb9c308", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "在创建新的多事务 ID 时设置下一个多事务 ID 的偏移量，以消除在边界情况下所需的等待循环", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}, "url": "/docs/compare/?release=17.8#17.8-351e263e26b0031c", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "1d8beb2475d7ec3ee5619d442f62f4e4", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "在创建新的多事务 ID 时设置下一个多事务 ID 的偏移量，以消除在边界情况下所需的等待循环", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}, "url": "/docs/compare/?release=16.12#16.12-90168bc8332f7a84", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "fff819d80d05a70e4ebf82ab7f9c951a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "在创建新的多事务 ID 时设置下一个多事务 ID 的偏移量，以消除在边界情况下所需的等待循环", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}, "url": "/docs/compare/?release=14.21#14.21-fc1711f590b7a7c5", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-fdb06078edbce9e9", "cves": [], "html": "<p>避免多次重写数据修改 CTE（Bernice Southey，Dean Rasheed）<a href=\"https://postgr.es/c/134a8ee22\">§</a></p>\n<p>以前，在更新自动可更新视图或带规则的关系时，如果原始查询含有数据修改 CTE，重写器会由于递归而多次重写这些 CTE。这不仅低效，而且当 CTE 包含对GENERATED ALWAYS 列的更新时可能产生虚假错误。</p>", "text": "避免多次重写数据修改 CTE（Bernice Southey，Dean Rasheed）§ 以前，在更新自动可更新视图或带规则的关系时，如果原始查询含有数据修改 CTE，重写器会由于递归而多次重写这些 CTE。这不仅低效，而且当 CTE 包含对GENERATED ALWAYS 列的更新时可能产生虚假错误。", "title": "避免多次重写数据修改 CTE", "commits": ["134a8ee22"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "829592d3da46613790fbc69ac2ffd62344d1a544b9f8fec96936df6ad3696c27", "section_path": ["变更"], "commit_groups": [["134a8ee22", "2d5b97b8c", "3881561d7", "4d288e33b", "b880d9a02", "c09096503"]], "identity_text": "Avoid rewriting data-modifying CTEs more than once (Bernice Southey, Dean Rasheed) Formerly, when updating an auto-updatable view or a relation with rules, if the original query had any data-modifying CTEs, the rewriter would rewrite those CTEs multiple times due to recursion. This was inefficient and could produce false errors if a CTE included an update of an always-generated column.", "commit_aliases": ["134a8ee22", "2d5b97b8c", "3881561d7", "4d288e33b", "b880d9a02", "c09096503"], "source_commits": ["134a8ee22"], "source_entry_id": "15.16/changes/020", "db_id": "fa9d76713707441eef7a725233377166", "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb", "relations": [{"rule": 2, "type": "equivalent", "target": "6e6c8a0f6889fba17b9d4ea6308a8d7a", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}}, {"rule": 2, "type": "equivalent", "target": "b1252119d1b5ac0ac5230ba9b7fb844b", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}}, {"rule": 2, "type": "equivalent", "target": "c9710e1b97bbf384a5536e25246c2c1e", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}}, {"rule": 2, "type": "equivalent", "target": "f467408bfd650872bf1654f4ee4ec70d", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b1252119d1b5ac0ac5230ba9b7fb844b", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "避免多次重写数据修改 CTE", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}, "url": "/docs/compare/?release=18.2#18.2-598e6b46a303e445", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "f467408bfd650872bf1654f4ee4ec70d", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "避免多次重写数据修改 CTE", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}, "url": "/docs/compare/?release=17.8#17.8-fed0bc33b201283d", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "c9710e1b97bbf384a5536e25246c2c1e", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "避免多次重写数据修改 CTE", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}, "url": "/docs/compare/?release=16.12#16.12-806ed942f9c5fd64", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "6e6c8a0f6889fba17b9d4ea6308a8d7a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "避免多次重写数据修改 CTE", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}, "url": "/docs/compare/?release=14.21#14.21-7e5820de57d7faff", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-61074b4b2db3b9f8", "cves": [], "html": "<p>如果 WAL 未涵盖检查点记录指示的重做点，则使恢复失败（Nitin Jadhav）<a href=\"https://postgr.es/c/95ef6f490\">§</a></p>\n<p>在开始恢复之前添加一个显式检查，以确保不会造成损害并提供有用的错误消息。以前，在这种情况下恢复可能会崩溃或损坏数据库。</p>", "text": "如果 WAL 未涵盖检查点记录指示的重做点，则使恢复失败（Nitin Jadhav）§ 在开始恢复之前添加一个显式检查，以确保不会造成损害并提供有用的错误消息。以前，在这种情况下恢复可能会崩溃或损坏数据库。", "title": "如果 WAL 未涵盖检查点记录指示的重做点，则使恢复失败", "commits": ["95ef6f490"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "84f67e887930c4401bfaac9db37b63623a9ccf18a8e16715e17cf78e5afffa86", "section_path": ["变更"], "commit_groups": [["14161bca4", "1aa57e9ed", "68ebdf2b0", "95ef6f490", "dc7c77f82", "f5927da4f"]], "identity_text": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record (Nitin Jadhav) Add an explicit check for this before starting recovery, so that no harm is done and a useful error message is provided. Previously, recovery might crash or corrupt the database in this situation.", "commit_aliases": ["14161bca4", "1aa57e9ed", "68ebdf2b0", "95ef6f490", "dc7c77f82", "f5927da4f"], "source_commits": ["95ef6f490"], "source_entry_id": "15.16/changes/021", "db_id": "ea5f140766dc7aa68dd175c861036247", "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034", "relations": [{"rule": 2, "type": "equivalent", "target": "011195db7fe270680db938124518987b", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}}, {"rule": 2, "type": "equivalent", "target": "3f4035b04c1c0e9ba08acef72e76fc91", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}}, {"rule": 2, "type": "equivalent", "target": "7e009c5e3ee2635f5a3f2d6750f1a823", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}}, {"rule": 2, "type": "equivalent", "target": "afebd143b96e516829ea82f80f213765", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "afebd143b96e516829ea82f80f213765", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "如果 WAL 未涵盖检查点记录指示的重做点，则使恢复失败", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}, "url": "/docs/compare/?release=18.2#18.2-48e29718af30085d", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "3f4035b04c1c0e9ba08acef72e76fc91", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "如果 WAL 未涵盖检查点记录指示的重做点，则使恢复失败", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}, "url": "/docs/compare/?release=17.8#17.8-3d4d2474ea729f43", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "7e009c5e3ee2635f5a3f2d6750f1a823", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "如果 WAL 未涵盖检查点记录指示的重做点，则使恢复失败", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}, "url": "/docs/compare/?release=16.12#16.12-ac8c469b0c901db5", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "011195db7fe270680db938124518987b", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "如果 WAL 未涵盖检查点记录指示的重做点，则使恢复失败", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}, "url": "/docs/compare/?release=14.21#14.21-c97498907e799420", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-a0b138a134556f43", "cves": [], "html": "<p>避免在 <code>ALTER PUBLICATION</code> 期间修改源查询树（Sunil S）<a href=\"https://postgr.es/c/f20b79059\">§</a></p>\n<p>此错误的可见效果是，为该查询触发的事件触发器只能看到第一个 <code>publish</code> 选项，即使指定了多个选项。如果此类查询被设置为预备语句，重新执行时也会出现错误行为。</p>", "text": "避免在 ALTER PUBLICATION 期间修改源查询树（Sunil S）§ 此错误的可见效果是，为该查询触发的事件触发器只能看到第一个 publish 选项，即使指定了多个选项。如果此类查询被设置为预备语句，重新执行时也会出现错误行为。", "title": "避免在 ALTER PUBLICATION 期间修改源查询树", "commits": ["f20b79059"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "b5d2911c39a08bf4c013e60d6922cf13af4f80c6555c7b94afce1ad4ff7a0c1b", "section_path": ["变更"], "commit_groups": [["0687a6eb0", "6ca8506ea", "ae45c7296", "bb08ac7ac", "bea57a6b4", "f20b79059"]], "identity_text": "Avoid scribbling on the source query tree during ALTER PUBLICATION (Sunil S) This error had the visible effect that an event trigger fired for the query would see only the first publish option, even if several had been specified. If such a query were set up as a prepared statement, re-executions would misbehave too.", "commit_aliases": ["0687a6eb0", "6ca8506ea", "ae45c7296", "bb08ac7ac", "bea57a6b4", "f20b79059"], "source_commits": ["f20b79059"], "source_entry_id": "15.16/changes/022", "db_id": "ef85167b2646b7c7d896a19a6abb3509", "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd", "relations": [{"rule": 2, "type": "equivalent", "target": "382e740a0f9f434506934984bfab5d72", "evidence": {"same_day": true, "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd"}}, {"rule": 2, "type": "equivalent", "target": "609a67b3d1e8a8770d3091b2429519a7", "evidence": {"same_day": true, "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd"}}, {"rule": 2, "type": "equivalent", "target": "7e3fc1d0791de552b876cdb2454f31d0", "evidence": {"same_day": true, "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd"}}, {"rule": 2, "type": "equivalent", "target": "bb090370862ac9b9ba54fb93b71c4869", "evidence": {"same_day": true, "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "7e3fc1d0791de552b876cdb2454f31d0", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "避免在 ALTER PUBLICATION 期间修改源查询树", "evidence": {"same_day": true, "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd"}, "url": "/docs/compare/?release=18.2#18.2-4ab1376a3267c027", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "bb090370862ac9b9ba54fb93b71c4869", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "避免在 ALTER PUBLICATION 期间修改源查询树", "evidence": {"same_day": true, "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd"}, "url": "/docs/compare/?release=17.8#17.8-51768104ffbbb8b1", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "609a67b3d1e8a8770d3091b2429519a7", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "避免在 ALTER PUBLICATION 期间修改源查询树", "evidence": {"same_day": true, "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd"}, "url": "/docs/compare/?release=16.12#16.12-0890dbb40db6c9be", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "382e740a0f9f434506934984bfab5d72", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "避免在 ALTER PUBLICATION 期间修改源查询树", "evidence": {"same_day": true, "patch_ids": ["27aaed0fd0399be3426c4d05cf88f583"], "statement_hash": "097d4d62aa891693f59702842928f93c4d533cb5aa5f4af54c5237246f6933dd"}, "url": "/docs/compare/?release=14.21#14.21-cf7993cc29f1125e", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-572c337cdeda5be4", "cves": [], "html": "<p>将 <code>CREATE SUBSCRIPTION ... CONNECTION</code> 中指定的连接选项传递给发布端的 walsender 进程（Fujii Masao）<a href=\"https://postgr.es/c/f7eb44e0f\">§</a></p>\n<p>在此修复之前，<code>options</code> 连接选项（如果有的话）会被忽略，因此，例如无法在 walsender 会话中设置自定义服务器参数值。该功能本应正常工作；在 <span>PostgreSQL</span> 15 中的重构破坏它之前，它也确实一直是正常工作的，因此这里恢复了先前的行为。</p>", "text": "将 CREATE SUBSCRIPTION ... CONNECTION 中指定的连接选项传递给发布端的 walsender 进程（Fujii Masao）§ 在此修复之前，options 连接选项（如果有的话）会被忽略，因此，例如无法在 walsender 会话中设置自定义服务器参数值。该功能本应正常工作；在 PostgreSQL 15 中的重构破坏它之前，它也确实一直是正常工作的，因此这里恢复了先前的行为。", "title": "将 CREATE SUBSCRIPTION ... CONNECTION 中指定的连接选项传递给发布端的 walsender 进程", "commits": ["f7eb44e0f"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "d0d881b1ea4ce998e7b00059e1c8c14f3bfb48f46520a4ecbe402ff7ba098867", "section_path": ["变更"], "commit_groups": [["75f3428f2", "797fc5d1b", "7a990e801", "d926462d8", "f7eb44e0f"]], "identity_text": "Pass connection options specified in CREATE SUBSCRIPTION ... CONNECTION to the publisher's walsender (Fujii Masao) Before this fix, the options connection option (if any) was ignored, thus for example preventing setting custom server parameter values in the walsender session. It was intended for that to work, and it did work before refactoring in PostgreSQL version 15 broke it, so restore the previous behavior.", "commit_aliases": ["75f3428f2", "797fc5d1b", "7a990e801", "d926462d8", "f7eb44e0f"], "source_commits": ["f7eb44e0f"], "source_entry_id": "15.16/changes/023", "db_id": "14350aa55158b13629c79743cee560e0", "patch_ids": ["568bc4b03123c66fa5044fb184e67302"], "statement_hash": "943489b5b1d830bbee00976c647cb6322ea03fa5558af6ad16b83a9deefb106c", "relations": [{"rule": 2, "type": "equivalent", "target": "2854750f46ab8bd38a28c1cfd5ae77c9", "evidence": {"same_day": true, "patch_ids": ["568bc4b03123c66fa5044fb184e67302"], "statement_hash": "943489b5b1d830bbee00976c647cb6322ea03fa5558af6ad16b83a9deefb106c"}}, {"rule": 2, "type": "equivalent", "target": "88f8d8a25ce40f7bce801ec6d1ceb806", "evidence": {"same_day": true, "patch_ids": ["568bc4b03123c66fa5044fb184e67302"], "statement_hash": "943489b5b1d830bbee00976c647cb6322ea03fa5558af6ad16b83a9deefb106c"}}, {"rule": 2, "type": "equivalent", "target": "e6adf36f29967b514be061f08ac43c83", "evidence": {"same_day": true, "patch_ids": ["568bc4b03123c66fa5044fb184e67302"], "statement_hash": "943489b5b1d830bbee00976c647cb6322ea03fa5558af6ad16b83a9deefb106c"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "88f8d8a25ce40f7bce801ec6d1ceb806", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "将 CREATE SUBSCRIPTION ... CONNECTION 中指定的连接选项传递给发布端的 walsender 进程", "evidence": {"same_day": true, "patch_ids": ["568bc4b03123c66fa5044fb184e67302"], "statement_hash": "943489b5b1d830bbee00976c647cb6322ea03fa5558af6ad16b83a9deefb106c"}, "url": "/docs/compare/?release=18.2#18.2-a7e8eb1d775d340e", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "e6adf36f29967b514be061f08ac43c83", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "将 CREATE SUBSCRIPTION ... CONNECTION 中指定的连接选项传递给发布端的 walsender 进程", "evidence": {"same_day": true, "patch_ids": ["568bc4b03123c66fa5044fb184e67302"], "statement_hash": "943489b5b1d830bbee00976c647cb6322ea03fa5558af6ad16b83a9deefb106c"}, "url": "/docs/compare/?release=17.8#17.8-8dc05bb27f841a6c", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "2854750f46ab8bd38a28c1cfd5ae77c9", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "将 CREATE SUBSCRIPTION ... CONNECTION 中指定的连接选项传递给发布端的 walsender 进程", "evidence": {"same_day": true, "patch_ids": ["568bc4b03123c66fa5044fb184e67302"], "statement_hash": "943489b5b1d830bbee00976c647cb6322ea03fa5558af6ad16b83a9deefb106c"}, "url": "/docs/compare/?release=16.12#16.12-856e665b12053097", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}]}, {"id": "15.16-2523a9b1b515d26f", "cves": [], "html": "<p>防止新创建或新同步的复制槽被无效化（Zhijie Hou）<a href=\"https://postgr.es/c/aae05622a\">§</a></p>\n<p>与并发检查点的竞争条件可能导致复制槽所需的 WAL 被删除，使得该槽立即被标记为无效。</p>", "text": "防止新创建或新同步的复制槽被无效化（Zhijie Hou）§ 与并发检查点的竞争条件可能导致复制槽所需的 WAL 被删除，使得该槽立即被标记为无效。", "title": "防止新创建或新同步的复制槽被无效化", "commits": ["aae05622a"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "ff02422aa9db1fbec836f6b50bfcef0a7afbbbe64f40c64c45452ce4848a0962", "section_path": ["变更"], "commit_groups": [["006dd4b2e", "24cce33c3", "3510ebeb0", "7406df605", "aae05622a", "d3ceb2084"], ["1c60f7236", "3a98f989e", "9649f1adf"], ["3243c0177", "851f6649c", "919c9fa13"]], "identity_text": "Prevent invalidation of newly created or newly synced replication slots (Zhijie Hou) A race condition with a concurrent checkpoint could allow WAL to be removed that is needed by the replication slot, causing the slot to immediately get marked invalid.", "commit_aliases": ["006dd4b2e", "1c60f7236", "24cce33c3", "3243c0177", "3510ebeb0", "3a98f989e", "7406df605", "851f6649c", "919c9fa13", "9649f1adf", "aae05622a", "d3ceb2084"], "source_commits": ["3a98f989e", "851f6649c", "aae05622a"], "source_entry_id": "15.16/changes/024", "db_id": "54b2a393bc7cb86ab19eb7c660bb2004", "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9", "relations": [{"rule": 2, "type": "equivalent", "target": "2e44c2dcd00ca731067ba5c1a7a9a31c", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}}, {"rule": 2, "type": "equivalent", "target": "7045b64c3c70e172ffa2ef8c1ae90896", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}}, {"rule": 2, "type": "equivalent", "target": "cb75695174eb56fb419b9a98e09580cc", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}}, {"rule": 2, "type": "equivalent", "target": "d1a860dc00a9dc81973d46ece96b0748", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "cb75695174eb56fb419b9a98e09580cc", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "防止新创建或新同步的复制槽被无效化", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}, "url": "/docs/compare/?release=18.2#18.2-882569f761ef0610", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "2e44c2dcd00ca731067ba5c1a7a9a31c", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "防止新创建或新同步的复制槽被无效化", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}, "url": "/docs/compare/?release=17.8#17.8-2ab0d69c3c8683d7", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "7045b64c3c70e172ffa2ef8c1ae90896", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "防止新创建或新同步的复制槽被无效化", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}, "url": "/docs/compare/?release=16.12#16.12-2c0a03a7293625cd", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "d1a860dc00a9dc81973d46ece96b0748", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "防止新创建或新同步的复制槽被无效化", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}, "url": "/docs/compare/?release=14.21#14.21-39c6194420a5bf2b", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-a49381efba5b11d0", "cves": [], "html": "<p>修复计算复制槽所需 xmin 时的竞争条件（Zhijie Hou）<a href=\"https://postgr.es/c/fa557d300\">§</a></p>\n<p>这可能导致错误 <span>“<span>cannot build an initial slot snapshot as oldest safe xid follows snapshot's xmin</span>”</span>。</p>", "text": "修复计算复制槽所需 xmin 时的竞争条件（Zhijie Hou）§ 这可能导致错误 “cannot build an initial slot snapshot as oldest safe xid follows snapshot's xmin”。", "title": "修复计算复制槽所需 xmin 时的竞争条件", "commits": ["fa557d300"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "059fc22583de086db2dbbd557d3d126545de203019cb4910bb1521509d239b76", "section_path": ["变更"], "commit_groups": [["123b851ab", "2a5225b99", "57048d6e1", "821466722", "fa557d300", "fd7c86cfa"]], "identity_text": "Fix race condition in computing a replication slot's required xmin (Zhijie Hou) This could lead to the error cannot build an initial slot snapshot as oldest safe xid follows snapshot's xmin.", "commit_aliases": ["123b851ab", "2a5225b99", "57048d6e1", "821466722", "fa557d300", "fd7c86cfa"], "source_commits": ["fa557d300"], "source_entry_id": "15.16/changes/025", "db_id": "8dfd1735c21afd64306b7ba15b0a34a0", "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369", "relations": [{"rule": 2, "type": "equivalent", "target": "5b75bdc74484bae30e1e7fdc965c9335", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}}, {"rule": 2, "type": "equivalent", "target": "669fa902ee7eb1553fc960938aa0101f", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}}, {"rule": 2, "type": "equivalent", "target": "97d0bb3c79bb34e32cf7ac9c088a6cc5", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}}, {"rule": 2, "type": "equivalent", "target": "ed4968909e48309a69552757b02c2ad7", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "669fa902ee7eb1553fc960938aa0101f", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复计算复制槽所需 xmin 时的竞争条件", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}, "url": "/docs/compare/?release=18.2#18.2-7907d70dfbb36d36", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "5b75bdc74484bae30e1e7fdc965c9335", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复计算复制槽所需 xmin 时的竞争条件", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}, "url": "/docs/compare/?release=17.8#17.8-73bf563728deef29", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "97d0bb3c79bb34e32cf7ac9c088a6cc5", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复计算复制槽所需 xmin 时的竞争条件", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}, "url": "/docs/compare/?release=16.12#16.12-dc6c53055853a66a", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "ed4968909e48309a69552757b02c2ad7", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复计算复制槽所需 xmin 时的竞争条件", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}, "url": "/docs/compare/?release=14.21#14.21-e0ac9a9b715f44f3", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-72eafe5fdeaf4699", "cves": [], "html": "<p>在逻辑复制订阅的初始同步期间，在开始复制数据之前提交 <code>pg_replication_origin</code> 条目的添加（Zhijie Hou）<a href=\"https://postgr.es/c/90d1beef6\">§</a></p>\n<p>以前，如果复制步骤失败，新的 <code>pg_replication_origin</code> 条目会因事务回滚而丢失，从而导致共享内存中的状态不一致。</p>", "text": "在逻辑复制订阅的初始同步期间，在开始复制数据之前提交 pg_replication_origin 条目的添加（Zhijie Hou）§ 以前，如果复制步骤失败，新的 pg_replication_origin 条目会因事务回滚而丢失，从而导致共享内存中的状态不一致。", "title": "在逻辑复制订阅的初始同步期间，在开始复制数据之前提交 pg_replication_origin 条目的添加", "commits": ["90d1beef6"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "0186b1b55e4617e76f6d012e729186d8be4f5b38d02ba4ce0f9a727b85b447c6", "section_path": ["变更"], "commit_groups": [["25a04aa52", "8e0d32a4a", "90d1beef6", "b07c32619", "e063ccc72", "e22e9ab0c"]], "identity_text": "During initial synchronization of a logical replication subscription, commit the addition of a pg_replication_origin entry before starting to copy data (Zhijie Hou) Previously, if the copy step failed, the new pg_replication_origin entry would be lost due to transaction rollback. This led to inconsistent state in shared memory.", "commit_aliases": ["25a04aa52", "8e0d32a4a", "90d1beef6", "b07c32619", "e063ccc72", "e22e9ab0c"], "source_commits": ["90d1beef6"], "source_entry_id": "15.16/changes/026", "db_id": "ca66bcb2ba08cd3e614c66d8cd512695", "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26", "relations": [{"rule": 2, "type": "equivalent", "target": "0641edcbe436f507275b2cfe99e6bfe1", "evidence": {"same_day": true, "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26"}}, {"rule": 2, "type": "equivalent", "target": "5bdf0ada14933155ce231f2e53c4a971", "evidence": {"same_day": true, "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26"}}, {"rule": 2, "type": "equivalent", "target": "6868525096474e94a6c61c14b66bef91", "evidence": {"same_day": true, "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26"}}, {"rule": 2, "type": "equivalent", "target": "eb4ae0a26d975941de9f63f06cf9d77f", "evidence": {"same_day": true, "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "0641edcbe436f507275b2cfe99e6bfe1", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "在逻辑复制订阅的初始同步期间，在开始复制数据之前提交 pg_replication_origin 条目的添加", "evidence": {"same_day": true, "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26"}, "url": "/docs/compare/?release=18.2#18.2-2de557ccdda45f50", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "eb4ae0a26d975941de9f63f06cf9d77f", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "在逻辑复制订阅的初始同步期间，在开始复制数据之前提交 pg_replication_origin 条目的添加", "evidence": {"same_day": true, "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26"}, "url": "/docs/compare/?release=17.8#17.8-e95d66b2b17f79c5", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "6868525096474e94a6c61c14b66bef91", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "在逻辑复制订阅的初始同步期间，在开始复制数据之前提交 pg_replication_origin 条目的添加", "evidence": {"same_day": true, "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26"}, "url": "/docs/compare/?release=16.12#16.12-986cc1721ba7e0ca", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "5bdf0ada14933155ce231f2e53c4a971", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "在逻辑复制订阅的初始同步期间，在开始复制数据之前提交 pg_replication_origin 条目的添加", "evidence": {"same_day": true, "patch_ids": ["8e425bf3652841f2fadba06865081f6e"], "statement_hash": "7d150c67ee78399daa2e94cde2a4147e691fc12beccfdee6012621884edbcb26"}, "url": "/docs/compare/?release=14.21#14.21-3e55dd139a333f1e", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-ba8bb5d9e4033d19", "cves": [], "html": "<p>修复流复制副本服务器重启期间可能出现的 <span>“<span>unexpected data beyond EOF</span>”</span> 失败问题（Anthonin Bonnefoy）<a href=\"https://postgr.es/c/ef8465588\">§</a></p>", "text": "修复流复制副本服务器重启期间可能出现的 “unexpected data beyond EOF” 失败问题（Anthonin Bonnefoy）§", "title": "修复流复制副本服务器重启期间可能出现的 “unexpected data beyond EOF” 失败问题", "commits": ["ef8465588"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "d9c2373dccafe5269cb1677a3dfbe2b86b931da44d2d1be3f34d3a16b0f523de", "section_path": ["变更"], "commit_groups": [["23b25586d", "2514f1c77", "9ed411e08", "a2eeb04f3", "c3770181c", "ef8465588"]], "identity_text": "Fix possible failure with unexpected data beyond EOF during restart of a streaming replica server (Anthonin Bonnefoy)", "commit_aliases": ["23b25586d", "2514f1c77", "9ed411e08", "a2eeb04f3", "c3770181c", "ef8465588"], "source_commits": ["ef8465588"], "source_entry_id": "15.16/changes/027", "db_id": "668c3f03c522a5db8d076f179e064027", "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab", "relations": [{"rule": 2, "type": "equivalent", "target": "06594efa4344da118700b1c48988f5e4", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}}, {"rule": 2, "type": "equivalent", "target": "8d924571fb5bee478b47c49ff89fa7f5", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}}, {"rule": 2, "type": "equivalent", "target": "a321a63cf72d9e7f3afd2ff1e5a2c814", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}}, {"rule": 2, "type": "equivalent", "target": "a79b7d220801497e224783e6369f7957", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "06594efa4344da118700b1c48988f5e4", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复流复制副本服务器重启期间可能出现的 “unexpected data beyond EOF” 失败问题", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}, "url": "/docs/compare/?release=18.2#18.2-c52d288613257e1b", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "a79b7d220801497e224783e6369f7957", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复流复制副本服务器重启期间可能出现的 “unexpected data beyond EOF” 失败问题", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}, "url": "/docs/compare/?release=17.8#17.8-ca1e290b0cb2dd09", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "a321a63cf72d9e7f3afd2ff1e5a2c814", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复流复制副本服务器重启期间可能出现的 “unexpected data beyond EOF” 失败问题", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}, "url": "/docs/compare/?release=16.12#16.12-ce78056abed06c7f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "8d924571fb5bee478b47c49ff89fa7f5", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复流复制副本服务器重启期间可能出现的 “unexpected data beyond EOF” 失败问题", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}, "url": "/docs/compare/?release=14.21#14.21-56f9977d411ed1a0", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-ed7528c4bca01a17", "cves": [], "html": "<p>修复解析分区范围边界时对列位置的错误跟踪（myzhen）<a href=\"https://postgr.es/c/3ad05640b\">§</a></p>\n<p>这可能导致在关于将分区边界值转换为列的数据类型的错误消息中引用错误的列名。</p>", "text": "修复解析分区范围边界时对列位置的错误跟踪（myzhen）§ 这可能导致在关于将分区边界值转换为列的数据类型的错误消息中引用错误的列名。", "title": "修复解析分区范围边界时对列位置的错误跟踪", "commits": ["3ad05640b"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "99d1b0e3dce6037793a1ecabe7b47fabee6d1a6f245bff3809e978a249ec4075", "section_path": ["变更"], "commit_groups": [["349107537", "3ad05640b", "821c4d27b", "84b787ae6", "a65995947", "c35e5dd9a"]], "identity_text": "Fix erroneous tracking of column position when parsing partition range bounds (myzhen) This could, for example, lead to the wrong column name being cited in error messages about casting partition bound values to the column's data type.", "commit_aliases": ["349107537", "3ad05640b", "821c4d27b", "84b787ae6", "a65995947", "c35e5dd9a"], "source_commits": ["3ad05640b"], "source_entry_id": "15.16/changes/028", "db_id": "775ee6e8b3e233efe9c85fc527d0a5d4", "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232", "relations": [{"rule": 2, "type": "equivalent", "target": "3d999c9c39b345cf00d6c149f77369bc", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}}, {"rule": 2, "type": "equivalent", "target": "8da33c76c87cf129799d93a7efd47d96", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}}, {"rule": 2, "type": "equivalent", "target": "bb4e430870bc5f4909df899b3e4e6a47", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}}, {"rule": 2, "type": "equivalent", "target": "bcd807761d1a951aa85d661bf8df019c", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "bcd807761d1a951aa85d661bf8df019c", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复解析分区范围边界时对列位置的错误跟踪", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}, "url": "/docs/compare/?release=18.2#18.2-3915ae13b44752be", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "3d999c9c39b345cf00d6c149f77369bc", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复解析分区范围边界时对列位置的错误跟踪", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}, "url": "/docs/compare/?release=17.8#17.8-1ae71997df1c5c19", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "bb4e430870bc5f4909df899b3e4e6a47", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复解析分区范围边界时对列位置的错误跟踪", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}, "url": "/docs/compare/?release=16.12#16.12-cf6cf28e524760ac", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "8da33c76c87cf129799d93a7efd47d96", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复解析分区范围边界时对列位置的错误跟踪", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}, "url": "/docs/compare/?release=14.21#14.21-cd4c9b00fed268c0", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-3b76c2a636f3fe46", "cves": [], "html": "<p>修复错误消息中的各种小错误（Man Zeng，Tianchen Zhang）<a href=\"https://postgr.es/c/4ec943f7d\">§</a> <a href=\"https://postgr.es/c/fbf8df580\">§</a> <a href=\"https://postgr.es/c/9dcd0b3de\">§</a></p>\n<p>例如，关于备份清单中时间线编号不匹配的错误报告在应该显示结束时间线编号的地方显示了起始时间线编号。</p>", "text": "修复错误消息中的各种小错误（Man Zeng，Tianchen Zhang）§ § § 例如，关于备份清单中时间线编号不匹配的错误报告在应该显示结束时间线编号的地方显示了起始时间线编号。", "title": "修复错误消息中的各种小错误", "commits": ["4ec943f7d", "9dcd0b3de", "fbf8df580"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "6d40c379eb4f3f89941eded9fade20c6bae9e7278a1c4a73ca79cabc7b62df71", "section_path": ["变更"], "commit_groups": [["05ef2371a", "69ee81932", "6bca4b50d", "e8fd6c9fd", "f1dc7a5b7", "fbf8df580"], ["1653ce523", "3e7bb39df", "5449fd261", "9dcd0b3de", "a7bdbbada", "cff2ef984"], ["263af458e", "2ca4464b6", "c8ec74713"], ["4ec943f7d", "67ad4387b", "74a116a79", "977a17a3e", "acfa422c3", "d32e17160"], ["5995135f1", "a9afa021e", "ab61f0087"]], "identity_text": "Fix assorted minor errors in error messages (Man Zeng, Tianchen Zhang) For example, an error report about mismatched timeline number in a backup manifest showed the starting timeline number where it meant to show the ending timeline number.", "commit_aliases": ["05ef2371a", "1653ce523", "263af458e", "2ca4464b6", "3e7bb39df", "4ec943f7d", "5449fd261", "5995135f1", "67ad4387b", "69ee81932", "6bca4b50d", "74a116a79", "977a17a3e", "9dcd0b3de", "a7bdbbada", "a9afa021e", "ab61f0087", "acfa422c3", "c8ec74713", "cff2ef984", "d32e17160", "e8fd6c9fd", "f1dc7a5b7", "fbf8df580"], "source_commits": ["4ec943f7d", "9dcd0b3de", "a9afa021e", "c8ec74713", "fbf8df580"], "source_entry_id": "15.16/changes/029", "db_id": "6391fdf7551cb6b17994c91b76215a9f", "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737", "relations": [{"rule": 2, "type": "equivalent", "target": "03e8508ea8a410388767d947c24e8eb3", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}}, {"rule": 2, "type": "equivalent", "target": "040254b8395148f9ed2820a7a9e7de75", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}}, {"rule": 2, "type": "equivalent", "target": "c28d793705797c568ae351065c8bf92d", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}}, {"rule": 2, "type": "equivalent", "target": "e4eecf733b283aee3b3d1c824dbc8e27", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c28d793705797c568ae351065c8bf92d", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复错误消息中的各种小错误", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}, "url": "/docs/compare/?release=18.2#18.2-2eb9c2c4100a1830", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "040254b8395148f9ed2820a7a9e7de75", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复错误消息中的各种小错误", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}, "url": "/docs/compare/?release=17.8#17.8-4eafc20a792cccfc", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "e4eecf733b283aee3b3d1c824dbc8e27", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复错误消息中的各种小错误", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}, "url": "/docs/compare/?release=16.12#16.12-3849a6578b12c6fe", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "03e8508ea8a410388767d947c24e8eb3", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复错误消息中的各种小错误", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}, "url": "/docs/compare/?release=14.21#14.21-2f6c908c2dcee449", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-7077db49018d55b0", "cves": [], "html": "<p>修复在使用 LLVM 17 或更高版本进行 JIT 编译时无法执行函数内联的问题（Anthonin Bonnefoy）<a href=\"https://postgr.es/c/cbdd09ae1\">§</a></p>", "text": "修复在使用 LLVM 17 或更高版本进行 JIT 编译时无法执行函数内联的问题（Anthonin Bonnefoy）§", "title": "修复在使用 LLVM 17 或更高版本进行 JIT 编译时无法执行函数内联的问题", "commits": ["cbdd09ae1"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "012b562ccbbc031ef42ef1a9fa7a20aee6925e74a90edd2b5c22b954d555d531", "section_path": ["变更"], "commit_groups": [["7600dc79c", "cbdd09ae1", "d0bb0e5b3", "de8081c30", "e5d99b4d9", "f1c6b153c"]], "identity_text": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later (Anthonin Bonnefoy)", "commit_aliases": ["7600dc79c", "cbdd09ae1", "d0bb0e5b3", "de8081c30", "e5d99b4d9", "f1c6b153c"], "source_commits": ["cbdd09ae1"], "source_entry_id": "15.16/changes/030", "db_id": "da5340b311cf457b0c8052e7119f6c5c", "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af", "relations": [{"rule": 2, "type": "equivalent", "target": "1d826bf62f1c8707e84a00b08bca6cc2", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}}, {"rule": 2, "type": "equivalent", "target": "23db3b0771d0b80deb078c18239bf311", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}}, {"rule": 2, "type": "equivalent", "target": "41aa0fa812e386b3bf111e16e5ca824b", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}}, {"rule": 2, "type": "equivalent", "target": "6c8a23f42fdf36b27a5c63a60ef638ee", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6c8a23f42fdf36b27a5c63a60ef638ee", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复在使用 LLVM 17 或更高版本进行 JIT 编译时无法执行函数内联的问题", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}, "url": "/docs/compare/?release=18.2#18.2-53f3b7ffe4f6fe06", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "23db3b0771d0b80deb078c18239bf311", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复在使用 LLVM 17 或更高版本进行 JIT 编译时无法执行函数内联的问题", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}, "url": "/docs/compare/?release=17.8#17.8-c185802f4eacb2ea", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "1d826bf62f1c8707e84a00b08bca6cc2", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复在使用 LLVM 17 或更高版本进行 JIT 编译时无法执行函数内联的问题", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}, "url": "/docs/compare/?release=16.12#16.12-e61e367302b48095", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "41aa0fa812e386b3bf111e16e5ca824b", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复在使用 LLVM 17 或更高版本进行 JIT 编译时无法执行函数内联的问题", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}, "url": "/docs/compare/?release=14.21#14.21-c9d25ce6f3b8c109", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-1709d5e654f518fa", "cves": [], "html": "<p>调整我们的 JIT 代码以兼容 LLVM 21（Holger Hoffstätte）<a href=\"https://postgr.es/c/55164852d\">§</a></p>\n<p>之前的代码在 aarch64 机器上编译失败。</p>", "text": "调整我们的 JIT 代码以兼容 LLVM 21（Holger Hoffstätte）§ 之前的代码在 aarch64 机器上编译失败。", "title": "调整我们的 JIT 代码以兼容 LLVM 21", "commits": ["55164852d"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "10c0e48ec50bb536608a51e64c26ce44746466d5112fedb7dd1de13a4e663598", "section_path": ["变更"], "commit_groups": [["035a1f5ac", "0dceba21d", "55164852d", "600acd34b", "60215eae7", "912cfa314"]], "identity_text": "Adjust our JIT code to work with LLVM 21 (Holger Hoffstätte) The previous coding failed to compile on aarch64 machines.", "commit_aliases": ["035a1f5ac", "0dceba21d", "55164852d", "600acd34b", "60215eae7", "912cfa314"], "source_commits": ["55164852d"], "source_entry_id": "15.16/changes/031", "db_id": "084e13baf0a1aaa1b6831e50a2e8b014", "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc", "relations": [{"rule": 2, "type": "equivalent", "target": "51e665bd2f8466b41d80cf0223c7e413", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}}, {"rule": 2, "type": "equivalent", "target": "c7ea32ba825d2c7140b0017b02f1a3ec", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}}, {"rule": 2, "type": "equivalent", "target": "cff57c5be469c947c3ffe128e6ba5e35", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}}, {"rule": 2, "type": "equivalent", "target": "e7ed91f4e25921028767eb7d80e59575", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e7ed91f4e25921028767eb7d80e59575", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "调整我们的 JIT 代码以兼容 LLVM 21", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}, "url": "/docs/compare/?release=18.2#18.2-bf063586f9119b1e", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "c7ea32ba825d2c7140b0017b02f1a3ec", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "调整我们的 JIT 代码以兼容 LLVM 21", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}, "url": "/docs/compare/?release=17.8#17.8-64e9296142cf419d", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "51e665bd2f8466b41d80cf0223c7e413", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "调整我们的 JIT 代码以兼容 LLVM 21", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}, "url": "/docs/compare/?release=16.12#16.12-f79746039ad9700e", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "cff57c5be469c947c3ffe128e6ba5e35", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "调整我们的 JIT 代码以兼容 LLVM 21", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}, "url": "/docs/compare/?release=14.21#14.21-cf7b1ea7a3d14458", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-03e934debe8d5e92", "cves": [], "html": "<p>支持在 GNU/Hurd 上更改进程标题（Michael Banck）<a href=\"https://postgr.es/c/3995e4a9d\">§</a></p>", "text": "支持在 GNU/Hurd 上更改进程标题（Michael Banck）§", "title": "支持在 GNU/Hurd 上更改进程标题", "commits": ["3995e4a9d"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "8ff26fd10b3c5ef88d101c5187a012f564d273d061292924bb4564e14df8c413", "section_path": ["变更"], "commit_groups": [["29a3e22f3", "32b236644", "3995e4a9d", "a1407dade", "bcfca332f", "d66a922f9"]], "identity_text": "Support process title changes on GNU/Hurd (Michael Banck)", "commit_aliases": ["29a3e22f3", "32b236644", "3995e4a9d", "a1407dade", "bcfca332f", "d66a922f9"], "source_commits": ["3995e4a9d"], "source_entry_id": "15.16/changes/032", "db_id": "d2f91f9760f28a721378c4e8d76ef619", "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f", "relations": [{"rule": 2, "type": "equivalent", "target": "45f431c4bd4cad50e4053b47f371bd3f", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}}, {"rule": 2, "type": "equivalent", "target": "465d44f8b93dc009feaa8d1fac573196", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}}, {"rule": 2, "type": "equivalent", "target": "92b88e55c652dfa1fcdde3f0953f3285", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}}, {"rule": 2, "type": "equivalent", "target": "b14342e6824ed37b82078bd9a6cc21e1", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "92b88e55c652dfa1fcdde3f0953f3285", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "支持在 GNU/Hurd 上更改进程标题", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}, "url": "/docs/compare/?release=18.2#18.2-e1336b6079ff8d5b", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "b14342e6824ed37b82078bd9a6cc21e1", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "支持在 GNU/Hurd 上更改进程标题", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}, "url": "/docs/compare/?release=17.8#17.8-3cbfa3eb5e11672e", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "45f431c4bd4cad50e4053b47f371bd3f", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "支持在 GNU/Hurd 上更改进程标题", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}, "url": "/docs/compare/?release=16.12#16.12-518eec4d74a9bdf5", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "465d44f8b93dc009feaa8d1fac573196", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "支持在 GNU/Hurd 上更改进程标题", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}, "url": "/docs/compare/?release=14.21#14.21-d81eba7f3eeb9460", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-3d69fa0131d029ba", "cves": [], "html": "<p>使 <span>pg_resetwal</span> 在更改 OldestXID 时打印更新后的值（Heikki Linnakangas）<a href=\"https://postgr.es/c/7c494072b\">§</a></p>\n<p>它对可以更改的其他每个变量都已经这样做了。</p>", "text": "使 pg_resetwal 在更改 OldestXID 时打印更新后的值（Heikki Linnakangas）§ 它对可以更改的其他每个变量都已经这样做了。", "title": "使 pg_resetwal 在更改 OldestXID 时打印更新后的值", "commits": ["7c494072b"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "c72a4b68640af141ee14ab61c2de8ca2c25f98456334b6456d4d6a3b72e782b9", "section_path": ["变更"], "commit_groups": [["11cc0f452", "19594271c", "7c494072b", "890cc81b6", "d5b4f3a6d", "f2e0ca0af"]], "identity_text": "Make pg_resetwal print the updated value when changing OldestXID (Heikki Linnakangas) It already did that for every other variable it can change.", "commit_aliases": ["11cc0f452", "19594271c", "7c494072b", "890cc81b6", "d5b4f3a6d", "f2e0ca0af"], "source_commits": ["7c494072b"], "source_entry_id": "15.16/changes/033", "db_id": "47e617ce37a58405cf4c7f033f26b641", "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a", "relations": [{"rule": 2, "type": "equivalent", "target": "22be50f61755ecf5187af28b01545b41", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}}, {"rule": 2, "type": "equivalent", "target": "500d9d80888f7caeb4b4801bee95301d", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}}, {"rule": 2, "type": "equivalent", "target": "5f928cd7f1a940e12cd51a8ce19d06f6", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}}, {"rule": 2, "type": "equivalent", "target": "94c5ea9aed8ffadf4043f33f201ed4e5", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "5f928cd7f1a940e12cd51a8ce19d06f6", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "使 pg_resetwal 在更改 OldestXID 时打印更新后的值", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}, "url": "/docs/compare/?release=18.2#18.2-12ea46c5ca32b0f2", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "500d9d80888f7caeb4b4801bee95301d", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "使 pg_resetwal 在更改 OldestXID 时打印更新后的值", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}, "url": "/docs/compare/?release=17.8#17.8-0aca6daf3559b899", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "94c5ea9aed8ffadf4043f33f201ed4e5", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "使 pg_resetwal 在更改 OldestXID 时打印更新后的值", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}, "url": "/docs/compare/?release=16.12#16.12-49d7c6db55fd3d90", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "22be50f61755ecf5187af28b01545b41", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "使 pg_resetwal 在更改 OldestXID 时打印更新后的值", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}, "url": "/docs/compare/?release=14.21#14.21-cd08367401e4956d", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-fed3a8dfafe193ba", "cves": [], "html": "<p>使 <span>pg_resetwal</span> 允许将下一个多事务 xid 设置为 0 或将下一个多事务偏移量设置为 UINT32_MAX（Maxim Orlov）<a href=\"https://postgr.es/c/97cd4b65a\">§</a></p>\n<p>这些是有效的值，因此拒绝它们是不正确的。在最坏的情况下，如果恰好在多事务回卷点尝试 pg_upgrade，升级将失败。</p>", "text": "使 pg_resetwal 允许将下一个多事务 xid 设置为 0 或将下一个多事务偏移量设置为 UINT32_MAX（Maxim Orlov）§ 这些是有效的值，因此拒绝它们是不正确的。在最坏的情况下，如果恰好在多事务回卷点尝试 pg_upgrade，升级将失败。", "title": "使 pg_resetwal 允许将下一个多事务 xid 设置为 0 或将下一个多事务偏移量设置为 UINT32_MAX", "commits": ["97cd4b65a"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "98976cf38e41c530fab66fd29be858bc6cd8993daed517aaa86d4c57c71d960f", "section_path": ["变更"], "commit_groups": [["8747b969f", "94939c5f3", "97cd4b65a", "cb2ef0e92", "e039b09f8"]], "identity_text": "Make pg_resetwal allow setting next multixact xid to 0 or next multixact offset to UINT32_MAX (Maxim Orlov) These are valid values, so rejecting them was incorrect. In the worst case, if a pg_upgrade is attempted when exactly at the point of multixact wraparound, the upgrade would fail.", "commit_aliases": ["8747b969f", "94939c5f3", "97cd4b65a", "cb2ef0e92", "e039b09f8"], "source_commits": ["97cd4b65a"], "source_entry_id": "15.16/changes/034", "db_id": "4da7f3aac2517d05e54bea6d3c1ab25e", "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea", "relations": [{"rule": 2, "type": "equivalent", "target": "89127b250f2abea1a64f754f71c48c77", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}}, {"rule": 2, "type": "equivalent", "target": "a4ce7629005a43b316bb9b4fbdb478ad", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}}, {"rule": 2, "type": "equivalent", "target": "ba56a98c48c3c98e929510554c2c7d1f", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "a4ce7629005a43b316bb9b4fbdb478ad", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "使 pg_resetwal 允许将下一个多事务 xid 设置为 0 或将下一个多事务偏移量设置为 UINT32_MAX", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}, "url": "/docs/compare/?release=18.2#18.2-b3adbf7cc127bf87", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "ba56a98c48c3c98e929510554c2c7d1f", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "使 pg_resetwal 允许将下一个多事务 xid 设置为 0 或将下一个多事务偏移量设置为 UINT32_MAX", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}, "url": "/docs/compare/?release=17.8#17.8-6a1deb077e1799c1", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "89127b250f2abea1a64f754f71c48c77", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "使 pg_resetwal 允许将下一个多事务 xid 设置为 0 或将下一个多事务偏移量设置为 UINT32_MAX", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}, "url": "/docs/compare/?release=16.12#16.12-be4ccb27fcd54b62", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}]}, {"id": "15.16-32e275050e59e4f0", "cves": [], "html": "<p>在 <code>contrib/amcheck</code> 中，为 B-树索引父节点检查使用正确的快照（Mihail Nikalayeu）<a href=\"https://postgr.es/c/dcddd6987\">§</a></p>\n<p>之前的代码在检查使用 <code>CREATE INDEX CONCURRENTLY</code> 创建的索引时会产生虚假错误。</p>", "text": "在 contrib/amcheck 中，为 B-树索引父节点检查使用正确的快照（Mihail Nikalayeu）§ 之前的代码在检查使用 CREATE INDEX CONCURRENTLY 创建的索引时会产生虚假错误。", "title": "在 contrib/amcheck 中，为 B-树索引父节点检查使用正确的快照", "commits": ["dcddd6987"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "a306082398741097597c4efa175beb46aa71e3ca24b134c4ca7714a3a534d06a", "section_path": ["变更"], "commit_groups": [["098a1fab8", "1f28982e4", "3c83a2a0a", "607a67c5e", "dcddd6987", "e1a327dc4"], ["6bd469d26", "ce2f575b7", "df93f94dd"]], "identity_text": "In contrib/amcheck, use the correct snapshot for btree index parent checks (Mihail Nikalayeu) The previous coding caused spurious errors when examining indexes created with CREATE INDEX CONCURRENTLY.", "commit_aliases": ["098a1fab8", "1f28982e4", "3c83a2a0a", "607a67c5e", "6bd469d26", "ce2f575b7", "dcddd6987", "df93f94dd", "e1a327dc4"], "source_commits": ["6bd469d26", "dcddd6987"], "source_entry_id": "15.16/changes/035", "db_id": "d68c80f0e4be35945733a8602d932285", "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d", "relations": [{"rule": 2, "type": "equivalent", "target": "493a72cf1959504f8641847b78bd08a1", "evidence": {"same_day": true, "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d"}}, {"rule": 2, "type": "equivalent", "target": "8bafe8c0e161e1a9a94a09493833d987", "evidence": {"same_day": true, "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d"}}, {"rule": 2, "type": "equivalent", "target": "8c9e41f976444baa74aa90d4929a9857", "evidence": {"same_day": true, "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d"}}, {"rule": 2, "type": "equivalent", "target": "955a03e6ef46153a22d64b4e82c47168", "evidence": {"same_day": true, "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "955a03e6ef46153a22d64b4e82c47168", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "在 contrib/amcheck 中，为 B-树索引父节点检查使用正确的快照", "evidence": {"same_day": true, "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d"}, "url": "/docs/compare/?release=18.2#18.2-bbfcc39776d1a2a4", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "8c9e41f976444baa74aa90d4929a9857", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "在 contrib/amcheck 中，为 B-树索引父节点检查使用正确的快照", "evidence": {"same_day": true, "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d"}, "url": "/docs/compare/?release=17.8#17.8-ab740b8bd4036a5f", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "8bafe8c0e161e1a9a94a09493833d987", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "在 contrib/amcheck 中，为 B-树索引父节点检查使用正确的快照", "evidence": {"same_day": true, "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d"}, "url": "/docs/compare/?release=16.12#16.12-57cb8c5f86934ffc", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "493a72cf1959504f8641847b78bd08a1", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "在 contrib/amcheck 中，为 B-树索引父节点检查使用正确的快照", "evidence": {"same_day": true, "patch_ids": ["1e97ec2b7912c8b7c0ec7e7abd017428", "a29fe4baf41fba16dd4afb02acc16023"], "statement_hash": "087497339e462790a79c92291f5c2d4d3a17e08435df6c64e32dc876bc1de14d"}, "url": "/docs/compare/?release=14.21#14.21-823de0611d087fb4", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-98501264b939d5f7", "cves": [], "html": "<p>修复 <code>contrib/amcheck</code> 以正确处理<span>“<span>半死亡</span>”</span> B-树索引页面（Heikki Linnakangas）<a href=\"https://postgr.es/c/7792bdc45\">§</a></p>\n<p><code>amcheck</code> 期望此类页面有一个父级下行链接，但实际上没有，导致关于 <span>“<span>mismatch between parent key and child high key</span>”</span> 的虚假错误报告。</p>", "text": "修复 contrib/amcheck 以正确处理“半死亡” B-树索引页面（Heikki Linnakangas）§ amcheck 期望此类页面有一个父级下行链接，但实际上没有，导致关于 “mismatch between parent key and child high key” 的虚假错误报告。", "title": "修复 contrib/amcheck 以正确处理“半死亡” B-树索引页面", "commits": ["7792bdc45"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "e79d5238d48cb8659d72dea58969d1ac0c71a8e9fce5a12bc6f20291867f2a8b", "section_path": ["变更"], "commit_groups": [["182901626", "19e786727", "7792bdc45", "cbe04e5d7", "e8ae59445", "fbb4b6078"]], "identity_text": "Fix contrib/amcheck to handle half-dead btree index pages correctly (Heikki Linnakangas) amcheck expected such a page to have a parent downlink, but it does not, leading to a false error report about mismatch between parent key and child high key.", "commit_aliases": ["182901626", "19e786727", "7792bdc45", "cbe04e5d7", "e8ae59445", "fbb4b6078"], "source_commits": ["7792bdc45"], "source_entry_id": "15.16/changes/036", "db_id": "b0c422d1b24cdfdcd3828e41eecc8d38", "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5", "relations": [{"rule": 2, "type": "equivalent", "target": "7d94ee89b853fd7d6f3bb697328e1fed", "evidence": {"same_day": true, "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5"}}, {"rule": 2, "type": "equivalent", "target": "bb53eff1677e4a2b4b54e1dcbe8a077d", "evidence": {"same_day": true, "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5"}}, {"rule": 2, "type": "equivalent", "target": "c7f51c102edaf4e048fd2d187271f417", "evidence": {"same_day": true, "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5"}}, {"rule": 2, "type": "equivalent", "target": "cd3fba00555984ba827b4d51519989d9", "evidence": {"same_day": true, "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "cd3fba00555984ba827b4d51519989d9", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复 contrib/amcheck 以正确处理“半死亡” B-树索引页面", "evidence": {"same_day": true, "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5"}, "url": "/docs/compare/?release=18.2#18.2-cb9b48895e2b846c", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "7d94ee89b853fd7d6f3bb697328e1fed", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复 contrib/amcheck 以正确处理“半死亡” B-树索引页面", "evidence": {"same_day": true, "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5"}, "url": "/docs/compare/?release=17.8#17.8-9f60cb27b127637e", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "bb53eff1677e4a2b4b54e1dcbe8a077d", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复 contrib/amcheck 以正确处理“半死亡” B-树索引页面", "evidence": {"same_day": true, "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5"}, "url": "/docs/compare/?release=16.12#16.12-8ce4eed0d5e06f12", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "c7f51c102edaf4e048fd2d187271f417", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复 contrib/amcheck 以正确处理“半死亡” B-树索引页面", "evidence": {"same_day": true, "patch_ids": ["f7e8ed321d6ed6ededda523198e8e879"], "statement_hash": "235569affe45bc821b8a939af4bf327951ad127f8ac6150fb4810ff7876efdc5"}, "url": "/docs/compare/?release=14.21#14.21-36f7bc4e4927fff8", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-fdcaabc9a4bd33b0", "cves": [], "html": "<p>修复 <code>contrib/amcheck</code> 以正确处理不完整的 B-树根页面分裂（Heikki Linnakangas）<a href=\"https://postgr.es/c/721b58fbe\">§</a></p>\n<p><code>amcheck</code> 可能会报告关于 <span>“<span>block is not true root</span>”</span> 的虚假错误。</p>", "text": "修复 contrib/amcheck 以正确处理不完整的 B-树根页面分裂（Heikki Linnakangas）§ amcheck 可能会报告关于 “block is not true root” 的虚假错误。", "title": "修复 contrib/amcheck 以正确处理不完整的 B-树根页面分裂", "commits": ["721b58fbe"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "9f2ecc3e8c03ddd4c5cb499d1f11d97d941db21a3e4b2e1ff4bf419b49249b48", "section_path": ["变更"], "commit_groups": [["50c63ebb0", "5a2d1df00", "6c05ef572", "721b58fbe", "a4cb21ea9", "f2a6df9fd"]], "identity_text": "Fix contrib/amcheck to handle incomplete btree root page splits correctly (Heikki Linnakangas) amcheck could report a false error about block is not true root.", "commit_aliases": ["50c63ebb0", "5a2d1df00", "6c05ef572", "721b58fbe", "a4cb21ea9", "f2a6df9fd"], "source_commits": ["721b58fbe"], "source_entry_id": "15.16/changes/037", "db_id": "c098597887b2f2c2a2d33ae0dfbe3669", "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb", "relations": [{"rule": 2, "type": "equivalent", "target": "0961927e1e1f17e976e1fe45d36dd9ce", "evidence": {"same_day": true, "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb"}}, {"rule": 2, "type": "equivalent", "target": "36d6b9b121e09182786381bf1019a5a6", "evidence": {"same_day": true, "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb"}}, {"rule": 2, "type": "equivalent", "target": "67e3b43981f7755a637c3f6f8538cf81", "evidence": {"same_day": true, "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb"}}, {"rule": 2, "type": "equivalent", "target": "8501633eefd4ba0be52ed6a8edf74102", "evidence": {"same_day": true, "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "8501633eefd4ba0be52ed6a8edf74102", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复 contrib/amcheck 以正确处理不完整的 B-树根页面分裂", "evidence": {"same_day": true, "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb"}, "url": "/docs/compare/?release=18.2#18.2-9de86ea05d414299", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "67e3b43981f7755a637c3f6f8538cf81", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复 contrib/amcheck 以正确处理不完整的 B-树根页面分裂", "evidence": {"same_day": true, "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb"}, "url": "/docs/compare/?release=17.8#17.8-5b1a363a1650f076", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "0961927e1e1f17e976e1fe45d36dd9ce", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复 contrib/amcheck 以正确处理不完整的 B-树根页面分裂", "evidence": {"same_day": true, "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb"}, "url": "/docs/compare/?release=16.12#16.12-c9fd4d380e654c76", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "36d6b9b121e09182786381bf1019a5a6", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复 contrib/amcheck 以正确处理不完整的 B-树根页面分裂", "evidence": {"same_day": true, "patch_ids": ["bc0672786aac6981e442848cef632af7"], "statement_hash": "a09b91d29cb6145c6b4b8a47f79add91a36b52c7cd5b33ff456ebcbee2d174eb"}, "url": "/docs/compare/?release=14.21#14.21-fe04a8384b630984", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-f389445655314c8a", "cves": [], "html": "<p>修复 <code>contrib/intarray</code> 中 <code>@@</code> 选择率估算器的边界情况整数溢出问题（Chao Li）<a href=\"https://postgr.es/c/c89510431\">§</a></p>\n<p>这可能导致在涉及最大整数值的情况下产生不准确的选择率估算。</p>", "text": "修复 contrib/intarray 中 @@ 选择率估算器的边界情况整数溢出问题（Chao Li）§ 这可能导致在涉及最大整数值的情况下产生不准确的选择率估算。", "title": "修复 contrib/intarray 中 @@ 选择率估算器的边界情况整数溢出问题", "commits": ["c89510431"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "34c9ef81372ea420b819849bba7ed52eff06df3feb5967340dfa8729cc82a658", "section_path": ["变更"], "commit_groups": [["07c1c6ec5", "4f49e4b55", "54f82c4aa", "67a6fd507", "a5f2dc421", "c89510431"]], "identity_text": "Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@ (Chao Li) This could cause poor selectivity estimates to be produced for cases involving the maximum integer value.", "commit_aliases": ["07c1c6ec5", "4f49e4b55", "54f82c4aa", "67a6fd507", "a5f2dc421", "c89510431"], "source_commits": ["c89510431"], "source_entry_id": "15.16/changes/038", "db_id": "81dbabd3964ac7d16575fec8b0e775d4", "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf", "relations": [{"rule": 2, "type": "equivalent", "target": "1285579c66ecba8872eb8b17f3bc4e1b", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}}, {"rule": 2, "type": "equivalent", "target": "59e2d3bf9637de09505f940988dcd182", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}}, {"rule": 2, "type": "equivalent", "target": "8280d414e29b698e7a7b5bdab7d65a67", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}}, {"rule": 2, "type": "equivalent", "target": "e129aabe6a0e432884befb054f303449", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e129aabe6a0e432884befb054f303449", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复 contrib/intarray 中 @@ 选择率估算器的边界情况整数溢出问题", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}, "url": "/docs/compare/?release=18.2#18.2-a45188e655691d38", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "8280d414e29b698e7a7b5bdab7d65a67", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复 contrib/intarray 中 @@ 选择率估算器的边界情况整数溢出问题", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}, "url": "/docs/compare/?release=17.8#17.8-ab6fdf5f76b2dd4a", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "1285579c66ecba8872eb8b17f3bc4e1b", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复 contrib/intarray 中 @@ 选择率估算器的边界情况整数溢出问题", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}, "url": "/docs/compare/?release=16.12#16.12-5a125ae178db396f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "59e2d3bf9637de09505f940988dcd182", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复 contrib/intarray 中 @@ 选择率估算器的边界情况整数溢出问题", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}, "url": "/docs/compare/?release=14.21#14.21-b90e49b89a9df63b", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-a86dbc9d880920b4", "cves": [], "html": "<p>修复 <code>contrib/ltree</code> 中的多字节编码问题（Jeff Davis）<a href=\"https://postgr.es/c/335b2f30b\">§</a></p>\n<p>之前的代码可能将不完整的多字节字符传递给 <code>lower()</code>，可能导致不正确的行为。</p>", "text": "修复 contrib/ltree 中的多字节编码问题（Jeff Davis）§ 之前的代码可能将不完整的多字节字符传递给 lower()，可能导致不正确的行为。", "title": "修复 contrib/ltree 中的多字节编码问题", "commits": ["335b2f30b"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "7455f1562a69c6bf77b1524c7d032a1cafd033cf93ec3c402dd6a9e9fb2a59af", "section_path": ["变更"], "commit_groups": [["335b2f30b", "84d5efa7e", "898991966", "b80227c0a", "b8cfe9dc2", "f79e239e0"]], "identity_text": "Fix multibyte-encoding issue in contrib/ltree (Jeff Davis) The previous coding could pass an incomplete multibyte character to lower(), probably resulting in incorrect behavior.", "commit_aliases": ["335b2f30b", "84d5efa7e", "898991966", "b80227c0a", "b8cfe9dc2", "f79e239e0"], "source_commits": ["335b2f30b"], "source_entry_id": "15.16/changes/039", "db_id": "d10631fe1ac5049f82fdf79ee53d5075", "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8", "relations": [{"rule": 2, "type": "equivalent", "target": "68d5a5585afcd2453c96b9409ff4eb3e", "evidence": {"same_day": true, "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8"}}, {"rule": 2, "type": "equivalent", "target": "81f250eccec05588f1ee61ab46a58eef", "evidence": {"same_day": true, "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8"}}, {"rule": 2, "type": "equivalent", "target": "a7c924b73b0998bc9111869833cc9355", "evidence": {"same_day": true, "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8"}}, {"rule": 2, "type": "equivalent", "target": "d009a076d5863b0968962c0a478ad63c", "evidence": {"same_day": true, "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8"}}], "version": "15.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a7c924b73b0998bc9111869833cc9355", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "修复 contrib/ltree 中的多字节编码问题", "evidence": {"same_day": true, "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8"}, "url": "/docs/compare/?release=18.2#18.2-4b1b9fbd0223faf3", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "d009a076d5863b0968962c0a478ad63c", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "修复 contrib/ltree 中的多字节编码问题", "evidence": {"same_day": true, "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8"}, "url": "/docs/compare/?release=17.8#17.8-cb9f9359b4259ec9", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "81f250eccec05588f1ee61ab46a58eef", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "修复 contrib/ltree 中的多字节编码问题", "evidence": {"same_day": true, "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8"}, "url": "/docs/compare/?release=16.12#16.12-62d738484b043fb5", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "68d5a5585afcd2453c96b9409ff4eb3e", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "修复 contrib/ltree 中的多字节编码问题", "evidence": {"same_day": true, "patch_ids": ["ce03709afde90a593822361bba7a645d"], "statement_hash": "df18b7dd23fc4a736b53dee8298de471bf4398537e381437dba5d40d41b4e8c8"}, "url": "/docs/compare/?release=14.21#14.21-16f0b9fef0baa13b", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}, {"id": "15.16-c4e519f4ba92f2b8", "cves": [], "html": "<p>将时区数据文件更新到 <span>tzdata</span> 2025c 版本（Tom Lane）<a href=\"https://postgr.es/c/00410b76d\">§</a></p>\n<p>唯一的变更是下加利福尼亚 1976 年之前时间戳的历史数据。</p>", "text": "将时区数据文件更新到 tzdata 2025c 版本（Tom Lane）§ 唯一的变更是下加利福尼亚 1976 年之前时间戳的历史数据。", "title": "将时区数据文件更新到 tzdata 2025c 版本", "commits": ["00410b76d"], "section": "变更", "category": "improvement", "source_url": "/docs/release/15.16/#ZH-AUTO-RELEASE-15-SECT2-4", "source_hash": "9d5b124422c2836ccc4a8450343bf565b8df65e422336d13f5d197dfc528448a", "section_path": ["变更"], "commit_groups": [["00410b76d", "228fe0c3e", "6574bee64", "8bbf28191", "d852d105e", "f87c0b84e"]], "identity_text": "Update time zone data files to tzdata release 2025c (Tom Lane) The only change is in historical data for pre-1976 timestamps in Baja California.", "commit_aliases": ["00410b76d", "228fe0c3e", "6574bee64", "8bbf28191", "d852d105e", "f87c0b84e"], "source_commits": ["00410b76d"], "source_entry_id": "15.16/changes/040", "db_id": "8fe4829a60aad3b491b6cf8cc56b6b67", "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b", "relations": [{"rule": 2, "type": "equivalent", "target": "1e212940a15748de8b9d8f9f8a00221c", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}}, {"rule": 2, "type": "equivalent", "target": "6a2a6f129d457a35195c94f742bac1c7", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}}, {"rule": 2, "type": "equivalent", "target": "af6fece6fb7485ca9609d00ddf419b69", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}}, {"rule": 2, "type": "equivalent", "target": "e11e7a4857357ba2a4255391b7eb4033", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}}], "version": "15.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1e212940a15748de8b9d8f9f8a00221c", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "将时区数据文件更新到 tzdata 2025c 版本", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}, "url": "/docs/compare/?release=18.2#18.2-4cbf16ee6dc57970", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "e11e7a4857357ba2a4255391b7eb4033", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "将时区数据文件更新到 tzdata 2025c 版本", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}, "url": "/docs/compare/?release=17.8#17.8-6f023224ced53b65", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "6a2a6f129d457a35195c94f742bac1c7", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "将时区数据文件更新到 tzdata 2025c 版本", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}, "url": "/docs/compare/?release=16.12#16.12-6eb2ba686b659281", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "af6fece6fb7485ca9609d00ddf419b69", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "将时区数据文件更新到 tzdata 2025c 版本", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}, "url": "/docs/compare/?release=14.21#14.21-af62fd071fbac039", "source_url": "/docs/release/14.21/#ZH-AUTO-RELEASE-14-SECT2-4"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 40}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 17}, {"key": "security", "label": "安全相关", "count": 4}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 19}], "total": 40, "release_count": 1, "cross_major": false, "cve_count": 4, "cves": [{"id": "CVE-2026-2006", "url": "https://www.postgresql.org/support/security/CVE-2026-2006/", "fixed": {"14": "14.21", "15": "15.16", "16": "16.12", "17": "17.8", "18": "18.2"}, "score": 8.8, "title": "修复多字节字符长度验证不充分的问题", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2026-2006", "affected": {"14": "14", "15": "15", "16": "16", "17": "17", "18": "18"}, "component": "core server", "published": {"14": "2026-02-12", "15": "2026-02-12", "16": "2026-02-12", "17": "2026-02-12", "18": "2026-02-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Missing validation of multibyte character length in PostgreSQL text manipulation allows a database user to issue crafted queries that achieve a buffer overrun. That suffices to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected.", "affected_ranges": [{"from": "0", "until": "14.21"}, {"from": "15", "until": "15.16"}, {"from": "16", "until": "16.12"}, {"from": "17", "until": "17.8"}, {"from": "18", "until": "18.2"}], "first_published": "2026-02-12", "fixed_version": "15.16"}, {"id": "CVE-2026-2005", "url": "https://www.postgresql.org/support/security/CVE-2026-2005/", "fixed": {"14": "14.21", "15": "15.16", "16": "16.12", "17": "17.8", "18": "18.2"}, "score": 8.8, "title": "修复 contrib/pgcrypto PGP 解密函数中的缓冲区溢出问题", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2026-2005", "affected": {"14": "14", "15": "15", "16": "16", "17": "17", "18": "18"}, "component": "contrib module", "published": {"14": "2026-02-12", "15": "2026-02-12", "16": "2026-02-12", "17": "2026-02-12", "18": "2026-02-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Heap buffer overflow in PostgreSQL pgcrypto allows a ciphertext provider to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected.", "affected_ranges": [{"from": "0", "until": "14.21"}, {"from": "15", "until": "15.16"}, {"from": "16", "until": "16.12"}, {"from": "17", "until": "17.8"}, {"from": "18", "until": "18.2"}], "first_published": "2026-02-12", "fixed_version": "15.16"}, {"id": "CVE-2026-2004", "url": "https://www.postgresql.org/support/security/CVE-2026-2004/", "fixed": {"14": "14.21", "15": "15.16", "16": "16.12", "17": "17.8", "18": "18.2"}, "score": 8.8, "title": "增强选择率估算器在被附加到接受非预期数据类型的操作符时的防护", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2026-2004", "affected": {"14": "14", "15": "15", "16": "16", "17": "17", "18": "18"}, "component": "contrib module", "published": {"14": "2026-02-12", "15": "2026-02-12", "16": "2026-02-12", "17": "2026-02-12", "18": "2026-02-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Missing validation of type of input in PostgreSQL intarray extension selectivity estimator function allows an object creator to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected.", "affected_ranges": [{"from": "0", "until": "14.21"}, {"from": "15", "until": "15.16"}, {"from": "16", "until": "16.12"}, {"from": "17", "until": "17.8"}, {"from": "18", "until": "18.2"}], "first_published": "2026-02-12", "fixed_version": "15.16"}, {"id": "CVE-2026-2003", "url": "https://www.postgresql.org/support/security/CVE-2026-2003/", "fixed": {"14": "14.21", "15": "15.16", "16": "16.12", "17": "17.8", "18": "18.2"}, "score": 4.3, "title": "防止 oidvector/int2vector 出现意外的维度", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2026-2003", "affected": {"14": "14", "15": "15", "16": "16", "17": "17", "18": "18"}, "component": "core server", "published": {"14": "2026-02-12", "15": "2026-02-12", "16": "2026-02-12", "17": "2026-02-12", "18": "2026-02-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Improper validation of type \"oidvector\" in PostgreSQL allows a database user to disclose a few bytes of server memory. We have not ruled out viability of attacks that arrange for presence of confidential information in disclosed bytes, but they seem unlikely. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected.", "affected_ranges": [{"from": "0", "until": "14.21"}, {"from": "15", "until": "15.16"}, {"from": "16", "until": "16.12"}, {"from": "17", "until": "17.8"}, {"from": "18", "until": "18.2"}], "first_published": "2026-02-12", "fixed_version": "15.16"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 40, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}