{"already_in_source_count":0,"candidate_count":22,"cross_major":false,"cve_available":true,"cve_count":1,"cves":[{"affected":{"10":"10","11":"11"},"component":"core server","cvss_version":"3.0","description_en":"","first_published":"2018-11-08","fixed":{"10":"10.6","11":"11.1"},"fixed_version":"11.1","id":"CVE-2018-16850","introduced":{},"published":{"10":"2018-11-08","11":"2018-11-08"},"score":8.8,"title":"确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号","url":"https://www.postgresql.org/support/security/CVE-2018-16850/","vector":"AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H"}],"duplicate_count":0,"excluded_count":0,"exclusions":[],"from_release":null,"groups":[{"age_days":2895,"build":"11.1","changes_count":22,"compatibility_count":0,"content_hash":"404582f8ef651a0894857775e8417983597a21cc5a09c3a92cac237c9ca55e8e","date":"2018-11-08","date_text":"2018-11-08","doc_git":"","doc_loaded_at":"2026-09-26T02:56:42.383207","entries":[{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["06292bb94","09397f0ed","350410be4"],"commit_groups":[["06292bb94","09397f0ed","350410be4"]],"commits":[],"cves":["CVE-2018-16850"],"db_id":"fb62e8b6ce81e5a8bcfcaa5ad5ac32b0","html":"\u003cp\u003e确保 \u003cspan\u003epg_dump\u003c/span\u003e 输出 \u003ccode\u003eCREATE TRIGGER ... REFERENCING\u003c/code\u003e 命令时，正确处理过渡表名称的引号（Tom Lane）\u003c/p\u003e\n\u003cp\u003e无特权用户可以利用这一疏漏，在下一次转储/重载或运行 \u003cspan\u003epg_upgrade\u003c/span\u003e 时取得超级用户权限。（CVE-2018-16850）\u003c/p\u003e","id":"11.1-e615412428ea2e36","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)","part":"changes","patch_ids":["6812f9cdd32d21d8ede5db32f7b091e7"],"related_changes":[{"db_id":"7dc8bb661661c4652580fc730f54c9d5","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"744de87375de2cd9e56d0909359e99f89ecb7ef0ffd00924f25c94ca4f7c7875"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号","url":"/docs/compare/?release=10.6#10.6-e615412428ea2e36","version":"10.6"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"744de87375de2cd9e56d0909359e99f89ecb7ef0ffd00924f25c94ca4f7c7875"},"rule":2,"target":"7dc8bb661661c4652580fc730f54c9d5","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["06292bb94"],"source_entry_id":"11.1/changes/001","source_hash":"a8e6c79edda6aad39116e1d8853127518ab018ca74eb9f7106dba93f1edbedca","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"744de87375de2cd9e56d0909359e99f89ecb7ef0ffd00924f25c94ca4f7c7875","text":"确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号（Tom Lane） 无特权用户可以利用这一疏漏，在下一次转储/重载或运行 pg_upgrade 时取得超级用户权限。（CVE-2018-16850）","title":"确保 pg_dump 输出 CREATE TRIGGER ... REFERENCING 命令时，正确处理过渡表名称的引号","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["33e6c34c3","dfa608141"],"commit_groups":[["33e6c34c3","dfa608141"]],"commits":[],"cves":[],"db_id":"0029b0c6a87c3f935a4d2fc5cf283603","html":"\u003cp\u003e创建子索引时，使用为分区索引指定的表空间（Álvaro Herrera）\u003c/p\u003e\n\u003cp\u003e以前，子索引始终创建在默认表空间中。\u003c/p\u003e","id":"11.1-9302d2df48771312","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.","part":"changes","patch_ids":["a1ac3899de20ed4bb712aa6e59466dc1"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["33e6c34c3"],"source_entry_id":"11.1/changes/002","source_hash":"7f8bb0faf83e38fe2c050598853a4cd3ce286e444f9a5592f93b1b5ab5b77017","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"cb995c893aea249d60471875e66735247aef53ee4e616580bdb6e297b34b493c","text":"创建子索引时，使用为分区索引指定的表空间（Álvaro Herrera） 以前，子索引始终创建在默认表空间中。","title":"创建子索引时，使用为分区索引指定的表空间","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["1ce4a807e","fd6449aa3"],"commit_groups":[["1ce4a807e","fd6449aa3"]],"commits":[],"cves":[],"db_id":"9ece0ce4e62e33c0f537fae247fbae66","html":"\u003cp\u003e修复并行哈希多批次左连接中的 NULL 处理（Andrew Gierth，Thomas Munro）\u003c/p\u003e\n\u003cp\u003ehash 键为空值的外侧关系行被遗漏在连接结果之外。\u003c/p\u003e","id":"11.1-4c767cd3dbf29928","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.","part":"changes","patch_ids":["07be5e9787a208458b7aeac6b6be864b"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["fd6449aa3"],"source_entry_id":"11.1/changes/003","source_hash":"98f7d8f846f768843aca75bd710cd77521399abe43acb9229603d4df9b2d91ae","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"905b9ae9424508de07d350d960c2b117e719059ebb274b3e077c06d61eefcf6b","text":"修复并行哈希多批次左连接中的 NULL 处理（Andrew Gierth，Thomas Munro） hash 键为空值的外侧关系行被遗漏在连接结果之外。","title":"修复并行哈希多批次左连接中的 NULL 处理","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["14a158f9b","2bd6dcdef"],"commit_groups":[["14a158f9b","2bd6dcdef"]],"commits":[],"cves":[],"db_id":"7b47318bfe18a3cd19eb0292002029a1","html":"\u003cp\u003e修复对具有常量测试表达式的 \u003ccode\u003eCASE\u003c/code\u003e 子句内数组类型强制转换表达式的不正确处理（Tom Lane）\u003c/p\u003e","id":"11.1-00b7c29ea54a5165","identity_text":"Fix incorrect processing of an array-type coercion expression appearing within a CASE clause that has a constant test expression (Tom Lane)","part":"changes","patch_ids":["9dab6bf238aef7c72251ce76d2c79d2e"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["2bd6dcdef"],"source_entry_id":"11.1/changes/004","source_hash":"656ee9dcae7d6036c3338fc3e31de7cb76d707de8b41f94319f947b267d16b05","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"9a74afe7eceee95500e4e715fbd72e50d68dfd1541b0ae76a6fd5d462cf9b7ea","text":"修复对具有常量测试表达式的 CASE 子句内数组类型强制转换表达式的不正确处理（Tom Lane）","title":"修复对具有常量测试表达式的 CASE 子句内数组类型强制转换表达式的不正确处理","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["040a1df61","372102b81"],"commit_groups":[["040a1df61","372102b81"]],"commits":[],"cves":[],"db_id":"ab21d4a56c505f04b6bba974f6b66915","html":"\u003cp\u003e修复对缺少最近新增列的元组的不正确展开（Andrew Dunstan，Amit Langote）\u003c/p\u003e\n\u003cp\u003e已知这会使最近添加过列的表上的触发器崩溃，也可能出现其他症状。\u003c/p\u003e","id":"11.1-9db22a6d03464b81","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.","part":"changes","patch_ids":["fe355da976b00e734117e1db4a459ba5"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["372102b81"],"source_entry_id":"11.1/changes/005","source_hash":"8535017e8e58c1fa132e3903cde8371b6f3743c71494c787618588bb130e3a85","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"ea7e57508299c857254bfa324adc17247df6efee66593d3cbb6e0b7177c90fa7","text":"修复对缺少最近新增列的元组的不正确展开（Andrew Dunstan，Amit Langote） 已知这会使最近添加过列的表上的触发器崩溃，也可能出现其他症状。","title":"修复对缺少最近新增列的元组的不正确展开","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["15c729347","4b0c3712c","9b6fb9fbb","d358da814"],"commit_groups":[["15c729347","4b0c3712c"],["9b6fb9fbb","d358da814"]],"commits":[],"cves":[],"db_id":"eb8bb1b7e75374aee6098be757cd407f","html":"\u003cp\u003e修复 \u003ccode\u003eCALL\u003c/code\u003e 参数列表中命名参数或默认参数的缺陷（Tom Lane，Pavel Stehule）\u003c/p\u003e","id":"11.1-547f16f8bea35e1d","identity_text":"Fix bugs with named or defaulted arguments in CALL argument lists (Tom Lane, Pavel Stehule)","part":"changes","patch_ids":["3d8d149722688270ffdb74462b5eff60","81cbe3c0c0fd707d459eb2f34c1e5939"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["4b0c3712c","d358da814"],"source_entry_id":"11.1/changes/006","source_hash":"680afd3ee83d9efda14c4e922ab096818f1f13d1e4f179d3bb5608fd6ce91916","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"a497521f491b63168fd855014fb6153def1a830cac7d032120f08adbd3154213","text":"修复 CALL 参数列表中命名参数或默认参数的缺陷（Tom Lane，Pavel Stehule）","title":"修复 CALL 参数列表中命名参数或默认参数的缺陷","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["4c640f4f3","6eb31cedb","793beab37","fd59b29c8"],"commit_groups":[["4c640f4f3","fd59b29c8"],["6eb31cedb","793beab37"]],"commits":[],"cves":[],"db_id":"91a68c590a257783bc15485bbe2af329","html":"\u003cp\u003e修复带有 \u003ccode\u003eORDER BY\u003c/code\u003e 列的严格聚合的严格性检查（Andrew Gierth，Andres Freund）\u003c/p\u003e\n\u003cp\u003e严格性逻辑错误地忽略了 \u003ccode\u003eORDER BY\u003c/code\u003e 值为空的行。\u003c/p\u003e","id":"11.1-08a14d5f6127c006","identity_text":"Fix strictness check for strict aggregates with ORDER BY columns (Andrew Gierth, Andres Freund) The strictness logic incorrectly ignored rows for which the ORDER BY value(s) were null.","part":"changes","patch_ids":["9c2a08ffd43d97a6fd128d397b72a7bc","ba56aa2a461f294a87ee3effce53f654"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["6eb31cedb","fd59b29c8"],"source_entry_id":"11.1/changes/007","source_hash":"a0ff73e355311d04f7885c99d1101fab796571fc4b2fe5d3ecb9d5b9881038eb","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"33eb9ba5cdca6312fe8491985e54f2c8a40b52e7f56f36a59ee4d65f7aaaae0b","text":"修复带有 ORDER BY 列的严格聚合的严格性检查（Andrew Gierth，Andres Freund） 严格性逻辑错误地忽略了 ORDER BY 值为空的行。","title":"修复带有 ORDER BY 列的严格聚合的严格性检查","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["05f84605d","5d28c9bd7"],"commit_groups":[["05f84605d","5d28c9bd7"]],"commits":[],"cves":[],"db_id":"4aaf10c186789935809bea2a23d16ede","html":"\u003cp\u003e禁用 \u003ccode\u003erecheck_on_update\u003c/code\u003e 优化（Tom Lane）\u003c/p\u003e\n\u003cp\u003e事实证明，这项 v11 新增特性尚未成熟。在能够解决问题之前将其禁用。\u003c/p\u003e","id":"11.1-4a366a1e6ad8eaa0","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.","part":"changes","patch_ids":["17099f9d37027704f6902650694b2e77"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["05f84605d"],"source_entry_id":"11.1/changes/008","source_hash":"04cd09c1c2e0401e1f57bbd6f99496294eebeddaf11ab27d88ebe491c9aef00c","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"261563ca826b955ef17f079b66e565c1c99bf871d6414447a623b2c1025e6e7c","text":"禁用 recheck_on_update 优化（Tom Lane） 事实证明，这项 v11 新增特性尚未成熟。在能够解决问题之前将其禁用。","title":"禁用 recheck_on_update 优化","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["7c222d5e5","8aad248f7","dc3e436b1"],"commit_groups":[["7c222d5e5","8aad248f7","dc3e436b1"]],"commits":[],"cves":[],"db_id":"74d748c9f055466c74a78a37e8b8366c","html":"\u003cp\u003e禁止在附着于父表的触发器中创建该表的分区（Amit Langote）\u003c/p\u003e\n\u003cp\u003e理想情况下应允许这样做，但目前必须禁止，以避免崩溃。\u003c/p\u003e","id":"11.1-9e0f0799bcf37e84","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.","part":"changes","patch_ids":["c10900fc555267b85f4ba1d038388a13"],"related_changes":[{"db_id":"88247caa9ec6c02189758703d85825bb","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"54e8a13ec9697b1c803065f7a737228066524252526f0464fb58401751046437"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"禁止在附着于父表的触发器中创建该表的分区","url":"/docs/compare/?release=10.6#10.6-9e0f0799bcf37e84","version":"10.6"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"54e8a13ec9697b1c803065f7a737228066524252526f0464fb58401751046437"},"rule":2,"target":"88247caa9ec6c02189758703d85825bb","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["7c222d5e5"],"source_entry_id":"11.1/changes/009","source_hash":"55caf7d8596b86a3dd8e76579de2f34fe95e2da745d6fdebc6a2a025afd4f757","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"54e8a13ec9697b1c803065f7a737228066524252526f0464fb58401751046437","text":"禁止在附着于父表的触发器中创建该表的分区（Amit Langote） 理想情况下应允许这样做，但目前必须禁止，以避免崩溃。","title":"禁止在附着于父表的触发器中创建该表的分区","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["4bc772e2a","70c38e708","948af5232"],"commit_groups":[["4bc772e2a","70c38e708","948af5232"]],"commits":[],"cves":[],"db_id":"f104b877b793bcf60c7c1d452b10cd2b","html":"\u003cp\u003e修复将 \u003ccode\u003eON COMMIT DELETE ROWS\u003c/code\u003e 应用于分区临时表时出现的问题（Amit Langote）\u003c/p\u003e","id":"11.1-6a392e3810b61cb6","identity_text":"Fix problems with applying ON COMMIT DELETE ROWS to a partitioned temporary table (Amit Langote)","part":"changes","patch_ids":["52010a8a9524ba59656c910e30adbfd6"],"related_changes":[{"db_id":"42d3bb2d44127732112144519ca75450","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a83333bc181a07682110ecd2cc8f64a25694da271d654a8d09499fd0e1c08d14"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"修复将 ON COMMIT DELETE ROWS 应用于分区临时表时出现的问题","url":"/docs/compare/?release=10.6#10.6-6a392e3810b61cb6","version":"10.6"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a83333bc181a07682110ecd2cc8f64a25694da271d654a8d09499fd0e1c08d14"},"rule":2,"target":"42d3bb2d44127732112144519ca75450","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["948af5232"],"source_entry_id":"11.1/changes/010","source_hash":"64cfe6acb6c85ffb7a2352c1fc5d0810a954aad805d91608e8cdc55d656b9539","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"a83333bc181a07682110ecd2cc8f64a25694da271d654a8d09499fd0e1c08d14","text":"修复将 ON COMMIT DELETE ROWS 应用于分区临时表时出现的问题（Amit Langote）","title":"修复将 ON COMMIT DELETE ROWS 应用于分区临时表时出现的问题","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0ae902e39","33c697e9d","6e6092989","73dbaed93","981dc2baa","bf4a9562e","f7ba6e951"],"commit_groups":[["0ae902e39","33c697e9d","6e6092989","73dbaed93","981dc2baa","bf4a9562e","f7ba6e951"]],"commits":[],"cves":[],"db_id":"07ac0e68d39e5eb1d01772c622ef886b","html":"\u003cp\u003e修复字符类检查，使其在 Windows 上不会因高于 U+FFFF 的 Unicode 字符而失败（Tom Lane，Kenji Uno）\u003c/p\u003e\n\u003cp\u003e此缺陷影响全文检索操作，以及 \u003ccode\u003econtrib/ltree\u003c/code\u003e 和 \u003ccode\u003econtrib/pg_trgm\u003c/code\u003e。\u003c/p\u003e","id":"11.1-b0b9b655780b1845","identity_text":"Fix character-class checks to not fail on Windows for Unicode characters above U+FFFF (Tom Lane, Kenji Uno) This bug affected full-text-search operations, as well as contrib/ltree and contrib/pg_trgm.","part":"changes","patch_ids":["e3477e0e03ab0c24dbaa0237aff72b74"],"related_changes":[{"db_id":"3b1425c29091cb957c19ef962eedcc91","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"修复字符类检查，使其在 Windows 上不会因高于 U+FFFF 的 Unicode 字符而失败","url":"/docs/compare/?release=10.6#10.6-b0b9b655780b1845","version":"10.6"},{"db_id":"4c4389058c6ec15d24710974ee433b72","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"修复字符类检查在 Windows 上对 U+FFFF 以上的 Unicode 字符不再失败","url":"/docs/compare/?release=9.6.11#9.6.11-ded82ea69402a5be","version":"9.6.11"},{"db_id":"71a0050bfe91eb9a80a48cf58fa38867","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"修复字符类检查在 Windows 上对 U+FFFF 以上的 Unicode 字符不再失败","url":"/docs/compare/?release=9.5.15#9.5.15-ded82ea69402a5be","version":"9.5.15"},{"db_id":"e8bab94529b5c87f952ec89057ca34bc","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"kind":"equivalent","label":"9.4.20","source_url":"/docs/release/9.4.20/#id-1.11.6.11.5","title":"修复字符类检查在 Windows 上对 U+FFFF 以上的 Unicode 字符不再失败","url":"/docs/compare/?release=9.4.20#9.4.20-ded82ea69402a5be","version":"9.4.20"},{"db_id":"ac497120f0805b17c85a3c027b169e05","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"kind":"equivalent","label":"9.3.25","source_url":"/docs/release/9.3.25/#id-1.11.6.5.6","title":"修复字符类检查在 Windows 上对 U+FFFF 以上的 Unicode 字符不再失败","url":"/docs/compare/?release=9.3.25#9.3.25-ded82ea69402a5be","version":"9.3.25"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"rule":2,"target":"3b1425c29091cb957c19ef962eedcc91","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"rule":2,"target":"4c4389058c6ec15d24710974ee433b72","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"rule":2,"target":"71a0050bfe91eb9a80a48cf58fa38867","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"rule":2,"target":"ac497120f0805b17c85a3c027b169e05","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f"},"rule":2,"target":"e8bab94529b5c87f952ec89057ca34bc","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["bf4a9562e"],"source_entry_id":"11.1/changes/011","source_hash":"f590923a146b8d3afe43f41f2f3edaca87db605b1542416630da15f540c25638","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"8fe30e8a00498505d1af1c06936dccd32cb92a9c671731c5004c471060848b8f","text":"修复字符类检查，使其在 Windows 上不会因高于 U+FFFF 的 Unicode 字符而失败（Tom Lane，Kenji Uno） 此缺陷影响全文检索操作，以及 contrib/ltree 和 contrib/pg_trgm。","title":"修复字符类检查，使其在 Windows 上不会因高于 U+FFFF 的 Unicode 字符而失败","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["2ddb9149d","3bdef6d21","7aaeb7b45","cbab94077","f4941666a"],"commit_groups":[["2ddb9149d","3bdef6d21","7aaeb7b45","cbab94077","f4941666a"]],"commits":[],"cves":[],"db_id":"a8267ccfb469efa114b4079b06d82dc2","html":"\u003cp\u003e确保服务器在等待客户端输入之前，处理已收到的 \u003ccode\u003eNOTIFY\u003c/code\u003e 和 \u003ccode\u003eSIGTERM\u003c/code\u003e 中断（Jeff Janes，Tom Lane）\u003c/p\u003e","id":"11.1-77265fd972ce43af","identity_text":"Ensure that the server will process already-received NOTIFY and SIGTERM interrupts before waiting for client input (Jeff Janes, Tom Lane)","part":"changes","patch_ids":["464871eb19617b94661d7eac977217f9"],"related_changes":[{"db_id":"a9e36a6f80e9e4054f9930438ca27b26","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6aaab866c8e48e0146e6af6a7dcd983762e678249084770092512aee8e0b8c"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"确保服务器在等待客户端输入之前，处理已收到的 NOTIFY 和 SIGTERM 中断","url":"/docs/compare/?release=10.6#10.6-77265fd972ce43af","version":"10.6"},{"db_id":"58a0a41b7dede37cef3fb1c940a2aff6","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6aaab866c8e48e0146e6af6a7dcd983762e678249084770092512aee8e0b8c"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"确保服务器在等待客户端输入之前处理已收到的 NOTIFY 和 SIGTERM 中断","url":"/docs/compare/?release=9.6.11#9.6.11-a2c8631463649323","version":"9.6.11"},{"db_id":"ee3e886f2c98b2f632e1888be46239d0","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6aaab866c8e48e0146e6af6a7dcd983762e678249084770092512aee8e0b8c"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"确保服务器在等待客户端输入之前处理已收到的 NOTIFY 和 SIGTERM 中断","url":"/docs/compare/?release=9.5.15#9.5.15-a2c8631463649323","version":"9.5.15"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6aaab866c8e48e0146e6af6a7dcd983762e678249084770092512aee8e0b8c"},"rule":2,"target":"58a0a41b7dede37cef3fb1c940a2aff6","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6aaab866c8e48e0146e6af6a7dcd983762e678249084770092512aee8e0b8c"},"rule":2,"target":"a9e36a6f80e9e4054f9930438ca27b26","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6aaab866c8e48e0146e6af6a7dcd983762e678249084770092512aee8e0b8c"},"rule":2,"target":"ee3e886f2c98b2f632e1888be46239d0","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["7aaeb7b45"],"source_entry_id":"11.1/changes/012","source_hash":"cdfff1e440d8e459c657bfd03aff2909efe9272d066a63ae99a84c56dc82079b","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"1f6aaab866c8e48e0146e6af6a7dcd983762e678249084770092512aee8e0b8c","text":"确保服务器在等待客户端输入之前，处理已收到的 NOTIFY 和 SIGTERM 中断（Jeff Janes，Tom Lane）","title":"确保服务器在等待客户端输入之前，处理已收到的 NOTIFY 和 SIGTERM 中断","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["156a737a6","2493e2c2d","558571afc","696b0c5fd","82dd1c271","92e371f9b","95015b1f8"],"commit_groups":[["156a737a6","2493e2c2d","558571afc","696b0c5fd","82dd1c271","92e371f9b","95015b1f8"]],"commits":[],"cves":[],"db_id":"b55562a2b724286d5206d8ef8095da34","html":"\u003cp\u003e修复重复扫描 SP-GiST 索引时的内存泄漏（Tom Lane）\u003c/p\u003e\n\u003cp\u003e目前仅已知在使用 SP-GiST 的排除约束于单条命令中接收大量新索引条目时，这种泄漏才会达到显著程度。\u003c/p\u003e","id":"11.1-68991a6abf9bcfaa","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.","part":"changes","patch_ids":["4e12d4f2731df20a5ffa2358c6cd6c2b"],"related_changes":[{"db_id":"97251aceae3237fca5cfc03ab2772ed8","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"修复重复扫描 SP-GiST 索引时的内存泄漏","url":"/docs/compare/?release=10.6#10.6-68991a6abf9bcfaa","version":"10.6"},{"db_id":"d36720e5fa0884f4bf6165c602c3ab83","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"修复重复 SP-GiST 索引扫描中的内存泄漏","url":"/docs/compare/?release=9.6.11#9.6.11-b5fe498b8a00261e","version":"9.6.11"},{"db_id":"a7f4ceb548ef27e44454af0fb4f0ea7b","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"修复重复 SP-GiST 索引扫描中的内存泄漏","url":"/docs/compare/?release=9.5.15#9.5.15-b5fe498b8a00261e","version":"9.5.15"},{"db_id":"7d01879c253fb3fe4968c53cd6bb9c5a","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"kind":"equivalent","label":"9.4.20","source_url":"/docs/release/9.4.20/#id-1.11.6.11.5","title":"修复重复 SP-GiST 索引扫描中的内存泄漏","url":"/docs/compare/?release=9.4.20#9.4.20-b5fe498b8a00261e","version":"9.4.20"},{"db_id":"461f8794e1c01e2cc3f5c331235d7da1","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"kind":"equivalent","label":"9.3.25","source_url":"/docs/release/9.3.25/#id-1.11.6.5.6","title":"修复重复 SP-GiST 索引扫描中的内存泄漏","url":"/docs/compare/?release=9.3.25#9.3.25-b5fe498b8a00261e","version":"9.3.25"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"rule":2,"target":"461f8794e1c01e2cc3f5c331235d7da1","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"rule":2,"target":"7d01879c253fb3fe4968c53cd6bb9c5a","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"rule":2,"target":"97251aceae3237fca5cfc03ab2772ed8","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"rule":2,"target":"a7f4ceb548ef27e44454af0fb4f0ea7b","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b"},"rule":2,"target":"d36720e5fa0884f4bf6165c602c3ab83","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["2493e2c2d"],"source_entry_id":"11.1/changes/013","source_hash":"d1fc3793d48db1457c2c6af6d9d2166417f73ad427520d5b3e346a06a1c0a797","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"84dda1f995e75fd1e58b5edd244a3ba6761ec3b5ce33a51a1f1df24d5003869b","text":"修复重复扫描 SP-GiST 索引时的内存泄漏（Tom Lane） 目前仅已知在使用 SP-GiST 的排除约束于单条命令中接收大量新索引条目时，这种泄漏才会达到显著程度。","title":"修复重复扫描 SP-GiST 索引时的内存泄漏","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["021e1c329","679cb44e4","691d79a07","c33a01c79","cf358a2c0","d35fd17cb"],"commit_groups":[["021e1c329","679cb44e4","691d79a07","c33a01c79","cf358a2c0","d35fd17cb"]],"commits":[],"cves":[],"db_id":"bb8ad4ce1290f5a5a79dad07ecca169c","html":"\u003cp\u003e如果 \u003ccode\u003ewal_level\u003c/code\u003e 设置过低，无法支持现有复制槽，则禁止启动服务器（Andres Freund）\u003c/p\u003e","id":"11.1-fa741401ce2eb557","identity_text":"Prevent starting the server with wal_level set to too low a value to support an existing replication slot (Andres Freund)","part":"changes","patch_ids":["b196f7eaa47bc5d419f111bf2e64fae7"],"related_changes":[{"db_id":"272d9b334637457fb19c505fe2c5744c","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"如果 wal_level 设置过低，无法支持现有复制槽，则禁止启动服务器","url":"/docs/compare/?release=10.6#10.6-fa741401ce2eb557","version":"10.6"},{"db_id":"69a3869c5059c2f6891c79168f3efbb1","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"防止以低到无法支持现有复制槽的 wal_level 启动服务器","url":"/docs/compare/?release=9.6.11#9.6.11-070d3827f034c332","version":"9.6.11"},{"db_id":"349a29f6c61ca7e400b3c496e944e2dc","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"防止以低到无法支持现有复制槽的 wal_level 启动服务器","url":"/docs/compare/?release=9.5.15#9.5.15-070d3827f034c332","version":"9.5.15"},{"db_id":"4a2c4704546f5705519d3623cbc3ec9c","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b"},"kind":"equivalent","label":"9.4.20","source_url":"/docs/release/9.4.20/#id-1.11.6.11.5","title":"阻止以过低的wal_level值（不足以支持现有复制槽）启动服务器","url":"/docs/compare/?release=9.4.20#9.4.20-5f1f80775e7a1eac","version":"9.4.20"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b"},"rule":2,"target":"272d9b334637457fb19c505fe2c5744c","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b"},"rule":2,"target":"349a29f6c61ca7e400b3c496e944e2dc","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b"},"rule":2,"target":"4a2c4704546f5705519d3623cbc3ec9c","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b"},"rule":2,"target":"69a3869c5059c2f6891c79168f3efbb1","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["c33a01c79"],"source_entry_id":"11.1/changes/014","source_hash":"ee5ba24bf39b0129018f5811296fb3d0ca06ce70f8e95d30e8d7aafe9b699688","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"1f6f61fc8b15e3a915a12a7a9b26605a67358cc4fedd1a3e3e74dfec7580a96b","text":"如果 wal_level 设置过低，无法支持现有复制槽，则禁止启动服务器（Andres Freund）","title":"如果 wal_level 设置过低，无法支持现有复制槽，则禁止启动服务器","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["34aad21cb","4247db625","ac3be116a","d30d27a52","ecc59e31a"],"commit_groups":[["34aad21cb","4247db625","ac3be116a","d30d27a52","ecc59e31a"]],"commits":[],"cves":[],"db_id":"5a1c406d48c7e103b2aa24abe3d1409c","html":"\u003cp\u003e修复 \u003cspan\u003epsql\u003c/span\u003e 以及文档示例，使其在每次调用 \u003ccode\u003ePQnotifies()\u003c/code\u003e 之前调用 \u003ccode\u003ePQconsumeInput()\u003c/code\u003e（Tom Lane）\u003c/p\u003e\n\u003cp\u003e这修复了 \u003cspan\u003epsql\u003c/span\u003e 直到下一条命令之后才报告收到 \u003ccode\u003eNOTIFY\u003c/code\u003e 消息的情况。\u003c/p\u003e","id":"11.1-079c4c7fcf5e3d30","identity_text":"Fix psql, as well as documentation examples, to call PQconsumeInput() before each PQnotifies() call (Tom Lane) This fixes cases in which psql would not report receipt of a NOTIFY message until after the next command.","part":"changes","patch_ids":["140e4a3f21507dac7d119631ef63031b"],"related_changes":[{"db_id":"b060894131b886788cfe8ba2aaf6c3ae","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"14c650cd2a6b97cf4efea2764e6bbe3235388394b02168f9bd91fe4dd5ac7e61"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"修复 psql 以及文档示例，使其在每次调用 PQnotifies() 之前调用 PQconsumeInput()","url":"/docs/compare/?release=10.6#10.6-079c4c7fcf5e3d30","version":"10.6"},{"db_id":"2af7ad06b6fdaaa207504cf080264fef","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"14c650cd2a6b97cf4efea2764e6bbe3235388394b02168f9bd91fe4dd5ac7e61"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"修复 psql 以及文档示例，在每次调用 PQnotifies() 之前先调用 PQconsumeInput()","url":"/docs/compare/?release=9.6.11#9.6.11-848a6a77c6eda410","version":"9.6.11"},{"db_id":"e9bc4fa86eca70b25a4c3a31d74918fd","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"14c650cd2a6b97cf4efea2764e6bbe3235388394b02168f9bd91fe4dd5ac7e61"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"修复 psql 以及文档示例，在每次调用 PQnotifies() 之前先调用 PQconsumeInput()","url":"/docs/compare/?release=9.5.15#9.5.15-848a6a77c6eda410","version":"9.5.15"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"14c650cd2a6b97cf4efea2764e6bbe3235388394b02168f9bd91fe4dd5ac7e61"},"rule":2,"target":"2af7ad06b6fdaaa207504cf080264fef","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"14c650cd2a6b97cf4efea2764e6bbe3235388394b02168f9bd91fe4dd5ac7e61"},"rule":2,"target":"b060894131b886788cfe8ba2aaf6c3ae","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"14c650cd2a6b97cf4efea2764e6bbe3235388394b02168f9bd91fe4dd5ac7e61"},"rule":2,"target":"e9bc4fa86eca70b25a4c3a31d74918fd","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["d30d27a52"],"source_entry_id":"11.1/changes/015","source_hash":"f59763036842b6b0fb5f3b6afc6612668ab78f43bd47422279cbbb273ce8ca84","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"14c650cd2a6b97cf4efea2764e6bbe3235388394b02168f9bd91fe4dd5ac7e61","text":"修复 psql 以及文档示例，使其在每次调用 PQnotifies() 之前调用 PQconsumeInput()（Tom Lane） 这修复了 psql 直到下一条命令之后才报告收到 NOTIFY 消息的情况。","title":"修复 psql 以及文档示例，使其在每次调用 PQnotifies() 之前调用 PQconsumeInput()","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["cc7f27eae","d55241af7"],"commit_groups":[["cc7f27eae","d55241af7"]],"commits":[],"cves":[],"db_id":"5aeec4b74df69e093bfd38417fefd229","html":"\u003cp\u003e修复 \u003cspan\u003epg_verify_checksums\u003c/span\u003e 对哪些文件应检查校验和的判断（Michael Paquier）\u003c/p\u003e\n\u003cp\u003e在某些情况下，它会对本来就不应有校验和的文件报错。\u003c/p\u003e","id":"11.1-2e33665612e6f6ad","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.","part":"changes","patch_ids":["a720e5bb26eb76befaf85169faf519cc"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["cc7f27eae"],"source_entry_id":"11.1/changes/016","source_hash":"70e44c319e5464535e9d3fd66d73c3167012db4f97adbb201ff675e799dede7f","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"040700079db71fadc59f85386a5609b722fe0481005974f60c39d74ef0030554","text":"修复 pg_verify_checksums 对哪些文件应检查校验和的判断（Michael Paquier） 在某些情况下，它会对本来就不应有校验和的文件报错。","title":"修复 pg_verify_checksums 对哪些文件应检查校验和的判断","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["90a1f9786","a3bb831ef","edb979766"],"commit_groups":[["90a1f9786","a3bb831ef","edb979766"]],"commits":[],"cves":[],"db_id":"0e7772edb977d87c4e9584d2ba6f7749","html":"\u003cp\u003e在 \u003ccode\u003econtrib/pg_stat_statements\u003c/code\u003e 中，禁止 \u003ccode\u003epg_read_all_stats\u003c/code\u003e 角色执行 \u003ccode\u003epg_stat_statements_reset()\u003c/code\u003e（Haribabu Kommi）\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003epg_read_all_stats\u003c/code\u003e 只应授予读取统计信息的权限，而非更改统计信息的权限，因此此前的授权不正确。\u003c/p\u003e\n\u003cp\u003e要使此项修改生效，请在每个已安装 \u003ccode\u003epg_stat_statements\u003c/code\u003e 的数据库中运行 \u003ccode\u003eALTER EXTENSION pg_stat_statements UPDATE\u003c/code\u003e。（在 11.0 中新建的数据库应该不需要这样做，但从旧发行版升级的数据库可能仍包含旧版 \u003ccode\u003epg_stat_statements\u003c/code\u003e。如果模块已更新，执行 \u003ccode\u003eUPDATE\u003c/code\u003e 命令也不会有害。）\u003c/p\u003e","id":"11.1-9b869fcce22ba013","identity_text":"In contrib/pg_stat_statements, disallow the pg_read_all_stats role from executing pg_stat_statements_reset() (Haribabu Kommi) pg_read_all_stats is only meant to grant permission to read statistics, not to change them, so this grant was incorrect. To cause this change to take effect, run ALTER EXTENSION pg_stat_statements UPDATE in each database where pg_stat_statements has been installed. (A database freshly created in 11.0 should not need this, but a database upgraded from a previous release probably still contains the old version of pg_stat_statements. The UPDATE command is harmless if the module was already updated.)","part":"changes","patch_ids":["0da5f5027050f26c1b8d5f066c4de0b5"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["a3bb831ef"],"source_entry_id":"11.1/changes/017","source_hash":"cf03879a83ed2fd3ee74a50ad44bba86b395c932c1ca70d46d932ca79658eeb4","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"c0ecadb83d10d99608fc836fe277120b2707fa40ceaf06ea1f8133436151f7e5","text":"在 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 命令也不会有害。）","title":"在 contrib/pg_stat_statements 中，禁止 pg_read_all_stats 角色执行 pg_stat_statements_reset()","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["003c68a3b","1f28ec6be","b2e754c14"],"commit_groups":[["003c68a3b","1f28ec6be","b2e754c14"]],"commits":[],"cves":[],"db_id":"b2b63130886329bb7fbe86266a95c046","html":"\u003cp\u003e重命名红黑树支持函数，使用 \u003ccode\u003erbt\u003c/code\u003e 前缀代替 \u003ccode\u003erb\u003c/code\u003e 前缀（Tom Lane）\u003c/p\u003e\n\u003cp\u003e这避免了与 Ruby 函数发生名称冲突，后者曾使 PL/Ruby 失效。希望没有其他扩展受到影响。\u003c/p\u003e","id":"11.1-2ff83efd3ef7f9a6","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.","part":"changes","patch_ids":["e76a2575f95720cece0ca6df9770e734"],"related_changes":[{"db_id":"df459454eaa00e82ec9d18ae69918099","evidence":{"patch_ids":["e76a2575f95720cece0ca6df9770e734"],"same_day":false,"statement_hash":"8bd50ae860c4fd5ec18f566869c831d96053832f2f80fc1723d19b716d2628a9"},"kind":"equivalent","label":"10.7","source_url":"/docs/release/10.7/#id-1.11.6.21.5","title":"重命名红黑树支持函数，使用 rbt 前缀代替 rb 前缀","url":"/docs/compare/?release=10.7#10.7-2ff83efd3ef7f9a6","version":"10.7"}],"relations":[{"evidence":{"patch_ids":["e76a2575f95720cece0ca6df9770e734"],"same_day":false,"statement_hash":"8bd50ae860c4fd5ec18f566869c831d96053832f2f80fc1723d19b716d2628a9"},"rule":2,"target":"df459454eaa00e82ec9d18ae69918099","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["1f28ec6be"],"source_entry_id":"11.1/changes/018","source_hash":"d6c7846df637b7949cf1a66be8cecc8acc8ed6fab672e472ed57d2d70b076a5c","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"8bd50ae860c4fd5ec18f566869c831d96053832f2f80fc1723d19b716d2628a9","text":"重命名红黑树支持函数，使用 rbt 前缀代替 rb 前缀（Tom Lane） 这避免了与 Ruby 函数发生名称冲突，后者曾使 PL/Ruby 失效。希望没有其他扩展受到影响。","title":"重命名红黑树支持函数，使用 rbt 前缀代替 rb 前缀","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["015fd381f","021b355cd","0749acca5","0a4456a70","1440c461f","19ac2cb2a","1a69f738d","1aad3a724","1b5e8b408","1b92ca9e2","229a5c8ad","34f9944c2","401202b79","486e6f8d9","5777a9ff8","5e2217131","6019247a5","68fc227dd","6dc28d291","736c3a48c","94ea1cf73","9590f7d6c","a5361b593","d0ab588cc","d1e869d1e","df1d749a7","e74dd00f5","ee6c08b01"],"commit_groups":[["015fd381f","021b355cd","0749acca5","1b92ca9e2","34f9944c2","d1e869d1e","e74dd00f5"],["0a4456a70","5e2217131","6019247a5","6dc28d291","736c3a48c","9590f7d6c","a5361b593"],["1440c461f","1aad3a724","1b5e8b408","229a5c8ad","401202b79","94ea1cf73","df1d749a7"],["19ac2cb2a","1a69f738d","486e6f8d9","5777a9ff8","68fc227dd","d0ab588cc","ee6c08b01"]],"commits":[],"cves":[],"db_id":"fe2bae05be5fd6088874d68a76b1f3ff","html":"\u003cp\u003e修复 macOS 10.14（Mojave）上的构建问题（Tom Lane）\u003c/p\u003e\n\u003cp\u003e调整 \u003cspan\u003econfigure\u003c/span\u003e，向 \u003ccode\u003eCPPFLAGS\u003c/code\u003e 添加 \u003ccode\u003e-isysroot\u003c/code\u003e 开关；否则，PL/Perl 和 PL/Tcl 在 macOS 10.14 上无法配置或构建。可以在 \u003cspan\u003econfigure\u003c/span\u003e 或 \u003cspan\u003emake\u003c/span\u003e 的参数中设置 \u003ccode\u003ePG_SYSROOT\u003c/code\u003e 变量，在配置时或构建时覆盖所用的具体 sysroot。\u003c/p\u003e\n\u003cp\u003e现在建议 Perl 相关扩展在编译器标志中写入 \u003ccode\u003e$(perl_includespec)\u003c/code\u003e，而非 \u003ccode\u003e-I$(perl_archlibexp)/CORE\u003c/code\u003e。后者在大多数平台上仍然有效，但在近期 macOS 上无效。\u003c/p\u003e\n\u003cp\u003e此外，在近期 macOS 版本上构建 PL/Tcl 时，应不再需要手动指定 \u003ccode\u003e--with-tclconfig\u003c/code\u003e。\u003c/p\u003e","id":"11.1-9a46ff8655386392","identity_text":"Fix build problems on macOS 10.14 (Mojave) (Tom Lane) Adjust configure to add an -isysroot switch to CPPFLAGS; without this, PL/Perl and PL/Tcl fail to configure or build on macOS 10.14. The specific sysroot used can be overridden at configure time or build time by setting the PG_SYSROOT variable in the arguments of configure or make. It is now recommended that Perl-related extensions write $(perl_includespec) rather than -I$(perl_archlibexp)/CORE in their compiler flags. The latter continues to work on most platforms, but not recent macOS. Also, it should no longer be necessary to specify --with-tclconfig manually to get PL/Tcl to build on recent macOS releases.","part":"changes","patch_ids":["297116497b26fff7a566c1ea9b3857a2","8203c951c6b3b1b133d2445a2d134ee7","cca7c45ddfed73412e7fab40c3828b99","db9b985c559f2eca8223b5c43bb7277c"],"related_changes":[{"db_id":"5c29e1d1317aab57179d5a6f6bad58dd","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"修复 macOS 10.14（Mojave）上的构建问题","url":"/docs/compare/?release=10.6#10.6-9a46ff8655386392","version":"10.6"},{"db_id":"fe85548f1db806d6dc35aa43c9c75091","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"修复 macOS 10.14（Mojave）上的构建问题","url":"/docs/compare/?release=9.6.11#9.6.11-9a46ff8655386392","version":"9.6.11"},{"db_id":"4d61afdda860b057b6269de4cc193262","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"修复 macOS 10.14（Mojave）上的构建问题","url":"/docs/compare/?release=9.5.15#9.5.15-9a46ff8655386392","version":"9.5.15"},{"db_id":"0573685aa14d64178784109e5f3f2399","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"kind":"equivalent","label":"9.4.20","source_url":"/docs/release/9.4.20/#id-1.11.6.11.5","title":"修复 macOS 10.14（Mojave）上的构建问题","url":"/docs/compare/?release=9.4.20#9.4.20-9a46ff8655386392","version":"9.4.20"},{"db_id":"0d12180e1c657bd3248e00988558c8b6","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"kind":"equivalent","label":"9.3.25","source_url":"/docs/release/9.3.25/#id-1.11.6.5.6","title":"修复 macOS 10.14（Mojave）上的构建问题","url":"/docs/compare/?release=9.3.25#9.3.25-9a46ff8655386392","version":"9.3.25"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"rule":2,"target":"0573685aa14d64178784109e5f3f2399","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"rule":2,"target":"0d12180e1c657bd3248e00988558c8b6","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"rule":2,"target":"4d61afdda860b057b6269de4cc193262","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"rule":2,"target":"5c29e1d1317aab57179d5a6f6bad58dd","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8"},"rule":2,"target":"fe85548f1db806d6dc35aa43c9c75091","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["1a69f738d","9590f7d6c","d1e869d1e","df1d749a7"],"source_entry_id":"11.1/changes/019","source_hash":"15f3e99da72bb1e1f70d173dcd0450ffe24937e241b5aabb8644afa8023ecacb","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"5548bd964195f61e6b9862763083a9aee02c1ef822aeadc42c795a2b1cf445a8","text":"修复 macOS 10.14（Mojave）上的构建问题（Tom Lane） 调整 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。","title":"修复 macOS 10.14（Mojave）上的构建问题","variants":[],"version":"11.1"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["075641fd0","1df92eeaf","698255147","8cb5e67d1","9fd6d4eae","a71f55652","ba103dc87"],"commit_groups":[["075641fd0","1df92eeaf","698255147","8cb5e67d1","9fd6d4eae","a71f55652","ba103dc87"]],"commits":[],"cves":[],"db_id":"38726384cd10e441aa4dcced098d61b8","html":"\u003cp\u003e修复 MSVC 构建和回归测试脚本，使其适用于近期 Perl 版本（Andrew Dunstan）\u003c/p\u003e\n\u003cp\u003ePerl 默认已不再将当前目录包含在搜索路径中，现在对此进行适配。\u003c/p\u003e","id":"11.1-4ce896e4612f55d4","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.","part":"changes","patch_ids":["002abb29792b3d916e28a5d4beed8527"],"related_changes":[{"db_id":"7c21077c9eb4a826e9bed8b137d5f770","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"修复 MSVC 构建和回归测试脚本，使其适用于近期 Perl 版本","url":"/docs/compare/?release=10.6#10.6-4ce896e4612f55d4","version":"10.6"},{"db_id":"330db97de242d00c963b07fc3c46b0e2","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"修复 MSVC 构建和回归测试脚本在最近的 Perl 版本上工作","url":"/docs/compare/?release=9.6.11#9.6.11-f991ee36ce29595f","version":"9.6.11"},{"db_id":"c05a64c813d21edd23ba0418b3a7b77e","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"修复 MSVC 构建和回归测试脚本在最近的 Perl 版本上工作","url":"/docs/compare/?release=9.5.15#9.5.15-f991ee36ce29595f","version":"9.5.15"},{"db_id":"e3ec0a53c68d18896cdc4e43a13db606","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"kind":"equivalent","label":"9.4.20","source_url":"/docs/release/9.4.20/#id-1.11.6.11.5","title":"修复 MSVC 构建和回归测试脚本在最近的 Perl 版本上工作","url":"/docs/compare/?release=9.4.20#9.4.20-f991ee36ce29595f","version":"9.4.20"},{"db_id":"8a1cc7acdfb09c199a9f3ca1cd405980","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"kind":"equivalent","label":"9.3.25","source_url":"/docs/release/9.3.25/#id-1.11.6.5.6","title":"修复 MSVC 构建和回归测试脚本在最近的 Perl 版本上工作","url":"/docs/compare/?release=9.3.25#9.3.25-f991ee36ce29595f","version":"9.3.25"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"rule":2,"target":"330db97de242d00c963b07fc3c46b0e2","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"rule":2,"target":"7c21077c9eb4a826e9bed8b137d5f770","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"rule":2,"target":"8a1cc7acdfb09c199a9f3ca1cd405980","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"rule":2,"target":"c05a64c813d21edd23ba0418b3a7b77e","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8"},"rule":2,"target":"e3ec0a53c68d18896cdc4e43a13db606","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["8cb5e67d1"],"source_entry_id":"11.1/changes/020","source_hash":"a65f69c2d7cb1a86b7a65470a90470a779d2e8a92d33bcc28c78316d0ac5f876","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"ae5a3c28d2110945ca8eab359490e20b4c9880f194aff5e7f362830376bf1eb8","text":"修复 MSVC 构建和回归测试脚本，使其适用于近期 Perl 版本（Andrew Dunstan） Perl 默认已不再将当前目录包含在搜索路径中，现在对此进行适配。","title":"修复 MSVC 构建和回归测试脚本，使其适用于近期 Perl 版本","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["42a93da25","a0a8671a6","cc02db82c","ce5d3424d","f4b67efdc"],"commit_groups":[["42a93da25","a0a8671a6","cc02db82c","ce5d3424d","f4b67efdc"]],"commits":[],"cves":[],"db_id":"48c2735b63080aaa3f2db59e70d658d4","html":"\u003cp\u003e在 Windows 上，允许使用 Administrator 账户运行回归测试（Andrew Dunstan）\u003c/p\u003e\n\u003cp\u003e为安全地做到这一点，\u003cspan\u003epg_regress\u003c/span\u003e 现在会在启动时放弃所有此类特权。\u003c/p\u003e","id":"11.1-4d189096157461b0","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.","part":"changes","patch_ids":["aa80bc7e4ecc9872d535699f901d69b9"],"related_changes":[{"db_id":"1d8ee57c6e885f7810b31fad3ae8af64","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"在 Windows 上，允许使用 Administrator 账户运行回归测试","url":"/docs/compare/?release=10.6#10.6-4d189096157461b0","version":"10.6"},{"db_id":"9d7ea114afa8473a02bf20907f9f413b","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"在 Windows 上，允许由管理员账户运行回归测试","url":"/docs/compare/?release=9.6.11#9.6.11-44146fcc9439c230","version":"9.6.11"},{"db_id":"e930c125b40f9ac76f19bef307f9d7df","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"在 Windows 上，允许由管理员账户运行回归测试","url":"/docs/compare/?release=9.5.15#9.5.15-44146fcc9439c230","version":"9.5.15"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"},"rule":2,"target":"1d8ee57c6e885f7810b31fad3ae8af64","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"},"rule":2,"target":"9d7ea114afa8473a02bf20907f9f413b","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a"},"rule":2,"target":"e930c125b40f9ac76f19bef307f9d7df","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["a0a8671a6"],"source_entry_id":"11.1/changes/021","source_hash":"b698918e46331376c55409cb177531c2958b35ac04e82d4d5c938960fe18ecc0","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"518a0f3cfeba75e955026198e57c35b7a6c5b24c57dd5d3897992d477d3f4e4a","text":"在 Windows 上，允许使用 Administrator 账户运行回归测试（Andrew Dunstan） 为安全地做到这一点，pg_regress 现在会在启动时放弃所有此类特权。","title":"在 Windows 上，允许使用 Administrator 账户运行回归测试","variants":[],"version":"11.1"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["13877d30f","185f135c9","3bf4edace","56170609b","5777c93af","58c45fdaa","5c2e0ca5f","671f43d88","811d8cb87","84261eb10","9abbfc35c","bb761c6a0","d2259c26b","d651e9e7c"],"commit_groups":[["13877d30f","185f135c9","56170609b","5777c93af","84261eb10","9abbfc35c","d2259c26b"],["3bf4edace","58c45fdaa","5c2e0ca5f","671f43d88","811d8cb87","bb761c6a0","d651e9e7c"]],"commits":[],"cves":[],"db_id":"ec1af20fff76afd67ff7d1ea4783a255","html":"\u003cp\u003e将时区数据文件更新到 \u003cspan\u003etzdata\u003c/span\u003e 2018g 版，以反映智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，并修正中国、夏威夷、日本、澳门和朝鲜的历史数据。\u003c/p\u003e","id":"11.1-a976c1cc861f3265","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.","part":"changes","patch_ids":["04598c44cf2a75a488bf50cae6ef6847","1a1428f61eafbf8549db9a42c6d8a26d"],"related_changes":[{"db_id":"a9dda89f62e87a28c9cc3df0363e971d","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"kind":"equivalent","label":"10.6","source_url":"/docs/release/10.6/#id-1.11.6.22.5","title":"将时区数据文件更新到 tzdata 2018g 版，以反映智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，并修正中国、夏威夷、日本、澳门和朝鲜的历史数据。","url":"/docs/compare/?release=10.6#10.6-a976c1cc861f3265","version":"10.6"},{"db_id":"bd23f638637439f7790fcb58590eeb8e","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"kind":"equivalent","label":"9.6.11","source_url":"/docs/release/9.6.11/#id-1.11.6.18.5","title":"更新时区数据文件到 tzdata 版本 2018g，涉及智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，以及中国、夏威夷、日本、澳门和朝鲜的历史修正。","url":"/docs/compare/?release=9.6.11#9.6.11-4239e7a753d90202","version":"9.6.11"},{"db_id":"3a47d92908a2a93e22bf9701d1a2d0fb","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"kind":"equivalent","label":"9.5.15","source_url":"/docs/release/9.5.15/#id-1.11.6.15.5","title":"更新时区数据文件到 tzdata 版本 2018g，涉及智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，以及中国、夏威夷、日本、澳门和朝鲜的历史修正。","url":"/docs/compare/?release=9.5.15#9.5.15-4239e7a753d90202","version":"9.5.15"},{"db_id":"46b29725b96825b29e06a3f184f945fc","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"kind":"equivalent","label":"9.4.20","source_url":"/docs/release/9.4.20/#id-1.11.6.11.5","title":"更新时区数据文件到 tzdata 版本 2018g，涉及智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，以及中国、夏威夷、日本、澳门和朝鲜的历史修正。","url":"/docs/compare/?release=9.4.20#9.4.20-4239e7a753d90202","version":"9.4.20"},{"db_id":"75ae186c775b3d34ee7e5623ad582135","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"kind":"equivalent","label":"9.3.25","source_url":"/docs/release/9.3.25/#id-1.11.6.5.6","title":"更新时区数据文件到 tzdata 版本 2018g，涉及智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，以及中国、夏威夷、日本、澳门和朝鲜的历史修正。","url":"/docs/compare/?release=9.3.25#9.3.25-4239e7a753d90202","version":"9.3.25"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"rule":2,"target":"3a47d92908a2a93e22bf9701d1a2d0fb","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"rule":2,"target":"46b29725b96825b29e06a3f184f945fc","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"rule":2,"target":"75ae186c775b3d34ee7e5623ad582135","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"rule":2,"target":"a9dda89f62e87a28c9cc3df0363e971d","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f"},"rule":2,"target":"bd23f638637439f7790fcb58590eeb8e","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["58c45fdaa","d2259c26b"],"source_entry_id":"11.1/changes/022","source_hash":"a701cb9bf13b6e8d75a5d3a21559abd8caf2427492f0732172cf2656bf25053e","source_url":"/docs/release/11.1/#id-1.11.6.26.5","statement_hash":"a9e19090b9bf091c1bb68a6566aa3e98703adba98349ffe3420350e144cbba5f","text":"将时区数据文件更新到 tzdata 2018g 版，以反映智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，并修正中国、夏威夷、日本、澳门和朝鲜的历史数据。","title":"将时区数据文件更新到 tzdata 2018g 版，以反映智利、斐济、摩洛哥和俄罗斯（伏尔加格勒）的夏令时法规变更，并修正中国、夏威夷、日本、澳门和朝鲜的历史数据。","variants":[],"version":"11.1"}],"entry_count":22,"eol":"2023-11-09","eol_date":"2023-11-09","label":"11.1","major":"11","manual":"11","manual_build":"11.22","manual_url":"/docs/11/release-11-1.html","migration_html":"\u003cp\u003e对于运行 11.X 的用户，不需要执行导出/恢复。\u003c/p\u003e\n\u003cp\u003e但是，如果使用了 \u003ccode\u003epg_stat_statements\u003c/code\u003e 扩展，请参阅下方相关变更日志条目。\u003c/p\u003e","minor":1,"placeholder":false,"source_as_of":"","source_url":"/docs/release/11.1/","status":"stable","status_label":"Historical","support_days":-1068,"supported":false,"version":"11.1"}],"mode":"release","release_count":1,"remaining_cves":[],"security_as_of":"2026-09-26","security_regressions":[],"source_as_of":"2026-09-26","stats":[{"count":22,"key":"all","label":"All changes"},{"count":0,"key":"feature","label":"Features"},{"count":12,"key":"bugfix","label":"Bug fixes"},{"count":1,"key":"security","label":"Security"},{"count":0,"key":"performance","label":"Performance"},{"count":0,"key":"compatibility","label":"Compatibility"},{"count":9,"key":"improvement","label":"Improvements"}],"to_release":{"age_days":2895,"build":"11.1","changes_count":22,"compatibility_count":0,"content_hash":"404582f8ef651a0894857775e8417983597a21cc5a09c3a92cac237c9ca55e8e","date":"2018-11-08","date_text":"2018-11-08","doc_git":"","doc_loaded_at":"2026-09-26T02:56:42.383207","entry_count":22,"eol":"2023-11-09","eol_date":"2023-11-09","label":"11.1","major":"11","manual":"11","manual_build":"11.22","manual_url":"/docs/11/release-11-1.html","migration_html":"\u003cp\u003e对于运行 11.X 的用户，不需要执行导出/恢复。\u003c/p\u003e\n\u003cp\u003e但是，如果使用了 \u003ccode\u003epg_stat_statements\u003c/code\u003e 扩展，请参阅下方相关变更日志条目。\u003c/p\u003e","minor":1,"placeholder":false,"source_as_of":"","source_url":"/docs/release/11.1/","status":"stable","status_label":"Historical","support_days":-1068,"supported":false,"version":"11.1"},"total":22,"warnings":[]}