对于运行 9.2.X 的用户，不需要进行转储/恢复。
不过，如果你是从早于 9.2.22 的版本升级，请参见第 E.3 节。
", "compatibility_count": 0, "label": "9.2.24", "status_label": "历史版本", "eol": "2017-11-09", "age_days": 3247, "support_days": -3247}, "groups": [{"date": "2017-11-09", "build": "9.2.24", "major": "9.2", "minor": 24, "manual": "9.2", "status": "stable", "doc_git": "", "version": "9.2.24", "eol_date": "2017-11-09", "date_text": "2017-11-09", "supported": false, "manual_url": "/docs/9.2/release-9-2-24.html", "source_url": "/docs/release/9.2.24/", "entry_count": 13, "placeholder": false, "content_hash": "595a483e1c878648669e2b20ee322ea53ea2dee3cca40662660b3b3a255f13de", "manual_build": "9.2.24", "source_as_of": "", "changes_count": 13, "doc_loaded_at": "2026-09-26T02:56:46.946617", "migration_html": "对于运行 9.2.X 的用户，不需要进行转储/恢复。
不过，如果你是从早于 9.2.22 的版本升级，请参见第 E.3 节。
", "compatibility_count": 0, "label": "9.2.24", "status_label": "历史版本", "eol": "2017-11-09", "age_days": 3247, "support_days": -3247, "entries": [{"id": "9.2.24-b695ceda5feee1ee", "cves": ["CVE-2017-12172"], "html": " 修复示例服务器启动脚本在打开 $PGLOG 之前变成\n $PGUSER（Noah Misch）\n
此前，postmaster 日志文件是在仍以 root 运行时打开的。因此数据库所有者可以通过让 $PGLOG 成为指向某个其他文件的符号链接来攻击另一个系统用户，该文件随后会因追加日志消息而被损坏。\n
默认情况下这些脚本不会安装到任何地方。使用了它们的用户需要手动重新复制，或对其修改版应用相同的更改。如果现有的\n $PGLOG 文件为 root 所有，在用修正后的脚本重启服务器之前需要把它移开或重命名。（CVE-2017-12172）\n
正确拒绝把无穷大浮点值转换为 numeric 类型的尝试（Tom Lane、KaiGai Kohei）\n
此前行为是与平台相关的。\n
", "text": "正确拒绝把无穷大浮点值转换为 numeric 类型的尝试（Tom Lane、KaiGai Kohei） 此前行为是与平台相关的。", "title": "正确拒绝把无穷大浮点值转换为 numeric 类型的尝试", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.24/#id-1.11.6.5.6", "source_hash": "06b92165868a31ca4a066e8fe73f59e1a9ec1a91c233a2746cba24224e0155cd", "section_path": ["变更"], "commit_groups": [], "identity_text": "Properly reject attempts to convert infinite float values to type numeric (Tom Lane, KaiGai Kohei) Previously the behavior was platform-dependent.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.24/changes/002", "db_id": "6fb383dce08a3cd1787f8492c5c597a7", "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9", "relations": [{"rule": 2, "type": "equivalent", "target": "1c3b664e169e7db957bffb63f49a583a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}}, {"rule": 2, "type": "equivalent", "target": "37d688fc8a40beae324922612cd078f9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}}, {"rule": 2, "type": "equivalent", "target": "4099b281f3b22fd6d6338ef9038b428f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}}, {"rule": 2, "type": "equivalent", "target": "f478875aa928332b3c7de8354b92e99d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}}], "version": "9.2.24", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f478875aa928332b3c7de8354b92e99d", "kind": "equivalent", "version": "9.6.6", "label": "9.6.6", "title": "正确拒绝把无穷大浮点值转换为 numeric 类型的尝试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}, "url": "/docs/compare/?release=9.6.6#9.6.6-c236d03a7517be54", "source_url": "/docs/release/9.6.6/#id-1.11.6.23.5"}, {"db_id": "4099b281f3b22fd6d6338ef9038b428f", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "正确拒绝把无穷大浮点值转换为 numeric 类型的尝试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}, "url": "/docs/compare/?release=9.5.10#9.5.10-c236d03a7517be54", "source_url": "/docs/release/9.5.10/#id-1.11.6.20.5"}, {"db_id": "37d688fc8a40beae324922612cd078f9", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "正确拒绝把无穷大浮点值转换为 numeric 类型的尝试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}, "url": "/docs/compare/?release=9.4.15#9.4.15-c236d03a7517be54", "source_url": "/docs/release/9.4.15/#id-1.11.6.16.5"}, {"db_id": "1c3b664e169e7db957bffb63f49a583a", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "正确拒绝把无穷大浮点值转换为 numeric 类型的尝试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}, "url": "/docs/compare/?release=9.3.20#9.3.20-c236d03a7517be54", "source_url": "/docs/release/9.3.20/#id-1.11.6.10.5"}]}, {"id": "9.2.24-98a6704c482fbe65", "cves": [], "html": "修复在视图末尾添加列后的边界崩溃（Tom Lane）\n
", "text": "修复在视图末尾添加列后的边界崩溃（Tom Lane）", "title": "修复在视图末尾添加列后的边界崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.24/#id-1.11.6.5.6", "source_hash": "7665bd6471f17435461f82cd3ba33cc010afeb4080c8a8cd7897c3dd32b6ff69", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix corner-case crashes when columns have been added to the end of a view (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.24/changes/003", "db_id": "8df8e065b7c9084d432bf1eb20ebef6f", "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf", "relations": [{"rule": 2, "type": "equivalent", "target": "5dd9112df0daa106089cd18015b5f07c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}, {"rule": 2, "type": "equivalent", "target": "89c8e733fdead3c204e3786e2b7c350d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}, {"rule": 2, "type": "equivalent", "target": "8a7b9b004774c09111b17cb617d4a36d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}, {"rule": 2, "type": "equivalent", "target": "ecb8d6ca4538276779e5fb096fe8c30a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}, {"rule": 2, "type": "equivalent", "target": "ef97718edf710920c1ada79e912a7394", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}], "version": "9.2.24", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ef97718edf710920c1ada79e912a7394", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "修复在视图末尾添加列时的极端情况崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=10.1#10.1-6025f14bd0231868", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "8a7b9b004774c09111b17cb617d4a36d", "kind": "equivalent", "version": "9.6.6", "label": "9.6.6", "title": "修复在视图末尾添加列后的边界崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=9.6.6#9.6.6-98a6704c482fbe65", "source_url": "/docs/release/9.6.6/#id-1.11.6.23.5"}, {"db_id": "89c8e733fdead3c204e3786e2b7c350d", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "修复在视图末尾添加列后的边界崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=9.5.10#9.5.10-98a6704c482fbe65", "source_url": "/docs/release/9.5.10/#id-1.11.6.20.5"}, {"db_id": "ecb8d6ca4538276779e5fb096fe8c30a", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "修复在视图末尾添加列后极端情况下崩溃的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=9.4.15#9.4.15-a372add8964a05a5", "source_url": "/docs/release/9.4.15/#id-1.11.6.16.5"}, {"db_id": "5dd9112df0daa106089cd18015b5f07c", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "修复在视图末尾添加列后的边界崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=9.3.20#9.3.20-98a6704c482fbe65", "source_url": "/docs/release/9.3.20/#id-1.11.6.10.5"}]}, {"id": "9.2.24-4afb8b5079afaf49", "cves": [], "html": " 在视图或规则包含 FieldSelect 或\n FieldStore 表达式节点时记录正确的依赖（Tom Lane）\n
缺少这些依赖可能允许本应失败的列或数据类型 DROP\n 成功执行，从而导致之后使用该视图或规则时出错。此补丁不会保护现有视图/规则，只保护将来创建的。\n
正确检测范围数据类型的可哈希性（Tom Lane）\n
规划器错误地假定任何范围类型都可以哈希用于哈希连接或哈希聚合，但实际上必须检查范围的子类型是否有哈希支持。这不影响任何内置范围类型，因为它们反正都是可哈希的。\n
", "text": "正确检测范围数据类型的可哈希性（Tom Lane） 规划器错误地假定任何范围类型都可以哈希用于哈希连接或哈希聚合，但实际上必须检查范围的子类型是否有哈希支持。这不影响任何内置范围类型，因为它们反正都是可哈希的。", "title": "正确检测范围数据类型的可哈希性", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.24/#id-1.11.6.5.6", "source_hash": "e17e39b07ccca74744ce6855712b2c1ad5406c1fa916a31f2f3135f8a87ccc32", "section_path": ["变更"], "commit_groups": [], "identity_text": "Correctly detect hashability of range data types (Tom Lane) The planner mistakenly assumed that any range type could be hashed for use in hash joins or hash aggregation, but actually it must check whether the range's subtype has hash support. This does not affect any of the built-in range types, since they're all hashable anyway.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.24/changes/005", "db_id": "879a1f89d800c2786255bd2ed0d83cfb", "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f", "relations": [{"rule": 2, "type": "equivalent", "target": "1f0ededa100214388e94db4ee785cdd1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}, {"rule": 2, "type": "equivalent", "target": "29fb35dd9919703bc165f056b889dd49", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}, {"rule": 2, "type": "equivalent", "target": "402b5b239a6a0c7dee3485212563f74e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}, {"rule": 2, "type": "equivalent", "target": "7d936341e4451a5527c1deda00cdb8e5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}, {"rule": 2, "type": "equivalent", "target": "c320085ab5e747c8994f3bccf936161f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}], "version": "9.2.24", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "7d936341e4451a5527c1deda00cdb8e5", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "正确检测范围数据类型是否支持 hash 运算", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=10.1#10.1-b9909fcb91ea910e", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "c320085ab5e747c8994f3bccf936161f", "kind": "equivalent", "version": "9.6.6", "label": "9.6.6", "title": "正确检测范围数据类型的可哈希性", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=9.6.6#9.6.6-4c6bea1fab68c8a1", "source_url": "/docs/release/9.6.6/#id-1.11.6.23.5"}, {"db_id": "29fb35dd9919703bc165f056b889dd49", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "正确检测范围数据类型的可哈希性", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=9.5.10#9.5.10-4c6bea1fab68c8a1", "source_url": "/docs/release/9.5.10/#id-1.11.6.20.5"}, {"db_id": "1f0ededa100214388e94db4ee785cdd1", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "正确检测范围数据类型的可哈希性", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=9.4.15#9.4.15-4c6bea1fab68c8a1", "source_url": "/docs/release/9.4.15/#id-1.11.6.16.5"}, {"db_id": "402b5b239a6a0c7dee3485212563f74e", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "正确检测范围数据类型的可哈希性", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=9.3.20#9.3.20-4c6bea1fab68c8a1", "source_url": "/docs/release/9.3.20/#id-1.11.6.10.5"}]}, {"id": "9.2.24-8ad2c3361ed421f1", "cves": [], "html": " 修复因 XID 回卷导致的低概率 NOTIFY 消息丢失（Marko Tiikkaja、Tom Lane）\n
如果一个会话在超过 20 亿个事务期间不执行查询而只是监听通知，它就开始遗漏来自并发提交事务的一些通知。\n
", "text": "修复因 XID 回卷导致的低概率 NOTIFY 消息丢失（Marko Tiikkaja、Tom Lane） 如果一个会话在超过 20 亿个事务期间不执行查询而只是监听通知，它就开始遗漏来自并发提交事务的一些通知。", "title": "修复因 XID 回卷导致的低概率 NOTIFY 消息丢失", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.24/#id-1.11.6.5.6", "source_hash": "145f9966f0f7ba240fcf6250d93d493c03c8d85a939083ff03de885b2fbf8ba7", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix low-probability loss of NOTIFY messages due to XID wraparound (Marko Tiikkaja, Tom Lane) If a session executed no queries, but merely listened for notifications, for more than 2 billion transactions, it started to miss some notifications from concurrently-committing transactions.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.24/changes/006", "db_id": "6e8a2efa855582392f8aa8b4b0e0a368", "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33", "relations": [{"rule": 2, "type": "equivalent", "target": "05363bfd016c01f9ff8549467d914e00", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}, {"rule": 2, "type": "equivalent", "target": "4b506c21e755bed67a575660d8226d50", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}, {"rule": 2, "type": "equivalent", "target": "89fcaef7b09acb5d6956f7d490688e6c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}, {"rule": 2, "type": "equivalent", "target": "b1531f77e7bfc7c36f8dcd1febcf51d1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}, {"rule": 2, "type": "equivalent", "target": "bd64297a2b9915f0c99497279540ff3d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}], "version": "9.2.24", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b506c21e755bed67a575660d8226d50", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "修复 XID 回卷导致 NOTIFY 消息以低概率丢失的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=10.1#10.1-1aee059b986c876c", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "05363bfd016c01f9ff8549467d914e00", "kind": "equivalent", "version": "9.6.6", "label": "9.6.6", "title": "修复因 XID 回卷导致的低概率 NOTIFY 消息丢失", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=9.6.6#9.6.6-8ad2c3361ed421f1", "source_url": "/docs/release/9.6.6/#id-1.11.6.23.5"}, {"db_id": "b1531f77e7bfc7c36f8dcd1febcf51d1", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "修复因 XID 回卷导致的低概率 NOTIFY 消息丢失", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=9.5.10#9.5.10-8ad2c3361ed421f1", "source_url": "/docs/release/9.5.10/#id-1.11.6.20.5"}, {"db_id": "89fcaef7b09acb5d6956f7d490688e6c", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "修复因 XID 回卷导致的低概率 NOTIFY 消息丢失", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=9.4.15#9.4.15-8ad2c3361ed421f1", "source_url": "/docs/release/9.4.15/#id-1.11.6.16.5"}, {"db_id": "bd64297a2b9915f0c99497279540ff3d", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "修复因 XID 回卷导致的低概率 NOTIFY 消息丢失", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=9.3.20#9.3.20-8ad2c3361ed421f1", "source_url": "/docs/release/9.3.20/#id-1.11.6.10.5"}]}, {"id": "9.2.24-08ada9d5eb58d26c", "cves": [], "html": "防止嵌套触发器触发处理中的低概率崩溃（Tom Lane）\n
", "text": "防止嵌套触发器触发处理中的低概率崩溃（Tom Lane）", "title": "防止嵌套触发器触发处理中的低概率崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.24/#id-1.11.6.5.6", "source_hash": "ef4a5995c55ce34e3598510b98217b849d3e836cc4c643c5ddb0ba61514212e6", "section_path": ["变更"], "commit_groups": [], "identity_text": "Prevent low-probability crash in processing of nested trigger firings (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.24/changes/007", "db_id": "90bab2f383d8aeb7b288d90321649ca0", "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27", "relations": [{"rule": 2, "type": "equivalent", "target": "0a1940517915a4c2940506f17a5eb707", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}}, {"rule": 2, "type": "equivalent", "target": "cf10bd02853e41f70bc1a6f1202f41a5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}}, {"rule": 2, "type": "equivalent", "target": "ed52e2c3034cd22ee4499e231c7702e6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}}, {"rule": 2, "type": "equivalent", "target": "ee96714487e8ca74fd6a107b83a6e2ff", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}}], "version": "9.2.24", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed52e2c3034cd22ee4499e231c7702e6", "kind": "equivalent", "version": "9.6.6", "label": "9.6.6", "title": "防止嵌套触发器触发处理中的低概率崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}, "url": "/docs/compare/?release=9.6.6#9.6.6-08ada9d5eb58d26c", "source_url": "/docs/release/9.6.6/#id-1.11.6.23.5"}, {"db_id": "cf10bd02853e41f70bc1a6f1202f41a5", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "防止嵌套触发器触发处理中的低概率崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}, "url": "/docs/compare/?release=9.5.10#9.5.10-08ada9d5eb58d26c", "source_url": "/docs/release/9.5.10/#id-1.11.6.20.5"}, {"db_id": "ee96714487e8ca74fd6a107b83a6e2ff", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "防止嵌套触发器触发处理中低概率的崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}, "url": "/docs/compare/?release=9.4.15#9.4.15-77d78ae4918aeda4", "source_url": "/docs/release/9.4.15/#id-1.11.6.16.5"}, {"db_id": "0a1940517915a4c2940506f17a5eb707", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "防止嵌套触发器触发处理中的低概率崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}, "url": "/docs/compare/?release=9.3.20#9.3.20-08ada9d5eb58d26c", "source_url": "/docs/release/9.3.20/#id-1.11.6.10.5"}]}, {"id": "9.2.24-f8c0de6d6a3a6766", "cves": [], "html": " COPY 或 lo_export() 中文件创建失败时正确恢复 umask 设置（Peter Eisentraut）\n
为 ANALYZE 中的重复列名给出更好的错误消息（Nathan Bossart）\n
修复 libpq 不要求用户的主目录存在（Tom Lane）\n
在 v10 中，尝试读取 ~/.pgpass 时找不到主目录被当作硬错误，但它应该只是导致找不到该文件。v10 和以前的发布分支在读取 ~/.pg_service.conf 时犯了同样的错误，不过这不太明显，因为除非指定了服务名否则不寻找该文件。\n
修复 libpq 防范\n PGresult 行数中的整数溢出（Michael Paquier）\n
把我们的时区库副本与 IANA tzcode2017c 同步（Tom Lane）\n
这修复了若干问题；唯一可能对用户可见的是，当时区数据目录中没有\n posixrules 文件时，POSIX 风格时区名的默认夏令时规则现在匹配当前美国法律而不是十几年前的。\n
更新时区数据文件到 tzdata 版本 2017c，涉及斐济、纳米比亚、北塞浦路斯、苏丹、汤加以及特克斯和凯科斯群岛的夏令时法规变更，加上阿拉斯加、阿皮亚、缅甸、加尔各答、底特律、爱尔兰、纳米比亚和帕果帕果的历史修正。\n
", "text": "更新时区数据文件到 tzdata 版本 2017c，涉及斐济、纳米比亚、北塞浦路斯、苏丹、汤加以及特克斯和凯科斯群岛的夏令时法规变更，加上阿拉斯加、阿皮亚、缅甸、加尔各答、底特律、爱尔兰、纳米比亚和帕果帕果的历史修正。", "title": "更新时区数据文件到 tzdata 版本 2017c，涉及斐济、纳米比亚、北塞浦路斯、苏丹、汤加以及特克斯和凯科斯群岛的夏令时法规变更，加上阿拉斯加、阿皮亚、缅甸、加尔各答、底特律、爱尔兰、纳米比亚和帕果帕果的历史修正。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.24/#id-1.11.6.5.6", "source_hash": "76d48a43ee33c8746bb6f8063ec88e7cadb450bdd45a77f4e13059ff3ce47ce1", "section_path": ["变更"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.24/changes/013", "db_id": "cc4690a822d3cdb953a0494112d06b92", "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8", "relations": [{"rule": 2, "type": "equivalent", "target": "293143bd1bebf2fa099b043849086024", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}, {"rule": 2, "type": "equivalent", "target": "41fa2b66666f8560149b4e828a789f52", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}, {"rule": 2, "type": "equivalent", "target": "5063230b1a3750ce6e2d9f3ced8caedc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}, {"rule": 2, "type": "equivalent", "target": "85588d39e9c7e704df909e151fc0201f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}, {"rule": 2, "type": "equivalent", "target": "ecc97112734f3476d067fd7dbbf430da", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}], "version": "9.2.24", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "ecc97112734f3476d067fd7dbbf430da", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "将时区数据文件更新到 tzdata 2017c 版，以反映斐济、纳米比亚、北塞浦路斯、苏丹、汤加和特克斯 & 凯科斯群岛的夏令时法规变更，并修正阿拉斯加、阿皮亚、缅甸、加尔各答、底特律、爱尔兰、纳米比亚和帕果帕果的历史数据。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=10.1#10.1-4014adbaf08d9687", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "293143bd1bebf2fa099b043849086024", "kind": "equivalent", "version": "9.6.6", "label": "9.6.6", "title": "更新时区数据文件到 tzdata 版本 2017c，涉及斐济、纳米比亚、北塞浦路斯、苏丹、汤加以及特克斯和凯科斯群岛的夏令时法规变更，加上阿拉斯加、阿皮亚、缅甸、加尔各答、底特律、爱尔兰、纳米比亚和帕果帕果的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=9.6.6#9.6.6-c140c362332e493c", "source_url": "/docs/release/9.6.6/#id-1.11.6.23.5"}, {"db_id": "85588d39e9c7e704df909e151fc0201f", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "更新时区数据文件到 tzdata 版本 2017c，涉及斐济、纳米比亚、北塞浦路斯、苏丹、汤加以及特克斯和凯科斯群岛的夏令时法规变更，加上阿拉斯加、阿皮亚、缅甸、加尔各答、底特律、爱尔兰、纳米比亚和帕果帕果的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=9.5.10#9.5.10-c140c362332e493c", "source_url": "/docs/release/9.5.10/#id-1.11.6.20.5"}, {"db_id": "5063230b1a3750ce6e2d9f3ced8caedc", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "将时区数据文件更新到tzdata发行版 2017c，以反映斐济、纳米比亚、北塞浦路斯、苏丹、汤加以及特克斯和凯科斯群岛的夏令时法规变更，以及阿拉斯加、阿皮亚、缅甸、加尔各答、底特律、爱尔兰、纳米比亚和帕果帕果的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=9.4.15#9.4.15-3732889a8bc3ae53", "source_url": "/docs/release/9.4.15/#id-1.11.6.16.5"}, {"db_id": "41fa2b66666f8560149b4e828a789f52", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "更新时区数据文件到 tzdata 版本 2017c，涉及斐济、纳米比亚、北塞浦路斯、苏丹、汤加以及特克斯和凯科斯群岛的夏令时法规变更，加上阿拉斯加、阿皮亚、缅甸、加尔各答、底特律、爱尔兰、纳米比亚和帕果帕果的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=9.3.20#9.3.20-c140c362332e493c", "source_url": "/docs/release/9.3.20/#id-1.11.6.10.5"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 13}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 5}, {"key": "security", "label": "安全相关", "count": 1}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 7}], "total": 13, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2017-12172", "url": "https://www.postgresql.org/support/security/CVE-2017-12172/", "fixed": {"10": "10.1", "9.2": "9.2.24", "9.3": "9.3.20", "9.4": "9.4.15", "9.5": "9.5.10", "9.6": "9.6.6"}, "score": 8.4, "title": "修复示例服务器启动脚本在打开 $PGLOG 之前变成 $PGUSER", "vector": "AV:N/AC:L/PR:H/UI:R/S:C/C:H/I:H/A:H", "affected": {"10": "10", "9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "contrib module", "published": {"10": "2017-11-09", "9.2": "2017-11-09", "9.3": "2017-11-09", "9.4": "2017-11-09", "9.5": "2017-11-09", "9.6": "2017-11-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-11-09", "fixed_version": "9.2.24"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 13, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}