{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2016-02-11", "build": "9.5.1", "major": "9.5", "minor": 1, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.1", "eol_date": "2021-02-11", "date_text": "2016-02-11", "supported": false, "manual_url": "/docs/9.5/release-9-5-1.html", "source_url": "/docs/release/9.5.1/", "entry_count": 23, "placeholder": false, "content_hash": "637d377e5781f79ec615144434060c4521dc1da0686e166e347da0d92772f756", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 23, "doc_loaded_at": "2026-09-26T02:56:44.718140", "migration_html": "

对于运行 9.5.X 的用户，不需要转储/恢复。

", "compatibility_count": 0, "label": "9.5.1", "status_label": "历史版本", "eol": "2021-02-11", "age_days": 3884, "support_days": -2057}, "groups": [{"date": "2016-02-11", "build": "9.5.1", "major": "9.5", "minor": 1, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.1", "eol_date": "2021-02-11", "date_text": "2016-02-11", "supported": false, "manual_url": "/docs/9.5/release-9-5-1.html", "source_url": "/docs/release/9.5.1/", "entry_count": 23, "placeholder": false, "content_hash": "637d377e5781f79ec615144434060c4521dc1da0686e166e347da0d92772f756", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 23, "doc_loaded_at": "2026-09-26T02:56:44.718140", "migration_html": "

对于运行 9.5.X 的用户，不需要转储/恢复。

", "compatibility_count": 0, "label": "9.5.1", "status_label": "历史版本", "eol": "2021-02-11", "age_days": 3884, "support_days": -2057, "entries": [{"id": "9.5.1-f56bb4796f0084d4", "cves": ["CVE-2016-0773"], "html": "

修复正则表达式中的无限循环和缓冲区越界问题（Tom Lane）

\n

方括号表达式中非常大的字符范围在某些情况下可能导致无限循环，在另一些情况下可能导致内存覆写。（CVE-2016-0773）

", "text": "修复正则表达式中的无限循环和缓冲区越界问题（Tom Lane） 方括号表达式中非常大的字符范围在某些情况下可能导致无限循环，在另一些情况下可能导致内存覆写。（CVE-2016-0773）", "title": "修复正则表达式中的无限循环和缓冲区越界问题", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "eb0438a45957947108c61c598f04acd2ec453dd2b563c4193f035f6b8b92e868", "section_path": ["变更"], "commit_groups": [["3bb3f42f3", "6403a6b74", "98d6b7305", "a61de2bc1", "e93516cf7", "fdc3139e2"]], "identity_text": "Fix infinite loops and buffer-overrun problems in regular expressions (Tom Lane) Very large character ranges in bracket expressions could cause infinite loops in some cases, and memory overwrites in other cases. (CVE-2016-0773)", "commit_aliases": ["3bb3f42f3", "6403a6b74", "98d6b7305", "a61de2bc1", "e93516cf7", "fdc3139e2"], "source_commits": ["a61de2bc1"], "source_entry_id": "9.5.1/changes/001", "db_id": "acbbe23ea65dd41f0174374de68d073f", "patch_ids": ["fff99eddfbc31c3eb5f41a8529895bbd"], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c", "relations": [{"rule": 2, "type": "equivalent", "target": "859232add61df95d2630e724ae0f4618", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}}, {"rule": 2, "type": "equivalent", "target": "a209620754197e56fafec1ecd0cd9842", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}}, {"rule": 2, "type": "equivalent", "target": "eb48871d4635001988ed54c5482d6ada", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}}, {"rule": 2, "type": "equivalent", "target": "f82b2c278b85f75fb51729724ed1a13f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}}], "version": "9.5.1", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "eb48871d4635001988ed54c5482d6ada", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "修复正则表达式中的无限循环和缓冲区越界问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}, "url": "/docs/compare/?release=9.4.6#9.4.6-f56bb4796f0084d4", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "f82b2c278b85f75fb51729724ed1a13f", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "修复正则表达式中的无限循环和缓冲区越界问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}, "url": "/docs/compare/?release=9.3.11#9.3.11-f56bb4796f0084d4", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "a209620754197e56fafec1ecd0cd9842", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "修复正则表达式中的无限循环和缓冲区越界问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}, "url": "/docs/compare/?release=9.2.15#9.2.15-f56bb4796f0084d4", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "859232add61df95d2630e724ae0f4618", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "修复正则表达式中的无限循环和缓冲区越界问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}, "url": "/docs/compare/?release=9.1.20#9.1.20-f56bb4796f0084d4", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-1c6ca7530b875506", "cves": [], "html": "

修复一个疏漏：它在罕见情况下导致哈希连接遗漏内部关系的某些元组（Tomas Vondra、Tom Lane）

", "text": "修复一个疏漏：它在罕见情况下导致哈希连接遗漏内部关系的某些元组（Tomas Vondra、Tom Lane）", "title": "修复一个疏漏：它在罕见情况下导致哈希连接遗漏内部关系的某些元组", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "8d20690639eba4a374b434eb9303f58e209ff57c6ed0a28ae9857db442d80ca5", "section_path": ["变更"], "commit_groups": [["129db3cbe", "f867ce551"]], "identity_text": "Fix an oversight that caused hash joins to miss joining to some tuples of the inner relation in rare cases (Tomas Vondra, Tom Lane)", "commit_aliases": ["129db3cbe", "f867ce551"], "source_commits": ["129db3cbe"], "source_entry_id": "9.5.1/changes/002", "db_id": "932c11915038d8b55a76e79b35c0abdd", "patch_ids": ["9e554408b05a7d34ef156283a1b8668d"], "statement_hash": "f054de5e9bc1d649ca06dd7c4c74a3f5011c0959e939ff93ac70784bb7ff123f", "relations": [], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-587b9fab14c71759", "cves": [], "html": "

在使用分组集时避免 HAVING 子句的下推（Andrew Gierth）

", "text": "在使用分组集时避免 HAVING 子句的下推（Andrew Gierth）", "title": "在使用分组集时避免 HAVING 子句的下推", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "6f9617097f5a5b852007b305055dbd8a21b4cc454e695ef73bd6068be35beedf", "section_path": ["变更"], "commit_groups": [["87dbc72a7", "a6897efab"]], "identity_text": "Avoid pushdown of HAVING clauses when grouping sets are used (Andrew Gierth)", "commit_aliases": ["87dbc72a7", "a6897efab"], "source_commits": ["87dbc72a7"], "source_entry_id": "9.5.1/changes/003", "db_id": "a81d08446582da4d624d0fca8eec950b", "patch_ids": ["cce6cb50a00901ba9dc0f769d0b5b032"], "statement_hash": "c917f9723e0b54ee747a5cef4027630f946f1419653be12054112333a84b4076", "relations": [], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-32b1f467d4b9d87a", "cves": [], "html": "

修复 ON CONFLICT 仲裁者 WHERE 子句的反解析（Peter Geoghegan）

