对于运行 9.0.X 的用户，不需要进行转储/恢复。
\n不过，如果你是从早于 9.0.4 的版本升级，请参见第 E.20 节。
", "compatibility_count": 0, "label": "9.0.5", "status_label": "历史版本", "eol": "2015-10-08", "age_days": 5483, "support_days": -4010}, "groups": [{"date": "2011-09-26", "build": "9.0.5", "major": "9.0", "minor": 5, "manual": "9.0", "status": "stable", "doc_git": "", "version": "9.0.5", "eol_date": "2015-10-08", "date_text": "2011-09-26", "supported": false, "manual_url": "/docs/9.0/release-9-0-5.html", "source_url": "/docs/release/9.0.5/", "entry_count": 64, "placeholder": false, "content_hash": "4ca6c20d4ad0ad956fb670627785928c87054b869d76ec2d5d3ac1e7c4b2fbc3", "manual_build": "9.0.23", "source_as_of": "", "changes_count": 64, "doc_loaded_at": "2026-09-26T02:56:48.570247", "migration_html": "对于运行 9.0.X 的用户，不需要进行转储/恢复。
\n不过，如果你是从早于 9.0.4 的版本升级，请参见第 E.20 节。
", "compatibility_count": 0, "label": "9.0.5", "status_label": "历史版本", "eol": "2015-10-08", "age_days": 5483, "support_days": -4010, "entries": [{"id": "9.0.5-6e5aa8d1e3b37b32", "cves": [], "html": "修复对系统目录执行 VACUUM FULL 或 CLUSTER 之后的目录缓存失效（Tom Lane）
某些情况下，系统目录行被重定位到别处不会被并发服务器进程识别，如果它们随后尝试更新该行，就可能发生目录损坏。最坏的结果可能是一张表完全丢失。
", "text": "修复对系统目录执行 VACUUM FULL 或 CLUSTER 之后的目录缓存失效（Tom Lane） 某些情况下，系统目录行被重定位到别处不会被并发服务器进程识别，如果它们随后尝试更新该行，就可能发生目录损坏。最坏的结果可能是一张表完全丢失。", "title": "修复对系统目录执行 VACUUM FULL 或 CLUSTER 之后的目录缓存失效", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "c20d4c45cfff3c07585a526b32023088f505a102feb830d631270e2edf9a77f5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix catalog cache invalidation after a VACUUM FULL or CLUSTER on a system catalog (Tom Lane) In some cases the relocation of a system catalog row to another place would not be recognized by concurrent server processes, allowing catalog corruption to occur if they then tried to update that row. The worst-case outcome could be as bad as complete loss of a table.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/001", "db_id": "856e9d5d223d74d568f0e17f5afbbfc2", "patch_ids": [], "statement_hash": "63863d095ef33e79cedb032eb30c9fd047099049cc60f677b5ea37d6dcdbc862", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-16f4b3739ae4d4a4", "cves": [], "html": "修复 sinval 重置处理期间错误的操作顺序，并确保 TOAST OID 在系统目录中被保留（Tom Lane）
\n这些失误可能导致对系统目录执行 VACUUM FULL 或 CLUSTER 之后出现瞬时失败。
修复对不确定的 HOT 更新元组建立索引的缺陷（Tom Lane）
\n这些缺陷可能导致重建系统目录索引之后索引损坏。据信它们不影响用户索引。
", "text": "修复对不确定的 HOT 更新元组建立索引的缺陷（Tom Lane） 这些缺陷可能导致重建系统目录索引之后索引损坏。据信它们不影响用户索引。", "title": "修复对不确定的 HOT 更新元组建立索引的缺陷", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "5d6ca5c3d96472de04f7cbbf2e1ba620e95401a447468540fd0f09081dd34b0f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix bugs in indexing of in-doubt HOT-updated tuples (Tom Lane) These bugs could result in index corruption after reindexing a system catalog. They are not believed to affect user indexes.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/003", "db_id": "694bb6b55270e077158b51ac03a7c398", "patch_ids": [], "statement_hash": "7e3f920bad95df37786f12de0335c438fc09b2ba045ec55436c2d0aef18cf501", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-7689b77b5dafd2be", "cves": [], "html": "修复 GiST 索引页面分裂处理中的多个缺陷（Heikki Linnakangas）
\n发生概率很低，但它们可能导致索引损坏。
", "text": "修复 GiST 索引页面分裂处理中的多个缺陷（Heikki Linnakangas） 发生概率很低，但它们可能导致索引损坏。", "title": "修复 GiST 索引页面分裂处理中的多个缺陷", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "26ed948fc24a56125611747ae40ab4dd55d9d4e6a016d3fc9ec89200b4ed7483", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix multiple bugs in GiST index page split processing (Heikki Linnakangas) The probability of occurrence was low, but these could lead to index corruption.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/004", "db_id": "65356b0cef0cbd777ceeb26e78dfdc18", "patch_ids": [], "statement_hash": "85c5527676fcc8624e3aec3fa758cf8407520bac6bc88d650ebfce4a1dd000b5", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-1883aeb6b79d57cf", "cves": [], "html": "修复 tsvector_concat() 中可能的缓冲区越界（Tom Lane）
该函数可能低估其结果所需的内存量，导致服务器崩溃。
", "text": "修复 tsvector_concat() 中可能的缓冲区越界（Tom Lane） 该函数可能低估其结果所需的内存量，导致服务器崩溃。", "title": "修复 tsvector_concat() 中可能的缓冲区越界", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "9781609519add05cb38c06b912c4d52fc129b3438a75273b9501b923ab4588e8", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible buffer overrun in tsvector_concat() (Tom Lane) The function could underestimate the amount of memory needed for its result, leading to server crashes.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/005", "db_id": "f7c63b89903fb3a8c2a478abff3496f6", "patch_ids": [], "statement_hash": "6fe54e948134cccddc2f0168daa3aaa99e0a7412033d1e2c070e5fa0a0c1f7b4", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-5b4de0da7aa17ffe", "cves": [], "html": "修复 xml_recv 处理“standalone”参数时的崩溃（Tom Lane）
让 pg_options_to_table 对没有值的选项返回 NULL（Tom Lane）
此前这类情况会导致服务器崩溃。
", "text": "让 pg_options_to_table 对没有值的选项返回 NULL（Tom Lane） 此前这类情况会导致服务器崩溃。", "title": "让 pg_options_to_table 对没有值的选项返回 NULL", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "ef2c4fc70b5bfc80d699a96673e3d789c23325a49e97565fcfedf20919eca37b", "section_path": ["变更"], "commit_groups": [], "identity_text": "Make pg_options_to_table return NULL for an option with no value (Tom Lane) Previously such cases would result in a server crash.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/007", "db_id": "3275f538db4250626cf3e2aa565b86e3", "patch_ids": [], "statement_hash": "c5a91c96a58e17d12b264f8f1d6c5d86d29e514b4299ea3b821b642e03ac9f0b", "relations": [{"rule": 2, "type": "equivalent", "target": "5b6cb6d2b65558c733595876dca7678e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5a91c96a58e17d12b264f8f1d6c5d86d29e514b4299ea3b821b642e03ac9f0b"}}], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "5b6cb6d2b65558c733595876dca7678e", "kind": "equivalent", "version": "9.1.1", "label": "9.1.1", "title": "让 pg_options_to_table 对没有值的选项返回 NULL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5a91c96a58e17d12b264f8f1d6c5d86d29e514b4299ea3b821b642e03ac9f0b"}, "url": "/docs/compare/?release=9.1.1#9.1.1-0a8f5042148adac6", "source_url": "/docs/release/9.1.1/#id-1.11.6.28.5"}]}, {"id": "9.0.5-dee81aff4f59d857", "cves": [], "html": "避免在 ANALYZE 和 SJIS-2004 编码转换中可能越过内存末尾的访问（Noah Misch）
这修复了一些概率极低的服务器崩溃场景。
", "text": "避免在 ANALYZE 和 SJIS-2004 编码转换中可能越过内存末尾的访问（Noah Misch） 这修复了一些概率极低的服务器崩溃场景。", "title": "避免在 ANALYZE 和 SJIS-2004 编码转换中可能越过内存末尾的访问", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "c3d1d102b63f6310954b6049ee7f546c4e39e1615eb7925670c13da9039b04a4", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid possibly accessing off the end of memory in ANALYZE and in SJIS-2004 encoding conversion (Noah Misch) This fixes some very-low-probability server crash scenarios.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/008", "db_id": "b15ac05af66b011a2bbfd3e21b7bff04", "patch_ids": [], "statement_hash": "4186b29ee691ee044380791f0b587ea72dae6f25e0c1ebb3c15a3ccea612782f", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-549e27ea26c2a72a", "cves": [], "html": "保护 pg_stat_reset_shared() 免受 NULL 输入（Magnus Hagander）
修复在子事务内检测到恢复冲突死锁时可能的失败（Tom Lane）
", "text": "修复在子事务内检测到恢复冲突死锁时可能的失败（Tom Lane）", "title": "修复在子事务内检测到恢复冲突死锁时可能的失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "5ed8c395829e609e26f953ee7565d2852a46e0ef0a1247555e852bad67e2c092", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible failure when a recovery conflict deadlock is detected within a sub-transaction (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/010", "db_id": "dcf64558c3fa1974ae2244457843775c", "patch_ids": [], "statement_hash": "0973d9b455346e91c4d83873a3f16a9e881e840f15a590276e1413b0d8ba17fe", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-0bfcc8b17f4790bd", "cves": [], "html": "避免热备期间回收 btree 索引页时的虚假冲突（Noah Misch、Simon Riggs）
", "text": "避免热备期间回收 btree 索引页时的虚假冲突（Noah Misch、Simon Riggs）", "title": "避免热备期间回收 btree 索引页时的虚假冲突", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "f9cf2cbc69caa94d1a9069f82b7dc522c1e0e9572755ce63d6d3de5ac7a4d6ec", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid spurious conflicts while recycling btree index pages during hot standby (Noah Misch, Simon Riggs)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/011", "db_id": "f53165e2b121acf845fc00e43a6b09b5", "patch_ids": [], "statement_hash": "b04ee02920bbdb0c84980fe57fb033d60eaebf11f2d1964b86752c70c65d0228", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-3f81d1a963c876b1", "cves": [], "html": "如果恢复结束时 WAL 接收端仍在运行则将其关闭（Heikki Linnakangas）
\npostmaster 此前在这种情况下会 panic，但这实际上是合法的情况。
", "text": "如果恢复结束时 WAL 接收端仍在运行则将其关闭（Heikki Linnakangas） postmaster 此前在这种情况下会 panic，但这实际上是合法的情况。", "title": "如果恢复结束时 WAL 接收端仍在运行则将其关闭", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "307065e1847fa3e9c61b9adeb9423f1874a8df604e2d17ebe14f4ba3bd418fbb", "section_path": ["变更"], "commit_groups": [], "identity_text": "Shut down WAL receiver if it's still running at end of recovery (Heikki Linnakangas) The postmaster formerly panicked in this situation, but it's actually a legitimate case.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/012", "db_id": "ac7799aef9cb07e00ee702eb95c994f1", "patch_ids": [], "statement_hash": "95c7c6fdc183c0038ec2b7d655734aa9e8669b9026940631ee2b5beba7ca4147", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-53d306ce436e59f1", "cves": [], "html": "修复 relcache init 文件失效中的竞态条件（Tom Lane）
\n存在一个时间窗口，新的后端进程可能读到过期的 init 文件，却错过本应告知它数据已过期的失效消息。结果是目录访问中的离奇失败，通常在启动稍后阶段报 “could not read block 0 in file ...”。
", "text": "修复 relcache init 文件失效中的竞态条件（Tom Lane） 存在一个时间窗口，新的后端进程可能读到过期的 init 文件，却错过本应告知它数据已过期的失效消息。结果是目录访问中的离奇失败，通常在启动稍后阶段报 “could not read block 0 in file ...”。", "title": "修复 relcache init 文件失效中的竞态条件", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "8848e6ed14a8bf17ef585d48f0788fc5916b2f69403abef8090da7b8ce2c0fc5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix race condition in relcache init file invalidation (Tom Lane) There was a window wherein a new backend process could read a stale init file but miss the inval messages that would tell it the data is stale. The result would be bizarre failures in catalog accesses, typically could not read block 0 in file ... later during startup.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/013", "db_id": "6551ce20b6d12f5ac4a62be33f11a9a5", "patch_ids": [], "statement_hash": "9568f308fc0b02167a5a672baeecbf160a6f018e18bad2a4e2836c468ff21fe7", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-361cf834b74f649c", "cves": [], "html": "修复 GiST 索引扫描结束时的内存泄漏（Tom Lane）
\n执行许多独立 GiST 索引扫描的命令（例如对已包含许多行的表验证新的基于 GiST 的排他约束）会因此泄漏瞬时需要大量内存。
", "text": "修复 GiST 索引扫描结束时的内存泄漏（Tom Lane） 执行许多独立 GiST 索引扫描的命令（例如对已包含许多行的表验证新的基于 GiST 的排他约束）会因此泄漏瞬时需要大量内存。", "title": "修复 GiST 索引扫描结束时的内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "fdb92f56027c9ddb6a06f1a7c1a8d3eabbd8f28e1f0a26aa2ddb28460dbbe33f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix memory leak at end of a GiST index scan (Tom Lane) Commands that perform many separate GiST index scans, such as verification of a new GiST-based exclusion constraint on a table already containing many rows, could transiently require large amounts of memory due to this leak.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/014", "db_id": "5663370bfa82647a3e2d0d54fa53390d", "patch_ids": [], "statement_hash": "8874e4cbab18a89732c29a6ac6e39590040bb8903e77ecc7207f67ff9d1b8d9c", "relations": [{"rule": 2, "type": "equivalent", "target": "fa34ca25147b2f0661795577525fb45e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8874e4cbab18a89732c29a6ac6e39590040bb8903e77ecc7207f67ff9d1b8d9c"}}], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa34ca25147b2f0661795577525fb45e", "kind": "equivalent", "version": "9.1.1", "label": "9.1.1", "title": "修复 GiST 索引扫描结束时的内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8874e4cbab18a89732c29a6ac6e39590040bb8903e77ecc7207f67ff9d1b8d9c"}, "url": "/docs/compare/?release=9.1.1#9.1.1-361cf834b74f649c", "source_url": "/docs/release/9.1.1/#id-1.11.6.28.5"}]}, {"id": "9.0.5-3c8c9cf483b691a6", "cves": [], "html": "修复当必须对传入的命令串做编码转换且 LISTEN 处于活动状态时的内存泄漏（Tom Lane）
修复支持可持有游标和 plpgsql 的 RETURN NEXT 命令的 tuplestore 中不正确的内存核算（可能导致内存膨胀）（Tom Lane）
修复同时存在 BEFORE 和 AFTER 触发器时的触发器 WHEN 条件（Tom Lane）
如果同一更新曾触发过 BEFORE ROW 触发器，AFTER ROW UPDATE 触发器的 WHEN 条件求值可能崩溃。
修复构造大型有损位图时的性能问题（Tom Lane）
", "text": "修复构造大型有损位图时的性能问题（Tom Lane）", "title": "修复构造大型有损位图时的性能问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "b85224e0f6a8b93e2351815fb20a2503c37e04e35e70fc2f5d62e63f6d9556d8", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix performance problem when constructing a large, lossy bitmap (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/018", "db_id": "55cc6f55cba55ffa93ef57961be2ac95", "patch_ids": [], "statement_hash": "e44ebdbcbb59cf95f8c20bc38cd4e83e633de9440fdefc182753b42951bc8531", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-8b0415156c792b22", "cves": [], "html": "修复唯一列的连接选择率估计（Tom Lane）
\n这修复了一个可能错误估计连接结果大小的规划器启发式规则。
", "text": "修复唯一列的连接选择率估计（Tom Lane） 这修复了一个可能错误估计连接结果大小的规划器启发式规则。", "title": "修复唯一列的连接选择率估计", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "905ec20ae679c45d08d02bc727e9826ea1433ccdb194e3f1b6480afe38379014", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix join selectivity estimation for unique columns (Tom Lane) This fixes an erroneous planner heuristic that could lead to poor estimates of the result size of a join.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/019", "db_id": "7dad43c8353783a77a650810dae8791b", "patch_ids": [], "statement_hash": "a87da81d67ddab08c882787371b18e36ad654341a685b5aee4e0c2a345945018", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-81466eafb8c57f7f", "cves": [], "html": "修复只出现在子 SELECT 目标列表中的嵌套 PlaceHolderVar 表达式（Tom Lane）
\n这一失误可能导致外连接的输出错误地显示为 NULL。
", "text": "修复只出现在子 SELECT 目标列表中的嵌套 PlaceHolderVar 表达式（Tom Lane） 这一失误可能导致外连接的输出错误地显示为 NULL。", "title": "修复只出现在子 SELECT 目标列表中的嵌套 PlaceHolderVar 表达式", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "6d4fac7e348a57bcd2e2ff08b929b0ec01aed237b9e90042764c7b39fde76b7a", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix nested PlaceHolderVar expressions that appear only in sub-select target lists (Tom Lane) This mistake could result in outputs of an outer join incorrectly appearing as NULL.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/020", "db_id": "1ec15e5aa85689c10c679e5644ecdbb3", "patch_ids": [], "statement_hash": "a1ebaf9d60cf87245f05e4ca30d1c9519a35b410ad3bfa5187a254be8277046e", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-8ce828eab01765b8", "cves": [], "html": "允许规划器假定空的父表真的是空的（Tom Lane）
\n通常为了规划目的，空表被假定具有某个最小大小；但对继承层次的父表而言，这一启发式规则似乎弊大于利，因为父表往往永久为空。
", "text": "允许规划器假定空的父表真的是空的（Tom Lane） 通常为了规划目的，空表被假定具有某个最小大小；但对继承层次的父表而言，这一启发式规则似乎弊大于利，因为父表往往永久为空。", "title": "允许规划器假定空的父表真的是空的", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "b795a1b013ccaebf53d936042a5f25065dc105d45f5137249635bae3af007ade", "section_path": ["变更"], "commit_groups": [], "identity_text": "Allow the planner to assume that empty parent tables really are empty (Tom Lane) Normally an empty table is assumed to have a certain minimum size for planning purposes; but this heuristic seems to do more harm than good for the parent table of an inheritance hierarchy, which often is permanently empty.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/021", "db_id": "c8f7aab04e542ab8eef63ad57ad69a58", "patch_ids": [], "statement_hash": "59b6c8414da6433822282d9a7285d01cd2bb6c6c848bc70bcaf78952d5f3869c", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-5a8d36db3efb478e", "cves": [], "html": "允许嵌套的 EXISTS 查询被正确优化（Tom Lane）
修复数组和路径创建函数，确保填充字节为零（Tom Lane）
\n这避免了一些规划器认为语义相等的常量不相等的情况，这种情况会导致糟糕的优化。
", "text": "修复数组和路径创建函数，确保填充字节为零（Tom Lane） 这避免了一些规划器认为语义相等的常量不相等的情况，这种情况会导致糟糕的优化。", "title": "修复数组和路径创建函数，确保填充字节为零", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "26c7a7b1c06241926ad8f93b103d50d184e3da400ade9e90fd3392994afe7ec2", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix array- and path-creating functions to ensure padding bytes are zeroes (Tom Lane) This avoids some situations where the planner will think that semantically-equal constants are not equal, resulting in poor optimization.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/023", "db_id": "9497e669ed72fd24145b3791e61de4b8", "patch_ids": [], "statement_hash": "2e65199111f2b15f6deee34a853bdf0cc3826ec7ad190f3699234311b56fd59d", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-0229aa3a07327796", "cves": [], "html": "修复 EXPLAIN，使其处理内层索引扫描子计划中的门控 Result 节点（Tom Lane）
这一疏忽的常见症状是 “bogus varno” 错误。
", "text": "修复 EXPLAIN，使其处理内层索引扫描子计划中的门控 Result 节点（Tom Lane） 这一疏忽的常见症状是 “bogus varno” 错误。", "title": "修复 EXPLAIN，使其处理内层索引扫描子计划中的门控 Result 节点", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "6d311a694997f8629e88d29471d8fc0a1eb12f400d1fee677d825f6fa0fa46fc", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix EXPLAIN to handle gating Result nodes within inner-indexscan subplans (Tom Lane) The usual symptom of this oversight was bogus varno errors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/024", "db_id": "3c1a8717a3e2be7ba66ba978a99be412", "patch_ids": [], "statement_hash": "e2e76fd9f19e74a4e3aea822bd1a9996bc1e63c2c5498f3059347a930f80877a", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-e20a487909d91a39", "cves": [], "html": "修复 btree 对 indexedcol IS NULL 条件的预处理（Dean Rasheed）
如果与同一索引列上任何其他类型的 btree 可索引条件组合，该条件是不可满足的。这种情况在 9.0.0 及更高版本中处理不正确，导致本应没有输出的查询产生输出。
", "text": "修复 btree 对 indexedcol IS NULL 条件的预处理（Dean Rasheed） 如果与同一索引列上任何其他类型的 btree 可索引条件组合，该条件是不可满足的。这种情况在 9.0.0 及更高版本中处理不正确，导致本应没有输出的查询产生输出。", "title": "修复 btree 对 indexedcol IS NULL 条件的预处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "95b1cfec18daf2c89f04a9ec59d110a6a116b02bab52b69ab507354ba2a1f8ac", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix btree preprocessing of indexedcol IS NULL conditions (Dean Rasheed) Such a condition is unsatisfiable if combined with any other type of btree-indexable condition on the same index column. The case was handled incorrectly in 9.0.0 and later, leading to query output where there should be none.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/025", "db_id": "52c1de0a09fc66d1715dd4b67ad7cd0e", "patch_ids": [], "statement_hash": "f2ebf8238a47175eaf86883f453b54351b830b826350d910f5d0e1d38514d92c", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-3b2b9f2077f1bf2d", "cves": [], "html": "规避破坏 WAL 重放的 gcc 4.6.0 缺陷（Tom Lane）
\n这可能导致服务器崩溃后已提交事务的丢失。
", "text": "规避破坏 WAL 重放的 gcc 4.6.0 缺陷（Tom Lane） 这可能导致服务器崩溃后已提交事务的丢失。", "title": "规避破坏 WAL 重放的 gcc 4.6.0 缺陷", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "c2ffe9cd686a8a73ab92ae7834f46833a99e673d0ac32e066621f69329faf181", "section_path": ["变更"], "commit_groups": [], "identity_text": "Work around gcc 4.6.0 bug that breaks WAL replay (Tom Lane) This could lead to loss of committed transactions after a server crash.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/026", "db_id": "e88cfc316fc676ded841ba7a66217586", "patch_ids": [], "statement_hash": "8bb8b96335a07e88bac007bf3bfde12d46e8a1671f066097ad5f7dbc430c5428", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-b34ce89c14574d8e", "cves": [], "html": "修复视图中 VALUES 的转储缺陷（Tom Lane）
禁止对序列执行 SELECT FOR UPDATE/SHARE（Tom Lane）
这种操作不像预期那样工作，可能导致失败。
", "text": "禁止对序列执行 SELECT FOR UPDATE/SHARE（Tom Lane） 这种操作不像预期那样工作，可能导致失败。", "title": "禁止对序列执行 SELECT FOR UPDATE/SHARE", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "70fdc4e13c14e4621f265195984a05d3d15a43f5c2e65b2c5cd437e30dac4975", "section_path": ["变更"], "commit_groups": [], "identity_text": "Disallow SELECT FOR UPDATE/SHARE on sequences (Tom Lane) This operation doesn't work as expected and can lead to failures.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/028", "db_id": "e4e9bff2da207c3597b9846ce5f98556", "patch_ids": [], "statement_hash": "e340a2209a2573f31d2d74657e9db8987726a88b80640dd6450ba3bef8872335", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-229741120fe65dcf", "cves": [], "html": "修复 VACUUM，使其总是更新 pg_class.reltuples/relpages（Tom Lane）
这修复了一些自动清理可能对何时清理表做出越来越差决策的场景。
", "text": "修复 VACUUM，使其总是更新 pg_class.reltuples/relpages（Tom Lane） 这修复了一些自动清理可能对何时清理表做出越来越差决策的场景。", "title": "修复 VACUUM，使其总是更新 pg_class.reltuples/relpages", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "4a0f450a9436ec3c5f1de00d3ad3d15309321ab56d2d83e7e77559608854fcb3", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix VACUUM so that it always updates pg_class.reltuples/relpages (Tom Lane) This fixes some scenarios where autovacuum could make increasingly poor decisions about when to vacuum tables.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/029", "db_id": "17150a9b8c992338101b85c58ad82304", "patch_ids": [], "statement_hash": "0f5790194aaaee7128f9e6ac233fba2540e29afdc136c3c5756badf884a5fc05", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-3af44e85ca3eabc8", "cves": [], "html": "防御计算哈希表大小时的整数溢出（Tom Lane）
", "text": "防御计算哈希表大小时的整数溢出（Tom Lane）", "title": "防御计算哈希表大小时的整数溢出", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "098fd8c0a20624203516b865f8fd7c310ac29b1d093f9070030a4d4f1f8fb632", "section_path": ["变更"], "commit_groups": [], "identity_text": "Defend against integer overflow when computing size of a hash table (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/030", "db_id": "2579443088e1eea68df44d485fb4a18c", "patch_ids": [], "statement_hash": "11bdc5c76fc2b17a837929748392dd3c8e1628814149c9860b744512c540df6d", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-76d1c335be3bc54c", "cves": [], "html": "修复 CLUSTER 可能尝试访问已移除的 TOAST 数据的情况（Tom Lane）
修复初始认证事务期间的过早超时失败（Tom Lane）
", "text": "修复初始认证事务期间的过早超时失败（Tom Lane）", "title": "修复初始认证事务期间的过早超时失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "730a4bcc23571e31d929c47196fe9ac3e788133bfb4b35885261d1be9624122e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix premature timeout failures during initial authentication transaction (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/032", "db_id": "15a9237fa68fae4b0d10cbfc65641d21", "patch_ids": [], "statement_hash": "732936b06c1497e801443b1408493c8dd6bd35cf4dc94249cdc36682895e6934", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-21a34a76836837b0", "cves": [], "html": "修复 “peer” 认证使用凭据控制消息时的可移植性缺陷（Tom Lane）
", "text": "修复 “peer” 认证使用凭据控制消息时的可移植性缺陷（Tom Lane）", "title": "修复 “peer” 认证使用凭据控制消息时的可移植性缺陷", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "707e792a951a2481edd7e5198168c90e0248908585623a95eaa798f6d1ff482c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix portability bugs in use of credentials control messages for peer authentication (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/033", "db_id": "6f6808ceee482a9ed9d8b55a2085d442", "patch_ids": [], "statement_hash": "cb6fbd738a87b296793cc48ca50f75cc9bd6f8097aa344261656ac5898e950e5", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-a1b4379a7835d9d9", "cves": [], "html": "修复需要多次往返时的 SSPI 登录（Ahmed Shinwari、Magnus Hagander）
\n该问题的典型症状是 SSPI 登录期间的 “The function requested is not supported” 错误。
", "text": "修复需要多次往返时的 SSPI 登录（Ahmed Shinwari、Magnus Hagander） 该问题的典型症状是 SSPI 登录期间的 “The function requested is not supported” 错误。", "title": "修复需要多次往返时的 SSPI 登录", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "f1f3975518d8eff680f5c29ae7d80eeb58b8fe6e3eda5868fe2dc4b0ccb40b3b", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix SSPI login when multiple roundtrips are required (Ahmed Shinwari, Magnus Hagander) The typical symptom of this problem was The function requested is not supported errors during SSPI login.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/034", "db_id": "de930a64439fe15c6fb5927b1a514612", "patch_ids": [], "statement_hash": "ab01a1b223d43d2a06696c29615f44109d67e8e53fd9e73b29f96228b99bf650", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-35f12da9cc71db20", "cves": [], "html": "修复向 postgresql.conf 添加自定义变量类的新变量时的失败（Tom Lane）
如果 pg_hba.conf 包含 hostssl 但 SSL 被禁用则抛出错误（Tom Lane）
这被认定比此前静默忽略这类行的行为更用户友好。
", "text": "如果 pg_hba.conf 包含 hostssl 但 SSL 被禁用则抛出错误（Tom Lane） 这被认定比此前静默忽略这类行的行为更用户友好。", "title": "如果 pg_hba.conf 包含 hostssl 但 SSL 被禁用则抛出错误", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "8982feb6f172ac9516467958ba21f5fd0bba63b25632751c7c33d647d7c070ff", "section_path": ["变更"], "commit_groups": [], "identity_text": "Throw an error if pg_hba.conf contains hostssl but SSL is disabled (Tom Lane) This was concluded to be more user-friendly than the previous behavior of silently ignoring such lines.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/036", "db_id": "3bc5bad025281e1d8dfd4cd091d37411", "patch_ids": [], "statement_hash": "c2f35d109c4dc81195dd7b963c6e4252915f05aea85b001d78188bf8ff764393", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-b99b09c935aaab5b", "cves": [], "html": "修复 DROP OWNED BY 试图移除序列上的默认权限时的失败（Shigeru Hanada）
修复 pg_srand48 种子初始化中的笔误（Andres Freund）
这导致未能使用所提供种子的所有位。该函数在大多数平台上不使用（只在没有 srandom 的平台上使用），而且无论如何看待，随机性低于预期的种子带来的潜在安全暴露似乎都很小。
避免 LIMIT 与 OFFSET 值之和超过 2^63 时的整数溢出（Heikki Linnakangas）
为 generate_series() 的 int4 和 int8 版本添加溢出检查（Robert Haas）
修复 to_char() 中移除尾随零的问题（Marti Raudsepp）
在使用 FM 且小数点后没有数字位的格式中，小数点左侧的零可能被错误移除。
修复 pg_size_pretty()，避免接近 2^63 的输入溢出（Tom Lane）
放宽 plpgsql 对记录值中 typmod 匹配的检查（Tom Lane）
\n过于严格的检查可能导致丢弃本应保留的长度修饰符。
", "text": "放宽 plpgsql 对记录值中 typmod 匹配的检查（Tom Lane） 过于严格的检查可能导致丢弃本应保留的长度修饰符。", "title": "放宽 plpgsql 对记录值中 typmod 匹配的检查", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "08b79c31cb927f9fe618aceef340960d24be3847cb653738b99f11b820993446", "section_path": ["变更"], "commit_groups": [], "identity_text": "Weaken plpgsql's check for typmod matching in record values (Tom Lane) An overly enthusiastic check could lead to discarding length modifiers that should have been kept.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/043", "db_id": "aa5c1fc267ab4160fca5c4b2d84f5083", "patch_ids": [], "statement_hash": "cad4edd036a183354d872eec2c4c84858fb28b0c988301e582c1b18543fcb0a1", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-1d0f582e6ca971f5", "cves": [], "html": "在 initdb 期间正确处理区域名中的引号（Heikki Linnakangas）
\n这种情况可能出现在某些 Windows 区域设置下，例如“People's Republic of China”。
", "text": "在 initdb 期间正确处理区域名中的引号（Heikki Linnakangas） 这种情况可能出现在某些 Windows 区域设置下，例如“People's Republic of China”。", "title": "在 initdb 期间正确处理区域名中的引号", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "cd44d96038b8d61704ab9f6996a310da211855039d0c85b76a1c9fa8bcacf7a5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Correctly handle quotes in locale names during initdb (Heikki Linnakangas) The case can arise with some Windows locales, such as People's Republic of China.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/044", "db_id": "5a38c8c5ca59255222e5985f0a9bdf0c", "patch_ids": [], "statement_hash": "4d0a997eb7763684cee9e01ea136e39c98657c75d954f3f9c65b6baa4944248b", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-f02aa99a218ec1aa", "cves": [], "html": "在 pg_upgrade 中，避免转储孤儿临时表（Bruce Momjian）
\n这防止了表 OID 分配在新旧安装之间失去同步的情况。
", "text": "在 pg_upgrade 中，避免转储孤儿临时表（Bruce Momjian） 这防止了表 OID 分配在新旧安装之间失去同步的情况。", "title": "在 pg_upgrade 中，避免转储孤儿临时表", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "833100418cbcbcafcf60497ce8292624bfc8c69a0de75bdef107584197b1484c", "section_path": ["变更"], "commit_groups": [], "identity_text": "In pg_upgrade, avoid dumping orphaned temporary tables (Bruce Momjian) This prevents situations wherein table OID assignments could get out of sync between old and new installations.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/045", "db_id": "765c8c68aa3b0490a3144b5de0374973", "patch_ids": [], "statement_hash": "c33616aeadca6719d71e7f27485695b8da8c2070c734f3f96ba51c7887464d95", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-199ca631561f96b9", "cves": [], "html": "修复 pg_upgrade，使其在从 8.3 升级期间保留 toast 表的 relfrozenxid（Bruce Momjian）
\n不这样做可能导致升级后 pg_clog 文件被过早删除。
修复 pg_upgrade 的 -l（日志）选项在 Windows 上工作的问题（Bruce Momjian）
在 pg_ctl 中，支持 Windows 上服务注册的静默模式（MauMau）
", "text": "在 pg_ctl 中，支持 Windows 上服务注册的静默模式（MauMau）", "title": "在 pg_ctl 中，支持 Windows 上服务注册的静默模式", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "33f01ca79eb91e9b23c37a613e543ab8df36c5365b047c5c567dfe96eadc1b8f", "section_path": ["变更"], "commit_groups": [], "identity_text": "In pg_ctl, support silent mode for service registrations on Windows (MauMau)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/048", "db_id": "7ccef7a9a042c981506ef45de83bb0af", "patch_ids": [], "statement_hash": "960e1bccb5b0eaa28fb129275454cc70f79491ecd9d16481356db89e8af55cfa", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-500ffa84ee5376ae", "cves": [], "html": "修复 psql 在从其他文件执行 COPY 期间脚本文件行号计数的问题（Tom Lane）
修复 pg_restore 直接写数据库模式对 standard_conforming_strings 的处理（Tom Lane）
当从以 standard_conforming_strings 设为 on 制作的归档文件直接恢复到数据库服务器时，pg_restore 可能发出不正确的命令。
对并行 pg_restore 不支持的情况更加用户友好（Tom Lane）
\n此变更确保这类情况在任何恢复动作发生之前就被检测并报告。
", "text": "对并行 pg_restore 不支持的情况更加用户友好（Tom Lane） 此变更确保这类情况在任何恢复动作发生之前就被检测并报告。", "title": "对并行 pg_restore 不支持的情况更加用户友好", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "e01c339f5f08e217a5548656802a1a546c2e8357e78f1069ae0242c3ab33255d", "section_path": ["变更"], "commit_groups": [], "identity_text": "Be more user-friendly about unsupported cases for parallel pg_restore (Tom Lane) This change ensures that such cases are detected and reported before any restore actions have been taken.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/051", "db_id": "9ae3e4f65ca6d29df28d7d88ef3f706b", "patch_ids": [], "statement_hash": "e00782bcc74c2bc8778ccbc4a6bea49945060044e6340863f689fa2febcf9519", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-6dab054de8c595b1", "cves": [], "html": "修复 libpq 的 LDAP 服务查找代码中的越界写入和内存泄漏（Albe Laurenz）
", "text": "修复 libpq 的 LDAP 服务查找代码中的越界写入和内存泄漏（Albe Laurenz）", "title": "修复 libpq 的 LDAP 服务查找代码中的越界写入和内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "42b1fc497673eb77704d769c83fdfd6a169505a73120eac6a3b17f7ccfcdf4d6", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix write-past-buffer-end and memory leak in libpq's LDAP service lookup code (Albe Laurenz)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/052", "db_id": "917cf5d250528bd3875516340bb75fd2", "patch_ids": [], "statement_hash": "bd4dcb56ef61729730f9dbf2a2cd5a60227019c86baf545975db44829284ee49", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-7701c79f717a3b2e", "cves": [], "html": "在 libpq 中，避免使用非阻塞 I/O 和 SSL 连接时的失败（Martin Pihlak、Tom Lane）
", "text": "在 libpq 中，避免使用非阻塞 I/O 和 SSL 连接时的失败（Martin Pihlak、Tom Lane）", "title": "在 libpq 中，避免使用非阻塞 I/O 和 SSL 连接时的失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "a32e2369b8348097d32661a445d02d079dc08724da1d8a945d9f705326effa42", "section_path": ["变更"], "commit_groups": [], "identity_text": "In libpq, avoid failures when using nonblocking I/O and an SSL connection (Martin Pihlak, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/053", "db_id": "6784e623de94a233a03e77ec426a68d5", "patch_ids": [], "statement_hash": "53b787c5b6935585b58d4337feb835dadfbb96b49f5bb783930d8dc2d4037da6", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-a101b5cab308ee6f", "cves": [], "html": "改进 libpq 对连接启动期间失败的处理（Tom Lane）
\n特别是，对 SSL 连接启动期间服务器报告 fork() 失败的响应现在更合理。
改进 libpq 对 SSL 失败的错误报告（Tom Lane）
", "text": "改进 libpq 对 SSL 失败的错误报告（Tom Lane）", "title": "改进 libpq 对 SSL 失败的错误报告", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "dcb9d57f3052090ee17199fe01b19fe37badbb965406f2992e40d12ae129f803", "section_path": ["变更"], "commit_groups": [], "identity_text": "Improve libpq's error reporting for SSL failures (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/055", "db_id": "2da6cd33cd6257df7bd32170cbc8cbee", "patch_ids": [], "statement_hash": "804f0119bbe102ff21ef4975ee11f69540630023e00cc072e1b8a1e49b5da912", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-16f52d1ed3025c0f", "cves": [], "html": "修复 PQsetvalue()，避免向最初来自服务器查询的 PGresult 添加新元组时可能崩溃（Andrew Chernow）
让 ecpglib 以 15 位精度写 double 值（Akira Kurosawa）
在 ecpglib 中，确保出错后恢复 LC_NUMERIC 设置（Michael Meskes）
应用上游对 blowfish 有符号字符缺陷的修复（CVE-2011-2483）（Tom Lane）
\ncontrib/pg_crypto 的 blowfish 加密代码在 char 为有符号的平台（大多数平台如此）上可能给出错误结果，导致加密口令比应有的强度更弱。
修复 contrib/seg 中的内存泄漏（Heikki Linnakangas）
修复 pgstatindex()，使其对空索引给出一致结果（Tom Lane）
允许使用 perl 5.14 构建（Alex Hunsaker）
", "text": "允许使用 perl 5.14 构建（Alex Hunsaker）", "title": "允许使用 perl 5.14 构建", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "2e13d277be584a5c9cb5a19aa4ea51096f05ed3dff3a702a6c31c71824f5e5fa", "section_path": ["变更"], "commit_groups": [], "identity_text": "Allow building with perl 5.14 (Alex Hunsaker)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/062", "db_id": "12181919e797977fd6a8eb4604be0f38", "patch_ids": [], "statement_hash": "8da45459c0723dc9f9270d845d7831a2a1fba49fe2b0715f16416dccef7db06c", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-0681077ecca05c06", "cves": [], "html": "修复构建和安装文件路径包含空格的各种问题（Tom Lane）
", "text": "修复构建和安装文件路径包含空格的各种问题（Tom Lane）", "title": "修复构建和安装文件路径包含空格的各种问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "a03ec91891f0c6438a8f27d211d85bd89cb583495c43a797fed4402818979c9c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix assorted issues with build and install file paths containing spaces (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/063", "db_id": "70c32ab657796b82a95e1f86f2b0c16a", "patch_ids": [], "statement_hash": "611b0c2aa93036b38510e3236a6a739f9631a0cd714fcda610b2f520496d31f8", "relations": [], "version": "9.0.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-390fc5430fa56c16", "cves": [], "html": "把时区数据文件更新为 tzdata 版本 2011i for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan。
", "text": "把时区数据文件更新为 tzdata 版本 2011i for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan。", "title": "把时区数据文件更新为 tzdata 版本 2011i for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.5/#id-1.11.6.23.5", "source_hash": "c7b1e5361546c15140f3f2c0461e5cf344d7a1929675dcfbfda0a219bd647810", "section_path": ["变更"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2011i for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/064", "db_id": "96a19602f4b237484f0fb352155f3ed8", "patch_ids": [], "statement_hash": "5a1b869d950438d25a1f8a65efc5256ff3b6ed06abf97a28ac8cc6b34237c8a2", "relations": [], "version": "9.0.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}]}], "stats": [{"key": "all", "label": "全部变更", "count": 64}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 39}, {"key": "security", "label": "安全相关", "count": 1}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 24}], "total": 64, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2011-2483", "url": "https://www.postgresql.org/support/security/CVE-2011-2483/", "fixed_version": "", "title": "应用上游对 blowfish 有符号字符缺陷的修复（CVE-2011-2483）"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 64, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}