对于运行 9.2.X 的用户，不需要进行转储/恢复。
不过，如果你是从早于 9.2.2 的版本升级，请参见第 E.23 节。
", "compatibility_count": 0, "label": "9.2.3", "status_label": "历史版本", "eol": "2017-11-09", "age_days": 4983, "support_days": -3247}, "groups": [{"date": "2013-02-07", "build": "9.2.3", "major": "9.2", "minor": 3, "manual": "9.2", "status": "stable", "doc_git": "", "version": "9.2.3", "eol_date": "2017-11-09", "date_text": "2013-02-07", "supported": false, "manual_url": "/docs/9.2/release-9-2-3.html", "source_url": "/docs/release/9.2.3/", "entry_count": 43, "placeholder": false, "content_hash": "e3e901b27ecb7da63ad03a463575dc37d2cdfbed74ed91871640a0535a70a3ce", "manual_build": "9.2.24", "source_as_of": "", "changes_count": 43, "doc_loaded_at": "2026-09-26T02:56:46.946617", "migration_html": "对于运行 9.2.X 的用户，不需要进行转储/恢复。
不过，如果你是从早于 9.2.2 的版本升级，请参见第 E.23 节。
", "compatibility_count": 0, "label": "9.2.3", "status_label": "历史版本", "eol": "2017-11-09", "age_days": 4983, "support_days": -3247, "entries": [{"id": "9.2.3-91b92bd203b9332b", "cves": ["CVE-2013-0255"], "html": " 防止从 SQL 执行 enum_recv（Tom Lane）\n
该函数声明有误，允许一条简单的 SQL 命令使服务器崩溃。原则上攻击者可能利用它检查服务器内存的内容。感谢 Sumit Soni（通过 Secunia SVCRP）报告此问题。（CVE-2013-0255）\n
", "text": "防止从 SQL 执行 enum_recv（Tom Lane） 该函数声明有误，允许一条简单的 SQL 命令使服务器崩溃。原则上攻击者可能利用它检查服务器内存的内容。感谢 Sumit Soni（通过 Secunia SVCRP）报告此问题。（CVE-2013-0255）", "title": "防止从 SQL 执行 enum_recv", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "a6b3429df40917e804ae9f3df02667745382dc8e344f06fc0212a4d806fbf864", "section_path": ["变更"], "commit_groups": [], "identity_text": "Prevent execution of enum_recv from SQL (Tom Lane) The function was misdeclared, allowing a simple SQL command to crash the server. In principle an attacker might be able to use it to examine the contents of server memory. Our thanks to Sumit Soni (via Secunia SVCRP) for reporting this issue. (CVE-2013-0255)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/001", "db_id": "e4073a2043e993fe80ee86d66eaf52c3", "patch_ids": [], "statement_hash": "8018138401c4605fd69a4015bbddab1708da0a341d9b5372ef38bd70bef6e31e", "relations": [{"rule": 2, "type": "equivalent", "target": "3e2c12362d5d790ac381850df41ba0d4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8018138401c4605fd69a4015bbddab1708da0a341d9b5372ef38bd70bef6e31e"}}, {"rule": 2, "type": "equivalent", "target": "4221aaac3275bb1ce0907871e741ff8e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8018138401c4605fd69a4015bbddab1708da0a341d9b5372ef38bd70bef6e31e"}}], "version": "9.2.3", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "4221aaac3275bb1ce0907871e741ff8e", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "防止从 SQL 执行 enum_recv", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8018138401c4605fd69a4015bbddab1708da0a341d9b5372ef38bd70bef6e31e"}, "url": "/docs/compare/?release=9.1.8#9.1.8-91b92bd203b9332b", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "3e2c12362d5d790ac381850df41ba0d4", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "防止从 SQL 执行 enum_recv", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8018138401c4605fd69a4015bbddab1708da0a341d9b5372ef38bd70bef6e31e"}, "url": "/docs/compare/?release=9.0.12#9.0.12-91b92bd203b9332b", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-a350cbbcb21a0a18", "cves": [], "html": "修复 WAL 重放期间检测何时达到一致数据库状态的多个问题（Fujii Masao、Heikki Linnakangas、Simon Riggs、Andres Freund）\n
", "text": "修复 WAL 重放期间检测何时达到一致数据库状态的多个问题（Fujii Masao、Heikki Linnakangas、Simon Riggs、Andres Freund）", "title": "修复 WAL 重放期间检测何时达到一致数据库状态的多个问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "d2a1de107ada35245453aa44fcff32b17449af03a1e931c9baa08b66d5f28029", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix multiple problems in detection of when a consistent database state has been reached during WAL replay (Fujii Masao, Heikki Linnakangas, Simon Riggs, Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/002", "db_id": "fdaa210137246825261db30f9a6f36f5", "patch_ids": [], "statement_hash": "5bcb0538e465c57e132664b1fe18882dc87dd6b8088f72c9541a72b30c63499d", "relations": [{"rule": 2, "type": "equivalent", "target": "3ef43a101b38a8f7bcd2f8fcd43c625b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bcb0538e465c57e132664b1fe18882dc87dd6b8088f72c9541a72b30c63499d"}}, {"rule": 2, "type": "equivalent", "target": "fadb263785b5197f9c4077e21ddd41bd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bcb0538e465c57e132664b1fe18882dc87dd6b8088f72c9541a72b30c63499d"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fadb263785b5197f9c4077e21ddd41bd", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复 WAL 重放期间检测何时达到一致数据库状态的多个问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bcb0538e465c57e132664b1fe18882dc87dd6b8088f72c9541a72b30c63499d"}, "url": "/docs/compare/?release=9.1.8#9.1.8-a350cbbcb21a0a18", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "3ef43a101b38a8f7bcd2f8fcd43c625b", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "修复 WAL 重放期间检测何时达到一致数据库状态的多个问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bcb0538e465c57e132664b1fe18882dc87dd6b8088f72c9541a72b30c63499d"}, "url": "/docs/compare/?release=9.0.12#9.0.12-a350cbbcb21a0a18", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-13a050d4730fc877", "cves": [], "html": "修复不需要实际重做工作时对备份结束点的检测（Heikki Linnakangas）\n
这一失误可能导致错误的“WAL ends before end of online backup”错误。\n
", "text": "修复不需要实际重做工作时对备份结束点的检测（Heikki Linnakangas） 这一失误可能导致错误的“WAL ends before end of online backup”错误。", "title": "修复不需要实际重做工作时对备份结束点的检测", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "d56e8b03b1b63de393c8668e60ce5d136827d6bf838b87acff1f520b37f9e64f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix detection of end-of-backup point when no actual redo work is required (Heikki Linnakangas) This mistake could result in incorrect WAL ends before end of online backup errors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/003", "db_id": "4c818049e83921208fe9b844616a562a", "patch_ids": [], "statement_hash": "4e5870656afba2c3f613ff7eebfcd70e5e30b8cd6798d6c57cdaf7d80554ca0d", "relations": [], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-16307396445d2320", "cves": [], "html": "在截断关系文件时更新最小恢复点（Heikki Linnakangas）\n
数据一旦被丢弃，在时间线上更早的点停止恢复就不再安全。\n
", "text": "在截断关系文件时更新最小恢复点（Heikki Linnakangas） 数据一旦被丢弃，在时间线上更早的点停止恢复就不再安全。", "title": "在截断关系文件时更新最小恢复点", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "a19081b86e225c7e1f77e7a07bede0f90b47c18b9bef0e8de5fb02a87b49c0d0", "section_path": ["变更"], "commit_groups": [], "identity_text": "Update minimum recovery point when truncating a relation file (Heikki Linnakangas) Once data has been discarded, it's no longer safe to stop recovery at an earlier point in the timeline.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/004", "db_id": "a2897187973796aa1f3cb5aaf9592aea", "patch_ids": [], "statement_hash": "b238a16c4484b5e1ebde5f1462c1da23e79e4b0922fd4628fded093e4cefb1fe", "relations": [{"rule": 2, "type": "equivalent", "target": "2429e8033349c37ddbdf001d05122236", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b238a16c4484b5e1ebde5f1462c1da23e79e4b0922fd4628fded093e4cefb1fe"}}, {"rule": 2, "type": "equivalent", "target": "f08672018f8003de3ab8249659f9d52c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b238a16c4484b5e1ebde5f1462c1da23e79e4b0922fd4628fded093e4cefb1fe"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f08672018f8003de3ab8249659f9d52c", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "在截断关系文件时更新最小恢复点", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b238a16c4484b5e1ebde5f1462c1da23e79e4b0922fd4628fded093e4cefb1fe"}, "url": "/docs/compare/?release=9.1.8#9.1.8-16307396445d2320", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "2429e8033349c37ddbdf001d05122236", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "在截断关系文件时更新最小恢复点", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b238a16c4484b5e1ebde5f1462c1da23e79e4b0922fd4628fded093e4cefb1fe"}, "url": "/docs/compare/?release=9.0.12#9.0.12-16307396445d2320", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-39eec271ebe62ea1", "cves": [], "html": "修复更改恢复目标时间线后 WAL 段的回收问题（Heikki Linnakangas）\n
", "text": "修复更改恢复目标时间线后 WAL 段的回收问题（Heikki Linnakangas）", "title": "修复更改恢复目标时间线后 WAL 段的回收问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "3eff56811fd6a583cc2ee2b9e7e8dc1c654cceadabc4971417cd6743e7f3a02c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix recycling of WAL segments after changing recovery target timeline (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/005", "db_id": "617d33b9bea74445ec1f5c9e2921d522", "patch_ids": [], "statement_hash": "3917649d5cdd8438e9dfd161cf509f1a29e8e0652d1f18633b616b4a4bbcb72e", "relations": [{"rule": 2, "type": "equivalent", "target": "fdeff65e4a38e7875431102398f23a0c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3917649d5cdd8438e9dfd161cf509f1a29e8e0652d1f18633b616b4a4bbcb72e"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fdeff65e4a38e7875431102398f23a0c", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复更改恢复目标时间线后 WAL 段的回收问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3917649d5cdd8438e9dfd161cf509f1a29e8e0652d1f18633b616b4a4bbcb72e"}, "url": "/docs/compare/?release=9.1.8#9.1.8-39eec271ebe62ea1", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}]}, {"id": "9.2.3-3b37c3f56ba32be8", "cves": [], "html": "在级联备库服务器上正确地从归档恢复时间线历史文件（Heikki Linnakangas）\n
", "text": "在级联备库服务器上正确地从归档恢复时间线历史文件（Heikki Linnakangas）", "title": "在级联备库服务器上正确地从归档恢复时间线历史文件", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "a4cde8b54af2c84e1b0337a3a62df45e8d88f42876ab02fe67e5474c5c3938fe", "section_path": ["变更"], "commit_groups": [], "identity_text": "Properly restore timeline history files from archive on cascading standby servers (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/006", "db_id": "60ff4caa5a98e1a6d053d9cef5095238", "patch_ids": [], "statement_hash": "8748c1fceb6fb96b99e2028be18cd2d0663c80a2b09fc3b1dec0d95e40fcf650", "relations": [], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-703cd7e4f8541fba", "cves": [], "html": "修复热备服务器上的锁冲突检测（Andres Freund、Robert Haas）\n
", "text": "修复热备服务器上的锁冲突检测（Andres Freund、Robert Haas）", "title": "修复热备服务器上的锁冲突检测", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "a4d8f9d39136d61c12763ddf9812333bc95839fa2a07dc7086ea212f78bc9644", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix lock conflict detection on hot-standby servers (Andres Freund, Robert Haas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/007", "db_id": "bdb9901fb155b8010caa89f1b6a6ae43", "patch_ids": [], "statement_hash": "f61792bf165f9e62d8d23fc726460a01579f7e0e9d7c8e584d2f140136703510", "relations": [], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-328fca946db8a287", "cves": [], "html": "修复热备模式下缺失的取消操作（Noah Misch、Simon Riggs）\n
取消冲突热备查询的需要有时会被遗漏，使这些查询看到不一致的数据。\n
", "text": "修复热备模式下缺失的取消操作（Noah Misch、Simon Riggs） 取消冲突热备查询的需要有时会被遗漏，使这些查询看到不一致的数据。", "title": "修复热备模式下缺失的取消操作", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "396803c519b895fe106e82514c6a553be7f6eca24f44f97f9be044c28c2b7aed", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix missing cancellations in hot standby mode (Noah Misch, Simon Riggs) The need to cancel conflicting hot-standby queries would sometimes be missed, allowing those queries to see inconsistent data.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/008", "db_id": "1c332c471d743826c8bbd21e8da0f88b", "patch_ids": [], "statement_hash": "29691cf096ef2b8f7772c0c1a88f12b6a33a9b74c22e16511a5504c941ef3faf", "relations": [{"rule": 2, "type": "equivalent", "target": "ab59487cc20954116d3a7c00f88d6c0b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29691cf096ef2b8f7772c0c1a88f12b6a33a9b74c22e16511a5504c941ef3faf"}}, {"rule": 2, "type": "equivalent", "target": "fdb7b6975ab326ff1a56eb83c39c639b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29691cf096ef2b8f7772c0c1a88f12b6a33a9b74c22e16511a5504c941ef3faf"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fdb7b6975ab326ff1a56eb83c39c639b", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复热备模式下缺失的取消操作", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29691cf096ef2b8f7772c0c1a88f12b6a33a9b74c22e16511a5504c941ef3faf"}, "url": "/docs/compare/?release=9.1.8#9.1.8-328fca946db8a287", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "ab59487cc20954116d3a7c00f88d6c0b", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "修复热备模式下缺失的取消操作", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29691cf096ef2b8f7772c0c1a88f12b6a33a9b74c22e16511a5504c941ef3faf"}, "url": "/docs/compare/?release=9.0.12#9.0.12-328fca946db8a287", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-f880339bcfcca2d6", "cves": [], "html": "防止恢复暂停功能在用户能够连接之前就暂停（Tom Lane）\n
", "text": "防止恢复暂停功能在用户能够连接之前就暂停（Tom Lane）", "title": "防止恢复暂停功能在用户能够连接之前就暂停", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "e35fa51359420db31561589d78d94deaa6ad4156c44171938c4af58c24929ebd", "section_path": ["变更"], "commit_groups": [], "identity_text": "Prevent recovery pause feature from pausing before users can connect (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/009", "db_id": "fe3e9abc289e2498f2bf03cb3b573587", "patch_ids": [], "statement_hash": "88389014cdd1b8244d7b7890957765ea8f39ea856e7ea72da9ef4b3f6cdfac40", "relations": [{"rule": 2, "type": "equivalent", "target": "62a53167e3730ac3d9939759bc195861", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "88389014cdd1b8244d7b7890957765ea8f39ea856e7ea72da9ef4b3f6cdfac40"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "62a53167e3730ac3d9939759bc195861", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "防止恢复暂停功能在用户能够连接之前就暂停", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "88389014cdd1b8244d7b7890957765ea8f39ea856e7ea72da9ef4b3f6cdfac40"}, "url": "/docs/compare/?release=9.1.8#9.1.8-f880339bcfcca2d6", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}]}, {"id": "9.2.3-cace9bed0c76fdcf", "cves": [], "html": "修复 SQL 文法，允许对子 SELECT 结果做下标或字段选择（Tom Lane）\n
", "text": "修复 SQL 文法，允许对子 SELECT 结果做下标或字段选择（Tom Lane）", "title": "修复 SQL 文法，允许对子 SELECT 结果做下标或字段选择", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "148f9632eda6ffb3bf75bbdc9d4d413a00ea6b27fdddb6f5cec7d4db82c5b60a", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix SQL grammar to allow subscripting or field selection from a sub-SELECT result (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/010", "db_id": "c172c281ebf7ef05d7151ba47e04c582", "patch_ids": [], "statement_hash": "bd01a0fa0aae935547790272a58548938856e616c9f336714db28f524b5c676d", "relations": [{"rule": 2, "type": "equivalent", "target": "39aafb0dd7097f163535b703f0bb8fa0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd01a0fa0aae935547790272a58548938856e616c9f336714db28f524b5c676d"}}, {"rule": 2, "type": "equivalent", "target": "895374fe22ae5293bb5f8959e25772e8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd01a0fa0aae935547790272a58548938856e616c9f336714db28f524b5c676d"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "895374fe22ae5293bb5f8959e25772e8", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复 SQL 文法，允许对子 SELECT 结果做下标或字段选择", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd01a0fa0aae935547790272a58548938856e616c9f336714db28f524b5c676d"}, "url": "/docs/compare/?release=9.1.8#9.1.8-cace9bed0c76fdcf", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "39aafb0dd7097f163535b703f0bb8fa0", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "修复 SQL 文法，允许对子 SELECT 结果做下标或字段选择", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd01a0fa0aae935547790272a58548938856e616c9f336714db28f524b5c676d"}, "url": "/docs/compare/?release=9.0.12#9.0.12-cace9bed0c76fdcf", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-f0bf6d806fb9f955", "cves": [], "html": "修复繁忙负载下自动清理截断的性能问题（Jan Wieck）\n
截断表末尾的空页需要排他锁，但自动清理被编码为在出现冲突锁请求时失败（并释放表锁）。在负载下，截断很可能永远不会发生，导致表膨胀。修复方法是先执行部分截断，释放锁，然后尝试重新获取锁并继续。此修复还大幅缩短了冲突请求到达后自动清理释放锁的平均时间。\n
", "text": "修复繁忙负载下自动清理截断的性能问题（Jan Wieck） 截断表末尾的空页需要排他锁，但自动清理被编码为在出现冲突锁请求时失败（并释放表锁）。在负载下，截断很可能永远不会发生，导致表膨胀。修复方法是先执行部分截断，释放锁，然后尝试重新获取锁并继续。此修复还大幅缩短了冲突请求到达后自动清理释放锁的平均时间。", "title": "修复繁忙负载下自动清理截断的性能问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "a783d1fc824a4b1541252431039f7f3c7b846d5559c86a17852ffe205b266154", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix performance problems with autovacuum truncation in busy workloads (Jan Wieck) Truncation of empty pages at the end of a table requires exclusive lock, but autovacuum was coded to fail (and release the table lock) when there are conflicting lock requests. Under load, it is easily possible that truncation would never occur, resulting in table bloat. Fix by performing a partial truncation, releasing the lock, then attempting to re-acquire the lock and continue. This fix also greatly reduces the average time before autovacuum releases the lock after a conflicting request arrives.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/011", "db_id": "54219d51cf8c2a51712e6c63125aa984", "patch_ids": [], "statement_hash": "875ccfe31c156a689602f0b94b37996e94934844623d1dc53baaeb2f3f262707", "relations": [{"rule": 2, "type": "equivalent", "target": "3d37c1cba00aaff6d71eb9162c03d0a4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "875ccfe31c156a689602f0b94b37996e94934844623d1dc53baaeb2f3f262707"}}, {"rule": 2, "type": "equivalent", "target": "ff055e53d870d7dc5b5d43ba36306047", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "875ccfe31c156a689602f0b94b37996e94934844623d1dc53baaeb2f3f262707"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ff055e53d870d7dc5b5d43ba36306047", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复繁忙负载下自动清理截断的性能问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "875ccfe31c156a689602f0b94b37996e94934844623d1dc53baaeb2f3f262707"}, "url": "/docs/compare/?release=9.1.8#9.1.8-f0bf6d806fb9f955", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "3d37c1cba00aaff6d71eb9162c03d0a4", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "修复繁忙负载下自动清理截断的性能问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "875ccfe31c156a689602f0b94b37996e94934844623d1dc53baaeb2f3f262707"}, "url": "/docs/compare/?release=9.0.12#9.0.12-f0bf6d806fb9f955", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-d355e9c38d790084", "cves": [], "html": " 改进 SPI_execute 及相关函数的性能，从而改进 PL/pgSQL 的 EXECUTE（Heikki Linnakangas、Tom Lane）\n
移除 9.2 中因计划缓存机制修改而引入的一些数据复制开销。这消除了相比 9.1 的性能退化，还节省了内存，尤其是当要执行的查询串包含许多 SQL 语句时。\n
一个附带好处是多语句查询串现在完全串行处理，即我们先完成前面语句的执行，再对后续语句做解析分析和规划。这消除了一个长期存在的问题：本应影响后续语句行为的 DDL 现在会按预期工作。\n
", "text": "改进 SPI_execute 及相关函数的性能，从而改进 PL/pgSQL 的 EXECUTE（Heikki Linnakangas、Tom Lane） 移除 9.2 中因计划缓存机制修改而引入的一些数据复制开销。这消除了相比 9.1 的性能退化，还节省了内存，尤其是当要执行的查询串包含许多 SQL 语句时。 一个附带好处是多语句查询串现在完全串行处理，即我们先完成前面语句的执行，再对后续语句做解析分析和规划。这消除了一个长期存在的问题：本应影响后续语句行为的 DDL 现在会按预期工作。", "title": "改进 SPI_execute 及相关函数的性能，从而改进 PL/pgSQL 的 EXECUTE", "commits": [], "section": "变更", "category": "performance", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "3b188f95f2e2298985d52fd741408c37b8e205cc3bdc1feff5a6e8ed86d73d6c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Improve performance of SPI_execute and related functions, thereby improving PL/pgSQL's EXECUTE (Heikki Linnakangas, Tom Lane) Remove some data-copying overhead that was added in 9.2 as a consequence of revisions in the plan caching mechanism. This eliminates a performance regression compared to 9.1, and also saves memory, especially when the query string to be executed contains many SQL statements. A side benefit is that multi-statement query strings are now processed fully serially, that is we complete execution of earlier statements before running parse analysis and planning on the following ones. This eliminates a long-standing issue, in that DDL that should affect the behavior of a later statement will now behave as expected.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/012", "db_id": "3d26e51a13dd46a8fb2e38b0d057876e", "patch_ids": [], "statement_hash": "d1f98b18f54e79bafa3099f39aca6bd298fb76d1c9ebef3c6bb9b39292d6a44d", "relations": [], "version": "9.2.3", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-0b50e01583dbd6b2", "cves": [], "html": "恢复 9.2 之前对索引使用的代价估计（Tom Lane）\n
一个欠考虑的修正因子变更导致对使用超大索引的代价估计高得离谱。\n
", "text": "恢复 9.2 之前对索引使用的代价估计（Tom Lane） 一个欠考虑的修正因子变更导致对使用超大索引的代价估计高得离谱。", "title": "恢复 9.2 之前对索引使用的代价估计", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "f73f14faeabdd8773093bca06e528ad4a3f15b8845cba67efbd0bc15fe78af38", "section_path": ["变更"], "commit_groups": [], "identity_text": "Restore pre-9.2 cost estimates for index usage (Tom Lane) An ill-considered change of a fudge factor led to undesirably high cost estimates for use of very large indexes.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/013", "db_id": "1e5b81e7178d4a83772d00cb9c90480e", "patch_ids": [], "statement_hash": "92c24e3e97dc08112e87cf5bf298edde1836d56b9564d095e75e715b5a16768c", "relations": [], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-335bd844483d7d4b", "cves": [], "html": " 修复 DROP INDEX CONCURRENTLY 中的间歇性崩溃（Tom Lane）\n
修复 CREATE/DROP INDEX CONCURRENTLY 期间共享内存锁表可能损坏的问题（Tom Lane）\n
修复 COPY 的多元组插入代码在元组大于页大小减去填充因子时的情况（Heikki Linnakangas）\n
先前的代码可能陷入无限循环。\n
", "text": "修复 COPY 的多元组插入代码在元组大于页大小减去填充因子时的情况（Heikki Linnakangas） 先前的代码可能陷入无限循环。", "title": "修复 COPY 的多元组插入代码在元组大于页大小减去填充因子时的情况", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "b83329d514566227a4993926344e762c64f36b0a05c92c22c0d755b55768f043", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix COPY's multiple-tuple-insertion code for the case of a tuple larger than page size minus fillfactor (Heikki Linnakangas) The previous coding could get into an infinite loop.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/016", "db_id": "14f6e8c9f9ead49dfe599b13d5168589", "patch_ids": [], "statement_hash": "fcd5fe47a835ec08de6f8a8f9ce098a9fab155b08798c83ef5cdbec7e641680d", "relations": [], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-c1c40c256e4746b0", "cves": [], "html": " 防止扫描 pg_tablespace 时的竞态条件（Stephen Frost、Tom Lane）\n
如果 pg_tablespace 条目存在并发更新，CREATE DATABASE 和 DROP DATABASE 可能行为异常。\n
防止 DROP OWNED 试图删除整个数据库或表空间（Álvaro Herrera）\n
为安全起见，这些对象的所有权必须重新分配，而不是删除。\n
", "text": "防止 DROP OWNED 试图删除整个数据库或表空间（Álvaro Herrera） 为安全起见，这些对象的所有权必须重新分配，而不是删除。", "title": "防止 DROP OWNED 试图删除整个数据库或表空间", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "d9c83aaab2e664a263f83f14c989c447b35b6d1deae3f9eab497191c19eb25e1", "section_path": ["变更"], "commit_groups": [], "identity_text": "Prevent DROP OWNED from trying to drop whole databases or tablespaces (Álvaro Herrera) For safety, ownership of these objects must be reassigned, not dropped.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/018", "db_id": "fd69836f756ccf7e773d19a70c716b6f", "patch_ids": [], "statement_hash": "14ac52f7c4085a31a2f64a07f6bcff3dc98a49399939b3110e5e00c4fb9d7597", "relations": [{"rule": 2, "type": "equivalent", "target": "4591577da65e3adbae050099c8f44547", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "14ac52f7c4085a31a2f64a07f6bcff3dc98a49399939b3110e5e00c4fb9d7597"}}, {"rule": 2, "type": "equivalent", "target": "91872261cc4f61e151e9a7d0ad8c8923", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "14ac52f7c4085a31a2f64a07f6bcff3dc98a49399939b3110e5e00c4fb9d7597"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "4591577da65e3adbae050099c8f44547", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "防止 DROP OWNED 试图删除整个数据库或表空间", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "14ac52f7c4085a31a2f64a07f6bcff3dc98a49399939b3110e5e00c4fb9d7597"}, "url": "/docs/compare/?release=9.1.8#9.1.8-c2386c3f3fc0b0cc", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "91872261cc4f61e151e9a7d0ad8c8923", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "防止 DROP OWNED 试图删除整个数据库或表空间", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "14ac52f7c4085a31a2f64a07f6bcff3dc98a49399939b3110e5e00c4fb9d7597"}, "url": "/docs/compare/?release=9.0.12#9.0.12-c2386c3f3fc0b0cc", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-78a2eaeea160458d", "cves": [], "html": " 修复 vacuum_freeze_table_age 实现中的错误（Andres Freund）\n
在已存在超过 vacuum_freeze_min_age 个事务的安装中，这一失误使自动清理无法使用部分表扫描，而总是进行全表扫描。\n
防止 RowExpr 或 XmlExpr 被二次解析分析时的不当行为（Andres Freund、Tom Lane）\n
这一失误在 CREATE TABLE LIKE INCLUDING INDEXES 等上下文中可能被用户看到。\n
增强对哈希表大小计算中整数溢出的防御（Jeff Davis）\n
", "text": "增强对哈希表大小计算中整数溢出的防御（Jeff Davis）", "title": "增强对哈希表大小计算中整数溢出的防御", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "f7fbe3b839f1826fbb542e1588af73d4f6bd9c66c931f4428f2a793badc03399", "section_path": ["变更"], "commit_groups": [], "identity_text": "Improve defenses against integer overflow in hashtable sizing calculations (Jeff Davis)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/021", "db_id": "8ace4c7a60dfb373dc4953a9dc984660", "patch_ids": [], "statement_hash": "c40eb99c68dea04c5fb7bddd9508bb7faa85f02166cf3ea732045bafdb466912", "relations": [{"rule": 2, "type": "equivalent", "target": "407aa706c6605ff416cb7c4e4e75428f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c40eb99c68dea04c5fb7bddd9508bb7faa85f02166cf3ea732045bafdb466912"}}, {"rule": 2, "type": "equivalent", "target": "7a490a116aa2738e282697a6f4adbb39", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c40eb99c68dea04c5fb7bddd9508bb7faa85f02166cf3ea732045bafdb466912"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "407aa706c6605ff416cb7c4e4e75428f", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "增强对哈希表大小计算中整数溢出的防御", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c40eb99c68dea04c5fb7bddd9508bb7faa85f02166cf3ea732045bafdb466912"}, "url": "/docs/compare/?release=9.1.8#9.1.8-972b3cd30af49471", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "7a490a116aa2738e282697a6f4adbb39", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "增强对哈希表大小计算中整数溢出的防御", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c40eb99c68dea04c5fb7bddd9508bb7faa85f02166cf3ea732045bafdb466912"}, "url": "/docs/compare/?release=9.0.12#9.0.12-972b3cd30af49471", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-bc1523c01f996056", "cves": [], "html": "修复一些与数据类型权限相关的缺陷（Tom Lane）\n
类型的默认权限存在一些问题，而且 pg_dump 完全没有转储这类权限。\n
", "text": "修复一些与数据类型权限相关的缺陷（Tom Lane） 类型的默认权限存在一些问题，而且 pg_dump 完全没有转储这类权限。", "title": "修复一些与数据类型权限相关的缺陷", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "3b708866e95c08b5b53e05856174b92b910fb86979e6d0fe969187999e0d7b61", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix some bugs associated with privileges on datatypes (Tom Lane) There were some issues with default privileges for types, and pg_dump failed to dump such privileges at all.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/022", "db_id": "eae0e38c580931711097aad144c9135e", "patch_ids": [], "statement_hash": "7b17261f24e7529494921dc6929818f29df885309aa7fa96db7570d38155bc98", "relations": [], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-bf89b090c9fa9aac", "cves": [], "html": "修复服务器崩溃后未能忽略遗留临时表的问题（Tom Lane）\n
", "text": "修复服务器崩溃后未能忽略遗留临时表的问题（Tom Lane）", "title": "修复服务器崩溃后未能忽略遗留临时表的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "2defda10322c2ba067003ef96f74eb2508950a8b6e13f1a36a298828fd219ec5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix failure to ignore leftover temporary tables after a server crash (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/023", "db_id": "e53effdd407e57efc13624b190d78b1c", "patch_ids": [], "statement_hash": "11cddb9905c954c1078ef30869cd06730f59cc5c7fdeefe0c7924d35614cfd5b", "relations": [{"rule": 2, "type": "equivalent", "target": "437c5527098eeb43e4ab7a82d0f34819", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "11cddb9905c954c1078ef30869cd06730f59cc5c7fdeefe0c7924d35614cfd5b"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "437c5527098eeb43e4ab7a82d0f34819", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复服务器崩溃后未能忽略遗留临时表的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "11cddb9905c954c1078ef30869cd06730f59cc5c7fdeefe0c7924d35614cfd5b"}, "url": "/docs/compare/?release=9.1.8#9.1.8-bf89b090c9fa9aac", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}]}, {"id": "9.2.3-30911c87471cf8d0", "cves": [], "html": "修复 Windows 上 postmaster 日志文件未能因大小而轮转的问题（Jeff Janes、Heikki Linnakangas）\n
", "text": "修复 Windows 上 postmaster 日志文件未能因大小而轮转的问题（Jeff Janes、Heikki Linnakangas）", "title": "修复 Windows 上 postmaster 日志文件未能因大小而轮转的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "54c1fb46b24eb8abc34c44cab6d59c2bb2fa35bab5174bafb5bedfb0ac666c7e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix failure to rotate postmaster log files for size reasons on Windows (Jeff Janes, Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/024", "db_id": "66fc140d199f2b79bad5299bf3a1d144", "patch_ids": [], "statement_hash": "1d9e7c59f24021ee90bac074014754160b8202071493695393907cd0914d3e98", "relations": [], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-3e2b49ebac471453", "cves": [], "html": " 拒绝 to_date() 中超出范围的日期（Hitoshi Harada）\n
修复 pg_extension_config_dump()，使其正确处理扩展更新情况（Tom Lane）\n
该函数现在会替换目标表的任何现有条目，使其可以在扩展更新脚本中使用。\n
", "text": "修复 pg_extension_config_dump()，使其正确处理扩展更新情况（Tom Lane） 该函数现在会替换目标表的任何现有条目，使其可以在扩展更新脚本中使用。", "title": "修复 pg_extension_config_dump()，使其正确处理扩展更新情况", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "8a265086bbbc55703f2353432c0588c38ae773c07670006bb10f34becf12dc9d", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_extension_config_dump() to handle extension-update cases properly (Tom Lane) This function will now replace any existing entry for the target table, making it usable in extension update scripts.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/026", "db_id": "e17a79e9d7c541b7747d2e33caddd7a0", "patch_ids": [], "statement_hash": "d6acff85bd06e7dfc071ffa216f4ae30e07f1cd06bbdf4c01a332a2eaae606bb", "relations": [{"rule": 2, "type": "equivalent", "target": "e423edfc5f88010a741ccc3ac73ea30e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d6acff85bd06e7dfc071ffa216f4ae30e07f1cd06bbdf4c01a332a2eaae606bb"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e423edfc5f88010a741ccc3ac73ea30e", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复 pg_extension_config_dump()，使其正确处理扩展更新情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d6acff85bd06e7dfc071ffa216f4ae30e07f1cd06bbdf4c01a332a2eaae606bb"}, "url": "/docs/compare/?release=9.1.8#9.1.8-eec2c9efb2564077", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}]}, {"id": "9.2.3-a7aa2ee9cf911801", "cves": [], "html": "修复 PL/pgSQL 对可能简单的表达式中规划期错误的报告（Tom Lane）\n
先前的编码有时会遗漏错误 CONTEXT 回溯的第一行。\n
修复 PL/Python 对用作多个表上触发器的函数的处理（Andres Freund）\n
", "text": "修复 PL/Python 对用作多个表上触发器的函数的处理（Andres Freund）", "title": "修复 PL/Python 对用作多个表上触发器的函数的处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "f16382c99f6bea1669dee58929a10db0f3f794ababe5f8daeb27021dd987a8f5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix PL/Python's handling of functions used as triggers on multiple tables (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/028", "db_id": "220ca2d6d99d5edaf036ec9de1edaf63", "patch_ids": [], "statement_hash": "16bc5ee2021e7e1509563e5fcc9057e4ee27e57e2850811bbfbda9d62b955c5b", "relations": [{"rule": 2, "type": "equivalent", "target": "c3c8169604ec7fcbb21ebb2f9d454c94", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "16bc5ee2021e7e1509563e5fcc9057e4ee27e57e2850811bbfbda9d62b955c5b"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c3c8169604ec7fcbb21ebb2f9d454c94", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复 PL/Python 对用作多个表上触发器的函数的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "16bc5ee2021e7e1509563e5fcc9057e4ee27e57e2850811bbfbda9d62b955c5b"}, "url": "/docs/compare/?release=9.1.8#9.1.8-380ed487f24aad1b", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}]}, {"id": "9.2.3-47019676ebaffb41", "cves": [], "html": "确保在 Windows 上非 ASCII 提示符字符串被转换到正确的代码页（Alexander Law、Noah Misch）\n
这一缺陷影响 psql 和其他一些客户端程序。\n
", "text": "确保在 Windows 上非 ASCII 提示符字符串被转换到正确的代码页（Alexander Law、Noah Misch） 这一缺陷影响 psql 和其他一些客户端程序。", "title": "确保在 Windows 上非 ASCII 提示符字符串被转换到正确的代码页", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "1dbf2fd4f0dbed50334ceee12a8ee4b5d67575590c022af59893f0a412a083c0", "section_path": ["变更"], "commit_groups": [], "identity_text": "Ensure that non-ASCII prompt strings are translated to the correct code page on Windows (Alexander Law, Noah Misch) This bug affected psql and some other client programs.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/029", "db_id": "499d7f239bc7f7516c6ee6d43cc02a93", "patch_ids": [], "statement_hash": "f69a3f45358c1387bcd2664f6ff27dceb55540cdd9a475deeebc350b2489c7c8", "relations": [{"rule": 2, "type": "equivalent", "target": "8190c8b07e5709730eb6d83c24f133db", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f69a3f45358c1387bcd2664f6ff27dceb55540cdd9a475deeebc350b2489c7c8"}}, {"rule": 2, "type": "equivalent", "target": "9edd7b917ecb849fa7360d797874307b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f69a3f45358c1387bcd2664f6ff27dceb55540cdd9a475deeebc350b2489c7c8"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "8190c8b07e5709730eb6d83c24f133db", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "确保在 Windows 上非 ASCII 提示符字符串被转换到正确的代码页", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f69a3f45358c1387bcd2664f6ff27dceb55540cdd9a475deeebc350b2489c7c8"}, "url": "/docs/compare/?release=9.1.8#9.1.8-47019676ebaffb41", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "9edd7b917ecb849fa7360d797874307b", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "确保在 Windows 上非 ASCII 提示符字符串被转换到正确的代码页", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f69a3f45358c1387bcd2664f6ff27dceb55540cdd9a475deeebc350b2489c7c8"}, "url": "/docs/compare/?release=9.0.12#9.0.12-47019676ebaffb41", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-9c92341cb525866c", "cves": [], "html": " 修复未连接数据库时 psql 的 \\? 命令可能崩溃的问题（Meng Qingzhong）\n
修复 pg_basebackup 运行期间关系文件被删除时可能出错的问题（Heikki Linnakangas）\n
", "text": "修复 pg_basebackup 运行期间关系文件被删除时可能出错的问题（Heikki Linnakangas）", "title": "修复 pg_basebackup 运行期间关系文件被删除时可能出错的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "0dbb405b2471b0438db01045311c178af3a4b4b968fa170ead460ea1b2050c2d", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible error if a relation file is removed while pg_basebackup is running (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/031", "db_id": "ad431a8974aafad6fe5f0ef212ded2c9", "patch_ids": [], "statement_hash": "1f2dcf6685ba58e60ff5ccb88beba7f7a2ab6222b86c65d81573e45859845fe0", "relations": [{"rule": 2, "type": "equivalent", "target": "eb77abf069dfaf99401d074d6d261661", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2dcf6685ba58e60ff5ccb88beba7f7a2ab6222b86c65d81573e45859845fe0"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "eb77abf069dfaf99401d074d6d261661", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复 pg_basebackup 运行期间关系文件被删除时可能出错的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2dcf6685ba58e60ff5ccb88beba7f7a2ab6222b86c65d81573e45859845fe0"}, "url": "/docs/compare/?release=9.1.8#9.1.8-16ac9af31befd6e1", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}]}, {"id": "9.2.3-04cde31799066149", "cves": [], "html": " 让 pg_basebackup -X fetch 在备份备库服务器时容忍时间线切换（Heikki Linnakangas）\n
让 pg_dump 在热备服务器上运行时排除不记录日志的表的数据（Magnus Hagander）\n
由于数据在备库服务器上不可用，这本来就会失败，因此最方便的做法似乎是自动假定 --no-unlogged-table-data。\n
修复 pg_upgrade，使其安全处理无效索引（Bruce Momjian）\n
", "text": "修复 pg_upgrade，使其安全处理无效索引（Bruce Momjian）", "title": "修复 pg_upgrade，使其安全处理无效索引", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "71dc780c3de016743bc6aa8d54ffc6828e9138d5442c234a9a48783d1ea1b5af", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_upgrade to deal with invalid indexes safely (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/034", "db_id": "a67066b1ca30377c447faab9ede582e0", "patch_ids": [], "statement_hash": "4e11bc10b70c7c08a4bae50beef46b806a60dc077df9e13e1f7f9317daaf815e", "relations": [{"rule": 2, "type": "equivalent", "target": "92f2eedd0191008895ecc47a0381e525", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e11bc10b70c7c08a4bae50beef46b806a60dc077df9e13e1f7f9317daaf815e"}}, {"rule": 2, "type": "equivalent", "target": "c131f4fa68c816d68243f49e0e66d505", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e11bc10b70c7c08a4bae50beef46b806a60dc077df9e13e1f7f9317daaf815e"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "92f2eedd0191008895ecc47a0381e525", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复 pg_upgrade，使其安全处理无效索引", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e11bc10b70c7c08a4bae50beef46b806a60dc077df9e13e1f7f9317daaf815e"}, "url": "/docs/compare/?release=9.1.8#9.1.8-d939c31edae16dcb", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "c131f4fa68c816d68243f49e0e66d505", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "修复 pg_upgrade，使其安全处理无效索引", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e11bc10b70c7c08a4bae50beef46b806a60dc077df9e13e1f7f9317daaf815e"}, "url": "/docs/compare/?release=9.0.12#9.0.12-d939c31edae16dcb", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-e390ae7b08ec4c10", "cves": [], "html": "修复 pg_upgrade 的 -O/-o 选项（Marti Raudsepp）\n
", "text": "修复 pg_upgrade 的 -O/-o 选项（Marti Raudsepp）", "title": "修复 pg_upgrade 的 -O/-o 选项", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "57665834380a011be3a7ae62b157ba47f89b096985c7aa4010b9456ade8b329f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_upgrade's -O/-o options (Marti Raudsepp)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/035", "db_id": "3e2e68d33322779eb9f7360a98373b6f", "patch_ids": [], "statement_hash": "2b4a1727a69fa37150cf510f959845977fe3e0394e138323f216d7045390d7b3", "relations": [], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.2.3-2ae2e7061cacdd1a", "cves": [], "html": " 修复 libpq 的 PQprintTuples 中的一字节缓冲区越界（Xi Wang）\n
这个古老的函数没有被 PostgreSQL 本身在任何地方使用，但仍可能被某些客户端代码使用。\n
", "text": "修复 libpq 的 PQprintTuples 中的一字节缓冲区越界（Xi Wang） 这个古老的函数没有被 PostgreSQL 本身在任何地方使用，但仍可能被某些客户端代码使用。", "title": "修复 libpq 的 PQprintTuples 中的一字节缓冲区越界", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "37c5424b096a29e41b2206748cefb02b89f0feb843cdd9fd20ece00ad1fd3e2b", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix one-byte buffer overrun in libpq's PQprintTuples (Xi Wang) This ancient function is not used anywhere by PostgreSQL itself, but it might still be used by some client code.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/036", "db_id": "c7f27d190db5f6d76239b290151cabe0", "patch_ids": [], "statement_hash": "649cc796ce72b235c2b327eed32d383596d5163a8c749997d087c3d5c39cf421", "relations": [{"rule": 2, "type": "equivalent", "target": "55a3aa9b84d8e18a8636a2bf960e674c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "649cc796ce72b235c2b327eed32d383596d5163a8c749997d087c3d5c39cf421"}}, {"rule": 2, "type": "equivalent", "target": "ed8b11f668bf27965f1486ee0ee6c1dc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "649cc796ce72b235c2b327eed32d383596d5163a8c749997d087c3d5c39cf421"}}], "version": "9.2.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "55a3aa9b84d8e18a8636a2bf960e674c", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "修复 libpq 的 PQprintTuples 中的一字节缓冲区越界", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "649cc796ce72b235c2b327eed32d383596d5163a8c749997d087c3d5c39cf421"}, "url": "/docs/compare/?release=9.1.8#9.1.8-2ae2e7061cacdd1a", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "ed8b11f668bf27965f1486ee0ee6c1dc", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "修复 libpq 的 PQprintTuples 中的一字节缓冲区越界", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "649cc796ce72b235c2b327eed32d383596d5163a8c749997d087c3d5c39cf421"}, "url": "/docs/compare/?release=9.0.12#9.0.12-2ae2e7061cacdd1a", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-7ed1c785c1654486", "cves": [], "html": "让 ecpglib 正确使用翻译后的消息（Chen Huajun）\n
", "text": "让 ecpglib 正确使用翻译后的消息（Chen Huajun）", "title": "让 ecpglib 正确使用翻译后的消息", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "f8caa4d3fd2cf60a37d71b4ddad1d7c08751b7c61104b1fd2669154c5d250896", "section_path": ["变更"], "commit_groups": [], "identity_text": "Make ecpglib use translated messages properly (Chen Huajun)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/037", "db_id": "eea8e6946233ce55a4993f604dc80f93", "patch_ids": [], "statement_hash": "49a7631fea6e863d77c30b1a1cd722c8fac60892e288dea3eb95e2b39ea43b33", "relations": [{"rule": 2, "type": "equivalent", "target": "310e1bbd2a63a2c3059a7ab89d5a51ad", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a7631fea6e863d77c30b1a1cd722c8fac60892e288dea3eb95e2b39ea43b33"}}, {"rule": 2, "type": "equivalent", "target": "c9f8816bc5e0b59b3a950e7ba129bbd9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a7631fea6e863d77c30b1a1cd722c8fac60892e288dea3eb95e2b39ea43b33"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "c9f8816bc5e0b59b3a950e7ba129bbd9", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "让 ecpglib 正确使用翻译后的消息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a7631fea6e863d77c30b1a1cd722c8fac60892e288dea3eb95e2b39ea43b33"}, "url": "/docs/compare/?release=9.1.8#9.1.8-7ed1c785c1654486", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "310e1bbd2a63a2c3059a7ab89d5a51ad", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "让 ecpglib 正确使用翻译后的消息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a7631fea6e863d77c30b1a1cd722c8fac60892e288dea3eb95e2b39ea43b33"}, "url": "/docs/compare/?release=9.0.12#9.0.12-7ed1c785c1654486", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-ccb9daeb6839c518", "cves": [], "html": "在 MSVC 上正确安装 ecpg_compat 和 pgtypes 库（Jiang Guiqing）\n
", "text": "在 MSVC 上正确安装 ecpg_compat 和 pgtypes 库（Jiang Guiqing）", "title": "在 MSVC 上正确安装 ecpg_compat 和 pgtypes 库", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "aed9c30dba7d684dd617cae9fb1b11df4b882f0a0d3393078ff1da10bb2cbc40", "section_path": ["变更"], "commit_groups": [], "identity_text": "Properly install ecpg_compat and pgtypes libraries on MSVC (Jiang Guiqing)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/038", "db_id": "1e024e7c1038e29cadc05c57a2c91683", "patch_ids": [], "statement_hash": "0937e1a464eaade0933dd613a8a81f57b0bc406eec60623021c3cbc7c0f65d8f", "relations": [{"rule": 2, "type": "equivalent", "target": "10b62e8f30a945f4bebfae2e42174fa3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0937e1a464eaade0933dd613a8a81f57b0bc406eec60623021c3cbc7c0f65d8f"}}, {"rule": 2, "type": "equivalent", "target": "326a49f11dc364f4304b26e7f911cc66", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0937e1a464eaade0933dd613a8a81f57b0bc406eec60623021c3cbc7c0f65d8f"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "326a49f11dc364f4304b26e7f911cc66", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "在 MSVC 上正确安装 ecpg_compat 和 pgtypes 库", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0937e1a464eaade0933dd613a8a81f57b0bc406eec60623021c3cbc7c0f65d8f"}, "url": "/docs/compare/?release=9.1.8#9.1.8-ccb9daeb6839c518", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "10b62e8f30a945f4bebfae2e42174fa3", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "在 MSVC 上正确安装 ecpg_compat 和 pgtypes 库", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0937e1a464eaade0933dd613a8a81f57b0bc406eec60623021c3cbc7c0f65d8f"}, "url": "/docs/compare/?release=9.0.12#9.0.12-ccb9daeb6839c518", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-7c0fa34c12c36e2e", "cves": [], "html": " 如果系统未提供 isinf()，则在 libecpg 中包含我们自己的版本（Jiang Guiqing）\n
重新排列 configure 对系统提供函数的测试，使其不被 libedit/libreadline 的虚假导出所欺骗（Christoph Berg）\n
", "text": "重新排列 configure 对系统提供函数的测试，使其不被 libedit/libreadline 的虚假导出所欺骗（Christoph Berg）", "title": "重新排列 configure 对系统提供函数的测试，使其不被 libedit/libreadline 的虚假导出所欺骗", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "6863599e7568406f5a840997ce623afd0185622163f9e61d7f7c9602d0ee9602", "section_path": ["变更"], "commit_groups": [], "identity_text": "Rearrange configure's tests for supplied functions so it is not fooled by bogus exports from libedit/libreadline (Christoph Berg)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/040", "db_id": "74c00b37070e969a13d784c94a8a0e0d", "patch_ids": [], "statement_hash": "e158edd89dba605daf3b829b35ea5c84462911f2139c0b4bf0e8791365292202", "relations": [{"rule": 2, "type": "equivalent", "target": "0458d6b686242b9a6e4bed416ba3491e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e158edd89dba605daf3b829b35ea5c84462911f2139c0b4bf0e8791365292202"}}, {"rule": 2, "type": "equivalent", "target": "c5d8b22210ced8efa76a0da9a474bff0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e158edd89dba605daf3b829b35ea5c84462911f2139c0b4bf0e8791365292202"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "c5d8b22210ced8efa76a0da9a474bff0", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "重新排列 configure 对系统提供函数的测试，使其不被 libedit/libreadline 的虚假导出所欺骗", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e158edd89dba605daf3b829b35ea5c84462911f2139c0b4bf0e8791365292202"}, "url": "/docs/compare/?release=9.1.8#9.1.8-90755d80ecff086a", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "0458d6b686242b9a6e4bed416ba3491e", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "重新排列 configure 对系统提供函数的测试，使其不被 libedit/libreadline 的虚假导出所欺骗", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e158edd89dba605daf3b829b35ea5c84462911f2139c0b4bf0e8791365292202"}, "url": "/docs/compare/?release=9.0.12#9.0.12-90755d80ecff086a", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-9232ac45578b99fb", "cves": [], "html": "确保 Windows 构建号随时间递增（Magnus Hagander）\n
", "text": "确保 Windows 构建号随时间递增（Magnus Hagander）", "title": "确保 Windows 构建号随时间递增", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "4d4767de9d270208a9b5635f3301ca8ac9769c6a9911655406c6d6ec8d29aded", "section_path": ["变更"], "commit_groups": [], "identity_text": "Ensure Windows build number increases over time (Magnus Hagander)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/041", "db_id": "173fab1f3c4b0a7ef20016598398a204", "patch_ids": [], "statement_hash": "0ca2e5abb4edad748a9aa524fd49f8a90c3fa461ae8270bd9f592b8508de122b", "relations": [{"rule": 2, "type": "equivalent", "target": "2b2e51914cac3e5f3c525689533f8f61", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ca2e5abb4edad748a9aa524fd49f8a90c3fa461ae8270bd9f592b8508de122b"}}, {"rule": 2, "type": "equivalent", "target": "6681c1784c69da9ff076d5c63c8309ac", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ca2e5abb4edad748a9aa524fd49f8a90c3fa461ae8270bd9f592b8508de122b"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "2b2e51914cac3e5f3c525689533f8f61", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "确保 Windows 构建号随时间递增", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ca2e5abb4edad748a9aa524fd49f8a90c3fa461ae8270bd9f592b8508de122b"}, "url": "/docs/compare/?release=9.1.8#9.1.8-9232ac45578b99fb", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "6681c1784c69da9ff076d5c63c8309ac", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "确保 Windows 构建号随时间递增", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ca2e5abb4edad748a9aa524fd49f8a90c3fa461ae8270bd9f592b8508de122b"}, "url": "/docs/compare/?release=9.0.12#9.0.12-9232ac45578b99fb", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}, {"id": "9.2.3-555718a0c24eaac5", "cves": [], "html": " 让 pgxs 在为 Windows 交叉编译时以正确的 .exe 后缀构建可执行文件（Zoltan Boszormenyi）\n
新增时区缩写 FET（Tom Lane）\n
它现在用于一些东欧时区。\n
", "text": "新增时区缩写 FET（Tom Lane） 它现在用于一些东欧时区。", "title": "新增时区缩写 FET", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.3/#id-1.11.6.26.5", "source_hash": "8aef290f6113515dd4315e1910737d8651f3165fb01e42377ac5be1b5c8c0298", "section_path": ["变更"], "commit_groups": [], "identity_text": "Add new timezone abbreviation FET (Tom Lane) This is now used in some eastern-European time zones.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.3/changes/043", "db_id": "d8df38792917705a75a7dd9d051709cb", "patch_ids": [], "statement_hash": "bc4823c1eddd1ec9cb04935f009f536696269e6c70a152290f84faf52cb18c67", "relations": [{"rule": 2, "type": "equivalent", "target": "3e41b446a44f803d89320f2560115d34", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc4823c1eddd1ec9cb04935f009f536696269e6c70a152290f84faf52cb18c67"}}, {"rule": 2, "type": "equivalent", "target": "cdda8dde81204828d84a1c6d648c9ae1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc4823c1eddd1ec9cb04935f009f536696269e6c70a152290f84faf52cb18c67"}}], "version": "9.2.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "3e41b446a44f803d89320f2560115d34", "kind": "equivalent", "version": "9.1.8", "label": "9.1.8", "title": "新增时区缩写 FET", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc4823c1eddd1ec9cb04935f009f536696269e6c70a152290f84faf52cb18c67"}, "url": "/docs/compare/?release=9.1.8#9.1.8-18f2179ffa9f58c6", "source_url": "/docs/release/9.1.8/#id-1.11.6.21.5"}, {"db_id": "cdda8dde81204828d84a1c6d648c9ae1", "kind": "equivalent", "version": "9.0.12", "label": "9.0.12", "title": "新增时区缩写 FET", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc4823c1eddd1ec9cb04935f009f536696269e6c70a152290f84faf52cb18c67"}, "url": "/docs/compare/?release=9.0.12#9.0.12-18f2179ffa9f58c6", "source_url": "/docs/release/9.0.12/#id-1.11.6.16.5"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 43}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 23}, {"key": "security", "label": "安全相关", "count": 1}, {"key": "performance", "label": "性能改进", "count": 1}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 18}], "total": 43, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2013-0255", "url": "https://www.postgresql.org/support/security/CVE-2013-0255/", "fixed": {"8.3": "8.3.23", "8.4": "8.4.16", "9.0": "9.0.12", "9.1": "9.1.8", "9.2": "9.2.3"}, "score": null, "title": "防止从 SQL 执行 enum_recv", "vector": "", "affected": {"8.3": "8.3", "8.4": "8.4", "9.0": "9.0", "9.1": "9.1", "9.2": "9.2"}, "component": "", "published": {}, "introduced": {}, "cvss_version": "", "description_en": "", "first_published": null, "fixed_version": "9.2.3"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 43, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}