", "text": "修复 ON CONFLICT 仲裁者 WHERE 子句的反解析（Peter Geoghegan）", "title": "修复 ON CONFLICT 仲裁者 WHERE 子句的反解析", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "31512443676c2ac3bbb1ee213bb6d0b065400e7b64a33d7c82abc7ff0ee7cc4f", "section_path": ["变更"], "commit_groups": [["82406d6ff", "cc2ca9319"]], "identity_text": "Fix deparsing of ON CONFLICT arbiter WHERE clauses (Peter Geoghegan)", "commit_aliases": ["82406d6ff", "cc2ca9319"], "source_commits": ["82406d6ff"], "source_entry_id": "9.5.1/changes/004", "db_id": "8a40745385ecf37b6c3e6228eea3bb67", "patch_ids": ["020eb461cfa64ace114f900472459c9e"], "statement_hash": "f81bab630f83d06b767a041109a5ee8580aebb53ade2f9458b3843e7909930dc", "relations": [], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-d2d542d258130ed6", "cves": [], "html": "

使 log_line_prefix 中的 %h 和 %r 转义对因 log_connections 而发出的消息也生效（Tom Lane）

\n

以前，%h/%r 要等到新会话发出“connection received”日志消息之后才开始生效；现在它们对该消息也生效。

", "text": "使 log_line_prefix 中的 %h 和 %r 转义对因 log_connections 而发出的消息也生效（Tom Lane） 以前，%h/%r 要等到新会话发出“connection received”日志消息之后才开始生效；现在它们对该消息也生效。", "title": "使 log_line_prefix 中的 %h 和 %r 转义对因 log_connections 而发出的消息也生效", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "524ab5fc9127fa1fe1203725d7a634010f9983154f06673adeb85dfbacb1b42b", "section_path": ["变更"], "commit_groups": [["2acb682f6", "2b3983158", "3a7af9d73", "9bbfca8fd", "b043df093", "b8682a715"]], "identity_text": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections (Tom Lane) Previously, %h/%r started to work just after a new session had emitted the connection received log message; now they work for that message too.", "commit_aliases": ["2acb682f6", "2b3983158", "3a7af9d73", "9bbfca8fd", "b043df093", "b8682a715"], "source_commits": ["2acb682f6"], "source_entry_id": "9.5.1/changes/005", "db_id": "6cc1fd169e073e22555fc531aff02d28", "patch_ids": ["8070190b021dab3e3dd6de9c25508d94"], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc", "relations": [{"rule": 2, "type": "equivalent", "target": "7caf7f1373b5cb1b3c69c8e5a4f8f302", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}}, {"rule": 2, "type": "equivalent", "target": "7cbb23e7d2754a3bd8e761e886e63406", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}}, {"rule": 2, "type": "equivalent", "target": "885ed48fb5fbfb10eada458542befc93", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}}, {"rule": 2, "type": "equivalent", "target": "dbb4d11812f0944feba47107395dba8f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}}], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "7caf7f1373b5cb1b3c69c8e5a4f8f302", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "使 log_line_prefix 中的 %h 和 %r 转义对因 log_connections 而发出的消息也生效", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}, "url": "/docs/compare/?release=9.4.6#9.4.6-d2d542d258130ed6", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "885ed48fb5fbfb10eada458542befc93", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "使 log_line_prefix 中的 %h 和 %r 转义对因 log_connections 而发出的消息也生效", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}, "url": "/docs/compare/?release=9.3.11#9.3.11-d2d542d258130ed6", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "7cbb23e7d2754a3bd8e761e886e63406", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "使 log_line_prefix 中的 %h 和 %r 转义对因 log_connections 而发出的消息也生效", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}, "url": "/docs/compare/?release=9.2.15#9.2.15-d2d542d258130ed6", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "dbb4d11812f0944feba47107395dba8f", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "使 log_line_prefix 中的 %h 和 %r 转义对因 log_connections 而发出的消息也生效", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}, "url": "/docs/compare/?release=9.1.20#9.1.20-d2d542d258130ed6", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-3d56b3b235f19bc9", "cves": [], "html": "

避免 SSPI 身份验证期间泄漏令牌句柄（Christian Ullrich）

", "text": "避免 SSPI 身份验证期间泄漏令牌句柄（Christian Ullrich）", "title": "避免 SSPI 身份验证期间泄漏令牌句柄", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "6e00352525219b364bf7bec2bdd6b5991a0d8e7f973838f788d127d1e4f09497", "section_path": ["变更"], "commit_groups": [["3276ca303", "6a61d1ff9", "77d8edcf5", "ab49f87d5", "b1c0f92eb", "df0bd5a0f"]], "identity_text": "Avoid leaking a token handle during SSPI authentication (Christian Ullrich)", "commit_aliases": ["3276ca303", "6a61d1ff9", "77d8edcf5", "ab49f87d5", "b1c0f92eb", "df0bd5a0f"], "source_commits": ["3276ca303"], "source_entry_id": "9.5.1/changes/006", "db_id": "5e825f5f564b8ef9b8c2ffbaf04b47cb", "patch_ids": ["043850648c6e2fcf66f222c23e6cdeb7"], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160", "relations": [{"rule": 2, "type": "equivalent", "target": "2e51514f5864394cf46f8e85f7419104", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}}, {"rule": 2, "type": "equivalent", "target": "438714cc5e6c71db4312eb35fbebec55", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}}, {"rule": 2, "type": "equivalent", "target": "a4a1520f5f054523d7c0e2fe9df3ced2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}}, {"rule": 2, "type": "equivalent", "target": "f3b2f1ddac374281dba34c16bc28d77e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}}], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f3b2f1ddac374281dba34c16bc28d77e", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "避免 SSPI 身份验证期间泄漏令牌句柄", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}, "url": "/docs/compare/?release=9.4.6#9.4.6-3d56b3b235f19bc9", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "438714cc5e6c71db4312eb35fbebec55", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "避免 SSPI 身份验证期间泄漏令牌句柄", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}, "url": "/docs/compare/?release=9.3.11#9.3.11-3d56b3b235f19bc9", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "2e51514f5864394cf46f8e85f7419104", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "避免 SSPI 身份验证期间泄漏令牌句柄", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}, "url": "/docs/compare/?release=9.2.15#9.2.15-3d56b3b235f19bc9", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "a4a1520f5f054523d7c0e2fe9df3ced2", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "避免 SSPI 身份验证期间泄漏令牌句柄", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}, "url": "/docs/compare/?release=9.1.20#9.1.20-3d56b3b235f19bc9", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-393f4986211d864e", "cves": [], "html": "

修复 psql 的 \\det 命令，使其以与其他可能带模式限定模式的 \\d 命令相同的方式解释模式参数（Reece Hart）

