对于运行 9.0.X 的用户，不需要进行转储/恢复。
", "compatibility_count": 0, "label": "9.0.2", "status_label": "历史版本", "eol": "2015-10-08", "age_days": 5767, "support_days": -4010}, "groups": [{"date": "2010-12-16", "build": "9.0.2", "major": "9.0", "minor": 2, "manual": "9.0", "status": "stable", "doc_git": "", "version": "9.0.2", "eol_date": "2015-10-08", "date_text": "2010-12-16", "supported": false, "manual_url": "/docs/9.0/release-9-0-2.html", "source_url": "/docs/release/9.0.2/", "entry_count": 42, "placeholder": false, "content_hash": "74d2219c591db7824c1cdf20cea79a39f64bbc2735e18896281b8550deaf7ea0", "manual_build": "9.0.23", "source_as_of": "", "changes_count": 42, "doc_loaded_at": "2026-09-26T02:56:48.570247", "migration_html": "对于运行 9.0.X 的用户，不需要进行转储/恢复。
", "compatibility_count": 0, "label": "9.0.2", "status_label": "历史版本", "eol": "2015-10-08", "age_days": 5767, "support_days": -4010, "entries": [{"id": "9.0.2-8d507d44af5ad2de", "cves": [], "html": "强制 Linux 上的默认 wal_sync_method 为 fdatasync（Tom Lane、Marti Raudsepp）
Linux 上的默认值实际上多年来一直是 fdatasync，但最近的内核变更导致 PostgreSQL 改选 open_datasync。这一选择没有带来任何性能改进，反而在某些文件系统（特别是使用 data=journal 挂载选项的 ext4）上导致彻底失败。
修复热备重放期间的 “too many KnownAssignedXids” 错误（Heikki Linnakangas）
", "text": "修复热备重放期间的 “too many KnownAssignedXids” 错误（Heikki Linnakangas）", "title": "修复热备重放期间的 “too many KnownAssignedXids” 错误", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "341611f99a3b78a339dd8c64bf7a9c8f3222342dc421f741a3d98f8c095b2eda", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix too many KnownAssignedXids error during Hot Standby replay (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/002", "db_id": "f1697701e87c0b4c41c0abc14a1bda44", "patch_ids": [], "statement_hash": "bc0dc120091e35d011498e5af3419ec29fda2d51f375e704a8f773c0d97e39c5", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-3979ca633a4a1844", "cves": [], "html": "修复热备期间锁获取中的竞态条件（Simon Riggs）
", "text": "修复热备期间锁获取中的竞态条件（Simon Riggs）", "title": "修复热备期间锁获取中的竞态条件", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "07dcea70770d22d29cf47c90965a7342490f600b41072a5203e923e66537f914", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix race condition in lock acquisition during Hot Standby (Simon Riggs)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/003", "db_id": "5fdb06cb9620d7f0e13e888df230f619", "patch_ids": [], "statement_hash": "6ec2c9f8db734a5e0d1aae4a42a77e421ab757f85d1ec6deec513b166505148d", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-8ae46a5ddae45b74", "cves": [], "html": "避免热备期间不必要的冲突（Simon Riggs）
\n这修复了一些重放被认为与备库查询冲突（导致重放延迟或可能取消查询）但实际上并不存在真正冲突的情况。
", "text": "避免热备期间不必要的冲突（Simon Riggs） 这修复了一些重放被认为与备库查询冲突（导致重放延迟或可能取消查询）但实际上并不存在真正冲突的情况。", "title": "避免热备期间不必要的冲突", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "ebf3aa392a32b83b337a979681bb0528bccc6246593ff3ca66cccad6c4a8fe49", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid unnecessary conflicts during Hot Standby (Simon Riggs) This fixes some cases where replay was considered to conflict with standby queries (causing delay of replay or possibly cancellation of the queries), but there was no real conflict.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/004", "db_id": "d9811dd344bfcca6c0fb7cf3e4680308", "patch_ids": [], "statement_hash": "cd2ce58b30dbbbbb00f7df5e13d43a323acb8616a859bd458cc2821ba17f4b8e", "relations": [], "version": "9.0.2", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-e5fa1d98be7f75dd", "cves": [], "html": "修复 GIN 索引 WAL 重放逻辑中的若干缺陷（Tom Lane）
\n这可能导致复制期间的 “bad buffer id: 0” 失败或索引内容损坏。
", "text": "修复 GIN 索引 WAL 重放逻辑中的若干缺陷（Tom Lane） 这可能导致复制期间的 “bad buffer id: 0” 失败或索引内容损坏。", "title": "修复 GIN 索引 WAL 重放逻辑中的若干缺陷", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "2b9e57fbedcab283c28b6526bfd65355616a6f7c87365caebc8634c937df7306", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix assorted bugs in WAL replay logic for GIN indexes (Tom Lane) This could result in bad buffer id: 0 failures or corruption of index contents during replication.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/005", "db_id": "edd6115c947e48657925129caeab1881", "patch_ids": [], "statement_hash": "b786728336e1aa8b4322f52df47a737eee9d644353a60b8ae31db8902b43b267", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-5dfc21756f679dce", "cves": [], "html": "修复当起始检查点 WAL 记录与其重做点不在同一 WAL 段时从基础备份恢复的问题（Jeff Davis）
", "text": "修复当起始检查点 WAL 记录与其重做点不在同一 WAL 段时从基础备份恢复的问题（Jeff Davis）", "title": "修复当起始检查点 WAL 记录与其重做点不在同一 WAL 段时从基础备份恢复的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "17030fa918d971b036e7fb9150ec046c6541f9bfa7a0755772c0f0521f825b78", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix recovery from base backup when the starting checkpoint WAL record is not in the same WAL segment as its redo point (Jeff Davis)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/006", "db_id": "82cb95a0139d2515253f2b4ea69ea50f", "patch_ids": [], "statement_hash": "bb3643dfb08e25e4f7da74a044e0489c7d14555385f4b17a6668756a56dfef0f", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-ee020f928b55b63d", "cves": [], "html": "修复在创建主数据库集簇后立即启用流复制时的极端情况缺陷（Heikki Linnakangas）
", "text": "修复在创建主数据库集簇后立即启用流复制时的极端情况缺陷（Heikki Linnakangas）", "title": "修复在创建主数据库集簇后立即启用流复制时的极端情况缺陷", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "837d44284d2a117039dcf1576943aafc7eab7039f8abb02da9737b4804c29124", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix corner-case bug when streaming replication is enabled immediately after creating the master database cluster (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/007", "db_id": "e5f512540ad951d21a24dba301686857", "patch_ids": [], "statement_hash": "6e7778f8df3a3d722fad102811f27c784abd32c26f311e3235f066c0be644c2c", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-d72ee9420915ad35", "cves": [], "html": "修复多个工作进程长期保持活动时自动清理工作进程的持续变慢（Tom Lane）
\n如果自动清理工作进程处理了足够多的表，其有效 vacuum_cost_limit 可能降到接近零，导致其运行极慢。
修复自动清理启动器中的长期内存泄漏（Alvaro Herrera）
", "text": "修复自动清理启动器中的长期内存泄漏（Alvaro Herrera）", "title": "修复自动清理启动器中的长期内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "3c72b69c2d7b6a6318cdda2246062fa514892cff1b54e12d7f1969d3c432d3c7", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix long-term memory leak in autovacuum launcher (Alvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/009", "db_id": "c9831dcd37fe25019d286bb76f90643c", "patch_ids": [], "statement_hash": "b994018836cc84e5d5f67e58ad2f82318e123bc05275171db55ddf1271d517d7", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-86de0401e758d15d", "cves": [], "html": "避免在事务之外尝试报告即将发生的事务回卷情况时失败（Tom Lane）
\n这一疏忽阻碍了事务回卷过于接近后的恢复，因为数据库启动处理会失败。
", "text": "避免在事务之外尝试报告即将发生的事务回卷情况时失败（Tom Lane） 这一疏忽阻碍了事务回卷过于接近后的恢复，因为数据库启动处理会失败。", "title": "避免在事务之外尝试报告即将发生的事务回卷情况时失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "a636c5d0b59cd2de1f201796f40c0fb25b985cbfc9c00bccf2db99aef3f1666f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid failure when trying to report an impending transaction wraparound condition from outside a transaction (Tom Lane) This oversight prevented recovery after transaction wraparound got too close, because database startup processing would fail.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/010", "db_id": "dfebd202963a9ce011fae5e5f1d6833f", "patch_ids": [], "statement_hash": "d7ae3b75ead5df98916a650937287bf390c47f0ba3bc75adab94dbebc0427184", "relations": [], "version": "9.0.2", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-6ecfc4b1e05231e6", "cves": [], "html": "新增在 IA64 上检测寄存器栈溢出的支持（Tom Lane）
IA64 架构有两个硬件栈。要完全防止栈溢出失败需要同时检查两者。
在 copyObject() 中添加栈溢出检查（Tom Lane）
给定足够复杂的查询，某些代码路径可能因栈溢出而崩溃。
", "text": "在 copyObject() 中添加栈溢出检查（Tom Lane） 给定足够复杂的查询，某些代码路径可能因栈溢出而崩溃。", "title": "在 copyObject() 中添加栈溢出检查", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "57c52797bf15087c584f5a1856593654c5b96239605c639d7d610a5487d58669", "section_path": ["变更"], "commit_groups": [], "identity_text": "Add a check for stack overflow in copyObject() (Tom Lane) Certain code paths could crash due to stack overflow given a sufficiently complex query.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/012", "db_id": "fab3556994f348a8bde09dbac5023e3d", "patch_ids": [], "statement_hash": "62598be390dbf15864e5ac4d9c300f0563b57ff0fa0b291f11b320c61ed1e111", "relations": [], "version": "9.0.2", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-b1e07dd3cbb9d09b", "cves": [], "html": "修复临时 GiST 索引中页面分裂的检测（Heikki Linnakangas）
\n在临时索引中可能出现“并发”页面分裂，例如当插入时有打开的游标正在扫描该索引。GiST 未能检测到这种情况，因此当游标继续执行时可能给出错误结果。
", "text": "修复临时 GiST 索引中页面分裂的检测（Heikki Linnakangas） 在临时索引中可能出现“并发”页面分裂，例如当插入时有打开的游标正在扫描该索引。GiST 未能检测到这种情况，因此当游标继续执行时可能给出错误结果。", "title": "修复临时 GiST 索引中页面分裂的检测", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "677f5871fb0178d12de5359da4017f18efd05d6743a03e1504d493c2402a7979", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix detection of page splits in temporary GiST indexes (Heikki Linnakangas) It is possible to have a concurrent page split in a temporary index, if for example there is an open cursor scanning the index when an insertion is done. GiST failed to detect this case and hence could deliver wrong results when execution of the cursor continued.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/013", "db_id": "5631626feed6c5f4f206cb0327b6250e", "patch_ids": [], "statement_hash": "f353fa08e38e5defbbf7064341a3b648ffa03547cde3cc12d936282127212f3b", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-d2d674855db376f4", "cves": [], "html": "修复早期连接处理期间的错误检查（Tom Lane）
\n某些情况下对子进程过多的检查被跳过，可能在尝试把新子进程添加到固定大小数组时导致 postmaster 崩溃。
", "text": "修复早期连接处理期间的错误检查（Tom Lane） 某些情况下对子进程过多的检查被跳过，可能在尝试把新子进程添加到固定大小数组时导致 postmaster 崩溃。", "title": "修复早期连接处理期间的错误检查", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "76fa2df108b17410b274655f8dc4a4a700dca4a0f7f1016cf5f46a2c62bc660f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix error checking during early connection processing (Tom Lane) The check for too many child processes was skipped in some cases, possibly leading to postmaster crash when attempting to add the new child process to fixed-size arrays.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/014", "db_id": "2c8d8613775f30a53c411ca19fb94386", "patch_ids": [], "statement_hash": "3ee7f433e68384fd176acbc3d6b6ed34a68dae759bc9479656ca998f7d2099b0", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-74464b009f93e99c", "cves": [], "html": "改进窗口函数的效率（Tom Lane）
\n某些需要提前读取大量元组、但 work_mem 足够大可以全部保存在内存中的情况意外地慢。percent_rank()、cume_dist() 和 ntile() 尤其受此问题影响。
避免在 ANALYZE 复杂索引表达式时内存泄漏（Tom Lane）
确保使用整行 Var 的索引仍依赖于其表（Tom Lane）
\n像 create index i on t (foo(t.*)) 这样声明的索引在删除其表时不会自动被删除。
补齐 DROP OWNED BY 中缺失的移除用户所拥有的外部数据包装器/服务器权限的支持（Heikki Linnakangas）
不要“内联”带多个 OUT 参数的 SQL 函数（Tom Lane）
这避免了因丢失预期结果行类型信息而可能出现的崩溃。
", "text": "不要“内联”带多个 OUT 参数的 SQL 函数（Tom Lane） 这避免了因丢失预期结果行类型信息而可能出现的崩溃。", "title": "不要“内联”带多个 OUT 参数的 SQL 函数", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "7a1df660a071de5c07e46ffd4501de08f7cc69d75d309c073e2512ec9b50e2f2", "section_path": ["变更"], "commit_groups": [], "identity_text": "Do not inline a SQL function with multiple OUT parameters (Tom Lane) This avoids a possible crash due to loss of information about the expected result rowtype.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/019", "db_id": "29d1c0c80db664df87358d57c0c753e1", "patch_ids": [], "statement_hash": "8107f7046b4add0aa1d745b767c84eec84043050816d8c26e19abcee818edf4d", "relations": [], "version": "9.0.2", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-4cd3c45d53ee6587", "cves": [], "html": "修复内联参数列表包含对可内联用户函数引用的集合返回函数时的崩溃（Tom Lane）
", "text": "修复内联参数列表包含对可内联用户函数引用的集合返回函数时的崩溃（Tom Lane）", "title": "修复内联参数列表包含对可内联用户函数引用的集合返回函数时的崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "14148e0cbba2f2866eeee2f07c88e11c182b3d81a583223417417ddcf82234a9", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix crash when inline-ing a set-returning function whose argument list contains a reference to an inline-able user function (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/020", "db_id": "cdf261c7539717bd796221b71b021577", "patch_ids": [], "statement_hash": "6b75dc2712841c495a1fa669a52f11d749103a14ce6355a6ebb5e0e8e870e3bd", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-18512023d83fe0d8", "cves": [], "html": "修复当 ORDER BY、LIMIT、FOR UPDATE 或 WITH 附加到 INSERT ... VALUES 的 VALUES 部分时的正确行为（Tom Lane）
把 OFF 关键字改为非保留（Heikki Linnakangas）
这避免了在 PL/pgSQL 中使用 off 作为变量名的问题。这在 9.0 之前可行，但现在被破坏了，因为 PL/pgSQL 现在把所有核心保留字视为保留。
修复 COALESCE() 表达式的常量折叠（Tom Lane）
规划器有时会尝试求值实际上永远不可达的子表达式，可能导致意外错误。
", "text": "修复 COALESCE() 表达式的常量折叠（Tom Lane） 规划器有时会尝试求值实际上永远不可达的子表达式，可能导致意外错误。", "title": "修复 COALESCE() 表达式的常量折叠", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "b7b3f9ab327088c648c447b7eaf7c53cdba0d54842c3934ff9fae2fb467d1f0d", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix constant-folding of COALESCE() expressions (Tom Lane) The planner would sometimes attempt to evaluate sub-expressions that in fact could never be reached, possibly leading to unexpected errors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/023", "db_id": "19a5f59c0b2d17df84f464af7c510ce0", "patch_ids": [], "statement_hash": "f7172c949ec2b612d429e994c53c6e5028c0749aab510cda9f94054d98d8a93b", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-13a15ca79836824f", "cves": [], "html": "修复比较整行 Var 时的 “could not find pathkey item to sort” 规划器失败（Tom Lane）
", "text": "修复比较整行 Var 时的 “could not find pathkey item to sort” 规划器失败（Tom Lane）", "title": "修复比较整行 Var 时的 “could not find pathkey item to sort” 规划器失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "762cf72a79cf8d0aad9877234301b7d3471cc9dcf33c06ff3e1f921acd29173f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix could not find pathkey item to sort planner failure with comparison of whole-row Vars (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/024", "db_id": "9d3ca780657b9c9fff78d87ea8cd24e0", "patch_ids": [], "statement_hash": "144266208c1e167a4127aa37fd6ae5f9c659780dd0140810513c0690bd6a8cb9", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-02995bc42a6a1d0b", "cves": [], "html": "修复当连接接受（accept() 或紧随其后的调用之一）失败且 postmaster 编译时带 GSSAPI 支持时的 postmaster 崩溃（Alexander Chernikov）
在收到来自 RADIUS 认证服务器的无效响应包之后重试（Magnus Hagander）
\n这修复了一个低风险的潜在拒绝服务条件。
", "text": "在收到来自 RADIUS 认证服务器的无效响应包之后重试（Magnus Hagander） 这修复了一个低风险的潜在拒绝服务条件。", "title": "在收到来自 RADIUS 认证服务器的无效响应包之后重试", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "8f7208c13216568797a725c3ff1f94249763bcf61aea03061fc2029a7e6d2c48", "section_path": ["变更"], "commit_groups": [], "identity_text": "Retry after receiving an invalid response packet from a RADIUS authentication server (Magnus Hagander) This fixes a low-risk potential denial of service condition.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/026", "db_id": "167906d50539c48e1496028d4054d9bc", "patch_ids": [], "statement_hash": "697947151a236aab0e3b710355edee679075a9116d9cbec9cb1e023626c51f67", "relations": [], "version": "9.0.2", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-1bd8ff2c7c075177", "cves": [], "html": "修复 log_temp_files 处于活动状态时临时文件漏删的问题（Tom Lane）
如果尝试发出日志消息时出错，就不会执行删除，导致临时文件累积。
", "text": "修复 log_temp_files 处于活动状态时临时文件漏删的问题（Tom Lane） 如果尝试发出日志消息时出错，就不会执行删除，导致临时文件累积。", "title": "修复 log_temp_files 处于活动状态时临时文件漏删的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "5f0e9ed711085444061d9adc92e32cfd846d2e74c2d3f90130ec550fd2895c99", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix missed unlink of temporary files when log_temp_files is active (Tom Lane) If an error occurred while attempting to emit the log message, the unlink was not done, resulting in accumulation of temp files.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/027", "db_id": "c1a79ae092b042c6006f2ed4f31f74f2", "patch_ids": [], "statement_hash": "a0ba8683c1146ac50a1cb28715dd053b91a62f2d248b07b50d2f6bca52e0059f", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-9c9eabdfb3058fd6", "cves": [], "html": "为 InhRelation 节点添加打印功能（Tom Lane）
这避免了启用 debug_print_parse 且执行某些类型的查询时的失败。
修复点到水平线段距离的错误计算（Tom Lane）
\n该缺陷影响多个不同的几何距离测量操作符。
", "text": "修复点到水平线段距离的错误计算（Tom Lane） 该缺陷影响多个不同的几何距离测量操作符。", "title": "修复点到水平线段距离的错误计算", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "2a6b6adbbc610c976788e63e7d7f83d207d1ab722e54c5472eb38f4cd577b726", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix incorrect calculation of distance from a point to a horizontal line segment (Tom Lane) This bug affected several different geometric distance-measurement operators.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/029", "db_id": "3ac449d8aa6f520e348000321722cb3a", "patch_ids": [], "statement_hash": "6f6ceebfa5cd978ecb6b1bf7a0e8f3ca69b425c2ff7708ad0f92fe17c531fbc8", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-674f3a68cfa28c5d", "cves": [], "html": "修复 ecpg 中事务状态的错误计算（Itagaki Takahiro）
", "text": "修复 ecpg 中事务状态的错误计算（Itagaki Takahiro）", "title": "修复 ecpg 中事务状态的错误计算", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "0942d2349bc93eb33b2210493aa4f68f22b6f42f54e7dd06fe9bfea0587a2354", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix incorrect calculation of transaction status in ecpg (Itagaki Takahiro)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/030", "db_id": "c748c5fce4507f46d3f760c4d50403de", "patch_ids": [], "statement_hash": "996b9c335473a394cc0a0f3034a6fdf20ed871f1734fc7d53edb4e5dd6db5d1f", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-9c046108556a592c", "cves": [], "html": "修复 psql Unicode 转义支持的错误（Tom Lane）
", "text": "修复 psql Unicode 转义支持的错误（Tom Lane）", "title": "修复 psql Unicode 转义支持的错误", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "5dbc701efac7abc7febd3293e377ee8bd574ce0a0630d89b608936dce61d01a5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix errors in psql's Unicode-escape support (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/031", "db_id": "22833c7d82a87371676c3f18f300cce4", "patch_ids": [], "statement_hash": "84e2ceb7a31f7dd39c00e5e095234a16c627d64001ba60797a271d2659bb5e31", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-624f0a44eedef4ef", "cves": [], "html": "加快归档包含许多大对象（blob）时并行 pg_restore 的速度（Tom Lane）
", "text": "加快归档包含许多大对象（blob）时并行 pg_restore 的速度（Tom Lane）", "title": "加快归档包含许多大对象（blob）时并行 pg_restore 的速度", "commits": [], "section": "变更", "category": "performance", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "0fe589f8a8d00efc87bb368c4b5eb07f1bd4d3a7dd4c1004f95c8ed6cc1d67e6", "section_path": ["变更"], "commit_groups": [], "identity_text": "Speed up parallel pg_restore when the archive contains many large objects (blobs) (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/032", "db_id": "024db4086d99949dd4642c42f90786ce", "patch_ids": [], "statement_hash": "044e09c0111839f283d0382cd79c6ee7876738a90414d543197bdbe4053bfe4f", "relations": [], "version": "9.0.2", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-246617500a79099a", "cves": [], "html": "修复 PL/pgSQL 对“简单”表达式的处理，使其在递归或错误恢复情况下不失败（Tom Lane）
", "text": "修复 PL/pgSQL 对“简单”表达式的处理，使其在递归或错误恢复情况下不失败（Tom Lane）", "title": "修复 PL/pgSQL 对“简单”表达式的处理，使其在递归或错误恢复情况下不失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "de400eca835cb0b7640b31c4f6ef9267b63c47a82e1260dedf783846f672f327", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix PL/pgSQL's handling of simple expressions to not fail in recursion or error-recovery cases (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/033", "db_id": "b70645bb5df4e09eb300b43e99a0cf20", "patch_ids": [], "statement_hash": "b0948e3dd097842d2d563c65ad803bb994ee7265c8d86a31ea0a4d83a9858725", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-127b666450c3440b", "cves": [], "html": "修复 PL/pgSQL 对不存在列情况的错误报告（Tom Lane）
\n从 9.0 起，它有时会报 “missing FROM-clause entry for table foo”，而更合适的消息应是 “record foo has no field bar”。
", "text": "修复 PL/pgSQL 对不存在列情况的错误报告（Tom Lane） 从 9.0 起，它有时会报 “missing FROM-clause entry for table foo”，而更合适的消息应是 “record foo has no field bar”。", "title": "修复 PL/pgSQL 对不存在列情况的错误报告", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "b8f80c027db2a188a663a22b0d66eed3465b2727081b529db1f8054b52b44a3f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix PL/pgSQL's error reporting for no-such-column cases (Tom Lane) As of 9.0, it would sometimes report missing FROM-clause entry for table foo when record foo has no field bar would be more appropriate.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/034", "db_id": "79dfe91911f7cc04b3d1df7817f0b82f", "patch_ids": [], "statement_hash": "4f0a70b6cba8dd0717cffcf96c9756edbb0883b6600e2d1d8e9481c6d5aa31e8", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-4e10906f1bce6dce", "cves": [], "html": "修复 PL/Python，使其在给元组字段赋值时遵循 typmod（即长度或精度限制）（Tom Lane）
\n这修复了一个自 8.4 以来的退化。
", "text": "修复 PL/Python，使其在给元组字段赋值时遵循 typmod（即长度或精度限制）（Tom Lane） 这修复了一个自 8.4 以来的退化。", "title": "修复 PL/Python，使其在给元组字段赋值时遵循 typmod（即长度或精度限制）", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "6acd54442e82b4396126ac38c2ddb0b0ba68bb2a91fc415355c21d98a1e8aec4", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix PL/Python to honor typmod (i.e., length or precision restrictions) when assigning to tuple fields (Tom Lane) This fixes a regression from 8.4.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/035", "db_id": "940c7285b0b58b6eafc3890580fd9cde", "patch_ids": [], "statement_hash": "44df1780f3e5434d8890162babeb2682dbe10b3f126f9b63078d415e28876832", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-9bc074afa1f4698d", "cves": [], "html": "修复 PL/Python 对集合返回函数的处理（Jan Urbanski）
\n在生成集合结果的迭代器内尝试调用 SPI 函数会失败。
", "text": "修复 PL/Python 对集合返回函数的处理（Jan Urbanski） 在生成集合结果的迭代器内尝试调用 SPI 函数会失败。", "title": "修复 PL/Python 对集合返回函数的处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "8a0d765b2892c1185f7b0b46548b5dcac13f5d42353a251a0a6537f0a8a4c7d3", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix PL/Python's handling of set-returning functions (Jan Urbanski) Attempts to call SPI functions within the iterator generating a set result would fail.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/036", "db_id": "4f4534bf92e555ac9ee7c1cdb1261efe", "patch_ids": [], "statement_hash": "67af5f54a4a8faf966937886f1538b427d222d0e8cd459b13b641e84eb3cc563", "relations": [], "version": "9.0.2", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.2-e432fd45b5091786", "cves": [], "html": "修复 contrib/cube 的 GiST picksplit 算法中的缺陷（Alexander Korotkov）
这可能导致 cube 列上的 GiST 索引相当低效，尽管答案并非真正错误。如果你有这样的索引，考虑在安装此更新后对其执行 REINDEX。
contrib/dblink 除了在创建新连接时外不再发出“identifier will be truncated”通知（Itagaki Takahiro）
修复 contrib/pgcrypto 在缺少公钥时可能的核心转储（Marti Raudsepp）
修复 contrib/pg_upgrade 中的缓冲区越界（Hernan Gonzalez）
修复 contrib/xml2 的 XPath 查询函数中的内存泄漏（Tom Lane）
把时区数据文件更新为 tzdata 版本 2010o for DST law changes in Fiji and Samoa; also historical corrections for Hong Kong。
", "text": "把时区数据文件更新为 tzdata 版本 2010o for DST law changes in Fiji and Samoa; also historical corrections for Hong Kong。", "title": "把时区数据文件更新为 tzdata 版本 2010o for DST law changes in Fiji and Samoa; also historical corrections for Hong Kong。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.2/#id-1.11.6.26.5", "source_hash": "b1e03f97ec8ed473d05ad665d6af9a8947f991b96af5ae51c46c0bf04981f81f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2010o for DST law changes in Fiji and Samoa; also historical corrections for Hong Kong.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.2/changes/042", "db_id": "41aa83ca226f8eefde4a127758ce058a", "patch_ids": [], "statement_hash": "dfb844426c100dee6f520e1152dced660047a990a18732167a24e731cc8bfa9c", "relations": [], "version": "9.0.2", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}]}], "stats": [{"key": "all", "label": "全部变更", "count": 42}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 26}, {"key": "security", "label": "安全相关", "count": 0}, {"key": "performance", "label": "性能改进", "count": 1}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 15}], "total": 42, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 42, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}