对于运行 14.X 的用户，不需要执行导出/恢复。
\n但是，如果是从早于 14.14 的版本升级，请参见第 E.11 节。
", "compatibility_count": 0, "label": "14.16", "status_label": "受支持版本", "eol": "2026-11-12", "age_days": 594, "support_days": 43}, "groups": [{"date": "2025-02-13", "build": "14.16", "major": "14", "minor": 16, "manual": "14", "status": "stable", "doc_git": "", "version": "14.16", "eol_date": "2026-11-12", "date_text": "2025-02-13", "supported": true, "manual_url": "/docs/14/release-14-16.html", "source_url": "/docs/release/14.16/", "entry_count": 46, "placeholder": false, "content_hash": "ceeb5a767f7c9d1adebd946f64b0034c1441f2ffaf30644c82cbec4c6e64c29d", "manual_build": "14.24", "source_as_of": "", "changes_count": 46, "doc_loaded_at": "2026-09-26T02:56:39.341991", "migration_html": "对于运行 14.X 的用户，不需要执行导出/恢复。
\n但是，如果是从早于 14.14 的版本升级，请参见第 E.11 节。
", "compatibility_count": 0, "label": "14.16", "status_label": "受支持版本", "eol": "2026-11-12", "age_days": 594, "support_days": 43, "entries": [{"id": "14.16-84a4341a43ed7fd0", "cves": ["CVE-2025-1094"], "html": "加强 PQescapeString 及相关函数对无效编码输入字符串的防护（Andres Freund，Noah Misch）§ § § § § §
libpq 提供的数据引用函数现在会完全检查其输入的编码有效性。如果检测到无效字符，会尽可能报告错误。对于缺少错误返回机制的函数，输出字符串会被调整以确保服务器会报告无效编码，并且中间处理不会被恰好匹配单引号、反斜杠等的字节所欺骗。
\n此变更的目的是防范在使用这些函数对精心构造的输入进行引用时可能发生的 SQL 注入攻击。当结果字符串直接发送到 PostgreSQL 服务器时没有风险（服务器无论如何都会检查编码），但当它通过 psql 或其他客户端代码传递时存在风险。历史上此类代码未仔细审查编码，在许多情况下如果检测到此类问题也不清楚应该怎么做。
\n此修复仅在数据引用函数、服务器以及任何中间处理对所使用的字符编码达成一致时才有效。插入不可信输入到 SQL 命令中的应用程序应特别注意确保这一点。
\n不使用这些 libpq 函数而引用不可信输入的应用程序和驱动程序可能面临类似问题的风险。它们应首先确认数据在服务器期望的编码中是有效的。
\nPostgreSQL 项目感谢 Stephen Fewer 报告此问题。（CVE-2025-1094）
", "text": "加强 PQescapeString 及相关函数对无效编码输入字符串的防护（Andres Freund，Noah Misch）§ § § § § § libpq 提供的数据引用函数现在会完全检查其输入的编码有效性。如果检测到无效字符，会尽可能报告错误。对于缺少错误返回机制的函数，输出字符串会被调整以确保服务器会报告无效编码，并且中间处理不会被恰好匹配单引号、反斜杠等的字节所欺骗。 此变更的目的是防范在使用这些函数对精心构造的输入进行引用时可能发生的 SQL 注入攻击。当结果字符串直接发送到 PostgreSQL 服务器时没有风险（服务器无论如何都会检查编码），但当它通过 psql 或其他客户端代码传递时存在风险。历史上此类代码未仔细审查编码，在许多情况下如果检测到此类问题也不清楚应该怎么做。 此修复仅在数据引用函数、服务器以及任何中间处理对所使用的字符编码达成一致时才有效。插入不可信输入到 SQL 命令中的应用程序应特别注意确保这一点。 不使用这些 libpq 函数而引用不可信输入的应用程序和驱动程序可能面临类似问题的风险。它们应首先确认数据在服务器期望的编码中是有效的。 PostgreSQL 项目感谢 Stephen Fewer 报告此问题。（CVE-2025-1094）", "title": "加强 PQescapeString 及相关函数对无效编码输入字符串的防护", "commits": ["2ae54ae17", "46ddf98df", "4a6825c76", "5bc33cbea", "e0ef3d776", "e1f1b030d"], "section": "变更", "category": "security", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "58f64473ecb04bd5076ea8c833f8982b231f82e2cdb42a0095dd4252126825e7", "section_path": ["变更"], "commit_groups": [["0075a5c6c", "5bf12323b", "85c1fcc65", "9862de917", "e1f1b030d", "f9fceef6e"], ["00f1a1f66"], ["01784793f", "02d4d87ac", "46ddf98df", "4ea3f5ef3", "ac00ff1c9", "de4b92f33"], ["05abb0f83", "41343f840", "4a6825c76", "7beb2af5e", "979205e47", "a085fa731"], ["2ae54ae17", "3e98c8ce5", "56aa2dcdd", "5df4e1632", "61ad93cdd", "b1756da75"], ["370c94d4c", "43a77239d", "5dc1e42b4", "92e4170f4", "c906bfe1b", "e0ef3d776"], ["4dc289635", "5bc33cbea", "6e05b195d", "703b3fd5d", "7d43ca6fe", "db3eb0e82"]], "identity_text": "Harden PQescapeString and allied functions against invalidly-encoded input strings (Andres Freund, Noah Misch) Data-quoting functions supplied by libpq now fully check the encoding validity of their input. If invalid characters are detected, they report an error if possible. For the ones that lack an error return convention, the output string is adjusted to ensure that the server will report invalid encoding and no intervening processing will be fooled by bytes that might happen to match single quote, backslash, etc. The purpose of this change is to guard against SQL-injection attacks that are possible if one of these functions is used to quote crafted input. There is no hazard when the resulting string is sent directly to a PostgreSQL server (which would check its encoding anyway), but there is a risk when it is passed through psql or other client-side code. Historically such code has not carefully vetted encoding, and in many cases it's not clear what it should do if it did detect such a problem. This fix is effective only if the data-quoting function, the server, and any intermediate processing agree on the character encoding that's being used. Applications that insert untrusted input into SQL commands should take special care to ensure that that's true. Applications and drivers that quote untrusted input without using these libpq functions may be at risk of similar problems. They should first confirm the data is valid in the encoding expected by the server. The PostgreSQL Project thanks Stephen Fewer for reporting this problem. (CVE-2025-1094)", "commit_aliases": ["0075a5c6c", "00f1a1f66", "01784793f", "02d4d87ac", "05abb0f83", "2ae54ae17", "370c94d4c", "3e98c8ce5", "41343f840", "43a77239d", "46ddf98df", "4a6825c76", "4dc289635", "4ea3f5ef3", "56aa2dcdd", "5bc33cbea", "5bf12323b", "5dc1e42b4", "5df4e1632", "61ad93cdd", "6e05b195d", "703b3fd5d", "7beb2af5e", "7d43ca6fe", "85c1fcc65", "92e4170f4", "979205e47", "9862de917", "a085fa731", "ac00ff1c9", "b1756da75", "c906bfe1b", "db3eb0e82", "de4b92f33", "e0ef3d776", "e1f1b030d", "f9fceef6e"], "source_commits": ["00f1a1f66", "2ae54ae17", "46ddf98df", "4a6825c76", "5bc33cbea", "e0ef3d776", "e1f1b030d"], "source_entry_id": "14.16/changes/001", "db_id": "c67f7d11537493045db911b0c721db16", "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510", "relations": [{"rule": 2, "type": "equivalent", "target": "90ded14b63ff2f1ce6a02628434a92b8", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}}, {"rule": 2, "type": "equivalent", "target": "d394c7dd9345d5f8b712225bcd0d756b", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}}, {"rule": 2, "type": "equivalent", "target": "f13ab6baf3e95ab97b902e09323ae11f", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}}, {"rule": 2, "type": "equivalent", "target": "f649b02262a5f42707d74fc679509c8c", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}}], "version": "14.16", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "d394c7dd9345d5f8b712225bcd0d756b", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "加强 PQescapeString 及相关函数对无效编码输入字符串的防护", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}, "url": "/docs/compare/?release=17.3#17.3-ec56c13500d18830", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "90ded14b63ff2f1ce6a02628434a92b8", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "加强 PQescapeString 及相关函数对无效编码输入字符串的防护", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}, "url": "/docs/compare/?release=16.7#16.7-76a3b23ceb65c9a6", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "f649b02262a5f42707d74fc679509c8c", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "加强 PQescapeString 及相关函数对无效编码输入字符串的防护", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}, "url": "/docs/compare/?release=15.11#15.11-ed0b0c5a5ce7c384", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "f13ab6baf3e95ab97b902e09323ae11f", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "加强 PQescapeString 及相关函数对无效编码输入字符串的防护", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}, "url": "/docs/compare/?release=13.19#13.19-53e824654163768f", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-be7c14323620943f", "cves": [], "html": "将并行工作进程排除在连接权限检查和限制之外（Tom Lane）§
\n启动并行工作进程时不再检查 datallowconn、rolcanlogin 和 ACL_CONNECT 权限，而是假定领导进程最初通过了类似检查就足够了。这避免了例如当领导进程以缺少登录权限的角色运行时，并行化查询出现意外失败的情况。同样，ReservedConnections、datconnlimit 和 rolconnlimit 限制仅对普通后端执行，且仅计算普通后端的数量来检查是否已达到限制。这些限制旨在防止普通后端过度占用进程槽位——而并行工作进程和其他特殊进程有自己的进程槽池和自己的限制检查。
保持 TransactionXmin 与 MyProc->xmin 同步（Heikki Linnakangas）§
此疏忽可能允许进程尝试访问已被清理掉的数据。一个已知的后果是出现临时性的 “could not access status of transaction” 错误。
", "text": "保持 TransactionXmin 与 MyProc->xmin 同步（Heikki Linnakangas）§ 此疏忽可能允许进程尝试访问已被清理掉的数据。一个已知的后果是出现临时性的 “could not access status of transaction” 错误。", "title": "保持 TransactionXmin 与 MyProc->xmin 同步", "commits": ["41eafbb49"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "e45f9226df11b7c3e6acde6a28ec3019550209ca80f35034c75a36482641812a", "section_path": ["变更"], "commit_groups": [["41eafbb49", "578a7fe7b", "7cfdb4d1e", "9c1afd344", "9d8ab2c46", "acd5c28db"]], "identity_text": "Keep TransactionXmin in sync with MyProc->xmin (Heikki Linnakangas) This oversight could permit a process to try to access data that had already been vacuumed away. One known consequence is transient could not access status of transaction errors.", "commit_aliases": ["41eafbb49", "578a7fe7b", "7cfdb4d1e", "9c1afd344", "9d8ab2c46", "acd5c28db"], "source_commits": ["41eafbb49"], "source_entry_id": "14.16/changes/003", "db_id": "0f7d09315a70377991e6a72997b3ba55", "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533", "relations": [{"rule": 2, "type": "equivalent", "target": "95bc5c6b6c30d84fe3e9651574bf0744", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}}, {"rule": 2, "type": "equivalent", "target": "b17ef1f417debb4410a01a0a5a78dc49", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}}, {"rule": 2, "type": "equivalent", "target": "c65490f6c757feec0acb4cae39b05bd5", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}}, {"rule": 2, "type": "equivalent", "target": "f41d1eff08bdff771230aeb8e3ed62d7", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f41d1eff08bdff771230aeb8e3ed62d7", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "保持 TransactionXmin 与 MyProc->xmin 同步", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}, "url": "/docs/compare/?release=17.3#17.3-64d8331c91e7da7b", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "c65490f6c757feec0acb4cae39b05bd5", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "保持 TransactionXmin 与 MyProc->xmin 同步", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}, "url": "/docs/compare/?release=16.7#16.7-ab66fa2b5cecb35b", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "b17ef1f417debb4410a01a0a5a78dc49", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "保持 TransactionXmin 与 MyProc->xmin 同步", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}, "url": "/docs/compare/?release=15.11#15.11-10d6ee2ef80e51a0", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "95bc5c6b6c30d84fe3e9651574bf0744", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "保持 TransactionXmin 与 MyProc->xmin 同步", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}, "url": "/docs/compare/?release=13.19#13.19-2a0429c69913222c", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-e9c0b08aff686af1", "cves": [], "html": "修复可能导致无法将新插入的目录条目添加到目录缓存列表中的竞态条件（Heikki Linnakangas）§
\n例如，这可能导致在现有会话中无法使用新创建的函数。
", "text": "修复可能导致无法将新插入的目录条目添加到目录缓存列表中的竞态条件（Heikki Linnakangas）§ 例如，这可能导致在现有会话中无法使用新创建的函数。", "title": "修复可能导致无法将新插入的目录条目添加到目录缓存列表中的竞态条件", "commits": ["fce17c3a5"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "5bee2526f9e4671d257d7d7a9fd5562f6a4c63f6d2b2473e6451ea68af8cf218", "section_path": ["变更"], "commit_groups": [["91fc447c2", "96e61b279", "af8cd1639", "ce7c406f0", "f217c4105", "fce17c3a5"]], "identity_text": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list (Heikki Linnakangas) This could result, for example, in failure to use a newly-created function within an existing session.", "commit_aliases": ["91fc447c2", "96e61b279", "af8cd1639", "ce7c406f0", "f217c4105", "fce17c3a5"], "source_commits": ["fce17c3a5"], "source_entry_id": "14.16/changes/004", "db_id": "ba88944c6494770af7de1c741188a801", "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13", "relations": [{"rule": 2, "type": "equivalent", "target": "428eec456d3609f76929a2b038f85e8a", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}}, {"rule": 2, "type": "equivalent", "target": "819024b2a3054af412673022665b0b12", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}}, {"rule": 2, "type": "equivalent", "target": "cd11a1e538f07e62b6fc668dbd1402ac", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}}, {"rule": 2, "type": "equivalent", "target": "f825fa61541437a3b4bb7f8ede4da592", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f825fa61541437a3b4bb7f8ede4da592", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "修复可能导致无法将新插入的目录条目添加到目录缓存列表中的竞态条件", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}, "url": "/docs/compare/?release=17.3#17.3-d49aa538a89c2e9d", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "819024b2a3054af412673022665b0b12", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "修复可能导致无法将新插入的目录条目添加到目录缓存列表中的竞态条件", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}, "url": "/docs/compare/?release=16.7#16.7-d3e1ddb3e3b864fa", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "428eec456d3609f76929a2b038f85e8a", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "修复可能导致无法将新插入的目录条目添加到目录缓存列表中的竞态条件", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}, "url": "/docs/compare/?release=15.11#15.11-27d7ae34526121f3", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "cd11a1e538f07e62b6fc668dbd1402ac", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "修复可能导致无法将新插入的目录条目添加到目录缓存列表中的竞态条件", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}, "url": "/docs/compare/?release=13.19#13.19-feed443fed43a11e", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-9f57888fe6641937", "cves": [], "html": "防止在系统目录被并发更新时进行 vacuum 可能导致的目录损坏（Noah Misch）§
", "text": "防止在系统目录被并发更新时进行 vacuum 可能导致的目录损坏（Noah Misch）§", "title": "防止在系统目录被并发更新时进行 vacuum 可能导致的目录损坏", "commits": ["25e99483c"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "9c6a54ed28f51dc02401cd3fa41c37f86b829a1f7e6c6bbf17380ff30f9aa699", "section_path": ["变更"], "commit_groups": [["1587f7b9f", "81772a495"], ["25e99483c", "8bfd2ceba", "9311fcb86", "d28cd3e7b", "dc02b98bd", "f4af4515b"]], "identity_text": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update (Noah Misch)", "commit_aliases": ["1587f7b9f", "25e99483c", "81772a495", "8bfd2ceba", "9311fcb86", "d28cd3e7b", "dc02b98bd", "f4af4515b"], "source_commits": ["25e99483c", "81772a495"], "source_entry_id": "14.16/changes/005", "db_id": "e2fc775ae660cbfe5909a35ba85930cf", "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382", "relations": [{"rule": 2, "type": "equivalent", "target": "1c538425f3222136473c1bd1f195a41c", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}}, {"rule": 2, "type": "equivalent", "target": "53e2d4d1a5f179c948796b4a85c497a0", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}}, {"rule": 2, "type": "equivalent", "target": "d552bf163f629e4ce3880b1314bf6e2f", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}}, {"rule": 2, "type": "equivalent", "target": "f3712147b2c17e6407c3aaa1c6b905b5", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "53e2d4d1a5f179c948796b4a85c497a0", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "防止在系统目录被并发更新时进行 vacuum 可能导致的目录损坏", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}, "url": "/docs/compare/?release=17.3#17.3-f3e54e13e653a3e5", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "1c538425f3222136473c1bd1f195a41c", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "防止在系统目录被并发更新时进行 vacuum 可能导致的目录损坏", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}, "url": "/docs/compare/?release=16.7#16.7-a055f3b905c546b3", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "f3712147b2c17e6407c3aaa1c6b905b5", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "防止在系统目录被并发更新时进行 vacuum 可能导致的目录损坏", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}, "url": "/docs/compare/?release=15.11#15.11-a1d8fcc306540815", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "d552bf163f629e4ce3880b1314bf6e2f", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "防止在系统目录被并发更新时进行 vacuum 可能导致的目录损坏", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}, "url": "/docs/compare/?release=13.19#13.19-cb91e58d180e62e3", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-80a213144aae7b2c", "cves": [], "html": "修复关系截断失败时的数据损坏问题（Thomas Munro）§ § §
\n执行关系截断所需的文件系统调用可能会失败，导致磁盘上留下不一致的状态（例如，实际上恢复了已删除的数据）。我们无法真正阻止这种情况，但可以通过将此类失败提升为 PANIC 来进行恢复，这样可以通过从 WAL 重放到尝试截断之前来恢复一致性。这并不是一个非常理想的行为，但由于此类失败足够罕见，因此似乎是一个可以接受的解决方案。
", "text": "修复关系截断失败时的数据损坏问题（Thomas Munro）§ § § 执行关系截断所需的文件系统调用可能会失败，导致磁盘上留下不一致的状态（例如，实际上恢复了已删除的数据）。我们无法真正阻止这种情况，但可以通过将此类失败提升为 PANIC 来进行恢复，这样可以通过从 WAL 重放到尝试截断之前来恢复一致性。这并不是一个非常理想的行为，但由于此类失败足够罕见，因此似乎是一个可以接受的解决方案。", "title": "修复关系截断失败时的数据损坏问题", "commits": ["049c8cb9a", "23c743b64", "f154f028d"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "4a28a9788fa4390a6bf779a37cc8f84459f427f5a8a6cd8b433ed6f62768543d", "section_path": ["变更"], "commit_groups": [["0350b876b", "228091216", "23c743b64", "38c579b08", "ba02d24ba", "fb540b6aa"], ["049c8cb9a", "190054e61", "417d41c65", "45aef9f6b", "9defaaa1d"], ["3181befdc", "66aaabe7a", "a1d17a894", "c957d7444", "f154f028d"]], "identity_text": "Fix data corruption when relation truncation fails (Thomas Munro) The filesystem calls needed to perform relation truncation could fail, leaving inconsistent state on disk (for example, effectively reviving deleted data). We can't really prevent that, but we can recover by dint of making such failures into PANICs, so that consistency is restored by replaying from WAL up to just before the attempted truncation. This isn't a hugely desirable behavior, but such failures are rare enough that it seems an acceptable solution.", "commit_aliases": ["0350b876b", "049c8cb9a", "190054e61", "228091216", "23c743b64", "3181befdc", "38c579b08", "417d41c65", "45aef9f6b", "66aaabe7a", "9defaaa1d", "a1d17a894", "ba02d24ba", "c957d7444", "f154f028d", "fb540b6aa"], "source_commits": ["049c8cb9a", "23c743b64", "f154f028d"], "source_entry_id": "14.16/changes/006", "db_id": "29a3dd579cd7acb075f4eb7f34cadf6d", "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90", "relations": [{"rule": 2, "type": "equivalent", "target": "6e2d54cee98be477c06d5503209286d2", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}}, {"rule": 2, "type": "equivalent", "target": "a705757c88e8dc114469492bca11380e", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}}, {"rule": 2, "type": "equivalent", "target": "affd693034e908911e8335280c40337c", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}}, {"rule": 2, "type": "equivalent", "target": "c876272e00edeea60adb978f3ab1e194", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c876272e00edeea60adb978f3ab1e194", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "修复关系截断失败时的数据损坏问题", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}, "url": "/docs/compare/?release=17.3#17.3-1628e1c1870a7451", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "a705757c88e8dc114469492bca11380e", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "修复关系截断失败时的数据损坏问题", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}, "url": "/docs/compare/?release=16.7#16.7-adc6f7d2ce7990fa", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "6e2d54cee98be477c06d5503209286d2", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "修复关系截断失败时的数据损坏问题", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}, "url": "/docs/compare/?release=15.11#15.11-bfc0aa4fc8a74702", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "affd693034e908911e8335280c40337c", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "修复关系截断失败时的数据损坏问题", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}, "url": "/docs/compare/?release=13.19#13.19-122ddb0a90db2f62", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-c9b2392b6b20c044", "cves": [], "html": "防止在关系截断期间启动检查点（Robert Haas）§
\n这避免了一种竞态条件，即修改后的文件可能在完成检查点之前未被 fsync，从而在操作系统崩溃后不久产生数据损坏的风险。
", "text": "防止在关系截断期间启动检查点（Robert Haas）§ 这避免了一种竞态条件，即修改后的文件可能在完成检查点之前未被 fsync，从而在操作系统崩溃后不久产生数据损坏的风险。", "title": "防止在关系截断期间启动检查点", "commits": ["7d0b91a28"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "234d96f93ac9724f49b9393c66ba9361a991862b33d9b01056b794ce255684df", "section_path": ["变更"], "commit_groups": [["1168acbca", "75818b3af", "7d0b91a28", "a501fe5a9", "ad5aa7bfd", "d4ffbf47b"]], "identity_text": "Prevent checkpoints from starting during relation truncation (Robert Haas) This avoids a race condition wherein the modified file might not get fsync'd before completing the checkpoint, creating a risk of data corruption if the operating system crashes soon after.", "commit_aliases": ["1168acbca", "75818b3af", "7d0b91a28", "a501fe5a9", "ad5aa7bfd", "d4ffbf47b"], "source_commits": ["7d0b91a28"], "source_entry_id": "14.16/changes/007", "db_id": "563d9f0f77b3eee26c49723296ec9b79", "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d", "relations": [{"rule": 2, "type": "equivalent", "target": "470f2470a3f35434fb1d59ff2b3944f7", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}}, {"rule": 2, "type": "equivalent", "target": "48e63346cf5f2bd983ad4aa906ad04c3", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}}, {"rule": 2, "type": "equivalent", "target": "a574173fa6e03fae58fa4d27b0e1c766", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}}, {"rule": 2, "type": "equivalent", "target": "b014a39e8931c48ade8177ec91e5da8e", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "a574173fa6e03fae58fa4d27b0e1c766", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "防止在关系截断期间启动检查点", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}, "url": "/docs/compare/?release=17.3#17.3-39227326b9aa5e8e", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "48e63346cf5f2bd983ad4aa906ad04c3", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "防止在关系截断期间启动检查点", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}, "url": "/docs/compare/?release=16.7#16.7-d552b4e09791f05c", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "470f2470a3f35434fb1d59ff2b3944f7", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "防止在关系截断期间启动检查点", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}, "url": "/docs/compare/?release=15.11#15.11-be8211ced912411c", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "b014a39e8931c48ade8177ec91e5da8e", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "防止在关系截断期间启动检查点", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}, "url": "/docs/compare/?release=13.19#13.19-e9956e400bc3e5e5", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-cf11062efb42b6e9", "cves": [], "html": "使用 rename() 而非 link()/unlink() 来重命名文件（Nathan Bossart）§
之前的代码旨在确保操作不会意外覆盖已有文件。但是失败可能会留下两个指向同一文件的链接，使后续操作混乱并产生数据损坏的风险。在实践中，我们不会在目标文件名可能已存在的地方使用此功能，因此放弃不覆盖保证以消除多链接风险似乎更好。
", "text": "使用 rename() 而非 link()/unlink() 来重命名文件（Nathan Bossart）§ 之前的代码旨在确保操作不会意外覆盖已有文件。但是失败可能会留下两个指向同一文件的链接，使后续操作混乱并产生数据损坏的风险。在实践中，我们不会在目标文件名可能已存在的地方使用此功能，因此放弃不覆盖保证以消除多链接风险似乎更好。", "title": "使用 rename() 而非 link()/unlink() 来重命名文件", "commits": ["c1c9df315"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "3706e221eee7fc09f7189ec1f31969b4ac80723ef2131e0c7c949a368e08e95e", "section_path": ["变更"], "commit_groups": [["1f95181b4", "26a79cbbd", "c1c9df315", "dac1ff309"]], "identity_text": "Use rename() not link()/unlink() to rename files (Nathan Bossart) The previous coding was intended to assure that the operation could not accidentally overwrite an existing file. However a failure could leave two links to the same file in existence, confusing subsequent operations and creating a risk of data corruption. In practice we do not use this functionality in places where the target filename could already exist, so it seems better to give up the no-overwrite guarantee to remove the multiple-link hazard.", "commit_aliases": ["1f95181b4", "26a79cbbd", "c1c9df315", "dac1ff309"], "source_commits": ["1f95181b4"], "source_entry_id": "14.16/changes/008", "db_id": "39a7ea01a72b25c8dba644abeeb8c8a0", "patch_ids": ["647bc3d9af3144dd436efb4674b73822"], "statement_hash": "9f134bed941f02dcfd4adebe143f7523720bf49e3095a5cf7e7364d20b3df4d6", "relations": [{"rule": 2, "type": "equivalent", "target": "09f32c6598ce32f4f080055b3dcfe189", "evidence": {"same_day": true, "patch_ids": ["647bc3d9af3144dd436efb4674b73822"], "statement_hash": "9f134bed941f02dcfd4adebe143f7523720bf49e3095a5cf7e7364d20b3df4d6"}}, {"rule": 2, "type": "equivalent", "target": "1cb6f6430785de32d8a1aea92346cfff", "evidence": {"same_day": true, "patch_ids": ["647bc3d9af3144dd436efb4674b73822"], "statement_hash": "9f134bed941f02dcfd4adebe143f7523720bf49e3095a5cf7e7364d20b3df4d6"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1cb6f6430785de32d8a1aea92346cfff", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "使用 rename() 而非 link()/unlink() 来重命名文件", "evidence": {"same_day": true, "patch_ids": ["647bc3d9af3144dd436efb4674b73822"], "statement_hash": "9f134bed941f02dcfd4adebe143f7523720bf49e3095a5cf7e7364d20b3df4d6"}, "url": "/docs/compare/?release=15.11#15.11-cf11062efb42b6e9", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "09f32c6598ce32f4f080055b3dcfe189", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "使用 rename() 而非 link()/unlink() 来重命名文件", "evidence": {"same_day": true, "patch_ids": ["647bc3d9af3144dd436efb4674b73822"], "statement_hash": "9f134bed941f02dcfd4adebe143f7523720bf49e3095a5cf7e7364d20b3df4d6"}, "url": "/docs/compare/?release=13.19#13.19-b5dce7e171563407", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-3c647ec0597ac4c4", "cves": [], "html": "避免在 VACUUM 与更改该数据库所有者的 REASSIGN OWNED 并发运行时可能丢失 pg_database.datfrozenxid 更新（Kirill Reshke）§
修复传递给 AFTER UPDATE 触发器的不正确 tg_updatedcols 值（Tom Lane）§
在某些情况下，tg_updatedcols 位图可能描述的是同一事务中较早命令更新的列集合，从而导致触发器做出错误的操作。
同时，防止由于制作过多 tg_updatedcols 位图副本而导致的内存膨胀。
修复 to_timestamp 的 FF 格式代码的错误处理（Tom Lane）§n
紧接在 FF 之前的整数格式代码会消耗所有可用数字，导致 nFF 没有剩余数字可用。n
在反解析 XMLTABLE() 表达式时，确保必要时对 XML 命名空间名称进行双引号引用（Dean Rasheed）§
在 pg_hba_file_rules() 输出中包含 ldapscheme 选项（Laurenz Albe）§ §
当列排序规则不一致时不合并 UNION 操作（Tom Lane）§
之前在判断是否可以安全地将 UNION 步骤合并为单个 N 路 UNION 操作时忽略了排序规则。在引入非确定性排序规则之前这可能是合理的，但现在不再如此，因为使用中的排序规则可以影响唯一性的定义。
修复分区剪枝步骤中遗漏的表达式处理（Tom Lane）§
\n此疏忽可能导致在访问分区表的查询中出现 “unrecognized node type” 错误以及其他可能的问题。
", "text": "修复分区剪枝步骤中遗漏的表达式处理（Tom Lane）§ 此疏忽可能导致在访问分区表的查询中出现 “unrecognized node type” 错误以及其他可能的问题。", "title": "修复分区剪枝步骤中遗漏的表达式处理", "commits": ["5f725648f"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "21c3e74b4b79b5cbaba6f9b11567fbc3ff163cb5562a24fd5ed2de948a7085d3", "section_path": ["变更"], "commit_groups": [["0671a71e0", "45004f527", "5f725648f", "724ebebb1", "94c02bd33", "bf826ea06"]], "identity_text": "Fix missed expression processing for partition pruning steps (Tom Lane) This oversight could lead to unrecognized node type errors, and perhaps other problems, in queries accessing partitioned tables.", "commit_aliases": ["0671a71e0", "45004f527", "5f725648f", "724ebebb1", "94c02bd33", "bf826ea06"], "source_commits": ["5f725648f"], "source_entry_id": "14.16/changes/015", "db_id": "d03371888cc7150b3deafc4ad1b65c61", "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b", "relations": [{"rule": 2, "type": "equivalent", "target": "54bec316da2ce059adbac0a0dbc8e9b6", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}}, {"rule": 2, "type": "equivalent", "target": "64aaf6067e2f499a849b519969ab7e4b", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}}, {"rule": 2, "type": "equivalent", "target": "92378b1193935bbe98423ded57c0f7a0", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}}, {"rule": 2, "type": "equivalent", "target": "f57a46c5163b3e5919b130be79f25ce5", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "54bec316da2ce059adbac0a0dbc8e9b6", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "修复分区剪枝步骤中遗漏的表达式处理", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}, "url": "/docs/compare/?release=17.3#17.3-13c2873d21939448", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "92378b1193935bbe98423ded57c0f7a0", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "修复分区剪枝步骤中遗漏的表达式处理", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}, "url": "/docs/compare/?release=16.7#16.7-7e432f19a9f91448", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "f57a46c5163b3e5919b130be79f25ce5", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "修复分区剪枝步骤中遗漏的表达式处理", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}, "url": "/docs/compare/?release=15.11#15.11-126d9ceb0a19d1f7", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "64aaf6067e2f499a849b519969ab7e4b", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "修复分区剪枝步骤中遗漏的表达式处理", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}, "url": "/docs/compare/?release=13.19#13.19-bb60e571dcd1116e", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-d37432d80add9128", "cves": [], "html": "允许 dshash 表增长超过 1GB（Matthias van de Meent）§
\n这避免了诸如 “invalid DSA memory alloc request size” 之类的错误。例如，在处理数百万个表的事务中可能会出现这种情况。
", "text": "允许 dshash 表增长超过 1GB（Matthias van de Meent）§ 这避免了诸如 “invalid DSA memory alloc request size” 之类的错误。例如，在处理数百万个表的事务中可能会出现这种情况。", "title": "允许 dshash 表增长超过 1GB", "commits": ["84dc1303c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "977b6ed1cb7297ada9f22891e239cd23aaec8109a75fc501917c19872f3072a2", "section_path": ["变更"], "commit_groups": [["18452b70a", "2a7402322", "84dc1303c", "84f1b0b03", "853cef097", "9f7b7d516"]], "identity_text": "Allow dshash tables to grow past 1GB (Matthias van de Meent) This avoids errors like invalid DSA memory alloc request size. The case can occur for example in transactions that process several million tables.", "commit_aliases": ["18452b70a", "2a7402322", "84dc1303c", "84f1b0b03", "853cef097", "9f7b7d516"], "source_commits": ["84dc1303c"], "source_entry_id": "14.16/changes/016", "db_id": "559be1008e5dc3b8471a163d74e0e555", "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8", "relations": [{"rule": 2, "type": "equivalent", "target": "6356be9dc3a4ccb3d25583a601b052d7", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}}, {"rule": 2, "type": "equivalent", "target": "c1707a3dbd154a011972a406a0fe3177", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}}, {"rule": 2, "type": "equivalent", "target": "c32bee4d5d51b2dfdb45db1d2db22cb1", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}}, {"rule": 2, "type": "equivalent", "target": "c51c9c918546c72f7a773592db3d7108", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "6356be9dc3a4ccb3d25583a601b052d7", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "允许 dshash 表增长超过 1GB", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}, "url": "/docs/compare/?release=17.3#17.3-01e60c1471a16974", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "c1707a3dbd154a011972a406a0fe3177", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "允许 dshash 表增长超过 1GB", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}, "url": "/docs/compare/?release=16.7#16.7-0c925e1e9ecd0922", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "c32bee4d5d51b2dfdb45db1d2db22cb1", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "允许 dshash 表增长超过 1GB", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}, "url": "/docs/compare/?release=15.11#15.11-bd0deef2a9ca340c", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "c51c9c918546c72f7a773592db3d7108", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "允许 dshash 表增长超过 1GB", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}, "url": "/docs/compare/?release=13.19#13.19-6c810fa8b81fd565", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-b175488683721a19", "cves": [], "html": "避免 bringetbitmap() 中可能的整数溢出（James Hunter，Evgeniy Gorbanyov）§
由于结果仅用于统计目的，此错误的影响大多是修饰性的。
", "text": "避免 bringetbitmap() 中可能的整数溢出（James Hunter，Evgeniy Gorbanyov）§ 由于结果仅用于统计目的，此错误的影响大多是修饰性的。", "title": "避免 bringetbitmap() 中可能的整数溢出", "commits": ["e35ff6520"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "cb293a7eed587f2941ae19ff7b5bb525961dc8ba9c0c04c3a6cd449c541c5ce6", "section_path": ["变更"], "commit_groups": [["332023e2d", "720e52984", "9e9f30139", "bfda7d8dd", "e027ee990", "e35ff6520"]], "identity_text": "Avoid possible integer overflow in bringetbitmap() (James Hunter, Evgeniy Gorbanyov) Since the result is only used for statistical purposes, the effects of this error were mostly cosmetic.", "commit_aliases": ["332023e2d", "720e52984", "9e9f30139", "bfda7d8dd", "e027ee990", "e35ff6520"], "source_commits": ["e35ff6520"], "source_entry_id": "14.16/changes/017", "db_id": "4c0001cec4b021e935b71b3a37aa73fe", "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec", "relations": [{"rule": 2, "type": "equivalent", "target": "1fe83d7e0b7aa17a1f0f729b4a0c12f0", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}}, {"rule": 2, "type": "equivalent", "target": "3382e0a80f8ca0563eb8cac40f2d851b", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}}, {"rule": 2, "type": "equivalent", "target": "3c029255e641bec15f2ee6842ff93a77", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}}, {"rule": 2, "type": "equivalent", "target": "921aaf580d2aca9ce93450c0492e7423", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "3382e0a80f8ca0563eb8cac40f2d851b", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "避免 bringetbitmap() 中可能的整数溢出", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}, "url": "/docs/compare/?release=17.3#17.3-a04d6e576513146f", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "921aaf580d2aca9ce93450c0492e7423", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "避免 bringetbitmap() 中可能的整数溢出", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}, "url": "/docs/compare/?release=16.7#16.7-b97ed85237994136", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "1fe83d7e0b7aa17a1f0f729b4a0c12f0", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "避免 bringetbitmap() 中可能的整数溢出", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}, "url": "/docs/compare/?release=15.11#15.11-4f9db6103a233435", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "3c029255e641bec15f2ee6842ff93a77", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "避免 bringetbitmap() 中可能的整数溢出", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}, "url": "/docs/compare/?release=13.19#13.19-65695708975bb439", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-b3b12c0bad0d0bc8", "cves": [], "html": "防止流复制备库在读取跨页的 WAL 记录时无限循环（Kyotaro Horiguchi，Alexander Kukushkin）§
\n当记录的后续部分位于需要从不同 WAL 源读取的页面上时会发生此问题。
", "text": "防止流复制备库在读取跨页的 WAL 记录时无限循环（Kyotaro Horiguchi，Alexander Kukushkin）§ 当记录的后续部分位于需要从不同 WAL 源读取的页面上时会发生此问题。", "title": "防止流复制备库在读取跨页的 WAL 记录时无限循环", "commits": ["a2d4f806c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "69d9c5c84f232ce45b69a9310774bcca503f240a2bbdba511af141859c6f3045", "section_path": ["变更"], "commit_groups": [["0f0431e91", "26554facc", "2c2e1d4f4", "6cf1647d8", "a2d4f806c", "e6767c0ed"]], "identity_text": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages (Kyotaro Horiguchi, Alexander Kukushkin) This would happen when the record's continuation is on a page that needs to be read from a different WAL source.", "commit_aliases": ["0f0431e91", "26554facc", "2c2e1d4f4", "6cf1647d8", "a2d4f806c", "e6767c0ed"], "source_commits": ["a2d4f806c"], "source_entry_id": "14.16/changes/018", "db_id": "76f611c374c0323f13dc341fb4721c32", "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac", "relations": [{"rule": 2, "type": "equivalent", "target": "44f9cbeda7bc216ab467698d3eef592e", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}}, {"rule": 2, "type": "equivalent", "target": "6659c5f8e0df6f1f962f8df015c68b49", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}}, {"rule": 2, "type": "equivalent", "target": "67dafb471f2271a6320dfe0f290a0ce0", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}}, {"rule": 2, "type": "equivalent", "target": "fdc72a7668046cce65c8c39dedeb9249", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "6659c5f8e0df6f1f962f8df015c68b49", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "防止流复制备库在读取跨页的 WAL 记录时无限循环", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}, "url": "/docs/compare/?release=17.3#17.3-e9e73d99c1cfb098", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "44f9cbeda7bc216ab467698d3eef592e", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "防止流复制备库在读取跨页的 WAL 记录时无限循环", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}, "url": "/docs/compare/?release=16.7#16.7-df1eee243145f866", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "67dafb471f2271a6320dfe0f290a0ce0", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "防止流复制备库在读取跨页的 WAL 记录时无限循环", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}, "url": "/docs/compare/?release=15.11#15.11-9354a205b1e1b91e", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "fdc72a7668046cce65c8c39dedeb9249", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "防止流复制备库在读取跨页的 WAL 记录时无限循环", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}, "url": "/docs/compare/?release=13.19#13.19-4169e9202c255d82", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-21c46392869cd7a2", "cves": [], "html": "改进存在大量状态文件时归档进程的性能（Nathan Bossart）§
\n此变更回移了最初在 v15 中进行的修复，以回应归档性能极差导致停机或副本丢失的报告。
", "text": "改进存在大量状态文件时归档进程的性能（Nathan Bossart）§ 此变更回移了最初在 v15 中进行的修复，以回应归档性能极差导致停机或副本丢失的报告。", "title": "改进存在大量状态文件时归档进程的性能", "commits": ["4abf615cc"], "section": "变更", "category": "performance", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "b60cf2cc74733b4505043aa1366c6fff88334beae03d0b9aeade93dc9675a91e", "section_path": ["变更"], "commit_groups": [["4abf615cc"]], "identity_text": "Improve performance of archiver process with many status files (Nathan Bossart) This change back-patches a fix originally made in v15, in response to reports of extremely poor archiving performance leading to downtime or loss of replicas.", "commit_aliases": ["4abf615cc"], "source_commits": ["4abf615cc"], "source_entry_id": "14.16/changes/019", "db_id": "4e347ad4bc0934aa6c5f19b1114a06c4", "patch_ids": ["e4ac2a3c1e7c73dbb941e955ca178d82"], "statement_hash": "1f0670bb80381d6f8b93cf5e81981a92a6fc3f2a5744a662c6779d33893b1c5e", "relations": [], "version": "14.16", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "14.16-a449a8f550e33341", "cves": [], "html": "修复在进程早期启动阶段 FATAL 错误被意外提升为 PANIC 的问题（Noah Misch）§
\n这修复了一些不太可能发生的情况，这些情况会导致 “PANIC: proc_exit() called in child process”。
", "text": "修复在进程早期启动阶段 FATAL 错误被意外提升为 PANIC 的问题（Noah Misch）§ 这修复了一些不太可能发生的情况，这些情况会导致 “PANIC: proc_exit() called in child process”。", "title": "修复在进程早期启动阶段 FATAL 错误被意外提升为 PANIC 的问题", "commits": ["315264d70"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "7240bfd00ee218fbc06c41c75526066fabd15ca24f9223e6fc2525552f45061c", "section_path": ["变更"], "commit_groups": [["315264d70", "4bd9de3f4", "6151769f6", "839da50bd", "8b9cbf492", "ac4a2b403"]], "identity_text": "Fix unintended promotion of FATAL errors to PANIC during early process startup (Noah Misch) This fixes some unlikely cases that would result in PANIC: proc_exit() called in child process.", "commit_aliases": ["315264d70", "4bd9de3f4", "6151769f6", "839da50bd", "8b9cbf492", "ac4a2b403"], "source_commits": ["315264d70"], "source_entry_id": "14.16/changes/020", "db_id": "f984d853bfadab0b79bd0501cc75f59c", "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4", "relations": [{"rule": 2, "type": "equivalent", "target": "93eca6f7915b54f74b93e375c2513842", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}}, {"rule": 2, "type": "equivalent", "target": "b14c042be747a937c3c74162b1b09321", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}}, {"rule": 2, "type": "equivalent", "target": "da9210bd08299df78861342f7e09c5d9", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}}, {"rule": 2, "type": "equivalent", "target": "fc52476d2fcf5579cadcfd273916020c", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "93eca6f7915b54f74b93e375c2513842", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "修复在进程早期启动阶段 FATAL 错误被意外提升为 PANIC 的问题", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}, "url": "/docs/compare/?release=17.3#17.3-96bd4a8fad85c533", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "b14c042be747a937c3c74162b1b09321", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "修复在进程早期启动阶段 FATAL 错误被意外提升为 PANIC 的问题", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}, "url": "/docs/compare/?release=16.7#16.7-795da8c683c4ad88", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "da9210bd08299df78861342f7e09c5d9", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "修复在进程早期启动阶段 FATAL 错误被意外提升为 PANIC 的问题", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}, "url": "/docs/compare/?release=15.11#15.11-e74c5a37c2620a7b", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "fc52476d2fcf5579cadcfd273916020c", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "修复在进程早期启动阶段 FATAL 错误被意外提升为 PANIC 的问题", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}, "url": "/docs/compare/?release=13.19#13.19-e7ab576b34d2feae", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-59648940f61270ce", "cves": [], "html": "修复操作符族成员操作符或支持函数可能成为悬空引用的情况（Tom Lane）§ §
\n在某些情况下，数据类型可能在其 OID 引用仍然存在于 pg_amop 或 pg_amproc 中时被删除。虽然这不会立即造成问题，但尝试删除所属操作符族会失败，并且 pg_dump 在导出该操作符族时会产生错误的输出。此修复使操作符族/类的创建和修改添加必要的依赖条目，以便删除数据类型时也会删除任何依赖的操作符族元素。但这对已存在的有问题的操作符族没有帮助，因此还在 DROP OPERATOR FAMILY 中增加了一个应急措施，以防止在删除具有悬空成员的族时失败。
修复逻辑解码输出中的多个内存泄漏（Vignesh C，Masahiko Sawada，Boyu Yang）§ §
", "text": "修复逻辑解码输出中的多个内存泄漏（Vignesh C，Masahiko Sawada，Boyu Yang）§ §", "title": "修复逻辑解码输出中的多个内存泄漏", "commits": ["c53d90bb4", "cfd6cbcf9"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "f70c1175218f8a6dc8fb5480fb70d61d312c25ab85802d0397261bfff4a6cf29", "section_path": ["变更"], "commit_groups": [["4d45e7490", "6c9b39754", "ba230ce40", "bbe68c13a", "cfd6cbcf9"], ["6fc30c24c", "afe9b0d9f", "e749eaf46", "ea792bfd9"], ["836435424", "a786cf04d", "c53d90bb4", "c9b3d4909", "da8bd5d42", "e3a27fd06"]], "identity_text": "Fix multiple memory leaks in logical decoding output (Vignesh C, Masahiko Sawada, Boyu Yang)", "commit_aliases": ["4d45e7490", "6c9b39754", "6fc30c24c", "836435424", "a786cf04d", "afe9b0d9f", "ba230ce40", "bbe68c13a", "c53d90bb4", "c9b3d4909", "cfd6cbcf9", "da8bd5d42", "e3a27fd06", "e749eaf46", "ea792bfd9"], "source_commits": ["c53d90bb4", "cfd6cbcf9", "ea792bfd9"], "source_entry_id": "14.16/changes/022", "db_id": "7b50a2183c182642d28afec0183d605b", "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3", "relations": [{"rule": 2, "type": "equivalent", "target": "13d179398909add9970f46ab481b9189", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}}, {"rule": 2, "type": "equivalent", "target": "4d10718ab097a65a0eb68ddf6be4859c", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}}, {"rule": 2, "type": "equivalent", "target": "72d566e30a8d7b411efea718bcd02235", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}}, {"rule": 2, "type": "equivalent", "target": "d3be3c9794f3530e444e4a59e5badd78", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "72d566e30a8d7b411efea718bcd02235", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "修复逻辑解码输出中的多个内存泄漏", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}, "url": "/docs/compare/?release=17.3#17.3-f8da83cc6b6fcff8", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "13d179398909add9970f46ab481b9189", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "修复逻辑解码输出中的多个内存泄漏", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}, "url": "/docs/compare/?release=16.7#16.7-8a82d9eb7b056fa3", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "d3be3c9794f3530e444e4a59e5badd78", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "修复逻辑解码输出中的多个内存泄漏", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}, "url": "/docs/compare/?release=15.11#15.11-4ddb503d2428c1e4", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "4d10718ab097a65a0eb68ddf6be4859c", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "修复逻辑解码输出中的多个内存泄漏", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}, "url": "/docs/compare/?release=13.19#13.19-fbacd441376f2672", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-1a6af517d68e9a14", "cves": [], "html": "避免在内存不足时由于缺少对 malloc() 失败返回的检查而导致的低概率崩溃（Karina Litskevich）§
避免在测试 wal_skip_threshold 条件时的整数溢出（Tom Lane）§
创建非常大的关系的事务可能会错误地决定通过将关系复制到 WAL 而非 fsync 来确保持久性，从而否定了 wal_skip_threshold 的意义。（这仅在 wal_level 设置为 minimal 时才有影响，否则无论如何都需要 WAL 复制。）
修复缓存查找期间不安全的操作顺序（Noah Misch）§
\n唯一已知的后果是在 GRANT TABLESPACE 期间出现通常无害的 “you don't own a lock of type ExclusiveLock” 警告。
修复在较旧 ARM 平台上使用 JIT 时可能出现的 “failed to resolve name” 失败（Thomas Munro）§
\n这可能是由于 gcc 和 clang 之间对 -moutline-atomics 默认设置不一致导致的。至少已知 Debian 和 Ubuntu 提供了针对 armv8-a 的 gcc 和 clang 编译器，但它们在默认使用 outline atomics 方面存在差异。
修复非 PostgreSQL 来源的 Windows 连接点的处理（Thomas Munro）§ §
\n之前，如果数据目录的路径包含展开后不是“驱动器绝对路径”格式的连接点，或其展开指向另一个连接点，initdb 将会失败。
", "text": "修复非 PostgreSQL 来源的 Windows 连接点的处理（Thomas Munro）§ § 之前，如果数据目录的路径包含展开后不是“驱动器绝对路径”格式的连接点，或其展开指向另一个连接点，initdb 将会失败。", "title": "修复非 PostgreSQL 来源的 Windows 连接点的处理", "commits": ["9b136b0f2", "e708f3188"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "bb8c6b0e37a06c94cfad520169a53a0b583f544b507c443ea45fe6c951ee20f7", "section_path": ["变更"], "commit_groups": [["2c4a532c9", "9b136b0f2", "f4fd5325c"], ["9f1c67488", "e708f3188", "fbf8efbda"]], "identity_text": "Fix handling of Windows junction points that are not of PostgreSQL origin (Thomas Munro) Previously, initdb would fail if the path to the data directory included junction points whose expansion isn't in drive absolute format, or whose expansion points to another junction point.", "commit_aliases": ["2c4a532c9", "9b136b0f2", "9f1c67488", "e708f3188", "f4fd5325c", "fbf8efbda"], "source_commits": ["9f1c67488", "f4fd5325c"], "source_entry_id": "14.16/changes/027", "db_id": "a87bed9fadd3cd8b0b628a71677cdff1", "patch_ids": ["621af65a7e189083e0ca89afc829497a", "cdd071d0fb6ca39ab63d4507f00af8dd"], "statement_hash": "29ff7d78572b67076328324c657ff9d506d54a8673ec94a8a167dac2a5944cfd", "relations": [{"rule": 2, "type": "equivalent", "target": "08b37ac16479d98b0d6ec10432356427", "evidence": {"same_day": true, "patch_ids": ["621af65a7e189083e0ca89afc829497a", "cdd071d0fb6ca39ab63d4507f00af8dd"], "statement_hash": "29ff7d78572b67076328324c657ff9d506d54a8673ec94a8a167dac2a5944cfd"}}, {"rule": 2, "type": "equivalent", "target": "4c7bc05110690f40da575a72bed63419", "evidence": {"same_day": true, "patch_ids": ["621af65a7e189083e0ca89afc829497a", "cdd071d0fb6ca39ab63d4507f00af8dd"], "statement_hash": "29ff7d78572b67076328324c657ff9d506d54a8673ec94a8a167dac2a5944cfd"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "08b37ac16479d98b0d6ec10432356427", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "修复非 PostgreSQL 来源的 Windows 连接点的处理", "evidence": {"same_day": true, "patch_ids": ["621af65a7e189083e0ca89afc829497a", "cdd071d0fb6ca39ab63d4507f00af8dd"], "statement_hash": "29ff7d78572b67076328324c657ff9d506d54a8673ec94a8a167dac2a5944cfd"}, "url": "/docs/compare/?release=15.11#15.11-910218fa434a8fd2", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "4c7bc05110690f40da575a72bed63419", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "修复非 PostgreSQL 来源的 Windows 联接点的处理", "evidence": {"same_day": true, "patch_ids": ["621af65a7e189083e0ca89afc829497a", "cdd071d0fb6ca39ab63d4507f00af8dd"], "statement_hash": "29ff7d78572b67076328324c657ff9d506d54a8673ec94a8a167dac2a5944cfd"}, "url": "/docs/compare/?release=13.19#13.19-9eaf8741fb72035a", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-240c61ebb38c4a89", "cves": [], "html": "修复 WITH RECURSIVE ... UNION 查询中的断言失败（David Rowley）§
避免在集合操作叶查询包含集合操作时规则反解析中的断言失败（Man Zeng，Tom Lane）§
", "text": "避免在集合操作叶查询包含集合操作时规则反解析中的断言失败（Man Zeng，Tom Lane）§", "title": "避免在集合操作叶查询包含集合操作时规则反解析中的断言失败", "commits": ["3eb26524c"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "3b2d401cc6bed4d69c22747007e13c553b8f5265ea9bd673d63ffbc3465230d3", "section_path": ["变更"], "commit_groups": [["3eb26524c", "630520c22", "94131cd53", "9b9689e26", "fe084039e", "fea81aee8"]], "identity_text": "Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations (Man Zeng, Tom Lane)", "commit_aliases": ["3eb26524c", "630520c22", "94131cd53", "9b9689e26", "fe084039e", "fea81aee8"], "source_commits": ["3eb26524c"], "source_entry_id": "14.16/changes/029", "db_id": "788662ba7d1019b44607912fceb78494", "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6", "relations": [{"rule": 2, "type": "equivalent", "target": "430ea600c60e03d11df898e94770372a", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}}, {"rule": 2, "type": "equivalent", "target": "50000347e8a508f0aaef39e9f6f46b3a", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}}, {"rule": 2, "type": "equivalent", "target": "7f4412cd75dc72714d7ab2bc7274e4b1", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}}, {"rule": 2, "type": "equivalent", "target": "fb21bd83fba5eb8385f3edc1dbf0a7f3", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "fb21bd83fba5eb8385f3edc1dbf0a7f3", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "避免在集合操作叶查询包含集合操作时规则反解析中的断言失败", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}, "url": "/docs/compare/?release=17.3#17.3-298a145035b17ae1", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "7f4412cd75dc72714d7ab2bc7274e4b1", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "避免在集合操作叶查询包含集合操作时规则反解析中的断言失败", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}, "url": "/docs/compare/?release=16.7#16.7-64b8371eaf4d37e0", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "50000347e8a508f0aaef39e9f6f46b3a", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "避免在集合操作叶查询包含集合操作时规则反解析中的断言失败", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}, "url": "/docs/compare/?release=15.11#15.11-9782e96a5d6e6210", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "430ea600c60e03d11df898e94770372a", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "避免在集合操作叶查询包含集合操作时规则反解析中的断言失败", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}, "url": "/docs/compare/?release=13.19#13.19-5492d6a199377d8e", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-89a40fa712bb947f", "cves": [], "html": "避免并行查询启动时的边界情况断言失败（Tom Lane）§
", "text": "避免并行查询启动时的边界情况断言失败（Tom Lane）§", "title": "避免并行查询启动时的边界情况断言失败", "commits": ["8a95ad3b2"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "26e3377037e8ad108e917227b9bbf3b40c9570bb117fc9868294b44326d9aaa2", "section_path": ["变更"], "commit_groups": [["3eea7a0c9", "4089b9bd6", "4d20bad5e", "556f7b7bc", "8a95ad3b2", "bb649b553"]], "identity_text": "Avoid edge-case assertion failure in parallel query startup (Tom Lane)", "commit_aliases": ["3eea7a0c9", "4089b9bd6", "4d20bad5e", "556f7b7bc", "8a95ad3b2", "bb649b553"], "source_commits": ["8a95ad3b2"], "source_entry_id": "14.16/changes/030", "db_id": "f773276377191676df7c3642b74798a8", "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7", "relations": [{"rule": 2, "type": "equivalent", "target": "3abae71410ce108faa00b2da6ec38a1a", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}}, {"rule": 2, "type": "equivalent", "target": "afb62e2219d6171b37153e1b07c79a3c", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}}, {"rule": 2, "type": "equivalent", "target": "bfd249fdf1d29e1a2671b588f5c25368", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}}, {"rule": 2, "type": "equivalent", "target": "fd91c149b0074746d42181c8ca343d83", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "afb62e2219d6171b37153e1b07c79a3c", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "避免并行查询启动时的边界情况断言失败", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}, "url": "/docs/compare/?release=17.3#17.3-722a0397cafeb199", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "3abae71410ce108faa00b2da6ec38a1a", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "避免并行查询启动时的边界情况断言失败", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}, "url": "/docs/compare/?release=16.7#16.7-98a37c42135391b3", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "bfd249fdf1d29e1a2671b588f5c25368", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "避免并行查询启动时的边界情况断言失败", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}, "url": "/docs/compare/?release=15.11#15.11-5e432f4b08cbf92e", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "fd91c149b0074746d42181c8ca343d83", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "避免并行查询启动时的边界情况断言失败", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}, "url": "/docs/compare/?release=13.19#13.19-382281fdd907f983", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-0e70592b47df05ca", "cves": [], "html": "在 NULLIF() 中，避免将可读写的扩展对象指针传递给数据类型的等值函数（Tom Lane）§
如果给定可读写指针，等值函数可能会修改或删除该对象，如果我们随后决定将其作为 NULLIF() 的结果返回，这将是有问题的。对于任何内置等值函数可能没有问题，但用 PL/pgSQL 编写的函数很容易展示出故障。
确保对 INSERT 中默认空值的表达式预处理被正确应用（Tom Lane）§
如果目标列是域类型，规划器必须插入一个强制转换到域的步骤而不仅仅是一个空常量，而此表达式遗漏了一些必要的处理步骤。对于基于核心数据类型的域没有已知后果，但理论上对于基于扩展类型的域可能会出错。
", "text": "确保对 INSERT 中默认空值的表达式预处理被正确应用（Tom Lane）§ 如果目标列是域类型，规划器必须插入一个强制转换到域的步骤而不仅仅是一个空常量，而此表达式遗漏了一些必要的处理步骤。对于基于核心数据类型的域没有已知后果，但理论上对于基于扩展类型的域可能会出错。", "title": "确保对 INSERT 中默认空值的表达式预处理被正确应用", "commits": ["c05268e6e"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "8069412952bf3dc6b41c80fc5ac5ab8fb5c9a1ad1db58be20ed6d0be98b51edf", "section_path": ["变更"], "commit_groups": [["0da39aa76", "6655d931c", "6e41e9e5e", "bb85d0935", "c05268e6e"]], "identity_text": "Ensure that expression preprocessing is applied to a default null value in INSERT (Tom Lane) If the target column is of a domain type, the planner must insert a coerce-to-domain step not just a null constant, and this expression missed going through some required processing steps. There is no known consequence with domains based on core data types, but in theory an error could occur with domains based on extension types.", "commit_aliases": ["0da39aa76", "6655d931c", "6e41e9e5e", "bb85d0935", "c05268e6e"], "source_commits": ["c05268e6e"], "source_entry_id": "14.16/changes/032", "db_id": "e461e7ee096e6254fa7012871a9c1f40", "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483", "relations": [{"rule": 2, "type": "equivalent", "target": "5c924d14c948271fbc38c8d281ec24e1", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}}, {"rule": 2, "type": "equivalent", "target": "e38ec1d2b1103ec9341c5b1123335159", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}}, {"rule": 2, "type": "equivalent", "target": "f058a89b390c55869f483a660569b0aa", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "5c924d14c948271fbc38c8d281ec24e1", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "确保对 INSERT 中默认空值的表达式预处理被正确应用", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}, "url": "/docs/compare/?release=17.3#17.3-7be5325298b8f565", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "f058a89b390c55869f483a660569b0aa", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "确保对 INSERT 中默认空值的表达式预处理被正确应用", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}, "url": "/docs/compare/?release=16.7#16.7-6680b0773026d87c", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "e38ec1d2b1103ec9341c5b1123335159", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "确保对 INSERT 中默认空值的表达式预处理被正确应用", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}, "url": "/docs/compare/?release=15.11#15.11-7e089e52061bb4f6", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}]}, {"id": "14.16-6409d189d030139a", "cves": [], "html": "修复 PL/Python 中的内存泄漏（Mat Arye，Tom Lane）§
\n重复使用 PLyPlan.execute 或 plpy.cursor 会导致在调用 PL/Python 函数的持续时间内产生内存泄漏。
修复 PL/Tcl 使其能在 Tcl 9 下编译（Peter Eisentraut）§
", "text": "修复 PL/Tcl 使其能在 Tcl 9 下编译（Peter Eisentraut）§", "title": "修复 PL/Tcl 使其能在 Tcl 9 下编译", "commits": ["17d081a6f"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "b7681899790958b41b242861797abf8a4a58afebd37df82361ad09ff9ef052ae", "section_path": ["变更"], "commit_groups": [["07c77803c", "17d081a6f", "32a2aa77e", "a5f9cbde9", "f230e27a2", "f979197eb"]], "identity_text": "Fix PL/Tcl to compile with Tcl 9 (Peter Eisentraut)", "commit_aliases": ["07c77803c", "17d081a6f", "32a2aa77e", "a5f9cbde9", "f230e27a2", "f979197eb"], "source_commits": ["17d081a6f"], "source_entry_id": "14.16/changes/034", "db_id": "b5e22eeed852a78978fa5b94ff645acf", "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24", "relations": [{"rule": 2, "type": "equivalent", "target": "0d6f80ed82ee1b2e80a6f8ca9c87a12d", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}}, {"rule": 2, "type": "equivalent", "target": "129c07a2f63ef2dd97017ea2d4602005", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}}, {"rule": 2, "type": "equivalent", "target": "43ec78dc409230e526b689e924ccab90", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}}, {"rule": 2, "type": "equivalent", "target": "eab1bcb0a34c2e2111bf60e2805ede38", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "eab1bcb0a34c2e2111bf60e2805ede38", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "修复 PL/Tcl 使其能在 Tcl 9 下编译", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}, "url": "/docs/compare/?release=17.3#17.3-3ed7f6c30ba4fca8", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "43ec78dc409230e526b689e924ccab90", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "修复 PL/Tcl 使其能在 Tcl 9 下编译", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}, "url": "/docs/compare/?release=16.7#16.7-0eaf6e78dbdc6912", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "129c07a2f63ef2dd97017ea2d4602005", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "修复 PL/Tcl 使其能在 Tcl 9 下编译", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}, "url": "/docs/compare/?release=15.11#15.11-3d33af5f4d4ad225", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "0d6f80ed82ee1b2e80a6f8ca9c87a12d", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "修复 PL/Tcl 使其能在 Tcl 9 下编译", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}, "url": "/docs/compare/?release=13.19#13.19-c88b3b083e0ea08f", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-e15053be8332fda8", "cves": [], "html": "在 ecpg 预处理器中，修复引用超出作用域变量的游标可能被错误处理的问题（Tom Lane）§
", "text": "在 ecpg 预处理器中，修复引用超出作用域变量的游标可能被错误处理的问题（Tom Lane）§", "title": "在 ecpg 预处理器中，修复引用超出作用域变量的游标可能被错误处理的问题", "commits": ["52c7a44e9"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "706e797cc119afcb8bc0dcf3ec4d56386d8599cbea3d08b6e4eedba701470f50", "section_path": ["变更"], "commit_groups": [["2f696453d", "52c7a44e9", "60b47525c", "a963abd54", "cca34f68c", "e359cbb84"]], "identity_text": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables (Tom Lane)", "commit_aliases": ["2f696453d", "52c7a44e9", "60b47525c", "a963abd54", "cca34f68c", "e359cbb84"], "source_commits": ["52c7a44e9"], "source_entry_id": "14.16/changes/035", "db_id": "20aa43ec07c27d96fa929c253c41d044", "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33", "relations": [{"rule": 2, "type": "equivalent", "target": "36dfe57940df538e7fb47cd7fdbd37be", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}}, {"rule": 2, "type": "equivalent", "target": "674e320ee70fdf11884316cc30475c46", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}}, {"rule": 2, "type": "equivalent", "target": "c4ec9fcca2f80cbbf22f2737f8f5fcb6", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}}, {"rule": 2, "type": "equivalent", "target": "f1227cacc29d5455e9dce3398b0622d4", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c4ec9fcca2f80cbbf22f2737f8f5fcb6", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "在 ecpg 预处理器中，修复引用超出作用域变量的游标可能被错误处理的问题", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}, "url": "/docs/compare/?release=17.3#17.3-dfe5a8c2c2423920", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "f1227cacc29d5455e9dce3398b0622d4", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "在 ecpg 预处理器中，修复引用超出作用域变量的游标可能被错误处理的问题", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}, "url": "/docs/compare/?release=16.7#16.7-5309e9bb99c52b63", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "674e320ee70fdf11884316cc30475c46", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "在 ecpg 预处理器中，修复引用超出作用域变量的游标可能被错误处理的问题", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}, "url": "/docs/compare/?release=15.11#15.11-0c6c96c4fed5dcb6", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "36dfe57940df538e7fb47cd7fdbd37be", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "在 ecpg 预处理器中，修复引用超出作用域变量的游标可能被错误处理的问题", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}, "url": "/docs/compare/?release=13.19#13.19-96df37ab6e655d81", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-56ba6358d3159b1f", "cves": [], "html": "在 ecpg 中，修复关于不支持使用 COPY ... FROM STDIN 的编译时警告（Ryo Kanbayashi）§
之前，由于拼写错误，预期的警告未被发出。
", "text": "在 ecpg 中，修复关于不支持使用 COPY ... FROM STDIN 的编译时警告（Ryo Kanbayashi）§ 之前，由于拼写错误，预期的警告未被发出。", "title": "在 ecpg 中，修复关于不支持使用 COPY ... FROM STDIN 的编译时警告", "commits": ["d06ab3c0c"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "ca93deb096551b55252db9d451956247ee58714ff2debbde6cbc263e11543a26", "section_path": ["变更"], "commit_groups": [["226c9048d", "5c7c34db2", "71ef47cf0", "94b914f60", "ba2dbedd5", "d06ab3c0c"]], "identity_text": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN (Ryo Kanbayashi) Previously, the intended warning was not issued due to a typo.", "commit_aliases": ["226c9048d", "5c7c34db2", "71ef47cf0", "94b914f60", "ba2dbedd5", "d06ab3c0c"], "source_commits": ["d06ab3c0c"], "source_entry_id": "14.16/changes/036", "db_id": "16348925260a3ff03e3723c9dd8c2397", "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f", "relations": [{"rule": 2, "type": "equivalent", "target": "3ff78f3d2c970b520dbfb8115656b8f2", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}}, {"rule": 2, "type": "equivalent", "target": "84b39b054b34211ea1d18a290c6cddf4", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}}, {"rule": 2, "type": "equivalent", "target": "bb2b663ff581a3c13fc37566fef8aea2", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}}, {"rule": 2, "type": "equivalent", "target": "bec199ad48fa75cf12e6e0349c6252cf", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "84b39b054b34211ea1d18a290c6cddf4", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "在 ecpg 中，修复关于不支持使用 COPY ... FROM STDIN 的编译时警告", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}, "url": "/docs/compare/?release=17.3#17.3-fe0d2d65c5d4aa3b", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "bec199ad48fa75cf12e6e0349c6252cf", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "在 ecpg 中，修复关于不支持使用 COPY ... FROM STDIN 的编译时警告", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}, "url": "/docs/compare/?release=16.7#16.7-5ec2b4f354ab6cca", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "3ff78f3d2c970b520dbfb8115656b8f2", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "在 ecpg 中，修复关于不支持使用 COPY ... FROM STDIN 的编译时警告", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}, "url": "/docs/compare/?release=15.11#15.11-18a63d75a25dde2a", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "bb2b663ff581a3c13fc37566fef8aea2", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "在 ecpg 中，修复关于不支持使用 COPY ... FROM STDIN 的编译时警告", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}, "url": "/docs/compare/?release=13.19#13.19-6b7efc6e2fb6ea0b", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-428e8a150cc86cec", "cves": [], "html": "修复 psql 以安全处理以 SJIS 编码的文件路径名（Tom Lane）§
\nSJIS 中的一些双字节字符的第二个字节等于 ASCII 反斜杠（\\）。这些字符会被路径名规范化所损坏，导致无法访问名称中包含此类字符的文件。
修复 pgbench 和 psql 中使用错误版本的 pqsignal() 的问题（Fujii Masao，Tom Lane）§
此错误可能导致在 pgbench 中使用 -T 选项或在 psql 中使用 \\watch 命令时出现异常行为，原因是被中断的系统调用未能按预期恢复。
修复 pgbench 中某些嵌套 \\if 构造的错误执行（Michail Nikolaev）§
出现在为假（未执行）的 \\if 分支中的 \\if 命令被错误地当作 \\elif 处理。
在 pgbench 中，修复表初始化期间进度消息可能显示错误的问题（Yushi Ogiwara，Tatsuo Ishii，Fujii Masao）§ §
", "text": "在 pgbench 中，修复表初始化期间进度消息可能显示错误的问题（Yushi Ogiwara，Tatsuo Ishii，Fujii Masao）§ §", "title": "在 pgbench 中，修复表初始化期间进度消息可能显示错误的问题", "commits": ["0f13e1a78", "5addea71c"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "e7ca120129904aacbd25b1078869cc87b77522c940ade0c757a0053ee5a05727", "section_path": ["变更"], "commit_groups": [["0f13e1a78", "1cf646957", "1e46f7351", "adb103fca", "af35fe501", "f1cb5e51f"], ["21b815f92", "499d1cf55", "5addea71c", "b6decfc1d", "e35d396ec", "fb056564e"]], "identity_text": "In pgbench, fix possible misdisplay of progress messages during table initialization (Yushi Ogiwara, Tatsuo Ishii, Fujii Masao)", "commit_aliases": ["0f13e1a78", "1cf646957", "1e46f7351", "21b815f92", "499d1cf55", "5addea71c", "adb103fca", "af35fe501", "b6decfc1d", "e35d396ec", "f1cb5e51f", "fb056564e"], "source_commits": ["0f13e1a78", "5addea71c"], "source_entry_id": "14.16/changes/040", "db_id": "4d088578b652179ddacd9d70bbb67986", "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76", "relations": [{"rule": 2, "type": "equivalent", "target": "519999f09977133cde405726c01a0d11", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}}, {"rule": 2, "type": "equivalent", "target": "54b30b07e73ec94fa147169ad6a3af52", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}}, {"rule": 2, "type": "equivalent", "target": "8f2041403d7330cc62885e5b2bb1b72c", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}}, {"rule": 2, "type": "equivalent", "target": "ae3970b18e126ca505a736ef0e883895", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "519999f09977133cde405726c01a0d11", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "在 pgbench 中，修复表初始化期间进度消息可能显示错误的问题", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}, "url": "/docs/compare/?release=17.3#17.3-f7e58e392f141f50", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "ae3970b18e126ca505a736ef0e883895", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "在 pgbench 中，修复表初始化期间进度消息可能显示错误的问题", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}, "url": "/docs/compare/?release=16.7#16.7-dab6dcfe958af472", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "54b30b07e73ec94fa147169ad6a3af52", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "在 pgbench 中，修复表初始化期间进度消息可能显示错误的问题", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}, "url": "/docs/compare/?release=15.11#15.11-d8a80d74420572fa", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "8f2041403d7330cc62885e5b2bb1b72c", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "在 pgbench 中，修复表初始化期间进度消息可能显示错误的问题", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}, "url": "/docs/compare/?release=13.19#13.19-531838d465c87787", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-ecd2f9229d5327aa", "cves": [], "html": "增强 pg_controldata 对损坏的 pg_control 文件的健壮性（Ilyasov Ian，Anton Voloshin）§
由于 pg_controldata 即使在 CRC 检查失败时也会尝试打印 pg_control 的内容，因此必须注意不要因无效字段值而出现异常行为。此补丁修复了无效时间戳和看似为负数的 WAL 段大小触发的一些问题。
修复 pg_dump 中当身份序列附加到作为扩展成员的表时可能崩溃的问题（Tom Lane）§
", "text": "修复 pg_dump 中当身份序列附加到作为扩展成员的表时可能崩溃的问题（Tom Lane）§", "title": "修复 pg_dump 中当身份序列附加到作为扩展成员的表时可能崩溃的问题", "commits": ["c7f3c414f"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "31df43eedcb73c805fddb2d4576c05ed4c7fef462d6af9dc1894c983c8fa745e", "section_path": ["变更"], "commit_groups": [["6978129b4", "782cc1aa3", "7b8cb9cd6", "ad950ea98", "b6df2d6e5", "c7f3c414f"]], "identity_text": "Fix possible crash in pg_dump with identity sequences attached to tables that are extension members (Tom Lane)", "commit_aliases": ["6978129b4", "782cc1aa3", "7b8cb9cd6", "ad950ea98", "b6df2d6e5", "c7f3c414f"], "source_commits": ["c7f3c414f"], "source_entry_id": "14.16/changes/042", "db_id": "8d305380dee5f3d46413d953276a0dad", "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e", "relations": [{"rule": 2, "type": "equivalent", "target": "477e86c272f9e2c3dbeca3e4c5fcc955", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}}, {"rule": 2, "type": "equivalent", "target": "7f23a5667f7e389c5f499ce86c38be10", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}}, {"rule": 2, "type": "equivalent", "target": "c0991c19a95931f5a1fb7aff94c40366", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}}, {"rule": 2, "type": "equivalent", "target": "fac028cab5754384359540890bb37419", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}}], "version": "14.16", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "7f23a5667f7e389c5f499ce86c38be10", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "修复 pg_dump 中当身份序列附加到作为扩展成员的表时可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}, "url": "/docs/compare/?release=17.3#17.3-11aed5731d7ba38d", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "c0991c19a95931f5a1fb7aff94c40366", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "修复 pg_dump 中当身份序列附加到作为扩展成员的表时可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}, "url": "/docs/compare/?release=16.7#16.7-b1ae83939398a4a5", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "477e86c272f9e2c3dbeca3e4c5fcc955", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "修复 pg_dump 中当身份序列附加到作为扩展成员的表时可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}, "url": "/docs/compare/?release=15.11#15.11-335b0c9dfbab5ea3", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "fac028cab5754384359540890bb37419", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "修复 pg_dump 中当身份序列附加到作为扩展成员的表时可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}, "url": "/docs/compare/?release=13.19#13.19-5c1a4b77b70a416c", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "14.16-6354e6bdb73b219e", "cves": [], "html": "修复 pg_basebackup 以正确处理 Windows 上超过 2GB 的 pg_wal.tar 文件（Davinder Singh，Thomas Munro）§ §
更新确定访问 ARM CRC 指令所需编译器开关的配置探测（Tom Lane）§
\n在基线 CPU 目标缺少 CRC 指令的 ARM 平台上，我们需要提供 -march 开关来说服编译器编译此类指令。较新版本的 gcc 会拒绝我们尝试使用的值，导致静默回退到软件 CRC。
在 configure 期间，如果检测到 C23 编译器，尝试请求 C17（Thomas Munro）§
\nv16 之前的 PostgreSQL 版本无法在 C23 规则下编译。如果所选编译器默认为 C23 或更高版本，尝试添加 -std=gnu17 开关来更改。（如果这对你的编译器不起作用，请手动指定带有合适开关的 CFLAGS。）
更新时区数据文件至 tzdata 2025a 版本，包含巴拉圭的夏令时法律变更以及菲律宾的历史修正（Tom Lane）§
", "text": "更新时区数据文件至 tzdata 2025a 版本，包含巴拉圭的夏令时法律变更以及菲律宾的历史修正（Tom Lane）§", "title": "更新时区数据文件至 tzdata 2025a 版本，包含巴拉圭的夏令时法律变更以及菲律宾的历史修正", "commits": ["20b4819d0"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.16/#ZH-AUTO-RELEASE-14-SECT2-14", "source_hash": "81621ab2189c6514e24e09955cf38874dd44f094d44251100c1b51d5a558ed1a", "section_path": ["变更"], "commit_groups": [["20b4819d0", "48bc95d0d", "60c513f8f", "6397819c8", "d62403c51", "e292ba333"]], "identity_text": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines (Tom Lane)", "commit_aliases": ["20b4819d0", "48bc95d0d", "60c513f8f", "6397819c8", "d62403c51", "e292ba333"], "source_commits": ["20b4819d0"], "source_entry_id": "14.16/changes/046", "db_id": "f6f570a8d6d74874c021872f79b537b9", "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b", "relations": [{"rule": 2, "type": "equivalent", "target": "142b6f5b8f5412088d8a118b9747bbd1", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}}, {"rule": 2, "type": "equivalent", "target": "96dcfa4106a9d8c891112ee991959a59", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}}, {"rule": 2, "type": "equivalent", "target": "b2eef5973920bcf8f3be6ddb2e79db35", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}}, {"rule": 2, "type": "equivalent", "target": "c7a079298874b849c2e215248946734d", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}}], "version": "14.16", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "142b6f5b8f5412088d8a118b9747bbd1", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "更新时区数据文件至 tzdata 2025a 版本，包含巴拉圭的夏令时法律变更以及菲律宾的历史修正", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}, "url": "/docs/compare/?release=17.3#17.3-bf7d1c9ccfa2521e", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "96dcfa4106a9d8c891112ee991959a59", "kind": "equivalent", "version": "16.7", "label": "16.7", "title": "更新时区数据文件至 tzdata 2025a 版本，包含巴拉圭的夏令时法律变更以及菲律宾的历史修正", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}, "url": "/docs/compare/?release=16.7#16.7-3c5219a3c087cbf0", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES"}, {"db_id": "c7a079298874b849c2e215248946734d", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "更新时区数据文件至 tzdata 2025a 版本，包含巴拉圭的夏令时法律变更以及菲律宾的历史修正", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}, "url": "/docs/compare/?release=15.11#15.11-3a998d6879710842", "source_url": "/docs/release/15.11/#ZH-AUTO-RELEASE-15-SECT2-14"}, {"db_id": "b2eef5973920bcf8f3be6ddb2e79db35", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "更新时区数据文件至 tzdata 2025a 版本，包含巴拉圭的夏令时法律变更以及菲律宾的历史修正", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}, "url": "/docs/compare/?release=13.19#13.19-e9856e484813a85d", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 46}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 26}, {"key": "security", "label": "安全相关", "count": 1}, {"key": "performance", "label": "性能改进", "count": 1}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 18}], "total": 46, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2025-1094", "url": "https://www.postgresql.org/support/security/CVE-2025-1094/", "fixed": {"13": "13.19", "14": "14.16", "15": "15.11", "16": "16.7", "17": "17.3"}, "score": 8.1, "title": "加强 PQescapeString 及相关函数对无效编码输入字符串的防护", "vector": "AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2025-1094", "affected": {"13": "13", "14": "14", "15": "15", "16": "16", "17": "17"}, "component": "core server", "published": {"13": "2025-02-13", "14": "2025-02-13", "15": "2025-02-13", "16": "2025-02-13", "17": "2025-02-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Improper neutralization of quoting syntax in PostgreSQL libpq functions PQescapeLiteral(), PQescapeIdentifier(), PQescapeString(), and PQescapeStringConn() allows a database input provider to achieve SQL injection in certain usage patterns. Specifically, SQL injection requires the application to use the function result to construct input to psql, the PostgreSQL interactive terminal. Similarly, improper neutralization of quoting syntax in PostgreSQL command line utility programs allows a source of command line arguments to achieve SQL injection when client_encoding is BIG5 and server_encoding is one of EUC_TW or MULE_INTERNAL. Versions before PostgreSQL 17.3, 16.7, 15.11, 14.16, and 13.19 are affected.", "affected_ranges": [{"from": "0", "until": "13.19"}, {"from": "14", "until": "14.16"}, {"from": "15", "until": "15.11"}, {"from": "16", "until": "16.7"}, {"from": "17", "until": "17.3"}], "first_published": "2025-02-13", "fixed_version": "14.16"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 46, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}