对于运行 11.X 的用户，不需要执行导出/恢复。
\n但是，如果使用了 pg_stat_statements 扩展，请参阅下方相关变更日志条目。
对于运行 11.X 的用户，不需要执行导出/恢复。
\n但是，如果使用了 pg_stat_statements 扩展，请参阅下方相关变更日志条目。
确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号（Tom Lane）
无特权用户可以利用这一疏漏，在下一次转储/重载或运行 pg_upgrade 时取得超级用户权限。（CVE-2018-16850）
", "text": "确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号（Tom Lane） 无特权用户可以利用这一疏漏，在下一次转储/重载或运行 pg_upgrade 时取得超级用户权限。（CVE-2018-16850）", "title": "确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "a8e6c79edda6aad39116e1d8853127518ab018ca74eb9f7106dba93f1edbedca", "section_path": ["变更"], "commit_groups": [["06292bb94", "09397f0ed", "350410be4"]], "identity_text": "Ensure proper quoting of transition table names when pg_dump emits CREATE TRIGGER ... REFERENCING commands (Tom Lane) This oversight could be exploited by an unprivileged user to gain superuser privileges during the next dump/reload or pg_upgrade run. (CVE-2018-16850)", "commit_aliases": ["06292bb94", "09397f0ed", "350410be4"], "source_commits": ["06292bb94"], "source_entry_id": "11.1/changes/001", "db_id": "fb62e8b6ce81e5a8bcfcaa5ad5ac32b0", "patch_ids": ["6812f9cdd32d21d8ede5db32f7b091e7"], "statement_hash": "744de87375de2cd9e56d0909359e99f89ecb7ef0ffd00924f25c94ca4f7c7875", "relations": [{"rule": 2, "type": "equivalent", "target": "7dc8bb661661c4652580fc730f54c9d5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "744de87375de2cd9e56d0909359e99f89ecb7ef0ffd00924f25c94ca4f7c7875"}}], "version": "11.1", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "7dc8bb661661c4652580fc730f54c9d5", "kind": "equivalent", "version": "10.6", "label": "10.6", "title": "确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "744de87375de2cd9e56d0909359e99f89ecb7ef0ffd00924f25c94ca4f7c7875"}, "url": "/docs/compare/?release=10.6#10.6-e615412428ea2e36", "source_url": "/docs/release/10.6/#id-1.11.6.22.5"}]}, {"id": "11.1-9302d2df48771312", "cves": [], "html": "创建子索引时，使用为分区索引指定的表空间（Álvaro Herrera）
\n以前，子索引始终创建在默认表空间中。
", "text": "创建子索引时，使用为分区索引指定的表空间（Álvaro Herrera） 以前，子索引始终创建在默认表空间中。", "title": "创建子索引时，使用为分区索引指定的表空间", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "7f8bb0faf83e38fe2c050598853a4cd3ce286e444f9a5592f93b1b5ab5b77017", "section_path": ["变更"], "commit_groups": [["33e6c34c3", "dfa608141"]], "identity_text": "Apply the tablespace specified for a partitioned index when creating a child index (Álvaro Herrera) Previously, child indexes were always created in the default tablespace.", "commit_aliases": ["33e6c34c3", "dfa608141"], "source_commits": ["33e6c34c3"], "source_entry_id": "11.1/changes/002", "db_id": "0029b0c6a87c3f935a4d2fc5cf283603", "patch_ids": ["a1ac3899de20ed4bb712aa6e59466dc1"], "statement_hash": "cb995c893aea249d60471875e66735247aef53ee4e616580bdb6e297b34b493c", "relations": [], "version": "11.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.1-4c767cd3dbf29928", "cves": [], "html": "修复并行哈希多批次左连接中的 NULL 处理（Andrew Gierth，Thomas Munro）
\nhash 键为空值的外侧关系行被遗漏在连接结果之外。
", "text": "修复并行哈希多批次左连接中的 NULL 处理（Andrew Gierth，Thomas Munro） hash 键为空值的外侧关系行被遗漏在连接结果之外。", "title": "修复并行哈希多批次左连接中的 NULL 处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "98f7d8f846f768843aca75bd710cd77521399abe43acb9229603d4df9b2d91ae", "section_path": ["变更"], "commit_groups": [["1ce4a807e", "fd6449aa3"]], "identity_text": "Fix NULL handling in parallel hashed multi-batch left joins (Andrew Gierth, Thomas Munro) Outer-relation rows with null values of the hash key were omitted from the join result.", "commit_aliases": ["1ce4a807e", "fd6449aa3"], "source_commits": ["fd6449aa3"], "source_entry_id": "11.1/changes/003", "db_id": "9ece0ce4e62e33c0f537fae247fbae66", "patch_ids": ["07be5e9787a208458b7aeac6b6be864b"], "statement_hash": "905b9ae9424508de07d350d960c2b117e719059ebb274b3e077c06d61eefcf6b", "relations": [], "version": "11.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.1-00b7c29ea54a5165", "cves": [], "html": "修复对具有常量测试表达式的 CASE 子句内数组类型强制转换表达式的不正确处理（Tom Lane）
修复对缺少最近新增列的元组的不正确展开（Andrew Dunstan，Amit Langote）
\n已知这会使最近添加过列的表上的触发器崩溃，也可能出现其他症状。
", "text": "修复对缺少最近新增列的元组的不正确展开（Andrew Dunstan，Amit Langote） 已知这会使最近添加过列的表上的触发器崩溃，也可能出现其他症状。", "title": "修复对缺少最近新增列的元组的不正确展开", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "8535017e8e58c1fa132e3903cde8371b6f3743c71494c787618588bb130e3a85", "section_path": ["变更"], "commit_groups": [["040a1df61", "372102b81"]], "identity_text": "Fix incorrect expansion of tuples lacking recently-added columns (Andrew Dunstan, Amit Langote) This is known to lead to crashes in triggers on tables with recently-added columns, and could have other symptoms as well.", "commit_aliases": ["040a1df61", "372102b81"], "source_commits": ["372102b81"], "source_entry_id": "11.1/changes/005", "db_id": "ab21d4a56c505f04b6bba974f6b66915", "patch_ids": ["fe355da976b00e734117e1db4a459ba5"], "statement_hash": "ea7e57508299c857254bfa324adc17247df6efee66593d3cbb6e0b7177c90fa7", "relations": [], "version": "11.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.1-547f16f8bea35e1d", "cves": [], "html": "修复 CALL 参数列表中命名参数或默认参数的缺陷（Tom Lane，Pavel Stehule）
修复带有 ORDER BY 列的严格聚合的严格性检查（Andrew Gierth，Andres Freund）
严格性逻辑错误地忽略了 ORDER BY 值为空的行。
禁用 recheck_on_update 优化（Tom Lane）
事实证明，这项 v11 新增特性尚未成熟。在能够解决问题之前将其禁用。
", "text": "禁用 recheck_on_update 优化（Tom Lane） 事实证明，这项 v11 新增特性尚未成熟。在能够解决问题之前将其禁用。", "title": "禁用 recheck_on_update 优化", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "04cd09c1c2e0401e1f57bbd6f99496294eebeddaf11ab27d88ebe491c9aef00c", "section_path": ["变更"], "commit_groups": [["05f84605d", "5d28c9bd7"]], "identity_text": "Disable recheck_on_update optimization (Tom Lane) This new-in-v11 feature turns out not to have been ready for prime time. Disable it until something can be done about it.", "commit_aliases": ["05f84605d", "5d28c9bd7"], "source_commits": ["05f84605d"], "source_entry_id": "11.1/changes/008", "db_id": "4aaf10c186789935809bea2a23d16ede", "patch_ids": ["17099f9d37027704f6902650694b2e77"], "statement_hash": "261563ca826b955ef17f079b66e565c1c99bf871d6414447a623b2c1025e6e7c", "relations": [], "version": "11.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.1-9e0f0799bcf37e84", "cves": [], "html": "禁止在附着于父表的触发器中创建该表的分区（Amit Langote）
\n理想情况下应允许这样做，但目前必须禁止，以避免崩溃。
", "text": "禁止在附着于父表的触发器中创建该表的分区（Amit Langote） 理想情况下应允许这样做，但目前必须禁止，以避免崩溃。", "title": "禁止在附着于父表的触发器中创建该表的分区", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "55caf7d8596b86a3dd8e76579de2f34fe95e2da745d6fdebc6a2a025afd4f757", "section_path": ["变更"], "commit_groups": [["7c222d5e5", "8aad248f7", "dc3e436b1"]], "identity_text": "Prevent creation of a partition in a trigger attached to its parent table (Amit Langote) Ideally we'd allow that, but for the moment it has to be blocked to avoid crashes.", "commit_aliases": ["7c222d5e5", "8aad248f7", "dc3e436b1"], "source_commits": ["7c222d5e5"], "source_entry_id": "11.1/changes/009", "db_id": "74d748c9f055466c74a78a37e8b8366c", "patch_ids": ["c10900fc555267b85f4ba1d038388a13"], "statement_hash": "54e8a13ec9697b1c803065f7a737228066524252526f0464fb58401751046437", "relations": [{"rule": 2, "type": "equivalent", "target": "88247caa9ec6c02189758703d85825bb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "54e8a13ec9697b1c803065f7a737228066524252526f0464fb58401751046437"}}], "version": "11.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "88247caa9ec6c02189758703d85825bb", "kind": "equivalent", "version": "10.6", "label": "10.6", "title": "禁止在附着于父表的触发器中创建该表的分区", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "54e8a13ec9697b1c803065f7a737228066524252526f0464fb58401751046437"}, "url": "/docs/compare/?release=10.6#10.6-9e0f0799bcf37e84", "source_url": "/docs/release/10.6/#id-1.11.6.22.5"}]}, {"id": "11.1-6a392e3810b61cb6", "cves": [], "html": "修复将 ON COMMIT DELETE ROWS 应用于分区临时表时出现的问题（Amit Langote）
修复字符类检查，使其在 Windows 上不会因高于 U+FFFF 的 Unicode 字符而失败（Tom Lane，Kenji Uno）
\n此缺陷影响全文检索操作，以及 contrib/ltree 和 contrib/pg_trgm。
确保服务器在等待客户端输入之前，处理已收到的 NOTIFY 和 SIGTERM 中断（Jeff Janes，Tom Lane）
修复重复扫描 SP-GiST 索引时的内存泄漏（Tom Lane）
\n目前仅已知在使用 SP-GiST 的排除约束于单条命令中接收大量新索引条目时，这种泄漏才会达到显著程度。
", "text": "修复重复扫描 SP-GiST 索引时的内存泄漏（Tom Lane） 目前仅已知在使用 SP-GiST 的排除约束于单条命令中接收大量新索引条目时，这种泄漏才会达到显著程度。", "title": "修复重复扫描 SP-GiST 索引时的内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "d1fc3793d48db1457c2c6af6d9d2166417f73ad427520d5b3e346a06a1c0a797", "section_path": ["变更"], "commit_groups": [["156a737a6", "2493e2c2d", "558571afc", "696b0c5fd", "82dd1c271", "92e371f9b", "95015b1f8"]], "identity_text": "Fix memory leak in repeated SP-GiST index scans (Tom Lane) This is only known to amount to anything significant in cases where an exclusion constraint using SP-GiST receives many new index entries in a single command.", "commit_aliases": ["156a737a6", "2493e2c2d", "558571afc", "696b0c5fd", "82dd1c271", "92e371f9b", "95015b1f8"], "source_commits": ["2493e2c2d"], "source_entry_id": "11.1/changes/013", "db_id": "b55562a2b724286d5206d8ef8095da34", "patch_ids": ["4e12d4f2731df20a5ffa2358c6cd6c2b"], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b", "relations": [{"rule": 2, "type": "equivalent", "target": "461f8794e1c01e2cc3f5c331235d7da1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}}, {"rule": 2, "type": "equivalent", "target": "7d01879c253fb3fe4968c53cd6bb9c5a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}}, {"rule": 2, "type": "equivalent", "target": "97251aceae3237fca5cfc03ab2772ed8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}}, {"rule": 2, "type": "equivalent", "target": "a7f4ceb548ef27e44454af0fb4f0ea7b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}}, {"rule": 2, "type": "equivalent", "target": "d36720e5fa0884f4bf6165c602c3ab83", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}}], "version": "11.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "97251aceae3237fca5cfc03ab2772ed8", "kind": "equivalent", "version": "10.6", "label": "10.6", "title": "修复重复扫描 SP-GiST 索引时的内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}, "url": "/docs/compare/?release=10.6#10.6-68991a6abf9bcfaa", "source_url": "/docs/release/10.6/#id-1.11.6.22.5"}, {"db_id": "d36720e5fa0884f4bf6165c602c3ab83", "kind": "equivalent", "version": "9.6.11", "label": "9.6.11", "title": "修复重复 SP-GiST 索引扫描中的内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}, "url": "/docs/compare/?release=9.6.11#9.6.11-b5fe498b8a00261e", "source_url": "/docs/release/9.6.11/#id-1.11.6.18.5"}, {"db_id": "a7f4ceb548ef27e44454af0fb4f0ea7b", "kind": "equivalent", "version": "9.5.15", "label": "9.5.15", "title": "修复重复 SP-GiST 索引扫描中的内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}, "url": "/docs/compare/?release=9.5.15#9.5.15-b5fe498b8a00261e", "source_url": "/docs/release/9.5.15/#id-1.11.6.15.5"}, {"db_id": "7d01879c253fb3fe4968c53cd6bb9c5a", "kind": "equivalent", "version": "9.4.20", "label": "9.4.20", "title": "修复重复 SP-GiST 索引扫描中的内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}, "url": "/docs/compare/?release=9.4.20#9.4.20-b5fe498b8a00261e", "source_url": "/docs/release/9.4.20/#id-1.11.6.11.5"}, {"db_id": "461f8794e1c01e2cc3f5c331235d7da1", "kind": "equivalent", "version": "9.3.25", "label": "9.3.25", "title": "修复重复 SP-GiST 索引扫描中的内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"}, "url": "/docs/compare/?release=9.3.25#9.3.25-b5fe498b8a00261e", "source_url": "/docs/release/9.3.25/#id-1.11.6.5.6"}]}, {"id": "11.1-fa741401ce2eb557", "cves": [], "html": "如果 wal_level 设置过低，无法支持现有复制槽，则禁止启动服务器（Andres Freund）
修复 psql 以及文档示例，使其在每次调用 PQnotifies() 之前调用 PQconsumeInput()（Tom Lane）
这修复了 psql 直到下一条命令之后才报告收到 NOTIFY 消息的情况。
修复 pg_verify_checksums 对哪些文件应检查校验和的判断（Michael Paquier）
\n在某些情况下，它会对本来就不应有校验和的文件报错。
", "text": "修复 pg_verify_checksums 对哪些文件应检查校验和的判断（Michael Paquier） 在某些情况下，它会对本来就不应有校验和的文件报错。", "title": "修复 pg_verify_checksums 对哪些文件应检查校验和的判断", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "70e44c319e5464535e9d3fd66d73c3167012db4f97adbb201ff675e799dede7f", "section_path": ["变更"], "commit_groups": [["cc7f27eae", "d55241af7"]], "identity_text": "Fix pg_verify_checksums's determination of which files to check the checksums of (Michael Paquier) In some cases it complained about files that are not expected to have checksums.", "commit_aliases": ["cc7f27eae", "d55241af7"], "source_commits": ["cc7f27eae"], "source_entry_id": "11.1/changes/016", "db_id": "5aeec4b74df69e093bfd38417fefd229", "patch_ids": ["a720e5bb26eb76befaf85169faf519cc"], "statement_hash": "040700079db71fadc59f85386a5609b722fe0481005974f60c39d74ef0030554", "relations": [], "version": "11.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.1-9b869fcce22ba013", "cves": [], "html": "在 contrib/pg_stat_statements 中，禁止 pg_read_all_stats 角色执行 pg_stat_statements_reset()（Haribabu Kommi）
pg_read_all_stats 只应授予读取统计信息的权限，而非更改统计信息的权限，因此此前的授权不正确。
要使此项修改生效，请在每个已安装 pg_stat_statements 的数据库中运行 ALTER EXTENSION pg_stat_statements UPDATE。（在 11.0 中新建的数据库应该不需要这样做，但从旧发行版升级的数据库可能仍包含旧版 pg_stat_statements。如果模块已更新，执行 UPDATE 命令也不会有害。）
重命名红黑树支持函数，使用 rbt 前缀代替 rb 前缀（Tom Lane）
这避免了与 Ruby 函数发生名称冲突，后者曾使 PL/Ruby 失效。希望没有其他扩展受到影响。
", "text": "重命名红黑树支持函数，使用 rbt 前缀代替 rb 前缀（Tom Lane） 这避免了与 Ruby 函数发生名称冲突，后者曾使 PL/Ruby 失效。希望没有其他扩展受到影响。", "title": "重命名红黑树支持函数，使用 rbt 前缀代替 rb 前缀", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "d6c7846df637b7949cf1a66be8cecc8acc8ed6fab672e472ed57d2d70b076a5c", "section_path": ["变更"], "commit_groups": [["003c68a3b", "1f28ec6be", "b2e754c14"]], "identity_text": "Rename red-black tree support functions to use rbt prefix not rb prefix (Tom Lane) This avoids name collisions with Ruby functions, which broke PL/Ruby. It's hoped that there are no other affected extensions.", "commit_aliases": ["003c68a3b", "1f28ec6be", "b2e754c14"], "source_commits": ["1f28ec6be"], "source_entry_id": "11.1/changes/018", "db_id": "b2b63130886329bb7fbe86266a95c046", "patch_ids": ["e76a2575f95720cece0ca6df9770e734"], "statement_hash": "8bd50ae860c4fd5ec18f566869c831d96053832f2f80fc1723d19b716d2628a9", "relations": [{"rule": 2, "type": "equivalent", "target": "df459454eaa00e82ec9d18ae69918099", "evidence": {"same_day": false, "patch_ids": ["e76a2575f95720cece0ca6df9770e734"], "statement_hash": "8bd50ae860c4fd5ec18f566869c831d96053832f2f80fc1723d19b716d2628a9"}}], "version": "11.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "df459454eaa00e82ec9d18ae69918099", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "重命名红黑树支持函数，使用 rbt 前缀代替 rb 前缀", "evidence": {"same_day": false, "patch_ids": ["e76a2575f95720cece0ca6df9770e734"], "statement_hash": "8bd50ae860c4fd5ec18f566869c831d96053832f2f80fc1723d19b716d2628a9"}, "url": "/docs/compare/?release=10.7#10.7-2ff83efd3ef7f9a6", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}]}, {"id": "11.1-9a46ff8655386392", "cves": [], "html": "修复 macOS 10.14（Mojave）上的构建问题（Tom Lane）
\n调整 configure，向 CPPFLAGS 添加 -isysroot 开关；否则，PL/Perl 和 PL/Tcl 在 macOS 10.14 上无法配置或构建。可以在 configure 或 make 的参数中设置 PG_SYSROOT 变量，在配置时或构建时覆盖所用的具体 sysroot。
现在建议 Perl 相关扩展在编译器标志中写入 $(perl_includespec)，而非 -I$(perl_archlibexp)/CORE。后者在大多数平台上仍然有效，但在近期 macOS 上无效。
此外，在近期 macOS 版本上构建 PL/Tcl 时，应不再需要手动指定 --with-tclconfig。
修复 MSVC 构建和回归测试脚本，使其适用于近期 Perl 版本（Andrew Dunstan）
\nPerl 默认已不再将当前目录包含在搜索路径中，现在对此进行适配。
", "text": "修复 MSVC 构建和回归测试脚本，使其适用于近期 Perl 版本（Andrew Dunstan） Perl 默认已不再将当前目录包含在搜索路径中，现在对此进行适配。", "title": "修复 MSVC 构建和回归测试脚本，使其适用于近期 Perl 版本", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "a65f69c2d7cb1a86b7a65470a90470a779d2e8a92d33bcc28c78316d0ac5f876", "section_path": ["变更"], "commit_groups": [["075641fd0", "1df92eeaf", "698255147", "8cb5e67d1", "9fd6d4eae", "a71f55652", "ba103dc87"]], "identity_text": "Fix MSVC build and regression-test scripts to work on recent Perl versions (Andrew Dunstan) Perl no longer includes the current directory in its search path by default; work around that.", "commit_aliases": ["075641fd0", "1df92eeaf", "698255147", "8cb5e67d1", "9fd6d4eae", "a71f55652", "ba103dc87"], "source_commits": ["8cb5e67d1"], "source_entry_id": "11.1/changes/020", "db_id": "38726384cd10e441aa4dcced098d61b8", "patch_ids": ["002abb29792b3d916e28a5d4beed8527"], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8", "relations": [{"rule": 2, "type": "equivalent", "target": "330db97de242d00c963b07fc3c46b0e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}}, {"rule": 2, "type": "equivalent", "target": "7c21077c9eb4a826e9bed8b137d5f770", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}}, {"rule": 2, "type": "equivalent", "target": "8a1cc7acdfb09c199a9f3ca1cd405980", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}}, {"rule": 2, "type": "equivalent", "target": "c05a64c813d21edd23ba0418b3a7b77e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}}, {"rule": 2, "type": "equivalent", "target": "e3ec0a53c68d18896cdc4e43a13db606", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}}], "version": "11.1", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "7c21077c9eb4a826e9bed8b137d5f770", "kind": "equivalent", "version": "10.6", "label": "10.6", "title": "修复 MSVC 构建和回归测试脚本，使其适用于近期 Perl 版本", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}, "url": "/docs/compare/?release=10.6#10.6-4ce896e4612f55d4", "source_url": "/docs/release/10.6/#id-1.11.6.22.5"}, {"db_id": "330db97de242d00c963b07fc3c46b0e2", "kind": "equivalent", "version": "9.6.11", "label": "9.6.11", "title": "修复 MSVC 构建和回归测试脚本在最近的 Perl 版本上工作", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}, "url": "/docs/compare/?release=9.6.11#9.6.11-f991ee36ce29595f", "source_url": "/docs/release/9.6.11/#id-1.11.6.18.5"}, {"db_id": "c05a64c813d21edd23ba0418b3a7b77e", "kind": "equivalent", "version": "9.5.15", "label": "9.5.15", "title": "修复 MSVC 构建和回归测试脚本在最近的 Perl 版本上工作", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}, "url": "/docs/compare/?release=9.5.15#9.5.15-f991ee36ce29595f", "source_url": "/docs/release/9.5.15/#id-1.11.6.15.5"}, {"db_id": "e3ec0a53c68d18896cdc4e43a13db606", "kind": "equivalent", "version": "9.4.20", "label": "9.4.20", "title": "修复 MSVC 构建和回归测试脚本在最近的 Perl 版本上工作", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}, "url": "/docs/compare/?release=9.4.20#9.4.20-f991ee36ce29595f", "source_url": "/docs/release/9.4.20/#id-1.11.6.11.5"}, {"db_id": "8a1cc7acdfb09c199a9f3ca1cd405980", "kind": "equivalent", "version": "9.3.25", "label": "9.3.25", "title": "修复 MSVC 构建和回归测试脚本在最近的 Perl 版本上工作", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"}, "url": "/docs/compare/?release=9.3.25#9.3.25-f991ee36ce29595f", "source_url": "/docs/release/9.3.25/#id-1.11.6.5.6"}]}, {"id": "11.1-4d189096157461b0", "cves": [], "html": "在 Windows 上，允许使用 Administrator 账户运行回归测试（Andrew Dunstan）
\n为安全地做到这一点，pg_regress 现在会在启动时放弃所有此类特权。
", "text": "在 Windows 上，允许使用 Administrator 账户运行回归测试（Andrew Dunstan） 为安全地做到这一点，pg_regress 现在会在启动时放弃所有此类特权。", "title": "在 Windows 上，允许使用 Administrator 账户运行回归测试", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "b698918e46331376c55409cb177531c2958b35ac04e82d4d5c938960fe18ecc0", "section_path": ["变更"], "commit_groups": [["42a93da25", "a0a8671a6", "cc02db82c", "ce5d3424d", "f4b67efdc"]], "identity_text": "On Windows, allow the regression tests to be run by an Administrator account (Andrew Dunstan) To do this safely, pg_regress now gives up any such privileges at startup.", "commit_aliases": ["42a93da25", "a0a8671a6", "cc02db82c", "ce5d3424d", "f4b67efdc"], "source_commits": ["a0a8671a6"], "source_entry_id": "11.1/changes/021", "db_id": "48c2735b63080aaa3f2db59e70d658d4", "patch_ids": ["aa80bc7e4ecc9872d535699f901d69b9"], "statement_hash": "518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a", "relations": [{"rule": 2, "type": "equivalent", "target": "1d8ee57c6e885f7810b31fad3ae8af64", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"}}, {"rule": 2, "type": "equivalent", "target": "9d7ea114afa8473a02bf20907f9f413b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"}}, {"rule": 2, "type": "equivalent", "target": "e930c125b40f9ac76f19bef307f9d7df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"}}], "version": "11.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1d8ee57c6e885f7810b31fad3ae8af64", "kind": "equivalent", "version": "10.6", "label": "10.6", "title": "在 Windows 上，允许使用 Administrator 账户运行回归测试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"}, "url": "/docs/compare/?release=10.6#10.6-4d189096157461b0", "source_url": "/docs/release/10.6/#id-1.11.6.22.5"}, {"db_id": "9d7ea114afa8473a02bf20907f9f413b", "kind": "equivalent", "version": "9.6.11", "label": "9.6.11", "title": "在 Windows 上，允许由管理员账户运行回归测试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"}, "url": "/docs/compare/?release=9.6.11#9.6.11-44146fcc9439c230", "source_url": "/docs/release/9.6.11/#id-1.11.6.18.5"}, {"db_id": "e930c125b40f9ac76f19bef307f9d7df", "kind": "equivalent", "version": "9.5.15", "label": "9.5.15", "title": "在 Windows 上，允许由管理员账户运行回归测试", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"}, "url": "/docs/compare/?release=9.5.15#9.5.15-44146fcc9439c230", "source_url": "/docs/release/9.5.15/#id-1.11.6.15.5"}]}, {"id": "11.1-a976c1cc861f3265", "cves": [], "html": "将时区数据文件更新到 tzdata 2018g 版，以反映智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，并修正中国、夏威夷、日本、澳门和朝鲜的历史数据。
", "text": "将时区数据文件更新到 tzdata 2018g 版，以反映智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，并修正中国、夏威夷、日本、澳门和朝鲜的历史数据。", "title": "将时区数据文件更新到 tzdata 2018g 版，以反映智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，并修正中国、夏威夷、日本、澳门和朝鲜的历史数据。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.1/#id-1.11.6.26.5", "source_hash": "a701cb9bf13b6e8d75a5d3a21559abd8caf2427492f0732172cf2656bf25053e", "section_path": ["变更"], "commit_groups": [["13877d30f", "185f135c9", "56170609b", "5777c93af", "84261eb10", "9abbfc35c", "d2259c26b"], ["3bf4edace", "58c45fdaa", "5c2e0ca5f", "671f43d88", "811d8cb87", "bb761c6a0", "d651e9e7c"]], "identity_text": "Update time zone data files to tzdata release 2018g for DST law changes in Chile, Fiji, Morocco, and Russia (Volgograd), plus historical corrections for China, Hawaii, Japan, Macau, and North Korea.", "commit_aliases": ["13877d30f", "185f135c9", "3bf4edace", "56170609b", "5777c93af", "58c45fdaa", "5c2e0ca5f", "671f43d88", "811d8cb87", "84261eb10", "9abbfc35c", "bb761c6a0", "d2259c26b", "d651e9e7c"], "source_commits": ["58c45fdaa", "d2259c26b"], "source_entry_id": "11.1/changes/022", "db_id": "ec1af20fff76afd67ff7d1ea4783a255", "patch_ids": ["04598c44cf2a75a488bf50cae6ef6847", "1a1428f61eafbf8549db9a42c6d8a26d"], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f", "relations": [{"rule": 2, "type": "equivalent", "target": "3a47d92908a2a93e22bf9701d1a2d0fb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}}, {"rule": 2, "type": "equivalent", "target": "46b29725b96825b29e06a3f184f945fc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}}, {"rule": 2, "type": "equivalent", "target": "75ae186c775b3d34ee7e5623ad582135", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}}, {"rule": 2, "type": "equivalent", "target": "a9dda89f62e87a28c9cc3df0363e971d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}}, {"rule": 2, "type": "equivalent", "target": "bd23f638637439f7790fcb58590eeb8e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}}], "version": "11.1", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "a9dda89f62e87a28c9cc3df0363e971d", "kind": "equivalent", "version": "10.6", "label": "10.6", "title": "将时区数据文件更新到 tzdata 2018g 版，以反映智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，并修正中国、夏威夷、日本、澳门和朝鲜的历史数据。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}, "url": "/docs/compare/?release=10.6#10.6-a976c1cc861f3265", "source_url": "/docs/release/10.6/#id-1.11.6.22.5"}, {"db_id": "bd23f638637439f7790fcb58590eeb8e", "kind": "equivalent", "version": "9.6.11", "label": "9.6.11", "title": "更新时区数据文件到 tzdata 版本 2018g，涉及智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，以及中国、夏威夷、日本、澳门和朝鲜的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}, "url": "/docs/compare/?release=9.6.11#9.6.11-4239e7a753d90202", "source_url": "/docs/release/9.6.11/#id-1.11.6.18.5"}, {"db_id": "3a47d92908a2a93e22bf9701d1a2d0fb", "kind": "equivalent", "version": "9.5.15", "label": "9.5.15", "title": "更新时区数据文件到 tzdata 版本 2018g，涉及智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，以及中国、夏威夷、日本、澳门和朝鲜的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}, "url": "/docs/compare/?release=9.5.15#9.5.15-4239e7a753d90202", "source_url": "/docs/release/9.5.15/#id-1.11.6.15.5"}, {"db_id": "46b29725b96825b29e06a3f184f945fc", "kind": "equivalent", "version": "9.4.20", "label": "9.4.20", "title": "更新时区数据文件到 tzdata 版本 2018g，涉及智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，以及中国、夏威夷、日本、澳门和朝鲜的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}, "url": "/docs/compare/?release=9.4.20#9.4.20-4239e7a753d90202", "source_url": "/docs/release/9.4.20/#id-1.11.6.11.5"}, {"db_id": "75ae186c775b3d34ee7e5623ad582135", "kind": "equivalent", "version": "9.3.25", "label": "9.3.25", "title": "更新时区数据文件到 tzdata 版本 2018g，涉及智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，以及中国、夏威夷、日本、澳门和朝鲜的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"}, "url": "/docs/compare/?release=9.3.25#9.3.25-4239e7a753d90202", "source_url": "/docs/release/9.3.25/#id-1.11.6.5.6"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 22}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 12}, {"key": "security", "label": "安全相关", "count": 1}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 9}], "total": 22, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2018-16850", "url": "https://www.postgresql.org/support/security/CVE-2018-16850/", "fixed": {"10": "10.6", "11": "11.1"}, "score": 8.8, "title": "确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"10": "10", "11": "11"}, "component": "core server", "published": {"10": "2018-11-08", "11": "2018-11-08"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2018-11-08", "fixed_version": "11.1"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 22, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}