{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2024-08-08", "build": "14.13", "major": "14", "minor": 13, "manual": "14", "status": "stable", "doc_git": "", "version": "14.13", "eol_date": "2026-11-12", "date_text": "2024-08-08", "supported": true, "manual_url": "/docs/14/release-14-13.html", "source_url": "/docs/release/14.13/", "entry_count": 42, "placeholder": false, "content_hash": "5e1237aec2ef948e4bc10e70345f7c3e55e99f81cc93a39f7b53fc64d4cd1b98", "manual_build": "14.24", "source_as_of": "", "changes_count": 42, "doc_loaded_at": "2026-09-26T02:56:39.341991", "migration_html": "<p>对于运行 14.X 的用户，不需要执行导出/恢复。</p>\n<p>但是，如果是从早于 14.12 的版本升级，请参见<a href=\"/docs/14/release-14-12.html\" title=\"E.13. 发布版本 14.12\">第 E.13 节</a>。</p>", "compatibility_count": 0, "label": "14.13", "status_label": "受支持版本", "eol": "2026-11-12", "age_days": 783, "support_days": 43}, "groups": [{"date": "2024-08-08", "build": "14.13", "major": "14", "minor": 13, "manual": "14", "status": "stable", "doc_git": "", "version": "14.13", "eol_date": "2026-11-12", "date_text": "2024-08-08", "supported": true, "manual_url": "/docs/14/release-14-13.html", "source_url": "/docs/release/14.13/", "entry_count": 42, "placeholder": false, "content_hash": "5e1237aec2ef948e4bc10e70345f7c3e55e99f81cc93a39f7b53fc64d4cd1b98", "manual_build": "14.24", "source_as_of": "", "changes_count": 42, "doc_loaded_at": "2026-09-26T02:56:39.341991", "migration_html": "<p>对于运行 14.X 的用户，不需要执行导出/恢复。</p>\n<p>但是，如果是从早于 14.12 的版本升级，请参见<a href=\"/docs/14/release-14-12.html\" title=\"E.13. 发布版本 14.12\">第 E.13 节</a>。</p>", "compatibility_count": 0, "label": "14.13", "status_label": "受支持版本", "eol": "2026-11-12", "age_days": 783, "support_days": 43, "entries": [{"id": "14.13-79afc7e6590473c8", "cves": ["CVE-2024-7348"], "html": "<p>防止在 <span>pg_dump</span> 期间执行未经授权的代码（Masahiko Sawada）<a href=\"https://postgr.es/c/72ef1675e\">§</a></p>\n<p>能够创建和删除非临时对象的攻击者可以注入 SQL 代码，该代码将由并发的 <span>pg_dump</span> 会话以运行 <span>pg_dump</span> 的角色权限（通常是超级用户）来执行。该攻击涉及将序列或类似对象替换为会执行恶意代码的视图或外部表。为防止此问题，引入了新的服务器参数 <code>restrict_nonsystem_relation_kind</code>，可以禁止展开非内置视图以及访问外部表，并教会 <span>pg_dump</span> 在可用时设置该参数。请注意，只有当 <span>pg_dump</span> 和它正在导出的服务器都足够新以包含此修复时，才能防止该攻击。</p>\n<p><span>PostgreSQL</span> 项目感谢 Noah Misch 报告此问题。（CVE-2024-7348）</p>", "text": "防止在 pg_dump 期间执行未经授权的代码（Masahiko Sawada）§ 能够创建和删除非临时对象的攻击者可以注入 SQL 代码，该代码将由并发的 pg_dump 会话以运行 pg_dump 的角色权限（通常是超级用户）来执行。该攻击涉及将序列或类似对象替换为会执行恶意代码的视图或外部表。为防止此问题，引入了新的服务器参数 restrict_nonsystem_relation_kind，可以禁止展开非内置视图以及访问外部表，并教会 pg_dump 在可用时设置该参数。请注意，只有当 pg_dump 和它正在导出的服务器都足够新以包含此修复时，才能防止该攻击。 PostgreSQL 项目感谢 Noah Misch 报告此问题。（CVE-2024-7348）", "title": "防止在 pg_dump 期间执行未经授权的代码", "commits": ["72ef1675e"], "section": "变更", "category": "security", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "9b939da7e5d254a5c90a9d97b35331ccf9f77bf36a7ffd8acc076ac62ab5060f", "section_path": ["变更"], "commit_groups": [["66e94448a", "6aba85a4b", "72ef1675e", "79c7a7e29", "bbc94abf6", "e81e53a0c", "fdf218f1d"]], "identity_text": "Prevent unauthorized code execution during pg_dump (Masahiko Sawada) An attacker able to create and drop non-temporary objects could inject SQL code that would be executed by a concurrent pg_dump session with the privileges of the role running pg_dump (which is often a superuser). The attack involves replacing a sequence or similar object with a view or foreign table that will execute malicious code. To prevent this, introduce a new server parameter restrict_nonsystem_relation_kind that can disable expansion of non-builtin views as well as access to foreign tables, and teach pg_dump to set it when available. Note that the attack is prevented only if both pg_dump and the server it is dumping from are new enough to have this fix. The PostgreSQL Project thanks Noah Misch for reporting this problem. (CVE-2024-7348)", "commit_aliases": ["66e94448a", "6aba85a4b", "72ef1675e", "79c7a7e29", "bbc94abf6", "e81e53a0c", "fdf218f1d"], "source_commits": ["72ef1675e"], "source_entry_id": "14.13/changes/001", "db_id": "813f22fc083427431bb4dd5fcb505625", "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7", "relations": [{"rule": 2, "type": "equivalent", "target": "4b8b6b30269d73c62119ec73a51f0787", "evidence": {"same_day": true, "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7"}}, {"rule": 2, "type": "equivalent", "target": "4e8fb19dc66d6a954a3a437033ec67d9", "evidence": {"same_day": true, "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7"}}, {"rule": 2, "type": "equivalent", "target": "5d48bc189a82a99da15c73ad2beebd72", "evidence": {"same_day": true, "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7"}}, {"rule": 2, "type": "equivalent", "target": "e64d8d76637f2cffb62c55e70118cc12", "evidence": {"same_day": true, "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7"}}], "version": "14.13", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "4e8fb19dc66d6a954a3a437033ec67d9", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "防止在 pg_dump 期间执行未经授权的代码", "evidence": {"same_day": true, "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7"}, "url": "/docs/compare/?release=16.4#16.4-24bc6aee30d87842", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "4b8b6b30269d73c62119ec73a51f0787", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "防止在 pg_dump 期间执行未经授权的代码", "evidence": {"same_day": true, "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7"}, "url": "/docs/compare/?release=15.8#15.8-cb2ec150ee97d968", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "5d48bc189a82a99da15c73ad2beebd72", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "防止在 pg_dump 期间执行未经授权的代码", "evidence": {"same_day": true, "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7"}, "url": "/docs/compare/?release=13.16#13.16-2e433a29b91b07a9", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "e64d8d76637f2cffb62c55e70118cc12", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "防止在 pg_dump 期间执行未经授权的代码", "evidence": {"same_day": true, "patch_ids": ["523fefda20c4d31aa6651d4a7832080b"], "statement_hash": "ff2dee7eaaaf5dfc9ab9abedc4b4ae86551f7a51e147d1c5317f6963700be2d7"}, "url": "/docs/compare/?release=12.20#12.20-0874e137f764db4c", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-d59a2ab2e7a24902", "cves": [], "html": "<p>防止 <code>VACUUM</code> 中的无限循环（Melanie Plageman）<a href=\"https://postgr.es/c/45ce054c0\">§</a></p>\n<p>在一个具有旧运行事务的断开连接的备库重新连接到主库之后，主库上的 <code>VACUUM</code> 可能会对哪些元组可以移除产生混淆，从而导致无限循环。</p>", "text": "防止 VACUUM 中的无限循环（Melanie Plageman）§ 在一个具有旧运行事务的断开连接的备库重新连接到主库之后，主库上的 VACUUM 可能会对哪些元组可以移除产生混淆，从而导致无限循环。", "title": "防止 VACUUM 中的无限循环", "commits": ["45ce054c0"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "842e2380f233951d1dfda0121b8f6999616083644e5b1590ca607f2cccdb5fd6", "section_path": ["变更"], "commit_groups": [["06bf404cd", "45ce054c0", "83c39a1f7", "dc6354c67", "fd4f12df5"]], "identity_text": "Prevent infinite loop in VACUUM (Melanie Plageman) After a disconnected standby server with an old running transaction reconnected to the primary, it was possible for VACUUM on the primary to get confused about which tuples are removable, resulting in an infinite loop.", "commit_aliases": ["06bf404cd", "45ce054c0", "83c39a1f7", "dc6354c67", "fd4f12df5"], "source_commits": ["45ce054c0"], "source_entry_id": "14.13/changes/002", "db_id": "cf58994dbec26ceb5a5540265849c69f", "patch_ids": ["70c0f97b84fabfd63cd3e9680ab0aa54"], "statement_hash": "9d0235a0718aa961251cc42a6fe86b0b987f60cd4debea53a5fa3dca582e2447", "relations": [{"rule": 2, "type": "equivalent", "target": "d80d353729fe2385a4582c6d271cd039", "evidence": {"same_day": true, "patch_ids": ["70c0f97b84fabfd63cd3e9680ab0aa54"], "statement_hash": "9d0235a0718aa961251cc42a6fe86b0b987f60cd4debea53a5fa3dca582e2447"}}, {"rule": 2, "type": "equivalent", "target": "d854ebe6ecf749252f64d7308ef12e6f", "evidence": {"same_day": true, "patch_ids": ["70c0f97b84fabfd63cd3e9680ab0aa54"], "statement_hash": "9d0235a0718aa961251cc42a6fe86b0b987f60cd4debea53a5fa3dca582e2447"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "d854ebe6ecf749252f64d7308ef12e6f", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "防止 VACUUM 中的无限循环", "evidence": {"same_day": true, "patch_ids": ["70c0f97b84fabfd63cd3e9680ab0aa54"], "statement_hash": "9d0235a0718aa961251cc42a6fe86b0b987f60cd4debea53a5fa3dca582e2447"}, "url": "/docs/compare/?release=16.4#16.4-adadf3107ed4b412", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "d80d353729fe2385a4582c6d271cd039", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "防止 VACUUM 中的无限循环", "evidence": {"same_day": true, "patch_ids": ["70c0f97b84fabfd63cd3e9680ab0aa54"], "statement_hash": "9d0235a0718aa961251cc42a6fe86b0b987f60cd4debea53a5fa3dca582e2447"}, "url": "/docs/compare/?release=15.8#15.8-bf83fcff283d0939", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}]}, {"id": "14.13-d9ad424821eab142", "cves": [], "html": "<p>修复在将表作为分区附加后的失败，如果该表之前有继承子表（Álvaro Herrera）<a href=\"https://postgr.es/c/fe1d16f66\">§</a></p>", "text": "修复在将表作为分区附加后的失败，如果该表之前有继承子表（Álvaro Herrera）§", "title": "修复在将表作为分区附加后的失败，如果该表之前有继承子表", "commits": ["fe1d16f66"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "89b724d6f8bb920d2cfccdb5bcc7706e8ddc42c1d8f334ab261a0c941f0d8a96", "section_path": ["变更"], "commit_groups": [["084814d88", "08b6a9ecf", "2b22543a4", "3dd637f3d", "ed7430975", "f74fac06c", "fe1d16f66"]], "identity_text": "Fix failure after attaching a table as a partition, if the table had previously had inheritance children (Álvaro Herrera)", "commit_aliases": ["084814d88", "08b6a9ecf", "2b22543a4", "3dd637f3d", "ed7430975", "f74fac06c", "fe1d16f66"], "source_commits": ["fe1d16f66"], "source_entry_id": "14.13/changes/003", "db_id": "fd19bcbfaacaf9a4cb511ac5de0af2bb", "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a", "relations": [{"rule": 2, "type": "equivalent", "target": "36f46d6303c1417bbde592ba867df825", "evidence": {"same_day": true, "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a"}}, {"rule": 2, "type": "equivalent", "target": "b21d67c28f0ca5242009519e7b173b7b", "evidence": {"same_day": true, "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a"}}, {"rule": 2, "type": "equivalent", "target": "b3cf42386a8c74e236e8bbb0697d28be", "evidence": {"same_day": true, "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a"}}, {"rule": 2, "type": "equivalent", "target": "ec94ee5a2790279a8a25b3dd3fa5d63a", "evidence": {"same_day": true, "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ec94ee5a2790279a8a25b3dd3fa5d63a", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复在将表作为分区附加后的失败，如果该表之前有继承子表", "evidence": {"same_day": true, "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a"}, "url": "/docs/compare/?release=16.4#16.4-d4eaac69a923e982", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "b3cf42386a8c74e236e8bbb0697d28be", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复在将表作为分区附加后的失败，如果该表之前有继承子表", "evidence": {"same_day": true, "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a"}, "url": "/docs/compare/?release=15.8#15.8-9b4166ac9d50e4b8", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "b21d67c28f0ca5242009519e7b173b7b", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复在将表作为分区附加后的失败，如果该表之前有继承子表", "evidence": {"same_day": true, "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a"}, "url": "/docs/compare/?release=13.16#13.16-ceaf20678b789860", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "36f46d6303c1417bbde592ba867df825", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复在将表作为分区附加后的失败，如果该表之前有继承子表", "evidence": {"same_day": true, "patch_ids": ["d194b679b521d7439d65560aa40f7eaa"], "statement_hash": "7f7c03eea395221a19931a49a8add19dcca8e00080c3dd073f2b8c37666c7a6a"}, "url": "/docs/compare/?release=12.20#12.20-a5310dd3542d0be4", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-7e4c44b0e8944a10", "cves": [], "html": "<p>修复涉及不一致的基于索引的约束时 <code>ALTER TABLE DETACH PARTITION</code> 的问题（Álvaro Herrera，Tender Wang）<a href=\"https://postgr.es/c/66aaa7a71\">§</a> <a href=\"https://postgr.es/c/2f5007459\">§</a></p>\n<p>当分区表有一个不与约束关联的索引，但某个分区有一个等效的索引且该索引与约束关联时，分离该分区会出现异常行为，导致前分区的约束具有不正确的 <code>coninhcount</code> 值。这会在后续对该约束进行任何操作时引发问题。</p>", "text": "修复涉及不一致的基于索引的约束时 ALTER TABLE DETACH PARTITION 的问题（Álvaro Herrera，Tender Wang）§ § 当分区表有一个不与约束关联的索引，但某个分区有一个等效的索引且该索引与约束关联时，分离该分区会出现异常行为，导致前分区的约束具有不正确的 coninhcount 值。这会在后续对该约束进行任何操作时引发问题。", "title": "修复涉及不一致的基于索引的约束时 ALTER TABLE DETACH PARTITION 的问题", "commits": ["2f5007459", "66aaa7a71"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "3e34485fbb70f6f0d63e75eca33dafd5da140dc9b9a43eb1d86297cd24695ebb", "section_path": ["变更"], "commit_groups": [["00a40e33c", "057482569", "30ca4e1ab", "4ae09c59d", "66aaa7a71", "839177913", "d0054432d"], ["0340eefd9", "067cb6c5d", "2f5007459", "34eb37f79", "74e12db19", "7898a494f", "9f0f72d89"]], "identity_text": "Fix ALTER TABLE DETACH PARTITION for cases involving inconsistent index-based constraints (Álvaro Herrera, Tender Wang) When a partitioned table has an index that is not associated with a constraint, but a partition has an equivalent index that is, then detaching the partition would misbehave, leaving the ex-partition's constraint with an incorrect coninhcount value. This would cause trouble during any further manipulations of that constraint.", "commit_aliases": ["00a40e33c", "0340eefd9", "057482569", "067cb6c5d", "2f5007459", "30ca4e1ab", "34eb37f79", "4ae09c59d", "66aaa7a71", "74e12db19", "7898a494f", "839177913", "9f0f72d89", "d0054432d"], "source_commits": ["2f5007459", "66aaa7a71"], "source_entry_id": "14.13/changes/004", "db_id": "d4f7b1c3ac3631a0b2d426a828db4e7d", "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4", "relations": [{"rule": 2, "type": "equivalent", "target": "0b5de1e04a8f32032a437c6404911548", "evidence": {"same_day": true, "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4"}}, {"rule": 2, "type": "equivalent", "target": "a890785f64ab4befa8f0bc9dab907637", "evidence": {"same_day": true, "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4"}}, {"rule": 2, "type": "equivalent", "target": "b53ea97012521fd43d7008e825deb747", "evidence": {"same_day": true, "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4"}}, {"rule": 2, "type": "equivalent", "target": "e6946f4aa46c1453fc9816029aeb48b0", "evidence": {"same_day": true, "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a890785f64ab4befa8f0bc9dab907637", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复涉及不一致的基于索引的约束时 ALTER TABLE DETACH PARTITION 的问题", "evidence": {"same_day": true, "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4"}, "url": "/docs/compare/?release=16.4#16.4-9b5674d1dbb513ed", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "b53ea97012521fd43d7008e825deb747", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复涉及不一致的基于索引的约束时 ALTER TABLE DETACH PARTITION 的问题", "evidence": {"same_day": true, "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4"}, "url": "/docs/compare/?release=15.8#15.8-d28967b11040c2ea", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "0b5de1e04a8f32032a437c6404911548", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复涉及不一致的基于索引的约束时 ALTER TABLE DETACH PARTITION 的问题", "evidence": {"same_day": true, "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4"}, "url": "/docs/compare/?release=13.16#13.16-f6e4b254611abdf4", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "e6946f4aa46c1453fc9816029aeb48b0", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复涉及不一致的基于索引的约束时 ALTER TABLE DETACH PARTITION 的问题", "evidence": {"same_day": true, "patch_ids": ["7a474cd20dd560cf058c4fa7c9a88bc0", "da6fe3a741a29320268685bf55e6d728"], "statement_hash": "cc22cdf207c9f0287940f7d24242c7d3189d8f4066304018b704d3a20779cda4"}, "url": "/docs/compare/?release=12.20#12.20-aa70dc747225f04d", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-b1e4d95284bfca87", "cves": [], "html": "<p>修复 <code>ALTER TABLE DETACH PARTITION CONCURRENTLY</code> 期间的分区剪枝设置（Álvaro Herrera）<a href=\"https://postgr.es/c/96105ebfe\">§</a> <a href=\"https://postgr.es/c/bf78abebf\">§</a></p>\n<p>执行器假定在对分区表的查询规划和执行之间不会有分区被分离。自从引入 <code>DETACH PARTITION</code> 的 <code>CONCURRENTLY</code> 选项后，这一假设不再成立，使得在使用该选项时查询执行可能会出现短暂的失败。</p>", "text": "修复 ALTER TABLE DETACH PARTITION CONCURRENTLY 期间的分区剪枝设置（Álvaro Herrera）§ § 执行器假定在对分区表的查询规划和执行之间不会有分区被分离。自从引入 DETACH PARTITION 的 CONCURRENTLY 选项后，这一假设不再成立，使得在使用该选项时查询执行可能会出现短暂的失败。", "title": "修复 ALTER TABLE DETACH PARTITION CONCURRENTLY 期间的分区剪枝设置", "commits": ["96105ebfe", "bf78abebf"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "572d55407e6696bca762370829b26d55abebaf861f01ce39dc6216e309a15198", "section_path": ["变更"], "commit_groups": [["03c8cdbb7", "5dcaefc6a", "bf78abebf", "c2fab7024"], ["27162a64b", "66e569f50", "96105ebfe", "fb0fb0740"]], "identity_text": "Fix partition pruning setup during ALTER TABLE DETACH PARTITION CONCURRENTLY (Álvaro Herrera) The executor assumed that no partition could be detached between planning and execution of a query on a partitioned table. This is no longer true since the introduction of DETACH PARTITION's CONCURRENTLY option, making it possible for query execution to fail transiently when that is used.", "commit_aliases": ["03c8cdbb7", "27162a64b", "5dcaefc6a", "66e569f50", "96105ebfe", "bf78abebf", "c2fab7024", "fb0fb0740"], "source_commits": ["5dcaefc6a", "66e569f50"], "source_entry_id": "14.13/changes/005", "db_id": "a0b998fe6dac012277a1b4d9751d713d", "patch_ids": ["4dbc8f300a6d7a1c82a98a15cb8aa1be", "fd9400809a6fe6411b5b9684b122233a"], "statement_hash": "aa80133bb62e2a0823eab05aad5946127ffb0bae64b9d2d1a6d7666cce462649", "relations": [{"rule": 2, "type": "equivalent", "target": "4284caa93dab0414d2a02cbea72530d8", "evidence": {"same_day": true, "patch_ids": ["4dbc8f300a6d7a1c82a98a15cb8aa1be", "fd9400809a6fe6411b5b9684b122233a"], "statement_hash": "aa80133bb62e2a0823eab05aad5946127ffb0bae64b9d2d1a6d7666cce462649"}}, {"rule": 2, "type": "equivalent", "target": "fbdf06f40e5209be8b7468482487692f", "evidence": {"same_day": true, "patch_ids": ["4dbc8f300a6d7a1c82a98a15cb8aa1be", "fd9400809a6fe6411b5b9684b122233a"], "statement_hash": "aa80133bb62e2a0823eab05aad5946127ffb0bae64b9d2d1a6d7666cce462649"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fbdf06f40e5209be8b7468482487692f", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复 ALTER TABLE DETACH PARTITION CONCURRENTLY 期间的分区剪枝设置", "evidence": {"same_day": true, "patch_ids": ["4dbc8f300a6d7a1c82a98a15cb8aa1be", "fd9400809a6fe6411b5b9684b122233a"], "statement_hash": "aa80133bb62e2a0823eab05aad5946127ffb0bae64b9d2d1a6d7666cce462649"}, "url": "/docs/compare/?release=16.4#16.4-b1e4d95284bfca87", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "4284caa93dab0414d2a02cbea72530d8", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复 ALTER TABLE DETACH PARTITION CONCURRENTLY 期间的分区剪枝设置", "evidence": {"same_day": true, "patch_ids": ["4dbc8f300a6d7a1c82a98a15cb8aa1be", "fd9400809a6fe6411b5b9684b122233a"], "statement_hash": "aa80133bb62e2a0823eab05aad5946127ffb0bae64b9d2d1a6d7666cce462649"}, "url": "/docs/compare/?release=15.8#15.8-b1e4d95284bfca87", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}]}, {"id": "14.13-495d14e97c08139a", "cves": [], "html": "<p>在最后一个子分区被删除后，正确地将分区表的 <code>pg_class</code>.<code>reltuples</code> 字段更新为零（Noah Misch）<a href=\"https://postgr.es/c/2b415e95a\">§</a></p>\n<p>对这样的分区表进行第一次 <code>ANALYZE</code> 时必须同时更新 <code>relhassubclass</code>，而这导致 <code>reltuples</code> 的更新丢失。</p>", "text": "在最后一个子分区被删除后，正确地将分区表的 pg_class.reltuples 字段更新为零（Noah Misch）§ 对这样的分区表进行第一次 ANALYZE 时必须同时更新 relhassubclass，而这导致 reltuples 的更新丢失。", "title": "在最后一个子分区被删除后，正确地将分区表的 pg_class.reltuples 字段更新为零", "commits": ["2b415e95a"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "c24629fcdbde09570122de4fa8690a174453a3ab0e6bdd958184674735eb83a8", "section_path": ["变更"], "commit_groups": [["2b415e95a", "2b4a2a79e", "710207032", "e81deeefc", "f5bb46fb2"]], "identity_text": "Correctly update a partitioned table's pg_class.reltuples field to zero after its last child partition is dropped (Noah Misch) The first ANALYZE on such a partitioned table must update relhassubclass as well, and that caused the reltuples update to be lost.", "commit_aliases": ["2b415e95a", "2b4a2a79e", "710207032", "e81deeefc", "f5bb46fb2"], "source_commits": ["2b415e95a"], "source_entry_id": "14.13/changes/006", "db_id": "69f08fdc29318984868322def5665ca9", "patch_ids": ["38d5b163594560c7ec9d236c2241a56f"], "statement_hash": "34af8b42d1f5de0f1ae80e571b5bdf24166da489a671d82d0e73fa676a7b7d99", "relations": [{"rule": 2, "type": "equivalent", "target": "4f782209771174bb9d08a14cef3bae99", "evidence": {"same_day": true, "patch_ids": ["38d5b163594560c7ec9d236c2241a56f"], "statement_hash": "34af8b42d1f5de0f1ae80e571b5bdf24166da489a671d82d0e73fa676a7b7d99"}}, {"rule": 2, "type": "equivalent", "target": "e7fef28cfb717788671e55a4fb20bcb9", "evidence": {"same_day": true, "patch_ids": ["38d5b163594560c7ec9d236c2241a56f"], "statement_hash": "34af8b42d1f5de0f1ae80e571b5bdf24166da489a671d82d0e73fa676a7b7d99"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e7fef28cfb717788671e55a4fb20bcb9", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "在最后一个子分区被删除后，正确地将分区表的 pg_class.reltuples 字段更新为零", "evidence": {"same_day": true, "patch_ids": ["38d5b163594560c7ec9d236c2241a56f"], "statement_hash": "34af8b42d1f5de0f1ae80e571b5bdf24166da489a671d82d0e73fa676a7b7d99"}, "url": "/docs/compare/?release=16.4#16.4-09f19f56ee6390c7", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "4f782209771174bb9d08a14cef3bae99", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "在最后一个子分区被删除后，正确地将分区表的 pg_class.reltuples 字段更新为零", "evidence": {"same_day": true, "patch_ids": ["38d5b163594560c7ec9d236c2241a56f"], "statement_hash": "34af8b42d1f5de0f1ae80e571b5bdf24166da489a671d82d0e73fa676a7b7d99"}, "url": "/docs/compare/?release=15.8#15.8-affd8c3ce7e9b582", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}]}, {"id": "14.13-c118ed77384005ad", "cves": [], "html": "<p>修复过程的多态输出参数的处理（Tom Lane）<a href=\"https://postgr.es/c/8e0e99972\">§</a> <a href=\"https://postgr.es/c/bb331af4a\">§</a></p>\n<p>SQL <code>CALL</code> 语句未能为此类参数解析正确的数据类型，导致诸如 <span>“<span>cannot display a value of type anyelement</span>”</span> 之类的错误，甚至直接崩溃。（但 <span>PL/pgSQL</span> 中的 <code>CALL</code> 可以正确工作。）</p>", "text": "修复过程的多态输出参数的处理（Tom Lane）§ § SQL CALL 语句未能为此类参数解析正确的数据类型，导致诸如 “cannot display a value of type anyelement” 之类的错误，甚至直接崩溃。（但 PL/pgSQL 中的 CALL 可以正确工作。）", "title": "修复过程的多态输出参数的处理", "commits": ["8e0e99972", "bb331af4a"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "9552dd2557d012d237dc52eda782944d4876f69f845e984c71d56b8d833afb67", "section_path": ["变更"], "commit_groups": [["4208f44c9", "5fe43d41d", "751598263", "9de0ff91a", "bb331af4a", "d88dcdf0f"], ["525bd1620", "70ffb27b2", "8e0e99972", "c40e78d23", "e85f641b2", "f535f350c"]], "identity_text": "Fix handling of polymorphic output arguments for procedures (Tom Lane) The SQL CALL statement did not resolve the correct data types for such arguments, leading to errors such as cannot display a value of type anyelement, or even outright crashes. (But CALL in PL/pgSQL worked correctly.)", "commit_aliases": ["4208f44c9", "525bd1620", "5fe43d41d", "70ffb27b2", "751598263", "8e0e99972", "9de0ff91a", "bb331af4a", "c40e78d23", "d88dcdf0f", "e85f641b2", "f535f350c"], "source_commits": ["525bd1620", "d88dcdf0f"], "source_entry_id": "14.13/changes/007", "db_id": "1b1cc49018041233d88062d94b4a58bc", "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724", "relations": [{"rule": 2, "type": "equivalent", "target": "780c380af58f55dc04828c6fc9c0fed3", "evidence": {"same_day": true, "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724"}}, {"rule": 2, "type": "equivalent", "target": "820141551e6621c7014f7c23ea863a6a", "evidence": {"same_day": true, "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724"}}, {"rule": 2, "type": "equivalent", "target": "9104561b33ac989ab5a6bede4dc50e1f", "evidence": {"same_day": true, "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724"}}, {"rule": 2, "type": "equivalent", "target": "f280ad1c7083fdbb19c800fee72b70d3", "evidence": {"same_day": true, "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "9104561b33ac989ab5a6bede4dc50e1f", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复过程的多态输出参数的处理", "evidence": {"same_day": true, "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724"}, "url": "/docs/compare/?release=16.4#16.4-c118ed77384005ad", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "780c380af58f55dc04828c6fc9c0fed3", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复过程的多态输出参数的处理", "evidence": {"same_day": true, "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724"}, "url": "/docs/compare/?release=15.8#15.8-c118ed77384005ad", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "f280ad1c7083fdbb19c800fee72b70d3", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复过程的多态输出参数的处理", "evidence": {"same_day": true, "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724"}, "url": "/docs/compare/?release=13.16#13.16-73b6a7a0d84cc6e0", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "820141551e6621c7014f7c23ea863a6a", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复过程的多态输出参数的处理", "evidence": {"same_day": true, "patch_ids": ["c673c19c8c2fa5b57a80232b1ba74d1d", "fe8b1d79850edc856a2492545fc7de3b"], "statement_hash": "fe9351c1494f416138806c89d55acfb927ac21340774de1a6932c966bd333724"}, "url": "/docs/compare/?release=12.20#12.20-025a2814d5f1a97d", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-fadc4da9ac5a6eae", "cves": [], "html": "<p>修复从 <code>CALL</code> 语句的参数列表中调用稳定函数时的行为（Tom Lane）<a href=\"https://postgr.es/c/0d18b8eb4\">§</a></p>\n<p>如果 <code>CALL</code> 位于原子上下文中（例如存在外部事务块），此类函数会被传递错误的快照，导致它们看到自外部事务开始以来已修改的行的过期值。</p>", "text": "修复从 CALL 语句的参数列表中调用稳定函数时的行为（Tom Lane）§ 如果 CALL 位于原子上下文中（例如存在外部事务块），此类函数会被传递错误的快照，导致它们看到自外部事务开始以来已修改的行的过期值。", "title": "修复从 CALL 语句的参数列表中调用稳定函数时的行为", "commits": ["0d18b8eb4"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "2d987309a163e45d77e4f547415798855db6e41331f4336625e868507708525a", "section_path": ["变更"], "commit_groups": [["0be81dd71", "0d18b8eb4", "0f7d1338c", "1d4ea1376", "2dc1deaea", "a160e9277"]], "identity_text": "Fix behavior of stable functions called from a CALL statement's argument list (Tom Lane) If the CALL is within an atomic context (e.g. there's an outer transaction block), such functions were passed the wrong snapshot, causing them to see stale values of rows modified since the start of the outer transaction.", "commit_aliases": ["0be81dd71", "0d18b8eb4", "0f7d1338c", "1d4ea1376", "2dc1deaea", "a160e9277"], "source_commits": ["0f7d1338c"], "source_entry_id": "14.13/changes/008", "db_id": "4c879b9e67ec7c535d70d1e470727d3c", "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244", "relations": [{"rule": 2, "type": "equivalent", "target": "28dba7f6e6014f5b8c46a679a595a864", "evidence": {"same_day": true, "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244"}}, {"rule": 2, "type": "equivalent", "target": "74a7107eaf68460781b07dd2eff6ceea", "evidence": {"same_day": true, "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244"}}, {"rule": 2, "type": "equivalent", "target": "7a347de7100a8a2c5be0771020158601", "evidence": {"same_day": true, "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244"}}, {"rule": 2, "type": "equivalent", "target": "a07d7962c8f60343f5d4ad6c36dae2b0", "evidence": {"same_day": true, "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a07d7962c8f60343f5d4ad6c36dae2b0", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复从 CALL 语句的参数列表中调用稳定函数时的行为", "evidence": {"same_day": true, "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244"}, "url": "/docs/compare/?release=16.4#16.4-fadc4da9ac5a6eae", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "28dba7f6e6014f5b8c46a679a595a864", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复从 CALL 语句的参数列表中调用稳定函数时的行为", "evidence": {"same_day": true, "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244"}, "url": "/docs/compare/?release=15.8#15.8-fadc4da9ac5a6eae", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "74a7107eaf68460781b07dd2eff6ceea", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复从 CALL 语句的参数列表中调用稳定函数时的行为", "evidence": {"same_day": true, "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244"}, "url": "/docs/compare/?release=13.16#13.16-898f61f2714050ea", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "7a347de7100a8a2c5be0771020158601", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复从 CALL 语句的参数列表中调用稳定函数时的行为", "evidence": {"same_day": true, "patch_ids": ["591579de72ffe4af6c0bfd479dd66a3b"], "statement_hash": "b1f3f1f43ff52ed1251c58f0ccb9f99012dd737fe8509117e69d2dacc00e7244"}, "url": "/docs/compare/?release=12.20#12.20-36607cb96eec13cd", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-395470a0c971f6d8", "cves": [], "html": "<p>检测 <code>money</code> 计算中的整数溢出（Joseph Koshakow）<a href=\"https://postgr.es/c/e8dfe0430\">§</a></p>\n<p>之前 <code>money</code> 类型的所有算术函数都没有检查溢出，因此在溢出的情况下会静默地给出错误的结果。</p>", "text": "检测 money 计算中的整数溢出（Joseph Koshakow）§ 之前 money 类型的所有算术函数都没有检查溢出，因此在溢出的情况下会静默地给出错误的结果。", "title": "检测 money 计算中的整数溢出", "commits": ["e8dfe0430"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "0e3fb3dd6e09fe1fcd2843f8162e33e5fb7c195b80d7a4f5693a1fd816e95f5c", "section_path": ["变更"], "commit_groups": [["22b0ccd65", "34e9dce69", "3764ee47f", "4f9628158", "b82791c8f", "c5321e965", "e8dfe0430"]], "identity_text": "Detect integer overflow in money calculations (Joseph Koshakow) None of the arithmetic functions for the money type checked for overflow before, so they would silently give wrong answers for overflowing cases.", "commit_aliases": ["22b0ccd65", "34e9dce69", "3764ee47f", "4f9628158", "b82791c8f", "c5321e965", "e8dfe0430"], "source_commits": ["e8dfe0430"], "source_entry_id": "14.13/changes/009", "db_id": "b390e27d1bfc9e8195ab41f81bc927c0", "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1", "relations": [{"rule": 2, "type": "equivalent", "target": "11b6bf2fdfe5435a60a177591adf452d", "evidence": {"same_day": true, "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1"}}, {"rule": 2, "type": "equivalent", "target": "352409133223c80a7e88aa00e034e0f3", "evidence": {"same_day": true, "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1"}}, {"rule": 2, "type": "equivalent", "target": "c3fd9a0c92aafeee5708290c2f19cb47", "evidence": {"same_day": true, "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1"}}, {"rule": 2, "type": "equivalent", "target": "fd430934b2423d413cbf1a5d799fa7ed", "evidence": {"same_day": true, "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "11b6bf2fdfe5435a60a177591adf452d", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "检测 money 计算中的整数溢出", "evidence": {"same_day": true, "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1"}, "url": "/docs/compare/?release=16.4#16.4-8f2abad2fd76312c", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "fd430934b2423d413cbf1a5d799fa7ed", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "检测 money 计算中的整数溢出", "evidence": {"same_day": true, "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1"}, "url": "/docs/compare/?release=15.8#15.8-6d5ba0d03266efbd", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "352409133223c80a7e88aa00e034e0f3", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "检测 money 计算中的整数溢出", "evidence": {"same_day": true, "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1"}, "url": "/docs/compare/?release=13.16#13.16-4b0cac87b48a9234", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "c3fd9a0c92aafeee5708290c2f19cb47", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "检测 money 计算中的整数溢出", "evidence": {"same_day": true, "patch_ids": ["2347c1179b305aa93b068dd63f2b6faa"], "statement_hash": "5ac9138ff0134cfd3fee3f30c16da68853c417dacd8941bd81a38db4321e8de1"}, "url": "/docs/compare/?release=12.20#12.20-bce8023057d952f3", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-3b8a8e08f21b008d", "cves": [], "html": "<p>修复 <code>round(numeric)</code> 和 <code>trunc(numeric)</code> 中对小数位参数过于激进的截断（Dean Rasheed）<a href=\"https://postgr.es/c/a3c0124f6\">§</a></p>\n<p>这些函数将小数位参数截断到 +/-2000，但有些有效的使用场景需要更大的值；在这些情况下函数返回了不正确的结果。改为截断到 <code>numeric</code> 类型实际允许的范围。</p>", "text": "修复 round(numeric) 和 trunc(numeric) 中对小数位参数过于激进的截断（Dean Rasheed）§ 这些函数将小数位参数截断到 +/-2000，但有些有效的使用场景需要更大的值；在这些情况下函数返回了不正确的结果。改为截断到 numeric 类型实际允许的范围。", "title": "修复 round(numeric) 和 trunc(numeric) 中对小数位参数过于激进的截断", "commits": ["a3c0124f6"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "1e67702417afbbafe806e8ca6285e34197b37b9221799a353acf48d4a34eb404", "section_path": ["变更"], "commit_groups": [["1ff39f4ff", "47ca912de", "7a8977d25", "8badee787", "a3c0124f6", "ece296926", "f7aec8c1d"]], "identity_text": "Fix over-aggressive clamping of the scale argument in round(numeric) and trunc(numeric) (Dean Rasheed) These functions clamped their scale argument to +/-2000, but there are valid use-cases for it to be larger; the functions returned incorrect results in such cases. Instead clamp to the actual allowed range of type numeric.", "commit_aliases": ["1ff39f4ff", "47ca912de", "7a8977d25", "8badee787", "a3c0124f6", "ece296926", "f7aec8c1d"], "source_commits": ["a3c0124f6"], "source_entry_id": "14.13/changes/010", "db_id": "47549eb0c2b1965d44c1bea698bb435b", "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1", "relations": [{"rule": 2, "type": "equivalent", "target": "464f26d639efe30a7259582dc4ec5ffd", "evidence": {"same_day": true, "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1"}}, {"rule": 2, "type": "equivalent", "target": "864c078229062c2d11995374de108127", "evidence": {"same_day": true, "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1"}}, {"rule": 2, "type": "equivalent", "target": "900760919962e70a7775385651b6951f", "evidence": {"same_day": true, "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1"}}, {"rule": 2, "type": "equivalent", "target": "c31e4062c6d36d86c7095029c789e824", "evidence": {"same_day": true, "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "464f26d639efe30a7259582dc4ec5ffd", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复 round(numeric) 和 trunc(numeric) 中对小数位参数过于激进的截断", "evidence": {"same_day": true, "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1"}, "url": "/docs/compare/?release=16.4#16.4-a98b7e3df6eaaab8", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "864c078229062c2d11995374de108127", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复 round(numeric) 和 trunc(numeric) 中对小数位参数过于激进的截断", "evidence": {"same_day": true, "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1"}, "url": "/docs/compare/?release=15.8#15.8-5131c68cc0c79629", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "c31e4062c6d36d86c7095029c789e824", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复 round(numeric) 和 trunc(numeric) 中对小数位参数过于激进的截断", "evidence": {"same_day": true, "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1"}, "url": "/docs/compare/?release=13.16#13.16-49ff5213d7815826", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "900760919962e70a7775385651b6951f", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复 round(numeric) 和 trunc(numeric) 中对小数位参数过于激进的截断", "evidence": {"same_day": true, "patch_ids": ["1047a03efb16dfc56952a0d093ce1a95"], "statement_hash": "15eaddd6ff6d9cfeb03f60c6074e62611d55909780a080195c81fcf037f4b9d1"}, "url": "/docs/compare/?release=12.20#12.20-2a7ad11c29386d18", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-62c2924647a51e0c", "cves": [], "html": "<p>防止 <code>pg_sequence_last_value()</code> 在备库上的不记录 WAL 的序列以及其他会话的临时序列上失败（Nathan Bossart）<a href=\"https://postgr.es/c/c1664c8ee\">§</a></p>\n<p>在这些情况下使其返回 NULL 而不是抛出错误。</p>", "text": "防止 pg_sequence_last_value() 在备库上的不记录 WAL 的序列以及其他会话的临时序列上失败（Nathan Bossart）§ 在这些情况下使其返回 NULL 而不是抛出错误。", "title": "防止 pg_sequence_last_value() 在备库上的不记录 WAL 的序列以及其他会话的临时序列上失败", "commits": ["c1664c8ee"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "6fcb5c3a83f2ec147a710379fe1f299a6e32d21fb97d7d175442da9207a4f0bc", "section_path": ["变更"], "commit_groups": [["09ec5d455", "2812059d3", "3cb2f13ac", "857d280c6", "c1664c8ee", "c8714230a"]], "identity_text": "Prevent pg_sequence_last_value() from failing on unlogged sequences on standby servers and on temporary sequences of other sessions (Nathan Bossart) Make it return NULL in these cases instead of throwing an error.", "commit_aliases": ["09ec5d455", "2812059d3", "3cb2f13ac", "857d280c6", "c1664c8ee", "c8714230a"], "source_commits": ["c8714230a"], "source_entry_id": "14.13/changes/011", "db_id": "abd4f4e23e691afeec1782d405270108", "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7", "relations": [{"rule": 2, "type": "equivalent", "target": "99df7dca3a5976e202a3d99168f62a0a", "evidence": {"same_day": true, "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7"}}, {"rule": 2, "type": "equivalent", "target": "b5bb3d35aa02583899b8650cc24fb876", "evidence": {"same_day": true, "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7"}}, {"rule": 2, "type": "equivalent", "target": "e12eec6c5a738be6fef94606371c454d", "evidence": {"same_day": true, "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7"}}, {"rule": 2, "type": "equivalent", "target": "f6e89c2fffa8bfe1a8991b772ba61198", "evidence": {"same_day": true, "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f6e89c2fffa8bfe1a8991b772ba61198", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "防止 pg_sequence_last_value() 在备库上的不记录 WAL 的序列以及其他会话的临时序列上失败", "evidence": {"same_day": true, "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7"}, "url": "/docs/compare/?release=16.4#16.4-62c2924647a51e0c", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "99df7dca3a5976e202a3d99168f62a0a", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "防止 pg_sequence_last_value() 在备库上的不记录 WAL 的序列以及其他会话的临时序列上失败", "evidence": {"same_day": true, "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7"}, "url": "/docs/compare/?release=15.8#15.8-62c2924647a51e0c", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "b5bb3d35aa02583899b8650cc24fb876", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "防止 pg_sequence_last_value() 在备库上的不记录 WAL 的序列和其他会话的临时序列上失败", "evidence": {"same_day": true, "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7"}, "url": "/docs/compare/?release=13.16#13.16-3feda48efa54990a", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "e12eec6c5a738be6fef94606371c454d", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "防止 pg_sequence_last_value() 在备库上的不记录 WAL 的序列和其他会话的临时序列上失败", "evidence": {"same_day": true, "patch_ids": ["9347da384122e06ef4905abb03c967b8"], "statement_hash": "66e9662381d668d9b94796775ed0fffdbff033bbf13696f16330f7664da2b3e7"}, "url": "/docs/compare/?release=12.20#12.20-40d68e8ee065f547", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-de2b4991da717550", "cves": [], "html": "<p>修复 <code>websearch_to_tsquery()</code> 中被忽略的操作符的解析（Tom Lane）<a href=\"https://postgr.es/c/086ecd12b\">§</a></p>\n<p>根据手册，<code>websearch_to_tsquery()</code> 的输入中的标点符号除了破折号和引号的特殊情况外都会被忽略。然而，紧接在 <code>or</code> 之前出现的括号和其他一些字符可能导致 <code>or</code> 被视为数据词，而非预期的 <code>OR</code> 操作符。</p>", "text": "修复 websearch_to_tsquery() 中被忽略的操作符的解析（Tom Lane）§ 根据手册，websearch_to_tsquery() 的输入中的标点符号除了破折号和引号的特殊情况外都会被忽略。然而，紧接在 or 之前出现的括号和其他一些字符可能导致 or 被视为数据词，而非预期的 OR 操作符。", "title": "修复 websearch_to_tsquery() 中被忽略的操作符的解析", "commits": ["086ecd12b"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "a0a687c0c9f8a1926207ae993b9ec67f121cbd0eecc515b6c36597805c417dd4", "section_path": ["变更"], "commit_groups": [["086ecd12b", "56a829621", "5912bf77c", "5e63a6f43", "c7de5a654", "df95c1ec0"]], "identity_text": "Fix parsing of ignored operators in websearch_to_tsquery() (Tom Lane) Per the manual, punctuation in the input of websearch_to_tsquery() is ignored except for the special cases of dashes and quotes. However, parentheses and a few other characters appearing immediately before an or could cause or to be treated as a data word, rather than as an OR operator as expected.", "commit_aliases": ["086ecd12b", "56a829621", "5912bf77c", "5e63a6f43", "c7de5a654", "df95c1ec0"], "source_commits": ["5912bf77c"], "source_entry_id": "14.13/changes/012", "db_id": "b4c2f73f672b5458c9a7040be8221a21", "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c", "relations": [{"rule": 2, "type": "equivalent", "target": "5c9026daffdc12d4ddda057a13c9d5e8", "evidence": {"same_day": true, "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c"}}, {"rule": 2, "type": "equivalent", "target": "7344cdfc6e2a8dfec3d630c6eb357c94", "evidence": {"same_day": true, "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c"}}, {"rule": 2, "type": "equivalent", "target": "c1450056b34ca3c2107f9d15bac99530", "evidence": {"same_day": true, "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c"}}, {"rule": 2, "type": "equivalent", "target": "d4762f5c0d82c61ab05f087145078d9d", "evidence": {"same_day": true, "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d4762f5c0d82c61ab05f087145078d9d", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复 websearch_to_tsquery() 中被忽略的操作符的解析", "evidence": {"same_day": true, "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c"}, "url": "/docs/compare/?release=16.4#16.4-de2b4991da717550", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "5c9026daffdc12d4ddda057a13c9d5e8", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复 websearch_to_tsquery() 中被忽略的操作符的解析", "evidence": {"same_day": true, "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c"}, "url": "/docs/compare/?release=15.8#15.8-de2b4991da717550", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "7344cdfc6e2a8dfec3d630c6eb357c94", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复 websearch_to_tsquery() 中对被忽略操作符的解析", "evidence": {"same_day": true, "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c"}, "url": "/docs/compare/?release=13.16#13.16-28460648cf68de79", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "c1450056b34ca3c2107f9d15bac99530", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复 websearch_to_tsquery() 中对被忽略操作符的解析", "evidence": {"same_day": true, "patch_ids": ["cb064cc15f7ff5ae6a0ccc8a24423b04"], "statement_hash": "9226b5d95ffb43a1431d2ce0b709b2635c1d689845fecfc7aa2045ca0d7db26c"}, "url": "/docs/compare/?release=12.20#12.20-594d598c8960abf6", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-13f6c9d61147cac5", "cves": ["CVE-2023-5869"], "html": "<p>检测计算新数组维度时的另一个整数溢出情况（Joseph Koshakow）<a href=\"https://postgr.es/c/670fb9f18\">§</a></p>\n<p>拒绝将数组维度 <code>[-2147483648:2147483647]</code> 应用于空数组。这与 CVE-2023-5869 密切相关，但看起来是无害的，因为数组最终仍然为空。</p>", "text": "检测计算新数组维度时的另一个整数溢出情况（Joseph Koshakow）§ 拒绝将数组维度 [-2147483648:2147483647] 应用于空数组。这与 CVE-2023-5869 密切相关，但看起来是无害的，因为数组最终仍然为空。", "title": "检测计算新数组维度时的另一个整数溢出情况", "commits": ["670fb9f18"], "section": "变更", "category": "security", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "1e9f9e694e4f5ea2acbc19bf667c438372df8a65904b0aa01a0c663f04d5e57b", "section_path": ["变更"], "commit_groups": [["547dd2cbd", "657e54a05", "670fb9f18", "6c1b71bc6", "878e8c6be", "991f8cf8a", "a57d16865"]], "identity_text": "Detect another integer overflow case while computing new array dimensions (Joseph Koshakow) Reject applying array dimensions [-2147483648:2147483647] to an empty array. This is closely related to CVE-2023-5869, but appears harmless since the array still ends up empty.", "commit_aliases": ["547dd2cbd", "657e54a05", "670fb9f18", "6c1b71bc6", "878e8c6be", "991f8cf8a", "a57d16865"], "source_commits": ["670fb9f18"], "source_entry_id": "14.13/changes/013", "db_id": "51f7f01fc4220c797e00a18515161b97", "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e", "relations": [{"rule": 2, "type": "equivalent", "target": "0d2e0b77aae145682f73bd947fa66118", "evidence": {"same_day": true, "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e"}}, {"rule": 2, "type": "equivalent", "target": "4f6878678916cc3dfb82b0249f0ee422", "evidence": {"same_day": true, "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e"}}, {"rule": 2, "type": "equivalent", "target": "855f692bec1a1e21e57a99d7fba42c6f", "evidence": {"same_day": true, "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e"}}, {"rule": 2, "type": "equivalent", "target": "cae41a9a3d98c4cbe51cf0ac818506cb", "evidence": {"same_day": true, "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e"}}], "version": "14.13", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "855f692bec1a1e21e57a99d7fba42c6f", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "检测计算新数组维度时的另一个整数溢出情况", "evidence": {"same_day": true, "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e"}, "url": "/docs/compare/?release=16.4#16.4-1c0606d0a0df7d1b", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "4f6878678916cc3dfb82b0249f0ee422", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "检测计算新数组维度时的另一个整数溢出情况", "evidence": {"same_day": true, "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e"}, "url": "/docs/compare/?release=15.8#15.8-972cc39245b78980", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "cae41a9a3d98c4cbe51cf0ac818506cb", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "检测计算新数组维度时的另一个整数溢出情况", "evidence": {"same_day": true, "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e"}, "url": "/docs/compare/?release=13.16#13.16-27841b5006f6d0ca", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "0d2e0b77aae145682f73bd947fa66118", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "检测计算新数组维度时的另一个整数溢出情况", "evidence": {"same_day": true, "patch_ids": ["0aaa0b11f29fc2801cba8f482431d18f"], "statement_hash": "66af8461726797096f0f79c08d897244d4280c370596efd4a008401131c0002e"}, "url": "/docs/compare/?release=12.20#12.20-9e24737f3cb9daf2", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-7abf34a46259074d", "cves": [], "html": "<p>检测在对目录缓存条目的字段进行解压缩时该条目变为过期的另一种情况（Noah Misch）<a href=\"https://postgr.es/c/e4afd7153\">§</a></p>\n<p>在展开目录元组的行外字段时发生的原地更新可能会被遗漏，导致目录缓存条目缺少原地更改但不被认为是过时的。这仅在 <code>pg_database</code> 目录中可能发生，因此影响范围较窄，但可能会导致异常行为。</p>", "text": "检测在对目录缓存条目的字段进行解压缩时该条目变为过期的另一种情况（Noah Misch）§ 在展开目录元组的行外字段时发生的原地更新可能会被遗漏，导致目录缓存条目缺少原地更改但不被认为是过时的。这仅在 pg_database 目录中可能发生，因此影响范围较窄，但可能会导致异常行为。", "title": "检测在对目录缓存条目的字段进行解压缩时该条目变为过期的另一种情况", "commits": ["e4afd7153"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "3753967a7d20954ee1c1088072370c0a62c6b90653baec879342b311181e0570", "section_path": ["变更"], "commit_groups": [["11f3815d6", "7a21306ae", "af73e37fa", "b08a4b616", "e4afd7153", "f9f47f0d9"]], "identity_text": "Detect another case of a new catalog cache entry becoming stale while detoasting its fields (Noah Misch) An in-place update occurring while we expand out-of-line fields in a catalog tuple could be missed, leading to a catalog cache entry that lacks the in-place change but is not known to be stale. This is only possible in the pg_database catalog, so the effects are narrow, but misbehavior is possible.", "commit_aliases": ["11f3815d6", "7a21306ae", "af73e37fa", "b08a4b616", "e4afd7153", "f9f47f0d9"], "source_commits": ["af73e37fa"], "source_entry_id": "14.13/changes/014", "db_id": "ecd76c9cf55ed9bca0585834bde73361", "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458", "relations": [{"rule": 2, "type": "equivalent", "target": "2733f31505efbc88e387fff2329eb5f4", "evidence": {"same_day": true, "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458"}}, {"rule": 2, "type": "equivalent", "target": "830929c9da73d5fe2011b60418fa480e", "evidence": {"same_day": true, "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458"}}, {"rule": 2, "type": "equivalent", "target": "af2393fa28ddabfb7685be10e5240d35", "evidence": {"same_day": true, "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458"}}, {"rule": 2, "type": "equivalent", "target": "f59220600eeba9606471f7e77870f509", "evidence": {"same_day": true, "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "2733f31505efbc88e387fff2329eb5f4", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "检测在对目录缓存条目的字段进行解压缩时该条目变为过期的另一种情况", "evidence": {"same_day": true, "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458"}, "url": "/docs/compare/?release=16.4#16.4-7abf34a46259074d", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "af2393fa28ddabfb7685be10e5240d35", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "检测在对目录缓存条目的字段进行解压缩时该条目变为过期的另一种情况", "evidence": {"same_day": true, "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458"}, "url": "/docs/compare/?release=15.8#15.8-7abf34a46259074d", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "f59220600eeba9606471f7e77870f509", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "检测新目录缓存条目在展开其字段时变为过时的另一种情况", "evidence": {"same_day": true, "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458"}, "url": "/docs/compare/?release=13.16#13.16-df5e9f79a4fc281b", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "830929c9da73d5fe2011b60418fa480e", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "检测新目录缓存条目在展开其字段时变为过时的另一种情况", "evidence": {"same_day": true, "patch_ids": ["9e0469d680bf3f10ae246f4203e18c6c"], "statement_hash": "53c7fc9ad7628d59f9ad822a34dba796bc338ed2df4185c35a1066a92c68f458"}, "url": "/docs/compare/?release=12.20#12.20-881ee4c28496d044", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-4f50d08869bbda36", "cves": [], "html": "<p>正确检查由 <code>INSERT</code> ... <code>DEFAULT</code> 目标的视图列的可更新性（Tom Lane）<a href=\"https://postgr.es/c/0d712ec12\">§</a></p>\n<p>如果这样的列不可更新，我们应该报告相应的错误。但该检查被遗漏了，随后的代码会报告一个不太有用的错误，如 <span>“<span>attribute number <em><code>N</code></em> not found in view targetlist</span>”</span>。</p>", "text": "正确检查由 INSERT ... DEFAULT 目标的视图列的可更新性（Tom Lane）§ 如果这样的列不可更新，我们应该报告相应的错误。但该检查被遗漏了，随后的代码会报告一个不太有用的错误，如 “attribute number N not found in view targetlist”。", "title": "正确检查由 INSERT ... DEFAULT 目标的视图列的可更新性", "commits": ["0d712ec12"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "b32bb25407f264469dd27944ad38ece97850034e2731ba26bbc5dfc5f846fc23", "section_path": ["变更"], "commit_groups": [["041a00c48", "0d712ec12", "220003b9b", "461f47948", "96953052a", "fd958bbbd", "feca6c688"]], "identity_text": "Correctly check updatability of view columns targeted by INSERT ... DEFAULT (Tom Lane) If such a column is non-updatable, we should give an error reporting that. But the check was missed and then later code would report an unhelpful error such as attribute number N not found in view targetlist.", "commit_aliases": ["041a00c48", "0d712ec12", "220003b9b", "461f47948", "96953052a", "fd958bbbd", "feca6c688"], "source_commits": ["0d712ec12"], "source_entry_id": "14.13/changes/015", "db_id": "f63c1f7e68ba3b3e9a01615c4eda6ee0", "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9", "relations": [{"rule": 2, "type": "equivalent", "target": "140f114f6b31582a09a373258187e1dc", "evidence": {"same_day": true, "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9"}}, {"rule": 2, "type": "equivalent", "target": "66c6478e3050450cfb1b9095f222d3b9", "evidence": {"same_day": true, "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9"}}, {"rule": 2, "type": "equivalent", "target": "7ec1d620c6513334f1a7520c5f2b1323", "evidence": {"same_day": true, "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9"}}, {"rule": 2, "type": "equivalent", "target": "b9e07521871f385832785a22eca4df7a", "evidence": {"same_day": true, "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b9e07521871f385832785a22eca4df7a", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "正确检查由 INSERT ... DEFAULT 目标的视图列的可更新性", "evidence": {"same_day": true, "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9"}, "url": "/docs/compare/?release=16.4#16.4-7077b3dde614dc32", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "7ec1d620c6513334f1a7520c5f2b1323", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "正确检查由 INSERT ... DEFAULT 目标的视图列的可更新性", "evidence": {"same_day": true, "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9"}, "url": "/docs/compare/?release=15.8#15.8-8f4156681cc1caf1", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "140f114f6b31582a09a373258187e1dc", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "正确检查由 INSERT ... DEFAULT 目标的视图列的可更新性", "evidence": {"same_day": true, "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9"}, "url": "/docs/compare/?release=13.16#13.16-f5d4a731a66a5824", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "66c6478e3050450cfb1b9095f222d3b9", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "正确检查由 INSERT ... DEFAULT 目标的视图列的可更新性", "evidence": {"same_day": true, "patch_ids": ["a198179ea880e48023a3c6a4a679a2fb"], "statement_hash": "6e598f513c30570ffff8a50b2238fe8760dbb4c3de28bcd1a40d03409c65eba9"}, "url": "/docs/compare/?release=12.20#12.20-26f4c6cff3b3fdb2", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-1b751427c1d25357", "cves": [], "html": "<p>避免对不正确的递归查询报告无用的内部错误（Tom Lane）<a href=\"https://postgr.es/c/02b4f5e1f\">§</a></p>\n<p>重新排列错误检查的顺序，以便在 <code>WITH RECURSIVE</code> 查询在 <code>UNION</code> 的第二个分支中没有自引用，但在其他位置（如 <code>ORDER BY</code>）有自引用时，抛出针对性的错误。</p>", "text": "避免对不正确的递归查询报告无用的内部错误（Tom Lane）§ 重新排列错误检查的顺序，以便在 WITH RECURSIVE 查询在 UNION 的第二个分支中没有自引用，但在其他位置（如 ORDER BY）有自引用时，抛出针对性的错误。", "title": "避免对不正确的递归查询报告无用的内部错误", "commits": ["02b4f5e1f"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "e822f201ddfc4c9c1384b2d8e6dff2d11e852e92381818fe5a7ca952808ae90c", "section_path": ["变更"], "commit_groups": [["02b4f5e1f", "236b225ed", "8fc487614", "b020a866a", "cf588e10f", "e7f9f44e3", "f96c2c727"]], "identity_text": "Avoid reporting an unhelpful internal error for incorrect recursive queries (Tom Lane) Rearrange the order of error checks so that we throw an on-point error when a WITH RECURSIVE query does not have a self-reference within the second arm of the UNION, but does have one self-reference in some other place such as ORDER BY.", "commit_aliases": ["02b4f5e1f", "236b225ed", "8fc487614", "b020a866a", "cf588e10f", "e7f9f44e3", "f96c2c727"], "source_commits": ["02b4f5e1f"], "source_entry_id": "14.13/changes/016", "db_id": "a1142d586d9e112a13977428a1e67eb2", "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b", "relations": [{"rule": 2, "type": "equivalent", "target": "3fbcca4a22669a9fc9f0c02a24221357", "evidence": {"same_day": true, "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b"}}, {"rule": 2, "type": "equivalent", "target": "556a8a24b599163490bfdd11a1d771a8", "evidence": {"same_day": true, "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b"}}, {"rule": 2, "type": "equivalent", "target": "6405aeb7eaa07135a74929ee3f47d421", "evidence": {"same_day": true, "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b"}}, {"rule": 2, "type": "equivalent", "target": "c38a37e1ceb8ee43f66ba9dff029a276", "evidence": {"same_day": true, "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "6405aeb7eaa07135a74929ee3f47d421", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "避免对不正确的递归查询报告无用的内部错误", "evidence": {"same_day": true, "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b"}, "url": "/docs/compare/?release=16.4#16.4-43d06b240cafa53a", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "556a8a24b599163490bfdd11a1d771a8", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "避免对不正确的递归查询报告无用的内部错误", "evidence": {"same_day": true, "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b"}, "url": "/docs/compare/?release=15.8#15.8-bcfea5ec3ffa9e82", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "3fbcca4a22669a9fc9f0c02a24221357", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "避免对不正确的递归查询报告无用的内部错误", "evidence": {"same_day": true, "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b"}, "url": "/docs/compare/?release=13.16#13.16-e056f8ee7124b218", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "c38a37e1ceb8ee43f66ba9dff029a276", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "避免对不正确的递归查询报告无用的内部错误", "evidence": {"same_day": true, "patch_ids": ["7d9a548feecb6f3d9d2bb7f0b653d8a1"], "statement_hash": "dc256c3ef73cc88bdf4147126fce4e7741a58b055845da928c2af34275c7a39b"}, "url": "/docs/compare/?release=12.20#12.20-70f7ce9b1c2e7f24", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-cf6b64ca49024d5e", "cves": [], "html": "<p>当排队的 <code>AFTER</code> 触发器不再存在时不抛出错误（Tom Lane）<a href=\"https://postgr.es/c/4f1966676\">§</a></p>\n<p>事务可能会执行一个操作将延迟的 <code>AFTER</code> 触发器排队等待后续执行，然后在触发器执行之前将其删除。之前这会导致诸如 <span>“<span>could not find trigger <em><code>NNNN</code></em></span>”</span> 之类的奇怪错误。如果触发器在应该执行的时间点已不存在，静默地不做任何操作似乎更好。</p>", "text": "当排队的 AFTER 触发器不再存在时不抛出错误（Tom Lane）§ 事务可能会执行一个操作将延迟的 AFTER 触发器排队等待后续执行，然后在触发器执行之前将其删除。之前这会导致诸如 “could not find trigger NNNN” 之类的奇怪错误。如果触发器在应该执行的时间点已不存在，静默地不做任何操作似乎更好。", "title": "当排队的 AFTER 触发器不再存在时不抛出错误", "commits": ["4f1966676"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "5607a099ffa1c182a8c47b977bc1f97e8b36c5ec347a37c0d46f282cd6ff2079", "section_path": ["变更"], "commit_groups": [["1424c7abc", "4f1966676", "88f3baa06", "9ce8ee9d3", "b0037bbef", "e6d0d16ad"]], "identity_text": "Don't throw an error if a queued AFTER trigger no longer exists (Tom Lane) It's possible for a transaction to execute an operation that queues a deferred AFTER trigger for later execution, and then to drop the trigger before that happens. Formerly this led to weird errors such as could not find trigger NNNN. It seems better to silently do nothing if the trigger no longer exists at the time when it would have been executed.", "commit_aliases": ["1424c7abc", "4f1966676", "88f3baa06", "9ce8ee9d3", "b0037bbef", "e6d0d16ad"], "source_commits": ["88f3baa06"], "source_entry_id": "14.13/changes/017", "db_id": "36042d2839a821ebd37de2eba4e16619", "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28", "relations": [{"rule": 2, "type": "equivalent", "target": "37ef6248b39fb4d3d30c9ebe7a989eb5", "evidence": {"same_day": true, "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28"}}, {"rule": 2, "type": "equivalent", "target": "98a7fb70532763a4eb4a910d1c0c139f", "evidence": {"same_day": true, "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28"}}, {"rule": 2, "type": "equivalent", "target": "b8c31e1bacd217b9917a754ecc1e065c", "evidence": {"same_day": true, "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28"}}, {"rule": 2, "type": "equivalent", "target": "f48d4eb23ab292e5214cb3a430d8abc1", "evidence": {"same_day": true, "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b8c31e1bacd217b9917a754ecc1e065c", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "当排队的 AFTER 触发器不再存在时不抛出错误", "evidence": {"same_day": true, "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28"}, "url": "/docs/compare/?release=16.4#16.4-cf6b64ca49024d5e", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "98a7fb70532763a4eb4a910d1c0c139f", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "当排队的 AFTER 触发器不再存在时不抛出错误", "evidence": {"same_day": true, "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28"}, "url": "/docs/compare/?release=15.8#15.8-cf6b64ca49024d5e", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "f48d4eb23ab292e5214cb3a430d8abc1", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "如果已排队的 AFTER 触发器不再存在，不再抛出错误", "evidence": {"same_day": true, "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28"}, "url": "/docs/compare/?release=13.16#13.16-3139e130ec3107d7", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "37ef6248b39fb4d3d30c9ebe7a989eb5", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "如果已排队的 AFTER 触发器不再存在，不再抛出错误", "evidence": {"same_day": true, "patch_ids": ["0163624b9955360a21f25509538c27d0"], "statement_hash": "5e13a5b14c0c247484a8ef9937985269176a0adf0f975a4ee23469bc33ea8f28"}, "url": "/docs/compare/?release=12.20#12.20-d53868f061f982f5", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-71b296d1b24a9a01", "cves": [], "html": "<p>修复在删除表时未能移除 <code>pg_init_privs</code> 中列级权限条目的问题（Tom Lane）<a href=\"https://postgr.es/c/9cf4beb9e\">§</a></p>\n<p>如果扩展对其创建的表授予了某些列级权限，在删除该扩展后相关的目录条目会被保留。这在表的 OID 被另一个关系重新使用之前是无害的，届时它可能会干扰 <span>pg_dump</span> 对该关系的导出。</p>", "text": "修复在删除表时未能移除 pg_init_privs 中列级权限条目的问题（Tom Lane）§ 如果扩展对其创建的表授予了某些列级权限，在删除该扩展后相关的目录条目会被保留。这在表的 OID 被另一个关系重新使用之前是无害的，届时它可能会干扰 pg_dump 对该关系的导出。", "title": "修复在删除表时未能移除 pg_init_privs 中列级权限条目的问题", "commits": ["9cf4beb9e"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "4781729e6a400b5c2df7a5911d06912f74f1182c0575cad780bf6f8cfd41f275", "section_path": ["变更"], "commit_groups": [["0a39343ae", "198de7961", "1f1eedd3f", "76618097a", "9cf4beb9e", "f3f6a14ce"]], "identity_text": "Fix failure to remove pg_init_privs entries for column-level privileges when their table is dropped (Tom Lane) If an extension grants some column-level privileges on a table it creates, relevant catalog entries would remain behind after the extension is dropped. This was harmless until/unless the table's OID was re-used for another relation, when it could interfere with what pg_dump dumps for that relation.", "commit_aliases": ["0a39343ae", "198de7961", "1f1eedd3f", "76618097a", "9cf4beb9e", "f3f6a14ce"], "source_commits": ["f3f6a14ce"], "source_entry_id": "14.13/changes/018", "db_id": "6470611c068664c3130f11eb3f99f02c", "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc", "relations": [{"rule": 2, "type": "equivalent", "target": "3b780ebf464f9927f01b5c4d3ea76668", "evidence": {"same_day": true, "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc"}}, {"rule": 2, "type": "equivalent", "target": "43cb111fec07d666a86bb5dec1743212", "evidence": {"same_day": true, "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc"}}, {"rule": 2, "type": "equivalent", "target": "6cffd4781686867264b3fd95e7b5eb36", "evidence": {"same_day": true, "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc"}}, {"rule": 2, "type": "equivalent", "target": "6d4174831ffae81637000b47a5310615", "evidence": {"same_day": true, "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "3b780ebf464f9927f01b5c4d3ea76668", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复在删除表时未能移除 pg_init_privs 中列级权限条目的问题", "evidence": {"same_day": true, "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc"}, "url": "/docs/compare/?release=16.4#16.4-71b296d1b24a9a01", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "43cb111fec07d666a86bb5dec1743212", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复在删除表时未能移除 pg_init_privs 中列级权限条目的问题", "evidence": {"same_day": true, "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc"}, "url": "/docs/compare/?release=15.8#15.8-71b296d1b24a9a01", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "6d4174831ffae81637000b47a5310615", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复在删除表时未能移除 pg_init_privs 中列级权限条目的问题", "evidence": {"same_day": true, "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc"}, "url": "/docs/compare/?release=13.16#13.16-9149e5e4e63282af", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "6cffd4781686867264b3fd95e7b5eb36", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复在删除表时未能移除 pg_init_privs 中列级权限条目的问题", "evidence": {"same_day": true, "patch_ids": ["3915e07b26b93b88feeee184d6868e91"], "statement_hash": "86a340c26d60b26bbf6be9aeacefb9f4a7b7df6e492815c39d1a3d4e3c69f8dc"}, "url": "/docs/compare/?release=12.20#12.20-ee69d178bec8044e", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-b0ddb361538ddbb1", "cves": [], "html": "<p>修复当目标索引具有表达式或谓词时 <code>ON CONFLICT</code> 仲裁索引的选择（Tom Lane）<a href=\"https://postgr.es/c/b188e1bf7\">§</a></p>\n<p>如果使用 <code>ON CONFLICT</code> 的查询通过可更新视图访问目标表，可能会失败并报告 <span>“<span>there is no unique or exclusion constraint matching the ON CONFLICT specification</span>”</span>，即使存在匹配的索引。</p>", "text": "修复当目标索引具有表达式或谓词时 ON CONFLICT 仲裁索引的选择（Tom Lane）§ 如果使用 ON CONFLICT 的查询通过可更新视图访问目标表，可能会失败并报告 “there is no unique or exclusion constraint matching the ON CONFLICT specification”，即使存在匹配的索引。", "title": "修复当目标索引具有表达式或谓词时 ON CONFLICT 仲裁索引的选择", "commits": ["b188e1bf7"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "e13d574d5cb55dcf043f47030778453092b604d5178b06c5492bfe68c6b27cda", "section_path": ["变更"], "commit_groups": [["096f2132c", "1d0399b54", "5e8aa32a9", "915de706d", "9256bf6eb", "b188e1bf7"]], "identity_text": "Fix selection of an arbiter index for ON CONFLICT when the desired index has expressions or predicates (Tom Lane) If a query using ON CONFLICT accesses the target table through an updatable view, it could fail with there is no unique or exclusion constraint matching the ON CONFLICT specification, even though a matching index does exist.", "commit_aliases": ["096f2132c", "1d0399b54", "5e8aa32a9", "915de706d", "9256bf6eb", "b188e1bf7"], "source_commits": ["096f2132c"], "source_entry_id": "14.13/changes/019", "db_id": "9e4d1efd46ecb1f9bcd50b083efc9f7e", "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266", "relations": [{"rule": 2, "type": "equivalent", "target": "2e556f7d1fc49bf3eab00fdda64129dc", "evidence": {"same_day": true, "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266"}}, {"rule": 2, "type": "equivalent", "target": "6dbe809ce6df3085b985dfd63c93f518", "evidence": {"same_day": true, "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266"}}, {"rule": 2, "type": "equivalent", "target": "9052455966f687b3285841904b12c534", "evidence": {"same_day": true, "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266"}}, {"rule": 2, "type": "equivalent", "target": "eccc12d087b0f8cfccf66b52f8642cd8", "evidence": {"same_day": true, "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6dbe809ce6df3085b985dfd63c93f518", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复当目标索引具有表达式或谓词时 ON CONFLICT 仲裁索引的选择", "evidence": {"same_day": true, "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266"}, "url": "/docs/compare/?release=16.4#16.4-b0ddb361538ddbb1", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "eccc12d087b0f8cfccf66b52f8642cd8", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复当目标索引具有表达式或谓词时 ON CONFLICT 仲裁索引的选择", "evidence": {"same_day": true, "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266"}, "url": "/docs/compare/?release=15.8#15.8-b0ddb361538ddbb1", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "9052455966f687b3285841904b12c534", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复当所需索引具有表达式或谓词时 ON CONFLICT 的仲裁索引选择", "evidence": {"same_day": true, "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266"}, "url": "/docs/compare/?release=13.16#13.16-325cfe49d641774b", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "2e556f7d1fc49bf3eab00fdda64129dc", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复当所需索引具有表达式或谓词时 ON CONFLICT 的仲裁索引选择", "evidence": {"same_day": true, "patch_ids": ["0bc97130751e42a86d19a4d553e4e7f3"], "statement_hash": "651831223905bf1579f6dc7b1718f73ec466e5d88e14d443a9c3d6c6b99c3266"}, "url": "/docs/compare/?release=12.20#12.20-fc9cb206fd807563", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-4ce7f4a9264ab505", "cves": [], "html": "<p>拒绝使用 <code>ALTER TABLE</code> 修改另一个会话的临时表（Tom Lane）<a href=\"https://postgr.es/c/8397f161e\">§</a></p>\n<p>权限检查通常会阻止此类情况发生，但可以通过修改一个其子表是另一个会话的临时表的父表来达到此情况。如果我们发现这样的子表属于另一个会话，则抛出错误。</p>", "text": "拒绝使用 ALTER TABLE 修改另一个会话的临时表（Tom Lane）§ 权限检查通常会阻止此类情况发生，但可以通过修改一个其子表是另一个会话的临时表的父表来达到此情况。如果我们发现这样的子表属于另一个会话，则抛出错误。", "title": "拒绝使用 ALTER TABLE 修改另一个会话的临时表", "commits": ["8397f161e"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "94c54fc11194f36e8937995414a20fa608209275fef4899873edc703b0265b67", "section_path": ["变更"], "commit_groups": [["2dad0f433", "3c71cb497", "7c4ac652e", "7ed8ce8a4", "8397f161e", "b8efd756d"]], "identity_text": "Refuse to modify a temporary table of another session with ALTER TABLE (Tom Lane) Permissions checks normally would prevent this case from arising, but it is possible to reach it by altering a parent table whose child is another session's temporary table. Throw an error if we discover that such a child table belongs to another session.", "commit_aliases": ["2dad0f433", "3c71cb497", "7c4ac652e", "7ed8ce8a4", "8397f161e", "b8efd756d"], "source_commits": ["2dad0f433"], "source_entry_id": "14.13/changes/020", "db_id": "8d9910ebff4ea90fbfe38b0c1910b701", "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef", "relations": [{"rule": 2, "type": "equivalent", "target": "1983b6491c0deef6767c8ea6d7285996", "evidence": {"same_day": true, "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef"}}, {"rule": 2, "type": "equivalent", "target": "41e81c1e144b80cd53840599e298e741", "evidence": {"same_day": true, "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef"}}, {"rule": 2, "type": "equivalent", "target": "4399fe2876f4be8dfecaa987d5601c8f", "evidence": {"same_day": true, "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef"}}, {"rule": 2, "type": "equivalent", "target": "51b850757ab02d17e5f509b67a427f25", "evidence": {"same_day": true, "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "41e81c1e144b80cd53840599e298e741", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "拒绝使用 ALTER TABLE 修改另一个会话的临时表", "evidence": {"same_day": true, "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef"}, "url": "/docs/compare/?release=16.4#16.4-4ce7f4a9264ab505", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "1983b6491c0deef6767c8ea6d7285996", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "拒绝使用 ALTER TABLE 修改另一个会话的临时表", "evidence": {"same_day": true, "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef"}, "url": "/docs/compare/?release=15.8#15.8-4ce7f4a9264ab505", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "51b850757ab02d17e5f509b67a427f25", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "拒绝使用 ALTER TABLE 修改另一个会话的临时表", "evidence": {"same_day": true, "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef"}, "url": "/docs/compare/?release=13.16#13.16-3c6dc30d7ef89c30", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "4399fe2876f4be8dfecaa987d5601c8f", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "拒绝使用 ALTER TABLE 修改另一个会话的临时表", "evidence": {"same_day": true, "patch_ids": ["290fcecff46eb2823aad296c96c0e2bc"], "statement_hash": "c7bd3278c5979562d90e9fab72f7830086dde53568336653325fba5a626da3ef"}, "url": "/docs/compare/?release=12.20#12.20-b0af490c299b8c0e", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-ed4fbc9f9d170f43", "cves": [], "html": "<p>修复 <code>CREATE TABLE LIKE STATISTICS</code> 中对表达式上扩展统计信息的处理（Tom Lane）<a href=\"https://postgr.es/c/2aa90c02d\">§</a></p>\n<p><code>CREATE</code> 命令未能将统计表达式中的列引用调整为新表可能不同的列编号。这会产生无效的统计对象，在后续操作中造成问题。需要重新编号列的典型场景是源表包含一些已删除的列。</p>", "text": "修复 CREATE TABLE LIKE STATISTICS 中对表达式上扩展统计信息的处理（Tom Lane）§ CREATE 命令未能将统计表达式中的列引用调整为新表可能不同的列编号。这会产生无效的统计对象，在后续操作中造成问题。需要重新编号列的典型场景是源表包含一些已删除的列。", "title": "修复 CREATE TABLE LIKE STATISTICS 中对表达式上扩展统计信息的处理", "commits": ["2aa90c02d"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "63d445fa54ce681e80bfa0d367f07fe41f3ab2b091c1326ff118a2a6b897225c", "section_path": ["变更"], "commit_groups": [["1015162c3", "2aa90c02d", "2f3cfcf76", "5278668d7"]], "identity_text": "Fix handling of extended statistics on expressions in CREATE TABLE LIKE STATISTICS (Tom Lane) The CREATE command failed to adjust column references in statistics expressions to the possibly-different column numbering of the new table. This resulted in invalid statistics objects that would cause problems later. A typical scenario where renumbering columns is needed is when the source table contains some dropped columns.", "commit_aliases": ["1015162c3", "2aa90c02d", "2f3cfcf76", "5278668d7"], "source_commits": ["1015162c3"], "source_entry_id": "14.13/changes/021", "db_id": "776851e21aa35ca46b0ba39e5b01e03a", "patch_ids": ["3769efad517992dcebedc1e7e741993c"], "statement_hash": "311c26ed7019286d6f6658b7d65784dd37ac8b8dc9ef85a341bc1179d4cceec9", "relations": [{"rule": 2, "type": "equivalent", "target": "47d0eff1df267e151f3034829a379d19", "evidence": {"same_day": true, "patch_ids": ["3769efad517992dcebedc1e7e741993c"], "statement_hash": "311c26ed7019286d6f6658b7d65784dd37ac8b8dc9ef85a341bc1179d4cceec9"}}, {"rule": 2, "type": "equivalent", "target": "cf97f7083008a790aaee1afe9c380d63", "evidence": {"same_day": true, "patch_ids": ["3769efad517992dcebedc1e7e741993c"], "statement_hash": "311c26ed7019286d6f6658b7d65784dd37ac8b8dc9ef85a341bc1179d4cceec9"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "cf97f7083008a790aaee1afe9c380d63", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复 CREATE TABLE LIKE STATISTICS 中对表达式上扩展统计信息的处理", "evidence": {"same_day": true, "patch_ids": ["3769efad517992dcebedc1e7e741993c"], "statement_hash": "311c26ed7019286d6f6658b7d65784dd37ac8b8dc9ef85a341bc1179d4cceec9"}, "url": "/docs/compare/?release=16.4#16.4-ed4fbc9f9d170f43", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "47d0eff1df267e151f3034829a379d19", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复 CREATE TABLE LIKE STATISTICS 中对表达式上扩展统计信息的处理", "evidence": {"same_day": true, "patch_ids": ["3769efad517992dcebedc1e7e741993c"], "statement_hash": "311c26ed7019286d6f6658b7d65784dd37ac8b8dc9ef85a341bc1179d4cceec9"}, "url": "/docs/compare/?release=15.8#15.8-ed4fbc9f9d170f43", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}]}, {"id": "14.13-95d803166d63086e", "cves": [], "html": "<p>修复从 <code>MIN()</code> 或 <code>MAX()</code> 聚合生成的子查询未能重新计算的问题（Tom Lane）<a href=\"https://postgr.es/c/ce0d16544\">§</a></p>\n<p>在某些情况下，在外部查询的某一行计算出的聚合结果可能会被后续行错误地重用。目前仅在外部查询使用以 hash 聚合实现的 <code>DISTINCT</code> 时观察到此问题，但可能存在其他情况。</p>", "text": "修复从 MIN() 或 MAX() 聚合生成的子查询未能重新计算的问题（Tom Lane）§ 在某些情况下，在外部查询的某一行计算出的聚合结果可能会被后续行错误地重用。目前仅在外部查询使用以 hash 聚合实现的 DISTINCT 时观察到此问题，但可能存在其他情况。", "title": "修复从 MIN() 或 MAX() 聚合生成的子查询未能重新计算的问题", "commits": ["ce0d16544"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "7a59c2242183db74b156c32419e61cbfda77d8f9a805f850774861a160b7e75a", "section_path": ["变更"], "commit_groups": [["4ac385adc", "5ac340602", "686c995fc", "779ac2c74", "7f90a5dc3", "ce0d16544"], ["d0d44049d"]], "identity_text": "Fix failure to recalculate sub-queries generated from MIN() or MAX() aggregates (Tom Lane) In some cases the aggregate result computed at one row of the outer query could be re-used for later rows when it should not be. This has only been seen to happen when the outer query uses DISTINCT that is implemented with hash aggregation, but other cases may exist.", "commit_aliases": ["4ac385adc", "5ac340602", "686c995fc", "779ac2c74", "7f90a5dc3", "ce0d16544", "d0d44049d"], "source_commits": ["5ac340602", "d0d44049d"], "source_entry_id": "14.13/changes/022", "db_id": "7227842aa76ee777f93cb314a65c0f52", "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7", "relations": [{"rule": 2, "type": "equivalent", "target": "0705db743840b66e1b587ae490755245", "evidence": {"same_day": true, "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7"}}, {"rule": 2, "type": "equivalent", "target": "0a4fec062451a66a6d2294e0d079beac", "evidence": {"same_day": true, "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7"}}, {"rule": 2, "type": "equivalent", "target": "11d64e1c0fd36a7ae3fc890515d7dad8", "evidence": {"same_day": true, "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7"}}, {"rule": 2, "type": "equivalent", "target": "7fe9fcd6e501bc3a3820eea26cb55c66", "evidence": {"same_day": true, "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "0705db743840b66e1b587ae490755245", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复从 MIN() 或 MAX() 聚合生成的子查询未能重新计算的问题", "evidence": {"same_day": true, "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7"}, "url": "/docs/compare/?release=16.4#16.4-95d803166d63086e", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "11d64e1c0fd36a7ae3fc890515d7dad8", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复从 MIN() 或 MAX() 聚合生成的子查询未能重新计算的问题", "evidence": {"same_day": true, "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7"}, "url": "/docs/compare/?release=15.8#15.8-95d803166d63086e", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "0a4fec062451a66a6d2294e0d079beac", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复从 MIN() 或 MAX() 聚合生成的子查询未能重新计算的问题", "evidence": {"same_day": true, "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7"}, "url": "/docs/compare/?release=13.16#13.16-b655fd3d8dd75b84", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "7fe9fcd6e501bc3a3820eea26cb55c66", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复从 MIN() 或 MAX() 聚合生成的子查询未能重新计算的问题", "evidence": {"same_day": true, "patch_ids": ["0c16d646655ac398dfa4ba6f881bfb82", "99d490781771c7c4b671fbe56a247d92"], "statement_hash": "4d84c9e6aede63335d920e32cb3e2fae44f82a195a0f30474f6dbcdecaf68da7"}, "url": "/docs/compare/?release=12.20#12.20-deec83722c172dc8", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-cf25ec7b08f3326c", "cves": [], "html": "<p>避免在 JIT 内联的后端函数抛出错误时崩溃（Tom Lane）<a href=\"https://postgr.es/c/07d66d3cc\">§</a></p>\n<p>错误状态可以包含指向持有 JIT 编译代码的动态加载模块的指针（用于错误位置字符串）。在某些代码路径中，模块可能在错误报告被处理之前被卸载，导致访问位置字符串时出现 SIGSEGV。</p>", "text": "避免在 JIT 内联的后端函数抛出错误时崩溃（Tom Lane）§ 错误状态可以包含指向持有 JIT 编译代码的动态加载模块的指针（用于错误位置字符串）。在某些代码路径中，模块可能在错误报告被处理之前被卸载，导致访问位置字符串时出现 SIGSEGV。", "title": "避免在 JIT 内联的后端函数抛出错误时崩溃", "commits": ["07d66d3cc"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "94982f3f32ab420464839d9c57bc41d1ef6e232ee9feb25c1a71c8155302eceb", "section_path": ["变更"], "commit_groups": [["07d66d3cc", "13abc1f66", "5401e70e4", "5d6c64d29", "86fac88ee", "dccda847b"]], "identity_text": "Avoid crashing when a JIT-inlined backend function throws an error (Tom Lane) The error state can include pointers into the dynamically loaded module holding the JIT-compiled code (for error location strings). In some code paths the module could get unloaded before the error report is processed, leading to SIGSEGV when the location strings are accessed.", "commit_aliases": ["07d66d3cc", "13abc1f66", "5401e70e4", "5d6c64d29", "86fac88ee", "dccda847b"], "source_commits": ["13abc1f66"], "source_entry_id": "14.13/changes/023", "db_id": "8cb79c4f08d8cb77f9647cdad2d34c19", "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2", "relations": [{"rule": 2, "type": "equivalent", "target": "56a4362bbbb6ba3736c130cfa08a59fe", "evidence": {"same_day": true, "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2"}}, {"rule": 2, "type": "equivalent", "target": "817329cfdffc2f7cc4012498db50e000", "evidence": {"same_day": true, "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2"}}, {"rule": 2, "type": "equivalent", "target": "84f5d4026e74111c68b10db90271bba5", "evidence": {"same_day": true, "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2"}}, {"rule": 2, "type": "equivalent", "target": "ae9906a0f31ecf76e1ea31a6f249d747", "evidence": {"same_day": true, "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "84f5d4026e74111c68b10db90271bba5", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "避免在 JIT 内联的后端函数抛出错误时崩溃", "evidence": {"same_day": true, "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2"}, "url": "/docs/compare/?release=16.4#16.4-cf25ec7b08f3326c", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "ae9906a0f31ecf76e1ea31a6f249d747", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "避免在 JIT 内联的后端函数抛出错误时崩溃", "evidence": {"same_day": true, "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2"}, "url": "/docs/compare/?release=15.8#15.8-cf25ec7b08f3326c", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "56a4362bbbb6ba3736c130cfa08a59fe", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "避免在 JIT 内联的后端函数抛出错误时崩溃", "evidence": {"same_day": true, "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2"}, "url": "/docs/compare/?release=13.16#13.16-1d7af98af834d1ea", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "817329cfdffc2f7cc4012498db50e000", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "避免在 JIT 内联的后端函数抛出错误时崩溃", "evidence": {"same_day": true, "patch_ids": ["8061f5a02c1df9d8d56b8123b8cd1591"], "statement_hash": "4620561b314b0e9436b5ad7e019d59c9631e86d23581531f97bc29873df333d2"}, "url": "/docs/compare/?release=12.20#12.20-2fcfb368f059849b", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-b9535a14f6b36dcb", "cves": [], "html": "<p>应对 <span>libxml2</span> 版本 2.13.x 中的行为变更（Erik Wienhold，Tom Lane）<a href=\"https://postgr.es/c/475e1807c\">§</a></p>\n<p>值得注意的是，我们现在会抑制来自 <span>libxml2</span> 的 <span>“<span>chunk is not well balanced</span>”</span> 错误，除非这是唯一报告的错误。这是为了使 2.13.x 和更早版本的 <span>libxml2</span> 之间的错误报告保持一致。在更早的版本中，该消息几乎总是冗余的或完全不正确的，因此 2.13.x 大幅减少了报告该消息的情况。</p>", "text": "应对 libxml2 版本 2.13.x 中的行为变更（Erik Wienhold，Tom Lane）§ 值得注意的是，我们现在会抑制来自 libxml2 的 “chunk is not well balanced” 错误，除非这是唯一报告的错误。这是为了使 2.13.x 和更早版本的 libxml2 之间的错误报告保持一致。在更早的版本中，该消息几乎总是冗余的或完全不正确的，因此 2.13.x 大幅减少了报告该消息的情况。", "title": "应对 libxml2 版本 2.13.x 中的行为变更", "commits": ["475e1807c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "f42bc7b8d7ff8286a19acc4026b33372894afc5bde971caf9a97ae2f92515b2e", "section_path": ["变更"], "commit_groups": [["066e8ac6e"], ["475e1807c", "48132587d", "896cd266f", "a134baea7", "a9747be27", "f68d6aabb", "f85c91a18"], ["6082b3d5d"], ["e7192486d"]], "identity_text": "Cope with behavioral changes in libxml2 version 2.13.x (Erik Wienhold, Tom Lane) Notably, we now suppress chunk is not well balanced errors from libxml2, unless that is the only reported error. This is to make error reports consistent between 2.13.x and earlier libxml2 versions. In earlier versions, that message was almost always redundant or outright incorrect, so 2.13.x substantially reduced the number of cases in which it's reported.", "commit_aliases": ["066e8ac6e", "475e1807c", "48132587d", "6082b3d5d", "896cd266f", "a134baea7", "a9747be27", "e7192486d", "f68d6aabb", "f85c91a18"], "source_commits": ["066e8ac6e", "475e1807c", "6082b3d5d", "e7192486d"], "source_entry_id": "14.13/changes/024", "db_id": "7795621993aa544ecd06ce727c6e8456", "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4", "relations": [{"rule": 2, "type": "equivalent", "target": "79a9fe0e7ac2f3dd9d113a8e5b3adbec", "evidence": {"same_day": true, "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4"}}, {"rule": 2, "type": "equivalent", "target": "96975460aa783512c152bc9b6c50458a", "evidence": {"same_day": true, "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4"}}, {"rule": 2, "type": "equivalent", "target": "bf592a68c6f6698e8fc5f939ede6c4d8", "evidence": {"same_day": true, "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4"}}, {"rule": 2, "type": "equivalent", "target": "c3e1d68dd0b143d0dc9b120907c4b606", "evidence": {"same_day": true, "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "79a9fe0e7ac2f3dd9d113a8e5b3adbec", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "应对 libxml2 版本 2.13.x 中的行为变更", "evidence": {"same_day": true, "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4"}, "url": "/docs/compare/?release=16.4#16.4-c19f65f66efb16cb", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "bf592a68c6f6698e8fc5f939ede6c4d8", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "应对 libxml2 版本 2.13.x 中的行为变更", "evidence": {"same_day": true, "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4"}, "url": "/docs/compare/?release=15.8#15.8-1e092af3f3653c6a", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "c3e1d68dd0b143d0dc9b120907c4b606", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "应对 libxml2 版本 2.13.x 中的行为变更", "evidence": {"same_day": true, "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4"}, "url": "/docs/compare/?release=13.16#13.16-44e5561a5e303592", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "96975460aa783512c152bc9b6c50458a", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "应对 libxml2 版本 2.13.x 中的行为变更", "evidence": {"same_day": true, "patch_ids": ["37c99d6b681d2052b6bf7d426058c9e4", "629aacf9d5e1df138d1c49c2a315d4e7", "d750da5a021aaa9bc4bd42d5d3dc1844", "f188736123ed999044a6d34c7d1d446b"], "statement_hash": "3d910b586cd43953b42f9e34ce07a33cab8107a0d34d01f35c704a1ee64abed4"}, "url": "/docs/compare/?release=12.20#12.20-da101a6623b90355", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-73a2e8a89c943342", "cves": [], "html": "<p>修复启动热备服务器时预备事务的子事务处理（Heikki Linnakangas）<a href=\"https://postgr.es/c/b5b418b68\">§</a></p>\n<p>当备库在关机检查点 WAL 记录处开始回放时，在主库上已预备但尚未提交的事务会被正确地理解为仍在进行中。但预备事务的子事务（由保存点或 <span>PL/pgSQL</span> 异常块创建）未被考虑，会被当作已中止的事务处理。如果预备事务随后被提交，就会导致不一致。</p>", "text": "修复启动热备服务器时预备事务的子事务处理（Heikki Linnakangas）§ 当备库在关机检查点 WAL 记录处开始回放时，在主库上已预备但尚未提交的事务会被正确地理解为仍在进行中。但预备事务的子事务（由保存点或 PL/pgSQL 异常块创建）未被考虑，会被当作已中止的事务处理。如果预备事务随后被提交，就会导致不一致。", "title": "修复启动热备服务器时预备事务的子事务处理", "commits": ["b5b418b68"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "a8779f1d62ddc6029534ee9f4e7033a463693f39a3d5e2b61560d9c2c4ea65e6", "section_path": ["变更"], "commit_groups": [["0e2f3d78b", "5dea6628b", "9dbf8ab48", "b5b418b68", "cbfbda784", "e9c8747ee"]], "identity_text": "Fix handling of subtransactions of prepared transactions when starting a hot standby server (Heikki Linnakangas) When starting a standby's replay at a shutdown checkpoint WAL record, transactions that had been prepared but not yet committed on the primary are correctly understood as being still in progress. But subtransactions of a prepared transaction (created by savepoints or PL/pgSQL exception blocks) were not accounted for and would be treated as aborted. That led to inconsistency if the prepared transaction was later committed.", "commit_aliases": ["0e2f3d78b", "5dea6628b", "9dbf8ab48", "b5b418b68", "cbfbda784", "e9c8747ee"], "source_commits": ["9dbf8ab48"], "source_entry_id": "14.13/changes/025", "db_id": "1d5c68552426f7a688acc9f556a5208b", "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a", "relations": [{"rule": 2, "type": "equivalent", "target": "66029534417861b20daa965c467fda63", "evidence": {"same_day": true, "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a"}}, {"rule": 2, "type": "equivalent", "target": "75f7406ca226a47dd96f203cdf0bdfda", "evidence": {"same_day": true, "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a"}}, {"rule": 2, "type": "equivalent", "target": "c820f7d1b7ff7adafc564e87d0542403", "evidence": {"same_day": true, "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a"}}, {"rule": 2, "type": "equivalent", "target": "f74676068a4dc67b60724d6dd3992bf1", "evidence": {"same_day": true, "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "66029534417861b20daa965c467fda63", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复启动热备服务器时预备事务的子事务处理", "evidence": {"same_day": true, "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a"}, "url": "/docs/compare/?release=16.4#16.4-73a2e8a89c943342", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "75f7406ca226a47dd96f203cdf0bdfda", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复启动热备服务器时预备事务的子事务处理", "evidence": {"same_day": true, "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a"}, "url": "/docs/compare/?release=15.8#15.8-73a2e8a89c943342", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "c820f7d1b7ff7adafc564e87d0542403", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复启动热备服务器时对预备事务的子事务的处理", "evidence": {"same_day": true, "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a"}, "url": "/docs/compare/?release=13.16#13.16-7686fdd2208f0c06", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "f74676068a4dc67b60724d6dd3992bf1", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复启动热备服务器时对预备事务的子事务的处理", "evidence": {"same_day": true, "patch_ids": ["903d1e081712f6e493da35eca18db280"], "statement_hash": "4ced749c9db1f39b7fea3a9d281066cc68e29a4bca7241300775834bca86f96a"}, "url": "/docs/compare/?release=12.20#12.20-20ea6a9b42ed23b7", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-79627f65d44ef772", "cves": [], "html": "<p>防止逻辑复制槽的不正确初始化（Masahiko Sawada）<a href=\"https://postgr.es/c/f7d3caf9d\">§</a></p>\n<p>在某些情况下，复制槽在 WAL 流中的起始点可能被设置为事务内部的某个位置，导致断言失败或不正确的解码结果。</p>", "text": "防止逻辑复制槽的不正确初始化（Masahiko Sawada）§ 在某些情况下，复制槽在 WAL 流中的起始点可能被设置为事务内部的某个位置，导致断言失败或不正确的解码结果。", "title": "防止逻辑复制槽的不正确初始化", "commits": ["f7d3caf9d"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "9bf3966fe312a47ea386232a06d8557cbbc7e27344d13014b66589d306921706", "section_path": ["变更"], "commit_groups": [["068674f4a", "1b3707587", "2f3304ce1", "aee8c2b95", "bb19b7008", "cf2c69ec5", "f7d3caf9d"]], "identity_text": "Prevent incorrect initialization of logical replication slots (Masahiko Sawada) In some cases a replication slot's start point within the WAL stream could be set to a point within a transaction, leading to assertion failures or incorrect decoding results.", "commit_aliases": ["068674f4a", "1b3707587", "2f3304ce1", "aee8c2b95", "bb19b7008", "cf2c69ec5", "f7d3caf9d"], "source_commits": ["f7d3caf9d"], "source_entry_id": "14.13/changes/026", "db_id": "a485385219574a54e8cd60590e215b20", "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63", "relations": [{"rule": 2, "type": "equivalent", "target": "1b83b73cb3b34c621ddf372d0362d666", "evidence": {"same_day": true, "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63"}}, {"rule": 2, "type": "equivalent", "target": "577d72d84ee2053d34fdebe2a7268652", "evidence": {"same_day": true, "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63"}}, {"rule": 2, "type": "equivalent", "target": "6d1402ce75d70fbfffa9e27f6e30467a", "evidence": {"same_day": true, "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63"}}, {"rule": 2, "type": "equivalent", "target": "a7610af2b7076c774c0f90b7d4ec731d", "evidence": {"same_day": true, "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1b83b73cb3b34c621ddf372d0362d666", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "防止逻辑复制槽的不正确初始化", "evidence": {"same_day": true, "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63"}, "url": "/docs/compare/?release=16.4#16.4-5c61539b7017d233", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "577d72d84ee2053d34fdebe2a7268652", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "防止逻辑复制槽的不正确初始化", "evidence": {"same_day": true, "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63"}, "url": "/docs/compare/?release=15.8#15.8-c45871b8ab1273c8", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "a7610af2b7076c774c0f90b7d4ec731d", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "防止逻辑复制槽的不正确初始化", "evidence": {"same_day": true, "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63"}, "url": "/docs/compare/?release=13.16#13.16-6db5ada335322286", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "6d1402ce75d70fbfffa9e27f6e30467a", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "防止逻辑复制槽的不正确初始化", "evidence": {"same_day": true, "patch_ids": ["f3ca5487898826c4944a699390deb5b8"], "statement_hash": "f583445c1c110ee7e89fc67e88734921b46c4f1599c090833ba65c220e030d63"}, "url": "/docs/compare/?release=12.20#12.20-03734ff88ecf36c8", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-ed1321b1f9f5d847", "cves": [], "html": "<p>避免在处理通知或共享失效中断后的内存泄漏（Tom Lane）<a href=\"https://postgr.es/c/54a7b21b3\">§</a></p>\n<p>这些事件的处理函数可能将当前内存上下文切换到 TopMemoryContext，导致在错误设置被替换之前分配的任何数据出现会话级别的泄漏。至少在传入查询的编码转换和附加到 Bind 消息的参数方面存在可观察到的泄漏。</p>", "text": "避免在处理通知或共享失效中断后的内存泄漏（Tom Lane）§ 这些事件的处理函数可能将当前内存上下文切换到 TopMemoryContext，导致在错误设置被替换之前分配的任何数据出现会话级别的泄漏。至少在传入查询的编码转换和附加到 Bind 消息的参数方面存在可观察到的泄漏。", "title": "避免在处理通知或共享失效中断后的内存泄漏", "commits": ["54a7b21b3"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "abdfb386ebb5cdefc1a5470f12f06009a319ce1807cadd38ddb2d690ffcd75fe", "section_path": ["变更"], "commit_groups": [["1608902fc", "31f8d620b", "4df767cf9", "54a7b21b3", "5f86cd70d", "8565fb6fb"]], "identity_text": "Avoid memory leakage after servicing a notify or sinval interrupt (Tom Lane) The processing functions for these events could switch the current memory context to TopMemoryContext, resulting in session-lifespan leakage of any data allocated before the incorrect setting gets replaced. There were observable leaks associated with (at least) encoding conversion of incoming queries and parameters attached to Bind messages.", "commit_aliases": ["1608902fc", "31f8d620b", "4df767cf9", "54a7b21b3", "5f86cd70d", "8565fb6fb"], "source_commits": ["1608902fc"], "source_entry_id": "14.13/changes/027", "db_id": "b3d22673cb20177c186729255869c9ea", "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71", "relations": [{"rule": 2, "type": "equivalent", "target": "0d82cb37c9a335dee35c3994766f2182", "evidence": {"same_day": true, "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71"}}, {"rule": 2, "type": "equivalent", "target": "608955e3fac97af439211180d82e2a9c", "evidence": {"same_day": true, "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71"}}, {"rule": 2, "type": "equivalent", "target": "6da29c6f62742014a2e29d1835a92337", "evidence": {"same_day": true, "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71"}}, {"rule": 2, "type": "equivalent", "target": "f8a6d2763491f62e2962b747215a53f7", "evidence": {"same_day": true, "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "0d82cb37c9a335dee35c3994766f2182", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "避免在处理通知或共享失效中断后的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71"}, "url": "/docs/compare/?release=16.4#16.4-ed1321b1f9f5d847", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "6da29c6f62742014a2e29d1835a92337", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "避免在处理通知或共享失效中断后的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71"}, "url": "/docs/compare/?release=15.8#15.8-ed1321b1f9f5d847", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "f8a6d2763491f62e2962b747215a53f7", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "避免在处理通知或共享失效中断后的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71"}, "url": "/docs/compare/?release=13.16#13.16-c5b9f0e6f10164e5", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "608955e3fac97af439211180d82e2a9c", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "避免在处理通知或共享失效中断后的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["e4b4c6857b69435f7041aa9717bc32ec"], "statement_hash": "246286e429b9f02767e1bf510975230828149e3a9b45b4541c80efbf7402be71"}, "url": "/docs/compare/?release=12.20#12.20-bcb2f288e96fb567", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-4ee92f82f43c7ff0", "cves": [], "html": "<p>防止在截断多事务 SLRU 日志时出现死锁和断言失败（Heikki Linnakangas）<a href=\"https://postgr.es/c/e7cbe5a85\">§</a></p>\n<p>尝试删除 SLRU 段的进程可能与检查点进程发生死锁。</p>", "text": "防止在截断多事务 SLRU 日志时出现死锁和断言失败（Heikki Linnakangas）§ 尝试删除 SLRU 段的进程可能与检查点进程发生死锁。", "title": "防止在截断多事务 SLRU 日志时出现死锁和断言失败", "commits": ["e7cbe5a85"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "91d45e7507e073cd592f5d824f8d033e17311de857166792d9298ae8faa69898", "section_path": ["变更"], "commit_groups": [["4c8e00ae9", "b1ffe3ff0", "c809a2b2d", "e7cbe5a85"]], "identity_text": "Prevent deadlocks and assertion failures during truncation of the multixact SLRU log (Heikki Linnakangas) A process trying to delete SLRU segments could deadlock with the checkpointer process.", "commit_aliases": ["4c8e00ae9", "b1ffe3ff0", "c809a2b2d", "e7cbe5a85"], "source_commits": ["4c8e00ae9"], "source_entry_id": "14.13/changes/028", "db_id": "f65af754adc39c0eb08c79f3656e5cbd", "patch_ids": ["584dbfb3f02d0227e45d3a9e9594ed32"], "statement_hash": "5705bd6fa004c0c0f497d57bb9a81504fdf85ce36f4292b6bf1a1325a7440b28", "relations": [{"rule": 2, "type": "equivalent", "target": "282d739b649051dd97bb9ecee1e10290", "evidence": {"same_day": true, "patch_ids": ["584dbfb3f02d0227e45d3a9e9594ed32"], "statement_hash": "5705bd6fa004c0c0f497d57bb9a81504fdf85ce36f4292b6bf1a1325a7440b28"}}, {"rule": 2, "type": "equivalent", "target": "c7a02a751b0a96aaf92740d4a1c93e12", "evidence": {"same_day": true, "patch_ids": ["584dbfb3f02d0227e45d3a9e9594ed32"], "statement_hash": "5705bd6fa004c0c0f497d57bb9a81504fdf85ce36f4292b6bf1a1325a7440b28"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c7a02a751b0a96aaf92740d4a1c93e12", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "防止在截断多事务 SLRU 日志时出现死锁和断言失败", "evidence": {"same_day": true, "patch_ids": ["584dbfb3f02d0227e45d3a9e9594ed32"], "statement_hash": "5705bd6fa004c0c0f497d57bb9a81504fdf85ce36f4292b6bf1a1325a7440b28"}, "url": "/docs/compare/?release=16.4#16.4-4ee92f82f43c7ff0", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "282d739b649051dd97bb9ecee1e10290", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "防止在截断多事务 SLRU 日志时出现死锁和断言失败", "evidence": {"same_day": true, "patch_ids": ["584dbfb3f02d0227e45d3a9e9594ed32"], "statement_hash": "5705bd6fa004c0c0f497d57bb9a81504fdf85ce36f4292b6bf1a1325a7440b28"}, "url": "/docs/compare/?release=15.8#15.8-4ee92f82f43c7ff0", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}]}, {"id": "14.13-ec3cbb1503e4a76e", "cves": [], "html": "<p>避免在 Windows 套接字上可能遗漏输入结束事件（Thomas Munro）<a href=\"https://postgr.es/c/894b497ac\">§</a></p>\n<p>Windows 在连接的远程端断开连接后只报告一次 FD_CLOSE 事件。在时机不巧的情况下，我们可能会遗漏该报告并无限期等待，或者至少等到超时为止，以期望获得更多输入。</p>", "text": "避免在 Windows 套接字上可能遗漏输入结束事件（Thomas Munro）§ Windows 在连接的远程端断开连接后只报告一次 FD_CLOSE 事件。在时机不巧的情况下，我们可能会遗漏该报告并无限期等待，或者至少等到超时为止，以期望获得更多输入。", "title": "避免在 Windows 套接字上可能遗漏输入结束事件", "commits": ["894b497ac"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "3517a414a0e9fafd74b0d9ae6be7b81f560ceaafaabe55719337f0dab93bd566", "section_path": ["变更"], "commit_groups": [["3554d841d", "3c1c82d40", "5546a834c", "894b497ac", "a622095bc", "a8458f508", "ba9fcac72"]], "identity_text": "Avoid possibly missing end-of-input events on Windows sockets (Thomas Munro) Windows reports an FD_CLOSE event only once after the remote end of the connection disconnects. With unlucky timing, we could miss that report and wait indefinitely, or at least until a timeout elapsed, expecting more input.", "commit_aliases": ["3554d841d", "3c1c82d40", "5546a834c", "894b497ac", "a622095bc", "a8458f508", "ba9fcac72"], "source_commits": ["894b497ac"], "source_entry_id": "14.13/changes/029", "db_id": "c978c16fdf2c365a1726b07afe1617f4", "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc", "relations": [{"rule": 2, "type": "equivalent", "target": "1631ed6f9c1e941ab12ffb28bee4372c", "evidence": {"same_day": true, "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc"}}, {"rule": 2, "type": "equivalent", "target": "17f3eefd22838bedf5d5ef66df9b1623", "evidence": {"same_day": true, "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc"}}, {"rule": 2, "type": "equivalent", "target": "2bbe9ff4d5498518bac0b7f203b15a2c", "evidence": {"same_day": true, "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc"}}, {"rule": 2, "type": "equivalent", "target": "6ea031a6085a757f0a918a983b8f18f2", "evidence": {"same_day": true, "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "17f3eefd22838bedf5d5ef66df9b1623", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "避免在 Windows 套接字上可能遗漏输入结束事件", "evidence": {"same_day": true, "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc"}, "url": "/docs/compare/?release=16.4#16.4-ec3cbb1503e4a76e", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "1631ed6f9c1e941ab12ffb28bee4372c", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "避免在 Windows 套接字上可能遗漏输入结束事件", "evidence": {"same_day": true, "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc"}, "url": "/docs/compare/?release=15.8#15.8-17a0e388359911d9", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "6ea031a6085a757f0a918a983b8f18f2", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "避免在 Windows 套接字上可能遗漏输入结束事件", "evidence": {"same_day": true, "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc"}, "url": "/docs/compare/?release=13.16#13.16-3b05d07fa0ce2e38", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "2bbe9ff4d5498518bac0b7f203b15a2c", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "避免在 Windows 套接字上可能遗漏输入结束事件", "evidence": {"same_day": true, "patch_ids": ["7aeed61fe835cd363dc1c4bd14c5c247"], "statement_hash": "90d25bbc5a5ea45ff4902ba054df6e236b0841319a0301a67217e6fa05628bdc"}, "url": "/docs/compare/?release=12.20#12.20-0a1cc36995561f35", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-252a69852fa2e4f7", "cves": [], "html": "<p>修复 JSON 解析错误报告中针对不完整字节序列的缓冲区越界读取（Jacob Champion）<a href=\"https://postgr.es/c/5396a2987\">§</a></p>\n<p>当最后的字节构成不完整的多字节字符时，可能会在输入缓冲区末尾越界读取几个字节。虽然通常无害，但原则上这可能导致崩溃。</p>", "text": "修复 JSON 解析错误报告中针对不完整字节序列的缓冲区越界读取（Jacob Champion）§ 当最后的字节构成不完整的多字节字符时，可能会在输入缓冲区末尾越界读取几个字节。虽然通常无害，但原则上这可能导致崩溃。", "title": "修复 JSON 解析错误报告中针对不完整字节序列的缓冲区越界读取", "commits": ["5396a2987"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "26b65f92ccfcabfea9cb62081fab5b5cc9a5cbca2ede836c4deac97a7b07be94", "section_path": ["变更"], "commit_groups": [["377c25d32", "41adf9d96", "5396a2987", "855517307", "8c3f30e67"]], "identity_text": "Fix buffer overread in JSON parse error reports for incomplete byte sequences (Jacob Champion) It was possible to walk off the end of the input buffer by a few bytes when the last bytes comprise an incomplete multi-byte character. While usually harmless, in principle this could cause a crash.", "commit_aliases": ["377c25d32", "41adf9d96", "5396a2987", "855517307", "8c3f30e67"], "source_commits": ["41adf9d96"], "source_entry_id": "14.13/changes/030", "db_id": "cc92c8dd978f1ed057eec472075c0818", "patch_ids": ["a7244d7fc4b5d6f2a1c109b8a35b7fea"], "statement_hash": "fd4d0c5daa06ce9e80c94184b0e66acd500184a9c5f1db4a0fd6784d53f886e0", "relations": [{"rule": 2, "type": "equivalent", "target": "23854c849e1d777b51e2f6dae926b846", "evidence": {"same_day": true, "patch_ids": ["a7244d7fc4b5d6f2a1c109b8a35b7fea"], "statement_hash": "fd4d0c5daa06ce9e80c94184b0e66acd500184a9c5f1db4a0fd6784d53f886e0"}}, {"rule": 2, "type": "equivalent", "target": "baf9c178c2a73906f3f9ae61c06e9ac5", "evidence": {"same_day": true, "patch_ids": ["a7244d7fc4b5d6f2a1c109b8a35b7fea"], "statement_hash": "fd4d0c5daa06ce9e80c94184b0e66acd500184a9c5f1db4a0fd6784d53f886e0"}}, {"rule": 2, "type": "equivalent", "target": "fc6e1671ca7917b75dd761a0d1500447", "evidence": {"same_day": true, "patch_ids": ["a7244d7fc4b5d6f2a1c109b8a35b7fea"], "statement_hash": "fd4d0c5daa06ce9e80c94184b0e66acd500184a9c5f1db4a0fd6784d53f886e0"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "baf9c178c2a73906f3f9ae61c06e9ac5", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复 JSON 解析错误报告中针对不完整字节序列的缓冲区越界读取", "evidence": {"same_day": true, "patch_ids": ["a7244d7fc4b5d6f2a1c109b8a35b7fea"], "statement_hash": "fd4d0c5daa06ce9e80c94184b0e66acd500184a9c5f1db4a0fd6784d53f886e0"}, "url": "/docs/compare/?release=16.4#16.4-252a69852fa2e4f7", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "23854c849e1d777b51e2f6dae926b846", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复 JSON 解析错误报告中针对不完整字节序列的缓冲区越界读取", "evidence": {"same_day": true, "patch_ids": ["a7244d7fc4b5d6f2a1c109b8a35b7fea"], "statement_hash": "fd4d0c5daa06ce9e80c94184b0e66acd500184a9c5f1db4a0fd6784d53f886e0"}, "url": "/docs/compare/?release=15.8#15.8-252a69852fa2e4f7", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "fc6e1671ca7917b75dd761a0d1500447", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复 JSON 解析错误报告中对不完整字节序列的缓冲区越界读取", "evidence": {"same_day": true, "patch_ids": ["a7244d7fc4b5d6f2a1c109b8a35b7fea"], "statement_hash": "fd4d0c5daa06ce9e80c94184b0e66acd500184a9c5f1db4a0fd6784d53f886e0"}, "url": "/docs/compare/?release=13.16#13.16-4f6d40ffabeb6c24", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}]}, {"id": "14.13-b6064f46843afdea", "cves": [], "html": "<p>禁用 OpenSSL 创建有状态 TLS 会话票证（Daniel Gustafsson）<a href=\"https://postgr.es/c/ecbb1cd9b\">§</a> <a href=\"https://postgr.es/c/51c1b4fd1\">§</a> <a href=\"https://postgr.es/c/ddd66a629\">§</a></p>\n<p>这可以避免客户端在收到会话票证后认为支持 TLS 会话恢复时可能出现的失败。</p>", "text": "禁用 OpenSSL 创建有状态 TLS 会话票证（Daniel Gustafsson）§ § § 这可以避免客户端在收到会话票证后认为支持 TLS 会话恢复时可能出现的失败。", "title": "禁用 OpenSSL 创建有状态 TLS 会话票证", "commits": ["51c1b4fd1", "ddd66a629", "ecbb1cd9b"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "52a0e493c955fb09c071771e90ed3d38174c36a8724c1ae97d82030987485697", "section_path": ["变更"], "commit_groups": [["118ec331b", "1f476bc75", "274bbced8", "32121c077", "3df7f44a8", "cc606afce", "ecbb1cd9b"], ["1272cfb72", "161c73462", "40e8ea949", "51c1b4fd1", "83b4a6358", "970cd5c62", "ac77add23"], ["441eba34d", "634710dfb", "ce3045e9b", "ddd66a629", "e6dd0b863"]], "identity_text": "Disable creation of stateful TLS session tickets by OpenSSL (Daniel Gustafsson) This avoids possible failures with clients that think receipt of a session ticket means that TLS session resumption is supported.", "commit_aliases": ["118ec331b", "1272cfb72", "161c73462", "1f476bc75", "274bbced8", "32121c077", "3df7f44a8", "40e8ea949", "441eba34d", "51c1b4fd1", "634710dfb", "83b4a6358", "970cd5c62", "ac77add23", "cc606afce", "ce3045e9b", "ddd66a629", "e6dd0b863", "ecbb1cd9b"], "source_commits": ["51c1b4fd1", "ddd66a629", "ecbb1cd9b"], "source_entry_id": "14.13/changes/031", "db_id": "e7b94d5630ba3142acc49921b812f60c", "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e", "relations": [{"rule": 2, "type": "equivalent", "target": "289993beea6a36a80de8e58b0c66ff65", "evidence": {"same_day": true, "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e"}}, {"rule": 2, "type": "equivalent", "target": "78d53f7d1b802fb85289b82f39e03821", "evidence": {"same_day": true, "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e"}}, {"rule": 2, "type": "equivalent", "target": "e636de8c8d8acaa78228011fc6c79b89", "evidence": {"same_day": true, "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e"}}, {"rule": 2, "type": "equivalent", "target": "ed9bd1366a78186d49bfeacb065309c8", "evidence": {"same_day": true, "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "78d53f7d1b802fb85289b82f39e03821", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "禁用 OpenSSL 创建有状态 TLS 会话票证", "evidence": {"same_day": true, "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e"}, "url": "/docs/compare/?release=16.4#16.4-fe85acc49637b05e", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "e636de8c8d8acaa78228011fc6c79b89", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "禁用 OpenSSL 创建有状态 TLS 会话票证", "evidence": {"same_day": true, "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e"}, "url": "/docs/compare/?release=15.8#15.8-016fbab259cebf18", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "ed9bd1366a78186d49bfeacb065309c8", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "禁用 OpenSSL 创建有状态 TLS 会话票证", "evidence": {"same_day": true, "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e"}, "url": "/docs/compare/?release=13.16#13.16-b8bee8a57fe93f1a", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "289993beea6a36a80de8e58b0c66ff65", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "禁用 OpenSSL 创建有状态 TLS 会话票证", "evidence": {"same_day": true, "patch_ids": ["1fee5702bfe4aed8b6eaccd06d985141", "8a5aeb1a85aed65823f76d18f63669df", "d59cdf2fd7aa799d5b080bd087388acd"], "statement_hash": "6eb0f228fc4188de980b5c10a810a580b9aa8703efc7b559672965dc17b4349e"}, "url": "/docs/compare/?release=12.20#12.20-c3bb502dd7c1cb3b", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-2258d3d478905208", "cves": [], "html": "<p>在重新规划 <span>PL/pgSQL</span> <span>“<span>简单表达式</span>”</span>时，检查其是否仍然是简单的（Tom Lane）<a href=\"https://postgr.es/c/82a931d3d\">§</a></p>\n<p>某些相当人工的情况，如删除一个被引用的函数并将其重新创建为聚合函数，可能导致诸如 <span>“<span>unexpected plan node type</span>”</span> 之类的意外失败。</p>", "text": "在重新规划 PL/pgSQL “简单表达式”时，检查其是否仍然是简单的（Tom Lane）§ 某些相当人工的情况，如删除一个被引用的函数并将其重新创建为聚合函数，可能导致诸如 “unexpected plan node type” 之类的意外失败。", "title": "在重新规划 PL/pgSQL “简单表达式”时，检查其是否仍然是简单的", "commits": ["82a931d3d"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "0ca892b53ccad03d729f9fccb6291a5a32df2a950c3e979dffb2b4fd50cc65cc", "section_path": ["变更"], "commit_groups": [["1450db793", "1fa46dba5", "6dfac2440", "82a931d3d", "bf552b1b2", "ec210914c"]], "identity_text": "When replanning a PL/pgSQL simple expression, check it's still simple (Tom Lane) Certain fairly-artificial cases, such as dropping a referenced function and recreating it as an aggregate, could lead to surprising failures such as unexpected plan node type.", "commit_aliases": ["1450db793", "1fa46dba5", "6dfac2440", "82a931d3d", "bf552b1b2", "ec210914c"], "source_commits": ["1450db793"], "source_entry_id": "14.13/changes/032", "db_id": "56555c6e717af3afa6caa44114656f30", "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40", "relations": [{"rule": 2, "type": "equivalent", "target": "127500e1083bce6f4d97d7eef49a742e", "evidence": {"same_day": true, "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40"}}, {"rule": 2, "type": "equivalent", "target": "24a3b4bda5662edaa1f1f7dfcec501e0", "evidence": {"same_day": true, "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40"}}, {"rule": 2, "type": "equivalent", "target": "45077f7207c2949591d55adc289e648e", "evidence": {"same_day": true, "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40"}}, {"rule": 2, "type": "equivalent", "target": "e258e8d66ef84a134ed33d077971516e", "evidence": {"same_day": true, "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "45077f7207c2949591d55adc289e648e", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "在重新规划 PL/pgSQL “简单表达式”时，检查其是否仍然是简单的", "evidence": {"same_day": true, "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40"}, "url": "/docs/compare/?release=16.4#16.4-2258d3d478905208", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "127500e1083bce6f4d97d7eef49a742e", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "在重新规划 PL/pgSQL “简单表达式”时，检查其是否仍然是简单的", "evidence": {"same_day": true, "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40"}, "url": "/docs/compare/?release=15.8#15.8-2258d3d478905208", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "e258e8d66ef84a134ed33d077971516e", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "当重新规划 PL/pgSQL 的“简单表达式”时，检查它是否仍然是简单的", "evidence": {"same_day": true, "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40"}, "url": "/docs/compare/?release=13.16#13.16-c74a11be13a3e1e9", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "24a3b4bda5662edaa1f1f7dfcec501e0", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "当重新规划 PL/pgSQL 的“简单表达式”时，检查它是否仍然是简单的", "evidence": {"same_day": true, "patch_ids": ["2b2a88b3accaf9ef1f7e0c5aaebba9e5"], "statement_hash": "5b3fe3920981346dd07ccf30e2c885173ddd07c186ec43a15450724ece7a5b40"}, "url": "/docs/compare/?release=12.20#12.20-d1615198c551197b", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-f2a5557e6f8451fe", "cves": [], "html": "<p>修复 <span>PL/Perl</span> 与 Perl 5.40 之间的不兼容问题（Andrew Dunstan）<a href=\"https://postgr.es/c/f853e23bf\">§</a></p>", "text": "修复 PL/Perl 与 Perl 5.40 之间的不兼容问题（Andrew Dunstan）§", "title": "修复 PL/Perl 与 Perl 5.40 之间的不兼容问题", "commits": ["f853e23bf"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "3c8ee2708b6825dda49fe5fbe52a95ef7a3988d18fc7ef52b77f7cb46165af6f", "section_path": ["变更"], "commit_groups": [["0536f8e2c", "12c8faaa7", "1c4173116", "20f22e6a6", "320534f8f", "8851d5c3a", "8f3be9661", "ab46e132f", "b7374f15b", "e1541d518", "f853e23bf"]], "identity_text": "Fix incompatibility between PL/Perl and Perl 5.40 (Andrew Dunstan)", "commit_aliases": ["0536f8e2c", "12c8faaa7", "1c4173116", "20f22e6a6", "320534f8f", "8851d5c3a", "8f3be9661", "ab46e132f", "b7374f15b", "e1541d518", "f853e23bf"], "source_commits": ["20f22e6a6"], "source_entry_id": "14.13/changes/033", "db_id": "a4abd25ad829287bae60c9e3d6c1a787", "patch_ids": ["ac36a3e229017b95c0d7033a58d49e22"], "statement_hash": "bebd637de3db8c5fdec0334d227f825e7162798ff8cd82409e9cb452778e9d72", "relations": [{"rule": 2, "type": "equivalent", "target": "b1809abaee448a5b3c2e4c8eb317ff6f", "evidence": {"same_day": true, "patch_ids": ["ac36a3e229017b95c0d7033a58d49e22"], "statement_hash": "bebd637de3db8c5fdec0334d227f825e7162798ff8cd82409e9cb452778e9d72"}}, {"rule": 2, "type": "equivalent", "target": "e62226a33106e021ec3c694f5df73200", "evidence": {"same_day": true, "patch_ids": ["ac36a3e229017b95c0d7033a58d49e22"], "statement_hash": "bebd637de3db8c5fdec0334d227f825e7162798ff8cd82409e9cb452778e9d72"}}, {"rule": 2, "type": "equivalent", "target": "ebb6a7557dd2325059d0701cd759b8b3", "evidence": {"same_day": true, "patch_ids": ["ac36a3e229017b95c0d7033a58d49e22"], "statement_hash": "bebd637de3db8c5fdec0334d227f825e7162798ff8cd82409e9cb452778e9d72"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ebb6a7557dd2325059d0701cd759b8b3", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复 PL/Perl 与 Perl 5.40 之间的不兼容问题", "evidence": {"same_day": true, "patch_ids": ["ac36a3e229017b95c0d7033a58d49e22"], "statement_hash": "bebd637de3db8c5fdec0334d227f825e7162798ff8cd82409e9cb452778e9d72"}, "url": "/docs/compare/?release=15.8#15.8-f2a5557e6f8451fe", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "e62226a33106e021ec3c694f5df73200", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复 PL/Perl 与 Perl 5.40 之间的不兼容性", "evidence": {"same_day": true, "patch_ids": ["ac36a3e229017b95c0d7033a58d49e22"], "statement_hash": "bebd637de3db8c5fdec0334d227f825e7162798ff8cd82409e9cb452778e9d72"}, "url": "/docs/compare/?release=13.16#13.16-f8d8185935718b6e", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "b1809abaee448a5b3c2e4c8eb317ff6f", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复 PL/Perl 与 Perl 5.40 之间的不兼容性", "evidence": {"same_day": true, "patch_ids": ["ac36a3e229017b95c0d7033a58d49e22"], "statement_hash": "bebd637de3db8c5fdec0334d227f825e7162798ff8cd82409e9cb452778e9d72"}, "url": "/docs/compare/?release=12.20#12.20-36e2abf639bc2e49", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-37c152b2a6e8068e", "cves": [], "html": "<p>修复返回 <code>RECORD</code> 类型的递归 <span>PL/Python</span> 函数（Tom Lane）<a href=\"https://postgr.es/c/52ea653aa\">§</a></p>\n<p>如果递归到同一函数的新调用并传递了不同的列定义列表（<code>AS</code> 子句），将会失败，因为内部调用会覆盖外部调用所期望的返回行类型。</p>", "text": "修复返回 RECORD 类型的递归 PL/Python 函数（Tom Lane）§ 如果递归到同一函数的新调用并传递了不同的列定义列表（AS 子句），将会失败，因为内部调用会覆盖外部调用所期望的返回行类型。", "title": "修复返回 RECORD 类型的递归 PL/Python 函数", "commits": ["52ea653aa"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "7423e0999c2eb3469e48b20673b8efb214cdde46ca7725b53016210a96fec5bf", "section_path": ["变更"], "commit_groups": [["157b1e6b4", "272867792", "52ea653aa", "6e29963ed", "d39337021", "d727c5431"]], "identity_text": "Fix recursive RECORD-returning PL/Python functions (Tom Lane) If we recurse to a new call of the same function that passes a different column definition list (AS clause), it would fail because the inner call would overwrite the outer call's idea of what rowtype to return.", "commit_aliases": ["157b1e6b4", "272867792", "52ea653aa", "6e29963ed", "d39337021", "d727c5431"], "source_commits": ["d39337021"], "source_entry_id": "14.13/changes/034", "db_id": "60010522b3542aa6b59c72353574d5cc", "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a", "relations": [{"rule": 2, "type": "equivalent", "target": "20b19a024ab3cee29466177488f0c8ec", "evidence": {"same_day": true, "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a"}}, {"rule": 2, "type": "equivalent", "target": "6a9c99a143bef47df45f9e3c803f361b", "evidence": {"same_day": true, "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a"}}, {"rule": 2, "type": "equivalent", "target": "9c75f3e803cd1ebfaf256e5bdce5a7d2", "evidence": {"same_day": true, "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a"}}, {"rule": 2, "type": "equivalent", "target": "ed8339e2ae4f004ad6676f89b5586940", "evidence": {"same_day": true, "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "20b19a024ab3cee29466177488f0c8ec", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复返回 RECORD 类型的递归 PL/Python 函数", "evidence": {"same_day": true, "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a"}, "url": "/docs/compare/?release=16.4#16.4-37c152b2a6e8068e", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "6a9c99a143bef47df45f9e3c803f361b", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复返回 RECORD 类型的递归 PL/Python 函数", "evidence": {"same_day": true, "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a"}, "url": "/docs/compare/?release=15.8#15.8-37c152b2a6e8068e", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "9c75f3e803cd1ebfaf256e5bdce5a7d2", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复递归返回 RECORD 类型的 PL/Python 函数", "evidence": {"same_day": true, "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a"}, "url": "/docs/compare/?release=13.16#13.16-7b98d3b2d985af86", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "ed8339e2ae4f004ad6676f89b5586940", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复递归返回 RECORD 类型的 PL/Python 函数", "evidence": {"same_day": true, "patch_ids": ["7947e30d798e59659f6e76204af65a32"], "statement_hash": "d308bee676993d12669f2e9bf27b8bc434ac917954b15e76eaf5a5cbc0624d6a"}, "url": "/docs/compare/?release=12.20#12.20-1ebab025873a68ed", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-0723d1dbaccd70f3", "cves": [], "html": "<p>防止在递归触发器调用期间损坏 <span>PL/Python</span> 的 <code>TD</code> 字典（Tom Lane）<a href=\"https://postgr.es/c/be18a12b6\">§</a></p>\n<p>如果一个 <span>PL/Python</span> 语言的触发器导致另一个触发器被调用，为内部触发器创建的 <code>TD</code> 字典会覆盖外部触发器的 <code>TD</code> 字典。</p>", "text": "防止在递归触发器调用期间损坏 PL/Python 的 TD 字典（Tom Lane）§ 如果一个 PL/Python 语言的触发器导致另一个触发器被调用，为内部触发器创建的 TD 字典会覆盖外部触发器的 TD 字典。", "title": "防止在递归触发器调用期间损坏 PL/Python 的 TD 字典", "commits": ["be18a12b6"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "411fa16c596161f08ba7530a09753361befdccc949986df72a324d34c866a944", "section_path": ["变更"], "commit_groups": [["363e8c2f9", "4488142a4", "90d39929a", "abe60b6a0", "be18a12b6", "c5bec5426"]], "identity_text": "Don't corrupt PL/Python's TD dictionary during a recursive trigger call (Tom Lane) If a PL/Python-language trigger caused another one to be invoked, the TD dictionary created for the inner one would overwrite the outer one's TD dictionary.", "commit_aliases": ["363e8c2f9", "4488142a4", "90d39929a", "abe60b6a0", "be18a12b6", "c5bec5426"], "source_commits": ["90d39929a"], "source_entry_id": "14.13/changes/035", "db_id": "e9a7d849af36bb7a26f1632e487d1c41", "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e", "relations": [{"rule": 2, "type": "equivalent", "target": "06cd9e5e2436499a0cb491a8624d7f03", "evidence": {"same_day": true, "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e"}}, {"rule": 2, "type": "equivalent", "target": "382af4882b9049066ef592c7ed64ea5d", "evidence": {"same_day": true, "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e"}}, {"rule": 2, "type": "equivalent", "target": "d4089df436fad1c56f5bad3f9a851b82", "evidence": {"same_day": true, "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e"}}, {"rule": 2, "type": "equivalent", "target": "ea62821b94c1115cb6f53375a6d21b32", "evidence": {"same_day": true, "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "d4089df436fad1c56f5bad3f9a851b82", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "防止在递归触发器调用期间损坏 PL/Python 的 TD 字典", "evidence": {"same_day": true, "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e"}, "url": "/docs/compare/?release=16.4#16.4-0723d1dbaccd70f3", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "06cd9e5e2436499a0cb491a8624d7f03", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "防止在递归触发器调用期间损坏 PL/Python 的 TD 字典", "evidence": {"same_day": true, "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e"}, "url": "/docs/compare/?release=15.8#15.8-0723d1dbaccd70f3", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "382af4882b9049066ef592c7ed64ea5d", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "在递归触发器调用时不再损坏 PL/Python 的 TD 字典", "evidence": {"same_day": true, "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e"}, "url": "/docs/compare/?release=13.16#13.16-7fbe397bbc1d28b8", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "ea62821b94c1115cb6f53375a6d21b32", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "在递归触发器调用时不再损坏 PL/Python 的 TD 字典", "evidence": {"same_day": true, "patch_ids": ["f03f2dde1dca0670bc1599dcbe317c61"], "statement_hash": "77a26ba814b408ca0d56a469ac251cd2882d2416c0b187eee6237a2e2cee6d2e"}, "url": "/docs/compare/?release=12.20#12.20-190f8da8963221d5", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-8771278eb7926ca7", "cves": [], "html": "<p>修复 <span>PL/Tcl</span> 在返回元组的函数结果中存在无效列表语法时的报告（Erik Wienhold，Tom Lane）<a href=\"https://postgr.es/c/c236ecc82\">§</a></p>\n<p>这种情况可能导致崩溃，或发出实际上引用的是之前 Tcl 错误的误导性上下文信息。</p>", "text": "修复 PL/Tcl 在返回元组的函数结果中存在无效列表语法时的报告（Erik Wienhold，Tom Lane）§ 这种情况可能导致崩溃，或发出实际上引用的是之前 Tcl 错误的误导性上下文信息。", "title": "修复 PL/Tcl 在返回元组的函数结果中存在无效列表语法时的报告", "commits": ["c236ecc82"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "5a051a0fbc9c210ae15b9223c3499f781cd86ed1dd81feeee1bd1c1f5e4477cf", "section_path": ["变更"], "commit_groups": [["1488dee08", "30487423c", "89ef2aeda", "b631d0149", "c236ecc82", "dda633a03"]], "identity_text": "Fix PL/Tcl's reporting of invalid list syntax in the result of a function returning tuple (Erik Wienhold, Tom Lane) Such a case could result in a crash, or in emission of misleading context information that actually refers to the previous Tcl error.", "commit_aliases": ["1488dee08", "30487423c", "89ef2aeda", "b631d0149", "c236ecc82", "dda633a03"], "source_commits": ["1488dee08"], "source_entry_id": "14.13/changes/036", "db_id": "48a40977310db944b18878fd1d9ee0c0", "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8", "relations": [{"rule": 2, "type": "equivalent", "target": "527170027e210471e71d83b895dbdce8", "evidence": {"same_day": true, "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8"}}, {"rule": 2, "type": "equivalent", "target": "5550401bdb6f623616415bcada604ebd", "evidence": {"same_day": true, "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8"}}, {"rule": 2, "type": "equivalent", "target": "81458e14632112f49a79ce32652e8912", "evidence": {"same_day": true, "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8"}}, {"rule": 2, "type": "equivalent", "target": "cc423f04849acf7f0abdd53b43754337", "evidence": {"same_day": true, "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "527170027e210471e71d83b895dbdce8", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复 PL/Tcl 在返回元组的函数结果中存在无效列表语法时的报告", "evidence": {"same_day": true, "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8"}, "url": "/docs/compare/?release=16.4#16.4-8771278eb7926ca7", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "5550401bdb6f623616415bcada604ebd", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复 PL/Tcl 在返回元组的函数结果中存在无效列表语法时的报告", "evidence": {"same_day": true, "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8"}, "url": "/docs/compare/?release=15.8#15.8-8771278eb7926ca7", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "cc423f04849acf7f0abdd53b43754337", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复 PL/Tcl 在返回元组的函数结果中报告无效列表语法时的问题", "evidence": {"same_day": true, "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8"}, "url": "/docs/compare/?release=13.16#13.16-a9849bd743d21915", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "81458e14632112f49a79ce32652e8912", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复 PL/Tcl 在返回元组的函数结果中报告无效列表语法时的问题", "evidence": {"same_day": true, "patch_ids": ["3eaed2b1263d4410cb744af32c710f13"], "statement_hash": "7bc0765525feeacfd02af43b9138934794c6b06757eca285a686c8d2901b1ca8"}, "url": "/docs/compare/?release=12.20#12.20-004857a636f4825e", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-328c4d72c45dad1d", "cves": [], "html": "<p>避免在 <span>libpq</span> 中使用非线程安全的 <code>strerror()</code>（Peter Eisentraut）<a href=\"https://postgr.es/c/95e805e9c\">§</a></p>\n<p>在多线程应用程序中，OpenSSL 返回的某些错误消息可能会出现乱码。</p>", "text": "避免在 libpq 中使用非线程安全的 strerror()（Peter Eisentraut）§ 在多线程应用程序中，OpenSSL 返回的某些错误消息可能会出现乱码。", "title": "避免在 libpq 中使用非线程安全的 strerror()", "commits": ["95e805e9c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "3b365ff25b49ad0200b3643fe848ceabe3240037a53de34c8974497949ae0725", "section_path": ["变更"], "commit_groups": [["1e666fd7c", "407048999", "6ddc8556c", "821fbd63e", "95e805e9c", "c53016860", "da5d7a771"]], "identity_text": "Avoid non-thread-safe usage of strerror() in libpq (Peter Eisentraut) Certain error messages returned by OpenSSL could become garbled in multi-threaded applications.", "commit_aliases": ["1e666fd7c", "407048999", "6ddc8556c", "821fbd63e", "95e805e9c", "c53016860", "da5d7a771"], "source_commits": ["95e805e9c"], "source_entry_id": "14.13/changes/037", "db_id": "097051fd9efc208c987eb76542e64177", "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137", "relations": [{"rule": 2, "type": "equivalent", "target": "0aeace2c7faf71a8f2d23262f81bd107", "evidence": {"same_day": true, "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137"}}, {"rule": 2, "type": "equivalent", "target": "81834e09775bbfdbf6f1336eb5b59b8a", "evidence": {"same_day": true, "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137"}}, {"rule": 2, "type": "equivalent", "target": "88958dc3f16320c688a325cdb8084269", "evidence": {"same_day": true, "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137"}}, {"rule": 2, "type": "equivalent", "target": "e2c1ca523a06f58e8aa08aa78a24abfa", "evidence": {"same_day": true, "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "88958dc3f16320c688a325cdb8084269", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "避免在 libpq 中使用非线程安全的 strerror()", "evidence": {"same_day": true, "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137"}, "url": "/docs/compare/?release=16.4#16.4-480885de705e9cbb", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "e2c1ca523a06f58e8aa08aa78a24abfa", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "避免在 libpq 中使用非线程安全的 strerror()", "evidence": {"same_day": true, "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137"}, "url": "/docs/compare/?release=15.8#15.8-676c07c2106c1940", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "81834e09775bbfdbf6f1336eb5b59b8a", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "避免在 libpq 中使用非线程安全的 strerror()", "evidence": {"same_day": true, "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137"}, "url": "/docs/compare/?release=13.16#13.16-0a633bb50a35294a", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "0aeace2c7faf71a8f2d23262f81bd107", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "避免在 libpq 中使用非线程安全的 strerror()", "evidence": {"same_day": true, "patch_ids": ["a3d7c4819f76f780b294f0d534f3d386"], "statement_hash": "8f87b81178c73ff90bca394c44d0b8be66c71dbc73e6f3a2ad680899707d7137"}, "url": "/docs/compare/?release=12.20#12.20-72e701377f35dc6d", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-4465b07bfecef10b", "cves": [], "html": "<p>确保 <code>pg_restore</code> <code>-l</code> 正确报告依赖的 TOC 条目（Tom Lane）<a href=\"https://postgr.es/c/5dce8ce0a\">§</a></p>\n<p>如果 <code>-l</code> 与选择性恢复选项（如 <code>-n</code> 或 <code>-N</code>）一起指定，依赖的 TOC 条目（如注释）会从列表中被省略，即使实际恢复会选择它们。</p>", "text": "确保 pg_restore -l 正确报告依赖的 TOC 条目（Tom Lane）§ 如果 -l 与选择性恢复选项（如 -n 或 -N）一起指定，依赖的 TOC 条目（如注释）会从列表中被省略，即使实际恢复会选择它们。", "title": "确保 pg_restore -l 正确报告依赖的 TOC 条目", "commits": ["5dce8ce0a"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "1dd22ccfa16bfc67d94a29b313f44d57ddba84508663c26975290d554920db22", "section_path": ["变更"], "commit_groups": [["52b23b4e1", "5dce8ce0a", "6a458d93b", "a3c00ab15", "b99dc6694", "c1aea206e"]], "identity_text": "Ensure that pg_restore -l reports dependent TOC entries correctly (Tom Lane) If -l was specified together with selective-restore options such as -n or -N, dependent TOC entries such as comments would be omitted from the listing, even when an actual restore would have selected them.", "commit_aliases": ["52b23b4e1", "5dce8ce0a", "6a458d93b", "a3c00ab15", "b99dc6694", "c1aea206e"], "source_commits": ["52b23b4e1"], "source_entry_id": "14.13/changes/038", "db_id": "59693ce86d9165ee0f47a1d70e62aa0d", "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd", "relations": [{"rule": 2, "type": "equivalent", "target": "ca3c38fbb5cc85cea9d2f9c29f2d4456", "evidence": {"same_day": true, "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd"}}, {"rule": 2, "type": "equivalent", "target": "cf7fcb1e75e9ced39a243606d466d53d", "evidence": {"same_day": true, "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd"}}, {"rule": 2, "type": "equivalent", "target": "f16b60ce0607fd8ead7704679cce55a5", "evidence": {"same_day": true, "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd"}}, {"rule": 2, "type": "equivalent", "target": "f61b13cb9a14f103337e063320537533", "evidence": {"same_day": true, "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f61b13cb9a14f103337e063320537533", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "确保 pg_restore -l 正确报告依赖的 TOC 条目", "evidence": {"same_day": true, "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd"}, "url": "/docs/compare/?release=16.4#16.4-4465b07bfecef10b", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "f16b60ce0607fd8ead7704679cce55a5", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "确保 pg_restore -l 正确报告依赖的 TOC 条目", "evidence": {"same_day": true, "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd"}, "url": "/docs/compare/?release=15.8#15.8-4465b07bfecef10b", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "cf7fcb1e75e9ced39a243606d466d53d", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "确保 pg_restore -l 正确报告依赖的 TOC 条目", "evidence": {"same_day": true, "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd"}, "url": "/docs/compare/?release=13.16#13.16-f0ea7245a8156863", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "ca3c38fbb5cc85cea9d2f9c29f2d4456", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "确保 pg_restore -l 正确报告依赖的 TOC 条目", "evidence": {"same_day": true, "patch_ids": ["fefb994793a8d6b379efb188ae6c7c2b"], "statement_hash": "10fc54dae596ed0a5d90649e294eaecdbdf7b4860ba37a7dd0388fd6cccc40cd"}, "url": "/docs/compare/?release=12.20#12.20-4a38d993e83c9b53", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-5f85238ce4d37124", "cves": [], "html": "<p>在 <code>contrib/postgres_fdw</code> 中，不向远程服务器发送 <code>FETCH FIRST WITH TIES</code> 子句（Japin Li）<a href=\"https://postgr.es/c/8405d5a37\">§</a></p>\n<p>远程服务器可能不支持此子句，或可能对其解释与本地不同，因此不要冒险尝试远程执行。</p>", "text": "在 contrib/postgres_fdw 中，不向远程服务器发送 FETCH FIRST WITH TIES 子句（Japin Li）§ 远程服务器可能不支持此子句，或可能对其解释与本地不同，因此不要冒险尝试远程执行。", "title": "在 contrib/postgres_fdw 中，不向远程服务器发送 FETCH FIRST WITH TIES 子句", "commits": ["8405d5a37"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "5dfb172699a228086dbf58309c62a3193cec454d8ba7f64da2e67da87c1547d4", "section_path": ["变更"], "commit_groups": [["269e2c391", "2b461efc5", "8405d5a37", "8cfbac149", "b33c141cc"]], "identity_text": "In contrib/postgres_fdw, do not send FETCH FIRST WITH TIES clauses to the remote server (Japin Li) The remote server might not implement this clause, or might interpret it differently than we would locally, so don't risk attempting remote execution.", "commit_aliases": ["269e2c391", "2b461efc5", "8405d5a37", "8cfbac149", "b33c141cc"], "source_commits": ["269e2c391"], "source_entry_id": "14.13/changes/039", "db_id": "578e3fc179af8baa9c81cecfb8dee4be", "patch_ids": ["af8cadd93c2e4e82af7a0a2a842e2994"], "statement_hash": "6ed56b7ba04fbd7adb333f9567fe5298d4c143e3b0df22004014da56081df4c3", "relations": [{"rule": 2, "type": "equivalent", "target": "459b25750cf24b7abdb4054a6a1f8343", "evidence": {"same_day": true, "patch_ids": ["af8cadd93c2e4e82af7a0a2a842e2994"], "statement_hash": "6ed56b7ba04fbd7adb333f9567fe5298d4c143e3b0df22004014da56081df4c3"}}, {"rule": 2, "type": "equivalent", "target": "4d677e935bf1190a9e3d0be744515d0e", "evidence": {"same_day": true, "patch_ids": ["af8cadd93c2e4e82af7a0a2a842e2994"], "statement_hash": "6ed56b7ba04fbd7adb333f9567fe5298d4c143e3b0df22004014da56081df4c3"}}, {"rule": 2, "type": "equivalent", "target": "c53e7e53d97ef233311ec34321fc6373", "evidence": {"same_day": true, "patch_ids": ["af8cadd93c2e4e82af7a0a2a842e2994"], "statement_hash": "6ed56b7ba04fbd7adb333f9567fe5298d4c143e3b0df22004014da56081df4c3"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "4d677e935bf1190a9e3d0be744515d0e", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "在 contrib/postgres_fdw 中，不向远程服务器发送 FETCH FIRST WITH TIES 子句", "evidence": {"same_day": true, "patch_ids": ["af8cadd93c2e4e82af7a0a2a842e2994"], "statement_hash": "6ed56b7ba04fbd7adb333f9567fe5298d4c143e3b0df22004014da56081df4c3"}, "url": "/docs/compare/?release=16.4#16.4-5f85238ce4d37124", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "c53e7e53d97ef233311ec34321fc6373", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "在 contrib/postgres_fdw 中，不向远程服务器发送 FETCH FIRST WITH TIES 子句", "evidence": {"same_day": true, "patch_ids": ["af8cadd93c2e4e82af7a0a2a842e2994"], "statement_hash": "6ed56b7ba04fbd7adb333f9567fe5298d4c143e3b0df22004014da56081df4c3"}, "url": "/docs/compare/?release=15.8#15.8-5f85238ce4d37124", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "459b25750cf24b7abdb4054a6a1f8343", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "在 contrib/postgres_fdw 中，不要将 FETCH FIRST WITH TIES 子句发送到远程服务器", "evidence": {"same_day": true, "patch_ids": ["af8cadd93c2e4e82af7a0a2a842e2994"], "statement_hash": "6ed56b7ba04fbd7adb333f9567fe5298d4c143e3b0df22004014da56081df4c3"}, "url": "/docs/compare/?release=13.16#13.16-777bd2caa21a3409", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}]}, {"id": "14.13-84d33b54cec13c7c", "cves": [], "html": "<p>避免与系统提供的 <code>&lt;regex.h&gt;</code> 头文件冲突（Thomas Munro）<a href=\"https://postgr.es/c/c2342a925\">§</a></p>\n<p>这修复了 macOS 版本 15 及更高版本上的编译失败。</p>", "text": "避免与系统提供的 <regex.h> 头文件冲突（Thomas Munro）§ 这修复了 macOS 版本 15 及更高版本上的编译失败。", "title": "避免与系统提供的 <regex.h> 头文件冲突", "commits": ["c2342a925"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "7e5f6f64c5281d1f8d1818772b2ad6061dfa2d997e93c628a47d044f8659ec05", "section_path": ["变更"], "commit_groups": [["274a8195d", "2a5ef0983", "31423bc44", "440aedc0f", "467d77bb1", "9c273679b", "c2342a925"]], "identity_text": "Avoid clashing with system-provided <regex.h> headers (Thomas Munro) This fixes a compilation failure on macOS version 15 and up.", "commit_aliases": ["274a8195d", "2a5ef0983", "31423bc44", "440aedc0f", "467d77bb1", "9c273679b", "c2342a925"], "source_commits": ["c2342a925"], "source_entry_id": "14.13/changes/040", "db_id": "115125c5dfb8e0c8580ccd73e9865f79", "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26", "relations": [{"rule": 2, "type": "equivalent", "target": "41c841abecf24c0a6b781847df943ea3", "evidence": {"same_day": true, "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26"}}, {"rule": 2, "type": "equivalent", "target": "59eef511e4d0d4762bed8161960d8f5f", "evidence": {"same_day": true, "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26"}}, {"rule": 2, "type": "equivalent", "target": "892025c3aeba77f7c8887c5900e76955", "evidence": {"same_day": true, "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26"}}, {"rule": 2, "type": "equivalent", "target": "d29e5cca14c0b5e9e789a13bcaeabd29", "evidence": {"same_day": true, "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26"}}], "version": "14.13", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "d29e5cca14c0b5e9e789a13bcaeabd29", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "避免与系统提供的 <regex.h> 头文件冲突", "evidence": {"same_day": true, "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26"}, "url": "/docs/compare/?release=16.4#16.4-da61a48deb079685", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "892025c3aeba77f7c8887c5900e76955", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "避免与系统提供的 <regex.h> 头文件冲突", "evidence": {"same_day": true, "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26"}, "url": "/docs/compare/?release=15.8#15.8-7fa723089ac8b4c3", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "59eef511e4d0d4762bed8161960d8f5f", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "避免与系统提供的 <regex.h> 头文件冲突", "evidence": {"same_day": true, "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26"}, "url": "/docs/compare/?release=13.16#13.16-d7f3dd9093eead02", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "41c841abecf24c0a6b781847df943ea3", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "避免与系统提供的 <regex.h> 头文件冲突", "evidence": {"same_day": true, "patch_ids": ["f299b243be09786873c169990e7a8a0f"], "statement_hash": "c7ae8a631c152ec96034cc3b7a0aeb4612fa0233f65b8079ce920f0ed199db26"}, "url": "/docs/compare/?release=12.20#12.20-9580cbede555c2f2", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}, {"id": "14.13-54f10c000d4de9ae", "cves": [], "html": "<p>修复 Memoize 代价估算中无害的断言失败（David Rowley）<a href=\"https://postgr.es/c/dae9f16aa\">§</a></p>", "text": "修复 Memoize 代价估算中无害的断言失败（David Rowley）§", "title": "修复 Memoize 代价估算中无害的断言失败", "commits": ["dae9f16aa"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "0c0ccb09e1fcc4ca24dab24f840f93edfd31d0e2a1d08379f7b89a98357ca6d4", "section_path": ["变更"], "commit_groups": [["27c6242a0", "6143c9c03", "aa901a37c", "dae9f16aa"]], "identity_text": "Fix otherwise-harmless assertion failure in Memoize cost estimation (David Rowley)", "commit_aliases": ["27c6242a0", "6143c9c03", "aa901a37c", "dae9f16aa"], "source_commits": ["dae9f16aa"], "source_entry_id": "14.13/changes/041", "db_id": "77079c980d8b56fa9f5bab0086844c3a", "patch_ids": ["ade48b4f0aa81affd8f791862fcafbb6"], "statement_hash": "288f5eca9b41b17c866ebb012dab2eb5c045b6fc831d67505eaed1f274c5f94c", "relations": [{"rule": 2, "type": "equivalent", "target": "25751ad4e71de0a52ec523f98a6bc9e2", "evidence": {"same_day": true, "patch_ids": ["ade48b4f0aa81affd8f791862fcafbb6"], "statement_hash": "288f5eca9b41b17c866ebb012dab2eb5c045b6fc831d67505eaed1f274c5f94c"}}, {"rule": 2, "type": "equivalent", "target": "b41f00e16ce18a50cab6e1a44d3257a2", "evidence": {"same_day": true, "patch_ids": ["ade48b4f0aa81affd8f791862fcafbb6"], "statement_hash": "288f5eca9b41b17c866ebb012dab2eb5c045b6fc831d67505eaed1f274c5f94c"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "25751ad4e71de0a52ec523f98a6bc9e2", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复 Memoize 代价估算中无害的断言失败", "evidence": {"same_day": true, "patch_ids": ["ade48b4f0aa81affd8f791862fcafbb6"], "statement_hash": "288f5eca9b41b17c866ebb012dab2eb5c045b6fc831d67505eaed1f274c5f94c"}, "url": "/docs/compare/?release=16.4#16.4-54f10c000d4de9ae", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "b41f00e16ce18a50cab6e1a44d3257a2", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复 Memoize 代价估算中无害的断言失败", "evidence": {"same_day": true, "patch_ids": ["ade48b4f0aa81affd8f791862fcafbb6"], "statement_hash": "288f5eca9b41b17c866ebb012dab2eb5c045b6fc831d67505eaed1f274c5f94c"}, "url": "/docs/compare/?release=15.8#15.8-71af27b8e83efd31", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}]}, {"id": "14.13-4c9cf35c87383b40", "cves": [], "html": "<p>修复对 SP-GiST 索引执行 <code>REINDEX CONCURRENTLY</code> 时的无害断言失败（Tom Lane）<a href=\"https://postgr.es/c/06f81fed3\">§</a></p>", "text": "修复对 SP-GiST 索引执行 REINDEX CONCURRENTLY 时的无害断言失败（Tom Lane）§", "title": "修复对 SP-GiST 索引执行 REINDEX CONCURRENTLY 时的无害断言失败", "commits": ["06f81fed3"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.13/#ZH-AUTO-RELEASE-14-SECT2-20", "source_hash": "5990e6c3beb172ddeb64526027bd70d32db3eb04c66edbe48b6feacae8569a74", "section_path": ["变更"], "commit_groups": [["06f81fed3", "3e3e2ebea", "507a900ad", "92c49d106", "e4a55378f", "f55083319"]], "identity_text": "Fix otherwise-harmless assertion failures in REINDEX CONCURRENTLY applied to an SP-GiST index (Tom Lane)", "commit_aliases": ["06f81fed3", "3e3e2ebea", "507a900ad", "92c49d106", "e4a55378f", "f55083319"], "source_commits": ["e4a55378f"], "source_entry_id": "14.13/changes/042", "db_id": "8414e5c5ff4bcaa9b5887890ca1efbfe", "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191", "relations": [{"rule": 2, "type": "equivalent", "target": "124a495b047deb5a0cb95e1f6de4f212", "evidence": {"same_day": true, "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191"}}, {"rule": 2, "type": "equivalent", "target": "73ce7a765d417fd304fe569e69b6b178", "evidence": {"same_day": true, "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191"}}, {"rule": 2, "type": "equivalent", "target": "7d3e82dd05e4622c8a36d190512af0c5", "evidence": {"same_day": true, "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191"}}, {"rule": 2, "type": "equivalent", "target": "90364bf4105ea19c37634826d8620a36", "evidence": {"same_day": true, "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191"}}], "version": "14.13", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "7d3e82dd05e4622c8a36d190512af0c5", "kind": "equivalent", "version": "16.4", "label": "16.4", "title": "修复对 SP-GiST 索引执行 REINDEX CONCURRENTLY 时的无害断言失败", "evidence": {"same_day": true, "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191"}, "url": "/docs/compare/?release=16.4#16.4-4c9cf35c87383b40", "source_url": "/docs/release/16.4/#RELEASE-16-4-CHANGES"}, {"db_id": "90364bf4105ea19c37634826d8620a36", "kind": "equivalent", "version": "15.8", "label": "15.8", "title": "修复对 SP-GiST 索引执行 REINDEX CONCURRENTLY 时的无害断言失败", "evidence": {"same_day": true, "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191"}, "url": "/docs/compare/?release=15.8#15.8-4c9cf35c87383b40", "source_url": "/docs/release/15.8/#ZH-AUTO-RELEASE-15-SECT2-20"}, {"db_id": "124a495b047deb5a0cb95e1f6de4f212", "kind": "equivalent", "version": "13.16", "label": "13.16", "title": "修复对 SP-GiST 索引应用 REINDEX CONCURRENTLY 时无害的断言失败", "evidence": {"same_day": true, "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191"}, "url": "/docs/compare/?release=13.16#13.16-144b5161fc78409a", "source_url": "/docs/release/13.16/#id-1.11.6.13.5"}, {"db_id": "73ce7a765d417fd304fe569e69b6b178", "kind": "equivalent", "version": "12.20", "label": "12.20", "title": "修复对 SP-GiST 索引应用 REINDEX CONCURRENTLY 时无害的断言失败", "evidence": {"same_day": true, "patch_ids": ["53caddfa058704bdf1813c8355d9cfb9"], "statement_hash": "6f74f46f2c2c96068e23b24b5ec4da43a9e1b150b9d073d99edd196871672191"}, "url": "/docs/compare/?release=12.20#12.20-1ee580be1ce9dbcf", "source_url": "/docs/release/12.20/#id-1.11.6.8.6"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 42}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 21}, {"key": "security", "label": "安全相关", "count": 2}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 19}], "total": 42, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2024-7348", "url": "https://www.postgresql.org/support/security/CVE-2024-7348/", "fixed": {"12": "12.20", "13": "13.16", "14": "14.13", "15": "15.8", "16": "16.4"}, "score": 8.8, "title": "防止在 pg_dump 期间执行未经授权的代码", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2024-7348", "affected": {"12": "12", "13": "13", "14": "14", "15": "15", "16": "16"}, "component": "core server", "published": {"12": "2024-08-08", "13": "2024-08-08", "14": "2024-08-08", "15": "2024-08-08", "16": "2024-08-08"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Time-of-check Time-of-use (TOCTOU) race condition in pg_dump in PostgreSQL allows an object creator to execute arbitrary SQL functions as the user running pg_dump, which is often a superuser. The attack involves replacing another relation type with a view or foreign table. The attack requires waiting for pg_dump to start, but winning the race condition is trivial if the attacker retains an open transaction. Versions before PostgreSQL 16.4, 15.8, 14.13, 13.16, and 12.20 are affected.\n\nThe PostgreSQL project thanks Noah Misch for reporting this problem.", "affected_ranges": [{"from": "0", "until": "12.20"}, {"from": "13", "until": "13.16"}, {"from": "14", "until": "14.13"}, {"from": "15", "until": "15.8"}, {"from": "16", "until": "16.4"}], "first_published": "2024-08-08", "fixed_version": "14.13"}, {"id": "CVE-2023-5869", "url": "https://www.postgresql.org/support/security/CVE-2023-5869/", "fixed": {"11": "11.22", "12": "12.17", "13": "13.13", "14": "14.10", "15": "15.5", "16": "16.1"}, "score": 8.8, "title": "检测计算新数组维度时的另一个整数溢出情况", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"11": "11", "12": "12", "13": "13", "14": "14", "15": "15", "16": "16"}, "component": "core server", "published": {"11": "2023-11-09", "12": "2023-11-09", "13": "2023-11-09", "14": "2023-11-09", "15": "2023-11-09", "16": "2023-11-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "While modifying certain SQL array values, missing overflow checks let authenticated database users write arbitrary bytes to a memory area that facilitates arbitrary code execution. Missing overflow checks also let authenticated database users read a wide area of server memory. The CVE-2021-32027 fix covered some attacks of this description, but it missed others.\n\nThe PostgreSQL project thanks Pedro Gallegos for reporting this problem.", "first_published": "2023-11-09", "fixed_version": "14.10"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 42, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}