对于运行 9.2.X 的用户，不需要进行转储/恢复。
不过，本版本纠正了若干潜在的数据损坏问题。请参见下面前三条变更日志，以确认你的安装是否受影响以及可以采取什么措施。\n
不过，如果你是从早于 9.2.4 的版本升级，请参见第 E.21 节。
", "compatibility_count": 0, "label": "9.2.6", "status_label": "历史版本", "eol": "2017-11-09", "age_days": 4682, "support_days": -3247}, "groups": [{"date": "2013-12-05", "build": "9.2.6", "major": "9.2", "minor": 6, "manual": "9.2", "status": "stable", "doc_git": "", "version": "9.2.6", "eol_date": "2017-11-09", "date_text": "2013-12-05", "supported": false, "manual_url": "/docs/9.2/release-9-2-6.html", "source_url": "/docs/release/9.2.6/", "entry_count": 26, "placeholder": false, "content_hash": "34b780c8c3ec045f97606149dacf9d1dbafa9bf3d37f8fd1f2d6856e698f7ee5", "manual_build": "9.2.24", "source_as_of": "", "changes_count": 26, "doc_loaded_at": "2026-09-26T02:56:46.946617", "migration_html": "对于运行 9.2.X 的用户，不需要进行转储/恢复。
不过，本版本纠正了若干潜在的数据损坏问题。请参见下面前三条变更日志，以确认你的安装是否受影响以及可以采取什么措施。\n
不过，如果你是从早于 9.2.4 的版本升级，请参见第 E.21 节。
", "compatibility_count": 0, "label": "9.2.6", "status_label": "历史版本", "eol": "2017-11-09", "age_days": 4682, "support_days": -3247, "entries": [{"id": "9.2.6-abf63764d111cc9f", "cves": [], "html": " 修复 VACUUM 判断是否可以更新 relfrozenxid 的测试（Andres Freund）\n
某些情况下，VACUUM（手工或自动）可能错误地推进表的 relfrozenxid 值，使元组逃过冻结，导致这些行在经过 2^31 个事务后变得不可见。由于需要多次错误推进才会发生实际丢失，数据丢失的概率相当低，但并非为零。在 9.2.0 及更高版本中，丢失概率更高，而且这一缺陷还可能导致“could not access status of transaction”错误。从 9.0.4、8.4.8 或更早版本升级的用户不受影响，但之后的所有版本都包含该缺陷。\n
升级后，在把 vacuum_freeze_table_age 设为零的情况下对所有数据库中的所有表执行清理，可以缓解此问题。这会修复任何潜伏的损坏，但无法修复所有既有的数据错误。不过，如果安装在其生命周期内执行的事务少于 2^31 个更新（可用 SELECT txid_current() < 2^31 检查），则在执行此清理之后即可认为该安装是安全的。\n
修复热备启动期间 pg_clog 和 pg_subtrans 的初始化（Andres Freund、Heikki Linnakangas）\n
这一缺陷会把已提交事务标记为未提交，从而在备库开始接受热备查询的那一刻造成数据丢失。除非备库启动时主库自上次检查点以来执行了大量更新事务，否则这种损坏的可能性很小。症状包括行缺失、本应删除的行仍可见，以及已更新行的过时版本与新版本同时可见。\n
该缺陷是在 9.3.0、9.2.5、9.1.10 和 9.0.14 版本中引入的。只运行过更早版本的备库没有风险。建议曾运行过任何含缺陷版本的备库在升级后从主库重新克隆（例如用新的基础备份）。\n
", "text": "修复热备启动期间 pg_clog 和 pg_subtrans 的初始化（Andres Freund、Heikki Linnakangas） 这一缺陷会把已提交事务标记为未提交，从而在备库开始接受热备查询的那一刻造成数据丢失。除非备库启动时主库自上次检查点以来执行了大量更新事务，否则这种损坏的可能性很小。症状包括行缺失、本应删除的行仍可见，以及已更新行的过时版本与新版本同时可见。 该缺陷是在 9.3.0、9.2.5、9.1.10 和 9.0.14 版本中引入的。只运行过更早版本的备库没有风险。建议曾运行过任何含缺陷版本的备库在升级后从主库重新克隆（例如用新的基础备份）。", "title": "修复热备启动期间 pg_clog 和 pg_subtrans 的初始化", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "6dae40bcb201811047a319c5216ac6bec23e8131658441c15860b671bc23ed18", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix initialization of pg_clog and pg_subtrans during hot standby startup (Andres Freund, Heikki Linnakangas) This bug can cause data loss on standby servers at the moment they start to accept hot-standby queries, by marking committed transactions as uncommitted. The likelihood of such corruption is small unless, at the time of standby startup, the primary server has executed many updating transactions since its last checkpoint. Symptoms include missing rows, rows that should have been deleted being still visible, and obsolete versions of updated rows being still visible alongside their newer versions. This bug was introduced in versions 9.3.0, 9.2.5, 9.1.10, and 9.0.14. Standby servers that have only been running earlier releases are not at risk. It's recommended that standby servers that have ever run any of the buggy releases be re-cloned from the primary (e.g., with a new base backup) after upgrading.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/002", "db_id": "901efd8aebaf77a6339dc8eb68def63e", "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913", "relations": [{"rule": 2, "type": "equivalent", "target": "0ef1879d1e53afd7f1388c2bfb67b1d4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}}, {"rule": 2, "type": "equivalent", "target": "4354cc947d1a9e224823cb48f97baa29", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}}, {"rule": 2, "type": "equivalent", "target": "be0f921e1ac97bf95d24f7ccbbfc3cd4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "4354cc947d1a9e224823cb48f97baa29", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复热备启动期间 pg_clog 和 pg_subtrans 的初始化", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}, "url": "/docs/compare/?release=9.3.2#9.3.2-75430459b83c6fcc", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "0ef1879d1e53afd7f1388c2bfb67b1d4", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "修复热备启动期间 pg_clog 和 pg_subtrans 的初始化", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}, "url": "/docs/compare/?release=9.1.11#9.1.11-75430459b83c6fcc", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "be0f921e1ac97bf95d24f7ccbbfc3cd4", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "修复热备启动期间 pg_clog 和 pg_subtrans 的初始化", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}, "url": "/docs/compare/?release=9.0.15#9.0.15-75430459b83c6fcc", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-1895d11a55da5937", "cves": [], "html": "修复快速路径锁定中的悬空指针问题（Tom Lane）\n
这可能导致共享内存中锁数据结构的损坏，造成“lock already held”和其他奇怪的错误。\n
", "text": "修复快速路径锁定中的悬空指针问题（Tom Lane） 这可能导致共享内存中锁数据结构的损坏，造成“lock already held”和其他奇怪的错误。", "title": "修复快速路径锁定中的悬空指针问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "2281a33a72c79d471ed91e5a642290940d5f53ada32063fe715c56e34374ff67", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix dangling-pointer problem in fast-path locking (Tom Lane) This could lead to corruption of the lock data structures in shared memory, causing lock already held and other odd errors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/003", "db_id": "2486a4438d3abc57225f8f26b280fe9f", "patch_ids": [], "statement_hash": "020f282ee518184028bea679963a34d1570c06bcb386bbea1109a99c6d72a8bc", "relations": [{"rule": 2, "type": "equivalent", "target": "c517f677b2703c4049cc3bf0adc59a4b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "020f282ee518184028bea679963a34d1570c06bcb386bbea1109a99c6d72a8bc"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c517f677b2703c4049cc3bf0adc59a4b", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复快速路径锁定中的悬空指针问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "020f282ee518184028bea679963a34d1570c06bcb386bbea1109a99c6d72a8bc"}, "url": "/docs/compare/?release=9.3.2#9.3.2-1895d11a55da5937", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}]}, {"id": "9.2.6-3c68846981b0ce05", "cves": [], "html": " 在 WAL 重放期间截断 pg_multixact 内容（Andres Freund）\n
这避免了备库中磁盘空间消耗不断增加。\n
", "text": "在 WAL 重放期间截断 pg_multixact 内容（Andres Freund） 这避免了备库中磁盘空间消耗不断增加。", "title": "在 WAL 重放期间截断 pg_multixact 内容", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "1f0e1d3f4baab9df0a9d0dd015b5991613eb990edad968ec1234a9d36ac3aa2e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Truncate pg_multixact contents during WAL replay (Andres Freund) This avoids ever-increasing disk space consumption in standby servers.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/004", "db_id": "714c9a65006f2669cc88af918eeedf2d", "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938", "relations": [{"rule": 2, "type": "equivalent", "target": "2ab09ab16fc74bcd964e8dbf67d0b5a0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}}, {"rule": 2, "type": "equivalent", "target": "bba9adb4cf79576fe7660d52aac70f83", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}}, {"rule": 2, "type": "equivalent", "target": "cd2378a1b741e9efcd50ec64673f309e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}}], "version": "9.2.6", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "cd2378a1b741e9efcd50ec64673f309e", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "在 WAL 重放期间截断 pg_multixact 内容", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}, "url": "/docs/compare/?release=9.3.2#9.3.2-3c68846981b0ce05", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "2ab09ab16fc74bcd964e8dbf67d0b5a0", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "在 WAL 重放期间截断 pg_multixact 内容", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}, "url": "/docs/compare/?release=9.1.11#9.1.11-3c68846981b0ce05", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "bba9adb4cf79576fe7660d52aac70f83", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "在 WAL 重放期间截断 pg_multixact 内容", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}, "url": "/docs/compare/?release=9.0.15#9.0.15-3c68846981b0ce05", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-95f7664f268523da", "cves": [], "html": " 确保防回卷 VACUUM 在仅验证了没有元组需要冻结时也把该页计为已扫描（Sergey Burladyan、Jeff Janes）\n
这一缺陷可能导致 relfrozenxid 未能推进，使该表仍被认为需要再次防回卷清理。最坏情况下，数据库甚至可能为防止回卷而关闭。\n
修复 GIN 索引 posting 树页面删除中的竞态条件（Heikki Linnakangas）\n
这可能导致瞬时的错误结果或查询失败。\n
", "text": "修复 GIN 索引 posting 树页面删除中的竞态条件（Heikki Linnakangas） 这可能导致瞬时的错误结果或查询失败。", "title": "修复 GIN 索引 posting 树页面删除中的竞态条件", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "91c8de29d0767b8dc6411f04e599bafa6ec014779ade9cf26fab54b16b59c731", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix race condition in GIN index posting tree page deletion (Heikki Linnakangas) This could lead to transient wrong answers or query failures.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/006", "db_id": "e61288b4d8d31e702a099b6c442953d6", "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0", "relations": [{"rule": 2, "type": "equivalent", "target": "789d7ff24e2fea7a05dbdfb17d12c20d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}}, {"rule": 2, "type": "equivalent", "target": "96fd2c00f600bb1490cdeef970027a27", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}}, {"rule": 2, "type": "equivalent", "target": "c05264daf32f008727a03c0e9d1634dc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c05264daf32f008727a03c0e9d1634dc", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复 GIN 索引 posting 树页面删除中的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}, "url": "/docs/compare/?release=9.3.2#9.3.2-8f37e9445b864c31", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "96fd2c00f600bb1490cdeef970027a27", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "修复 GIN 索引 posting 树页面删除中的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}, "url": "/docs/compare/?release=9.1.11#9.1.11-8f37e9445b864c31", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "789d7ff24e2fea7a05dbdfb17d12c20d", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "修复 GIN 索引 posting 树页面删除中的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}, "url": "/docs/compare/?release=9.0.15#9.0.15-8f37e9445b864c31", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-76c1c6d73605b653", "cves": [], "html": "修复 SP-GiST 索引创建期间的“unexpected spgdoinsert() failure”错误（Teodor Sigaev）\n
", "text": "修复 SP-GiST 索引创建期间的“unexpected spgdoinsert() failure”错误（Teodor Sigaev）", "title": "修复 SP-GiST 索引创建期间的“unexpected spgdoinsert() failure”错误", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "2a5d1537535ba108c10568526b596f39a18cfb6f76e742546ae4c5126c4202dd", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix unexpected spgdoinsert() failure error during SP-GiST index creation (Teodor Sigaev)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/007", "db_id": "8109c1b7fda854702607ce1bf1c239d5", "patch_ids": [], "statement_hash": "9c38bae562368fd9cea0a62122d3cf8c44e2d57919b1618df75fe92f145c52b0", "relations": [{"rule": 2, "type": "equivalent", "target": "2b98839819d91f11cc4139cc49119418", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9c38bae562368fd9cea0a62122d3cf8c44e2d57919b1618df75fe92f145c52b0"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "2b98839819d91f11cc4139cc49119418", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复 SP-GiST 索引创建期间的 “unexpected spgdoinsert() failure” 错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9c38bae562368fd9cea0a62122d3cf8c44e2d57919b1618df75fe92f145c52b0"}, "url": "/docs/compare/?release=9.3.2#9.3.2-842756fb73bbad02", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}]}, {"id": "9.2.6-121ab8a03eaa5bea", "cves": [], "html": " 避免展平 SELECT 列表中包含包裹在子 SELECT 中的易变函数的子查询（Tom Lane）\n
这避免了因易变函数被额外求值而导致的意外结果。\n
", "text": "避免展平 SELECT 列表中包含包裹在子 SELECT 中的易变函数的子查询（Tom Lane） 这避免了因易变函数被额外求值而导致的意外结果。", "title": "避免展平 SELECT 列表中包含包裹在子 SELECT 中的易变函数的子查询", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "36f673840f0b68373a4bec3cac1343cbc17356df61e0c217db78552e5897858d", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT (Tom Lane) This avoids unexpected results due to extra evaluations of the volatile function.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/008", "db_id": "f9bdc2a201976a72575aab9fdbdd57b1", "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb", "relations": [{"rule": 2, "type": "equivalent", "target": "097f89eb3d95a428d6d9eb09740567b8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}}, {"rule": 2, "type": "equivalent", "target": "df73986505d42b26f2af65e7291f2c03", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}}, {"rule": 2, "type": "equivalent", "target": "e9f8dfb4a813cd5095b24d286270230d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}}], "version": "9.2.6", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "df73986505d42b26f2af65e7291f2c03", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "避免展平 SELECT 列表中包含包裹在子 SELECT 中的易变函数的子查询", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}, "url": "/docs/compare/?release=9.3.2#9.3.2-121ab8a03eaa5bea", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "e9f8dfb4a813cd5095b24d286270230d", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "避免展平 SELECT 列表中包含包裹在子 SELECT 中的易变函数的子查询", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}, "url": "/docs/compare/?release=9.1.11#9.1.11-121ab8a03eaa5bea", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "097f89eb3d95a428d6d9eb09740567b8", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "避免展平 SELECT 列表中包含包裹在子 SELECT 中的易变函数的子查询", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}, "url": "/docs/compare/?release=9.0.15#9.0.15-121ab8a03eaa5bea", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-2cfc143b9d165255", "cves": [], "html": "修复规划器对外连接中嵌套的非简单变量子查询输出的处理（Tom Lane）\n
这一错误可能为涉及 JOIN 语法中多级子查询的查询生成错误的计划。\n
修复同一非严格表达式出现在多个 WHERE 和外连接 JOIN 等值子句中时的错误规划（Tom Lane）\n
修复对子查询的整行引用导致规划器崩溃的问题（Tom Lane）\n
", "text": "修复对子查询的整行引用导致规划器崩溃的问题（Tom Lane）", "title": "修复对子查询的整行引用导致规划器崩溃的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "412ac78a3f4fc515185c01ccda6211c2bce9451bef109ba0d5b5f68481ae58b5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix planner crash with whole-row reference to a subquery (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/011", "db_id": "a9ca73f6071f71970df2f90376ffdad3", "patch_ids": [], "statement_hash": "179c1e2f723447912f0b97ac0f27d79b59627b35ba60a2e92d50e1e687c869e6", "relations": [{"rule": 2, "type": "equivalent", "target": "a569976016af70e6b700555b04ab6a5d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "179c1e2f723447912f0b97ac0f27d79b59627b35ba60a2e92d50e1e687c869e6"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a569976016af70e6b700555b04ab6a5d", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复对子查询的整行引用导致规划器崩溃的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "179c1e2f723447912f0b97ac0f27d79b59627b35ba60a2e92d50e1e687c869e6"}, "url": "/docs/compare/?release=9.3.2#9.3.2-38b7b29ad3fce8c3", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}]}, {"id": "9.2.6-48d46053c2c2eef4", "cves": [], "html": "修复继承树的优化 MIN()/MAX() 计划生成错误（Tom Lane）\n
当 MIN()/MAX() 的参数是表达式而不是简单变量时，规划器可能失败。\n
", "text": "修复继承树的优化 MIN()/MAX() 计划生成错误（Tom Lane） 当 MIN()/MAX() 的参数是表达式而不是简单变量时，规划器可能失败。", "title": "修复继承树的优化 MIN()/MAX() 计划生成错误", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "cea3433b008f7c49859e05e9da2ee8207bd997bc151d0b278522d86eab2b4d01", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix incorrect generation of optimized MIN()/MAX() plans for inheritance trees (Tom Lane) The planner could fail in cases where the MIN()/MAX() argument was an expression rather than a simple variable.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/012", "db_id": "f01f8238f135123e84d73bcc9822e19d", "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61", "relations": [{"rule": 2, "type": "equivalent", "target": "339ffd90456fa9cba8be03a6d01df826", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61"}}, {"rule": 2, "type": "equivalent", "target": "c8d909f561ae33e6df161be0742d3c51", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c8d909f561ae33e6df161be0742d3c51", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复继承树的优化 MIN()/MAX() 计划生成错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61"}, "url": "/docs/compare/?release=9.3.2#9.3.2-48d46053c2c2eef4", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "339ffd90456fa9cba8be03a6d01df826", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "修复继承树的优化 MIN()/MAX() 计划生成错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61"}, "url": "/docs/compare/?release=9.1.11#9.1.11-48d46053c2c2eef4", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}]}, {"id": "9.2.6-79374173a62be50b", "cves": [], "html": "修复临时文件被过早删除的问题（Andres Freund）\n
", "text": "修复临时文件被过早删除的问题（Andres Freund）", "title": "修复临时文件被过早删除的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "e5e91dd3a5106b0714f7cf93ae357cce871b0b72eb44ebc2466cb59f7abc8403", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix premature deletion of temporary files (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/013", "db_id": "60928172601d5b6dda085390441c12fa", "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355", "relations": [{"rule": 2, "type": "equivalent", "target": "0215f444a73bfa2ac623668492cbf9da", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}}, {"rule": 2, "type": "equivalent", "target": "794c783639e28fe65ce37ad20e41d06f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}}, {"rule": 2, "type": "equivalent", "target": "eea4af0d1602c8ce09fc3f6cf6e9923f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "794c783639e28fe65ce37ad20e41d06f", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复临时文件被过早删除的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}, "url": "/docs/compare/?release=9.3.2#9.3.2-79374173a62be50b", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "eea4af0d1602c8ce09fc3f6cf6e9923f", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "修复临时文件被过早删除的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}, "url": "/docs/compare/?release=9.1.11#9.1.11-79374173a62be50b", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "0215f444a73bfa2ac623668492cbf9da", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "修复临时文件被过早删除的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}, "url": "/docs/compare/?release=9.0.15#9.0.15-79374173a62be50b", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-fec2762a1428e381", "cves": [], "html": "防止打印范围值时的事务内内存泄漏（Tom Lane）\n
此修复实际上消除了任何数据类型输出函数中的瞬时内存泄漏，但已知只有范围类型曾出现显著问题。\n
", "text": "防止打印范围值时的事务内内存泄漏（Tom Lane） 此修复实际上消除了任何数据类型输出函数中的瞬时内存泄漏，但已知只有范围类型曾出现显著问题。", "title": "防止打印范围值时的事务内内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "c0f815efe44a4d5ad93c7c35306eab22cdd02d4e772a81c88c35a260a8a55ef8", "section_path": ["变更"], "commit_groups": [], "identity_text": "Prevent intra-transaction memory leak when printing range values (Tom Lane) This fix actually cures transient memory leaks in any datatype output function, but range types are the only ones known to have had a significant problem.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/014", "db_id": "e4f07bc495985d5f3a2f0c0033ac58a0", "patch_ids": [], "statement_hash": "fcb0b015590f6d5b196f3085f0ec4717cc0e91e1131380314f3bedc5204621de", "relations": [{"rule": 2, "type": "equivalent", "target": "fa91aece2c4def2398ffacd427ff008f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcb0b015590f6d5b196f3085f0ec4717cc0e91e1131380314f3bedc5204621de"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa91aece2c4def2398ffacd427ff008f", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "防止打印范围值时的事务内内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcb0b015590f6d5b196f3085f0ec4717cc0e91e1131380314f3bedc5204621de"}, "url": "/docs/compare/?release=9.3.2#9.3.2-fec2762a1428e381", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}]}, {"id": "9.2.6-055b1e1aac0d3e9e", "cves": [], "html": "防止 NOT NULL 和 CHECK 约束违规消息中错误地显示已删除的列（Michael Paquier、Tom Lane）\n
", "text": "防止 NOT NULL 和 CHECK 约束违规消息中错误地显示已删除的列（Michael Paquier、Tom Lane）", "title": "防止 NOT NULL 和 CHECK 约束违规消息中错误地显示已删除的列", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "586d005abc73af1d69b3646614a68b286614dcb0a83f50548d4419357b72be8b", "section_path": ["变更"], "commit_groups": [], "identity_text": "Prevent incorrect display of dropped columns in NOT NULL and CHECK constraint violation messages (Michael Paquier and Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/015", "db_id": "f042db5bc5ef684661e5a3ee5d1741d4", "patch_ids": [], "statement_hash": "5e971ef7855dd62c24022dabf41e47ec1898e43ffb391ade31e97b7155bf615b", "relations": [{"rule": 2, "type": "equivalent", "target": "9a9cdbc2ea819cba1ca239f19de50ecc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e971ef7855dd62c24022dabf41e47ec1898e43ffb391ade31e97b7155bf615b"}}], "version": "9.2.6", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "9a9cdbc2ea819cba1ca239f19de50ecc", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "防止 NOT NULL 和 CHECK 约束违规消息中错误地显示已删除的列", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e971ef7855dd62c24022dabf41e47ec1898e43ffb391ade31e97b7155bf615b"}, "url": "/docs/compare/?release=9.3.2#9.3.2-055b1e1aac0d3e9e", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}]}, {"id": "9.2.6-d351937490906535", "cves": [], "html": "允许窗口函数使用默认参数和命名参数记法（Tom Lane）\n
此前这些情况很可能崩溃。\n
", "text": "允许窗口函数使用默认参数和命名参数记法（Tom Lane） 此前这些情况很可能崩溃。", "title": "允许窗口函数使用默认参数和命名参数记法", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "5b500017abb9ef4cdeeea04082ca2d21fdb9098ebed936deecb5e21e7519c47a", "section_path": ["变更"], "commit_groups": [], "identity_text": "Allow default arguments and named-argument notation for window functions (Tom Lane) Previously, these cases were likely to crash.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/016", "db_id": "08d74fbaaca370df8f0371f1ccab6f9a", "patch_ids": [], "statement_hash": "a2c8bf238db48fc6d86051097c35bfa514e17314aae8a44ceef651dbb5b64d5b", "relations": [{"rule": 2, "type": "equivalent", "target": "db2d61b2cd6d9a46030ac60bebe9d59a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a2c8bf238db48fc6d86051097c35bfa514e17314aae8a44ceef651dbb5b64d5b"}}], "version": "9.2.6", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "db2d61b2cd6d9a46030ac60bebe9d59a", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "允许窗口函数使用默认参数和命名参数记法", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a2c8bf238db48fc6d86051097c35bfa514e17314aae8a44ceef651dbb5b64d5b"}, "url": "/docs/compare/?release=9.3.2#9.3.2-d351937490906535", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}]}, {"id": "9.2.6-33766060b5f495ac", "cves": [], "html": "修复规则打印中可能读取越过内存末尾的问题（Peter Eisentraut）\n
", "text": "修复规则打印中可能读取越过内存末尾的问题（Peter Eisentraut）", "title": "修复规则打印中可能读取越过内存末尾的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "b7e02dbd5dcef5e0a25f1d8c9c6836cfec403ca5c343aa0aedf299f85ce04093", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible read past end of memory in rule printing (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/017", "db_id": "faa18fe51c0b4eebc64a07aeca34c7e2", "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762", "relations": [{"rule": 2, "type": "equivalent", "target": "52a1895a8d0fca9d245787982a39c754", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}}, {"rule": 2, "type": "equivalent", "target": "5f850f0c90891244795995e7648334db", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}}, {"rule": 2, "type": "equivalent", "target": "ced8771b6066f828b8d7a8a2dfbfed08", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "52a1895a8d0fca9d245787982a39c754", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复规则打印中可能读取越过内存末尾的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}, "url": "/docs/compare/?release=9.3.2#9.3.2-33766060b5f495ac", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "5f850f0c90891244795995e7648334db", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "修复规则打印中可能读取越过内存末尾的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}, "url": "/docs/compare/?release=9.1.11#9.1.11-33766060b5f495ac", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "ced8771b6066f828b8d7a8a2dfbfed08", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "修复规则打印中可能读取越过内存末尾的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}, "url": "/docs/compare/?release=9.0.15#9.0.15-33766060b5f495ac", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-f956ca6666def5ba", "cves": [], "html": " 修复 int2vector 和 oidvector 值的数组切片（Tom Lane）\n
这类表达式现在会被隐式提升为常规的 int2 或 oid 数组。\n
修复使用 SQL 标准的简单 GMT 偏移时区时的错误行为（Tom Lane）\n
某些情况下，系统会使用简单 GMT 偏移值，而本应使用选择简单偏移之前一直生效的常规时区设置。此变更还使 timeofday 函数遵循简单 GMT 偏移时区。\n
防止记录 Windows 错误码翻译时可能出现的不当行为（Tom Lane）\n
", "text": "防止记录 Windows 错误码翻译时可能出现的不当行为（Tom Lane）", "title": "防止记录 Windows 错误码翻译时可能出现的不当行为", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "b534a69735517531237cb1d9be94f15b96841831c95d9f3733b41e4921cbb667", "section_path": ["变更"], "commit_groups": [], "identity_text": "Prevent possible misbehavior when logging translations of Windows error codes (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/020", "db_id": "aeede94f946c1ded6bedcaa1abc527b3", "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b", "relations": [{"rule": 2, "type": "equivalent", "target": "11c80cc0b7a2fc53ad9812bcf14375c2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}}, {"rule": 2, "type": "equivalent", "target": "13b0387ae30ee6ae7463f9d748e7dcf1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}}, {"rule": 2, "type": "equivalent", "target": "54820da474bebf8b921bae7f57eada98", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}}], "version": "9.2.6", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "13b0387ae30ee6ae7463f9d748e7dcf1", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "防止记录 Windows 错误码翻译时可能出现的不当行为", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}, "url": "/docs/compare/?release=9.3.2#9.3.2-bdebcc31fe0dc7c0", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "54820da474bebf8b921bae7f57eada98", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "防止记录 Windows 错误码翻译时可能出现的不当行为", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}, "url": "/docs/compare/?release=9.1.11#9.1.11-bdebcc31fe0dc7c0", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "11c80cc0b7a2fc53ad9812bcf14375c2", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "防止记录 Windows 错误码翻译时可能出现的不当行为", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}, "url": "/docs/compare/?release=9.0.15#9.0.15-bdebcc31fe0dc7c0", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-e12c41883839f84f", "cves": [], "html": "正确地为 pg_ctl 生成的命令行加引号（Naoya Anzai、Tom Lane）\n
此修复仅适用于 Windows。\n
", "text": "正确地为 pg_ctl 生成的命令行加引号（Naoya Anzai、Tom Lane） 此修复仅适用于 Windows。", "title": "正确地为 pg_ctl 生成的命令行加引号", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "7c654722e991126168400db1cb093d0408c5692c6d3cdb6f49dcd2208b8b9736", "section_path": ["变更"], "commit_groups": [], "identity_text": "Properly quote generated command lines in pg_ctl (Naoya Anzai and Tom Lane) This fix applies only to Windows.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/021", "db_id": "b1f08684e6cfbb31c79a0dccb63be1f8", "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f", "relations": [{"rule": 2, "type": "equivalent", "target": "06ef602928ccb464f7de8ec282bf722b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}}, {"rule": 2, "type": "equivalent", "target": "8b28d4028101ea2d3477d14a5442e5f3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}}, {"rule": 2, "type": "equivalent", "target": "bbe0bde4d80cb9deabba661cfb328a9b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}}], "version": "9.2.6", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "bbe0bde4d80cb9deabba661cfb328a9b", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "正确地为 pg_ctl 生成的命令行加引号", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}, "url": "/docs/compare/?release=9.3.2#9.3.2-e12c41883839f84f", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "06ef602928ccb464f7de8ec282bf722b", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "正确地为 pg_ctl 生成的命令行加引号", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}, "url": "/docs/compare/?release=9.1.11#9.1.11-e12c41883839f84f", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "8b28d4028101ea2d3477d14a5442e5f3", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "正确地为 pg_ctl 生成的命令行加引号", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}, "url": "/docs/compare/?release=9.0.15#9.0.15-e12c41883839f84f", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-7dc92563d1e4f087", "cves": [], "html": " 修复当源数据库通过 ALTER DATABASE SET 设置 default_transaction_read_only 时 pg_dumpall 无法工作的问题（Kevin Grittner）\n
此前，生成的脚本在恢复期间会失败。\n
", "text": "修复当源数据库通过 ALTER DATABASE SET 设置 default_transaction_read_only 时 pg_dumpall 无法工作的问题（Kevin Grittner） 此前，生成的脚本在恢复期间会失败。", "title": "修复当源数据库通过 ALTER DATABASE SET 设置 default_transaction_read_only 时 pg_dumpall 无法工作的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "ddc1f4d975a82f4f14f87600c1439f1a838c022e32eb2c8312fa545b25203fe5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET (Kevin Grittner) Previously, the generated script would fail during restore.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/022", "db_id": "af9bf6db44c025c5eb9a27b06c7074d4", "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c", "relations": [{"rule": 2, "type": "equivalent", "target": "48525738e3d068e0af15f93585c27c23", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}}, {"rule": 2, "type": "equivalent", "target": "6185cd94f5d883265aac461185ec82d6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}}, {"rule": 2, "type": "equivalent", "target": "9f630319d7135ae6876108b30d324497", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}}], "version": "9.2.6", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6185cd94f5d883265aac461185ec82d6", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "修复当源数据库通过 ALTER DATABASE SET 设置 default_transaction_read_only 时 pg_dumpall 无法工作的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}, "url": "/docs/compare/?release=9.3.2#9.3.2-7dc92563d1e4f087", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "9f630319d7135ae6876108b30d324497", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "修复当源数据库通过 ALTER DATABASE SET 设置 default_transaction_read_only 时 pg_dumpall 无法工作的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}, "url": "/docs/compare/?release=9.1.11#9.1.11-7dc92563d1e4f087", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "48525738e3d068e0af15f93585c27c23", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "修复当源数据库通过 ALTER DATABASE SET 设置 default_transaction_read_only 时 pg_dumpall 无法工作的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}, "url": "/docs/compare/?release=9.0.15#9.0.15-7dc92563d1e4f087", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}, {"id": "9.2.6-c42e3aa7be61a159", "cves": [], "html": "让 ecpg 以大小写敏感方式搜索带引号的游标名（Zoltán Böszörményi）\n
", "text": "让 ecpg 以大小写敏感方式搜索带引号的游标名（Zoltán Böszörményi）", "title": "让 ecpg 以大小写敏感方式搜索带引号的游标名", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "6df5cbd43360788b6b5779a71cab630f9d5042c45ce1635dd94e00855f77f7f4", "section_path": ["变更"], "commit_groups": [], "identity_text": "Make ecpg search for quoted cursor names case-sensitively (Zoltán Böszörményi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/023", "db_id": "c56f1d7cc6c344b0e448dd10bfeaf87b", "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4", "relations": [{"rule": 2, "type": "equivalent", "target": "664f2a70f76b238ff7461dd363b63e85", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4"}}, {"rule": 2, "type": "equivalent", "target": "9c81d9ba335c94e5da5b3d4e1131fc37", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4"}}], "version": "9.2.6", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "664f2a70f76b238ff7461dd363b63e85", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "让 ecpg 以大小写敏感方式搜索带引号的游标名", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4"}, "url": "/docs/compare/?release=9.3.2#9.3.2-c42e3aa7be61a159", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "9c81d9ba335c94e5da5b3d4e1131fc37", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "让 ecpg 以大小写敏感方式搜索带引号的游标名", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4"}, "url": "/docs/compare/?release=9.1.11#9.1.11-c42e3aa7be61a159", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}]}, {"id": "9.2.6-169a7568a70cb421", "cves": [], "html": " 修复 ecpg 对声明为 varchar 的变量列表的处理（Zoltán Böszörményi）\n
让 contrib/lo 防御不正确的触发器定义（Marc Cousin）\n
把时区数据文件更新为 tzdata 版本 2013h\n for DST law changes in Argentina, Brazil, Jordan, Libya,\n Liechtenstein, Morocco, and Palestine。Also, new timezone\n abbreviations WIB, WIT, WITA for Indonesia.\n
", "text": "把时区数据文件更新为 tzdata 版本 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine。Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "title": "把时区数据文件更新为 tzdata 版本 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine。Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.6/#id-1.11.6.23.5", "source_hash": "d3c55877b3d6f9247c68d1738d2e6e2c385bd03687a37412e5673a1173491117", "section_path": ["变更"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/026", "db_id": "424125e8e6a645f6b06c795a699f69d0", "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f", "relations": [{"rule": 2, "type": "equivalent", "target": "7be18ae3b11bb3941b2b0b756054a0c8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}}, {"rule": 2, "type": "equivalent", "target": "7c44c32d94b8860307e11c5103c052c9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}}, {"rule": 2, "type": "equivalent", "target": "873dbd191790e30b273777ef978761ed", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}}], "version": "9.2.6", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "873dbd191790e30b273777ef978761ed", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "把时区数据文件更新为 tzdata 版本 2013h，以反映阿根廷、巴西、约旦、利比亚、列支敦士登、摩洛哥和巴勒斯坦的夏令时法规变更。另外，新增印度尼西亚的时区缩写 WIB、WIT、WITA。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}, "url": "/docs/compare/?release=9.3.2#9.3.2-eaeafa79cd57e97b", "source_url": "/docs/release/9.3.2/#id-1.11.6.28.5"}, {"db_id": "7be18ae3b11bb3941b2b0b756054a0c8", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "把时区数据文件更新为 tzdata 版本 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine。Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}, "url": "/docs/compare/?release=9.1.11#9.1.11-c44e740c2c08d47e", "source_url": "/docs/release/9.1.11/#id-1.11.6.18.5"}, {"db_id": "7c44c32d94b8860307e11c5103c052c9", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "把时区数据文件更新为 tzdata 版本 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine。Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}, "url": "/docs/compare/?release=9.0.15#9.0.15-c44e740c2c08d47e", "source_url": "/docs/release/9.0.15/#id-1.11.6.13.5"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 26}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 16}, {"key": "security", "label": "安全相关", "count": 0}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 10}], "total": 26, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 26, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}