", "text": "修复 psql 的 \\det 命令，使其以与其他可能带模式限定模式的 \\d 命令相同的方式解释模式参数（Reece Hart）", "title": "修复 psql 的 \\det 命令，使其以与其他可能带模式限定模式的 \\d 命令相同的方式解释模式参数", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "2934761f32aeac456966ea22ed7d360753afeefcfcb88be526134be654340215", "section_path": ["变更"], "commit_groups": [["56251f396", "5849b6e32", "7e2247047", "a362cc2e3", "db678ca16", "ed5f57218"]], "identity_text": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do (Reece Hart)", "commit_aliases": ["56251f396", "5849b6e32", "7e2247047", "a362cc2e3", "db678ca16", "ed5f57218"], "source_commits": ["56251f396"], "source_entry_id": "9.5.1/changes/007", "db_id": "56543181c886e0a9e02d16ceb110d586", "patch_ids": ["980fc05fa3fb10b765e92533448afdf2"], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44", "relations": [{"rule": 2, "type": "equivalent", "target": "72c2989920da86c253ab09eecb31b14e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}}, {"rule": 2, "type": "equivalent", "target": "a44ae03d4941be3dc2e2c64890df9f35", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}}, {"rule": 2, "type": "equivalent", "target": "ae26b564c233409889218223f5607057", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}}, {"rule": 2, "type": "equivalent", "target": "c2275e8ef3b9fe637be3a173f5a783ae", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}}], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c2275e8ef3b9fe637be3a173f5a783ae", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "修复 psql 的 \\det 命令，使其以与其他可能带模式限定模式的 \\d 命令相同的方式解释模式参数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}, "url": "/docs/compare/?release=9.4.6#9.4.6-393f4986211d864e", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "a44ae03d4941be3dc2e2c64890df9f35", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "修复 psql 的 \\det 命令，使其以与其他可能带模式限定模式的 \\d 命令相同的方式解释模式参数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}, "url": "/docs/compare/?release=9.3.11#9.3.11-393f4986211d864e", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "ae26b564c233409889218223f5607057", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "修复 psql 的 \\det 命令，使其以与其他可能带模式限定模式的 \\d 命令相同的方式解释模式参数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}, "url": "/docs/compare/?release=9.2.15#9.2.15-393f4986211d864e", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "72c2989920da86c253ab09eecb31b14e", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "修复 psql 的 \\det 命令，使其以与其他可能带模式限定模式的 \\d 命令相同的方式解释模式参数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}, "url": "/docs/compare/?release=9.1.20#9.1.20-393f4986211d864e", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-ffc20c3efcf2b89c", "cves": [], "html": "

在 Windows 上的 pg_ctl 中，通过检查服务状态来决定输出发送到哪里，而不是检查标准输出是否为终端（Michael Paquier）

", "text": "在 Windows 上的 pg_ctl 中，通过检查服务状态来决定输出发送到哪里，而不是检查标准输出是否为终端（Michael Paquier）", "title": "在 Windows 上的 pg_ctl 中，通过检查服务状态来决定输出发送到哪里，而不是检查标准输出是否为终端", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "5725a069624b9666f0fa1ef408405403512d70dc60fdb5543bda4a3f60c91408", "section_path": ["变更"], "commit_groups": [["5c4cbd5d1", "744d01c9a", "74d4009b8", "a96761391", "b96f6f444", "c7aca3d45"]], "identity_text": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal (Michael Paquier)", "commit_aliases": ["5c4cbd5d1", "744d01c9a", "74d4009b8", "a96761391", "b96f6f444", "c7aca3d45"], "source_commits": ["744d01c9a"], "source_entry_id": "9.5.1/changes/008", "db_id": "fc55b81ca38dd48fd637c4b89b222440", "patch_ids": ["efbbf5bf90d3be34215d8f56c82effd2"], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d", "relations": [{"rule": 2, "type": "equivalent", "target": "46bc5c70bec439f4ae601fe91c34c983", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}}, {"rule": 2, "type": "equivalent", "target": "50a28c9cf76d98dccd0ae115ab281817", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}}, {"rule": 2, "type": "equivalent", "target": "998f6731981001ad75f03a48efe6cfa2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}}, {"rule": 2, "type": "equivalent", "target": "f2c17c58b814d10bbb6e43d22001d01f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}}], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f2c17c58b814d10bbb6e43d22001d01f", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "在 Windows 上的 pg_ctl 中，通过检查服务状态来决定输出发送到哪里，而不是检查标准输出是否为终端", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}, "url": "/docs/compare/?release=9.4.6#9.4.6-ffc20c3efcf2b89c", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "46bc5c70bec439f4ae601fe91c34c983", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "在 Windows 上的 pg_ctl 中，通过检查服务状态来决定输出发送到哪里，而不是检查标准输出是否为终端", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}, "url": "/docs/compare/?release=9.3.11#9.3.11-ffc20c3efcf2b89c", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "998f6731981001ad75f03a48efe6cfa2", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "在 Windows 上的 pg_ctl 中，通过检查服务状态来决定输出发送到哪里，而不是检查标准输出是否为终端", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}, "url": "/docs/compare/?release=9.2.15#9.2.15-ffc20c3efcf2b89c", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "50a28c9cf76d98dccd0ae115ab281817", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "在 Windows 上的 pg_ctl 中，通过检查服务状态来决定输出发送到哪里，而不是检查标准输出是否为终端", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}, "url": "/docs/compare/?release=9.1.20#9.1.20-ffc20c3efcf2b89c", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-3813de76442f9d72", "cves": [], "html": "

修复 pg_dump 处理扩展成员对象时的若干边界 bug（Tom Lane）

", "text": "修复 pg_dump 处理扩展成员对象时的若干边界 bug（Tom Lane）", "title": "修复 pg_dump 处理扩展成员对象时的若干边界 bug", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "2e319798e33c8ba0526134260735925be957264ad5cb5636acc8bf83d281fe93", "section_path": ["变更"], "commit_groups": [["5108013db", "7393208b5", "b87403f70", "be2b27651", "c42df2d46", "e72d7d853"]], "identity_text": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects (Tom Lane)", "commit_aliases": ["5108013db", "7393208b5", "b87403f70", "be2b27651", "c42df2d46", "e72d7d853"], "source_commits": ["c42df2d46"], "source_entry_id": "9.5.1/changes/009", "db_id": "731b97a7fd7086f0d44dbe80bb27f8a5", "patch_ids": ["47aa462eac36b1bcd14ef32c7166d0e5"], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4", "relations": [{"rule": 2, "type": "equivalent", "target": "2457804d08df483237bb75a8f59d49cd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}}, {"rule": 2, "type": "equivalent", "target": "73af11867b35c973d9c8af24f2b31875", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}}, {"rule": 2, "type": "equivalent", "target": "e630fa430c08c62d366dea55d599cfc4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}}, {"rule": 2, "type": "equivalent", "target": "fadd4c514c362343f3f596b4eee319e5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}}], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "73af11867b35c973d9c8af24f2b31875", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "修复 pg_dump 处理扩展成员对象时的若干边界 bug", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}, "url": "/docs/compare/?release=9.4.6#9.4.6-3813de76442f9d72", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "fadd4c514c362343f3f596b4eee319e5", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "修复 pg_dump 处理扩展成员对象时的若干边界 bug", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}, "url": "/docs/compare/?release=9.3.11#9.3.11-3813de76442f9d72", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "2457804d08df483237bb75a8f59d49cd", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "修复 pg_dump 处理扩展成员对象时的若干边界 bug", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}, "url": "/docs/compare/?release=9.2.15#9.2.15-3813de76442f9d72", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "e630fa430c08c62d366dea55d599cfc4", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "修复 pg_dump 处理扩展成员对象时的若干边界 bug", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}, "url": "/docs/compare/?release=9.1.20#9.1.20-3813de76442f9d72", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-19615b05b0ccc551", "cves": [], "html": "

