{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2021-05-13", "build": "13.3", "major": "13", "minor": 3, "manual": "13", "status": "stable", "doc_git": "", "version": "13.3", "eol_date": "2025-11-13", "date_text": "2021-05-13", "supported": false, "manual_url": "/docs/13/release-13-3.html", "source_url": "/docs/release/13.3/", "entry_count": 48, "placeholder": false, "content_hash": "8aea941b160242c9a4cfb6f39548f3d646a63c0353f1f97827b46e44c6aa79e1", "manual_build": "13.23", "source_as_of": "", "changes_count": 48, "doc_loaded_at": "2026-09-26T02:56:40.428744", "migration_html": "<p>对于运行 13.X 的用户，不需要执行导出/恢复。</p>\n<p>但是，如果是从早于 13.2 的版本升级，请参见<a href=\"/docs/13/release-13-2.html\" title=\"E.22. 发布版本 13.2\">第 E.22 节</a>。</p>", "compatibility_count": 0, "label": "13.3", "status_label": "历史版本", "eol": "2025-11-13", "age_days": 1966, "support_days": -321}, "groups": [{"date": "2021-05-13", "build": "13.3", "major": "13", "minor": 3, "manual": "13", "status": "stable", "doc_git": "", "version": "13.3", "eol_date": "2025-11-13", "date_text": "2021-05-13", "supported": false, "manual_url": "/docs/13/release-13-3.html", "source_url": "/docs/release/13.3/", "entry_count": 48, "placeholder": false, "content_hash": "8aea941b160242c9a4cfb6f39548f3d646a63c0353f1f97827b46e44c6aa79e1", "manual_build": "13.23", "source_as_of": "", "changes_count": 48, "doc_loaded_at": "2026-09-26T02:56:40.428744", "migration_html": "<p>对于运行 13.X 的用户，不需要执行导出/恢复。</p>\n<p>但是，如果是从早于 13.2 的版本升级，请参见<a href=\"/docs/13/release-13-2.html\" title=\"E.22. 发布版本 13.2\">第 E.22 节</a>。</p>", "compatibility_count": 0, "label": "13.3", "status_label": "历史版本", "eol": "2025-11-13", "age_days": 1966, "support_days": -321, "entries": [{"id": "13.3-662fbe650093c58f", "cves": ["CVE-2021-32027"], "html": "<p>防止数组下标计算中的整数溢出（Tom Lane）<a href=\"https://postgr.es/c/467395bfd\">§</a></p>\n<p>以前，当数组下界加上长度发生整数溢出时，数组代码不会报错。这会使数组中后面的项无法访问（因为它们的下标无法表示为整数），更重要的是还会干扰后续赋值操作。这可能造成内存覆盖，进而导致崩溃或非预期的数据修改。（CVE-2021-32027）</p>", "text": "防止数组下标计算中的整数溢出（Tom Lane）§ 以前，当数组下界加上长度发生整数溢出时，数组代码不会报错。这会使数组中后面的项无法访问（因为它们的下标无法表示为整数），更重要的是还会干扰后续赋值操作。这可能造成内存覆盖，进而导致崩溃或非预期的数据修改。（CVE-2021-32027）", "title": "防止数组下标计算中的整数溢出", "commits": ["467395bfd"], "section": "变更", "category": "security", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "17a0dbfc23b30e1662d703c521751291abf5bc4d5162b64273f000e2f1727e35", "section_path": ["变更"], "commit_groups": [["06bfbe854", "0c1caa48d", "2fb809d3e", "3b0f6a7ae", "467395bfd", "f02b9085a"]], "identity_text": "Prevent integer overflows in array subscripting calculations (Tom Lane) The array code previously did not complain about cases where an array's lower bound plus length overflows an integer. This resulted in later entries in the array becoming inaccessible (since their subscripts could not be written as integers), but more importantly it confused subsequent assignment operations. This could lead to memory overwrites, with ensuing crashes or unwanted data modifications. (CVE-2021-32027)", "commit_aliases": ["06bfbe854", "0c1caa48d", "2fb809d3e", "3b0f6a7ae", "467395bfd", "f02b9085a"], "source_commits": ["467395bfd"], "source_entry_id": "13.3/changes/001", "db_id": "c8963e580f988547350ccc8ce6625481", "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e", "relations": [{"rule": 2, "type": "equivalent", "target": "4666021688be3025a677f523ae0c8c60", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}}, {"rule": 2, "type": "equivalent", "target": "585fcef5c692b598ea6a152292683b72", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}}, {"rule": 2, "type": "equivalent", "target": "7319e67c7fec827a36de6818c38d93d2", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}}, {"rule": 2, "type": "equivalent", "target": "e4fdf746e5ec58e73f25f64763b1d119", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}}], "version": "13.3", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "e4fdf746e5ec58e73f25f64763b1d119", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "防止数组下标计算中的整数溢出", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}, "url": "/docs/compare/?release=12.7#12.7-ac73d078ce65a7fd", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "7319e67c7fec827a36de6818c38d93d2", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "防止数组下标计算中的整数溢出", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}, "url": "/docs/compare/?release=11.12#11.12-b9c1a3a97eb4a245", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "585fcef5c692b598ea6a152292683b72", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "防止数组下标计算中的整数溢出", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}, "url": "/docs/compare/?release=10.17#10.17-b9c1a3a97eb4a245", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "4666021688be3025a677f523ae0c8c60", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "防止数组下标计算中的整数溢出", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}, "url": "/docs/compare/?release=9.6.22#9.6.22-b9c1a3a97eb4a245", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-0f677eeae1faab2b", "cves": ["CVE-2021-32028"], "html": "<p>修复 <code>INSERT ... ON CONFLICT ... UPDATE</code> 目标列表中对 <span>“<span>junk</span>”</span> 列的错误处理（Tom Lane）<a href=\"https://postgr.es/c/4a8656a7e\">§</a></p>\n<p>如果 <code>UPDATE</code> 列表包含任何多列子查询（它们除了产生正式结果外，还会产生 junk 列），<code>UPDATE</code> 路径最终会存储包含额外 junk 列值的元组。短期内这基本无害，但如果向表中添加新列，这些值就会变得可访问；如果它们与新增列的数据类型不匹配，就可能导致异常。</p>\n<p>此外，在支持跨分区更新的版本中，由此类情况触发的跨分区更新存在相反的问题：junk 列被从目标列表中移除，通常会因多列子查询机制失效而立即崩溃。（CVE-2021-32028）</p>", "text": "修复 INSERT ... ON CONFLICT ... UPDATE 目标列表中对 “junk” 列的错误处理（Tom Lane）§ 如果 UPDATE 列表包含任何多列子查询（它们除了产生正式结果外，还会产生 junk 列），UPDATE 路径最终会存储包含额外 junk 列值的元组。短期内这基本无害，但如果向表中添加新列，这些值就会变得可访问；如果它们与新增列的数据类型不匹配，就可能导致异常。 此外，在支持跨分区更新的版本中，由此类情况触发的跨分区更新存在相反的问题：junk 列被从目标列表中移除，通常会因多列子查询机制失效而立即崩溃。（CVE-2021-32028）", "title": "修复 INSERT ... ON CONFLICT ... UPDATE 目标列表中对 “junk” 列的错误处理", "commits": ["4a8656a7e"], "section": "变更", "category": "security", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "ef2c6243bb1ab46a774cc148a882e2f07557fcd607898a9bda9a6ed67c3243b5", "section_path": ["变更"], "commit_groups": [["049e1e2ed", "0fcb8e2e0", "4a8656a7e", "52a441362", "a5fa3e067", "b7d1f32ff"]], "identity_text": "Fix mishandling of junk columns in INSERT ... ON CONFLICT ... UPDATE target lists (Tom Lane) If the UPDATE list contains any multi-column sub-selects (which give rise to junk columns in addition to the results proper), the UPDATE path would end up storing tuples that include the values of the extra junk columns. That's fairly harmless in the short run, but if new columns are added to the table then the values would become accessible, possibly leading to malfunctions if they don't match the datatypes of the added columns. In addition, in versions supporting cross-partition updates, a cross-partition update triggered by such a case had the reverse problem: the junk columns were removed from the target list, typically causing an immediate crash due to malfunction of the multi-column sub-select mechanism. (CVE-2021-32028)", "commit_aliases": ["049e1e2ed", "0fcb8e2e0", "4a8656a7e", "52a441362", "a5fa3e067", "b7d1f32ff"], "source_commits": ["4a8656a7e"], "source_entry_id": "13.3/changes/002", "db_id": "cfea65ca9d40576b1d0602eaccf39e2a", "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe", "relations": [{"rule": 2, "type": "equivalent", "target": "2ee7e4bc11ce6a07ec695882d5d4830d", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}}, {"rule": 2, "type": "equivalent", "target": "3f2c9193965eda4138ae7d054f8f1a9b", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}}, {"rule": 2, "type": "equivalent", "target": "402ddf1823a78b25bc4bae8aa78148a5", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}}, {"rule": 2, "type": "equivalent", "target": "d7b2c329c0c08a8f6a79de7573c441e0", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}}], "version": "13.3", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7b2c329c0c08a8f6a79de7573c441e0", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 INSERT ... ON CONFLICT ... UPDATE 目标列表中对 “junk” 列的错误处理", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}, "url": "/docs/compare/?release=12.7#12.7-99371ae3858378c5", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "402ddf1823a78b25bc4bae8aa78148a5", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 INSERT ... ON CONFLICT ... UPDATE 目标列表中对 “junk” 列的错误处理", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}, "url": "/docs/compare/?release=11.12#11.12-e7be457a4c664006", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "2ee7e4bc11ce6a07ec695882d5d4830d", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 INSERT ... ON CONFLICT ... UPDATE 目标列表中对 “junk” 列的错误处理", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}, "url": "/docs/compare/?release=10.17#10.17-e7be457a4c664006", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "3f2c9193965eda4138ae7d054f8f1a9b", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 INSERT ... ON CONFLICT ... UPDATE 目标列表中“垃圾”列的处理不当", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}, "url": "/docs/compare/?release=9.6.22#9.6.22-98b39e1ef9c989a0", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-461a1b783bb96232", "cves": ["CVE-2021-32029"], "html": "<p>修复涉及连接的跨分区更新中 <code>UPDATE ... RETURNING</code> 输出可能计算不正确的问题（Amit Langote，Etsuro Fujita）<a href=\"https://postgr.es/c/a71cfc56b\">§</a> <a href=\"https://postgr.es/c/2602ee468\">§</a></p>\n<p>如果对分区表的 <code>UPDATE</code> 使某行被移动到另一个行类型在物理上不同的分区（例如，已删除列的集合不同），为该行计算 <code>RETURNING</code> 结果时可能报错或得到错误的结果。只有当 <code>UPDATE</code> 涉及将其他表连接到目标表时，才会出现此错误。（CVE-2021-32029）</p>", "text": "修复涉及连接的跨分区更新中 UPDATE ... RETURNING 输出可能计算不正确的问题（Amit Langote，Etsuro Fujita）§ § 如果对分区表的 UPDATE 使某行被移动到另一个行类型在物理上不同的分区（例如，已删除列的集合不同），为该行计算 RETURNING 结果时可能报错或得到错误的结果。只有当 UPDATE 涉及将其他表连接到目标表时，才会出现此错误。（CVE-2021-32029）", "title": "修复涉及连接的跨分区更新中 UPDATE ... RETURNING 输出可能计算不正确的问题", "commits": ["2602ee468", "a71cfc56b"], "section": "变更", "category": "security", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "0dc06f252a1ba2d58030408195da44792e5b34f678bcb1d718e4c9c266c04cb5", "section_path": ["变更"], "commit_groups": [["05ce4bf8b", "2602ee468", "d479d0028"], ["27835b547", "3fb93103a", "a71cfc56b"]], "identity_text": "Fix possibly-incorrect computation of UPDATE ... RETURNING outputs for joined cross-partition updates (Amit Langote, Etsuro Fujita) If an UPDATE for a partitioned table caused a row to be moved to another partition with a physically different row type (for example, one with a different set of dropped columns), computation of RETURNING results for that row could produce errors or wrong answers. No error is observed unless the UPDATE involves other tables being joined to the target table. (CVE-2021-32029)", "commit_aliases": ["05ce4bf8b", "2602ee468", "27835b547", "3fb93103a", "a71cfc56b", "d479d0028"], "source_commits": ["2602ee468", "a71cfc56b"], "source_entry_id": "13.3/changes/003", "db_id": "bb8dab28c2438324c2fbbb0a15d05607", "patch_ids": ["4b6de9a8da283c26f1d52bed588ac8ec", "59f5b873ec775c043e3186fe13c6928f"], "statement_hash": "c5ecec847bdeb73017325ced49ff319dab73f02e4492ea08654637f4ae2a8b4f", "relations": [{"rule": 2, "type": "equivalent", "target": "17aef93b63211704b731238d79b74391", "evidence": {"same_day": true, "patch_ids": ["4b6de9a8da283c26f1d52bed588ac8ec", "59f5b873ec775c043e3186fe13c6928f"], "statement_hash": "c5ecec847bdeb73017325ced49ff319dab73f02e4492ea08654637f4ae2a8b4f"}}, {"rule": 2, "type": "equivalent", "target": "cfb5cf809874e73302363c7d3dc4ff43", "evidence": {"same_day": true, "patch_ids": ["4b6de9a8da283c26f1d52bed588ac8ec", "59f5b873ec775c043e3186fe13c6928f"], "statement_hash": "c5ecec847bdeb73017325ced49ff319dab73f02e4492ea08654637f4ae2a8b4f"}}], "version": "13.3", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "cfb5cf809874e73302363c7d3dc4ff43", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复涉及连接的跨分区更新中 UPDATE ... RETURNING 输出可能计算不正确的问题", "evidence": {"same_day": true, "patch_ids": ["4b6de9a8da283c26f1d52bed588ac8ec", "59f5b873ec775c043e3186fe13c6928f"], "statement_hash": "c5ecec847bdeb73017325ced49ff319dab73f02e4492ea08654637f4ae2a8b4f"}, "url": "/docs/compare/?release=12.7#12.7-95661281b11218c0", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "17aef93b63211704b731238d79b74391", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复涉及连接的跨分区更新中 UPDATE ... RETURNING 输出可能计算不正确的问题", "evidence": {"same_day": true, "patch_ids": ["4b6de9a8da283c26f1d52bed588ac8ec", "59f5b873ec775c043e3186fe13c6928f"], "statement_hash": "c5ecec847bdeb73017325ced49ff319dab73f02e4492ea08654637f4ae2a8b4f"}, "url": "/docs/compare/?release=11.12#11.12-b2c64411aebb82c4", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}]}, {"id": "13.3-eea1f3f4d9f457ac", "cves": [], "html": "<p>修复分区表中约束可延迟属性的调整（Álvaro Herrera）<a href=\"https://postgr.es/c/923c13520\">§</a></p>\n<p>对分区表的外键约束执行 <code>ALTER TABLE ... ALTER CONSTRAINT</code> 时，未能调整叶子分区的约束和触发器上的 <code>DEFERRABLE</code> 或 <code>INITIALLY DEFERRED</code> 标记。这导致此类约束产生非预期的行为。更新到此版本后，可以执行新的 <code>ALTER</code> 命令设置所需属性，从而修复行为异常的分区表。</p>\n<p>此项修改还禁止直接对叶子分区的约束执行这样的 <code>ALTER</code>。唯一受支持的情况是整个分区层次结构具有相同的约束属性，因此此类 <code>ALTER</code> 必须在分区根表上执行。</p>", "text": "修复分区表中约束可延迟属性的调整（Álvaro Herrera）§ 对分区表的外键约束执行 ALTER TABLE ... ALTER CONSTRAINT 时，未能调整叶子分区的约束和触发器上的 DEFERRABLE 或 INITIALLY DEFERRED 标记。这导致此类约束产生非预期的行为。更新到此版本后，可以执行新的 ALTER 命令设置所需属性，从而修复行为异常的分区表。 此项修改还禁止直接对叶子分区的约束执行这样的 ALTER。唯一受支持的情况是整个分区层次结构具有相同的约束属性，因此此类 ALTER 必须在分区根表上执行。", "title": "修复分区表中约束可延迟属性的调整", "commits": ["923c13520"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "8ff98407c0682f0cf2a7831d7090b4e4130ff232ad71dcf6ed001db214105ced", "section_path": ["变更"], "commit_groups": [["6f70d7ca1", "923c13520", "a25b98d2c", "abce26c9e"]], "identity_text": "Fix adjustment of constraint deferrability properties in partitioned tables (Álvaro Herrera) When applied to a foreign-key constraint of a partitioned table, ALTER TABLE ... ALTER CONSTRAINT failed to adjust the DEFERRABLE and/or INITIALLY DEFERRED markings of the constraints and triggers of leaf partitions. This led to unexpected behavior of such constraints. After updating to this version, any misbehaving partitioned tables can be fixed by executing a new ALTER command to set the desired properties. This change also disallows applying such an ALTER directly to the constraints of leaf partitions. The only supported case is for the whole partitioning hierarchy to have identical constraint properties, so such ALTERs must be applied at the partition root.", "commit_aliases": ["6f70d7ca1", "923c13520", "a25b98d2c", "abce26c9e"], "source_commits": ["923c13520"], "source_entry_id": "13.3/changes/004", "db_id": "901a80146c077a10ce605a379d2dfd9a", "patch_ids": ["62d4402fc656081298bdf5218b024394"], "statement_hash": "61e14781133723654876c626f5e0f49e124f245b5fb26e2f3b819f92bf31484b", "relations": [{"rule": 2, "type": "equivalent", "target": "10c8e1a8e2dfe66ad3e098a43d5a70bd", "evidence": {"same_day": true, "patch_ids": ["62d4402fc656081298bdf5218b024394"], "statement_hash": "61e14781133723654876c626f5e0f49e124f245b5fb26e2f3b819f92bf31484b"}}, {"rule": 2, "type": "equivalent", "target": "c996e105d80be80e0ab7058f658efe12", "evidence": {"same_day": true, "patch_ids": ["62d4402fc656081298bdf5218b024394"], "statement_hash": "61e14781133723654876c626f5e0f49e124f245b5fb26e2f3b819f92bf31484b"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c996e105d80be80e0ab7058f658efe12", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复分区表中约束可延迟属性的调整", "evidence": {"same_day": true, "patch_ids": ["62d4402fc656081298bdf5218b024394"], "statement_hash": "61e14781133723654876c626f5e0f49e124f245b5fb26e2f3b819f92bf31484b"}, "url": "/docs/compare/?release=12.7#12.7-53786c613060530b", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "10c8e1a8e2dfe66ad3e098a43d5a70bd", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复分区表中约束可延迟属性的调整", "evidence": {"same_day": true, "patch_ids": ["62d4402fc656081298bdf5218b024394"], "statement_hash": "61e14781133723654876c626f5e0f49e124f245b5fb26e2f3b819f92bf31484b"}, "url": "/docs/compare/?release=11.12#11.12-e2763f28c2b59bf6", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}]}, {"id": "13.3-390684b4e414cf9f", "cves": [], "html": "<p>使用 <code>ALTER TABLE ... INHERIT</code> 附加子表时，要求子表中与父表生成列对应的列以相同方式生成（Peter Eisentraut）<a href=\"https://postgr.es/c/64190d65f\">§</a></p>", "text": "使用 ALTER TABLE ... INHERIT 附加子表时，要求子表中与父表生成列对应的列以相同方式生成（Peter Eisentraut）§", "title": "使用 ALTER TABLE ... INHERIT 附加子表时，要求子表中与父表生成列对应的列以相同方式生成", "commits": ["64190d65f"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "73fc19532cd597393a0c4bf74abf3be5bbbaeb35e955e6460abf65e05cbd9d1f", "section_path": ["变更"], "commit_groups": [["13ff139a2", "64190d65f", "a970edbed"]], "identity_text": "When attaching a child table with ALTER TABLE ... INHERIT, insist that any generated columns in the parent be generated the same way in the child (Peter Eisentraut)", "commit_aliases": ["13ff139a2", "64190d65f", "a970edbed"], "source_commits": ["64190d65f"], "source_entry_id": "13.3/changes/005", "db_id": "48f6f42de98adfa33bea6afaafb9b8c4", "patch_ids": ["c87835393275ab1e417ccf6e96334a3e"], "statement_hash": "2f21107a3bcfda6ef7e75eae87d409cdfc2d6ebda2af68e3e2c138f1ac3b5738", "relations": [{"rule": 2, "type": "equivalent", "target": "1b1797d3dc775d1c02f8fd9878d9c2bc", "evidence": {"same_day": true, "patch_ids": ["c87835393275ab1e417ccf6e96334a3e"], "statement_hash": "2f21107a3bcfda6ef7e75eae87d409cdfc2d6ebda2af68e3e2c138f1ac3b5738"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1b1797d3dc775d1c02f8fd9878d9c2bc", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "使用 ALTER TABLE ... INHERIT 附加子表时，要求子表中与父表生成列对应的列以相同方式生成", "evidence": {"same_day": true, "patch_ids": ["c87835393275ab1e417ccf6e96334a3e"], "statement_hash": "2f21107a3bcfda6ef7e75eae87d409cdfc2d6ebda2af68e3e2c138f1ac3b5738"}, "url": "/docs/compare/?release=12.7#12.7-63131a61ed07139b", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-e079971e9d9be355", "cves": [], "html": "<p>禁止将标识列标记为可空（Vik Fearing）<a href=\"https://postgr.es/c/8a2297776\">§</a></p>\n<p><code>GENERATED ... AS IDENTITY</code> 隐含 <code>NOT NULL</code>，因此不允许将其与显式的 <code>NULL</code> 指定结合使用。</p>", "text": "禁止将标识列标记为可空（Vik Fearing）§ GENERATED ... AS IDENTITY 隐含 NOT NULL，因此不允许将其与显式的 NULL 指定结合使用。", "title": "禁止将标识列标记为可空", "commits": ["8a2297776"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "68510cd47d064a52d9f3850d9e0cd940c8cf07593288dd8ee7061270abd4711c", "section_path": ["变更"], "commit_groups": [["6c34f186c", "8a2297776", "e5794cd59", "e7f7950f6", "f52c5d674"]], "identity_text": "Forbid marking an identity column as nullable (Vik Fearing) GENERATED ... AS IDENTITY implies NOT NULL, so don't allow it to be combined with an explicit NULL specification.", "commit_aliases": ["6c34f186c", "8a2297776", "e5794cd59", "e7f7950f6", "f52c5d674"], "source_commits": ["8a2297776"], "source_entry_id": "13.3/changes/006", "db_id": "0cefb6fcfeda026ab2cfaf8d2f0232d0", "patch_ids": ["c6a30ddc3756be0ba7a308befcf92919"], "statement_hash": "d9461fefbc7fa417e2b80da03b0cdef880a20929e723c5cf7c6a0d920ed7d207", "relations": [{"rule": 2, "type": "equivalent", "target": "a8ef262a8215203a52d61fac76044fca", "evidence": {"same_day": true, "patch_ids": ["c6a30ddc3756be0ba7a308befcf92919"], "statement_hash": "d9461fefbc7fa417e2b80da03b0cdef880a20929e723c5cf7c6a0d920ed7d207"}}, {"rule": 2, "type": "equivalent", "target": "ccee0fd6c7ad08f0376124df1d37a504", "evidence": {"same_day": true, "patch_ids": ["c6a30ddc3756be0ba7a308befcf92919"], "statement_hash": "d9461fefbc7fa417e2b80da03b0cdef880a20929e723c5cf7c6a0d920ed7d207"}}, {"rule": 2, "type": "equivalent", "target": "ebbf4389d2b9f02a5b914ea771ef13bd", "evidence": {"same_day": true, "patch_ids": ["c6a30ddc3756be0ba7a308befcf92919"], "statement_hash": "d9461fefbc7fa417e2b80da03b0cdef880a20929e723c5cf7c6a0d920ed7d207"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "ebbf4389d2b9f02a5b914ea771ef13bd", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "禁止将标识列标记为可空", "evidence": {"same_day": true, "patch_ids": ["c6a30ddc3756be0ba7a308befcf92919"], "statement_hash": "d9461fefbc7fa417e2b80da03b0cdef880a20929e723c5cf7c6a0d920ed7d207"}, "url": "/docs/compare/?release=12.7#12.7-e61efb40b0603453", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "ccee0fd6c7ad08f0376124df1d37a504", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "禁止将标识列标记为可空", "evidence": {"same_day": true, "patch_ids": ["c6a30ddc3756be0ba7a308befcf92919"], "statement_hash": "d9461fefbc7fa417e2b80da03b0cdef880a20929e723c5cf7c6a0d920ed7d207"}, "url": "/docs/compare/?release=11.12#11.12-ff07d76263b8dbe8", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "a8ef262a8215203a52d61fac76044fca", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "禁止将标识列标记为可空", "evidence": {"same_day": true, "patch_ids": ["c6a30ddc3756be0ba7a308befcf92919"], "statement_hash": "d9461fefbc7fa417e2b80da03b0cdef880a20929e723c5cf7c6a0d920ed7d207"}, "url": "/docs/compare/?release=10.17#10.17-ff07d76263b8dbe8", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-5941ada8f8acfccd", "cves": [], "html": "<p>允许 <code>ALTER ROLE/DATABASE ... SET</code> 设置 <code>role</code>、<code>session_authorization</code> 和 <code>temp_buffers</code> 参数（Tom Lane）<a href=\"https://postgr.es/c/c39aa1e87\">§</a></p>\n<p>以前，过于急切的有效性检查可能拒绝这些命令，即使相关值在之后实际使用时本可以正常工作。这使转储/重载和升级场景中出现了命令顺序方面的隐患。</p>", "text": "允许 ALTER ROLE/DATABASE ... SET 设置 role、session_authorization 和 temp_buffers 参数（Tom Lane）§ 以前，过于急切的有效性检查可能拒绝这些命令，即使相关值在之后实际使用时本可以正常工作。这使转储/重载和升级场景中出现了命令顺序方面的隐患。", "title": "允许 ALTER ROLE/DATABASE ... SET 设置 role、session_authorization 和 temp_buffers 参数", "commits": ["c39aa1e87"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "006f05675827f428a7f67385acf06385d1de0549877af4bccafa3a43a7548656", "section_path": ["变更"], "commit_groups": [["041f4efd2", "46b6635b7", "69d5ca484", "a7fcb6285", "c39aa1e87", "c7f0275fb"]], "identity_text": "Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters (Tom Lane) Previously, over-eager validity checks might reject these commands, even if the values would have worked when used later. This created a command ordering hazard for dump/reload and upgrade scenarios.", "commit_aliases": ["041f4efd2", "46b6635b7", "69d5ca484", "a7fcb6285", "c39aa1e87", "c7f0275fb"], "source_commits": ["c39aa1e87"], "source_entry_id": "13.3/changes/007", "db_id": "d0451410730607800b5df7d2e7948715", "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3", "relations": [{"rule": 2, "type": "equivalent", "target": "043ff6cd519d8bec7a87d4f43ead62c5", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}}, {"rule": 2, "type": "equivalent", "target": "c3314c5d1c83f2209c3e6d3b60ed537c", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}}, {"rule": 2, "type": "equivalent", "target": "d86c969ac905b3cd2d03d2be6b46b1ae", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}}, {"rule": 2, "type": "equivalent", "target": "e97862062ce0ecf8f4295eda9e69b3e7", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e97862062ce0ecf8f4295eda9e69b3e7", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "允许 ALTER ROLE/DATABASE ... SET 设置 role、session_authorization 和 temp_buffers 参数", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}, "url": "/docs/compare/?release=12.7#12.7-5aef3b1587010883", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "d86c969ac905b3cd2d03d2be6b46b1ae", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "允许 ALTER ROLE/DATABASE ... SET 设置 role、session_authorization 和 temp_buffers 参数", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}, "url": "/docs/compare/?release=11.12#11.12-3abda7d90ef80e1f", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "c3314c5d1c83f2209c3e6d3b60ed537c", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "允许 ALTER ROLE/DATABASE ... SET 设置 role、session_authorization 和 temp_buffers 参数", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}, "url": "/docs/compare/?release=10.17#10.17-3abda7d90ef80e1f", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "043ff6cd519d8bec7a87d4f43ead62c5", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "允许 ALTER ROLE/DATABASE ... SET 设置 role、session_authorization 和 temp_buffers 参数", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}, "url": "/docs/compare/?release=9.6.22#9.6.22-3abda7d90ef80e1f", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-8c7c04a7d6b85c90", "cves": [], "html": "<p>确保 <code>REINDEX CONCURRENTLY</code> 保留为索引设置的统计目标（Michael Paquier）<a href=\"https://postgr.es/c/849383138\">§</a> <a href=\"https://postgr.es/c/c6cd20d91\">§</a></p>", "text": "确保 REINDEX CONCURRENTLY 保留为索引设置的统计目标（Michael Paquier）§ §", "title": "确保 REINDEX CONCURRENTLY 保留为索引设置的统计目标", "commits": ["849383138", "c6cd20d91"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "0ab0ef18e900c20dfce90cbf7aee8862d181a90d4da66d95605a849fe37de4aa", "section_path": ["变更"], "commit_groups": [["4f4726005", "5b2945ec0", "c6cd20d91"], ["849383138", "85edb1f26", "bd1208098"]], "identity_text": "Ensure that REINDEX CONCURRENTLY preserves any statistics target that's been set for the index (Michael Paquier)", "commit_aliases": ["4f4726005", "5b2945ec0", "849383138", "85edb1f26", "bd1208098", "c6cd20d91"], "source_commits": ["849383138", "c6cd20d91"], "source_entry_id": "13.3/changes/008", "db_id": "c38cb19cae4d086aa40fbe424eab93cb", "patch_ids": ["7d975fc56fcb5a6c23adfd414a6392cd", "db3a5462fabeb5d3b7d5dd9828d33f38"], "statement_hash": "08713a3cca565e03a5f2b4fde5b84b5fe3a83e607d48a60ad38727da36d787f3", "relations": [{"rule": 2, "type": "equivalent", "target": "51fe1d6c5529388a0d9a0dc19a35d4ca", "evidence": {"same_day": true, "patch_ids": ["7d975fc56fcb5a6c23adfd414a6392cd", "db3a5462fabeb5d3b7d5dd9828d33f38"], "statement_hash": "08713a3cca565e03a5f2b4fde5b84b5fe3a83e607d48a60ad38727da36d787f3"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "51fe1d6c5529388a0d9a0dc19a35d4ca", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "确保 REINDEX CONCURRENTLY 保留为索引设置的统计目标", "evidence": {"same_day": true, "patch_ids": ["7d975fc56fcb5a6c23adfd414a6392cd", "db3a5462fabeb5d3b7d5dd9828d33f38"], "statement_hash": "08713a3cca565e03a5f2b4fde5b84b5fe3a83e607d48a60ad38727da36d787f3"}, "url": "/docs/compare/?release=12.7#12.7-0fc8b473d2546509", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-aa9261392bd3a839", "cves": [], "html": "<p>修复 <code>COMMIT AND CHAIN</code>，使其在当前事务存在有效保存点时正确工作（Fujii Masao）<a href=\"https://postgr.es/c/422012c98\">§</a></p>", "text": "修复 COMMIT AND CHAIN，使其在当前事务存在有效保存点时正确工作（Fujii Masao）§", "title": "修复 COMMIT AND CHAIN，使其在当前事务存在有效保存点时正确工作", "commits": ["422012c98"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "0806df12c83c63f7a28ad78f24a6c680d9d2d83baf0a056bfdc460c3defb0493", "section_path": ["变更"], "commit_groups": [["422012c98", "8a55cb5ba", "fadcc4e81"]], "identity_text": "Fix COMMIT AND CHAIN to work correctly when the current transaction has live savepoints (Fujii Masao)", "commit_aliases": ["422012c98", "8a55cb5ba", "fadcc4e81"], "source_commits": ["422012c98"], "source_entry_id": "13.3/changes/009", "db_id": "45cdf2a85df3bbd0540d4024eea0c691", "patch_ids": ["15ef31f2428cffe09a77a8fccd329fef"], "statement_hash": "82dd7adcd1a5d8a068aedef243d243442c03f97dd317742add7657f75e165018", "relations": [{"rule": 2, "type": "equivalent", "target": "443da0d32495d27dd8d0238a97f77c4b", "evidence": {"same_day": true, "patch_ids": ["15ef31f2428cffe09a77a8fccd329fef"], "statement_hash": "82dd7adcd1a5d8a068aedef243d243442c03f97dd317742add7657f75e165018"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "443da0d32495d27dd8d0238a97f77c4b", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 COMMIT AND CHAIN，使其在当前事务存在有效保存点时正确工作", "evidence": {"same_day": true, "patch_ids": ["15ef31f2428cffe09a77a8fccd329fef"], "statement_hash": "82dd7adcd1a5d8a068aedef243d243442c03f97dd317742add7657f75e165018"}, "url": "/docs/compare/?release=12.7#12.7-415fd68e1492c446", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-64ccf588730fbfc0", "cves": [], "html": "<p>修复 <code>WITH RECURSIVE</code> 处理中的列表操作缺陷（Michael Paquier，Tom Lane）<a href=\"https://postgr.es/c/49076fd3b\">§</a></p>\n<p>足够深的 <code>WITH</code> 结构嵌套（至少七层）会触发核心转储，或错误地报告 <code>WITH</code> 嵌套有误。</p>", "text": "修复 WITH RECURSIVE 处理中的列表操作缺陷（Michael Paquier，Tom Lane）§ 足够深的 WITH 结构嵌套（至少七层）会触发核心转储，或错误地报告 WITH 嵌套有误。", "title": "修复 WITH RECURSIVE 处理中的列表操作缺陷", "commits": ["49076fd3b"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "d0499f588f8e5ed5bef29f77c14e10a06fa5553f0a37fc0b3806145397d35855", "section_path": ["变更"], "commit_groups": [["49076fd3b", "80ca8464f"]], "identity_text": "Fix list-manipulation bug in WITH RECURSIVE processing (Michael Paquier, Tom Lane) Sufficiently deep nesting of WITH constructs (at least seven levels) triggered core dumps or incorrect complaints of faulty WITH nesting.", "commit_aliases": ["49076fd3b", "80ca8464f"], "source_commits": ["49076fd3b"], "source_entry_id": "13.3/changes/010", "db_id": "e8addd1566cef41038e0e820d47121ab", "patch_ids": ["73a7adfe5753ec94f5d7a2e7937dbb68"], "statement_hash": "8269d4952b73a660894d8fe639098d051fb8f00eacc0a693138e3424e0c9f486", "relations": [], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-10f61f6d7ee10895", "cves": [], "html": "<p>修复将 <code>COLLATE</code> 表达式的结果强制转换为不支持排序规则的类型时的缺陷（Tom Lane）<a href=\"https://postgr.es/c/8a7bd1e6c\">§</a></p>\n<p>这会生成一棵语法解析树，其中 <code>COLLATE</code> 看起来被应用于一个不支持排序规则的值。虽然这通常没有实际影响（因为 <code>COLLATE</code> 在运行时没有作用），但仍有可能构造出在转储/重载期间被拒绝的视图。</p>", "text": "修复将 COLLATE 表达式的结果强制转换为不支持排序规则的类型时的缺陷（Tom Lane）§ 这会生成一棵语法解析树，其中 COLLATE 看起来被应用于一个不支持排序规则的值。虽然这通常没有实际影响（因为 COLLATE 在运行时没有作用），但仍有可能构造出在转储/重载期间被拒绝的视图。", "title": "修复将 COLLATE 表达式的结果强制转换为不支持排序规则的类型时的缺陷", "commits": ["8a7bd1e6c"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "4a2216b7ecf11f81ad469afd94f8e629e44e8484d47d860832ee061d4191048c", "section_path": ["变更"], "commit_groups": [["27011bcff", "4b0aecee8", "8a7bd1e6c", "a6158a4d9", "c402b02b9", "fb2cca828"]], "identity_text": "Fix bug with coercing the result of a COLLATE expression to a non-collatable type (Tom Lane) This led to a parse tree in which the COLLATE appears to be applied to a non-collatable value. While that normally has no real impact (since COLLATE has no effect at runtime), it was possible to construct views that would be rejected during dump/reload.", "commit_aliases": ["27011bcff", "4b0aecee8", "8a7bd1e6c", "a6158a4d9", "c402b02b9", "fb2cca828"], "source_commits": ["8a7bd1e6c"], "source_entry_id": "13.3/changes/011", "db_id": "abb30bf8744a5d98736b8e5e85968d25", "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f", "relations": [{"rule": 2, "type": "equivalent", "target": "03872d51902341e78f3762c12e74634c", "evidence": {"same_day": true, "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f"}}, {"rule": 2, "type": "equivalent", "target": "1bb34a32c748fc13ad726d873d811614", "evidence": {"same_day": true, "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f"}}, {"rule": 2, "type": "equivalent", "target": "3c7c8c72920e227ad94cb3a912c954a5", "evidence": {"same_day": true, "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f"}}, {"rule": 2, "type": "equivalent", "target": "90665f926fa6dc60b6efb5c5b4db356a", "evidence": {"same_day": true, "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "1bb34a32c748fc13ad726d873d811614", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复将 COLLATE 表达式的结果强制转换为不支持排序规则的类型时的缺陷", "evidence": {"same_day": true, "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f"}, "url": "/docs/compare/?release=12.7#12.7-35665a6ec9cbc3cc", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "3c7c8c72920e227ad94cb3a912c954a5", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复将 COLLATE 表达式的结果强制转换为不支持排序规则的类型时的缺陷", "evidence": {"same_day": true, "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f"}, "url": "/docs/compare/?release=11.12#11.12-f512b9a88d6d0840", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "03872d51902341e78f3762c12e74634c", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复将 COLLATE 表达式的结果强制转换为不支持排序规则的类型时的缺陷", "evidence": {"same_day": true, "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f"}, "url": "/docs/compare/?release=10.17#10.17-f512b9a88d6d0840", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "90665f926fa6dc60b6efb5c5b4db356a", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复把 COLLATE 表达式的结果强制转换为不可排序类型时的 bug", "evidence": {"same_day": true, "patch_ids": ["bc0c38dd5368211113518f2d7e77a821"], "statement_hash": "49b9c831678d626b93a4bd08bec89d247290b5683b70b76c3d6980072d2f357f"}, "url": "/docs/compare/?release=9.6.22#9.6.22-2768e5dc2468676c", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-abdc152e14cb409f", "cves": [], "html": "<p>修复为 <code>AFTER</code> 触发器保存元组时的释放后使用缺陷（Amit Langote）<a href=\"https://postgr.es/c/2688852a4\">§</a></p>\n<p>这在某些情况下可能导致崩溃。</p>", "text": "修复为 AFTER 触发器保存元组时的释放后使用缺陷（Amit Langote）§ 这在某些情况下可能导致崩溃。", "title": "修复为 AFTER 触发器保存元组时的释放后使用缺陷", "commits": ["2688852a4"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "722664df1ccb4101acef309588490a49540fb97ecf5f05078c4d14941cc35d08", "section_path": ["变更"], "commit_groups": [["25936fd46", "262eb990c", "2688852a4"]], "identity_text": "Fix use-after-free bug in saving tuples for AFTER triggers (Amit Langote) This could cause crashes in some situations.", "commit_aliases": ["25936fd46", "262eb990c", "2688852a4"], "source_commits": ["2688852a4"], "source_entry_id": "13.3/changes/012", "db_id": "eeae21700f5b61c6da643158de541e80", "patch_ids": ["e930f83e6b676948d8ec23e440ef2b9e"], "statement_hash": "f33c46d06cc94392cd131fc9113ad371a29406aa2dc86176de4c7c7a9926cadb", "relations": [{"rule": 2, "type": "equivalent", "target": "815a9207b62cee7f514d44a006b40da3", "evidence": {"same_day": true, "patch_ids": ["e930f83e6b676948d8ec23e440ef2b9e"], "statement_hash": "f33c46d06cc94392cd131fc9113ad371a29406aa2dc86176de4c7c7a9926cadb"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "815a9207b62cee7f514d44a006b40da3", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复为 AFTER 触发器保存元组时的释放后使用缺陷", "evidence": {"same_day": true, "patch_ids": ["e930f83e6b676948d8ec23e440ef2b9e"], "statement_hash": "f33c46d06cc94392cd131fc9113ad371a29406aa2dc86176de4c7c7a9926cadb"}, "url": "/docs/compare/?release=12.7#12.7-f726eb3230fd1762", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-073a4739a4f40fc4", "cves": [], "html": "<p>禁止通过<span>“<span>快速路径</span>”</span>线协议消息调用窗口函数和过程（Tom Lane）<a href=\"https://postgr.es/c/4d225ba0e\">§</a></p>\n<p>这里只支持普通函数。虽然尝试调用聚合函数已经会失败，但调用窗口函数会导致崩溃，而调用过程只有在过程不进行事务控制时才能正常工作。</p>", "text": "禁止通过“快速路径”线协议消息调用窗口函数和过程（Tom Lane）§ 这里只支持普通函数。虽然尝试调用聚合函数已经会失败，但调用窗口函数会导致崩溃，而调用过程只有在过程不进行事务控制时才能正常工作。", "title": "禁止通过“快速路径”线协议消息调用窗口函数和过程", "commits": ["4d225ba0e"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "c85dd1fe945e08a5554a43485649c87db233481e0586e7d0aafdcfa85fe50b8e", "section_path": ["变更"], "commit_groups": [["0627f3630", "2efcd502e", "4d225ba0e", "73bad52a9", "89768ee69", "ebc2ff076"]], "identity_text": "Disallow calling window functions and procedures via the fast path wire protocol message (Tom Lane) Only plain functions are supported here. While trying to call an aggregate function failed already, calling a window function would crash, and calling a procedure would work only if the procedure did no transaction control.", "commit_aliases": ["0627f3630", "2efcd502e", "4d225ba0e", "73bad52a9", "89768ee69", "ebc2ff076"], "source_commits": ["4d225ba0e"], "source_entry_id": "13.3/changes/013", "db_id": "7778f3a32b2fa6ab9761805a1e3b4fba", "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1", "relations": [{"rule": 2, "type": "equivalent", "target": "03906a7c8653f859466c2026e48f63c6", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}}, {"rule": 2, "type": "equivalent", "target": "1b8f2a45a9d2e935788f99131bc2b253", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}}, {"rule": 2, "type": "equivalent", "target": "dea30517e2656d30b3618508113e7285", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}}, {"rule": 2, "type": "equivalent", "target": "e8af7a374034d509284f19f6cc78df61", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "03906a7c8653f859466c2026e48f63c6", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "禁止通过“快速路径”线协议消息调用窗口函数和过程", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}, "url": "/docs/compare/?release=12.7#12.7-06b0536ea0d66ab4", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "dea30517e2656d30b3618508113e7285", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "禁止通过“快速路径”线协议消息调用窗口函数和过程", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}, "url": "/docs/compare/?release=11.12#11.12-6c2ca6f3cc542eae", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "e8af7a374034d509284f19f6cc78df61", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "禁止通过“快速路径”线协议消息调用窗口函数和过程", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}, "url": "/docs/compare/?release=10.17#10.17-6c2ca6f3cc542eae", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "1b8f2a45a9d2e935788f99131bc2b253", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "禁止通过“快速路径”线上协议消息调用窗口函数和过程", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}, "url": "/docs/compare/?release=9.6.22#9.6.22-3fe8b7018a871824", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-288208cef0a2f9c4", "cves": [], "html": "<p>扩展 <code>pg_identify_object_as_address()</code>，使其支持事件触发器（Joel Jacobson）<a href=\"https://postgr.es/c/f3c453787\">§</a> <a href=\"https://postgr.es/c/a928297bc\">§</a></p>", "text": "扩展 pg_identify_object_as_address()，使其支持事件触发器（Joel Jacobson）§ §", "title": "扩展 pg_identify_object_as_address()，使其支持事件触发器", "commits": ["a928297bc", "f3c453787"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "39a6b884fbe28aae4e624bcc4fade8e489373df2bab1629a56448469faac6ed3", "section_path": ["变更"], "commit_groups": [["0d05a3a1d", "669f73666", "85a3e0be1", "a928297bc", "b797918d2", "f93f0b5b2"], ["5b717e13c", "6e41ff056", "7e76cb1d8", "90c9bad30", "f3c453787", "f7aab36d6"]], "identity_text": "Extend pg_identify_object_as_address() to support event triggers (Joel Jacobson)", "commit_aliases": ["0d05a3a1d", "5b717e13c", "669f73666", "6e41ff056", "7e76cb1d8", "85a3e0be1", "90c9bad30", "a928297bc", "b797918d2", "f3c453787", "f7aab36d6", "f93f0b5b2"], "source_commits": ["a928297bc", "f3c453787"], "source_entry_id": "13.3/changes/014", "db_id": "5cd6ab8e24d263554c647a40d8e6510a", "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8", "relations": [{"rule": 2, "type": "equivalent", "target": "1ab2e233f6adf0cae7bd7d4b105e8558", "evidence": {"same_day": true, "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8"}}, {"rule": 2, "type": "equivalent", "target": "570aba58ff1a8e4643d5e729f8c80905", "evidence": {"same_day": true, "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8"}}, {"rule": 2, "type": "equivalent", "target": "61e2b5a711cfd7ff993742786ffe1c8d", "evidence": {"same_day": true, "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8"}}, {"rule": 2, "type": "equivalent", "target": "a52214e46c3177ebfce59ee06b06dd33", "evidence": {"same_day": true, "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1ab2e233f6adf0cae7bd7d4b105e8558", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "扩展 pg_identify_object_as_address()，使其支持事件触发器", "evidence": {"same_day": true, "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8"}, "url": "/docs/compare/?release=12.7#12.7-43013edea40caf2a", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "a52214e46c3177ebfce59ee06b06dd33", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "扩展 pg_identify_object_as_address()，使其支持事件触发器", "evidence": {"same_day": true, "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8"}, "url": "/docs/compare/?release=11.12#11.12-b9fd61bd2129e903", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "61e2b5a711cfd7ff993742786ffe1c8d", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "扩展 pg_identify_object_as_address()，使其支持事件触发器", "evidence": {"same_day": true, "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8"}, "url": "/docs/compare/?release=10.17#10.17-b9fd61bd2129e903", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "570aba58ff1a8e4643d5e729f8c80905", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "扩展 pg_identify_object_as_address() 以支持事件触发器", "evidence": {"same_day": true, "patch_ids": ["88311dbc3e5c7c10fd507b06c3be4f17", "e20dd963a27959d2a0218561dbf5ba07"], "statement_hash": "a4c8f32334b544e71fcc71c548ea67fd9e04a29d37e7ac022aa573a6acc712b8"}, "url": "/docs/compare/?release=9.6.22#9.6.22-38cc6de8ef10b61c", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-9ee98f84b0afbd4f", "cves": [], "html": "<p>修复 <code>to_char()</code> 对负时间间隔使用罗马数字月份格式代码的处理（Julien Rouhaud）<a href=\"https://postgr.es/c/be79debd9\">§</a></p>\n<p>以前，此类情况通常会导致崩溃。</p>", "text": "修复 to_char() 对负时间间隔使用罗马数字月份格式代码的处理（Julien Rouhaud）§ 以前，此类情况通常会导致崩溃。", "title": "修复 to_char() 对负时间间隔使用罗马数字月份格式代码的处理", "commits": ["be79debd9"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "ea1820ed800712f7d815a37c07c040e9d660088fa14e1dde8d2cc6e76fbb5fa4", "section_path": ["变更"], "commit_groups": [["1cc110f68", "5656f2c3d", "6540322fa", "7a3972597", "82dd5706e", "be79debd9"]], "identity_text": "Fix to_char()'s handling of Roman-numeral month format codes with negative intervals (Julien Rouhaud) Previously, such cases would usually cause a crash.", "commit_aliases": ["1cc110f68", "5656f2c3d", "6540322fa", "7a3972597", "82dd5706e", "be79debd9"], "source_commits": ["be79debd9"], "source_entry_id": "13.3/changes/015", "db_id": "b7c10db782f367caba5ef19f3462459b", "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5", "relations": [{"rule": 2, "type": "equivalent", "target": "0a104851ab53b64998bf762315515496", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}}, {"rule": 2, "type": "equivalent", "target": "40cc08f45f115d84fadcd5703140f2f9", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}}, {"rule": 2, "type": "equivalent", "target": "9f5b7d05c6c1db76a9ca6065f9203b1a", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}}, {"rule": 2, "type": "equivalent", "target": "bd638f861b8f78c34f8208fab8338b52", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "bd638f861b8f78c34f8208fab8338b52", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 to_char() 对负时间间隔使用罗马数字月份格式代码的处理", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}, "url": "/docs/compare/?release=12.7#12.7-9d059568c66a3ba9", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "0a104851ab53b64998bf762315515496", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 to_char() 对负时间间隔使用罗马数字月份格式代码的处理", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}, "url": "/docs/compare/?release=11.12#11.12-8fc513836898aa0c", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "40cc08f45f115d84fadcd5703140f2f9", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 to_char() 对负时间间隔使用罗马数字月份格式代码的处理", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}, "url": "/docs/compare/?release=10.17#10.17-8fc513836898aa0c", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "9f5b7d05c6c1db76a9ca6065f9203b1a", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 to_char() 对负区间使用罗马数字月份格式代码的处理", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}, "url": "/docs/compare/?release=9.6.22#9.6.22-628fe4627ac13739", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-7a4f40e4d3e3b444", "cves": [], "html": "<p>检查 <code>pg_import_system_collations()</code> 的参数是否为有效的模式 OID（Tom Lane）<a href=\"https://postgr.es/c/fe2b5386b\">§</a></p>", "text": "检查 pg_import_system_collations() 的参数是否为有效的模式 OID（Tom Lane）§", "title": "检查 pg_import_system_collations() 的参数是否为有效的模式 OID", "commits": ["fe2b5386b"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "6b622a17040d9e4bea41be20bfadd0a3429b98b3ad3372389d446c9446bae889", "section_path": ["变更"], "commit_groups": [["37228ecde", "5c06abb9b", "8fff8a874", "ea42ccbce", "fe2b5386b"]], "identity_text": "Check that the argument of pg_import_system_collations() is a valid schema OID (Tom Lane)", "commit_aliases": ["37228ecde", "5c06abb9b", "8fff8a874", "ea42ccbce", "fe2b5386b"], "source_commits": ["fe2b5386b"], "source_entry_id": "13.3/changes/016", "db_id": "49e03b938174a6e39f8f05b81f33ee84", "patch_ids": ["a046b14baa298c1c61cca6775867e1b0"], "statement_hash": "cc2542df4c0e51e16770dd147b1261319ca819d9c410bfa266b11a0eaa2550c2", "relations": [{"rule": 2, "type": "equivalent", "target": "23efc8f8a72cb24f663c66cf9d758c2a", "evidence": {"same_day": true, "patch_ids": ["a046b14baa298c1c61cca6775867e1b0"], "statement_hash": "cc2542df4c0e51e16770dd147b1261319ca819d9c410bfa266b11a0eaa2550c2"}}, {"rule": 2, "type": "equivalent", "target": "67660c320a7b2a4ff949a9b0a7708fd5", "evidence": {"same_day": true, "patch_ids": ["a046b14baa298c1c61cca6775867e1b0"], "statement_hash": "cc2542df4c0e51e16770dd147b1261319ca819d9c410bfa266b11a0eaa2550c2"}}, {"rule": 2, "type": "equivalent", "target": "69e917bd282ab2de8ea1a635fe4f803d", "evidence": {"same_day": true, "patch_ids": ["a046b14baa298c1c61cca6775867e1b0"], "statement_hash": "cc2542df4c0e51e16770dd147b1261319ca819d9c410bfa266b11a0eaa2550c2"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "69e917bd282ab2de8ea1a635fe4f803d", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "检查 pg_import_system_collations() 的参数是否为有效的模式 OID", "evidence": {"same_day": true, "patch_ids": ["a046b14baa298c1c61cca6775867e1b0"], "statement_hash": "cc2542df4c0e51e16770dd147b1261319ca819d9c410bfa266b11a0eaa2550c2"}, "url": "/docs/compare/?release=12.7#12.7-ab309e466e18148f", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "23efc8f8a72cb24f663c66cf9d758c2a", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "检查 pg_import_system_collations() 的参数是否为有效的模式 OID", "evidence": {"same_day": true, "patch_ids": ["a046b14baa298c1c61cca6775867e1b0"], "statement_hash": "cc2542df4c0e51e16770dd147b1261319ca819d9c410bfa266b11a0eaa2550c2"}, "url": "/docs/compare/?release=11.12#11.12-2f981bae763e4451", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "67660c320a7b2a4ff949a9b0a7708fd5", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "检查 pg_import_system_collations() 的参数是否为有效的模式 OID", "evidence": {"same_day": true, "patch_ids": ["a046b14baa298c1c61cca6775867e1b0"], "statement_hash": "cc2542df4c0e51e16770dd147b1261319ca819d9c410bfa266b11a0eaa2550c2"}, "url": "/docs/compare/?release=10.17#10.17-2f981bae763e4451", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-75cd8adaf0246852", "cves": [], "html": "<p>修复解析 BRE 模式正则表达式中的 <code>\\{<em><code>m</code></em>,<em><code>n</code></em>\\}</code> 量词时使用未初始化值的问题（Tom Lane）<a href=\"https://postgr.es/c/bf9d3a5f8\">§</a></p>\n<p>此错误可能使量词表现为非贪婪模式，即表现得像完整正则表达式中的 <code>{<em><code>m</code></em>,<em><code>n</code></em>}?</code> 量词。</p>", "text": "修复解析 BRE 模式正则表达式中的 \\{m,n\\} 量词时使用未初始化值的问题（Tom Lane）§ 此错误可能使量词表现为非贪婪模式，即表现得像完整正则表达式中的 {m,n}? 量词。", "title": "修复解析 BRE 模式正则表达式中的 \\{m,n\\} 量词时使用未初始化值的问题", "commits": ["bf9d3a5f8"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "d508be1a20cef7e2014bf9f51d9a90330c4813448844ae5ff869a4d454b1afcc", "section_path": ["变更"], "commit_groups": [["6e6fecf49", "ab208421e", "b06450979", "b5a66e735", "bf9d3a5f8", "e7cddb5f2"]], "identity_text": "Fix use of uninitialized value while parsing an \\{m,n\\} quantifier in a BRE-mode regular expression (Tom Lane) This error could cause the quantifier to act non-greedy, that is behave like an {m,n}? quantifier would do in full regular expressions.", "commit_aliases": ["6e6fecf49", "ab208421e", "b06450979", "b5a66e735", "bf9d3a5f8", "e7cddb5f2"], "source_commits": ["bf9d3a5f8"], "source_entry_id": "13.3/changes/017", "db_id": "18bcd4ff4a5b2578a944105a2d3bad2b", "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b", "relations": [{"rule": 2, "type": "equivalent", "target": "0bf05e3e62e8640ec87cf9c4260bdf71", "evidence": {"same_day": true, "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b"}}, {"rule": 2, "type": "equivalent", "target": "35d023ec7e6cb87b0ac4f6dd25c4cdcc", "evidence": {"same_day": true, "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b"}}, {"rule": 2, "type": "equivalent", "target": "be17b091805137c3f9fc93d8574ff6ff", "evidence": {"same_day": true, "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b"}}, {"rule": 2, "type": "equivalent", "target": "daac38e577e2f7007410cd8dc7f5ac3f", "evidence": {"same_day": true, "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "0bf05e3e62e8640ec87cf9c4260bdf71", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复解析 BRE 模式正则表达式中的 \\{m,n\\} 量词时使用未初始化值的问题", "evidence": {"same_day": true, "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b"}, "url": "/docs/compare/?release=12.7#12.7-2f97e49be6871e4a", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "be17b091805137c3f9fc93d8574ff6ff", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复解析 BRE 模式正则表达式中的 \\{m,n\\} 量词时使用未初始化值的问题", "evidence": {"same_day": true, "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b"}, "url": "/docs/compare/?release=11.12#11.12-2146f382754c4721", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "daac38e577e2f7007410cd8dc7f5ac3f", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复解析 BRE 模式正则表达式中的 \\{m,n\\} 量词时使用未初始化值的问题", "evidence": {"same_day": true, "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b"}, "url": "/docs/compare/?release=10.17#10.17-2146f382754c4721", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "35d023ec7e6cb87b0ac4f6dd25c4cdcc", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 BRE 模式正则表达式中解析 \\{m,n\\} 量词时使用未初始化值的问题", "evidence": {"same_day": true, "patch_ids": ["28090e761bc8afcf7c092c652ea46eae"], "statement_hash": "33e2417303e32078f65ccd1e73b2d7a4ee36854373984e0110794b476bb7669b"}, "url": "/docs/compare/?release=9.6.22#9.6.22-19823c8b9c9bd4d7", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-400a6562fa9f4610", "cves": [], "html": "<p>修复排序键涉及聚合函数或窗口函数的某些情况下出现的 <span>“<span>could not find pathkey item to sort</span>”</span> 规划器错误（James Coleman，Tom Lane）<a href=\"https://postgr.es/c/7bfba4f19\">§</a></p>", "text": "修复排序键涉及聚合函数或窗口函数的某些情况下出现的 “could not find pathkey item to sort” 规划器错误（James Coleman，Tom Lane）§", "title": "修复排序键涉及聚合函数或窗口函数的某些情况下出现的 “could not find pathkey item to sort” 规划器错误", "commits": ["7bfba4f19"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "8bf317a522de5d1c824552a8e01e28b5cf529d06a3ab250882010112473f8658", "section_path": ["变更"], "commit_groups": [["375398244", "7bfba4f19"]], "identity_text": "Fix could not find pathkey item to sort planner errors in some situations where the sort key involves an aggregate or window function (James Coleman, Tom Lane)", "commit_aliases": ["375398244", "7bfba4f19"], "source_commits": ["7bfba4f19"], "source_entry_id": "13.3/changes/018", "db_id": "b49655c38a59f0207df3e8cc8acba579", "patch_ids": ["e93c98efeec9552cf59199c181e969dd"], "statement_hash": "3f7e3564a071852f2b91d38084437abb3dd6a2710967920a2f92ee2a8fc3c575", "relations": [], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-c6e3802017718bb5", "cves": [], "html": "<p>使用扩展统计信息估计分组数量时，不要忽略系统列（Tomas Vondra）<a href=\"https://postgr.es/c/67251c82a\">§</a></p>\n<p>这会导致 <code>SELECT ... GROUP BY a, b, ctid</code> 等查询得到异常的估计值。</p>", "text": "使用扩展统计信息估计分组数量时，不要忽略系统列（Tomas Vondra）§ 这会导致 SELECT ... GROUP BY a, b, ctid 等查询得到异常的估计值。", "title": "使用扩展统计信息估计分组数量时，不要忽略系统列", "commits": ["67251c82a"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "56abf919344e582c24764dd4c17b5825f82175232a101a0fe9be362d6068181c", "section_path": ["变更"], "commit_groups": [["2a307df1b", "33e52ad9a", "67251c82a", "88acb0135", "e5eb40eed"]], "identity_text": "Don't ignore system columns when estimating the number of groups using extended statistics (Tomas Vondra) This led to strange estimates for queries such as SELECT ... GROUP BY a, b, ctid.", "commit_aliases": ["2a307df1b", "33e52ad9a", "67251c82a", "88acb0135", "e5eb40eed"], "source_commits": ["67251c82a"], "source_entry_id": "13.3/changes/019", "db_id": "e4e1fae2c58ead7c78dfed9687e72c62", "patch_ids": ["9d7246b7e3e28d78216a9704a1d7e51c"], "statement_hash": "dcce31105fce4829772584396528597f4238868a5f56aa314c02d80d4785b6c5", "relations": [{"rule": 2, "type": "equivalent", "target": "0436b0d48f16d890cac06a6a49450d56", "evidence": {"same_day": true, "patch_ids": ["9d7246b7e3e28d78216a9704a1d7e51c"], "statement_hash": "dcce31105fce4829772584396528597f4238868a5f56aa314c02d80d4785b6c5"}}, {"rule": 2, "type": "equivalent", "target": "1328128651a37a3aecb5aba77c512cdf", "evidence": {"same_day": true, "patch_ids": ["9d7246b7e3e28d78216a9704a1d7e51c"], "statement_hash": "dcce31105fce4829772584396528597f4238868a5f56aa314c02d80d4785b6c5"}}, {"rule": 2, "type": "equivalent", "target": "19047eac955bc30eca73c031111c9f2e", "evidence": {"same_day": true, "patch_ids": ["9d7246b7e3e28d78216a9704a1d7e51c"], "statement_hash": "dcce31105fce4829772584396528597f4238868a5f56aa314c02d80d4785b6c5"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1328128651a37a3aecb5aba77c512cdf", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "使用扩展统计信息估计分组数量时，不要忽略系统列", "evidence": {"same_day": true, "patch_ids": ["9d7246b7e3e28d78216a9704a1d7e51c"], "statement_hash": "dcce31105fce4829772584396528597f4238868a5f56aa314c02d80d4785b6c5"}, "url": "/docs/compare/?release=12.7#12.7-8e8c78dba0149d8a", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "19047eac955bc30eca73c031111c9f2e", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "使用扩展统计信息估计分组数量时，不要忽略系统列", "evidence": {"same_day": true, "patch_ids": ["9d7246b7e3e28d78216a9704a1d7e51c"], "statement_hash": "dcce31105fce4829772584396528597f4238868a5f56aa314c02d80d4785b6c5"}, "url": "/docs/compare/?release=11.12#11.12-5e634bf1af57462b", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "0436b0d48f16d890cac06a6a49450d56", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "使用扩展统计信息估计分组数量时，不要忽略系统列", "evidence": {"same_day": true, "patch_ids": ["9d7246b7e3e28d78216a9704a1d7e51c"], "statement_hash": "dcce31105fce4829772584396528597f4238868a5f56aa314c02d80d4785b6c5"}, "url": "/docs/compare/?release=10.17#10.17-5e634bf1af57462b", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-0c127e09568e7e6e", "cves": [], "html": "<p>避免估计具有很长固定前缀的正则表达式的选择率时出现除零错误（Tom Lane）<a href=\"https://postgr.es/c/3a02d68a9\">§</a></p>\n<p>这通常会产生 <code>NaN</code> 选择率值，从而导致断言失败或规划器行为异常。</p>", "text": "避免估计具有很长固定前缀的正则表达式的选择率时出现除零错误（Tom Lane）§ 这通常会产生 NaN 选择率值，从而导致断言失败或规划器行为异常。", "title": "避免估计具有很长固定前缀的正则表达式的选择率时出现除零错误", "commits": ["3a02d68a9"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "76d1f9616352e14a1b7a261e2ba5207c65719ed6449fbdc53b9e9f5bb4ca0680", "section_path": ["变更"], "commit_groups": [["0347470b3", "374f1cefe", "3a02d68a9", "a28df6fa3", "ae4867ec7", "f4d781dae"]], "identity_text": "Avoid divide-by-zero when estimating selectivity of a regular expression with a very long fixed prefix (Tom Lane) This typically led to a NaN selectivity value, causing assertion failures or strange planner behavior.", "commit_aliases": ["0347470b3", "374f1cefe", "3a02d68a9", "a28df6fa3", "ae4867ec7", "f4d781dae"], "source_commits": ["3a02d68a9"], "source_entry_id": "13.3/changes/020", "db_id": "262537625d4bf258dd1131759d746f52", "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62", "relations": [{"rule": 2, "type": "equivalent", "target": "11cd51efa02c594b7f72e8e5c1191a71", "evidence": {"same_day": true, "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62"}}, {"rule": 2, "type": "equivalent", "target": "14d062b495819ce0d0510ea041c79088", "evidence": {"same_day": true, "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62"}}, {"rule": 2, "type": "equivalent", "target": "bd45c3f5dda28a076169fb3b2eb6f6a7", "evidence": {"same_day": true, "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62"}}, {"rule": 2, "type": "equivalent", "target": "dd95045b892c651f4672028b9a382f57", "evidence": {"same_day": true, "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "11cd51efa02c594b7f72e8e5c1191a71", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "避免估计具有很长固定前缀的正则表达式的选择率时出现除零错误", "evidence": {"same_day": true, "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62"}, "url": "/docs/compare/?release=12.7#12.7-780c72813beb1ac4", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "bd45c3f5dda28a076169fb3b2eb6f6a7", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "避免估计具有很长固定前缀的正则表达式的选择率时出现除零错误", "evidence": {"same_day": true, "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62"}, "url": "/docs/compare/?release=11.12#11.12-9304401a9a3da26c", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "14d062b495819ce0d0510ea041c79088", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "避免估计具有很长固定前缀的正则表达式的选择率时出现除零错误", "evidence": {"same_day": true, "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62"}, "url": "/docs/compare/?release=10.17#10.17-9304401a9a3da26c", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "dd95045b892c651f4672028b9a382f57", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "避免在估算带有很长固定前缀的正则表达式的选择率时除零", "evidence": {"same_day": true, "patch_ids": ["9902ee3c2d2817b9f581b3aa98640e9b"], "statement_hash": "af7fe50671e73be53d326ebd78815b26ead6f2256a3490d648eae020b7a7fe62"}, "url": "/docs/compare/?release=9.6.22#9.6.22-bb2e0d1931995be1", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-ab4eaf112dfb2d89", "cves": [], "html": "<p>修复 BRIN 索引位图扫描中访问超出表末尾位置的错误（Tomas Vondra）<a href=\"https://postgr.es/c/1aad1d181\">§</a></p>\n<p>如果 BRIN 索引使用的页范围大小不是二的幂，在某些边界情况下，位图扫描可能尝试获取超出表实际末尾的页面，导致 <span>“<span>could not open file</span>”</span> 错误。</p>", "text": "修复 BRIN 索引位图扫描中访问超出表末尾位置的错误（Tomas Vondra）§ 如果 BRIN 索引使用的页范围大小不是二的幂，在某些边界情况下，位图扫描可能尝试获取超出表实际末尾的页面，导致 “could not open file” 错误。", "title": "修复 BRIN 索引位图扫描中访问超出表末尾位置的错误", "commits": ["1aad1d181"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "0df4d1ef140dd76a4453faf05f21c38365d1406402ec0790a8d21c6d69b8a38e", "section_path": ["变更"], "commit_groups": [["1aad1d181", "23607a815", "7d3a53461", "847612fda", "df97ee6ea", "e4f251be7"]], "identity_text": "Fix access-off-the-end-of-the-table error in BRIN index bitmap scans (Tomas Vondra) If the page range size used by a BRIN index isn't a power of two, there were corner cases in which a bitmap scan could try to fetch pages past the actual end of the table, leading to could not open file errors.", "commit_aliases": ["1aad1d181", "23607a815", "7d3a53461", "847612fda", "df97ee6ea", "e4f251be7"], "source_commits": ["1aad1d181"], "source_entry_id": "13.3/changes/021", "db_id": "61cbd7bfd3778343419ff4ea7ee70db1", "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606", "relations": [{"rule": 2, "type": "equivalent", "target": "a4a6211a7ccfce246a599ca2b95e1de9", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}}, {"rule": 2, "type": "equivalent", "target": "c5ed0e21fd32ad21603f4a15525170ee", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}}, {"rule": 2, "type": "equivalent", "target": "e4e4a8f913f2b8037c0c5747e48b0878", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}}, {"rule": 2, "type": "equivalent", "target": "fb32cff9c207c98871de91e331df5e47", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c5ed0e21fd32ad21603f4a15525170ee", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 BRIN 索引位图扫描中访问超出表末尾位置的错误", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}, "url": "/docs/compare/?release=12.7#12.7-9c1de227cc83156d", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "fb32cff9c207c98871de91e331df5e47", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 BRIN 索引位图扫描中访问超出表末尾位置的错误", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}, "url": "/docs/compare/?release=11.12#11.12-64f8de0b19c5611c", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "e4e4a8f913f2b8037c0c5747e48b0878", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 BRIN 索引位图扫描中访问超出表末尾位置的错误", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}, "url": "/docs/compare/?release=10.17#10.17-64f8de0b19c5611c", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "a4a6211a7ccfce246a599ca2b95e1de9", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 BRIN 索引位图扫描中越表末访问的错误", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}, "url": "/docs/compare/?release=9.6.22#9.6.22-bc748355dcaccaf3", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-9251898da0d1b553", "cves": [], "html": "<p>修复匹配元组很多时，GIN <code>tsvector</code> 索引搜索可能返回错误结果的问题（Tom Lane）<a href=\"https://postgr.es/c/0d779d22a\">§</a></p>\n<p>如果索引匹配项的数量足够多，导致存储它们的位图变为有损位图（阈值取决于 <code>work_mem</code>），代码就可能错误判断是否需要重新检查，从而返回实际上并不匹配查询的行。</p>", "text": "修复匹配元组很多时，GIN tsvector 索引搜索可能返回错误结果的问题（Tom Lane）§ 如果索引匹配项的数量足够多，导致存储它们的位图变为有损位图（阈值取决于 work_mem），代码就可能错误判断是否需要重新检查，从而返回实际上并不匹配查询的行。", "title": "修复匹配元组很多时，GIN tsvector 索引搜索可能返回错误结果的问题", "commits": ["0d779d22a"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "0a5fd7a8d193ce50a557e20f7bf013063a9377dae2260779395e7c6abbf9aa85", "section_path": ["变更"], "commit_groups": [["0d779d22a", "38bb3aef3"]], "identity_text": "Fix potentially wrong answers from GIN tsvector index searches, when there are many matching tuples (Tom Lane) If the number of index matches became large enough to make the bitmap holding them become lossy (a threshold that depends on work_mem), the code could get confused about whether rechecks are required, allowing rows to be returned that don't actually match the query.", "commit_aliases": ["0d779d22a", "38bb3aef3"], "source_commits": ["0d779d22a"], "source_entry_id": "13.3/changes/022", "db_id": "1225bd96f0a6499792255c4cf4c549f2", "patch_ids": ["ac281a2b59383d93498df5cbffcc1619"], "statement_hash": "49b2f35a9522a7f658bbbe64250b1c360c0c92593863630c1023504bee0ca513", "relations": [], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-c365dff65fa76e1b", "cves": [], "html": "<p>修复 Windows 上 WAL 段回收的并发问题（Michael Paquier）<a href=\"https://postgr.es/c/78c24e97d\">§</a></p>\n<p>这撤销了一项会间歇性产生 <span>“<span>could not rename file ...: Permission denied</span>”</span> 日志消息的修改。虽然没有严重后果，但大量无用日志令人困扰。</p>", "text": "修复 Windows 上 WAL 段回收的并发问题（Michael Paquier）§ 这撤销了一项会间歇性产生 “could not rename file ...: Permission denied” 日志消息的修改。虽然没有严重后果，但大量无用日志令人困扰。", "title": "修复 Windows 上 WAL 段回收的并发问题", "commits": ["78c24e97d"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "3f11741fec566b31c1e1a886eeaf47767b7386c6052d821ccdb475e3a23b586f", "section_path": ["变更"], "commit_groups": [["78c24e97d", "909b449e0"]], "identity_text": "Fix concurrency issues with WAL segment recycling on Windows (Michael Paquier) This reverts a change that caused intermittent could not rename file ...: Permission denied log messages. While there were not serious consequences, the log spam was annoying.", "commit_aliases": ["78c24e97d", "909b449e0"], "source_commits": ["78c24e97d"], "source_entry_id": "13.3/changes/023", "db_id": "e3696fd317ce4bc9ff6a769590e7570c", "patch_ids": ["fdedf35533a04515edb485e4577b9415"], "statement_hash": "b831103671db89a17330e56f5e424ce0d9f36f17e0c7f0d94cb64a0df06b8333", "relations": [], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-6caafe2c96cb71d0", "cves": [], "html": "<p>避免从 WAL 恢复未提交的两阶段事务时发生不正确的时间线变更（Soumyadeep Chakraborty，Jimmy Yih，Kevin Yeap）<a href=\"https://postgr.es/c/6e5ce888a\">§</a></p>\n<p>此错误可能使后续 WAL 记录在错误的时间线 ID 下写入，导致之后出现一致性问题，甚至完全无法重启服务器。</p>", "text": "避免从 WAL 恢复未提交的两阶段事务时发生不正确的时间线变更（Soumyadeep Chakraborty，Jimmy Yih，Kevin Yeap）§ 此错误可能使后续 WAL 记录在错误的时间线 ID 下写入，导致之后出现一致性问题，甚至完全无法重启服务器。", "title": "避免从 WAL 恢复未提交的两阶段事务时发生不正确的时间线变更", "commits": ["6e5ce888a"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "0dff2217c3987d21388e7652b47b81091b1808bd6b85a47525ab8bf033756f8b", "section_path": ["变更"], "commit_groups": [["1ec7162a8", "4b1dd9b1e", "595b9cba2", "6e5ce888a", "f1d550f18"]], "identity_text": "Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL (Soumyadeep Chakraborty, Jimmy Yih, Kevin Yeap) This error could lead to subsequent WAL records being written under the wrong timeline ID, leading to consistency problems, or even complete failure to be able to restart the server, later on.", "commit_aliases": ["1ec7162a8", "4b1dd9b1e", "595b9cba2", "6e5ce888a", "f1d550f18"], "source_commits": ["6e5ce888a"], "source_entry_id": "13.3/changes/024", "db_id": "1b01f5f8148ce71942c1add860ebade0", "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61", "relations": [{"rule": 2, "type": "equivalent", "target": "23f21299dd74193efff4e9202ddcda7d", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}}, {"rule": 2, "type": "equivalent", "target": "eed0155770501dc8aeec531a7935e994", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}}, {"rule": 2, "type": "equivalent", "target": "eed68915dba63eb3adcf429dd51b0809", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "23f21299dd74193efff4e9202ddcda7d", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "避免从 WAL 恢复未提交的两阶段事务时发生不正确的时间线变更", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}, "url": "/docs/compare/?release=12.7#12.7-1405be4ff510fdd0", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "eed68915dba63eb3adcf429dd51b0809", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "避免从 WAL 恢复未提交的两阶段事务时发生不正确的时间线变更", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}, "url": "/docs/compare/?release=11.12#11.12-54d80475bfb25edd", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "eed0155770501dc8aeec531a7935e994", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "避免从 WAL 恢复未提交的两阶段事务时发生不正确的时间线变更", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}, "url": "/docs/compare/?release=10.17#10.17-54d80475bfb25edd", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-09ab65777a171b7b", "cves": [], "html": "<p>确保关闭备库的启动进程时释放锁（Fujii Masao）<a href=\"https://postgr.es/c/e7bcfd717\">§</a></p>\n<p>在备库仍处于恢复状态时将其关闭，可能会留下某些仍被持有的锁。这会导致调试构建中的断言失败；尚不清楚在生产构建中是否可能造成严重后果。</p>", "text": "确保关闭备库的启动进程时释放锁（Fujii Masao）§ 在备库仍处于恢复状态时将其关闭，可能会留下某些仍被持有的锁。这会导致调试构建中的断言失败；尚不清楚在生产构建中是否可能造成严重后果。", "title": "确保关闭备库的启动进程时释放锁", "commits": ["e7bcfd717"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "8d8ca4a6de7ce4197e9ed3372dd86d4d2ecf52b6fbc08fcff527e568999535b6", "section_path": ["变更"], "commit_groups": [["ad8b67492", "b59d3abaf", "b9cf9d7d3", "dd5b7e486", "e3bf96216", "e7bcfd717"]], "identity_text": "Ensure that locks are released while shutting down a standby server's startup process (Fujii Masao) When a standby server is shut down while still in recovery, some locks might be left held. This causes assertion failures in debug builds; it's unclear whether any serious consequence could occur in production builds.", "commit_aliases": ["ad8b67492", "b59d3abaf", "b9cf9d7d3", "dd5b7e486", "e3bf96216", "e7bcfd717"], "source_commits": ["e7bcfd717"], "source_entry_id": "13.3/changes/025", "db_id": "238c45b77c57b6ea46d88aee7653f60d", "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69", "relations": [{"rule": 2, "type": "equivalent", "target": "062b13769fd19e7beae52070c5a9e124", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}}, {"rule": 2, "type": "equivalent", "target": "073e827b10f6b1fc2d24b6b821f12348", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}}, {"rule": 2, "type": "equivalent", "target": "492876ca41b4c6bb5cff16a8c4788a61", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}}, {"rule": 2, "type": "equivalent", "target": "59acb9b03dd39c719f32a8eb23740b16", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "062b13769fd19e7beae52070c5a9e124", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "确保关闭备库的启动进程时释放锁", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}, "url": "/docs/compare/?release=12.7#12.7-ef3ade4b27c85a8b", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "492876ca41b4c6bb5cff16a8c4788a61", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "确保关闭备库的启动进程时释放锁", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}, "url": "/docs/compare/?release=11.12#11.12-cc0923f765ef064b", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "073e827b10f6b1fc2d24b6b821f12348", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "确保关闭备库的启动进程时释放锁", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}, "url": "/docs/compare/?release=10.17#10.17-cc0923f765ef064b", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "59acb9b03dd39c719f32a8eb23740b16", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "确保在关闭备库服务器的启动进程期间释放锁", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}, "url": "/docs/compare/?release=9.6.22#9.6.22-bd5da1bf87ad9ac8", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-13b20c07e29ebfea", "cves": [], "html": "<p>修复逻辑复制工作进程执行 <code>ALTER SUBSCRIPTION REFRESH</code> 时的崩溃（Peter Smith）<a href=\"https://postgr.es/c/ef70b6f8e\">§</a></p>\n<p>核心代码不会这样做，但副本触发器可能会。</p>", "text": "修复逻辑复制工作进程执行 ALTER SUBSCRIPTION REFRESH 时的崩溃（Peter Smith）§ 核心代码不会这样做，但副本触发器可能会。", "title": "修复逻辑复制工作进程执行 ALTER SUBSCRIPTION REFRESH 时的崩溃", "commits": ["ef70b6f8e"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "e71a7818d809d7cd4504e5965e2abff6985cb9642fcc7edf236f3e4cc11a7377", "section_path": ["变更"], "commit_groups": [["1803c7626", "4e8c0f1a0", "b40865ebd", "cfebc7080", "ef70b6f8e"]], "identity_text": "Fix crash when a logical replication worker does ALTER SUBSCRIPTION REFRESH (Peter Smith) The core code won't do this, but a replica trigger could.", "commit_aliases": ["1803c7626", "4e8c0f1a0", "b40865ebd", "cfebc7080", "ef70b6f8e"], "source_commits": ["ef70b6f8e"], "source_entry_id": "13.3/changes/026", "db_id": "0b57d686a4ccc9f24c5695fea460e4ec", "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34", "relations": [{"rule": 2, "type": "equivalent", "target": "6fc3fe3ce8f06ff2ddc579dbcf9988a0", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}}, {"rule": 2, "type": "equivalent", "target": "70738891bf9bb064baf7c8f329c0017f", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}}, {"rule": 2, "type": "equivalent", "target": "ee7a35f7ec2fcc509c503e21c1539f2b", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6fc3fe3ce8f06ff2ddc579dbcf9988a0", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复逻辑复制工作进程执行 ALTER SUBSCRIPTION REFRESH 时的崩溃", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}, "url": "/docs/compare/?release=12.7#12.7-8b8cac53fef14fc8", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "ee7a35f7ec2fcc509c503e21c1539f2b", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复逻辑复制工作进程执行 ALTER SUBSCRIPTION REFRESH 时的崩溃", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}, "url": "/docs/compare/?release=11.12#11.12-837b47bc07aeed52", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "70738891bf9bb064baf7c8f329c0017f", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复逻辑复制工作进程执行 ALTER SUBSCRIPTION REFRESH 时的崩溃", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}, "url": "/docs/compare/?release=10.17#10.17-837b47bc07aeed52", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-8adb86c3113e8360", "cves": [], "html": "<p>确保在较新版本的 FreeBSD 上默认使用 <code>wal_sync_method</code> = <code>fdatasync</code>（Thomas Munro）<a href=\"https://postgr.es/c/6c23e5ae9\">§</a></p>\n<p>FreeBSD 13 支持 <code>open_datasync</code>，通常它会成为默认选择。但尚不清楚这对 Postgres 是否确有改进，因此暂时保留现有默认值。</p>", "text": "确保在较新版本的 FreeBSD 上默认使用 wal_sync_method = fdatasync（Thomas Munro）§ FreeBSD 13 支持 open_datasync，通常它会成为默认选择。但尚不清楚这对 Postgres 是否确有改进，因此暂时保留现有默认值。", "title": "确保在较新版本的 FreeBSD 上默认使用 wal_sync_method = fdatasync", "commits": ["6c23e5ae9"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "05bedac2bdfcb1b38dc9696097375adf4202f0eeaa68681e1ac13cb451f235d8", "section_path": ["变更"], "commit_groups": [["09a3b19e3", "1fefe8879", "6c23e5ae9", "800131df7", "a27f3a7f4", "f900a79ec"]], "identity_text": "Ensure we default to wal_sync_method = fdatasync on recent FreeBSD (Thomas Munro) FreeBSD 13 supports open_datasync, which would normally become the default choice. However, it's unclear whether that is actually an improvement for Postgres, so preserve the existing default for now.", "commit_aliases": ["09a3b19e3", "1fefe8879", "6c23e5ae9", "800131df7", "a27f3a7f4", "f900a79ec"], "source_commits": ["6c23e5ae9"], "source_entry_id": "13.3/changes/027", "db_id": "ee7442e57c3a8ae83094a27d9ad8da11", "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c", "relations": [{"rule": 2, "type": "equivalent", "target": "308b7195d5ab5445234c5c824b504dce", "evidence": {"same_day": true, "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c"}}, {"rule": 2, "type": "equivalent", "target": "720f4c295e8c8d7064ee80213ba0772e", "evidence": {"same_day": true, "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c"}}, {"rule": 2, "type": "equivalent", "target": "9689adc34579b70072bc3d5e395cadf5", "evidence": {"same_day": true, "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c"}}, {"rule": 2, "type": "equivalent", "target": "d8abd2d2b916ea344275fa48febd6de3", "evidence": {"same_day": true, "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "720f4c295e8c8d7064ee80213ba0772e", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "确保在较新版本的 FreeBSD 上默认使用 wal_sync_method = fdatasync", "evidence": {"same_day": true, "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c"}, "url": "/docs/compare/?release=12.7#12.7-7af28a1338c7ba5d", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "9689adc34579b70072bc3d5e395cadf5", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "确保在较新版本的 FreeBSD 上默认使用 wal_sync_method = fdatasync", "evidence": {"same_day": true, "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c"}, "url": "/docs/compare/?release=11.12#11.12-cebda2bae56e9f79", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "308b7195d5ab5445234c5c824b504dce", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "确保在较新版本的 FreeBSD 上默认使用 wal_sync_method = fdatasync", "evidence": {"same_day": true, "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c"}, "url": "/docs/compare/?release=10.17#10.17-cebda2bae56e9f79", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "d8abd2d2b916ea344275fa48febd6de3", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "确保在较新的 FreeBSD 上默认使用 wal_sync_method = fdatasync", "evidence": {"same_day": true, "patch_ids": ["bbb3d03be2d44c294d2e4311c686e0a6"], "statement_hash": "f999c4164b7f4ce856e2c5423b1be8c6335f7a0e13f31b4f08d8aee03b85ac5c"}, "url": "/docs/compare/?release=9.6.22#9.6.22-8120ab81cf704e2f", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-fb1133cf63235295", "cves": [], "html": "<p>禁用 <code>vacuum_cleanup_index_scale_factor</code> 参数及存储选项（Peter Geoghegan）<a href=\"https://postgr.es/c/9663d1244\">§</a> <a href=\"https://postgr.es/c/1fc5a5738\">§</a></p>\n<p>事实证明，跟踪<span>“<span>过期</span>”</span>索引统计信息的做法与 <code>autovacuum_vacuum_insert_threshold</code> 参数配合不当，会导致不必要的全索引扫描，进而降低自动清理性能。后者的机制似乎更好，因此移除过期统计信息逻辑。控制该逻辑的参数 <code>vacuum_cleanup_index_scale_factor</code> 将在 v14 中完全移除。在 v13 中，为避免破坏现有配置文件，该参数仍然存在，但已不再产生任何作用。</p>", "text": "禁用 vacuum_cleanup_index_scale_factor 参数及存储选项（Peter Geoghegan）§ § 事实证明，跟踪“过期”索引统计信息的做法与 autovacuum_vacuum_insert_threshold 参数配合不当，会导致不必要的全索引扫描，进而降低自动清理性能。后者的机制似乎更好，因此移除过期统计信息逻辑。控制该逻辑的参数 vacuum_cleanup_index_scale_factor 将在 v14 中完全移除。在 v13 中，为避免破坏现有配置文件，该参数仍然存在，但已不再产生任何作用。", "title": "禁用 vacuum_cleanup_index_scale_factor 参数及存储选项", "commits": ["1fc5a5738", "9663d1244"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "00b121e1153639e8c33c9114e3c41e47dd3daaed22a36cfc914988d7c1873017", "section_path": ["变更"], "commit_groups": [["1fc5a5738", "5f8727f5a"], ["9663d1244", "9f3665fbf"]], "identity_text": "Disable the vacuum_cleanup_index_scale_factor parameter and storage option (Peter Geoghegan) The notion of tracking stale index statistics proved to interact badly with the autovacuum_vacuum_insert_threshold parameter, resulting in unnecessary full-index scans and consequent degradation of autovacuum performance. The latter mechanism seems superior, so remove the stale-statistics logic. The control parameter for that, vacuum_cleanup_index_scale_factor, will be removed entirely in v14. In v13, it remains present to avoid breaking existing configuration files, but it no longer does anything.", "commit_aliases": ["1fc5a5738", "5f8727f5a", "9663d1244", "9f3665fbf"], "source_commits": ["1fc5a5738", "9663d1244"], "source_entry_id": "13.3/changes/028", "db_id": "905141292f2512fd9b9052468cc7ff7d", "patch_ids": ["6835ddedc0d0fa804083748ca3bad65e", "7d139072a7e720186d8972f31f3b9f5e"], "statement_hash": "a17bfaf499d1309061c602159269a9338d77529c143ee0fed0b5656c14403666", "relations": [{"rule": 2, "type": "related", "target": "33ba05eddab9ba712287813f7255b7e2", "evidence": {"same_day": false, "patch_ids": ["7d139072a7e720186d8972f31f3b9f5e"]}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "33ba05eddab9ba712287813f7255b7e2", "kind": "related", "version": "14.0", "label": "14.0", "title": "移除服务器参数 vacuum_cleanup_index_scale_factor", "evidence": {"same_day": false, "patch_ids": ["7d139072a7e720186d8972f31f3b9f5e"]}, "url": "/docs/compare/?release=14.0#14.0-c488d77ab8d7845d", "source_url": "/docs/release/14.0/#ZH-AUTO-RELEASE-14-SECT2-46"}]}, {"id": "13.3-00427ca8e46fec89", "cves": [], "html": "<p>在 <code>ALTER CONSTRAINT</code> 期间，将正确的触发器 OID 传递给对象修改后钩子（Álvaro Herrera）<a href=\"https://postgr.es/c/91a6b3862\">§</a></p>\n<p>在 <code>ALTER CONSTRAINT</code> 期间更新触发器属性时，修改后钩子被告知正在更新触发器，但传入的却是约束的 OID，而非触发器的 OID。</p>", "text": "在 ALTER CONSTRAINT 期间，将正确的触发器 OID 传递给对象修改后钩子（Álvaro Herrera）§ 在 ALTER CONSTRAINT 期间更新触发器属性时，修改后钩子被告知正在更新触发器，但传入的却是约束的 OID，而非触发器的 OID。", "title": "在 ALTER CONSTRAINT 期间，将正确的触发器 OID 传递给对象修改后钩子", "commits": ["91a6b3862"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "d26a03d5776d2d61e961b142470591fa83a9ec7d3fbfbb0cdf83ff3c60e45cc6", "section_path": ["变更"], "commit_groups": [["72fabd4bf", "91a6b3862", "e798d095d"]], "identity_text": "Pass the correct trigger OID to object post-alter hooks during ALTER CONSTRAINT (Álvaro Herrera) When updating trigger properties during ALTER CONSTRAINT, the post-alter hook was told that we are updating a trigger, but the constraint's OID was passed instead of the trigger's.", "commit_aliases": ["72fabd4bf", "91a6b3862", "e798d095d"], "source_commits": ["91a6b3862"], "source_entry_id": "13.3/changes/029", "db_id": "e89ad346435983841b57a01a59cc45dc", "patch_ids": ["9828fa71a8c31e7799f86c13aab31d71"], "statement_hash": "a9b69a892a423c9f8cf3d2e949b21046841cdc6b6260f84f222d2326ed921bcc", "relations": [{"rule": 2, "type": "equivalent", "target": "a51491504897521506b49e92b247cf2a", "evidence": {"same_day": true, "patch_ids": ["9828fa71a8c31e7799f86c13aab31d71"], "statement_hash": "a9b69a892a423c9f8cf3d2e949b21046841cdc6b6260f84f222d2326ed921bcc"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a51491504897521506b49e92b247cf2a", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "在 ALTER CONSTRAINT 期间，将正确的触发器 OID 传递给对象修改后钩子", "evidence": {"same_day": true, "patch_ids": ["9828fa71a8c31e7799f86c13aab31d71"], "statement_hash": "a9b69a892a423c9f8cf3d2e949b21046841cdc6b6260f84f222d2326ed921bcc"}, "url": "/docs/compare/?release=12.7#12.7-ad719811a04263ca", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-781bdd17d7abc7e2", "cves": [], "html": "<p>确保分离 DSM 段期间被中断时仍能完成清理（Thomas Munro）<a href=\"https://postgr.es/c/9fe40913c\">§</a></p>\n<p>此错误可能导致并行查询后未能及时清理临时文件。</p>", "text": "确保分离 DSM 段期间被中断时仍能完成清理（Thomas Munro）§ 此错误可能导致并行查询后未能及时清理临时文件。", "title": "确保分离 DSM 段期间被中断时仍能完成清理", "commits": ["9fe40913c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "1036c058b36ec0e7a3345849dd08eadd82dff6fcf9964723342013d99b23df33", "section_path": ["变更"], "commit_groups": [["4b426f77c", "637668fb1", "840eda04e", "8a07e5bd8", "9fe40913c", "acafdd9ed"]], "identity_text": "Ensure we finish cleaning up when interrupted while detaching a DSM segment (Thomas Munro) This error could result in temporary files not being cleaned up promptly after a parallel query.", "commit_aliases": ["4b426f77c", "637668fb1", "840eda04e", "8a07e5bd8", "9fe40913c", "acafdd9ed"], "source_commits": ["9fe40913c"], "source_entry_id": "13.3/changes/030", "db_id": "d5d8252f9e52aa7f57a975f98746773e", "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc", "relations": [{"rule": 2, "type": "equivalent", "target": "39df208538fedc0bf3f262ba010b8933", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}}, {"rule": 2, "type": "equivalent", "target": "869cfb32e5b7b396c6b448739c9e20e2", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}}, {"rule": 2, "type": "equivalent", "target": "a2d067a132fbaf87a1e15613cfce2e0a", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}}, {"rule": 2, "type": "equivalent", "target": "e8c49727adfe23a3d9c02af29c178ab7", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "869cfb32e5b7b396c6b448739c9e20e2", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "确保分离 DSM 段期间被中断时仍能完成清理", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}, "url": "/docs/compare/?release=12.7#12.7-9c8c5cc0a75b8ce2", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "a2d067a132fbaf87a1e15613cfce2e0a", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "确保分离 DSM 段期间被中断时仍能完成清理", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}, "url": "/docs/compare/?release=11.12#11.12-99418baefecb959e", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "e8c49727adfe23a3d9c02af29c178ab7", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "确保分离 DSM 段期间被中断时仍能完成清理", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}, "url": "/docs/compare/?release=10.17#10.17-99418baefecb959e", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "39df208538fedc0bf3f262ba010b8933", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "确保在分离 DSM 段被中断时完成清理", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}, "url": "/docs/compare/?release=9.6.22#9.6.22-b25a6708b239157a", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-a60ee9865585f428", "cves": [], "html": "<p>修复服务器中多种较小的内存泄漏（Tom Lane，Andres Freund）<a href=\"https://postgr.es/c/4b41f6923\">§</a> <a href=\"https://postgr.es/c/12354839e\">§</a> <a href=\"https://postgr.es/c/642b0b69b\">§</a> <a href=\"https://postgr.es/c/eba939551\">§</a> <a href=\"https://postgr.es/c/ea3989f34\">§</a> <a href=\"https://postgr.es/c/536836970\">§</a> <a href=\"https://postgr.es/c/4d072bf2a\">§</a></p>", "text": "修复服务器中多种较小的内存泄漏（Tom Lane，Andres Freund）§ § § § § § §", "title": "修复服务器中多种较小的内存泄漏", "commits": ["12354839e", "4b41f6923", "4d072bf2a", "536836970", "642b0b69b", "ea3989f34", "eba939551"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "cfd32cce1cd4ffaf88e4e296ad5e5a0018826d977c7ec551b86afcb59962a908", "section_path": ["变更"], "commit_groups": [["099d2914f", "09e961929", "0b618ddf8", "92bc14a10", "d303849b0", "eba939551"], ["12354839e", "20f11ca0d", "4eca51d44", "9bacdf9f5", "ba986b7bc"], ["1452a0bb8", "415ffdc22", "ea3989f34"], ["26a3ae06d", "377b7a830", "5058e95a6", "642b0b69b", "7e2521770", "fc552f868"], ["28644fac1", "2bed650c4", "536836970", "967b693ea", "fbcc9fe33"], ["2f31414f4", "4b41f6923", "8c830148d", "ad6c19066", "e835e89a0"], ["4b12ab18c", "4d072bf2a", "6e3475556", "7ce7f2b79", "a2764d87d"]], "identity_text": "Fix assorted minor memory leaks in the server (Tom Lane, Andres Freund)", "commit_aliases": ["099d2914f", "09e961929", "0b618ddf8", "12354839e", "1452a0bb8", "20f11ca0d", "26a3ae06d", "28644fac1", "2bed650c4", "2f31414f4", "377b7a830", "415ffdc22", "4b12ab18c", "4b41f6923", "4d072bf2a", "4eca51d44", "5058e95a6", "536836970", "642b0b69b", "6e3475556", "7ce7f2b79", "7e2521770", "8c830148d", "92bc14a10", "967b693ea", "9bacdf9f5", "a2764d87d", "ad6c19066", "ba986b7bc", "d303849b0", "e835e89a0", "ea3989f34", "eba939551", "fbcc9fe33", "fc552f868"], "source_commits": ["12354839e", "4b41f6923", "4d072bf2a", "536836970", "642b0b69b", "ea3989f34", "eba939551"], "source_entry_id": "13.3/changes/031", "db_id": "47dd699457eb55393cedc2f4d22772ff", "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c", "relations": [{"rule": 2, "type": "equivalent", "target": "0b77a332a701d12618a8679c0ffa81bb", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}}, {"rule": 2, "type": "equivalent", "target": "1678dd9c9a9003a7d56ad21c3c3e2f3b", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}}, {"rule": 2, "type": "related", "target": "a7a165b7be91c9d1539502d4e43cb9a3", "evidence": {"same_day": true, "patch_ids": ["8e19f457a6c06d813e4fcd3e511e6652", "ef57775f040bdd51593eb3d9b31a1536"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}}, {"rule": 2, "type": "equivalent", "target": "f3d455c6804ccf0ec8d47e1b31d304ff", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f3d455c6804ccf0ec8d47e1b31d304ff", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复服务器中多种较小的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}, "url": "/docs/compare/?release=12.7#12.7-c0926c7d178ccdba", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "1678dd9c9a9003a7d56ad21c3c3e2f3b", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复服务器中多种较小的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}, "url": "/docs/compare/?release=11.12#11.12-1ebd6aed5408c6ff", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "0b77a332a701d12618a8679c0ffa81bb", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复服务器中多种较小的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}, "url": "/docs/compare/?release=10.17#10.17-1ebd6aed5408c6ff", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "a7a165b7be91c9d1539502d4e43cb9a3", "kind": "related", "version": "9.6.22", "label": "9.6.22", "title": "修复服务器中若干轻微的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["8e19f457a6c06d813e4fcd3e511e6652", "ef57775f040bdd51593eb3d9b31a1536"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}, "url": "/docs/compare/?release=9.6.22#9.6.22-1dfecc2f4aee441f", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-eb425b76abadbb0f", "cves": [], "html": "<p>修复共享内存中 WAL 接收进程统计信息里的未初始化变量（Fujii Masao）<a href=\"https://postgr.es/c/d4b667e93\">§</a></p>\n<p>此错误在大多数平台上无害，但在缺乏原子变量或自旋锁支持的平台上可能造成问题。</p>", "text": "修复共享内存中 WAL 接收进程统计信息里的未初始化变量（Fujii Masao）§ 此错误在大多数平台上无害，但在缺乏原子变量或自旋锁支持的平台上可能造成问题。", "title": "修复共享内存中 WAL 接收进程统计信息里的未初始化变量", "commits": ["d4b667e93"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "6a491e7980b83030c0a86da0e80023b7ad4b28e97bfdc238be8bd9ff40d631fd", "section_path": ["变更"], "commit_groups": [["614b7f18b", "d4b667e93"]], "identity_text": "Fix uninitialized variable in walreceiver's statistics in shared memory (Fujii Masao) This error was harmless on most platforms, but could cause issues on platforms lacking atomic variables and/or spinlock support.", "commit_aliases": ["614b7f18b", "d4b667e93"], "source_commits": ["d4b667e93"], "source_entry_id": "13.3/changes/032", "db_id": "4dfcfae8ab58d4a6ed350341b4896ed3", "patch_ids": ["16397dac7d384da807c481126fb5f4c6"], "statement_hash": "d0dcd960f9bf56c4da424a5288b1910d8bac1367aee448fbea24347991701a00", "relations": [], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-5f86528874f31d42", "cves": [], "html": "<p>在编译时包含了 dtrace 支持但未启用时，降低 LWLock 操作中 dtrace 探针的开销（Peter Eisentraut）<a href=\"https://postgr.es/c/e48ce7ef0\">§</a> <a href=\"https://postgr.es/c/0d204a4b0\">§</a></p>", "text": "在编译时包含了 dtrace 支持但未启用时，降低 LWLock 操作中 dtrace 探针的开销（Peter Eisentraut）§ §", "title": "在编译时包含了 dtrace 支持但未启用时，降低 LWLock 操作中 dtrace 探针的开销", "commits": ["0d204a4b0", "e48ce7ef0"], "section": "变更", "category": "performance", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "b3b8e06dbe996c046302e241304b47594d06c3aaf72b913904394e7a1b857936", "section_path": ["变更"], "commit_groups": [["0d204a4b0", "fa8fbadb9"], ["b94409a02", "e48ce7ef0"]], "identity_text": "Reduce the overhead of dtrace probes for LWLock operations, when dtrace support is compiled in but not active (Peter Eisentraut)", "commit_aliases": ["0d204a4b0", "b94409a02", "e48ce7ef0", "fa8fbadb9"], "source_commits": ["0d204a4b0", "e48ce7ef0"], "source_entry_id": "13.3/changes/033", "db_id": "5ad606177f6b9d17df2252e782823d28", "patch_ids": ["2175f03dd4c289ef956c8b75548c0bea", "9c1862a64d2cfe9ee8aee681067c641e"], "statement_hash": "11536147b13a028cb44878d094959c8476c32bc0fa857f04bd829bdc20e3c119", "relations": [], "version": "13.3", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-6cb8c6a49ab8caa0", "cves": [], "html": "<p>修复 PL/pgSQL <code>DO</code> 块同时使用复合类型变量和事务控制时的失败（Tom Lane）<a href=\"https://postgr.es/c/97b7ad468\">§</a></p>\n<p>以前，此类情况会导致关于元组描述符泄漏的错误。</p>", "text": "修复 PL/pgSQL DO 块同时使用复合类型变量和事务控制时的失败（Tom Lane）§ 以前，此类情况会导致关于元组描述符泄漏的错误。", "title": "修复 PL/pgSQL DO 块同时使用复合类型变量和事务控制时的失败", "commits": ["97b7ad468"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "757e82e7883f55c88a77936fdb357948ccc5540fc026e5d04f75f3b6abef37a6", "section_path": ["变更"], "commit_groups": [["22f2a98cf", "6530df6c2", "97b7ad468", "c2db458c1"]], "identity_text": "Fix failure when a PL/pgSQL DO block makes use of both composite-type variables and transaction control (Tom Lane) Previously, such cases led to errors about leaked tuple descriptors.", "commit_aliases": ["22f2a98cf", "6530df6c2", "97b7ad468", "c2db458c1"], "source_commits": ["97b7ad468"], "source_entry_id": "13.3/changes/034", "db_id": "815af4f67c20802cb4925bf07f3cb9f2", "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e", "relations": [{"rule": 2, "type": "equivalent", "target": "06dd88a06d68630994b88beff68676c4", "evidence": {"same_day": true, "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e"}}, {"rule": 2, "type": "equivalent", "target": "f6dc76d2791f6e5d887ce9d9a043ef6e", "evidence": {"same_day": true, "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f6dc76d2791f6e5d887ce9d9a043ef6e", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 PL/pgSQL DO 块同时使用复合类型变量和事务控制时的失败", "evidence": {"same_day": true, "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e"}, "url": "/docs/compare/?release=12.7#12.7-7444eb8ef76a8f49", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "06dd88a06d68630994b88beff68676c4", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 PL/pgSQL DO 块同时使用复合类型变量和事务控制时的失败", "evidence": {"same_day": true, "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e"}, "url": "/docs/compare/?release=11.12#11.12-21af9a15c9576a53", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}]}, {"id": "13.3-d1b3e4574f126458", "cves": [], "html": "<p>防止 <span>libpq</span> 收到长度损坏的 ParameterDescription 消息时陷入无限循环（Tom Lane）<a href=\"https://postgr.es/c/3580b4a0c\">§</a></p>", "text": "防止 libpq 收到长度损坏的 ParameterDescription 消息时陷入无限循环（Tom Lane）§", "title": "防止 libpq 收到长度损坏的 ParameterDescription 消息时陷入无限循环", "commits": ["3580b4a0c"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "ae095282170d25677c2c1ff6cbfd0187f644e3af0bfbba8176a0474b9f7595bd", "section_path": ["变更"], "commit_groups": [["3580b4a0c", "51c54bb60", "56defbdd0", "a98e53e10", "d2be6cdc5", "d3a557894"]], "identity_text": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received (Tom Lane)", "commit_aliases": ["3580b4a0c", "51c54bb60", "56defbdd0", "a98e53e10", "d2be6cdc5", "d3a557894"], "source_commits": ["3580b4a0c"], "source_entry_id": "13.3/changes/035", "db_id": "46eef7218cafa404380daee2f63d31a0", "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287", "relations": [{"rule": 2, "type": "equivalent", "target": "20962137519d9b459e46e1ca576e6fec", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}}, {"rule": 2, "type": "equivalent", "target": "546f4a726fe3405762281da3367c949f", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}}, {"rule": 2, "type": "equivalent", "target": "cc3057e47b0e74abc43def86be80e4e8", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}}, {"rule": 2, "type": "equivalent", "target": "e0aaeb46fa67ca300769b7f407099603", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "546f4a726fe3405762281da3367c949f", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "防止 libpq 收到长度损坏的 ParameterDescription 消息时陷入无限循环", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}, "url": "/docs/compare/?release=12.7#12.7-eec70e869190c282", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "e0aaeb46fa67ca300769b7f407099603", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "防止 libpq 收到长度损坏的 ParameterDescription 消息时陷入无限循环", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}, "url": "/docs/compare/?release=11.12#11.12-c5447b73a4a7d956", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "20962137519d9b459e46e1ca576e6fec", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "防止 libpq 收到长度损坏的 ParameterDescription 消息时陷入无限循环", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}, "url": "/docs/compare/?release=10.17#10.17-c5447b73a4a7d956", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "cc3057e47b0e74abc43def86be80e4e8", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "防止收到长度损坏的 ParameterDescription 消息时 libpq 陷入无限循环", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}, "url": "/docs/compare/?release=9.6.22#9.6.22-160fe053a6923109", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-c3c388e0c2cee9ba", "cves": [], "html": "<p>当 <span>initdb</span> 打印如何启动服务器的说明时，使其在 Windows 上显示的 <span>pg_ctl</span> 路径使用反斜杠分隔符（Nitin Jadhav）<a href=\"https://postgr.es/c/b52fd1e7c\">§</a></p>", "text": "当 initdb 打印如何启动服务器的说明时，使其在 Windows 上显示的 pg_ctl 路径使用反斜杠分隔符（Nitin Jadhav）§", "title": "当 initdb 打印如何启动服务器的说明时，使其在 Windows 上显示的 pg_ctl 路径使用反斜杠分隔符", "commits": ["b52fd1e7c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "bb26fc7660d735c43eac8a32864b9a5b827516a5e628cbc6179620e88b9e9d97", "section_path": ["变更"], "commit_groups": [["75dbfe4ca", "926139dd0", "ae1c1d84e", "b52fd1e7c", "f92776791"]], "identity_text": "When initdb prints instructions about how to start the server, make the path shown for pg_ctl use backslash separators on Windows (Nitin Jadhav)", "commit_aliases": ["75dbfe4ca", "926139dd0", "ae1c1d84e", "b52fd1e7c", "f92776791"], "source_commits": ["b52fd1e7c"], "source_entry_id": "13.3/changes/036", "db_id": "ef96f3983ff07fbbec86298e689af748", "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa", "relations": [{"rule": 2, "type": "equivalent", "target": "978606246e68f045876e9a51bf1047d6", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}}, {"rule": 2, "type": "equivalent", "target": "c92d15a5b66a70b4adf3b3810d8dc87f", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}}, {"rule": 2, "type": "equivalent", "target": "e4e524dcabec6d412314a19b53e7894f", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "c92d15a5b66a70b4adf3b3810d8dc87f", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "当 initdb 打印如何启动服务器的说明时，使其在 Windows 上显示的 pg_ctl 路径使用反斜杠分隔符", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}, "url": "/docs/compare/?release=12.7#12.7-f7f208d1cc9ef825", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "e4e524dcabec6d412314a19b53e7894f", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "当 initdb 打印如何启动服务器的说明时，使其在 Windows 上显示的 pg_ctl 路径使用反斜杠分隔符", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}, "url": "/docs/compare/?release=11.12#11.12-51902079e0b7eca0", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "978606246e68f045876e9a51bf1047d6", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "当 initdb 打印如何启动服务器的说明时，使其在 Windows 上显示的 pg_ctl 路径使用反斜杠分隔符", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}, "url": "/docs/compare/?release=10.17#10.17-51902079e0b7eca0", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-846e4f14cd80f245", "cves": [], "html": "<p>修复 <span>psql</span>，恢复 <code>\\connect service=<em><code>something</code></em></code> 以前的行为（Tom Lane）<a href=\"https://postgr.es/c/c6eac71a8\">§</a></p>\n<p>先前的一项缺陷修复导致环境变量（例如 <code>PGPORT</code>）在此情况下覆盖服务文件中的条目。现在恢复以前的行为，使优先级反过来。</p>", "text": "修复 psql，恢复 \\connect service=something 以前的行为（Tom Lane）§ 先前的一项缺陷修复导致环境变量（例如 PGPORT）在此情况下覆盖服务文件中的条目。现在恢复以前的行为，使优先级反过来。", "title": "修复 psql，恢复 \\connect service=something 以前的行为", "commits": ["c6eac71a8"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "c9f7892eb7a0adee821b21d38329e4b28a021bb64ca85c0d23af130129611f12", "section_path": ["变更"], "commit_groups": [["4f670c64e", "beac4bd65", "c6eac71a8", "d5a905ed5", "d75edab42", "ea8013854"]], "identity_text": "Fix psql to restore the previous behavior of \\connect service=something (Tom Lane) A previous bug fix caused environment variables (such as PGPORT) to override entries in the service file in this context. Restore the previous behavior, in which the priority is the other way around.", "commit_aliases": ["4f670c64e", "beac4bd65", "c6eac71a8", "d5a905ed5", "d75edab42", "ea8013854"], "source_commits": ["c6eac71a8"], "source_entry_id": "13.3/changes/037", "db_id": "c7082c0d989394b0641dbee7e15c1e7e", "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2", "relations": [{"rule": 2, "type": "equivalent", "target": "116dbfb4021dc8f708c6d39c560689d5", "evidence": {"same_day": true, "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2"}}, {"rule": 2, "type": "equivalent", "target": "4c17f93954329cc6f9f954669ba4ce36", "evidence": {"same_day": true, "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2"}}, {"rule": 2, "type": "equivalent", "target": "bee1a221cb288c1e02115549cb090f1b", "evidence": {"same_day": true, "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2"}}, {"rule": 2, "type": "equivalent", "target": "dbf74091bb1c8fe612e90357b67e32d7", "evidence": {"same_day": true, "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "dbf74091bb1c8fe612e90357b67e32d7", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 psql，恢复 \\connect service=something 以前的行为", "evidence": {"same_day": true, "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2"}, "url": "/docs/compare/?release=12.7#12.7-82ad77b59962a124", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "116dbfb4021dc8f708c6d39c560689d5", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 psql，恢复 \\connect service=something 以前的行为", "evidence": {"same_day": true, "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2"}, "url": "/docs/compare/?release=11.12#11.12-33788c5c4452efbb", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "bee1a221cb288c1e02115549cb090f1b", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 psql，恢复 \\connect service=something 以前的行为", "evidence": {"same_day": true, "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2"}, "url": "/docs/compare/?release=10.17#10.17-33788c5c4452efbb", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "4c17f93954329cc6f9f954669ba4ce36", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 psql，恢复 \\connect service=something 的先前行为", "evidence": {"same_day": true, "patch_ids": ["fab7e7d8b3905b68e36138d8f0d656e6"], "statement_hash": "736cb2e14988f53a452617794d06e7660f2909179f5e68c3e5b93d01f643deb2"}, "url": "/docs/compare/?release=9.6.22#9.6.22-ca1fa4611c3c3294", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-4207528dc5fe71a1", "cves": [], "html": "<p>修复 <span>psql</span> 的 <code>ON_ERROR_ROLLBACK</code> 功能，使其正确处理 <code>COMMIT AND CHAIN</code> 命令（Arthur Nascimento）<a href=\"https://postgr.es/c/be7485a1e\">§</a></p>\n<p>以前，这种情况会以 <span>“<span>savepoint \"pg_psql_temporary_savepoint\" does not exist</span>”</span> 错误失败。</p>", "text": "修复 psql 的 ON_ERROR_ROLLBACK 功能，使其正确处理 COMMIT AND CHAIN 命令（Arthur Nascimento）§ 以前，这种情况会以 “savepoint \"pg_psql_temporary_savepoint\" does not exist” 错误失败。", "title": "修复 psql 的 ON_ERROR_ROLLBACK 功能，使其正确处理 COMMIT AND CHAIN 命令", "commits": ["be7485a1e"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "4261d5d9120eaa86bd7830b6e9dab3c748beed1214ffc9484fb0328e28bc598e", "section_path": ["变更"], "commit_groups": [["67b3ee292", "be7485a1e", "fe06819f1"]], "identity_text": "Fix psql's ON_ERROR_ROLLBACK feature to handle COMMIT AND CHAIN commands correctly (Arthur Nascimento) Previously, this case failed with savepoint \"pg_psql_temporary_savepoint\" does not exist.", "commit_aliases": ["67b3ee292", "be7485a1e", "fe06819f1"], "source_commits": ["be7485a1e"], "source_entry_id": "13.3/changes/038", "db_id": "ba0102e30ddaddf1298eeed83e300e0c", "patch_ids": ["9c951d59b5ab2de56affd68fc6279f77"], "statement_hash": "9347ba15375638d7580d2e1d533c21c7882ff7e35ba05d7e0af0a685359ae502", "relations": [{"rule": 2, "type": "equivalent", "target": "a604a24fcdfd08328f9e35d6b7ad0289", "evidence": {"same_day": true, "patch_ids": ["9c951d59b5ab2de56affd68fc6279f77"], "statement_hash": "9347ba15375638d7580d2e1d533c21c7882ff7e35ba05d7e0af0a685359ae502"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a604a24fcdfd08328f9e35d6b7ad0289", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 psql 的 ON_ERROR_ROLLBACK 功能，使其正确处理 COMMIT AND CHAIN 命令", "evidence": {"same_day": true, "patch_ids": ["9c951d59b5ab2de56affd68fc6279f77"], "statement_hash": "9347ba15375638d7580d2e1d533c21c7882ff7e35ba05d7e0af0a685359ae502"}, "url": "/docs/compare/?release=12.7#12.7-125607d63501710b", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-ca8436d9586f9a88", "cves": [], "html": "<p>在 <span>psql</span> 中，避免首次出现 <span>“<span>could not print result table</span>”</span> 错误后反复发生同类错误（Álvaro Herrera）<a href=\"https://postgr.es/c/f50dc2c72\">§</a></p>", "text": "在 psql 中，避免首次出现 “could not print result table” 错误后反复发生同类错误（Álvaro Herrera）§", "title": "在 psql 中，避免首次出现 “could not print result table” 错误后反复发生同类错误", "commits": ["f50dc2c72"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "acb9b2294fe2e2cf995a1d939c5faab5341daf309ae5a3b52c56420a1abbd7f0", "section_path": ["变更"], "commit_groups": [["8d645a116", "f50dc2c72"]], "identity_text": "In psql, avoid repeated could not print result table failures after the first such error (Álvaro Herrera)", "commit_aliases": ["8d645a116", "f50dc2c72"], "source_commits": ["f50dc2c72"], "source_entry_id": "13.3/changes/039", "db_id": "9b04900aa416ab9eabadcf87d05ebe8e", "patch_ids": ["bc74b6fc382b184418d7f04dd8c2b4e9"], "statement_hash": "f1cc807ab416bdd22f6b1ed2a7b1a9ebca63dce700200d43665f747fd16cb763", "relations": [], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-57ede42ce642fa9a", "cves": [], "html": "<p>修复 <span>psql</span> 的 <code>\\e</code> 及相关命令检测文件修改时的竞争条件（Laurenz Albe）<a href=\"https://postgr.es/c/6ed059933\">§</a></p>\n<p>输入速度非常快的用户可能使代码基于文件时间戳对临时编辑文件是否更改的判断失准。</p>", "text": "修复 psql 的 \\e 及相关命令检测文件修改时的竞争条件（Laurenz Albe）§ 输入速度非常快的用户可能使代码基于文件时间戳对临时编辑文件是否更改的判断失准。", "title": "修复 psql 的 \\e 及相关命令检测文件修改时的竞争条件", "commits": ["6ed059933"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "a58532f66a923cebe356236199d11036aa1faa797e61294a522134c7d48e8940", "section_path": ["变更"], "commit_groups": [["33aa7d13d", "48d67fd89", "60e5c2b14", "6ed059933", "8915e7906", "a42c4438b"]], "identity_text": "Fix race condition in detection of file modification by psql's \\e and related commands (Laurenz Albe) A very fast typist could fool the code's file-timestamp-based detection of whether the temporary edit file was changed.", "commit_aliases": ["33aa7d13d", "48d67fd89", "60e5c2b14", "6ed059933", "8915e7906", "a42c4438b"], "source_commits": ["6ed059933"], "source_entry_id": "13.3/changes/040", "db_id": "9490d94d24adfc3753c23708e68ea756", "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433", "relations": [{"rule": 2, "type": "equivalent", "target": "629ec2f506257dac0541d0eb5f2df930", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}}, {"rule": 2, "type": "equivalent", "target": "789d0f31913e4825828aee505607146c", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}}, {"rule": 2, "type": "equivalent", "target": "a5b781e82406d8ec8e6110705c010700", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}}, {"rule": 2, "type": "equivalent", "target": "a97d6f6fa8cb0ec9888093363fd3bc91", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a5b781e82406d8ec8e6110705c010700", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 psql 的 \\e 及相关命令检测文件修改时的竞争条件", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}, "url": "/docs/compare/?release=12.7#12.7-cc0b940141de7ebc", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "629ec2f506257dac0541d0eb5f2df930", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 psql 的 \\e 及相关命令检测文件修改时的竞争条件", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}, "url": "/docs/compare/?release=11.12#11.12-07948f89c9d80c85", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "789d0f31913e4825828aee505607146c", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 psql 的 \\e 及相关命令检测文件修改时的竞争条件", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}, "url": "/docs/compare/?release=10.17#10.17-07948f89c9d80c85", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "a97d6f6fa8cb0ec9888093363fd3bc91", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 psql 的 \\e 及相关命令检测文件修改时的竞态条件", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}, "url": "/docs/compare/?release=9.6.22#9.6.22-fa8121edc8178671", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-9dc3e8b14435c2da", "cves": [], "html": "<p>修复 <span>pg_dump</span> 对分区表中生成列的转储（Peter Eisentraut）<a href=\"https://postgr.es/c/a6a3a274a\">§</a></p>\n<p>上一个小版本引入的一项修复只应应用于传统继承表，不应应用于分区表。</p>", "text": "修复 pg_dump 对分区表中生成列的转储（Peter Eisentraut）§ 上一个小版本引入的一项修复只应应用于传统继承表，不应应用于分区表。", "title": "修复 pg_dump 对分区表中生成列的转储", "commits": ["a6a3a274a"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "86c94bf8f8333c947f77d09faffbf044a1e915944ba274c87b5be6af9014a09b", "section_path": ["变更"], "commit_groups": [["a6a3a274a", "bdaa0d2d7", "feb270d10"]], "identity_text": "Fix pg_dump's dumping of generated columns in partitioned tables (Peter Eisentraut) A fix introduced in the previous minor release should not be applied to partitioned tables, only traditionally-inherited tables.", "commit_aliases": ["a6a3a274a", "bdaa0d2d7", "feb270d10"], "source_commits": ["a6a3a274a"], "source_entry_id": "13.3/changes/041", "db_id": "1c6c0e97646846b873245ebc8f35cf6d", "patch_ids": ["d4768d7523874d6ec712498db061d2e4"], "statement_hash": "be201fe8e3427dde6b4b8e921b33cc47691d3bdecb873bd49c810db9d6f10db9", "relations": [{"rule": 2, "type": "equivalent", "target": "2575d6865024d36485ba52d9e2641094", "evidence": {"same_day": true, "patch_ids": ["d4768d7523874d6ec712498db061d2e4"], "statement_hash": "be201fe8e3427dde6b4b8e921b33cc47691d3bdecb873bd49c810db9d6f10db9"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "2575d6865024d36485ba52d9e2641094", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 pg_dump 对分区表中生成列的转储", "evidence": {"same_day": true, "patch_ids": ["d4768d7523874d6ec712498db061d2e4"], "statement_hash": "be201fe8e3427dde6b4b8e921b33cc47691d3bdecb873bd49c810db9d6f10db9"}, "url": "/docs/compare/?release=12.7#12.7-d4f5550c0d6b4e1a", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-130f7a85d04342ce", "cves": [], "html": "<p>修复 <span>pg_restore</span> 中遗漏的文件版本检查（Tom Lane）<a href=\"https://postgr.es/c/35421a470\">§</a></p>\n<p>从不支持定位的来源读取自定义格式归档时，<span>pg_restore</span> 忽略了检查归档版本。如果输入的归档版本比它所支持的版本更新，之后就会以混乱的方式失败。</p>", "text": "修复 pg_restore 中遗漏的文件版本检查（Tom Lane）§ 从不支持定位的来源读取自定义格式归档时，pg_restore 忽略了检查归档版本。如果输入的归档版本比它所支持的版本更新，之后就会以混乱的方式失败。", "title": "修复 pg_restore 中遗漏的文件版本检查", "commits": ["35421a470"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "7b7abe973e403f2dec683b2721933578b9f0f31d79589cdb878988d8a75f7b0d", "section_path": ["变更"], "commit_groups": [["1b6961c8f", "25fe401d5", "2c9b857af", "35421a470", "84c5e0dd2", "ec03f2df1"]], "identity_text": "Fix missed file version check in pg_restore (Tom Lane) When reading a custom-format archive from a non-seekable source, pg_restore neglected to check the archive version. If it was fed a newer archive version than it can support, it would fail messily later on.", "commit_aliases": ["1b6961c8f", "25fe401d5", "2c9b857af", "35421a470", "84c5e0dd2", "ec03f2df1"], "source_commits": ["35421a470"], "source_entry_id": "13.3/changes/042", "db_id": "66907a60b4852950edf387af36c10dbb", "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9", "relations": [{"rule": 2, "type": "equivalent", "target": "715fd254bd8a4717c986721fdf71070d", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}}, {"rule": 2, "type": "equivalent", "target": "a7163c4d0c78c39be674cefac9a50abc", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}}, {"rule": 2, "type": "equivalent", "target": "bf10eb31ef22649341d965fb9d13d2cc", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}}, {"rule": 2, "type": "equivalent", "target": "f9160e6dc2769150fb108fe831bb2531", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f9160e6dc2769150fb108fe831bb2531", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 pg_restore 中遗漏的文件版本检查", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}, "url": "/docs/compare/?release=12.7#12.7-215f5c04452b2f36", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "bf10eb31ef22649341d965fb9d13d2cc", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 pg_restore 中遗漏的文件版本检查", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}, "url": "/docs/compare/?release=11.12#11.12-b2b29c9834ba075b", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "a7163c4d0c78c39be674cefac9a50abc", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 pg_restore 中遗漏的文件版本检查", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}, "url": "/docs/compare/?release=10.17#10.17-b2b29c9834ba075b", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "715fd254bd8a4717c986721fdf71070d", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 pg_restore 漏检文件版本的问题", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}, "url": "/docs/compare/?release=9.6.22#9.6.22-3ec0b2f3e8de9211", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-a1e79a1c9aa1137a", "cves": [], "html": "<p>为 <span>pg_upgrade</span> 增加对包含不可升级数据类型的用户表的检查（Tom Lane）<a href=\"https://postgr.es/c/bbcfee0e5\">§</a></p>\n<p>修复对不可升级的数据类型嵌入容器类型（例如数组或范围）中的某些情况的检测。另外，如果用户表包含系统定义的复合类型的列，则不允许升级，因为这些类型的 OID 在不同版本之间并不稳定。</p>", "text": "为 pg_upgrade 增加对包含不可升级数据类型的用户表的检查（Tom Lane）§ 修复对不可升级的数据类型嵌入容器类型（例如数组或范围）中的某些情况的检测。另外，如果用户表包含系统定义的复合类型的列，则不允许升级，因为这些类型的 OID 在不同版本之间并不稳定。", "title": "为 pg_upgrade 增加对包含不可升级数据类型的用户表的检查", "commits": ["bbcfee0e5"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "1b7f7b5122e8b7bcfc712b400172e966540c59670f9d37f39e0bf159580dece1", "section_path": ["变更"], "commit_groups": [["404946d40", "54a233071", "57c081de0", "ba86371b9", "bbcfee0e5", "d5722c927"]], "identity_text": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types (Tom Lane) Fix detection of some cases where a non-upgradable data type is embedded within a container type (such as an array or range). Also disallow upgrading when user tables contain columns of system-defined composite types, since those types' OIDs are not stable across versions.", "commit_aliases": ["404946d40", "54a233071", "57c081de0", "ba86371b9", "bbcfee0e5", "d5722c927"], "source_commits": ["bbcfee0e5"], "source_entry_id": "13.3/changes/043", "db_id": "4a35a518c763a81d11486e7586282fdd", "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506", "relations": [{"rule": 2, "type": "equivalent", "target": "abc8e5d67ba0f03b572aa61fb16fa606", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}}, {"rule": 2, "type": "equivalent", "target": "b847847e95257ae080ca36d3c4db7c46", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}}, {"rule": 2, "type": "equivalent", "target": "bb329e3677e2f4a8187c163041b2467b", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}}, {"rule": 2, "type": "equivalent", "target": "bdd180e442b2457a080f8ede3edfb6cd", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "bdd180e442b2457a080f8ede3edfb6cd", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "为 pg_upgrade 增加对包含不可升级数据类型的用户表的检查", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}, "url": "/docs/compare/?release=12.7#12.7-6fc52d428f2f81e1", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "bb329e3677e2f4a8187c163041b2467b", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "为 pg_upgrade 增加对包含不可升级数据类型的用户表的检查", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}, "url": "/docs/compare/?release=11.12#11.12-30a5c5ce3956af46", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "b847847e95257ae080ca36d3c4db7c46", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "为 pg_upgrade 增加对包含不可升级数据类型的用户表的检查", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}, "url": "/docs/compare/?release=10.17#10.17-30a5c5ce3956af46", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "abc8e5d67ba0f03b572aa61fb16fa606", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "为 pg_upgrade 增加更多对包含不可升级数据类型的用户表的检查", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}, "url": "/docs/compare/?release=9.6.22#9.6.22-01aa2189fc590de9", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-56211a9323cb831d", "cves": [], "html": "<p>修复 <span>pg_checksums</span> 中不正确的进度报告计算（Shinya Kato）<a href=\"https://postgr.es/c/104164361\">§</a></p>", "text": "修复 pg_checksums 中不正确的进度报告计算（Shinya Kato）§", "title": "修复 pg_checksums 中不正确的进度报告计算", "commits": ["104164361"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "e97e5e765664ca45ca6675831162ac866c0bedab24cabf46344462337cc427e1", "section_path": ["变更"], "commit_groups": [["104164361", "24bcce3bd", "2eb1fc8b1"]], "identity_text": "Fix incorrect progress-reporting calculation in pg_checksums (Shinya Kato)", "commit_aliases": ["104164361", "24bcce3bd", "2eb1fc8b1"], "source_commits": ["104164361"], "source_entry_id": "13.3/changes/044", "db_id": "02b9ec1798ffc3c0418e8aba7016d5f8", "patch_ids": ["2d334b7b72c08943ee7ab7b49a2ba376"], "statement_hash": "2b80274fe47abd276817bf75acdfd9ff144eec623e8d892e49b56867f073834f", "relations": [{"rule": 2, "type": "equivalent", "target": "6273201352519e745fb31eb6211d2695", "evidence": {"same_day": true, "patch_ids": ["2d334b7b72c08943ee7ab7b49a2ba376"], "statement_hash": "2b80274fe47abd276817bf75acdfd9ff144eec623e8d892e49b56867f073834f"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6273201352519e745fb31eb6211d2695", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 pg_checksums 中不正确的进度报告计算", "evidence": {"same_day": true, "patch_ids": ["2d334b7b72c08943ee7ab7b49a2ba376"], "statement_hash": "2b80274fe47abd276817bf75acdfd9ff144eec623e8d892e49b56867f073834f"}, "url": "/docs/compare/?release=12.7#12.7-7a4ea0644dc4362c", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-650c9e32773ccb57", "cves": [], "html": "<p>修复 <span>pg_waldump</span>，使其在生成逐记录统计信息时正确统计 <code>XACT</code> 记录（Kyotaro Horiguchi）<a href=\"https://postgr.es/c/34279fd4f\">§</a></p>", "text": "修复 pg_waldump，使其在生成逐记录统计信息时正确统计 XACT 记录（Kyotaro Horiguchi）§", "title": "修复 pg_waldump，使其在生成逐记录统计信息时正确统计 XACT 记录", "commits": ["34279fd4f"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "67fd3d6492ba033854c14d6f18eda2d23d317b182b198939aa99171fc5e3f74a", "section_path": ["变更"], "commit_groups": [["34279fd4f", "4220e06f4", "4a2627c41", "51893c846", "5386a8506", "e73068b07"]], "identity_text": "Fix pg_waldump to count XACT records correctly when generating per-record statistics (Kyotaro Horiguchi)", "commit_aliases": ["34279fd4f", "4220e06f4", "4a2627c41", "51893c846", "5386a8506", "e73068b07"], "source_commits": ["34279fd4f"], "source_entry_id": "13.3/changes/045", "db_id": "15a0fdba1603a2fb77a254f2bff1ffc1", "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261", "relations": [{"rule": 2, "type": "equivalent", "target": "191764d2b7f59eec30f9503c182fe916", "evidence": {"same_day": true, "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261"}}, {"rule": 2, "type": "equivalent", "target": "2deed9332fac2f24b11a781fb9bac839", "evidence": {"same_day": true, "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261"}}, {"rule": 2, "type": "equivalent", "target": "99c2c5cd828d5a16e7254eb5aa4bced3", "evidence": {"same_day": true, "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261"}}, {"rule": 2, "type": "equivalent", "target": "9b2840b6b9fd5bffd0900a09fad79736", "evidence": {"same_day": true, "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "191764d2b7f59eec30f9503c182fe916", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 pg_waldump，使其在生成逐记录统计信息时正确统计 XACT 记录", "evidence": {"same_day": true, "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261"}, "url": "/docs/compare/?release=12.7#12.7-6d00bb5e17dbfa56", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "2deed9332fac2f24b11a781fb9bac839", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 pg_waldump，使其在生成逐记录统计信息时正确统计 XACT 记录", "evidence": {"same_day": true, "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261"}, "url": "/docs/compare/?release=11.12#11.12-e5c33348418ff4d8", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "9b2840b6b9fd5bffd0900a09fad79736", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 pg_waldump，使其在生成逐记录统计信息时正确统计 XACT 记录", "evidence": {"same_day": true, "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261"}, "url": "/docs/compare/?release=10.17#10.17-e5c33348418ff4d8", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "99c2c5cd828d5a16e7254eb5aa4bced3", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 pg_waldump 在生成逐记录统计时对 XACT 记录的计数", "evidence": {"same_day": true, "patch_ids": ["37f24563004a04b9b8719206fc002c9b"], "statement_hash": "62f5e02676b62f43a87860a3597f2382dd42ffce85c97796f2654fe2a700a261"}, "url": "/docs/compare/?release=9.6.22#9.6.22-c6816bcee191dec3", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-e07e3d4dd848fb1b", "cves": [], "html": "<p>修复 <code>contrib/amcheck</code>，使其不再因元组标志 <code>HEAP_XMAX_LOCK_ONLY</code> 和 <code>HEAP_KEYS_UPDATED</code> 同时设置而报错（Julien Rouhaud）<a href=\"https://postgr.es/c/28f4b6108\">§</a></p>\n<p>这是 <code>SELECT FOR UPDATE</code> 之后的一种有效状态。</p>", "text": "修复 contrib/amcheck，使其不再因元组标志 HEAP_XMAX_LOCK_ONLY 和 HEAP_KEYS_UPDATED 同时设置而报错（Julien Rouhaud）§ 这是 SELECT FOR UPDATE 之后的一种有效状态。", "title": "修复 contrib/amcheck，使其不再因元组标志 HEAP_XMAX_LOCK_ONLY 和 HEAP_KEYS_UPDATED 同时设置而报错", "commits": ["28f4b6108"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "b00d742d8e13bf3194715e4bbd7f82d7a14a1721921423d18cc891516e6f0eb5", "section_path": ["变更"], "commit_groups": [["0ccebe779", "258391707", "2796ae2ad", "28f4b6108", "8deb6b38d", "bf518fefa"]], "identity_text": "Fix contrib/amcheck to not complain about the tuple flags HEAP_XMAX_LOCK_ONLY and HEAP_KEYS_UPDATED both being set (Julien Rouhaud) This is a valid state after SELECT FOR UPDATE.", "commit_aliases": ["0ccebe779", "258391707", "2796ae2ad", "28f4b6108", "8deb6b38d", "bf518fefa"], "source_commits": ["28f4b6108"], "source_entry_id": "13.3/changes/046", "db_id": "c428f7cbafcf889bbd24c2d703afc8a1", "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2", "relations": [{"rule": 2, "type": "equivalent", "target": "03430d78c7197cbdbd4b5154404099dd", "evidence": {"same_day": true, "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2"}}, {"rule": 2, "type": "equivalent", "target": "46cf5e6392e585c108df88f560ba19e0", "evidence": {"same_day": true, "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2"}}, {"rule": 2, "type": "equivalent", "target": "e885d411401ddad9358a9fb28a0d2027", "evidence": {"same_day": true, "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2"}}, {"rule": 2, "type": "equivalent", "target": "ead519e93f069d185ec7b76b51f4c414", "evidence": {"same_day": true, "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ead519e93f069d185ec7b76b51f4c414", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 contrib/amcheck，使其不再因元组标志 HEAP_XMAX_LOCK_ONLY 和 HEAP_KEYS_UPDATED 同时设置而报错", "evidence": {"same_day": true, "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2"}, "url": "/docs/compare/?release=12.7#12.7-d27b2a1d13d77853", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "46cf5e6392e585c108df88f560ba19e0", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 contrib/amcheck，使其不再因元组标志 HEAP_XMAX_LOCK_ONLY 和 HEAP_KEYS_UPDATED 同时设置而报错", "evidence": {"same_day": true, "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2"}, "url": "/docs/compare/?release=11.12#11.12-fcb7ca14a2de3cca", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "e885d411401ddad9358a9fb28a0d2027", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 contrib/amcheck，使其不再因元组标志 HEAP_XMAX_LOCK_ONLY 和 HEAP_KEYS_UPDATED 同时设置而报错", "evidence": {"same_day": true, "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2"}, "url": "/docs/compare/?release=10.17#10.17-fcb7ca14a2de3cca", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "03430d78c7197cbdbd4b5154404099dd", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 contrib/amcheck 不再对同时设置了元组标志 HEAP_XMAX_LOCK_ONLY 和 HEAP_KEYS_UPDATED 报怨", "evidence": {"same_day": true, "patch_ids": ["532b61ef424402770de657ec50ca7ee2"], "statement_hash": "8d862505d16b5938059c3b7ced4ce7627b20411b8915074adfe742084efa55a2"}, "url": "/docs/compare/?release=9.6.22#9.6.22-df1999e32518d078", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-f4f1281003126428", "cves": [], "html": "<p>调整 VPATH 构建规则，以支持较新版本的 Oracle Developer Studio 编译器（Noah Misch）<a href=\"https://postgr.es/c/13881199e\">§</a></p>", "text": "调整 VPATH 构建规则，以支持较新版本的 Oracle Developer Studio 编译器（Noah Misch）§", "title": "调整 VPATH 构建规则，以支持较新版本的 Oracle Developer Studio 编译器", "commits": ["13881199e"], "section": "变更", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "059ba252677d27dec2730a23671018c066ebb9453dd56c9c02a360756fbd55a5", "section_path": ["变更"], "commit_groups": [["13881199e", "455dbc010", "4749c7ff4", "c8da16ba1", "f488d19f3", "fb9812b6c"]], "identity_text": "Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions (Noah Misch)", "commit_aliases": ["13881199e", "455dbc010", "4749c7ff4", "c8da16ba1", "f488d19f3", "fb9812b6c"], "source_commits": ["13881199e"], "source_entry_id": "13.3/changes/047", "db_id": "5a1e2b32ba24f2105020cf405dee28aa", "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c", "relations": [{"rule": 2, "type": "equivalent", "target": "2431ed226eb3ece1ee012e119ee804d6", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}}, {"rule": 2, "type": "equivalent", "target": "67c6b59641c1e9a17f6bd874be7e694c", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}}, {"rule": 2, "type": "equivalent", "target": "77e1e3a9debc4e533cda64e3938174e2", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}}, {"rule": 2, "type": "equivalent", "target": "eb8154c18011d297b73acf6cd5836fa5", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}}], "version": "13.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "67c6b59641c1e9a17f6bd874be7e694c", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "调整 VPATH 构建规则，以支持较新版本的 Oracle Developer Studio 编译器", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}, "url": "/docs/compare/?release=12.7#12.7-29df11f62dca7309", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "2431ed226eb3ece1ee012e119ee804d6", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "调整 VPATH 构建规则，以支持较新版本的 Oracle Developer Studio 编译器", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}, "url": "/docs/compare/?release=11.12#11.12-09c5c2b451bafe18", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "77e1e3a9debc4e533cda64e3938174e2", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "调整 VPATH 构建规则，以支持较新版本的 Oracle Developer Studio 编译器", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}, "url": "/docs/compare/?release=10.17#10.17-09c5c2b451bafe18", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "eb8154c18011d297b73acf6cd5836fa5", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "调整 VPATH 构建规则以支持较新的 Oracle Developer Studio 编译器版本", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}, "url": "/docs/compare/?release=9.6.22#9.6.22-092d0460f5b52397", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}, {"id": "13.3-b1a59dd0a955e8eb", "cves": [], "html": "<p>修复 Solaris 上针对 Python 3 的 PL/Python 测试（Noah Misch）<a href=\"https://postgr.es/c/766c8fce5\">§</a></p>", "text": "修复 Solaris 上针对 Python 3 的 PL/Python 测试（Noah Misch）§", "title": "修复 Solaris 上针对 Python 3 的 PL/Python 测试", "commits": ["766c8fce5"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "a23eca3b33fe1e5b3f34d23f7a2f1ad3d441823f82790269f2accf67d482137e", "section_path": ["变更"], "commit_groups": [["14652a19f", "4a3de4092", "72a9bd047", "766c8fce5", "c3556f6fa", "e3ac7d176"]], "identity_text": "Fix testing of PL/Python for Python 3 on Solaris (Noah Misch)", "commit_aliases": ["14652a19f", "4a3de4092", "72a9bd047", "766c8fce5", "c3556f6fa", "e3ac7d176"], "source_commits": ["766c8fce5"], "source_entry_id": "13.3/changes/048", "db_id": "b2d2752178e70fb98f83de3934d73d26", "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7", "relations": [{"rule": 2, "type": "equivalent", "target": "17dbeb20be5ddeb53681473f23bc4b25", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}}, {"rule": 2, "type": "equivalent", "target": "2344812cc386e14dd7dd54e4a4e882fe", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}}, {"rule": 2, "type": "equivalent", "target": "4f3f6954d89c0b65253f9600be8a9ec8", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}}, {"rule": 2, "type": "equivalent", "target": "a029a502265ccdbd46a66494d03d3a76", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}}], "version": "13.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "4f3f6954d89c0b65253f9600be8a9ec8", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "修复 Solaris 上针对 Python 3 的 PL/Python 测试", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}, "url": "/docs/compare/?release=12.7#12.7-676562672b5b8180", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "17dbeb20be5ddeb53681473f23bc4b25", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "修复 Solaris 上针对 Python 3 的 PL/Python 测试", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}, "url": "/docs/compare/?release=11.12#11.12-3011e96c7113dc41", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "a029a502265ccdbd46a66494d03d3a76", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "修复 Solaris 上针对 Python 3 的 PL/Python 测试", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}, "url": "/docs/compare/?release=10.17#10.17-3011e96c7113dc41", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "2344812cc386e14dd7dd54e4a4e882fe", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "修复 Solaris 上 PL/Python 对 Python 3 的测试", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}, "url": "/docs/compare/?release=9.6.22#9.6.22-0823a56806e72b56", "source_url": "/docs/release/9.6.22/#id-1.11.6.7.6"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 48}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 27}, {"key": "security", "label": "安全相关", "count": 3}, {"key": "performance", "label": "性能改进", "count": 1}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 17}], "total": 48, "release_count": 1, "cross_major": false, "cve_count": 3, "cves": [{"id": "CVE-2021-32029", "url": "https://www.postgresql.org/support/security/CVE-2021-32029/", "fixed": {"11": "11.12", "12": "12.7", "13": "13.3"}, "score": 6.5, "title": "修复涉及连接的跨分区更新中 UPDATE ... RETURNING 输出可能计算不正确的问题", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N", "affected": {"11": "11", "12": "12", "13": "13"}, "component": "core server", "published": {"11": "2021-05-13", "12": "2021-05-13", "13": "2021-05-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Using an UPDATE ... RETURNING on a purpose-crafted partitioned table, an attacker can read arbitrary bytes of server memory. In the default configuration, any authenticated database user can create prerequisite objects and complete this attack at will. A user lacking the CREATE and TEMPORARY privileges on all databases and the CREATE privilege on all schemas typically cannot use this attack at will.\n\nThe PostgreSQL project thanks Tom Lane for reporting this problem.", "first_published": "2021-05-13", "fixed_version": "13.3"}, {"id": "CVE-2021-32028", "url": "https://www.postgresql.org/support/security/CVE-2021-32028/", "fixed": {"10": "10.17", "11": "11.12", "12": "12.7", "13": "13.3", "9.6": "9.6.22"}, "score": 6.5, "title": "修复 INSERT ... ON CONFLICT ... UPDATE 目标列表中对 “junk” 列的错误处理", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N", "affected": {"10": "10", "11": "11", "12": "12", "13": "13", "9.6": "9.6"}, "component": "core server", "published": {"10": "2021-05-13", "11": "2021-05-13", "12": "2021-05-13", "13": "2021-05-13", "9.6": "2021-05-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Using an INSERT ... ON CONFLICT ... DO UPDATE command on a purpose-crafted table, an attacker can read arbitrary bytes of server memory. In the default configuration, any authenticated database user can create prerequisite objects and complete this attack at will. A user lacking the CREATE and TEMPORARY privileges on all databases and the CREATE privilege on all schemas cannot use this attack at will.\n\nThe PostgreSQL project thanks Andres Freund for reporting this problem.", "first_published": "2021-05-13", "fixed_version": "13.3"}, {"id": "CVE-2021-32027", "url": "https://www.postgresql.org/support/security/CVE-2021-32027/", "fixed": {"10": "10.17", "11": "11.12", "12": "12.7", "13": "13.3", "9.6": "9.6.22"}, "score": 6.5, "title": "防止数组下标计算中的整数溢出", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:H/A:N", "affected": {"10": "10", "11": "11", "12": "12", "13": "13", "9.6": "9.6"}, "component": "core server", "published": {"10": "2021-05-13", "11": "2021-05-13", "12": "2021-05-13", "13": "2021-05-13", "9.6": "2021-05-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "While modifying certain SQL array values, missing bounds checks let authenticated database users write arbitrary bytes to a wide area of server memory.\n\nThe PostgreSQL project thanks Tom Lane for reporting this problem.", "first_published": "2021-05-13", "fixed_version": "13.3"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 48, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}