修复 pg_dump 中域约束名称引用不当的问题（Elvis Pranskevichus）

", "text": "修复 pg_dump 中域约束名称引用不当的问题（Elvis Pranskevichus）", "title": "修复 pg_dump 中域约束名称引用不当的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "4248a4e9dfa49c2be52983f84c88ca0aecbeb76f2008b9dc613ce5042ce8e9b8", "section_path": ["变更"], "commit_groups": [["1e910cf5b", "df43fcf45"]], "identity_text": "Fix improper quoting of domain constraint names in pg_dump (Elvis Pranskevichus)", "commit_aliases": ["1e910cf5b", "df43fcf45"], "source_commits": ["1e910cf5b"], "source_entry_id": "9.5.1/changes/010", "db_id": "0c42970b0b6922a74212ca2a3e41d178", "patch_ids": ["89e8811d9d7fe86c032a439a8c0942b0"], "statement_hash": "aed83ff5617aaa2b75b1d172725cb7b08b3f01cd39781a0ce7ebb41dc8b34156", "relations": [], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-4ac819f6b4fd1f7a", "cves": [], "html": "

使 pg_dump 把视图的触发器标记为需要在其规则之后处理，以防止并行 pg_restore 期间可能出现的失败（Tom Lane）

", "text": "使 pg_dump 把视图的触发器标记为需要在其规则之后处理，以防止并行 pg_restore 期间可能出现的失败（Tom Lane）", "title": "使 pg_dump 把视图的触发器标记为需要在其规则之后处理，以防止并行 pg_restore 期间可能出现的失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "77701c0eed34d059806bb959fb9962cf60619e0e8b5014e1a21b88cd5a15e04f", "section_path": ["变更"], "commit_groups": [["0ed707e9b", "411e2b0d5", "4f58a7003", "9c704632c", "aefbc208b", "b99dd7170"]], "identity_text": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore (Tom Lane)", "commit_aliases": ["0ed707e9b", "411e2b0d5", "4f58a7003", "9c704632c", "aefbc208b", "b99dd7170"], "source_commits": ["b99dd7170"], "source_entry_id": "9.5.1/changes/011", "db_id": "b2e8b7cf11bd9b63b30920bdeb93c80d", "patch_ids": ["f068a51d7bdecc3c0281c9345157d145"], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3", "relations": [{"rule": 2, "type": "equivalent", "target": "639282d960c0c0b620edebea4b414918", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}}, {"rule": 2, "type": "equivalent", "target": "63b8a63bbdbf13afeea084b329b5de75", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}}, {"rule": 2, "type": "equivalent", "target": "7164bcf02cc88ab85c08ce3c606ae32c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}}, {"rule": 2, "type": "equivalent", "target": "e36862b792e753bdfce395af7b742909", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}}], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "7164bcf02cc88ab85c08ce3c606ae32c", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "使 pg_dump 把视图的触发器标记为需要在其规则之后处理，以防止并行 pg_restore 期间可能出现的失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}, "url": "/docs/compare/?release=9.4.6#9.4.6-4ac819f6b4fd1f7a", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "63b8a63bbdbf13afeea084b329b5de75", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "使 pg_dump 把视图的触发器标记为需要在其规则之后处理，以防止并行 pg_restore 期间可能出现的失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}, "url": "/docs/compare/?release=9.3.11#9.3.11-4ac819f6b4fd1f7a", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "e36862b792e753bdfce395af7b742909", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "使 pg_dump 把视图的触发器标记为需要在其规则之后处理，以防止并行 pg_restore 期间可能出现的失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}, "url": "/docs/compare/?release=9.2.15#9.2.15-4ac819f6b4fd1f7a", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "639282d960c0c0b620edebea4b414918", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "使 pg_dump 把视图的触发器标记为需要在其规则之后处理，以防止并行 pg_restore 期间可能出现的失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}, "url": "/docs/compare/?release=9.1.20#9.1.20-4ac819f6b4fd1f7a", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-062bdb6ed6ecd3a0", "cves": [], "html": "

在 pgbench 中加入防护，防止计算脚本指定的除法或取模运算符期间的边界溢出情况（Fabien Coelho、Michael Paquier）

", "text": "在 pgbench 中加入防护，防止计算脚本指定的除法或取模运算符期间的边界溢出情况（Fabien Coelho、Michael Paquier）", "title": "在 pgbench 中加入防护，防止计算脚本指定的除法或取模运算符期间的边界溢出情况", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "aed2a0ec093010ea8eb85c16b4a0826a6d8a11475174d1920558c04aaf69eca5", "section_path": ["变更"], "commit_groups": [["014796aa3", "4c8b07d3c", "64f5edca2", "829757c8a", "b63a4f418", "c33d1a8d5"]], "identity_text": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators (Fabien Coelho, Michael Paquier)", "commit_aliases": ["014796aa3", "4c8b07d3c", "64f5edca2", "829757c8a", "b63a4f418", "c33d1a8d5"], "source_commits": ["829757c8a"], "source_entry_id": "9.5.1/changes/012", "db_id": "9acad733ddf9374f74a8f9a01331be18", "patch_ids": ["dbcead3e052783268db3eb4290d0645b"], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0", "relations": [{"rule": 2, "type": "equivalent", "target": "4429311b4c20fda04d0ca5162000d686", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}}, {"rule": 2, "type": "equivalent", "target": "463b7c278954267c51dffc4cc837224d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}}, {"rule": 2, "type": "equivalent", "target": "8343cc2c0cc89f60b2a1ea88aed18d6f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}}, {"rule": 2, "type": "equivalent", "target": "a93a7956fc7b9f395d4fc12c4ba43568", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}}], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "463b7c278954267c51dffc4cc837224d", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "在 pgbench 中加入防护，防止计算脚本指定的除法或取模运算符期间的边界溢出情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}, "url": "/docs/compare/?release=9.4.6#9.4.6-062bdb6ed6ecd3a0", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "a93a7956fc7b9f395d4fc12c4ba43568", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "在 pgbench 中加入防护，防止计算脚本指定的除法或取模运算符期间的边界溢出情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}, "url": "/docs/compare/?release=9.3.11#9.3.11-062bdb6ed6ecd3a0", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "8343cc2c0cc89f60b2a1ea88aed18d6f", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "在 pgbench 中加入防护，防止计算脚本指定的除法或取模运算符期间的边界溢出情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}, "url": "/docs/compare/?release=9.2.15#9.2.15-062bdb6ed6ecd3a0", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "4429311b4c20fda04d0ca5162000d686", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "在 pgbench 中加入防护，防止计算脚本指定的除法或取模运算符期间的边界溢出情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}, "url": "/docs/compare/?release=9.1.20#9.1.20-062bdb6ed6ecd3a0", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-4ac30fbacbdfc4f6", "cves": [], "html": "

抑制 pg_receivexlog 连接到 9.4 之前服务器时无用的警告消息（Marco Nenciarini）

", "text": "抑制 pg_receivexlog 连接到 9.4 之前服务器时无用的警告消息（Marco Nenciarini）", "title": "抑制 pg_receivexlog 连接到 9.4 之前服务器时无用的警告消息", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "0fe30a54379bd2338d8e58f616c693ea4be90e647c638d9fbad1677f96bd253e", "section_path": ["变更"], "commit_groups": [["4aecd22d3", "7ef311eb4"]], "identity_text": "Suppress useless warning message when pg_receivexlog connects to a pre-9.4 server (Marco Nenciarini)", "commit_aliases": ["4aecd22d3", "7ef311eb4"], "source_commits": ["7ef311eb4"], "source_entry_id": "9.5.1/changes/013", "db_id": "d75f44ac472b001f60323a653062ab34", "patch_ids": ["4f85028094a2ca8f0c0d3adc238c9239"], "statement_hash": "fdb6a52fe1bb01a328d28b47228b6fe4dbd7328b369af638e8993565fbd00755", "relations": [], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-b80acca3e311d56f", "cves": [], "html": "

避免同时使用 plpython2 和 plpython3 时的转储/重载问题（Tom Lane）

\n

原则上，两个版本的 PL/Python 可以在同一个数据库中使用，但不能在同一个会话中使用（因为两个版本的 libpython 无法安全地并发使用）。然而，pg_restore 和 pg_upgrade 都会做一些可能触犯同会话限制的事情。通过更改检查的时机来规避这一点。

", "text": "避免同时使用 plpython2 和 plpython3 时的转储/重载问题（Tom Lane） 原则上，两个版本的 PL/Python 可以在同一个数据库中使用，但不能在同一个会话中使用（因为两个版本的 libpython 无法安全地并发使用）。然而，pg_restore 和 pg_upgrade 都会做一些可能触犯同会话限制的事情。通过更改检查的时机来规避这一点。", "title": "避免同时使用 plpython2 和 plpython3 时的转储/重载问题", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "552fa7de07fa605440aef3fd02ef0ecce882d2734845ecd8afb209ff2f02b59f", "section_path": ["变更"], "commit_groups": [["0ddeaba7e", "22815752e", "3843ba510", "866566a69", "db8fa56d6"], ["5ef26b8de", "fb6fcbd33"]], "identity_text": "Avoid dump/reload problems when using both plpython2 and plpython3 (Tom Lane) In principle, both versions of PL/Python can be used in the same database, though not in the same session (because the two versions of libpython cannot safely be used concurrently). However, pg_restore and pg_upgrade both do things that can fall foul of the same-session restriction. Work around that by changing the timing of the check.", "commit_aliases": ["0ddeaba7e", "22815752e", "3843ba510", "5ef26b8de", "866566a69", "db8fa56d6", "fb6fcbd33"], "source_commits": ["5ef26b8de", "db8fa56d6"], "source_entry_id": "9.5.1/changes/014", "db_id": "73bfe5d2b41d97c4d9debc1380abac6d", "patch_ids": ["33155a03c349caa0f3b86db8350bb26f", "3cbfc8ffb21ad3584938fd2b08b31dfa"], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068", "relations": [{"rule": 2, "type": "equivalent", "target": "5c4e991f8d4a642900a543199662451d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}}, {"rule": 2, "type": "equivalent", "target": "7fdfe610b682c284f5187886cab8f091", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}}, {"rule": 2, "type": "equivalent", "target": "f96612f238be71ec939b6687fd44e0ef", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}}], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "7fdfe610b682c284f5187886cab8f091", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "避免同时使用 plpython2 和 plpython3 时的转储/重载问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}, "url": "/docs/compare/?release=9.4.6#9.4.6-b80acca3e311d56f", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "5c4e991f8d4a642900a543199662451d", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "避免同时使用 plpython2 和 plpython3 时的转储/重载问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}, "url": "/docs/compare/?release=9.3.11#9.3.11-b80acca3e311d56f", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "f96612f238be71ec939b6687fd44e0ef", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "避免同时使用 plpython2 和 plpython3 时的转储/重载问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}, "url": "/docs/compare/?release=9.2.15#9.2.15-b80acca3e311d56f", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}]}, {"id": "9.5.1-98e44a64839adac8", "cves": [], "html": "

修复 PL/Python 回归测试，使其在 Python 3.5 下通过（Peter Eisentraut）

", "text": "修复 PL/Python 回归测试，使其在 Python 3.5 下通过（Peter Eisentraut）", "title": "修复 PL/Python 回归测试，使其在 Python 3.5 下通过", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "5416494c28506e35c4e5c6199da40e786243910596e4da9b594da441a8c96b16", "section_path": ["变更"], "commit_groups": [["82076c1e4", "a37ab812c", "f1b898759"], ["a66c1fcdd"]], "identity_text": "Fix PL/Python regression tests to pass with Python 3.5 (Peter Eisentraut)", "commit_aliases": ["82076c1e4", "a37ab812c", "a66c1fcdd", "f1b898759"], "source_commits": ["a66c1fcdd", "f1b898759"], "source_entry_id": "9.5.1/changes/015", "db_id": "87806806231c4a8aae83fd9987903150", "patch_ids": ["0c0e045e40fea071e4b57a1bc47fc096", "eb846bdeeb31a393a1a53b301d044b79"], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d", "relations": [{"rule": 2, "type": "equivalent", "target": "55b28d130ac75b6dc9cfaabf8bcdb824", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}}, {"rule": 2, "type": "equivalent", "target": "a5ea72bcf0bc30d1ac85879513b1a196", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}}, {"rule": 2, "type": "equivalent", "target": "d386cbd1ac4a9f26bef75a9d608f038a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}}], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d386cbd1ac4a9f26bef75a9d608f038a", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "修复 PL/Python 回归测试，使其在 Python 3.5 下通过", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}, "url": "/docs/compare/?release=9.4.6#9.4.6-98e44a64839adac8", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "a5ea72bcf0bc30d1ac85879513b1a196", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "修复 PL/Python 回归测试，使其在 Python 3.5 下通过", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}, "url": "/docs/compare/?release=9.3.11#9.3.11-98e44a64839adac8", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "55b28d130ac75b6dc9cfaabf8bcdb824", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "修复 PL/Python 回归测试，使其在 Python 3.5 下通过", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}, "url": "/docs/compare/?release=9.2.15#9.2.15-98e44a64839adac8", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}]}, {"id": "9.5.1-4bd6cf6c1d36bca3", "cves": ["CVE-2016-0766"], "html": "

防止某些 PL/Java 参数被非超级用户设置（Noah Misch）

\n

此变更缓解了 PL/Java 的一个安全 bug（CVE-2016-0766），该 bug 在 PL/Java 中已通过把这些参数标记为仅超级用户可用来修复。为了保护那些更新 PostgreSQL 比 PL/Java 更频繁的站点，核心代码现在也识别这些参数。

", "text": "防止某些 PL/Java 参数被非超级用户设置（Noah Misch） 此变更缓解了 PL/Java 的一个安全 bug（CVE-2016-0766），该 bug 在 PL/Java 中已通过把这些参数标记为仅超级用户可用来修复。为了保护那些更新 PostgreSQL 比 PL/Java 更频繁的站点，核心代码现在也识别这些参数。", "title": "防止某些 PL/Java 参数被非超级用户设置", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "65ada80d16c184c7b2bfa993f528e031432a64b029e02243e50a34e77fb06ecc", "section_path": ["变更"], "commit_groups": [["0089dd34a", "34e91736b", "b1f591c50", "de9766d39", "ed6deeb7a", "f4aa3a18a"]], "identity_text": "Prevent certain PL/Java parameters from being set by non-superusers (Noah Misch) This change mitigates a PL/Java security bug (CVE-2016-0766), which was fixed in PL/Java by marking these parameters as superuser-only. To fix the security hazard for sites that update PostgreSQL more frequently than PL/Java, make the core code aware of them also.", "commit_aliases": ["0089dd34a", "34e91736b", "b1f591c50", "de9766d39", "ed6deeb7a", "f4aa3a18a"], "source_commits": ["0089dd34a"], "source_entry_id": "9.5.1/changes/016", "db_id": "97dc39fa0e7bec5e2534a2b04109f605", "patch_ids": ["c03a543ab7fae4ba45f27501433bf595"], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11", "relations": [{"rule": 2, "type": "equivalent", "target": "4917d87c69fd2381f0cd0bb043dd7284", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}}, {"rule": 2, "type": "equivalent", "target": "c75a2e5f772bd39312a83d259c6eca92", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}}, {"rule": 2, "type": "equivalent", "target": "da4a43b885b72a66ad8ccbcf7f4c082b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}}, {"rule": 2, "type": "equivalent", "target": "e039ea2a4900d0587260a96ef5854826", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}}], "version": "9.5.1", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "c75a2e5f772bd39312a83d259c6eca92", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "防止某些 PL/Java 参数被非超级用户设置", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}, "url": "/docs/compare/?release=9.4.6#9.4.6-4bd6cf6c1d36bca3", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "e039ea2a4900d0587260a96ef5854826", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "防止某些 PL/Java 参数被非超级用户设置", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}, "url": "/docs/compare/?release=9.3.11#9.3.11-4bd6cf6c1d36bca3", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "da4a43b885b72a66ad8ccbcf7f4c082b", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "防止某些 PL/Java 参数被非超级用户设置", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}, "url": "/docs/compare/?release=9.2.15#9.2.15-4bd6cf6c1d36bca3", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "4917d87c69fd2381f0cd0bb043dd7284", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "防止某些 PL/Java 参数被非超级用户设置", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}, "url": "/docs/compare/?release=9.1.20#9.1.20-4bd6cf6c1d36bca3", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-265e230ca84c450a", "cves": [], "html": "

修复 ecpg 提供的头文件，使其不包含从预处理指令行延续到下一行的注释（Michael Meskes）

\n

这样的注释会被 ecpg 拒绝。尚不清楚是否应该更改 ecpg 本身。

", "text": "修复 ecpg 提供的头文件，使其不包含从预处理指令行延续到下一行的注释（Michael Meskes） 这样的注释会被 ecpg 拒绝。尚不清楚是否应该更改 ecpg 本身。", "title": "修复 ecpg 提供的头文件，使其不包含从预处理指令行延续到下一行的注释", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "dc136081e9898e255bf89931c5ff9b85e5904e7d50b0a9329a1128145ef8e0df", "section_path": ["变更"], "commit_groups": [["0b55fef39", "40482e606", "79782b407", "7a58d19b0", "d9ce5d201"], ["33b26426e"]], "identity_text": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line (Michael Meskes) Such a comment is rejected by ecpg. It's not yet clear whether ecpg itself should be changed.", "commit_aliases": ["0b55fef39", "33b26426e", "40482e606", "79782b407", "7a58d19b0", "d9ce5d201"], "source_commits": ["33b26426e", "40482e606"], "source_entry_id": "9.5.1/changes/017", "db_id": "25923104378ff078f6db6dfc3a69ed95", "patch_ids": ["1a951dfc20a8eff451ba0d82eabc2f99", "1b977972875e2576ffa817c974a98cdd"], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90", "relations": [{"rule": 2, "type": "equivalent", "target": "0bf8a231c2b475eb4b99b5b31cdf39ee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}}, {"rule": 2, "type": "equivalent", "target": "46427e125a70e51c6f0c98928b775de3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}}, {"rule": 2, "type": "equivalent", "target": "50f0a9e0cfb049a7cead7166e0526ccf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}}, {"rule": 2, "type": "equivalent", "target": "d63bda274e38217adfc55e5c5421c6d9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}}], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "50f0a9e0cfb049a7cead7166e0526ccf", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "修复 ecpg 提供的头文件，使其不包含从预处理指令行延续到下一行的注释", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}, "url": "/docs/compare/?release=9.4.6#9.4.6-265e230ca84c450a", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "d63bda274e38217adfc55e5c5421c6d9", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "修复 ecpg 提供的头文件，使其不包含从预处理指令行延续到下一行的注释", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}, "url": "/docs/compare/?release=9.3.11#9.3.11-265e230ca84c450a", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "46427e125a70e51c6f0c98928b775de3", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "修复 ecpg 提供的头文件，使其不包含从预处理指令行延续到下一行的注释", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}, "url": "/docs/compare/?release=9.2.15#9.2.15-265e230ca84c450a", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "0bf8a231c2b475eb4b99b5b31cdf39ee", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "修复 ecpg 提供的头文件，使其不包含从预处理指令行延续到下一行的注释", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}, "url": "/docs/compare/?release=9.1.20#9.1.20-265e230ca84c450a", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-c90195d020119a21", "cves": [], "html": "

修复 hstore_to_json_loose() 对 hstore 值能否转换为 JSON 数字的测试（Tom Lane）

\n

以前该函数可能被尾部的非字母数字字符欺骗，导致输出语法无效的 JSON。

", "text": "修复 hstore_to_json_loose() 对 hstore 值能否转换为 JSON 数字的测试（Tom Lane） 以前该函数可能被尾部的非字母数字字符欺骗，导致输出语法无效的 JSON。", "title": "修复 hstore_to_json_loose() 对 hstore 值能否转换为 JSON 数字的测试", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "66e58b57c6881dab8412ed70ed75cc97f99b7fe5dfb5851ccc4e3757ae44ba32", "section_path": ["变更"], "commit_groups": [["1c291624b", "1f2b195eb", "aa223a037", "e6ecc93a1"]], "identity_text": "Fix hstore_to_json_loose()'s test for whether an hstore value can be converted to a JSON number (Tom Lane) Previously this function could be fooled by non-alphanumeric trailing characters, leading to emitting syntactically-invalid JSON.", "commit_aliases": ["1c291624b", "1f2b195eb", "aa223a037", "e6ecc93a1"], "source_commits": ["1c291624b"], "source_entry_id": "9.5.1/changes/018", "db_id": "0c8d921d241d195812cf1b0b980d872a", "patch_ids": ["74ddec990a472a59cd4decea8f9df92c"], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8", "relations": [{"rule": 2, "type": "equivalent", "target": "03f2410191b24ef609506ead82abc566", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8"}}, {"rule": 2, "type": "equivalent", "target": "04bda60ae91abda4ba10b35de91c4e22", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8"}}], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "04bda60ae91abda4ba10b35de91c4e22", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "修复 hstore_to_json_loose() 对 hstore 值能否转换为 JSON 数字的测试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8"}, "url": "/docs/compare/?release=9.4.6#9.4.6-c90195d020119a21", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "03f2410191b24ef609506ead82abc566", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "修复 hstore_to_json_loose() 对 hstore 值能否转换为 JSON 数字的测试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8"}, "url": "/docs/compare/?release=9.3.11#9.3.11-c90195d020119a21", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}]}, {"id": "9.5.1-d84eb7aaf1094df9", "cves": [], "html": "

在 contrib/postgres_fdw 中，修复由数据修改命令中使用 tableoid 触发的 bug（Etsuro Fujita、Robert Haas）

", "text": "在 contrib/postgres_fdw 中，修复由数据修改命令中使用 tableoid 触发的 bug（Etsuro Fujita、Robert Haas）", "title": "在 contrib/postgres_fdw 中，修复由数据修改命令中使用 tableoid 触发的 bug", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "43331eab26eba41b01203a6c31a5dd2d7b0cf29e431cd84ad3bd9735e0fbc60b", "section_path": ["变更"], "commit_groups": [["1f3294c22", "453d40817", "9418d79a7"], ["2099b911d", "37c84570b", "d160e2a34"]], "identity_text": "In contrib/postgres_fdw, fix bugs triggered by use of tableoid in data-modifying commands (Etsuro Fujita, Robert Haas)", "commit_aliases": ["1f3294c22", "2099b911d", "37c84570b", "453d40817", "9418d79a7", "d160e2a34"], "source_commits": ["453d40817", "d160e2a34"], "source_entry_id": "9.5.1/changes/019", "db_id": "c4c2ba6603cd54bca3e4d0558afedff5", "patch_ids": ["b8f1a6a792d35e65d2c8f40a017b8491", "f3086b86a159941be300c18eec4c5247"], "statement_hash": "b50820b450dca25e0fa742e53e3618238b1e7b8647181de22971a4a85648ed32", "relations": [{"rule": 2, "type": "equivalent", "target": "d7c09d03805867d10fad0549fb0b2120", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b50820b450dca25e0fa742e53e3618238b1e7b8647181de22971a4a85648ed32"}}], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7c09d03805867d10fad0549fb0b2120", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "修复contrib/postgres_fdw中在数据修改命令中使用tableoid触发的缺陷", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b50820b450dca25e0fa742e53e3618238b1e7b8647181de22971a4a85648ed32"}, "url": "/docs/compare/?release=9.4.6#9.4.6-2bcb159d4f53dbc2", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}]}, {"id": "9.5.1-5a2d0dce15184965", "cves": [], "html": "

修复把 NAMEDATALEN 限制为小于 256 的不当约束（Robert Haas、Tom Lane）

", "text": "修复把 NAMEDATALEN 限制为小于 256 的不当约束（Robert Haas、Tom Lane）", "title": "修复把 NAMEDATALEN 限制为小于 256 的不当约束", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "2d5f7aa2020be3dcccd8c9eeee360e950465d41f546a599de3488ff79264340b", "section_path": ["变更"], "commit_groups": [["47acf3add", "a396144ac"]], "identity_text": "Fix ill-advised restriction of NAMEDATALEN to be less than 256 (Robert Haas, Tom Lane)", "commit_aliases": ["47acf3add", "a396144ac"], "source_commits": ["47acf3add"], "source_entry_id": "9.5.1/changes/020", "db_id": "331ac25a117f5cde477b5b290ff37df8", "patch_ids": ["b6c98bb271905aaeb3ad961fb409d279"], "statement_hash": "f22a31f1117714a6171d61007f2b54fe10f01f1b5c404997c3c0fd82471950a5", "relations": [], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-e403ee59d1b1487c", "cves": [], "html": "

通过确保以固定顺序向链接器提供文件名，提高构建输出的可重现性（Christoph Berg）

\n

这避免了产生的可执行文件在不同构建之间可能出现按位差异。

", "text": "通过确保以固定顺序向链接器提供文件名，提高构建输出的可重现性（Christoph Berg） 这避免了产生的可执行文件在不同构建之间可能出现按位差异。", "title": "通过确保以固定顺序向链接器提供文件名，提高构建输出的可重现性", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "199fdef18ba63db71265f40385e6d5746ff6dcde6f83d902e00915b4855978e3", "section_path": ["变更"], "commit_groups": [["3343ea9e8", "6d899f098", "8805af088", "8c558b2e9"]], "identity_text": "Improve reproducibility of build output by ensuring filenames are given to the linker in a fixed order (Christoph Berg) This avoids possible bitwise differences in the produced executable files from one build to the next.", "commit_aliases": ["3343ea9e8", "6d899f098", "8805af088", "8c558b2e9"], "source_commits": ["8805af088"], "source_entry_id": "9.5.1/changes/021", "db_id": "f7e1414cc27ba5e639b640d4543e7178", "patch_ids": ["828b2fb73c9968b9f9e55f2c8cd0976a"], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2", "relations": [{"rule": 2, "type": "equivalent", "target": "6c585d6778a3d2697d5dcc424f1d350c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2"}}, {"rule": 2, "type": "equivalent", "target": "7866311e30659f5004aabe65ed6de911", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2"}}], "version": "9.5.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "7866311e30659f5004aabe65ed6de911", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "通过确保以固定顺序向链接器提供文件名，提高构建输出的可重现性", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2"}, "url": "/docs/compare/?release=9.4.6#9.4.6-e403ee59d1b1487c", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "6c585d6778a3d2697d5dcc424f1d350c", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "通过确保以固定顺序向链接器提供文件名，提高构建输出的可重现性", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2"}, "url": "/docs/compare/?release=9.3.11#9.3.11-e403ee59d1b1487c", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}]}, {"id": "9.5.1-a9f19425bc6a02bc", "cves": [], "html": "

确保 dynloader.h 包含在 MSVC 构建安装的头文件中（Bruce Momjian、Michael Paquier）

", "text": "确保 dynloader.h 包含在 MSVC 构建安装的头文件中（Bruce Momjian、Michael Paquier）", "title": "确保 dynloader.h 包含在 MSVC 构建安装的头文件中", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "aeda060b735fbc220542de8d385a4decdba8f6d898707cb355495b9cb3e1fa7d", "section_path": ["变更"], "commit_groups": [["216d56843", "34bda20ae", "49d65e857", "7a47262ce", "8b3d52801", "b1bc38144"]], "identity_text": "Ensure that dynloader.h is included in the installed header files in MSVC builds (Bruce Momjian, Michael Paquier)", "commit_aliases": ["216d56843", "34bda20ae", "49d65e857", "7a47262ce", "8b3d52801", "b1bc38144"], "source_commits": ["34bda20ae"], "source_entry_id": "9.5.1/changes/022", "db_id": "da1850390a9c1f327882277c4eb3def9", "patch_ids": ["878e29a9bf792d0f42bad5cb4d088176"], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83", "relations": [{"rule": 2, "type": "equivalent", "target": "24615ed3777f4cc8415f1be5cb3c6886", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}}, {"rule": 2, "type": "equivalent", "target": "3620494c7d45e6dfc1d177208fe06745", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}}, {"rule": 2, "type": "equivalent", "target": "d7a602e7b3be1c6f91455ba18fac8ae3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}}, {"rule": 2, "type": "equivalent", "target": "f15b775bc084b37a970dbfe86e6aba76", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}}], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7a602e7b3be1c6f91455ba18fac8ae3", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "确保 MSVC 构建中安装的头文件包含dynloader.h", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}, "url": "/docs/compare/?release=9.4.6#9.4.6-4bace5f9003e475f", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "24615ed3777f4cc8415f1be5cb3c6886", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "确保 dynloader.h 包含在 MSVC 构建安装的头文件中", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}, "url": "/docs/compare/?release=9.3.11#9.3.11-a9f19425bc6a02bc", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "3620494c7d45e6dfc1d177208fe06745", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "确保 dynloader.h 包含在 MSVC 构建安装的头文件中", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}, "url": "/docs/compare/?release=9.2.15#9.2.15-a9f19425bc6a02bc", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "f15b775bc084b37a970dbfe86e6aba76", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "确保 dynloader.h 包含在 MSVC 构建安装的头文件中", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}, "url": "/docs/compare/?release=9.1.20#9.1.20-a9f19425bc6a02bc", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}, {"id": "9.5.1-4a8856bb6c168e90", "cves": [], "html": "

把时区数据文件更新到 tzdata 2016a 版，涉及开曼群岛、梅特拉卡特拉和外贝加尔边疆区的夏令时法规变更，以及巴基斯坦的历史数据修正。

", "text": "把时区数据文件更新到 tzdata 2016a 版，涉及开曼群岛、梅特拉卡特拉和外贝加尔边疆区的夏令时法规变更，以及巴基斯坦的历史数据修正。", "title": "把时区数据文件更新到 tzdata 2016a 版，涉及开曼群岛、梅特拉卡特拉和外贝加尔边疆区的夏令时法规变更，以及巴基斯坦的历史数据修正。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.5.1/#id-1.11.6.29.5", "source_hash": "0de04b7c71cb7bf3b6c6f53e7740a355957f07616d0fef41ee07fc13a33efe77", "section_path": ["变更"], "commit_groups": [["31b792f61", "32f17a2e7", "37e694632", "6887d72d0", "9a3475b84", "a73311e52"]], "identity_text": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.", "commit_aliases": ["31b792f61", "32f17a2e7", "37e694632", "6887d72d0", "9a3475b84", "a73311e52"], "source_commits": ["37e694632"], "source_entry_id": "9.5.1/changes/023", "db_id": "5597e80195585ed30008c59306886b22", "patch_ids": ["2c0e98564b1797f57b28da97f4f95fc4"], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8", "relations": [{"rule": 2, "type": "equivalent", "target": "2dd502f3961a7bc4d19efd4ee63e9da5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}}, {"rule": 2, "type": "equivalent", "target": "dcb5b295c36a7627a763f51c946763ec", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}}, {"rule": 2, "type": "equivalent", "target": "dfb917d07e1c239db68c9dd1bf24ca9a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}}, {"rule": 2, "type": "equivalent", "target": "f08f6b2c87032eb0ae56d29afd228106", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}}], "version": "9.5.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f08f6b2c87032eb0ae56d29afd228106", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "将时区数据文件更新到tzdata发行版 2016a，以反映开曼群岛、梅特拉卡特拉和外贝加尔边疆区的夏令时法规变更，以及巴基斯坦的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}, "url": "/docs/compare/?release=9.4.6#9.4.6-e5191de67210fcce", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}, {"db_id": "2dd502f3961a7bc4d19efd4ee63e9da5", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "把时区数据文件更新到 tzdata 2016a 版，涉及开曼群岛、梅特拉卡特拉和外贝加尔边疆区的夏令时法规变更，以及巴基斯坦的历史数据修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}, "url": "/docs/compare/?release=9.3.11#9.3.11-4a8856bb6c168e90", "source_url": "/docs/release/9.3.11/#id-1.11.6.19.5"}, {"db_id": "dcb5b295c36a7627a763f51c946763ec", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "把时区数据文件更新到 tzdata 2016a 版，涉及开曼群岛、梅特拉卡特拉和外贝加尔边疆区的夏令时法规变更，以及巴基斯坦的历史数据修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}, "url": "/docs/compare/?release=9.2.15#9.2.15-4a8856bb6c168e90", "source_url": "/docs/release/9.2.15/#id-1.11.6.14.5"}, {"db_id": "dfb917d07e1c239db68c9dd1bf24ca9a", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "把时区数据文件更新到 tzdata 2016a 版，涉及开曼群岛、梅特拉卡特拉和外贝加尔边疆区的夏令时法规变更，以及巴基斯坦的历史数据修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}, "url": "/docs/compare/?release=9.1.20#9.1.20-4a8856bb6c168e90", "source_url": "/docs/release/9.1.20/#id-1.11.6.9.5"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 23}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 12}, {"key": "security", "label": "安全相关", "count": 2}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 9}], "total": 23, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2016-0773", "url": "https://www.postgresql.org/support/security/CVE-2016-0773/", "fixed": {"9.1": "9.1.20", "9.2": "9.2.15", "9.3": "9.3.11", "9.4": "9.4.6", "9.5": "9.5.1"}, "score": 6.5, "title": "修复正则表达式中的无限循环和缓冲区越界问题", "vector": "AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:L/A:H", "affected": {"9.1": "9.1", "9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5"}, "component": "core server", "published": {"9.1": "2016-02-11", "9.2": "2016-02-11", "9.3": "2016-02-11", "9.4": "2016-02-11", "9.5": "2016-02-11"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2016-02-11", "fixed_version": "9.5.1"}, {"id": "CVE-2016-0766", "url": "https://www.postgresql.org/support/security/CVE-2016-0766/", "fixed_version": "", "title": "防止某些 PL/Java 参数被非超级用户设置"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 23, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}