{"already_in_source_count":0,"candidate_count":71,"cross_major":false,"cve_available":true,"cve_count":8,"cves":[{"affected":{"8.4":"8.4","9.0":"9.0","9.1":"9.1","9.2":"9.2","9.3":"9.3"},"component":"core server","cvss_version":"3.0","description_en":"","first_published":null,"fixed":{"8.4":"8.4.20","9.0":"9.0.16","9.1":"9.1.12","9.2":"9.2.7","9.3":"9.3.3"},"fixed_version":"9.3.3","id":"CVE-2014-0062","introduced":{},"published":{},"score":8.8,"title":"避免在表和索引 DDL 期间进行多次名称查找","url":"https://www.postgresql.org/support/security/CVE-2014-0062/","vector":"AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H"},{"affected":{"8.4":"8.4","9.0":"9.0","9.1":"9.1","9.2":"9.2","9.3":"9.3"},"component":"core server","cvss_version":"3.0","description_en":"","first_published":null,"fixed":{"8.4":"8.4.20","9.0":"9.0.16","9.1":"9.1.12","9.2":"9.2.7","9.3":"9.3.3"},"fixed_version":"9.3.3","id":"CVE-2014-0061","introduced":{},"published":{},"score":7.5,"title":"防止通过手工调用 PL 验证器函数进行权限提升","url":"https://www.postgresql.org/support/security/CVE-2014-0061/","vector":"AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H"},{"affected":{"9.0":"9.0","9.1":"9.1","9.2":"9.2","9.3":"9.3","9.4":"9.4"},"component":"other","cvss_version":"3.0","description_en":"","first_published":null,"fixed":{"9.0":"9.0.19","9.1":"9.1.15","9.2":"9.2.10","9.3":"9.3.6","9.4":"9.4.1"},"fixed_version":"9.3.6","id":"CVE-2014-0067","introduced":{},"published":{},"score":7.0,"title":"在回归测试说明中记录 make check 的风险","url":"https://www.postgresql.org/support/security/CVE-2014-0067/","vector":"AV:L/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H"},{"affected":{"8.4":"8.4","9.0":"9.0","9.1":"9.1","9.2":"9.2","9.3":"9.3"},"component":"core server","cvss_version":"3.0","description_en":"","first_published":null,"fixed":{"8.4":"8.4.20","9.0":"9.0.16","9.1":"9.1.12","9.2":"9.2.7","9.3":"9.3.3"},"fixed_version":"9.3.3","id":"CVE-2014-0064","introduced":{},"published":{},"score":6.5,"title":"防止大小计算中的整数溢出导致缓冲区越界","url":"https://www.postgresql.org/support/security/CVE-2014-0064/","vector":"AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:L/A:H"},{"affected":{"8.4":"8.4","9.0":"9.0","9.1":"9.1","9.2":"9.2","9.3":"9.3"},"component":"core server","cvss_version":"3.0","description_en":"","first_published":null,"fixed":{"8.4":"8.4.20","9.0":"9.0.16","9.1":"9.1.12","9.2":"9.2.7","9.3":"9.3.3"},"fixed_version":"9.3.3","id":"CVE-2014-0063","introduced":{},"published":{},"score":4.3,"title":"防止长日期时间字符串造成缓冲区越界","url":"https://www.postgresql.org/support/security/CVE-2014-0063/","vector":"AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:L/A:N"},{"affected":{"8.4":"8.4","9.0":"9.0","9.1":"9.1","9.2":"9.2","9.3":"9.3"},"component":"core server","cvss_version":"3.0","description_en":"","first_published":null,"fixed":{"8.4":"8.4.20","9.0":"9.0.16","9.1":"9.1.12","9.2":"9.2.7","9.3":"9.3.3"},"fixed_version":"9.3.3","id":"CVE-2014-0060","introduced":{},"published":{},"score":3.1,"title":"加固 GRANT ... WITH ADMIN OPTION 的限制","url":"https://www.postgresql.org/support/security/CVE-2014-0060/","vector":"AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:N/A:L"},{"affected":{"8.4":"8.4","9.0":"9.0","9.1":"9.1","9.2":"9.2","9.3":"9.3"},"component":"contrib module","cvss_version":"3.0","description_en":"","first_published":null,"fixed":{"8.4":"8.4.20","9.0":"9.0.16","9.1":"9.1.12","9.2":"9.2.7","9.3":"9.3.3"},"fixed_version":"9.3.3","id":"CVE-2014-0066","introduced":{},"published":{},"score":0.0,"title":"避免在 crypt() 返回 NULL 时崩溃","url":"https://www.postgresql.org/support/security/CVE-2014-0066/","vector":"AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:N/A:N"},{"affected":{"8.4":"8.4","9.0":"9.0","9.1":"9.1","9.2":"9.2","9.3":"9.3"},"component":"core server","cvss_version":"3.0","description_en":"","first_published":null,"fixed":{"8.4":"8.4.20","9.0":"9.0.16","9.1":"9.1.12","9.2":"9.2.7","9.3":"9.3.3"},"fixed_version":"9.3.3","id":"CVE-2014-0065","introduced":{},"published":{},"score":0.0,"title":"防止固定大小缓冲区越界","url":"https://www.postgresql.org/support/security/CVE-2014-0065/","vector":"AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:N/A:N"}],"duplicate_count":0,"excluded_count":0,"exclusions":[],"from_release":null,"groups":[{"age_days":4617,"build":"9.3.3","changes_count":71,"compatibility_count":0,"content_hash":"a9b07ead63ed242db533001b03b822b955a3d46ba1c9797fd3db0007523f3dbd","date":"2014-02-20","date_text":"2014-02-20","doc_git":"","doc_loaded_at":"2026-09-26T02:56:46.133805","entries":[{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["15a8f97b9","475a1fbc4","5d320a16c","789063697","fea164a72","ff35425c8"],"commit_groups":[["15a8f97b9","475a1fbc4","5d320a16c","789063697","fea164a72","ff35425c8"]],"commits":[],"cves":["CVE-2014-0060"],"db_id":"a0af19377a8f08e1c41168da3bfc8ec2","html":"\u003cp\u003e加固 \u003ccode\u003eGRANT ... WITH ADMIN OPTION\u003c/code\u003e 的限制（Noah Misch）\u003c/p\u003e\n\u003cp\u003e不带 \u003ccode\u003eADMIN OPTION\u003c/code\u003e 授予角色本应阻止被授予者向该角色添加或移除成员，但这一限制很容易通过先执行 \u003ccode\u003eSET ROLE\u003c/code\u003e 绕过。其安全影响主要在于角色成员可以撤销其他人的访问权限，这违背了授权者的意愿。未经批准添加角色成员的影响相对较小，因为不配合的角色成员本来就可以通过创建视图或 \u003ccode\u003eSECURITY DEFINER\u003c/code\u003e 函数把自己的大部分权限提供给他人。（CVE-2014-0060）\u003c/p\u003e","id":"9.3.3-46d40736d76fe1e1","identity_text":"Shore up GRANT ... WITH ADMIN OPTION restrictions (Noah Misch) Granting a role without ADMIN OPTION is supposed to prevent the grantee from adding or removing members from the granted role, but this restriction was easily bypassed by doing SET ROLE first. The security impact is mostly that a role member can revoke the access of others, contrary to the wishes of his grantor. Unapproved role member additions are a lesser concern, since an uncooperative role member could provide most of his rights to others anyway by creating views or SECURITY DEFINER functions. (CVE-2014-0060)","part":"changes","patch_ids":["600f4cf2230c1ecaa25a3fcda23311d1"],"related_changes":[{"db_id":"eb9eca640834341acf49af39f8eb5e82","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"加固 GRANT ... WITH ADMIN OPTION 的限制","url":"/docs/compare/?release=9.2.7#9.2.7-46d40736d76fe1e1","version":"9.2.7"},{"db_id":"8fed47c81bc13e310ce60e63b82d3369","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"加固 GRANT ... WITH ADMIN OPTION 的限制","url":"/docs/compare/?release=9.1.12#9.1.12-46d40736d76fe1e1","version":"9.1.12"},{"db_id":"39a7228bd3692113e40d80fa360dd96f","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"加固 GRANT ... WITH ADMIN OPTION 的限制","url":"/docs/compare/?release=9.0.16#9.0.16-46d40736d76fe1e1","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"},"rule":2,"target":"39a7228bd3692113e40d80fa360dd96f","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"},"rule":2,"target":"8fed47c81bc13e310ce60e63b82d3369","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"},"rule":2,"target":"eb9eca640834341acf49af39f8eb5e82","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["475a1fbc4"],"source_entry_id":"9.3.3/changes/001","source_hash":"6e37955c412d5e32a5769e3aad865f9e898e71305a81acc6327876eb0bdd1298","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c","text":"加固 GRANT ... WITH ADMIN OPTION 的限制（Noah Misch） 不带 ADMIN OPTION 授予角色本应阻止被授予者向该角色添加或移除成员，但这一限制很容易通过先执行 SET ROLE 绕过。其安全影响主要在于角色成员可以撤销其他人的访问权限，这违背了授权者的意愿。未经批准添加角色成员的影响相对较小，因为不配合的角色成员本来就可以通过创建视图或 SECURITY DEFINER 函数把自己的大部分权限提供给他人。（CVE-2014-0060）","title":"加固 GRANT ... WITH ADMIN OPTION 的限制","variants":[],"version":"9.3.3"},{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["1d701d28a","23b5a85e6","537cbd35c","823b9dc25","c0ac4c75f","fc4a04a3c"],"commit_groups":[["1d701d28a","23b5a85e6","537cbd35c","823b9dc25","c0ac4c75f","fc4a04a3c"]],"commits":[],"cves":["CVE-2014-0061"],"db_id":"95e3f5c8f5cd2edeccb1fb4455fee2da","html":"\u003cp\u003e防止通过手工调用 PL 验证器函数进行权限提升（Andres Freund）\u003c/p\u003e\n\u003cp\u003ePL 验证器函数的主要角色是在 \u003ccode\u003eCREATE FUNCTION\u003c/code\u003e 期间被隐式调用，但它们也是普通 SQL 函数，用户可以显式调用。对实际以其他语言编写的函数调用验证器此前未被检查，可能被用于权限提升。修复方法是在每个验证器函数中加入对权限检查函数的调用。非核心过程语言如果自带验证器函数，也需要做同样的修改。（CVE-2014-0061）\u003c/p\u003e","id":"9.3.3-cf0ad82d2d3b3b4e","identity_text":"Prevent privilege escalation via manual calls to PL validator functions (Andres Freund) The primary role of PL validator functions is to be called implicitly during CREATE FUNCTION, but they are also normal SQL functions that a user can call explicitly. Calling a validator on a function actually written in some other language was not checked for and could be exploited for privilege-escalation purposes. The fix involves adding a call to a privilege-checking function in each validator function. Non-core procedural languages will also need to make this change to their own validator functions, if any. (CVE-2014-0061)","part":"changes","patch_ids":["c3ab414af7489aed3400d1ba66af2d8e"],"related_changes":[{"db_id":"fae61d73481179b6c74904102e9e2d86","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"防止通过手工调用 PL 验证器函数进行权限提升","url":"/docs/compare/?release=9.2.7#9.2.7-cf0ad82d2d3b3b4e","version":"9.2.7"},{"db_id":"02c1da92f538c5c6ea8ef875af38da59","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"防止通过手工调用 PL 验证器函数进行权限提升","url":"/docs/compare/?release=9.1.12#9.1.12-cf0ad82d2d3b3b4e","version":"9.1.12"},{"db_id":"a9eb85599c0056790df203d46916a55a","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"防止通过手工调用 PL 验证器函数进行权限提升","url":"/docs/compare/?release=9.0.16#9.0.16-cf0ad82d2d3b3b4e","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"},"rule":2,"target":"02c1da92f538c5c6ea8ef875af38da59","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"},"rule":2,"target":"a9eb85599c0056790df203d46916a55a","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"},"rule":2,"target":"fae61d73481179b6c74904102e9e2d86","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["fc4a04a3c"],"source_entry_id":"9.3.3/changes/002","source_hash":"996f7829e9a5f62bf0f9cd98987d27d06cbdef4f3f01686ac09857f1a68851f4","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db","text":"防止通过手工调用 PL 验证器函数进行权限提升（Andres Freund） PL 验证器函数的主要角色是在 CREATE FUNCTION 期间被隐式调用，但它们也是普通 SQL 函数，用户可以显式调用。对实际以其他语言编写的函数调用验证器此前未被检查，可能被用于权限提升。修复方法是在每个验证器函数中加入对权限检查函数的调用。非核心过程语言如果自带验证器函数，也需要做同样的修改。（CVE-2014-0061）","title":"防止通过手工调用 PL 验证器函数进行权限提升","variants":[],"version":"9.3.3"},{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["43d4e965e","5f173040e","820ab11fb","b5c574399","e1e0a4d79","e46476133"],"commit_groups":[["43d4e965e","5f173040e","820ab11fb","b5c574399","e1e0a4d79","e46476133"]],"commits":[],"cves":["CVE-2014-0062"],"db_id":"2c79866e4eaa6e21ca64fcf166ffbe34","html":"\u003cp\u003e避免在表和索引 DDL 期间进行多次名称查找（Robert Haas、Andres Freund）\u003c/p\u003e\n\u003cp\u003e如果由于并发活动导致名称查找得出不同结论，我们可能会对不同的表执行 DDL 的不同部分。至少在 \u003ccode\u003eCREATE INDEX\u003c/code\u003e 的情况下，这可被用来让权限检查针对与索引创建不同的表执行，从而造成权限提升攻击。（CVE-2014-0062）\u003c/p\u003e","id":"9.3.3-76a21e41869b218b","identity_text":"Avoid multiple name lookups during table and index DDL (Robert Haas, Andres Freund) If the name lookups come to different conclusions due to concurrent activity, we might perform some parts of the DDL on a different table than other parts. At least in the case of CREATE INDEX, this can be used to cause the permissions checks to be performed against a different table than the index creation, allowing for a privilege escalation attack. (CVE-2014-0062)","part":"changes","patch_ids":["dbe8b2a09dc6e83c1c93615907448293"],"related_changes":[{"db_id":"86482abe5b27ee8f0d69a73a4dbcf5b8","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"避免在表和索引 DDL 期间进行多次名称查找","url":"/docs/compare/?release=9.2.7#9.2.7-76a21e41869b218b","version":"9.2.7"},{"db_id":"8e317c93dde468d19fb18a404e9d1206","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"避免在表和索引 DDL 期间进行多次名称查找","url":"/docs/compare/?release=9.1.12#9.1.12-76a21e41869b218b","version":"9.1.12"},{"db_id":"f475983d0e117e81b5004e5573ac47a6","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"避免在表和索引 DDL 期间进行多次名称查找","url":"/docs/compare/?release=9.0.16#9.0.16-76a21e41869b218b","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"},"rule":2,"target":"86482abe5b27ee8f0d69a73a4dbcf5b8","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"},"rule":2,"target":"8e317c93dde468d19fb18a404e9d1206","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"},"rule":2,"target":"f475983d0e117e81b5004e5573ac47a6","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["e1e0a4d79"],"source_entry_id":"9.3.3/changes/003","source_hash":"93deea8759038475a1db343860970300dcde0b0cc3a3d8000fbd41089dda6c4a","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70","text":"避免在表和索引 DDL 期间进行多次名称查找（Robert Haas、Andres Freund） 如果由于并发活动导致名称查找得出不同结论，我们可能会对不同的表执行 DDL 的不同部分。至少在 CREATE INDEX 的情况下，这可被用来让权限检查针对与索引创建不同的表执行，从而造成权限提升攻击。（CVE-2014-0062）","title":"避免在表和索引 DDL 期间进行多次名称查找","variants":[],"version":"9.3.3"},{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["4318daecc","6a10e57b0","b9c3bb1b3","d0ed1a6c0","e4a4fa223","f416622be"],"commit_groups":[["4318daecc","6a10e57b0","b9c3bb1b3","d0ed1a6c0","e4a4fa223","f416622be"]],"commits":[],"cves":["CVE-2014-0063"],"db_id":"eaa396302537066d7d33df5fd483d229","html":"\u003cp\u003e防止长日期时间字符串造成缓冲区越界（Noah Misch）\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003eMAXDATELEN\u003c/code\u003e 常量对于 \u003ccode\u003einterval\u003c/code\u003e 类型可能的最长值来说太小，导致 \u003ccode\u003einterval_out()\u003c/code\u003e 中可能出现缓冲区越界。虽然日期时间输入函数在避免缓冲区越界方面更谨慎，但该限制仍短到导致它们拒绝某些有效输入，例如包含很长时区名的输入。\u003cspan\u003eecpg\u003c/span\u003e 库存在这些漏洞以及它自身的一些漏洞。（CVE-2014-0063）\u003c/p\u003e","id":"9.3.3-0b66a90264406c0c","identity_text":"Prevent buffer overrun with long datetime strings (Noah Misch) The MAXDATELEN constant was too small for the longest possible value of type interval, allowing a buffer overrun in interval_out(). Although the datetime input functions were more careful about avoiding buffer overrun, the limit was short enough to cause them to reject some valid inputs, such as input containing a very long timezone name. The ecpg library contained these vulnerabilities along with some of its own. (CVE-2014-0063)","part":"changes","patch_ids":["28dc88a032cb8ff982b84a997e239466"],"related_changes":[{"db_id":"b733e717191113378d5efd83b0b4f2ad","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a7cb2b574435cbd471861ce714ff5285890bf353d7c97361c2642326595a07a3"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"防止长日期时间字符串造成缓冲区越界","url":"/docs/compare/?release=9.2.7#9.2.7-0b66a90264406c0c","version":"9.2.7"},{"db_id":"8f6a29f411be2e570d2f9e488585081d","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a7cb2b574435cbd471861ce714ff5285890bf353d7c97361c2642326595a07a3"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"防止长日期时间字符串造成缓冲区越界","url":"/docs/compare/?release=9.1.12#9.1.12-0b66a90264406c0c","version":"9.1.12"},{"db_id":"8e353e29b7ab130639fce6533f56dea2","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a7cb2b574435cbd471861ce714ff5285890bf353d7c97361c2642326595a07a3"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"防止长日期时间字符串造成缓冲区越界","url":"/docs/compare/?release=9.0.16#9.0.16-0b66a90264406c0c","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a7cb2b574435cbd471861ce714ff5285890bf353d7c97361c2642326595a07a3"},"rule":2,"target":"8e353e29b7ab130639fce6533f56dea2","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a7cb2b574435cbd471861ce714ff5285890bf353d7c97361c2642326595a07a3"},"rule":2,"target":"8f6a29f411be2e570d2f9e488585081d","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a7cb2b574435cbd471861ce714ff5285890bf353d7c97361c2642326595a07a3"},"rule":2,"target":"b733e717191113378d5efd83b0b4f2ad","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["e4a4fa223"],"source_entry_id":"9.3.3/changes/004","source_hash":"46e066b9e04ac05d8079309086ea40e096090505f44066b6a7b05ddead083213","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"a7cb2b574435cbd471861ce714ff5285890bf353d7c97361c2642326595a07a3","text":"防止长日期时间字符串造成缓冲区越界（Noah Misch） MAXDATELEN 常量对于 interval 类型可能的最长值来说太小，导致 interval_out() 中可能出现缓冲区越界。虽然日期时间输入函数在避免缓冲区越界方面更谨慎，但该限制仍短到导致它们拒绝某些有效输入，例如包含很长时区名的输入。ecpg 库存在这些漏洞以及它自身的一些漏洞。（CVE-2014-0063）","title":"防止长日期时间字符串造成缓冲区越界","variants":[],"version":"9.3.3"},{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["0b7026d96","12bbce15d","2c3203e18","31400a673","7a362a176","98be8a6ea"],"commit_groups":[["0b7026d96","12bbce15d","2c3203e18","31400a673","7a362a176","98be8a6ea"]],"commits":[],"cves":["CVE-2014-0064"],"db_id":"b037db4e2b1ee88e92ccf73cddee5112","html":"\u003cp\u003e防止大小计算中的整数溢出导致缓冲区越界（Noah Misch、Heikki Linnakangas）\u003c/p\u003e\n\u003cp\u003e若干函数（大多是类型输入函数）在计算分配大小时未检查溢出。如果发生溢出，就会分配过小的缓冲区并被写越界。（CVE-2014-0064）\u003c/p\u003e","id":"9.3.3-a0252db5e81ebdfb","identity_text":"Prevent buffer overrun due to integer overflow in size calculations (Noah Misch, Heikki Linnakangas) Several functions, mostly type input functions, calculated an allocation size without checking for overflow. If overflow did occur, a too-small buffer would be allocated and then written past. (CVE-2014-0064)","part":"changes","patch_ids":["673abf14fef49521b271fb1d0b558420"],"related_changes":[{"db_id":"524ce52e603c56d2b6d29ce8bd8554ce","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"防止大小计算中的整数溢出导致缓冲区越界","url":"/docs/compare/?release=9.2.7#9.2.7-a0252db5e81ebdfb","version":"9.2.7"},{"db_id":"ab9fc7f01fa6040e520b53dbe02bf539","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"防止大小计算中的整数溢出导致缓冲区越界","url":"/docs/compare/?release=9.1.12#9.1.12-a0252db5e81ebdfb","version":"9.1.12"},{"db_id":"b61e618ef531b83260a118f3e710803e","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"防止大小计算中的整数溢出导致缓冲区越界","url":"/docs/compare/?release=9.0.16#9.0.16-a0252db5e81ebdfb","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"},"rule":2,"target":"524ce52e603c56d2b6d29ce8bd8554ce","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"},"rule":2,"target":"ab9fc7f01fa6040e520b53dbe02bf539","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"},"rule":2,"target":"b61e618ef531b83260a118f3e710803e","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["7a362a176"],"source_entry_id":"9.3.3/changes/005","source_hash":"041d07edca033259e1a23c7631e7e09f3016916b36560523c331786a069df5aa","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac","text":"防止大小计算中的整数溢出导致缓冲区越界（Noah Misch、Heikki Linnakangas） 若干函数（大多是类型输入函数）在计算分配大小时未检查溢出。如果发生溢出，就会分配过小的缓冲区并被写越界。（CVE-2014-0064）","title":"防止大小计算中的整数溢出导致缓冲区越界","variants":[],"version":"9.3.3"},{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["01824385a","45bf2404a","4741e3160","655b665f7","69d2bc14a","e3208fec3"],"commit_groups":[["01824385a","45bf2404a","4741e3160","655b665f7","69d2bc14a","e3208fec3"]],"commits":[],"cves":["CVE-2014-0065"],"db_id":"36614e60ac7ac982d1f4efe65d9c4df8","html":"\u003cp\u003e防止固定大小缓冲区越界（Peter Eisentraut、Jozef Mlich）\u003c/p\u003e\n\u003cp\u003e使用 \u003ccode\u003estrlcpy()\u003c/code\u003e 及相关函数，以明确保证固定大小缓冲区不会被越界写入。与前面几项不同，这些情况是否真的构成现实问题尚不清楚，因为在大多数情况下，输入字符串的大小似乎已有先前约束。尽管如此，消除所有此类 Coverity 警告似乎是明智的。（CVE-2014-0065）\u003c/p\u003e","id":"9.3.3-c669fac45788e34c","identity_text":"Prevent overruns of fixed-size buffers (Peter Eisentraut, Jozef Mlich) Use strlcpy() and related functions to provide a clear guarantee that fixed-size buffers are not overrun. Unlike the preceding items, it is unclear whether these cases really represent live issues, since in most cases there appear to be previous constraints on the size of the input string. Nonetheless it seems prudent to silence all Coverity warnings of this type. (CVE-2014-0065)","part":"changes","patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"related_changes":[{"db_id":"783d9c90c3867e10e3a26c550f9567a2","evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"same_day":true},"kind":"related","label":"9.3.3","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","title":"避免在 crypt() 返回 NULL 时崩溃","url":"/docs/compare/?release=9.3.3#9.3.3-14f78cee37d06ff3","version":"9.3.3"},{"db_id":"1ed5105b349baf71c428a98857eb15cf","evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"8f6d25b5d79f5c83220401d8459a1934e47de7b1c50441d0aa7cd5f6d20afbcb"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"防止固定大小缓冲区越界","url":"/docs/compare/?release=9.2.7#9.2.7-c669fac45788e34c","version":"9.2.7"},{"db_id":"9cd052fae9c1b35526531bf64b222501","evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"8f6d25b5d79f5c83220401d8459a1934e47de7b1c50441d0aa7cd5f6d20afbcb"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"防止固定大小缓冲区越界","url":"/docs/compare/?release=9.1.12#9.1.12-c669fac45788e34c","version":"9.1.12"},{"db_id":"63a3d5232781e5fb91c3705fff0779a6","evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"8f6d25b5d79f5c83220401d8459a1934e47de7b1c50441d0aa7cd5f6d20afbcb"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"防止固定大小缓冲区越界","url":"/docs/compare/?release=9.0.16#9.0.16-c669fac45788e34c","version":"9.0.16"}],"relations":[{"evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"8f6d25b5d79f5c83220401d8459a1934e47de7b1c50441d0aa7cd5f6d20afbcb"},"rule":2,"target":"1ed5105b349baf71c428a98857eb15cf","type":"equivalent"},{"evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"8f6d25b5d79f5c83220401d8459a1934e47de7b1c50441d0aa7cd5f6d20afbcb"},"rule":2,"target":"63a3d5232781e5fb91c3705fff0779a6","type":"equivalent"},{"evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"same_day":true},"rule":2,"target":"783d9c90c3867e10e3a26c550f9567a2","type":"related"},{"evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"8f6d25b5d79f5c83220401d8459a1934e47de7b1c50441d0aa7cd5f6d20afbcb"},"rule":2,"target":"9cd052fae9c1b35526531bf64b222501","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["e3208fec3"],"source_entry_id":"9.3.3/changes/006","source_hash":"e4c083c1cde1324b0850c78b9c91e57d006fa1fd7ba4f6c13bece0e66b93ace1","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"8f6d25b5d79f5c83220401d8459a1934e47de7b1c50441d0aa7cd5f6d20afbcb","text":"防止固定大小缓冲区越界（Peter Eisentraut、Jozef Mlich） 使用 strlcpy() 及相关函数，以明确保证固定大小缓冲区不会被越界写入。与前面几项不同，这些情况是否真的构成现实问题尚不清楚，因为在大多数情况下，输入字符串的大小似乎已有先前约束。尽管如此，消除所有此类 Coverity 警告似乎是明智的。（CVE-2014-0065）","title":"防止固定大小缓冲区越界","variants":[],"version":"9.3.3"},{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["01824385a","45bf2404a","4741e3160","655b665f7","69d2bc14a","e3208fec3"],"commit_groups":[["01824385a","45bf2404a","4741e3160","655b665f7","69d2bc14a","e3208fec3"]],"commits":[],"cves":["CVE-2014-0066"],"db_id":"783d9c90c3867e10e3a26c550f9567a2","html":"\u003cp\u003e避免在 \u003ccode\u003ecrypt()\u003c/code\u003e 返回 NULL 时崩溃（Honza Horak、Bruce Momjian）\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003ecrypt()\u003c/code\u003e 可能返回 NULL 的场景相对较少，但如果发生，\u003ccode\u003econtrib/chkpass\u003c/code\u003e 就会崩溃。一个可能出问题的实际情况是 \u003cspan\u003elibc\u003c/span\u003e 被配置为拒绝执行未获批准的哈希算法（例如 \u003cspan\u003e“\u003cspan\u003eFIPS 模式\u003c/span\u003e”\u003c/span\u003e）。（CVE-2014-0066）\u003c/p\u003e","id":"9.3.3-14f78cee37d06ff3","identity_text":"Avoid crashing if crypt() returns NULL (Honza Horak, Bruce Momjian) There are relatively few scenarios in which crypt() could return NULL, but contrib/chkpass would crash if it did. One practical case in which this could be an issue is if libc is configured to refuse to execute unapproved hashing algorithms (e.g., FIPS mode). (CVE-2014-0066)","part":"changes","patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"related_changes":[{"db_id":"36614e60ac7ac982d1f4efe65d9c4df8","evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"same_day":true},"kind":"related","label":"9.3.3","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","title":"防止固定大小缓冲区越界","url":"/docs/compare/?release=9.3.3#9.3.3-c669fac45788e34c","version":"9.3.3"},{"db_id":"eb6f4ecb26305d5a5de1728921f0e47e","evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"016fe2a828ba5eef1ed7ce7066ca9088596c6b2b74af74ff6dc0744d3d9b02af"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"避免在 crypt() 返回 NULL 时崩溃","url":"/docs/compare/?release=9.2.7#9.2.7-14f78cee37d06ff3","version":"9.2.7"},{"db_id":"83006328c688bbe0cdd39e4c22f5f6db","evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"016fe2a828ba5eef1ed7ce7066ca9088596c6b2b74af74ff6dc0744d3d9b02af"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"避免在 crypt() 返回 NULL 时崩溃","url":"/docs/compare/?release=9.1.12#9.1.12-14f78cee37d06ff3","version":"9.1.12"},{"db_id":"47f79e882acc8d75d3b6d00f09266c32","evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"016fe2a828ba5eef1ed7ce7066ca9088596c6b2b74af74ff6dc0744d3d9b02af"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"避免在 crypt() 返回 NULL 时崩溃","url":"/docs/compare/?release=9.0.16#9.0.16-14f78cee37d06ff3","version":"9.0.16"}],"relations":[{"evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"same_day":true},"rule":2,"target":"36614e60ac7ac982d1f4efe65d9c4df8","type":"related"},{"evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"016fe2a828ba5eef1ed7ce7066ca9088596c6b2b74af74ff6dc0744d3d9b02af"},"rule":2,"target":"47f79e882acc8d75d3b6d00f09266c32","type":"equivalent"},{"evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"016fe2a828ba5eef1ed7ce7066ca9088596c6b2b74af74ff6dc0744d3d9b02af"},"rule":2,"target":"83006328c688bbe0cdd39e4c22f5f6db","type":"equivalent"},{"evidence":{"ambiguous_patch_ids":["4142c4a7e713d31966f7837b92fb2b52"],"patch_ids":[],"same_day":true,"statement_hash":"016fe2a828ba5eef1ed7ce7066ca9088596c6b2b74af74ff6dc0744d3d9b02af"},"rule":2,"target":"eb6f4ecb26305d5a5de1728921f0e47e","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["e3208fec3"],"source_entry_id":"9.3.3/changes/007","source_hash":"1ae9fdb6c269b01e423effeef4d721601005e95d248f194e47608d2d3be3c387","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"016fe2a828ba5eef1ed7ce7066ca9088596c6b2b74af74ff6dc0744d3d9b02af","text":"避免在 crypt() 返回 NULL 时崩溃（Honza Horak、Bruce Momjian） crypt() 可能返回 NULL 的场景相对较少，但如果发生，contrib/chkpass 就会崩溃。一个可能出问题的实际情况是 libc 被配置为拒绝执行未获批准的哈希算法（例如 “FIPS 模式”）。（CVE-2014-0066）","title":"避免在 crypt() 返回 NULL 时崩溃","variants":[],"version":"9.3.3"},{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["1ec5988f3","369c229d2","6ef325429","800a3744b","f58663ab1","ff3d533e5"],"commit_groups":[["1ec5988f3","369c229d2","6ef325429","800a3744b","f58663ab1","ff3d533e5"]],"commits":[],"cves":["CVE-2014-0067"],"db_id":"1fc7ca6d4d85f594eed0141b6b08fef5","html":"\u003cp\u003e在回归测试说明中记录 \u003ccode\u003emake check\u003c/code\u003e 的风险（Noah Misch、Tom Lane）\u003c/p\u003e\n\u003cp\u003e由于 \u003ccode\u003emake check\u003c/code\u003e 启动的临时服务器使用 \u003cspan\u003e“\u003cspan\u003etrust\u003c/span\u003e”\u003c/span\u003e 认证，同一台机器上的其他用户可以以数据库超级用户身份连接它，进而可能利用启动测试的操作系统用户的权限。未来版本可能会在测试流程中加入防止此风险的变更，但需要先进行一些公开讨论。因此目前只是警告：当同一台机器上存在不受信任的用户时，不要使用 \u003ccode\u003emake check\u003c/code\u003e。（CVE-2014-0067）\u003c/p\u003e","id":"9.3.3-10731528cb521bec","identity_text":"Document risks of make check in the regression testing instructions (Noah Misch, Tom Lane) Since the temporary server started by make check uses trust authentication, another user on the same machine could connect to it as database superuser, and then potentially exploit the privileges of the operating-system user who started the tests. A future release will probably incorporate changes in the testing procedure to prevent this risk, but some public discussion is needed first. So for the moment, just warn people against using make check when there are untrusted users on the same machine. (CVE-2014-0067)","part":"changes","patch_ids":["fe6e333c5c753f1ac3da4fc0df41c469"],"related_changes":[{"db_id":"8152bce71f31ab46c9501acebe8824b1","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"在回归测试说明中记录 make check 的风险","url":"/docs/compare/?release=9.2.7#9.2.7-10731528cb521bec","version":"9.2.7"},{"db_id":"d832db97db43a8964c530c6f3561fa82","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"在回归测试说明中记录 make check 的风险","url":"/docs/compare/?release=9.1.12#9.1.12-10731528cb521bec","version":"9.1.12"},{"db_id":"1de82313af07dfbea3232d47d8ab78b1","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"在回归测试说明中记录 make check 的风险","url":"/docs/compare/?release=9.0.16#9.0.16-10731528cb521bec","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"},"rule":2,"target":"1de82313af07dfbea3232d47d8ab78b1","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"},"rule":2,"target":"8152bce71f31ab46c9501acebe8824b1","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"},"rule":2,"target":"d832db97db43a8964c530c6f3561fa82","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["1ec5988f3"],"source_entry_id":"9.3.3/changes/008","source_hash":"58f7fde8d209eeeb6dcff660292b11b60b6b5e0db58ad59490be114f3d497835","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342","text":"在回归测试说明中记录 make check 的风险（Noah Misch、Tom Lane） 由于 make check 启动的临时服务器使用 “trust” 认证，同一台机器上的其他用户可以以数据库超级用户身份连接它，进而可能利用启动测试的操作系统用户的权限。未来版本可能会在测试流程中加入防止此风险的变更，但需要先进行一些公开讨论。因此目前只是警告：当同一台机器上存在不受信任的用户时，不要使用 make check。（CVE-2014-0067）","title":"在回归测试说明中记录 make check 的风险","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["3b97e6823","8e9a16ab8"],"commit_groups":[["3b97e6823","8e9a16ab8"]],"commits":[],"cves":[],"db_id":"72b9ca077a92280d95e171983c8840c2","html":"\u003cp\u003e重做元组冻结协议（Álvaro Herrera、Andres Freund）\u003c/p\u003e\n\u003cp\u003e元组冻结逻辑无法处理某些涉及\u003ca href=\"/docs/9.3/maintenance.html#VACUUM-FOR-MULTIXACT-WRAPAROUND\" title=\"23.1.5.1. 多事务与回卷\"\u003e\u003cem\u003e多事务\u003c/em\u003e ID\u003c/a\u003e冻结的情况，实际影响是共享行级锁在足够老之后可能被遗忘。\u003c/p\u003e\n\u003cp\u003e修复此问题需要更改元组冻结的 WAL 记录格式。这对独立服务器不成问题，但在使用复制时意味着\u003cspan\u003e\u003cem\u003e备库服务器必须先于其主库升级到 9.3.3 或更高版本\u003c/em\u003e\u003c/span\u003e。较旧的备库将无法解释较新主库生成的冻结记录，并以 PANIC 消息失败。（在这种情况下，升级备库应足以让它恢复执行。）\u003c/p\u003e","id":"9.3.3-d3e93e3b883b7e05","identity_text":"Rework tuple freezing protocol (Álvaro Herrera, Andres Freund) The logic for tuple freezing was unable to handle some cases involving freezing of multixact IDs, with the practical effect that shared row-level locks might be forgotten once old enough. Fixing this required changing the WAL record format for tuple freezing. While this is no issue for standalone servers, when using replication it means that standby servers must be upgraded to 9.3.3 or later before their masters are. An older standby will be unable to interpret freeze records generated by a newer master, and will fail with a PANIC message. (In such a case, upgrading the standby should be sufficient to let it resume execution.)","part":"changes","patch_ids":["818207a186075f0edcb6e8122cb8d65c"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["8e9a16ab8"],"source_entry_id":"9.3.3/changes/009","source_hash":"464b2ff1454b5ab83260140d2e88ce3bc57f9af80caf8235c5390d17a5af0944","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"54df1e5ef45edf394b34afb8dfc8b47b55e82ee9e828d6ce6ddc1e4e5c49cf49","text":"重做元组冻结协议（Álvaro Herrera、Andres Freund） 元组冻结逻辑无法处理某些涉及多事务 ID冻结的情况，实际影响是共享行级锁在足够老之后可能被遗忘。 修复此问题需要更改元组冻结的 WAL 记录格式。这对独立服务器不成问题，但在使用复制时意味着备库服务器必须先于其主库升级到 9.3.3 或更高版本。较旧的备库将无法解释较新主库生成的冻结记录，并以 PANIC 消息失败。（在这种情况下，升级备库应足以让它恢复执行。）","title":"重做元组冻结协议","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["801c2dc72","fb47de2be"],"commit_groups":[["801c2dc72","fb47de2be"]],"commits":[],"cves":[],"db_id":"cf70f145a254ab85f1f5337045bf80e0","html":"\u003cp\u003e创建单独的 GUC 参数来控制多事务冻结（Álvaro Herrera）\u003c/p\u003e\n\u003cp\u003e9.3 要求在多事务元组标签变得过老之前将其冻结，这与普通事务 ID 标签一段时间以来的冻结方式相同。此前，事务 ID 冻结参数也用于多事务 ID；但由于事务 ID 和多事务 ID 的消耗速率可能相差很大，这种做法效果不佳。现已引入新设置\u003ca href=\"/docs/9.3/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-MIN-AGE\"\u003evacuum_multixact_freeze_min_age\u003c/a\u003e、\u003ca href=\"/docs/9.3/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE\"\u003evacuum_multixact_freeze_table_age\u003c/a\u003e和\u003ca href=\"/docs/9.3/runtime-config-autovacuum.html#GUC-AUTOVACUUM-MULTIXACT-FREEZE-MAX-AGE\"\u003eautovacuum_multixact_freeze_max_age\u003c/a\u003e来控制何时冻结多事务。\u003c/p\u003e","id":"9.3.3-f09d96da5cc35978","identity_text":"Create separate GUC parameters to control multixact freezing (Álvaro Herrera) 9.3 requires multixact tuple labels to be frozen before they grow too old, in the same fashion as plain transaction ID labels have been frozen for some time. Previously, the transaction ID freezing parameters were used for multixact IDs too; but since the consumption rates of transaction IDs and multixact IDs can be quite different, this did not work very well. Introduce new settings guc-vacuum-multixact-freeze-min-age , guc-vacuum-multixact-freeze-table-age , and guc-autovacuum-multixact-freeze-max-age to control when to freeze multixacts.","part":"changes","patch_ids":["ba7040142fd00b6fdc785193d3ebc77e"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["fb47de2be"],"source_entry_id":"9.3.3/changes/010","source_hash":"a5372ff93bbfa30a88d8ee61898750818e5b74ab38a71d1ca2fce93d0452a3c5","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"e023ce6e84b59a5ee27e9b6ed729b596972ee81db72a3b99594a695b88b2d90e","text":"创建单独的 GUC 参数来控制多事务冻结（Álvaro Herrera） 9.3 要求在多事务元组标签变得过老之前将其冻结，这与普通事务 ID 标签一段时间以来的冻结方式相同。此前，事务 ID 冻结参数也用于多事务 ID；但由于事务 ID 和多事务 ID 的消耗速率可能相差很大，这种做法效果不佳。现已引入新设置vacuum_multixact_freeze_min_age、vacuum_multixact_freeze_table_age和autovacuum_multixact_freeze_max_age来控制何时冻结多事务。","title":"创建单独的 GUC 参数来控制多事务冻结","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["11ac4c73c","db1014bc4"],"commit_groups":[["11ac4c73c","db1014bc4"]],"commits":[],"cves":[],"db_id":"be59d318059564f82c292f2af5625602","html":"\u003cp\u003e把本地更新传播的远程行锁考虑在内（Álvaro Herrera）\u003c/p\u003e\n\u003cp\u003e如果某行被事务 A 锁定，而事务 B 更新了它，B 创建的新行版本会被 A 锁定，却只对 B 可见。如果事务 B 随后再次更新该行，A 的锁不会被检查，从而可能允许 B 在不该完成时完成。这种情况是 9.3 新出现的，因为之前的版本没有任何允许其他事务更新被锁行的行锁类型。\u003c/p\u003e\n\u003cp\u003e这一疏忽可能导致引用完整性检查给出假阳性（例如允许本应被拒绝的删除）。使用新命令 \u003ccode\u003eSELECT FOR KEY SHARE\u003c/code\u003e 和 \u003ccode\u003eSELECT FOR NO KEY UPDATE\u003c/code\u003e 的应用也可能遭遇此类锁失效。\u003c/p\u003e","id":"9.3.3-d2a6097758b986ab","identity_text":"Account for remote row locks propagated by local updates (Álvaro Herrera) If a row was locked by transaction A, and transaction B updated it, the new version of the row created by B would be locked by A, yet visible only to B. If transaction B then again updated the row, A's lock wouldn't get checked, thus possibly allowing B to complete when it shouldn't. This case is new in 9.3 since prior versions did not have any types of row locking that would permit another transaction to update the row at all. This oversight could allow referential integrity checks to give false positives (for instance, allow deletes that should have been rejected). Applications using the new commands SELECT FOR KEY SHARE and SELECT FOR NO KEY UPDATE might also have suffered locking failures of this kind.","part":"changes","patch_ids":["edc07c4bbd4b830bd309a982c8f98aee"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["db1014bc4"],"source_entry_id":"9.3.3/changes/011","source_hash":"10e6f6dd1b7d88bc88e4f098740e051706f9f49d9d4f3d90503e28a8a27d3f4b","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"beafb62aa75ec61052112c474a7e145a99c6779531f1bbe0bea25b93a7b58024","text":"把本地更新传播的远程行锁考虑在内（Álvaro Herrera） 如果某行被事务 A 锁定，而事务 B 更新了它，B 创建的新行版本会被 A 锁定，却只对 B 可见。如果事务 B 随后再次更新该行，A 的锁不会被检查，从而可能允许 B 在不该完成时完成。这种情况是 9.3 新出现的，因为之前的版本没有任何允许其他事务更新被锁行的行锁类型。 这一疏忽可能导致引用完整性检查给出假阳性（例如允许本应被拒绝的删除）。使用新命令 SELECT FOR KEY SHARE 和 SELECT FOR NO KEY UPDATE 的应用也可能遭遇此类锁失效。","title":"把本地更新传播的远程行锁考虑在内","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["07aeb1fec","c6cd27e36"],"commit_groups":[["07aeb1fec","c6cd27e36"]],"commits":[],"cves":[],"db_id":"bcdf40cc5e020a75f49ad8c2046c5b55","html":"\u003cp\u003e防止当某个行锁的多个持有者之一中止时\u003cspan\u003e“\u003cspan\u003e遗忘\u003c/span\u003e”\u003c/span\u003e有效的行锁（Álvaro Herrera）\u003c/p\u003e\n\u003cp\u003e这是共享行锁可能丢失的又一种机制，因此可能允许本应被外键约束阻止的更新。\u003c/p\u003e","id":"9.3.3-e1e64f1e6d7dbedc","identity_text":"Prevent forgetting valid row locks when one of several holders of a row lock aborts (Álvaro Herrera) This was yet another mechanism by which a shared row lock could be lost, thus possibly allowing updates that should have been prevented by foreign-key constraints.","part":"changes","patch_ids":["4a190af0294f19ae828f1e44d0e0e2e5"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["c6cd27e36"],"source_entry_id":"9.3.3/changes/012","source_hash":"3976cdc032865f362f536ba2f1b0b0e830dd703ae390839985bf161ded76a40e","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"e9596678e062a838a2595a9ea2846cfa4fb8506ea6530df4d501b3bcab3a8bf6","text":"防止当某个行锁的多个持有者之一中止时“遗忘”有效的行锁（Álvaro Herrera） 这是共享行锁可能丢失的又一种机制，因此可能允许本应被外键约束阻止的更新。","title":"防止当某个行锁的多个持有者之一中止时“遗忘”有效的行锁","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2dcc48c35","312bde3d4"],"commit_groups":[["2dcc48c35","312bde3d4"]],"commits":[],"cves":[],"db_id":"e302c0873214d41995628dcee4d2d984","html":"\u003cp\u003e修复更新链锁定期间的错误逻辑（Álvaro Herrera）\u003c/p\u003e\n\u003cp\u003e这一失误可能导致在 \u003ccode\u003eREPEATABLE READ\u003c/code\u003e 和 \u003ccode\u003eSERIALIZABLE\u003c/code\u003e 事务隔离模式下出现虚假的 \u003cspan\u003e“\u003cspan\u003ecould not serialize access due to concurrent update\u003c/span\u003e”\u003c/span\u003e 错误。\u003c/p\u003e","id":"9.3.3-66c49529f45324da","identity_text":"Fix incorrect logic during update chain locking (Álvaro Herrera) This mistake could result in spurious could not serialize access due to concurrent update errors in REPEATABLE READ and SERIALIZABLE transaction isolation modes.","part":"changes","patch_ids":["36b7da294e1808f2b189dac69786a6b1"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["2dcc48c35"],"source_entry_id":"9.3.3/changes/013","source_hash":"047f522c7e74f040e0e2801af3138671c0f438acc457b84fdbf4d0c9f5517f95","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"8698cbd4f974d6c7de69b5ad1bf646cc27beccd93860fb158970ec9e5c334f75","text":"修复更新链锁定期间的错误逻辑（Álvaro Herrera） 这一失误可能导致在 REPEATABLE READ 和 SERIALIZABLE 事务隔离模式下出现虚假的 “could not serialize access due to concurrent update” 错误。","title":"修复更新链锁定期间的错误逻辑","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["03db79459","a50d97625"],"commit_groups":[["03db79459","a50d97625"]],"commits":[],"cves":[],"db_id":"219086f5a98b29e21e63cee6cb409775","html":"\u003cp\u003e在扩展或截断 \u003ccode\u003epg_multixact/members\u003c/code\u003e 时正确处理回卷（Andres Freund、Álvaro Herrera）\u003c/p\u003e","id":"9.3.3-6e6d76b302a18315","identity_text":"Handle wraparound correctly during extension or truncation of pg_multixact/members (Andres Freund, Álvaro Herrera)","part":"changes","patch_ids":["d4dd7a55b78c2135c2ef1eec657e528a"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["03db79459"],"source_entry_id":"9.3.3/changes/014","source_hash":"dbdc52dcec455e0707c9ef5ea07626be8b93a7d4eeb6971ee69af1f5ebbd0402","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"8b8adf58a6ce80e14b05878164544478c09e0610c94ce4453503474f04d7734f","text":"在扩展或截断 pg_multixact/members 时正确处理回卷（Andres Freund、Álvaro Herrera）","title":"在扩展或截断 pg_multixact/members 时正确处理回卷","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["638cf09e7","948a3dfbb"],"commit_groups":[["638cf09e7","948a3dfbb"]],"commits":[],"cves":[],"db_id":"c209bf0778c7241c37e210d33d9a6e8f","html":"\u003cp\u003e修复 \u003ccode\u003epg_multixact/members\u003c/code\u003e 中 5 位数字文件名的处理（Álvaro Herrera）\u003c/p\u003e\n\u003cp\u003e从 9.3 起，这些名称可能超过 4 位数字，但目录清理代码忽略了这类文件。\u003c/p\u003e","id":"9.3.3-9e35e0d802c01f06","identity_text":"Fix handling of 5-digit filenames in pg_multixact/members (Álvaro Herrera) As of 9.3, these names can be more than 4 digits, but the directory cleanup code ignored such files.","part":"changes","patch_ids":["8ce332b6a04de2ae00ef301b8c54e655"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["948a3dfbb"],"source_entry_id":"9.3.3/changes/015","source_hash":"3c5f744f34e72db7d59132ee657f73794280758a02dfb66a60c9714190ac5b65","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"1f211ae3b225864fdb659ea4b7b4b6e2d2d5d142f8bc4237e3945b78f4ff75f8","text":"修复 pg_multixact/members 中 5 位数字文件名的处理（Álvaro Herrera） 从 9.3 起，这些名称可能超过 4 位数字，但目录清理代码忽略了这类文件。","title":"修复 pg_multixact/members 中 5 位数字文件名的处理","variants":[],"version":"9.3.3"},{"also_in":[],"category":"performance","category_label":"Performance","commit_aliases":["0bc00363b","d881dd623"],"commit_groups":[["0bc00363b","d881dd623"]],"commits":[],"cves":[],"db_id":"079cdea3651fe786b0f287b20bcff96b","html":"\u003cp\u003e改进多事务缓存代码的性能（Álvaro Herrera）\u003c/p\u003e","id":"9.3.3-95052c9d57ce6e40","identity_text":"Improve performance of multixact cache code (Álvaro Herrera)","part":"changes","patch_ids":["16c10d9d04e66a02956ea33e7bd3d294"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["0bc00363b"],"source_entry_id":"9.3.3/changes/016","source_hash":"835e4406ebae977b675d361cbfd67006348893b850f9d83d3876dba079ada150","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"7f49bcc6fade07e3c3599885407f951ed447226456a427fef938b9bd3a16f4ba","text":"改进多事务缓存代码的性能（Álvaro Herrera）","title":"改进多事务缓存代码的性能","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["13aa62443","85d3b3c3a"],"commit_groups":[["13aa62443","85d3b3c3a"]],"commits":[],"cves":[],"db_id":"e1cd9ed03c5da7ea11f994bfd2a43d7a","html":"\u003cp\u003e优化更新已被同一事务锁定的行的过程（Andres Freund、Álvaro Herrera）\u003c/p\u003e\n\u003cp\u003e这修复了相比 9.3 之前版本在执行 \u003ccode\u003eSELECT FOR UPDATE\u003c/code\u003e 后接 \u003ccode\u003eUPDATE/DELETE\u003c/code\u003e 时的性能退化。\u003c/p\u003e","id":"9.3.3-d91eba944eb66734","identity_text":"Optimize updating a row that's already locked by the same transaction (Andres Freund, Álvaro Herrera) This fixes a performance regression from pre-9.3 versions when doing SELECT FOR UPDATE followed by UPDATE/DELETE.","part":"changes","patch_ids":["76cad24c3d339f63ba703261e7c46495"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["85d3b3c3a"],"source_entry_id":"9.3.3/changes/017","source_hash":"43eb87feeb9429c20fb59689a99ea2c620045b54874ce68d62482f92b7b9b2d9","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"591bb184b73c5d01d56e9a486d74cd73d79713e3b66c480a176fef3a134d8445","text":"优化更新已被同一事务锁定的行的过程（Andres Freund、Álvaro Herrera） 这修复了相比 9.3 之前版本在执行 SELECT FOR UPDATE 后接 UPDATE/DELETE 时的性能退化。","title":"优化更新已被同一事务锁定的行的过程","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["4d894b41c","762bd379a"],"commit_groups":[["4d894b41c","762bd379a"]],"commits":[],"cves":[],"db_id":"ba0c93f1353cafc0e11ee6dd6a8a17a2","html":"\u003cp\u003e在归档恢复期间，当归档和 \u003ccode\u003epg_xlog/\u003c/code\u003e 中存在相同 ID 的 WAL 段时，优先选择最高时间线编号（Kyotaro Horiguchi）\u003c/p\u003e\n\u003cp\u003e此前，尚未归档的段可能在恢复期间被忽略。这把 9.3.0 中一个不理想的行为变更恢复为 9.3 之前的工作方式。\u003c/p\u003e","id":"9.3.3-29dfc41b0e79e4aa","identity_text":"During archive recovery, prefer highest timeline number when WAL segments with the same ID are present in both the archive and pg_xlog/ (Kyotaro Horiguchi) Previously, not-yet-archived segments could get ignored during recovery. This reverts an undesirable behavioral change in 9.3.0 back to the way things worked pre-9.3.","part":"changes","patch_ids":["20175a42b135a8db2b4ae4d930aca431"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["762bd379a"],"source_entry_id":"9.3.3/changes/018","source_hash":"b241917050a792e730b7a7537a59c211401cd8abf5fd9d0914c8652683ae405e","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"be7f11c63f00b0799e2ad1007b409d20683442ff8ce6c37e6c6c1082b3ad3bc9","text":"在归档恢复期间，当归档和 pg_xlog/ 中存在相同 ID 的 WAL 段时，优先选择最高时间线编号（Kyotaro Horiguchi） 此前，尚未归档的段可能在恢复期间被忽略。这把 9.3.0 中一个不理想的行为变更恢复为 9.3 之前的工作方式。","title":"在归档恢复期间，当归档和 pg_xlog/ 中存在相同 ID 的 WAL 段时，优先选择最高时间线编号","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["6f2aead1f","7190f7a34","7fedd79b7","9620fede9","a69cc9b2c","bc7ab301a"],"commit_groups":[["6f2aead1f","7190f7a34","7fedd79b7","9620fede9","a69cc9b2c","bc7ab301a"]],"commits":[],"cves":[],"db_id":"25de053281805a245fab1b676779dcc4","html":"\u003cp\u003e修复当关系的某些段不是完整大小时 WAL 记录可能被错误重放的问题（Greg Stark、Tom Lane）\u003c/p\u003e\n\u003cp\u003eWAL 更新可能被应用到错误的页面，甚至可能偏后很多页。除了损坏数据外，已观察到这一错误导致备库相比主库显著\u003cspan\u003e“\u003cspan\u003e膨胀\u003c/span\u003e”\u003c/span\u003e，因为更新被应用到了远超文件末尾应在位置的地方。这种失败模式在崩溃恢复期间似乎不构成重大风险，只在初始同步从快速变化的主库基础备份创建的备库时出现。\u003c/p\u003e","id":"9.3.3-358be8d16b225d0a","identity_text":"Fix possible mis-replay of WAL records when some segments of a relation aren't full size (Greg Stark, Tom Lane) The WAL update could be applied to the wrong page, potentially many pages past where it should have been. Aside from corrupting data, this error has been observed to result in significant bloat of standby servers compared to their masters, due to updates being applied far beyond where the end-of-file should have been. This failure mode does not appear to be a significant risk during crash recovery, only when initially synchronizing a standby created from a base backup taken from a quickly-changing master.","part":"changes","patch_ids":["60e540100256cf797c1353a2c9b71210"],"related_changes":[{"db_id":"2b001c634d577b177a7b6908f8431b7e","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复当关系的某些段不是完整大小时 WAL 记录可能被错误重放的问题","url":"/docs/compare/?release=9.2.7#9.2.7-358be8d16b225d0a","version":"9.2.7"},{"db_id":"3e5bf72839871f5d922463c0b0ae582c","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复当关系的某些段不是完整大小时 WAL 记录可能被错误重放的问题","url":"/docs/compare/?release=9.1.12#9.1.12-358be8d16b225d0a","version":"9.1.12"},{"db_id":"6a64aabe3f3ed8e232a5d6564458bbf0","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复当关系的某些段不是完整大小时 WAL 记录可能被错误重放的问题","url":"/docs/compare/?release=9.0.16#9.0.16-358be8d16b225d0a","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"},"rule":2,"target":"2b001c634d577b177a7b6908f8431b7e","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"},"rule":2,"target":"3e5bf72839871f5d922463c0b0ae582c","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"},"rule":2,"target":"6a64aabe3f3ed8e232a5d6564458bbf0","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["7190f7a34"],"source_entry_id":"9.3.3/changes/019","source_hash":"67da68ededb4274d5005277f690d441d145fbca2820fe70a583da788d40a5014","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5","text":"修复当关系的某些段不是完整大小时 WAL 记录可能被错误重放的问题（Greg Stark、Tom Lane） WAL 更新可能被应用到错误的页面，甚至可能偏后很多页。除了损坏数据外，已观察到这一错误导致备库相比主库显著“膨胀”，因为更新被应用到了远超文件末尾应在位置的地方。这种失败模式在崩溃恢复期间似乎不构成重大风险，只在初始同步从快速变化的主库基础备份创建的备库时出现。","title":"修复当关系的某些段不是完整大小时 WAL 记录可能被错误重放的问题","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["425bef6ee","5301c8395","82c75f9dd","d59ff6c11","e56430c62"],"commit_groups":[["425bef6ee","5301c8395","82c75f9dd","d59ff6c11","e56430c62"]],"commits":[],"cves":[],"db_id":"a73b9eb084d1c6ae8789d3f1839e3542","html":"\u003cp\u003e修复判断恢复何时达到一致性的缺陷（Tomonari Katsumata、Heikki Linnakangas）\u003c/p\u003e\n\u003cp\u003e某些情况下，WAL 重放会错误地在重放开始时就断定数据库已一致，从而可能在数据库真正一致之前允许热备查询。也可能出现其他症状，例如 \u003cspan\u003e“\u003cspan\u003ePANIC: WAL contains references to invalid pages\u003c/span\u003e”\u003c/span\u003e。\u003c/p\u003e","id":"9.3.3-f8e05985761562f6","identity_text":"Fix bug in determining when recovery has reached consistency (Tomonari Katsumata, Heikki Linnakangas) In some cases WAL replay would mistakenly conclude that the database was already consistent at the start of replay, thus possibly allowing hot-standby queries before the database was really consistent. Other symptoms such as PANIC: WAL contains references to invalid pages were also possible.","part":"changes","patch_ids":["1f603d0dfc564b097b6b6ec1b77ef430"],"related_changes":[{"db_id":"e27ff0865920d9d12031284f043fc2ec","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复判断恢复何时达到一致性的缺陷","url":"/docs/compare/?release=9.2.7#9.2.7-f8e05985761562f6","version":"9.2.7"},{"db_id":"0ff932aeacb12930c82887b483ca71f4","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复判断恢复何时达到一致性的缺陷","url":"/docs/compare/?release=9.1.12#9.1.12-f8e05985761562f6","version":"9.1.12"},{"db_id":"0cda2f81c3b66f79b7213d869e10179f","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复判断恢复何时达到一致性的缺陷","url":"/docs/compare/?release=9.0.16#9.0.16-f8e05985761562f6","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"},"rule":2,"target":"0cda2f81c3b66f79b7213d869e10179f","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"},"rule":2,"target":"0ff932aeacb12930c82887b483ca71f4","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"},"rule":2,"target":"e27ff0865920d9d12031284f043fc2ec","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["425bef6ee"],"source_entry_id":"9.3.3/changes/020","source_hash":"f97a0e69bebd2f647bdbfd81a857b534b0a5647167f4f9c213c624983aee0a71","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07","text":"修复判断恢复何时达到一致性的缺陷（Tomonari Katsumata、Heikki Linnakangas） 某些情况下，WAL 重放会错误地在重放开始时就断定数据库已一致，从而可能在数据库真正一致之前允许热备查询。也可能出现其他症状，例如 “PANIC: WAL contains references to invalid pages”。","title":"修复判断恢复何时达到一致性的缺陷","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["615299cf6","a49633d8d"],"commit_groups":[["615299cf6","a49633d8d"]],"commits":[],"cves":[],"db_id":"983ee41764fb636c17ba709424b501a2","html":"\u003cp\u003e修复可见性映射变更的 WAL 记录（Heikki Linnakangas）\u003c/p\u003e","id":"9.3.3-f4318bf0bcdedbee","identity_text":"Fix WAL logging of visibility map changes (Heikki Linnakangas)","part":"changes","patch_ids":["5e00f57f1c609901f16866b280676bd8"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["615299cf6"],"source_entry_id":"9.3.3/changes/021","source_hash":"d76bff993f9967d90ba3707087220460a632be3ef28e54448f0292015c0f1b63","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"01a9b4f96ccd88c284172e88364476f92f30ac9413258d088adfe7856f87e50d","text":"修复可见性映射变更的 WAL 记录（Heikki Linnakangas）","title":"修复可见性映射变更的 WAL 记录","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["061b079f8","5d742b9ce","ab4bb5c47","ad2e041a3","ebde6c401"],"commit_groups":[["061b079f8","5d742b9ce","ab4bb5c47","ad2e041a3","ebde6c401"]],"commits":[],"cves":[],"db_id":"591dd475baa8f6028925cb450d25c233","html":"\u003cp\u003e修复在热备模式下重放 \u003ccode\u003eVACUUM\u003c/code\u003e 操作时对 btree 索引页的不当锁定（Andres Freund、Heikki Linnakangas、Tom Lane）\u003c/p\u003e\n\u003cp\u003e这一错误可能导致 \u003cspan\u003e“\u003cspan\u003ePANIC: WAL contains references to invalid pages\u003c/span\u003e”\u003c/span\u003e 失败。\u003c/p\u003e","id":"9.3.3-30c2210ab2f0837f","identity_text":"Fix improper locking of btree index pages while replaying a VACUUM operation in hot-standby mode (Andres Freund, Heikki Linnakangas, Tom Lane) This error could result in PANIC: WAL contains references to invalid pages failures.","part":"changes","patch_ids":["74c428ba076a344c0cf0c7ebda2875bc"],"related_changes":[{"db_id":"c7a8558d89c20ffa25ace74deb3a2c98","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复在热备模式下重放 VACUUM 操作时对 btree 索引页的不当锁定","url":"/docs/compare/?release=9.2.7#9.2.7-30c2210ab2f0837f","version":"9.2.7"},{"db_id":"267ea97c36ade4e7c3f07d9bcf5f6b19","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复在热备模式下重放 VACUUM 操作时对 btree 索引页的不当锁定","url":"/docs/compare/?release=9.1.12#9.1.12-30c2210ab2f0837f","version":"9.1.12"},{"db_id":"bc3b5b9193580c289a2ddef968dfdb5e","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复在热备模式下重放 VACUUM 操作时对 btree 索引页的不当锁定","url":"/docs/compare/?release=9.0.16#9.0.16-30c2210ab2f0837f","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"},"rule":2,"target":"267ea97c36ade4e7c3f07d9bcf5f6b19","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"},"rule":2,"target":"bc3b5b9193580c289a2ddef968dfdb5e","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"},"rule":2,"target":"c7a8558d89c20ffa25ace74deb3a2c98","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["ebde6c401"],"source_entry_id":"9.3.3/changes/022","source_hash":"d787c4fafcac3eb72b3e53d10a3f621e0915911b193b24630cee5118b32c6ad1","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55","text":"修复在热备模式下重放 VACUUM 操作时对 btree 索引页的不当锁定（Andres Freund、Heikki Linnakangas、Tom Lane） 这一错误可能导致 “PANIC: WAL contains references to invalid pages” 失败。","title":"修复在热备模式下重放 VACUUM 操作时对 btree 索引页的不当锁定","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["06df57ac6","22122c83f","67fc33d3a","760606dc5","8fd04cb32","e6acb956a"],"commit_groups":[["06df57ac6","22122c83f","67fc33d3a","760606dc5","8fd04cb32","e6acb956a"]],"commits":[],"cves":[],"db_id":"cb26e8d99d2182f4549767cb9f38a4d5","html":"\u003cp\u003e确保对 GIN 索引非叶页面的插入在合适时写入整页 WAL 记录（Heikki Linnakangas）\u003c/p\u003e\n\u003cp\u003e先前的代码在系统崩溃期间发生部分页写入时存在索引损坏风险。\u003c/p\u003e","id":"9.3.3-81cefe057af14b8d","identity_text":"Ensure that insertions into non-leaf GIN index pages write a full-page WAL record when appropriate (Heikki Linnakangas) The previous coding risked index corruption in the event of a partial-page write during a system crash.","part":"changes","patch_ids":["78c61aa2b4e3e76425d031aed17ee3b6"],"related_changes":[{"db_id":"6534a8a826b2471118bd1a76206cbef0","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"确保对 GIN 索引非叶页面的插入在合适时写入整页 WAL 记录","url":"/docs/compare/?release=9.2.7#9.2.7-81cefe057af14b8d","version":"9.2.7"},{"db_id":"76061ba322a8049243f49879f7e82f05","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"确保对 GIN 索引非叶页面的插入在合适时写入整页 WAL 记录","url":"/docs/compare/?release=9.1.12#9.1.12-81cefe057af14b8d","version":"9.1.12"},{"db_id":"2eff690870453ffcdb7349755715b1aa","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"确保对 GIN 索引非叶页面的插入在合适时写入整页 WAL 记录","url":"/docs/compare/?release=9.0.16#9.0.16-81cefe057af14b8d","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"},"rule":2,"target":"2eff690870453ffcdb7349755715b1aa","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"},"rule":2,"target":"6534a8a826b2471118bd1a76206cbef0","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"},"rule":2,"target":"76061ba322a8049243f49879f7e82f05","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["8fd04cb32"],"source_entry_id":"9.3.3/changes/023","source_hash":"7d9420d051fe88e17432dbd6318eeb46d42ec0d69cef185c15c55480a1855559","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379","text":"确保对 GIN 索引非叶页面的插入在合适时写入整页 WAL 记录（Heikki Linnakangas） 先前的代码在系统崩溃期间发生部分页写入时存在索引损坏风险。","title":"确保对 GIN 索引非叶页面的插入在合适时写入整页 WAL 记录","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0402f2441","3739e5ab9","3aefff422","3bd8987ef"],"commit_groups":[["0402f2441","3739e5ab9","3aefff422","3bd8987ef"]],"commits":[],"cves":[],"db_id":"ce43233e5ea76168cc7a0e5625b81c39","html":"\u003cp\u003e当 \u003ccode\u003epause_at_recovery_target\u003c/code\u003e 和 \u003ccode\u003erecovery_target_inclusive\u003c/code\u003e 都被设置时，确保目标记录在暂停之前而不是之后被应用（Heikki Linnakangas）\u003c/p\u003e","id":"9.3.3-191b833b4bf2154e","identity_text":"When pause_at_recovery_target and recovery_target_inclusive are both set, ensure the target record is applied before pausing, not after (Heikki Linnakangas)","part":"changes","patch_ids":["241b1fe9d89241ac044a339a91dcc673"],"related_changes":[{"db_id":"746ade29c4ae38898946d89dd2d5525f","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"67e22c6d9876beda430335f693f63b3cd456e3cb50c6413a432f2c263491c783"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"当 pause_at_recovery_target 和 recovery_target_inclusive 都被设置时，确保目标记录在暂停之前而不是之后被应用","url":"/docs/compare/?release=9.2.7#9.2.7-191b833b4bf2154e","version":"9.2.7"},{"db_id":"b058ea44777da6ac2b2c7678c15f6d88","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"67e22c6d9876beda430335f693f63b3cd456e3cb50c6413a432f2c263491c783"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"当 pause_at_recovery_target 和 recovery_target_inclusive 都被设置时，确保目标记录在暂停之前而不是之后被应用","url":"/docs/compare/?release=9.1.12#9.1.12-191b833b4bf2154e","version":"9.1.12"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"67e22c6d9876beda430335f693f63b3cd456e3cb50c6413a432f2c263491c783"},"rule":2,"target":"746ade29c4ae38898946d89dd2d5525f","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"67e22c6d9876beda430335f693f63b3cd456e3cb50c6413a432f2c263491c783"},"rule":2,"target":"b058ea44777da6ac2b2c7678c15f6d88","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["3aefff422"],"source_entry_id":"9.3.3/changes/024","source_hash":"00081388fc867511dc4d1fbd3c10e76e47c1a447bb4da920a272af4eb64908a7","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"67e22c6d9876beda430335f693f63b3cd456e3cb50c6413a432f2c263491c783","text":"当 pause_at_recovery_target 和 recovery_target_inclusive 都被设置时，确保目标记录在暂停之前而不是之后被应用（Heikki Linnakangas）","title":"当 pause_at_recovery_target 和 recovery_target_inclusive 都被设置时，确保目标记录在暂停之前而不是之后被应用","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["a472ae1e4","e34acac62"],"commit_groups":[["a472ae1e4","e34acac62"]],"commits":[],"cves":[],"db_id":"fafcb322ce3135f7892cf2629aad246a","html":"\u003cp\u003e确保 walreceiver 即使在数据持续不断时也按时发送热备反馈消息（Andres Freund、Amit Kapila）\u003c/p\u003e","id":"9.3.3-87ac97a8bd09d848","identity_text":"Ensure walreceiver sends hot-standby feedback messages on time even when there is a continuous stream of data (Andres Freund, Amit Kapila)","part":"changes","patch_ids":["efc4481fa9e5b56c325e642eaa3e12e6"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["e34acac62"],"source_entry_id":"9.3.3/changes/025","source_hash":"587296b033a5b64c3552e1f0288f00e8b9faaa2f627a8cda63edc9068cdcb876","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"b192c2f8a223496a14634516cc0b62c2502a1db76336feb5f3f0ca47632766b0","text":"确保 walreceiver 即使在数据持续不断时也按时发送热备反馈消息（Andres Freund、Amit Kapila）","title":"确保 walreceiver 即使在数据持续不断时也按时发送热备反馈消息","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["478af9b79","e8312b4f0"],"commit_groups":[["478af9b79","e8312b4f0"]],"commits":[],"cves":[],"db_id":"00a9b820362e4916260cf1cc2dee87f4","html":"\u003cp\u003e防止超时中断从主流程代码手中夺取控制权，除非设置了 \u003ccode\u003eImmediateInterruptOK\u003c/code\u003e（Andres Freund、Tom Lane）\u003c/p\u003e\n\u003cp\u003e这对任何使用语句超时的应用都是一个严重问题，因为它可能在超时发生后造成各种奇怪的失败。我们见过关于自旋锁\u003cspan\u003e“\u003cspan\u003e卡住\u003c/span\u003e”\u003c/span\u003e、ERROR 意外升级为 PANIC、无法终止的后端进程以及其他异常行为的报告。\u003c/p\u003e","id":"9.3.3-e1cc3cee18571c44","identity_text":"Prevent timeout interrupts from taking control away from mainline code unless ImmediateInterruptOK is set (Andres Freund, Tom Lane) This is a serious issue for any application making use of statement timeouts, as it could cause all manner of strange failures after a timeout occurred. We have seen reports of stuck spinlocks, ERRORs being unexpectedly promoted to PANICs, unkillable backends, and other misbehaviors.","part":"changes","patch_ids":["63d7f66f85e68ba95a4e47aecb73e40d"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["478af9b79"],"source_entry_id":"9.3.3/changes/026","source_hash":"aa301548188c661c14d2c3e5ab4ff2548d89569f3ea2316165a2e86116f6f577","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"ba69d0f98eaf35a43e42a6ec1e51331210ac9e5a0b6e952989b71e9e8943dd54","text":"防止超时中断从主流程代码手中夺取控制权，除非设置了 ImmediateInterruptOK（Andres Freund、Tom Lane） 这对任何使用语句超时的应用都是一个严重问题，因为它可能在超时发生后造成各种奇怪的失败。我们见过关于自旋锁“卡住”、ERROR 意外升级为 PANIC、无法终止的后端进程以及其他异常行为的报告。","title":"防止超时中断从主流程代码手中夺取控制权，除非设置了 ImmediateInterruptOK","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["458b20f2d","5d807a74b","798243a81","8e6bfc9eb","d1981719a","ebe334463"],"commit_groups":[["458b20f2d","5d807a74b","798243a81","8e6bfc9eb","d1981719a","ebe334463"]],"commits":[],"cves":[],"db_id":"1e1a787c2b2075910db8d64413d2429b","html":"\u003cp\u003e修复服务器进程退出期间的竞态条件（Robert Haas）\u003c/p\u003e\n\u003cp\u003e确保信号处理程序不会在进程的 \u003ccode\u003eMyProc\u003c/code\u003e 指针不再有效后尝试使用它。\u003c/p\u003e","id":"9.3.3-17924e3b05368ddd","identity_text":"Fix race conditions during server process exit (Robert Haas) Ensure that signal handlers don't attempt to use the process's MyProc pointer after it's no longer valid.","part":"changes","patch_ids":["9d8a40d0a719962c0c7d626ebe2b9dcd"],"related_changes":[{"db_id":"902b0f0f92d250a77926a1cb90366ad7","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复服务器进程退出期间的竞态条件","url":"/docs/compare/?release=9.2.7#9.2.7-17924e3b05368ddd","version":"9.2.7"},{"db_id":"f69dda79e5a071672a7388442daca1bb","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复服务器进程退出期间的竞态条件","url":"/docs/compare/?release=9.1.12#9.1.12-17924e3b05368ddd","version":"9.1.12"},{"db_id":"2253a5527cd74ada04357261a28c088d","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复服务器进程退出期间的竞态条件","url":"/docs/compare/?release=9.0.16#9.0.16-17924e3b05368ddd","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"},"rule":2,"target":"2253a5527cd74ada04357261a28c088d","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"},"rule":2,"target":"902b0f0f92d250a77926a1cb90366ad7","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"},"rule":2,"target":"f69dda79e5a071672a7388442daca1bb","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["5d807a74b"],"source_entry_id":"9.3.3/changes/027","source_hash":"ad3f8ce4fcc8fdb33d6b94bcbfe14345132bd1f31c2e9ed59b1f5fdc0af241ab","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f","text":"修复服务器进程退出期间的竞态条件（Robert Haas） 确保信号处理程序不会在进程的 MyProc 指针不再有效后尝试使用它。","title":"修复服务器进程退出期间的竞态条件","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["03f06ff38","214c7a4f0","6f1a40773","81b116d98"],"commit_groups":[["03f06ff38","214c7a4f0","6f1a40773","81b116d98"]],"commits":[],"cves":[],"db_id":"37eb8f42fb3d8294e7fa4a4b049e9eb3","html":"\u003cp\u003e修复 walsender 关闭逻辑和 walreceiver SIGHUP 信号处理程序中的竞态条件（Tom Lane）\u003c/p\u003e","id":"9.3.3-1585f80b8a559486","identity_text":"Fix race conditions in walsender shutdown logic and walreceiver SIGHUP signal handler (Tom Lane)","part":"changes","patch_ids":["848c5c9c393d92e3bd6770c3e5ea5e96"],"related_changes":[{"db_id":"aa5afd581fa3c302b7744381f9c7557c","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"919e1316855b10daa2c6c568f57a5abb1907661a3625e55c147cfa57b5e32c63"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 walsender 关闭逻辑和 walreceiver SIGHUP 信号处理程序中的竞态条件","url":"/docs/compare/?release=9.2.7#9.2.7-1585f80b8a559486","version":"9.2.7"},{"db_id":"14e097e65db0d890cb48064641966c52","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"919e1316855b10daa2c6c568f57a5abb1907661a3625e55c147cfa57b5e32c63"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 walsender 关闭逻辑和 walreceiver SIGHUP 信号处理程序中的竞态条件","url":"/docs/compare/?release=9.1.12#9.1.12-1585f80b8a559486","version":"9.1.12"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"919e1316855b10daa2c6c568f57a5abb1907661a3625e55c147cfa57b5e32c63"},"rule":2,"target":"14e097e65db0d890cb48064641966c52","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"919e1316855b10daa2c6c568f57a5abb1907661a3625e55c147cfa57b5e32c63"},"rule":2,"target":"aa5afd581fa3c302b7744381f9c7557c","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["6f1a40773"],"source_entry_id":"9.3.3/changes/028","source_hash":"e8a38dd613a7025e536eba923e35ff27ddd069e8effcb7b20b0c753574ac59f2","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"919e1316855b10daa2c6c568f57a5abb1907661a3625e55c147cfa57b5e32c63","text":"修复 walsender 关闭逻辑和 walreceiver SIGHUP 信号处理程序中的竞态条件（Tom Lane）","title":"修复 walsender 关闭逻辑和 walreceiver SIGHUP 信号处理程序中的竞态条件","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["01b882fd8","3e71ce1e9","571addd72","af259c691","bf8ee6f15","d17a667e8"],"commit_groups":[["01b882fd8","3e71ce1e9","571addd72","af259c691","bf8ee6f15","d17a667e8"]],"commits":[],"cves":[],"db_id":"37b95577ed90367c94210a79984362d9","html":"\u003cp\u003e修复错误报告逻辑中对 \u003ccode\u003eerrno\u003c/code\u003e 的不安全引用（Christian Kruse）\u003c/p\u003e\n\u003cp\u003e这通常会导致奇怪的行为，例如 \u003ccode\u003eHINT\u003c/code\u003e 字段缺失或不恰当。\u003c/p\u003e","id":"9.3.3-49cce80b853a829d","identity_text":"Fix unsafe references to errno within error reporting logic (Christian Kruse) This would typically lead to odd behaviors such as missing or inappropriate HINT fields.","part":"changes","patch_ids":["540cd3385c2fed8a4f7875204b785a1c"],"related_changes":[{"db_id":"bc3f7584e4445525d6f45b7085bf401d","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复错误报告逻辑中对 errno 的不安全引用","url":"/docs/compare/?release=9.2.7#9.2.7-49cce80b853a829d","version":"9.2.7"},{"db_id":"3e87d3f06c98ffe8bdeeefa70078a8bf","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复错误报告逻辑中对 errno 的不安全引用","url":"/docs/compare/?release=9.1.12#9.1.12-49cce80b853a829d","version":"9.1.12"},{"db_id":"7d0b30dd22b8070f126ec9141785cff7","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复错误报告逻辑中对 errno 的不安全引用","url":"/docs/compare/?release=9.0.16#9.0.16-49cce80b853a829d","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"},"rule":2,"target":"3e87d3f06c98ffe8bdeeefa70078a8bf","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"},"rule":2,"target":"7d0b30dd22b8070f126ec9141785cff7","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"},"rule":2,"target":"bc3f7584e4445525d6f45b7085bf401d","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["bf8ee6f15"],"source_entry_id":"9.3.3/changes/029","source_hash":"caac25c70f7e301d4d2384ec0a408ae21eac194bb0d7919489123ee4c875a807","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d","text":"修复错误报告逻辑中对 errno 的不安全引用（Christian Kruse） 这通常会导致奇怪的行为，例如 HINT 字段缺失或不恰当。","title":"修复错误报告逻辑中对 errno 的不安全引用","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2de905186","3f721588a","5bfcc9ec5","910bac595","d0070ac81","d9c4442b8"],"commit_groups":[["2de905186","3f721588a","5bfcc9ec5","910bac595","d0070ac81","d9c4442b8"]],"commits":[],"cves":[],"db_id":"df3e479eecfd2500a93eff44e9e5ab59","html":"\u003cp\u003e修复服务器启动期间过早使用 \u003ccode\u003eereport()\u003c/code\u003e 可能导致的崩溃（Tom Lane）\u003c/p\u003e\n\u003cp\u003e我们在实际中见到的主要情况是：如果服务器在一个它没有读取权限的目录中被启动，就会崩溃。\u003c/p\u003e","id":"9.3.3-d0cc9be6415fd283","identity_text":"Fix possible crashes from using ereport() too early during server startup (Tom Lane) The principal case we've seen in the field is a crash if the server is started in a directory it doesn't have permission to read.","part":"changes","patch_ids":["0ce3146b82b45d70b95ea992e8b18df8"],"related_changes":[{"db_id":"4a16d4287f4ee8452465cd646d1fd781","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复服务器启动期间过早使用 ereport() 可能导致的崩溃","url":"/docs/compare/?release=9.2.7#9.2.7-d0cc9be6415fd283","version":"9.2.7"},{"db_id":"e6191c20bd057498459d068ab454d4d4","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复服务器启动期间过早使用 ereport() 可能导致的崩溃","url":"/docs/compare/?release=9.1.12#9.1.12-d0cc9be6415fd283","version":"9.1.12"},{"db_id":"f162a4f736bbc4a94390f9623f33f298","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复服务器启动期间过早使用 ereport() 可能导致的崩溃","url":"/docs/compare/?release=9.0.16#9.0.16-d0cc9be6415fd283","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"},"rule":2,"target":"4a16d4287f4ee8452465cd646d1fd781","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"},"rule":2,"target":"e6191c20bd057498459d068ab454d4d4","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"},"rule":2,"target":"f162a4f736bbc4a94390f9623f33f298","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["5bfcc9ec5"],"source_entry_id":"9.3.3/changes/030","source_hash":"5d0ce5580bf0d0e9e5829a5e398d19d2bec6d2857c8fb0f38b1e048d5ccacddb","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18","text":"修复服务器启动期间过早使用 ereport() 可能导致的崩溃（Tom Lane） 我们在实际中见到的主要情况是：如果服务器在一个它没有读取权限的目录中被启动，就会崩溃。","title":"修复服务器启动期间过早使用 ereport() 可能导致的崩溃","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["2a6e1a554","36352ceb4","41042970b","74242c23c","7635dae55","ad910ccdc"],"commit_groups":[["2a6e1a554","36352ceb4","41042970b","74242c23c","7635dae55","ad910ccdc"]],"commits":[],"cves":[],"db_id":"11671fca978410389b3a726d8bea8852","html":"\u003cp\u003e在 OpenSSL 套接字写函数中正确清除重试标志（Alexander Kukushkin）\u003c/p\u003e\n\u003cp\u003e这一遗漏可能导致 SSL 加密连接意外断开后服务器锁死。\u003c/p\u003e","id":"9.3.3-716aaa191c3cd5ee","identity_text":"Clear retry flags properly in OpenSSL socket write function (Alexander Kukushkin) This omission could result in a server lockup after unexpected loss of an SSL-encrypted connection.","part":"changes","patch_ids":["4da40c27b6513898d858272221f71688"],"related_changes":[{"db_id":"8fef34044c53fb22630112ea37abb361","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"在 OpenSSL 套接字写函数中正确清除重试标志","url":"/docs/compare/?release=9.2.7#9.2.7-716aaa191c3cd5ee","version":"9.2.7"},{"db_id":"0b007ab59ce736b143f3f709df9c5b30","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"在 OpenSSL 套接字写函数中正确清除重试标志","url":"/docs/compare/?release=9.1.12#9.1.12-716aaa191c3cd5ee","version":"9.1.12"},{"db_id":"941caa56d3c088d05a0927a7592abb33","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"在 OpenSSL 套接字写函数中正确清除重试标志","url":"/docs/compare/?release=9.0.16#9.0.16-716aaa191c3cd5ee","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"},"rule":2,"target":"0b007ab59ce736b143f3f709df9c5b30","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"},"rule":2,"target":"8fef34044c53fb22630112ea37abb361","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"},"rule":2,"target":"941caa56d3c088d05a0927a7592abb33","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["2a6e1a554"],"source_entry_id":"9.3.3/changes/031","source_hash":"845345a5d1efdaee2d83ea1e3684a3de8b481c13775c2dab4864b5a0c8ce2dd9","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a","text":"在 OpenSSL 套接字写函数中正确清除重试标志（Alexander Kukushkin） 这一遗漏可能导致 SSL 加密连接意外断开后服务器锁死。","title":"在 OpenSSL 套接字写函数中正确清除重试标志","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["148052d25","170590261","44c216330","8439ee415","a8a46d846","ca1c17181"],"commit_groups":[["148052d25","170590261","44c216330","8439ee415","a8a46d846","ca1c17181"]],"commits":[],"cves":[],"db_id":"f9b078f059a923d2bd5bd6cb576ab7fd","html":"\u003cp\u003e修复对包含转义的 Unicode 标识符（\u003ccode\u003eU\u0026amp;\"...\"\u003c/code\u003e 语法）的长度检查（Tom Lane）\u003c/p\u003e\n\u003cp\u003e如果标识符的转义形式过长，就会为这类标识符打印虚假的截断警告，但标识符在反转义之后实际上并不需要截断。\u003c/p\u003e","id":"9.3.3-c3388e8771705baf","identity_text":"Fix length checking for Unicode identifiers (U\u0026\"...\" syntax) containing escapes (Tom Lane) A spurious truncation warning would be printed for such identifiers if the escaped form of the identifier was too long, but the identifier actually didn't need truncation after de-escaping.","part":"changes","patch_ids":["82336ed6004f24b1b22dd4cdf8b4df2b"],"related_changes":[{"db_id":"c0c97674783fef61838fe77fe815ef47","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复对包含转义的 Unicode 标识符（U\u0026\"...\" 语法）的长度检查","url":"/docs/compare/?release=9.2.7#9.2.7-c3388e8771705baf","version":"9.2.7"},{"db_id":"42f4b233e4f166ead5bf69f9d022b760","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复对包含转义的 Unicode 标识符（U\u0026\"...\" 语法）的长度检查","url":"/docs/compare/?release=9.1.12#9.1.12-c3388e8771705baf","version":"9.1.12"},{"db_id":"65740b7941f3e9b086e8907f001022fc","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复对包含转义的 Unicode 标识符（U\u0026\"...\" 语法）的长度检查","url":"/docs/compare/?release=9.0.16#9.0.16-c3388e8771705baf","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"},"rule":2,"target":"42f4b233e4f166ead5bf69f9d022b760","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"},"rule":2,"target":"65740b7941f3e9b086e8907f001022fc","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"},"rule":2,"target":"c0c97674783fef61838fe77fe815ef47","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["ca1c17181"],"source_entry_id":"9.3.3/changes/032","source_hash":"cf406dbc8a07c48d170f04f9bacc108069fa098ee265d9d1643248aabaa54aca","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a","text":"修复对包含转义的 Unicode 标识符（U\u0026\"...\" 语法）的长度检查（Tom Lane） 如果标识符的转义形式过长，就会为这类标识符打印虚假的截断警告，但标识符在反转义之后实际上并不需要截断。","title":"修复对包含转义的 Unicode 标识符（U\u0026\"...\" 语法）的长度检查","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0c2338abb","4c70cb1d3"],"commit_groups":[["0c2338abb","4c70cb1d3"]],"commits":[],"cves":[],"db_id":"0bbcfc4128e15eedd953016072698fc9","html":"\u003cp\u003e修复恰好在命令字符串或函数体末尾之前的 Unicode 字面量和标识符的解析（Tom Lane）\u003c/p\u003e","id":"9.3.3-c01a56796fba5742","identity_text":"Fix parsing of Unicode literals and identifiers just before the end of a command string or function body (Tom Lane)","part":"changes","patch_ids":["815cfadd721e215e67a4351d8a298956"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["4c70cb1d3"],"source_entry_id":"9.3.3/changes/033","source_hash":"36c3df9ab69d22abf433dd0689c31b52f3dec3b4fb4b521cedb647a0ae8f4d9a","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"95718f4a897ac1a17f59d248edb42c0a958a26504ca2499a5cd9170960d6e15e","text":"修复恰好在命令字符串或函数体末尾之前的 Unicode 字面量和标识符的解析（Tom Lane）","title":"修复恰好在命令字符串或函数体末尾之前的 Unicode 字面量和标识符的解析","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["6c36f383d","c0e6169e1","cbd850bf6","d1e3070f0","f2eede9b5"],"commit_groups":[["6c36f383d","c0e6169e1","cbd850bf6","d1e3070f0","f2eede9b5"]],"commits":[],"cves":[],"db_id":"b669cceaac0688c3467ae4cc3bdfc5cf","html":"\u003cp\u003e允许作为类型名的关键字用于角色列表（Stephen Frost）\u003c/p\u003e\n\u003cp\u003e先前的补丁允许这类关键字在角色标识符等位置不加引号使用；但漏掉了允许角色标识符列表的情况，例如 \u003ccode\u003eDROP ROLE\u003c/code\u003e。\u003c/p\u003e","id":"9.3.3-26b51f6387adc9b6","identity_text":"Allow keywords that are type names to be used in lists of roles (Stephen Frost) A previous patch allowed such keywords to be used without quoting in places such as role identifiers; but it missed cases where a list of role identifiers was permitted, such as DROP ROLE.","part":"changes","patch_ids":["988784c136305454eaa4cd372ad51bd2"],"related_changes":[{"db_id":"facc82e0f268cb697ef0e460cb963a03","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"允许作为类型名的关键字用于角色列表","url":"/docs/compare/?release=9.2.7#9.2.7-26b51f6387adc9b6","version":"9.2.7"},{"db_id":"f7964e61818d714c7e0529b9e3c273df","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"允许作为类型名的关键字用于角色列表","url":"/docs/compare/?release=9.1.12#9.1.12-26b51f6387adc9b6","version":"9.1.12"},{"db_id":"5fd4ec2506ed6953d713694b1bfb2ef3","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"允许作为类型名的关键字用于角色列表","url":"/docs/compare/?release=9.0.16#9.0.16-26b51f6387adc9b6","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"},"rule":2,"target":"5fd4ec2506ed6953d713694b1bfb2ef3","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"},"rule":2,"target":"f7964e61818d714c7e0529b9e3c273df","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"},"rule":2,"target":"facc82e0f268cb697ef0e460cb963a03","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["d1e3070f0"],"source_entry_id":"9.3.3/changes/034","source_hash":"3422358a199d6c3c0f055ac6d81cf78eb7ef3839ddb980f8df92652e9d2075ae","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488","text":"允许作为类型名的关键字用于角色列表（Stephen Frost） 先前的补丁允许这类关键字在角色标识符等位置不加引号使用；但漏掉了允许角色标识符列表的情况，例如 DROP ROLE。","title":"允许作为类型名的关键字用于角色列表","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["6698782f1","7ab321404","b44ae4893","f67b8aeab"],"commit_groups":[["6698782f1","7ab321404","b44ae4893","f67b8aeab"]],"commits":[],"cves":[],"db_id":"cc82a00ff7837fcf4f929f3d710075b7","html":"\u003cp\u003e修复 \u003ccode\u003eEXISTS(SELECT * FROM zero_column_table)\u003c/code\u003e 的解析器崩溃（Tom Lane）\u003c/p\u003e","id":"9.3.3-3a6268aab3200344","identity_text":"Fix parser crash for EXISTS(SELECT * FROM zero_column_table) (Tom Lane)","part":"changes","patch_ids":["03ab2ec354d6a89c4d591ea5ce8c2dba"],"related_changes":[{"db_id":"c9a70a021e05e448e27f35f9a48362ed","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"4b7f15b3ba10001d28f82194fc9d8c8018472bd04189427c4745eed12b6636cc"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 EXISTS(SELECT * FROM zero_column_table) 的解析器崩溃","url":"/docs/compare/?release=9.2.7#9.2.7-3a6268aab3200344","version":"9.2.7"},{"db_id":"a4215c04f2ec3ff54cd8dba70933efb0","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"4b7f15b3ba10001d28f82194fc9d8c8018472bd04189427c4745eed12b6636cc"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 EXISTS(SELECT * FROM zero_column_table) 的解析器崩溃","url":"/docs/compare/?release=9.1.12#9.1.12-3a6268aab3200344","version":"9.1.12"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"4b7f15b3ba10001d28f82194fc9d8c8018472bd04189427c4745eed12b6636cc"},"rule":2,"target":"a4215c04f2ec3ff54cd8dba70933efb0","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"4b7f15b3ba10001d28f82194fc9d8c8018472bd04189427c4745eed12b6636cc"},"rule":2,"target":"c9a70a021e05e448e27f35f9a48362ed","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["b44ae4893"],"source_entry_id":"9.3.3/changes/035","source_hash":"f64a422ffff3cfdf292f695388b2ca6340c8e81429edb0b2eff831fff9ea5647","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"4b7f15b3ba10001d28f82194fc9d8c8018472bd04189427c4745eed12b6636cc","text":"修复 EXISTS(SELECT * FROM zero_column_table) 的解析器崩溃（Tom Lane）","title":"修复 EXISTS(SELECT * FROM zero_column_table) 的解析器崩溃","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["41e9990cd","48e5cfde8","884c6384a","9d2e07fec","9ec6199d1","f5d9fdcc7"],"commit_groups":[["41e9990cd","48e5cfde8","884c6384a","9d2e07fec","9ec6199d1","f5d9fdcc7"]],"commits":[],"cves":[],"db_id":"3e1cf87c50929ba8621eacb7c7aa2815","html":"\u003cp\u003e修复嵌套子选择（例如 \u003ccode\u003eWHERE (... x IN (SELECT ...) ...) IN (SELECT ...)\u003c/code\u003e）因无效计划而可能崩溃的问题（Tom Lane）\u003c/p\u003e","id":"9.3.3-0120485e2756491d","identity_text":"Fix possible crash due to invalid plan for nested sub-selects, such as WHERE (... x IN (SELECT ...) ...) IN (SELECT ...) (Tom Lane)","part":"changes","patch_ids":["ba737cc47ae54d1dfd245b84ce9df8ce"],"related_changes":[{"db_id":"c20e57bd97bb0aed81a85b2b4bb6fb2f","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复嵌套子选择（例如 WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)）因无效计划而可能崩溃的问题","url":"/docs/compare/?release=9.2.7#9.2.7-0120485e2756491d","version":"9.2.7"},{"db_id":"4b54d1cbc23906d35a2c5cbb980cf685","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复嵌套子选择（例如 WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)）因无效计划而可能崩溃的问题","url":"/docs/compare/?release=9.1.12#9.1.12-0120485e2756491d","version":"9.1.12"},{"db_id":"587a014707d18a9dfe4fcd7665f8ffae","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复嵌套子选择（例如 WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)）因无效计划而可能崩溃的问题","url":"/docs/compare/?release=9.0.16#9.0.16-0120485e2756491d","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"},"rule":2,"target":"4b54d1cbc23906d35a2c5cbb980cf685","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"},"rule":2,"target":"587a014707d18a9dfe4fcd7665f8ffae","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"},"rule":2,"target":"c20e57bd97bb0aed81a85b2b4bb6fb2f","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["9d2e07fec"],"source_entry_id":"9.3.3/changes/036","source_hash":"62cef334d9707163a0c7e6b4f73534f10e60c719a8fb17a11a59b482fbcd3e75","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606","text":"修复嵌套子选择（例如 WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)）因无效计划而可能崩溃的问题（Tom Lane）","title":"修复嵌套子选择（例如 WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)）因无效计划而可能崩溃的问题","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["043f6ff05","a4aa854ca"],"commit_groups":[["043f6ff05","a4aa854ca"]],"commits":[],"cves":[],"db_id":"4e297bdce24185b58584574e6ceb9adf","html":"\u003cp\u003e修复对从 \u003ccode\u003eLATERAL\u003c/code\u003e 子查询上拉的 \u003ccode\u003eWHERE\u003c/code\u003e 条件的处理不当（Tom Lane）\u003c/p\u003e\n\u003cp\u003e此缺陷的典型症状是 \u003cspan\u003e“\u003cspan\u003eJOIN qualification cannot refer to other relations\u003c/span\u003e”\u003c/span\u003e 错误，不过在生成的计划中出现细微逻辑错误似乎也有可能。\u003c/p\u003e","id":"9.3.3-9a99163607062423","identity_text":"Fix mishandling of WHERE conditions pulled up from a LATERAL subquery (Tom Lane) The typical symptom of this bug was a JOIN qualification cannot refer to other relations error, though subtle logic errors in created plans seem possible as well.","part":"changes","patch_ids":["c27f9eb05949433e83b08a7c37c0353c"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["a4aa854ca"],"source_entry_id":"9.3.3/changes/037","source_hash":"489d61c17d4e27ce15747ab3e7efea56c99beb10df939b9286d543c4b2bc888d","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"1b3b689d605c626d8c4166a58a0b6cea3f3952112504ed62aef5a332de70580e","text":"修复对从 LATERAL 子查询上拉的 WHERE 条件的处理不当（Tom Lane） 此缺陷的典型症状是 “JOIN qualification cannot refer to other relations” 错误，不过在生成的计划中出现细微逻辑错误似乎也有可能。","title":"修复对从 LATERAL 子查询上拉的 WHERE 条件的处理不当","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["158b7fa6a","27ff4cfe7"],"commit_groups":[["158b7fa6a","27ff4cfe7"]],"commits":[],"cves":[],"db_id":"2b17f603c6ad859f11affe0e6c550250","html":"\u003cp\u003e禁止对 \u003ccode\u003eUPDATE/DELETE\u003c/code\u003e 的目标表进行 \u003ccode\u003eLATERAL\u003c/code\u003e 引用（Tom Lane）\u003c/p\u003e\n\u003cp\u003e虽然未来版本可能允许这样做，但它在 9.3 中是无意的，而且无论如何都不能正常工作。\u003c/p\u003e","id":"9.3.3-3cdc6d1c043b0bb0","identity_text":"Disallow LATERAL references to the target table of an UPDATE/DELETE (Tom Lane) While this might be allowed in some future release, it was unintentional in 9.3, and didn't work quite right anyway.","part":"changes","patch_ids":["0a66fa5f6dd9d62f0184f9eece7d7152"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["27ff4cfe7"],"source_entry_id":"9.3.3/changes/038","source_hash":"13f6592d1f13f102a385eda9015784fc6bc2c75351c2f36ba3ee1cb6a951ce57","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"b5c05620b5c2153ed9143531d38e8e9193b3d5734e1435fad24eb0304c1d23f0","text":"禁止对 UPDATE/DELETE 的目标表进行 LATERAL 引用（Tom Lane） 虽然未来版本可能允许这样做，但它在 9.3 中是无意的，而且无论如何都不能正常工作。","title":"禁止对 UPDATE/DELETE 的目标表进行 LATERAL 引用","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["324577f39","5d545b7ed","c03ad5602"],"commit_groups":[["324577f39","5d545b7ed","c03ad5602"]],"commits":[],"cves":[],"db_id":"25519f138b80db342af36655ee28975d","html":"\u003cp\u003e修复对带 \u003ccode\u003eUNION ALL\u003c/code\u003e 子查询的继承目标表的 \u003ccode\u003eUPDATE/DELETE\u003c/code\u003e（Tom Lane）\u003c/p\u003e\n\u003cp\u003e如果不修复，\u003ccode\u003eUNION ALL\u003c/code\u003e 子查询就不能正确插入第一个之后的继承子表的更新计划中，通常导致那些子表完全没有被更新。\u003c/p\u003e","id":"9.3.3-6effe56643462844","identity_text":"Fix UPDATE/DELETE of an inherited target table that has UNION ALL subqueries (Tom Lane) Without this fix, UNION ALL subqueries aren't correctly inserted into the update plans for inheritance child tables after the first one, typically resulting in no update happening for those child table(s).","part":"changes","patch_ids":["17883559d4c0d9cd22ce644ec611b49e"],"related_changes":[{"db_id":"fdf7c4700ffff73b7739301197429cc2","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"4b2fa92e4cc3843a640050d2bd1649f8ca3dedcac2b4c147c3a9c8bf6d823c5a"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复对带 UNION ALL 子查询的继承目标表的 UPDATE/DELETE","url":"/docs/compare/?release=9.2.7#9.2.7-6effe56643462844","version":"9.2.7"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"4b2fa92e4cc3843a640050d2bd1649f8ca3dedcac2b4c147c3a9c8bf6d823c5a"},"rule":2,"target":"fdf7c4700ffff73b7739301197429cc2","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["324577f39"],"source_entry_id":"9.3.3/changes/039","source_hash":"eed2f770d292fb3df5541bdf1b7e3a6ce9687eb44391df4075c390092d485449","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"4b2fa92e4cc3843a640050d2bd1649f8ca3dedcac2b4c147c3a9c8bf6d823c5a","text":"修复对带 UNION ALL 子查询的继承目标表的 UPDATE/DELETE（Tom Lane） 如果不修复，UNION ALL 子查询就不能正确插入第一个之后的继承子表的更新计划中，通常导致那些子表完全没有被更新。","title":"修复对带 UNION ALL 子查询的继承目标表的 UPDATE/DELETE","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["4eeda92d8","663f8419b"],"commit_groups":[["4eeda92d8","663f8419b"]],"commits":[],"cves":[],"db_id":"233d4effca7fab23f26fa9e99ef53460","html":"\u003cp\u003e修复 \u003ccode\u003eANALYZE\u003c/code\u003e 在列是范围类型之上的域时失败的问题（Tom Lane）\u003c/p\u003e","id":"9.3.3-377f722c83da5739","identity_text":"Fix ANALYZE to not fail on a column that's a domain over a range type (Tom Lane)","part":"changes","patch_ids":["aa069c3c2c24722cfbf3b414ea317753"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["663f8419b"],"source_entry_id":"9.3.3/changes/040","source_hash":"8613bfa52abb7b10db0b5912f38f025f3f5ae267ba10d779164e3a5a72210def","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"d8e54a4a2510f740a7ff7b0d86f828f73b9ee35fc6e4383e8be4ef96b5c50f28","text":"修复 ANALYZE 在列是范围类型之上的域时失败的问题（Tom Lane）","title":"修复 ANALYZE 在列是范围类型之上的域时失败的问题","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["00b77771a","2d76d75d9","36785a21b","628652620","9387f4e1b","f0381680f"],"commit_groups":[["00b77771a","2d76d75d9","36785a21b","628652620","9387f4e1b","f0381680f"]],"commits":[],"cves":[],"db_id":"f3695dd10fa7b17e2c880937788ec52b","html":"\u003cp\u003e确保即使表列中的所有值都\u003cspan\u003e“\u003cspan\u003e过宽\u003c/span\u003e”\u003c/span\u003e，\u003ccode\u003eANALYZE\u003c/code\u003e 也会为该列创建统计信息（Tom Lane）\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003eANALYZE\u003c/code\u003e 有意在直方图和最常用值计算中省略非常宽的值，但在所有采样条目都过宽的情况下没有做出合理的处理。\u003c/p\u003e","id":"9.3.3-45d4601c41a69628","identity_text":"Ensure that ANALYZE creates statistics for a table column even when all the values in it are too wide (Tom Lane) ANALYZE intentionally omits very wide values from its histogram and most-common-values calculations, but it neglected to do something sane in the case that all the sampled entries are too wide.","part":"changes","patch_ids":["d7d398f6dc30f300383f39a985a01cdb"],"related_changes":[{"db_id":"559a553c08451fe4dcfb5586f0f99e82","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"确保即使表列中的所有值都“过宽”，ANALYZE 也会为该列创建统计信息","url":"/docs/compare/?release=9.2.7#9.2.7-45d4601c41a69628","version":"9.2.7"},{"db_id":"75fe6c40b7de8f85e5877c5c28800ac9","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"确保即使表列中的所有值都“过宽”，ANALYZE 也会为该列创建统计信息","url":"/docs/compare/?release=9.1.12#9.1.12-45d4601c41a69628","version":"9.1.12"},{"db_id":"e87f90c509b154f64680271a9e8604ff","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"确保即使表列中的所有值都“过宽”，ANALYZE 也会为该列创建统计信息","url":"/docs/compare/?release=9.0.16#9.0.16-45d4601c41a69628","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"},"rule":2,"target":"559a553c08451fe4dcfb5586f0f99e82","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"},"rule":2,"target":"75fe6c40b7de8f85e5877c5c28800ac9","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"},"rule":2,"target":"e87f90c509b154f64680271a9e8604ff","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["36785a21b"],"source_entry_id":"9.3.3/changes/041","source_hash":"fc59333f31f1c5f6ebb654d73ad1e6f5610a47afad076778531e92abfdb7b654","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4","text":"确保即使表列中的所有值都“过宽”，ANALYZE 也会为该列创建统计信息（Tom Lane） ANALYZE 有意在直方图和最常用值计算中省略非常宽的值，但在所有采样条目都过宽的情况下没有做出合理的处理。","title":"确保即使表列中的所有值都“过宽”，ANALYZE 也会为该列创建统计信息","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0fb4e3ceb","1fe06595a","6f25c62d7","86e58ae02","d2636486b","e70c42821"],"commit_groups":[["0fb4e3ceb","1fe06595a","6f25c62d7","86e58ae02","d2636486b","e70c42821"]],"commits":[],"cves":[],"db_id":"f4ea0d64a1dc2dd78d93bdae9255c39e","html":"\u003cp\u003e在 \u003ccode\u003eALTER TABLE ... SET TABLESPACE\u003c/code\u003e 中，允许不经权限检查就使用数据库的默认表空间（Stephen Frost）\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003eCREATE TABLE\u003c/code\u003e 一直允许这种用法，但 \u003ccode\u003eALTER TABLE\u003c/code\u003e 没有照做。\u003c/p\u003e","id":"9.3.3-abe3fe7f7c1377f4","identity_text":"In ALTER TABLE ... SET TABLESPACE, allow the database's default tablespace to be used without a permissions check (Stephen Frost) CREATE TABLE has always allowed such usage, but ALTER TABLE didn't get the memo.","part":"changes","patch_ids":["61ca926f3352265a900e12994feca337"],"related_changes":[{"db_id":"95e0a24f610d24ea94a95e0efe62ca88","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"在 ALTER TABLE ... SET TABLESPACE 中，允许不经权限检查就使用数据库的默认表空间","url":"/docs/compare/?release=9.2.7#9.2.7-abe3fe7f7c1377f4","version":"9.2.7"},{"db_id":"7ded2f3aed6eb776afe95ab57579f474","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"在 ALTER TABLE ... SET TABLESPACE 中，允许不经权限检查就使用数据库的默认表空间","url":"/docs/compare/?release=9.1.12#9.1.12-abe3fe7f7c1377f4","version":"9.1.12"},{"db_id":"4d098fa538b4f461a0bf9de881e82ee6","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"在 ALTER TABLE ... SET TABLESPACE 中，允许不经权限检查就使用数据库的默认表空间","url":"/docs/compare/?release=9.0.16#9.0.16-abe3fe7f7c1377f4","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"},"rule":2,"target":"4d098fa538b4f461a0bf9de881e82ee6","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"},"rule":2,"target":"7ded2f3aed6eb776afe95ab57579f474","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"},"rule":2,"target":"95e0a24f610d24ea94a95e0efe62ca88","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["86e58ae02"],"source_entry_id":"9.3.3/changes/042","source_hash":"e7c7af828e141aeb095f8202e4760206ce58a87fc2740fb2616201e460f13bc1","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300","text":"在 ALTER TABLE ... SET TABLESPACE 中，允许不经权限检查就使用数据库的默认表空间（Stephen Frost） CREATE TABLE 一直允许这种用法，但 ALTER TABLE 没有照做。","title":"在 ALTER TABLE ... SET TABLESPACE 中，允许不经权限检查就使用数据库的默认表空间","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["9a6e2b150","c01bc51f8"],"commit_groups":[["9a6e2b150","c01bc51f8"]],"commits":[],"cves":[],"db_id":"7cb7c3d3215c79ae72d59d6338477bb1","html":"\u003cp\u003e修复对包含事件触发器的扩展的支持（Tom Lane）\u003c/p\u003e","id":"9.3.3-9436c16878655f5c","identity_text":"Fix support for extensions containing event triggers (Tom Lane)","part":"changes","patch_ids":["680160795bd3795d8d0a5711010f6b2a"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["9a6e2b150"],"source_entry_id":"9.3.3/changes/043","source_hash":"214bd47fe95e0978b5990d49905f9ca305defc0c482dc1789cc935a2fc57b5dc","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"9ba93ce2843e4ea68a755872ff265e963268aed02e425fd270635041435c1a44","text":"修复对包含事件触发器的扩展的支持（Tom Lane）","title":"修复对包含事件触发器的扩展的支持","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["080b7db72","47ac4473a","57ac7d8a7","6c6c53d0b","6ca712fb9","97a39f295"],"commit_groups":[["080b7db72","47ac4473a","57ac7d8a7","6c6c53d0b","6ca712fb9","97a39f295"]],"commits":[],"cves":[],"db_id":"5c0d749e9a869ed15f6aabb49321c1c6","html":"\u003cp\u003e修复当 \u003ccode\u003eCASE\u003c/code\u003e 的某些分支返回集合而另一些不返回时的 \u003cspan\u003e“\u003cspan\u003ecannot accept a set\u003c/span\u003e”\u003c/span\u003e 错误（Tom Lane）\u003c/p\u003e","id":"9.3.3-c79e00b15c7a1b23","identity_text":"Fix cannot accept a set error when some arms of a CASE return a set and others don't (Tom Lane)","part":"changes","patch_ids":["b4c1f8d0695745eeebf849b085b21d55"],"related_changes":[{"db_id":"3c022e03cacf413d80f93c1250d3f8d8","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复当 CASE 的某些分支返回集合而另一些不返回时的“cannot accept a set”错误","url":"/docs/compare/?release=9.2.7#9.2.7-71848f476e985de7","version":"9.2.7"},{"db_id":"90e4474f0a8941a41cee36d029dcd7ec","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复当 CASE 的某些分支返回集合而另一些不返回时的 “cannot accept a set” 错误","url":"/docs/compare/?release=9.1.12#9.1.12-c79e00b15c7a1b23","version":"9.1.12"},{"db_id":"58542151bd1bb3c497ae9ee5b4dafc1a","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复当 CASE 的某些分支返回集合而另一些不返回时的 “cannot accept a set” 错误","url":"/docs/compare/?release=9.0.16#9.0.16-c79e00b15c7a1b23","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"},"rule":2,"target":"3c022e03cacf413d80f93c1250d3f8d8","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"},"rule":2,"target":"58542151bd1bb3c497ae9ee5b4dafc1a","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"},"rule":2,"target":"90e4474f0a8941a41cee36d029dcd7ec","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["47ac4473a"],"source_entry_id":"9.3.3/changes/044","source_hash":"a8764b4fe1c21c34bc097b78a138576bba56daa58712464e188fd0ab1404b44c","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2","text":"修复当 CASE 的某些分支返回集合而另一些不返回时的 “cannot accept a set” 错误（Tom Lane）","title":"修复当 CASE 的某些分支返回集合而另一些不返回时的 “cannot accept a set” 错误","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["cdfbb78f0","d3ee45152"],"commit_groups":[["cdfbb78f0","d3ee45152"]],"commits":[],"cves":[],"db_id":"6d6476528c7de6ff7a8500914c03ff37","html":"\u003cp\u003e修复 JSON 函数中的内存泄漏（Craig Ringer）\u003c/p\u003e","id":"9.3.3-10589ad7c8c71dd1","identity_text":"Fix memory leakage in JSON functions (Craig Ringer)","part":"changes","patch_ids":["c80b641985bfd6b07d4449b7e7d8d788"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["cdfbb78f0"],"source_entry_id":"9.3.3/changes/045","source_hash":"b5ebad305bd9bd76b9905769882191b12032ef633d5ea7b66de7286e695660ea","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"aea4a6c06bede1f4b8e359fca961f08d75454c212f4f5ed956d20d90a9d8f63b","text":"修复 JSON 函数中的内存泄漏（Craig Ringer）","title":"修复 JSON 函数中的内存泄漏","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["29dcf7ded","4825a9e95","7dfd9f6f5"],"commit_groups":[["29dcf7ded","4825a9e95","7dfd9f6f5"]],"commits":[],"cves":[],"db_id":"574f88ab460d539c0819a1f1ea99f8ec","html":"\u003cp\u003e在生成 JSON 输出时正确区分数字与非数字（Andrew Dunstan）\u003c/p\u003e","id":"9.3.3-1f31bb78a4029bf1","identity_text":"Properly distinguish numbers from non-numbers when generating JSON output (Andrew Dunstan)","part":"changes","patch_ids":["75343687ddcb2fcf2319ef8644cac0fa"],"related_changes":[{"db_id":"145c7c02d948a54adb722d2a993f656a","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"678bed02a53efccb1d29c5253df241c9d6450c551575c911442369d97b8ce86d"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"在生成 JSON 输出时正确区分数字与非数字","url":"/docs/compare/?release=9.2.7#9.2.7-1f31bb78a4029bf1","version":"9.2.7"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"678bed02a53efccb1d29c5253df241c9d6450c551575c911442369d97b8ce86d"},"rule":2,"target":"145c7c02d948a54adb722d2a993f656a","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["7dfd9f6f5"],"source_entry_id":"9.3.3/changes/046","source_hash":"0348b645326d1db7170ba753ba0672f839a1b76c4c993eccd25bc0cd563ef1dc","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"678bed02a53efccb1d29c5253df241c9d6450c551575c911442369d97b8ce86d","text":"在生成 JSON 输出时正确区分数字与非数字（Andrew Dunstan）","title":"在生成 JSON 输出时正确区分数字与非数字","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["150a30e19","1f069d21d","28b60aa23","918d74a07","a133bf703","b2d80147d"],"commit_groups":[["150a30e19","1f069d21d","28b60aa23","918d74a07","a133bf703","b2d80147d"]],"commits":[],"cves":[],"db_id":"a00f19f4a4095e9a9165e129b432db14","html":"\u003cp\u003e修复 pgstat 函数中对全零客户端地址的检查（Kevin Grittner）\u003c/p\u003e","id":"9.3.3-37c412e7c57e6641","identity_text":"Fix checks for all-zero client addresses in pgstat functions (Kevin Grittner)","part":"changes","patch_ids":["a5313d621d8d95e4e204e0d4b8b8f8e7"],"related_changes":[{"db_id":"bda9cb552f7456b4075e860b04842ecc","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 pgstat 函数中对全零客户端地址的检查","url":"/docs/compare/?release=9.2.7#9.2.7-37c412e7c57e6641","version":"9.2.7"},{"db_id":"f66fb5509ed7da6955cc8611eb2490e2","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 pgstat 函数中对全零客户端地址的检查","url":"/docs/compare/?release=9.1.12#9.1.12-37c412e7c57e6641","version":"9.1.12"},{"db_id":"f647ad538a9bce5e0da6e05e57afcc79","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复 pgstat 函数中对全零客户端地址的检查","url":"/docs/compare/?release=9.0.16#9.0.16-37c412e7c57e6641","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"},"rule":2,"target":"bda9cb552f7456b4075e860b04842ecc","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"},"rule":2,"target":"f647ad538a9bce5e0da6e05e57afcc79","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"},"rule":2,"target":"f66fb5509ed7da6955cc8611eb2490e2","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["28b60aa23"],"source_entry_id":"9.3.3/changes/047","source_hash":"078f83ab14535c851aca537dc8afd3499c5f4fb4e31ac599b11e0c2a461b07a4","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27","text":"修复 pgstat 函数中对全零客户端地址的检查（Kevin Grittner）","title":"修复 pgstat 函数中对全零客户端地址的检查","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["082c0dfa1","399d23e19","3c7b4ef70","56f5d3424","8be095cea","9beffdcc3"],"commit_groups":[["082c0dfa1","399d23e19","3c7b4ef70","56f5d3424","8be095cea","9beffdcc3"]],"commits":[],"cves":[],"db_id":"bdec3fe347e507ce4e004c7d0c07d9b2","html":"\u003cp\u003e修复文本搜索解析器可能错误分类多字节字符的问题（Tom Lane）\u003c/p\u003e\n\u003cp\u003e在 C 区域设置下使用多字节编码时，非 ASCII 字符可能被错误分类。在 Cygwin 上，非 C 区域设置也可能失败。\u003c/p\u003e","id":"9.3.3-d665b6c08ce4e8d9","identity_text":"Fix possible misclassification of multibyte characters by the text search parser (Tom Lane) Non-ASCII characters could be misclassified when using C locale with a multibyte encoding. On Cygwin, non-C locales could fail as well.","part":"changes","patch_ids":["6ade1bc9089508a03d077b5210f0ec56"],"related_changes":[{"db_id":"0d29215af03bfacc673f9e3040747da2","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复文本搜索解析器可能错误分类多字节字符的问题","url":"/docs/compare/?release=9.2.7#9.2.7-d665b6c08ce4e8d9","version":"9.2.7"},{"db_id":"537f6a77723456e1f621b81a24ab6f9a","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复文本搜索解析器可能错误分类多字节字符的问题","url":"/docs/compare/?release=9.1.12#9.1.12-d665b6c08ce4e8d9","version":"9.1.12"},{"db_id":"5356f043efb90dba09cddfb702db2ea9","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复文本搜索解析器可能错误分类多字节字符的问题","url":"/docs/compare/?release=9.0.16#9.0.16-d665b6c08ce4e8d9","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"},"rule":2,"target":"0d29215af03bfacc673f9e3040747da2","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"},"rule":2,"target":"5356f043efb90dba09cddfb702db2ea9","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"},"rule":2,"target":"537f6a77723456e1f621b81a24ab6f9a","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["9beffdcc3"],"source_entry_id":"9.3.3/changes/048","source_hash":"d96fdef635c6f8195b28a9a30b1fccb2d9a5cec0de93b7374a04b1911d6f668c","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee","text":"修复文本搜索解析器可能错误分类多字节字符的问题（Tom Lane） 在 C 区域设置下使用多字节编码时，非 ASCII 字符可能被错误分类。在 Cygwin 上，非 C 区域设置也可能失败。","title":"修复文本搜索解析器可能错误分类多字节字符的问题","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["5f778e644","6141983fb","6c2744f1d","928aec71c","f3807106b","fe8a6f53e"],"commit_groups":[["5f778e644","6141983fb","6c2744f1d","928aec71c","f3807106b","fe8a6f53e"]],"commits":[],"cves":[],"db_id":"3c13e80df6489c286b0b371b85fea89b","html":"\u003cp\u003e修复 \u003ccode\u003eplainto_tsquery()\u003c/code\u003e 中可能的不当行为（Heikki Linnakangas）\u003c/p\u003e\n\u003cp\u003e在复制重叠内存区域时使用 \u003ccode\u003ememmove()\u003c/code\u003e 而不是 \u003ccode\u003ememcpy()\u003c/code\u003e。尚无实际造成问题的现场报告，但这无疑是有风险的。\u003c/p\u003e","id":"9.3.3-4d4f516a0f72070d","identity_text":"Fix possible misbehavior in plainto_tsquery() (Heikki Linnakangas) Use memmove() not memcpy() for copying overlapping memory regions. There have been no field reports of this actually causing trouble, but it's certainly risky.","part":"changes","patch_ids":["6887b0d5d5b3e260f5a1fc5c579ae461"],"related_changes":[{"db_id":"3584d74976b07ad9c4dc56f943abc435","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5f2b2549524e3e113908ea16e76a8718dfd1d3d0e2d3d3e05a18ae4ecea1aefe"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 plainto_tsquery() 中可能的不当行为","url":"/docs/compare/?release=9.2.7#9.2.7-4d4f516a0f72070d","version":"9.2.7"},{"db_id":"91c677a48c5613d5b601edd2f050fbe4","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5f2b2549524e3e113908ea16e76a8718dfd1d3d0e2d3d3e05a18ae4ecea1aefe"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 plainto_tsquery() 中可能的不当行为","url":"/docs/compare/?release=9.1.12#9.1.12-4d4f516a0f72070d","version":"9.1.12"},{"db_id":"11527e9d63f3ed473939ba4be339e00b","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5f2b2549524e3e113908ea16e76a8718dfd1d3d0e2d3d3e05a18ae4ecea1aefe"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复 plainto_tsquery() 中可能的不当行为","url":"/docs/compare/?release=9.0.16#9.0.16-4d4f516a0f72070d","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5f2b2549524e3e113908ea16e76a8718dfd1d3d0e2d3d3e05a18ae4ecea1aefe"},"rule":2,"target":"11527e9d63f3ed473939ba4be339e00b","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5f2b2549524e3e113908ea16e76a8718dfd1d3d0e2d3d3e05a18ae4ecea1aefe"},"rule":2,"target":"3584d74976b07ad9c4dc56f943abc435","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"5f2b2549524e3e113908ea16e76a8718dfd1d3d0e2d3d3e05a18ae4ecea1aefe"},"rule":2,"target":"91c677a48c5613d5b601edd2f050fbe4","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["928aec71c"],"source_entry_id":"9.3.3/changes/049","source_hash":"9e959d813051444f6b8c439b538f98d3175b2c83b3898b5636db58835eb57016","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"5f2b2549524e3e113908ea16e76a8718dfd1d3d0e2d3d3e05a18ae4ecea1aefe","text":"修复 plainto_tsquery() 中可能的不当行为（Heikki Linnakangas） 在复制重叠内存区域时使用 memmove() 而不是 memcpy()。尚无实际造成问题的现场报告，但这无疑是有风险的。","title":"修复 plainto_tsquery() 中可能的不当行为","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["026a91f86","61d4d14ee","91c2755fc","9544cc0d6"],"commit_groups":[["026a91f86","61d4d14ee","91c2755fc","9544cc0d6"]],"commits":[],"cves":[],"db_id":"5e2a4d76d561056c600e4138ea9de2e3","html":"\u003cp\u003e修复 \u003ccode\u003epg_start_backup()\u003c/code\u003e 和 \u003ccode\u003epg_stop_backup()\u003c/code\u003e 中权限检查的位置（Andres Freund、Magnus Hagander）\u003c/p\u003e\n\u003cp\u003e先前的代码可能在不该访问系统目录时尝试访问。\u003c/p\u003e","id":"9.3.3-0be1096a46aa88c6","identity_text":"Fix placement of permissions checks in pg_start_backup() and pg_stop_backup() (Andres Freund, Magnus Hagander) The previous coding might attempt to do catalog access when it shouldn't.","part":"changes","patch_ids":["45778237272dc65691634e34a18efe9f"],"related_changes":[{"db_id":"597b91daeaf6cf1100116ab5dc343844","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"17adb5e95e11a626c7f5d55e91fd4b6371b87b21ba5e2065c93accb6042a9bb3"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 pg_start_backup() 和 pg_stop_backup() 中权限检查的位置","url":"/docs/compare/?release=9.2.7#9.2.7-0be1096a46aa88c6","version":"9.2.7"},{"db_id":"6dc4919ce36b958cad1f8179a7c06c39","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"17adb5e95e11a626c7f5d55e91fd4b6371b87b21ba5e2065c93accb6042a9bb3"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 pg_start_backup() 和 pg_stop_backup() 中权限检查的位置","url":"/docs/compare/?release=9.1.12#9.1.12-0be1096a46aa88c6","version":"9.1.12"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"17adb5e95e11a626c7f5d55e91fd4b6371b87b21ba5e2065c93accb6042a9bb3"},"rule":2,"target":"597b91daeaf6cf1100116ab5dc343844","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"17adb5e95e11a626c7f5d55e91fd4b6371b87b21ba5e2065c93accb6042a9bb3"},"rule":2,"target":"6dc4919ce36b958cad1f8179a7c06c39","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["91c2755fc"],"source_entry_id":"9.3.3/changes/050","source_hash":"06cb1e2e3b25a9961fe20c23e772e104961e663b153867fee8aa82a5c634cbe1","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"17adb5e95e11a626c7f5d55e91fd4b6371b87b21ba5e2065c93accb6042a9bb3","text":"修复 pg_start_backup() 和 pg_stop_backup() 中权限检查的位置（Andres Freund、Magnus Hagander） 先前的代码可能在不该访问系统目录时尝试访问。","title":"修复 pg_start_backup() 和 pg_stop_backup() 中权限检查的位置","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["035226c61","0c07ef1ad","1f0626ee4","69f77d756","7016d970d","8122e6f85"],"commit_groups":[["035226c61","0c07ef1ad","1f0626ee4","69f77d756","7016d970d","8122e6f85"]],"commits":[],"cves":[],"db_id":"9771bff578b97b093217263738f5d2fa","html":"\u003cp\u003e在区域检查方面接受 \u003ccode\u003eSHIFT_JIS\u003c/code\u003e 作为编码名（Tatsuo Ishii）\u003c/p\u003e","id":"9.3.3-180c20631458e44e","identity_text":"Accept SHIFT_JIS as an encoding name for locale checking purposes (Tatsuo Ishii)","part":"changes","patch_ids":["4252f68ae4cf6cb3eee3c4aba2f29ad2"],"related_changes":[{"db_id":"866c9eaa269f0f65fb023895be9f35ee","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"在区域检查方面接受 SHIFT_JIS 作为编码名","url":"/docs/compare/?release=9.2.7#9.2.7-180c20631458e44e","version":"9.2.7"},{"db_id":"f6f888ec1197e21a1c8d0720e5da29fa","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"在区域检查方面接受 SHIFT_JIS 作为编码名","url":"/docs/compare/?release=9.1.12#9.1.12-180c20631458e44e","version":"9.1.12"},{"db_id":"a04d579b3f501ab201d3464ef69d04bf","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"在区域检查方面接受 SHIFT_JIS 作为编码名","url":"/docs/compare/?release=9.0.16#9.0.16-180c20631458e44e","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"},"rule":2,"target":"866c9eaa269f0f65fb023895be9f35ee","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"},"rule":2,"target":"a04d579b3f501ab201d3464ef69d04bf","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"},"rule":2,"target":"f6f888ec1197e21a1c8d0720e5da29fa","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["8122e6f85"],"source_entry_id":"9.3.3/changes/051","source_hash":"e93f15ff444ab0f041852e7d293ab60e755ee6cd293529e99a4d5bb4c08a980e","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d","text":"在区域检查方面接受 SHIFT_JIS 作为编码名（Tatsuo Ishii）","title":"在区域检查方面接受 SHIFT_JIS 作为编码名","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0def2573c","641c08041","888b56570"],"commit_groups":[["0def2573c","641c08041","888b56570"]],"commits":[],"cves":[],"db_id":"6e11c5bb7da447848ebe2621fc11f308","html":"\u003cp\u003e修复 SQL 语言函数中命名参数的 \u003ccode\u003e*\u003c/code\u003e 限定（Tom Lane）\u003c/p\u003e\n\u003cp\u003e对于名为 \u003ccode\u003efoo\u003c/code\u003e 的组合类型参数，\u003ccode\u003e$1.*\u003c/code\u003e 工作正常，但 \u003ccode\u003efoo.*\u003c/code\u003e 就不行了。\u003c/p\u003e","id":"9.3.3-eb6c95b3a5b01721","identity_text":"Fix *-qualification of named parameters in SQL-language functions (Tom Lane) Given a composite-type parameter named foo, $1.* worked fine, but foo.* not so much.","part":"changes","patch_ids":["d3db6acfa4ebc787a6790626b0fd650d"],"related_changes":[{"db_id":"4478577fc4c52332f4e32c63abdfc389","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9eb9a231f1cd85b7fb23cc44bec90509591cbec46002b2012ac8a06389765c6d"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 SQL 语言函数中命名参数的 * 限定","url":"/docs/compare/?release=9.2.7#9.2.7-eb6c95b3a5b01721","version":"9.2.7"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9eb9a231f1cd85b7fb23cc44bec90509591cbec46002b2012ac8a06389765c6d"},"rule":2,"target":"4478577fc4c52332f4e32c63abdfc389","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["641c08041"],"source_entry_id":"9.3.3/changes/052","source_hash":"9232cea938daca212a6982257e4374fa2c910b7a60b8b1f2d9b3ca86b35f87ce","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"9eb9a231f1cd85b7fb23cc44bec90509591cbec46002b2012ac8a06389765c6d","text":"修复 SQL 语言函数中命名参数的 * 限定（Tom Lane） 对于名为 foo 的组合类型参数，$1.* 工作正常，但 foo.* 就不行了。","title":"修复 SQL 语言函数中命名参数的 * 限定","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["1b384aff1","5525529db","77035fa8a","996b21cbf","be5d49974","ea311bfdf"],"commit_groups":[["1b384aff1","5525529db","77035fa8a","996b21cbf","be5d49974","ea311bfdf"]],"commits":[],"cves":[],"db_id":"6334cd2eb111d5b2cfd0cd06ce8e5a7b","html":"\u003cp\u003e修复 \u003ccode\u003ePQhost()\u003c/code\u003e 在 Windows 上的不当行为（Fujii Masao）\u003c/p\u003e\n\u003cp\u003e如果未指定主机，它应返回 \u003ccode\u003elocalhost\u003c/code\u003e。\u003c/p\u003e","id":"9.3.3-b37c8dd469f73934","identity_text":"Fix misbehavior of PQhost() on Windows (Fujii Masao) It should return localhost if no host has been specified.","part":"changes","patch_ids":["013989e95cfce02e4dd61026b8de33fe"],"related_changes":[{"db_id":"5db54b36acb017ea25901f1533a95c0e","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 PQhost() 在 Windows 上的不当行为","url":"/docs/compare/?release=9.2.7#9.2.7-b37c8dd469f73934","version":"9.2.7"},{"db_id":"844108fae0db3a59b6f24237a7ad8720","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 PQhost() 在 Windows 上的不当行为","url":"/docs/compare/?release=9.1.12#9.1.12-b37c8dd469f73934","version":"9.1.12"},{"db_id":"2be4fa57cd17a0243188804f11d8aeb6","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复 PQhost() 在 Windows 上的不当行为","url":"/docs/compare/?release=9.0.16#9.0.16-b37c8dd469f73934","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"},"rule":2,"target":"2be4fa57cd17a0243188804f11d8aeb6","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"},"rule":2,"target":"5db54b36acb017ea25901f1533a95c0e","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"},"rule":2,"target":"844108fae0db3a59b6f24237a7ad8720","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["be5d49974"],"source_entry_id":"9.3.3/changes/053","source_hash":"34c1228c9ab6b2ccbf1ac607d3a4ccb0cf8f0beda5ee53f0da604f49a621329d","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262","text":"修复 PQhost() 在 Windows 上的不当行为（Fujii Masao） 如果未指定主机，它应返回 localhost。","title":"修复 PQhost() 在 Windows 上的不当行为","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["218dd205b","2573f08a1","7182bd239","7644a7bd8","b8f00a46b","f208fb436"],"commit_groups":[["218dd205b","2573f08a1","7182bd239","7644a7bd8","b8f00a46b","f208fb436"]],"commits":[],"cves":[],"db_id":"1977d3f1de2078a044157f02af2d57e2","html":"\u003cp\u003e改进 \u003cspan\u003elibpq\u003c/span\u003e 和 \u003cspan\u003epsql\u003c/span\u003e 对 \u003ccode\u003eCOPY TO STDOUT/FROM STDIN\u003c/code\u003e 期间失败的错误处理（Tom Lane）\u003c/p\u003e\n\u003cp\u003e这尤其修复了 9.2 及更高版本中，如果服务器连接在 \u003ccode\u003eCOPY FROM STDIN\u003c/code\u003e 期间丢失可能发生的无限循环。该场景的变体在旧版本或其他客户端应用中也可能出现。\u003c/p\u003e","id":"9.3.3-c1586eb7d0837e6d","identity_text":"Improve error handling in libpq and psql for failures during COPY TO STDOUT/FROM STDIN (Tom Lane) In particular this fixes an infinite loop that could occur in 9.2 and up if the server connection was lost during COPY FROM STDIN. Variants of that scenario might be possible in older versions, or with other client applications.","part":"changes","patch_ids":["7ea3d1ec7917e8d1c7eff55d21430571"],"related_changes":[{"db_id":"18946eb065f1162c255f7a086721af24","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"改进 libpq 和 psql 对 COPY TO STDOUT/FROM STDIN 期间失败的错误处理","url":"/docs/compare/?release=9.2.7#9.2.7-c1586eb7d0837e6d","version":"9.2.7"},{"db_id":"a87e12de3be8565fae3a0cc05ccbec93","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"改进 libpq 和 psql 对 COPY TO STDOUT/FROM STDIN 期间失败的错误处理","url":"/docs/compare/?release=9.1.12#9.1.12-c1586eb7d0837e6d","version":"9.1.12"},{"db_id":"abb33b9a9a77e4fcf26c39103d088b1d","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"改进 libpq 和 psql 对 COPY TO STDOUT/FROM STDIN 期间失败的错误处理","url":"/docs/compare/?release=9.0.16#9.0.16-c1586eb7d0837e6d","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"},"rule":2,"target":"18946eb065f1162c255f7a086721af24","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"},"rule":2,"target":"a87e12de3be8565fae3a0cc05ccbec93","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"},"rule":2,"target":"abb33b9a9a77e4fcf26c39103d088b1d","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["f208fb436"],"source_entry_id":"9.3.3/changes/054","source_hash":"2dcb1de2aa726ba9700b939ad36d218272c3b92071ceb5e01e3dd652c530d4a5","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703","text":"改进 libpq 和 psql 对 COPY TO STDOUT/FROM STDIN 期间失败的错误处理（Tom Lane） 这尤其修复了 9.2 及更高版本中，如果服务器连接在 COPY FROM STDIN 期间丢失可能发生的无限循环。该场景的变体在旧版本或其他客户端应用中也可能出现。","title":"改进 libpq 和 psql 对 COPY TO STDOUT/FROM STDIN 期间失败的错误处理","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["341f0bc49","92459e7a7","fa28f9cba"],"commit_groups":[["341f0bc49","92459e7a7","fa28f9cba"]],"commits":[],"cves":[],"db_id":"940e3d6ee22f2d908932076bab68b15d","html":"\u003cp\u003e修复某些 \u003cspan\u003epsql\u003c/span\u003e \u003ccode\u003e\\d\u003c/code\u003e 命令中不正确的翻译处理（Peter Eisentraut、Tom Lane）\u003c/p\u003e","id":"9.3.3-a70858f642ad5923","identity_text":"Fix incorrect translation handling in some psql \\d commands (Peter Eisentraut, Tom Lane)","part":"changes","patch_ids":["ab58b0a2dd272c4505c29615821ed9a7"],"related_changes":[{"db_id":"bb8fb12a373c8038d57c13ffc8b38ce4","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"d09f7a5d5ec8a94c24e57175f816e5e50d32b78648177f4e21bc0ec482546814"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复某些 psql \\d 命令中不正确的翻译处理","url":"/docs/compare/?release=9.2.7#9.2.7-a70858f642ad5923","version":"9.2.7"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"d09f7a5d5ec8a94c24e57175f816e5e50d32b78648177f4e21bc0ec482546814"},"rule":2,"target":"bb8fb12a373c8038d57c13ffc8b38ce4","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["341f0bc49"],"source_entry_id":"9.3.3/changes/055","source_hash":"8cb68967eb2e0b2aaea3c7527ee3f1b6b6c52234c95bb8c4372ca8cfadfa1918","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"d09f7a5d5ec8a94c24e57175f816e5e50d32b78648177f4e21bc0ec482546814","text":"修复某些 psql \\d 命令中不正确的翻译处理（Peter Eisentraut、Tom Lane）","title":"修复某些 psql \\d 命令中不正确的翻译处理","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0ae288d2d","63ab2befe","c90204c60"],"commit_groups":[["0ae288d2d","63ab2befe","c90204c60"]],"commits":[],"cves":[],"db_id":"4c9442f9874fa84d379711541d08e78b","html":"\u003cp\u003e确保 \u003cspan\u003epg_basebackup\u003c/span\u003e 的前台进程退出时其后台进程被终止（Magnus Hagander）\u003c/p\u003e","id":"9.3.3-01aa2d3a53e9fdee","identity_text":"Ensure pg_basebackup's background process is killed when exiting its foreground process (Magnus Hagander)","part":"changes","patch_ids":["55255c88c752215cd758a9da6ad14063"],"related_changes":[{"db_id":"6eac62da2e4a173d161c8591f63ae9fa","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c5c3e6da592237a83efb5ebc59aff949383d4f67aed2cfe7783a198f367acc96"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"确保 pg_basebackup 的前台进程退出时其后台进程被终止","url":"/docs/compare/?release=9.2.7#9.2.7-01aa2d3a53e9fdee","version":"9.2.7"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"c5c3e6da592237a83efb5ebc59aff949383d4f67aed2cfe7783a198f367acc96"},"rule":2,"target":"6eac62da2e4a173d161c8591f63ae9fa","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["c90204c60"],"source_entry_id":"9.3.3/changes/056","source_hash":"45d4126e1cabc482a8312d66c264283937c5ab5e66b1d81687cd8e037161c4a5","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"c5c3e6da592237a83efb5ebc59aff949383d4f67aed2cfe7783a198f367acc96","text":"确保 pg_basebackup 的前台进程退出时其后台进程被终止（Magnus Hagander）","title":"确保 pg_basebackup 的前台进程退出时其后台进程被终止","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["01025d80a","165aa1da5","680baa8d2","c6e5c4dd1"],"commit_groups":[["01025d80a","165aa1da5","680baa8d2","c6e5c4dd1"]],"commits":[],"cves":[],"db_id":"7076488c328bd98603d504ac2ce73912","html":"\u003cp\u003e修复 \u003cspan\u003epg_basebackup\u003c/span\u003e 详细模式下文件名可能打印错误的问题（Magnus Hagander）\u003c/p\u003e","id":"9.3.3-a1e8844c6e44b50c","identity_text":"Fix possible incorrect printing of filenames in pg_basebackup's verbose mode (Magnus Hagander)","part":"changes","patch_ids":["9328ba32be26d9fe683c80fdd6b36df0"],"related_changes":[{"db_id":"f39a444482cdb28c1185e183aff8b9ec","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"643643d3ffd6a9b6501ade1c0568e39dbcfb4385298e94b3ec7d1270c8664ab7"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 pg_basebackup 详细模式下文件名可能打印错误的问题","url":"/docs/compare/?release=9.2.7#9.2.7-a1e8844c6e44b50c","version":"9.2.7"},{"db_id":"538e58c1ee63fcc9f649baafee474f48","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"643643d3ffd6a9b6501ade1c0568e39dbcfb4385298e94b3ec7d1270c8664ab7"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 pg_basebackup 详细模式下文件名可能打印错误的问题","url":"/docs/compare/?release=9.1.12#9.1.12-a1e8844c6e44b50c","version":"9.1.12"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"643643d3ffd6a9b6501ade1c0568e39dbcfb4385298e94b3ec7d1270c8664ab7"},"rule":2,"target":"538e58c1ee63fcc9f649baafee474f48","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"643643d3ffd6a9b6501ade1c0568e39dbcfb4385298e94b3ec7d1270c8664ab7"},"rule":2,"target":"f39a444482cdb28c1185e183aff8b9ec","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["680baa8d2"],"source_entry_id":"9.3.3/changes/057","source_hash":"3e359e49b7227fa489bb5bba56415a0702a2a17b596bf88ad6a24b28b1faf1ef","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"643643d3ffd6a9b6501ade1c0568e39dbcfb4385298e94b3ec7d1270c8664ab7","text":"修复 pg_basebackup 详细模式下文件名可能打印错误的问题（Magnus Hagander）","title":"修复 pg_basebackup 详细模式下文件名可能打印错误的问题","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0463b9419","2edf3e82c","773e4d5e4","b168c5ef2"],"commit_groups":[["0463b9419","2edf3e82c","773e4d5e4","b168c5ef2"]],"commits":[],"cves":[],"db_id":"1f5a6456c9e4adfd9c1c368dc9a3ed71","html":"\u003cp\u003e避免在基础备份中把 PGDATA 内的表空间包含两次（Dimitri Fontaine、Magnus Hagander）\u003c/p\u003e","id":"9.3.3-968699dee9138b9c","identity_text":"Avoid including tablespaces inside PGDATA twice in base backups (Dimitri Fontaine, Magnus Hagander)","part":"changes","patch_ids":["b7c73de8666ac4c48e613ba2ff727d67"],"related_changes":[{"db_id":"6a4f01dfa6521c8033d9ba717615091e","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a8670bd07dad1206796d462e345374652f5958532e7382d833b7e5562a199df4"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"避免在基础备份中把 PGDATA 内的表空间包含两次","url":"/docs/compare/?release=9.2.7#9.2.7-968699dee9138b9c","version":"9.2.7"},{"db_id":"be798cdf9948784612abe0e7bfd94691","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a8670bd07dad1206796d462e345374652f5958532e7382d833b7e5562a199df4"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"避免在基础备份中把 PGDATA 内的表空间包含两次","url":"/docs/compare/?release=9.1.12#9.1.12-968699dee9138b9c","version":"9.1.12"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a8670bd07dad1206796d462e345374652f5958532e7382d833b7e5562a199df4"},"rule":2,"target":"6a4f01dfa6521c8033d9ba717615091e","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"a8670bd07dad1206796d462e345374652f5958532e7382d833b7e5562a199df4"},"rule":2,"target":"be798cdf9948784612abe0e7bfd94691","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["0463b9419"],"source_entry_id":"9.3.3/changes/058","source_hash":"2928e022b6a983c4f5f6ced00d7695a3589679cf5f05a828ebf720a0f3e79619","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"a8670bd07dad1206796d462e345374652f5958532e7382d833b7e5562a199df4","text":"避免在基础备份中把 PGDATA 内的表空间包含两次（Dimitri Fontaine、Magnus Hagander）","title":"避免在基础备份中把 PGDATA 内的表空间包含两次","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["28fff0ef8","799728b0b","9f5b3a1a1","a29b6c342","d685e2424","d68a65b01"],"commit_groups":[["28fff0ef8","799728b0b","9f5b3a1a1","a29b6c342","d685e2424","d68a65b01"]],"commits":[],"cves":[],"db_id":"6ade69ef56fb0dd48990328ce7dca6b0","html":"\u003cp\u003e修复 \u003cspan\u003eecpg\u003c/span\u003e 中未对齐的描述符（MauMau）\u003c/p\u003e","id":"9.3.3-64aa85b276874fb3","identity_text":"Fix misaligned descriptors in ecpg (MauMau)","part":"changes","patch_ids":["e03a09d8287b75a9efd6c0a67812b3f6"],"related_changes":[{"db_id":"4d69980cad10a28e2496f4dd4cddc7e8","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 ecpg 中未对齐的描述符","url":"/docs/compare/?release=9.2.7#9.2.7-64aa85b276874fb3","version":"9.2.7"},{"db_id":"ec5d2ade7e0c822042799186a50168ff","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 ecpg 中未对齐的描述符","url":"/docs/compare/?release=9.1.12#9.1.12-64aa85b276874fb3","version":"9.1.12"},{"db_id":"63187688b264935a9fb8c639a9e8279c","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复 ecpg 中未对齐的描述符","url":"/docs/compare/?release=9.0.16#9.0.16-64aa85b276874fb3","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"},"rule":2,"target":"4d69980cad10a28e2496f4dd4cddc7e8","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"},"rule":2,"target":"63187688b264935a9fb8c639a9e8279c","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"},"rule":2,"target":"ec5d2ade7e0c822042799186a50168ff","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["28fff0ef8"],"source_entry_id":"9.3.3/changes/059","source_hash":"2364e38a98e9d05017b8dd013a0f2efc7dc4709783db81c7353f4d682e3ba302","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f","text":"修复 ecpg 中未对齐的描述符（MauMau）","title":"修复 ecpg 中未对齐的描述符","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["119a59879","17bcdd01f","7c957ec83","8404037d8","948498274","96de4939c"],"commit_groups":[["119a59879","17bcdd01f","7c957ec83","8404037d8","948498274","96de4939c"]],"commits":[],"cves":[],"db_id":"4afa4aeef213bb9e4d870a5d611ec8ec","html":"\u003cp\u003e在 \u003cspan\u003eecpg\u003c/span\u003e 中正确处理连接参数中缺少主机名的情况（Michael Meskes）\u003c/p\u003e","id":"9.3.3-5be39aaedee6747a","identity_text":"In ecpg, handle lack of a hostname in the connection parameters properly (Michael Meskes)","part":"changes","patch_ids":["5fc097b300d6edecc744c564f8f804bc"],"related_changes":[{"db_id":"9ceb30ec27e9b5568d6e7846e555febe","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"在 ecpg 中正确处理连接参数中缺少主机名的情况","url":"/docs/compare/?release=9.2.7#9.2.7-5be39aaedee6747a","version":"9.2.7"},{"db_id":"d59fea6d312588389fd5cef530e33d24","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"在 ecpg 中正确处理连接参数中缺少主机名的情况","url":"/docs/compare/?release=9.1.12#9.1.12-5be39aaedee6747a","version":"9.1.12"},{"db_id":"a9a7c28946aaa4ecbcc57c3da8a77f66","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"在 ecpg 中正确处理连接参数中缺少主机名的情况","url":"/docs/compare/?release=9.0.16#9.0.16-5be39aaedee6747a","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"},"rule":2,"target":"9ceb30ec27e9b5568d6e7846e555febe","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"},"rule":2,"target":"a9a7c28946aaa4ecbcc57c3da8a77f66","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"},"rule":2,"target":"d59fea6d312588389fd5cef530e33d24","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["8404037d8"],"source_entry_id":"9.3.3/changes/060","source_hash":"e446c9dd087e4e9630c8a7dd0a3dcbe6063cb3dbb4efa538ce2f1f2e2c26d176","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c","text":"在 ecpg 中正确处理连接参数中缺少主机名的情况（Michael Meskes）","title":"在 ecpg 中正确处理连接参数中缺少主机名的情况","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0ec530625","6c8b16e30","70165f25b","7f4ef622f","9057adc23","d6ca510d9"],"commit_groups":[["0ec530625","6c8b16e30","70165f25b","7f4ef622f","9057adc23","d6ca510d9"]],"commits":[],"cves":[],"db_id":"98099b381e1ec49a7b3ab6e5a1ccdfca","html":"\u003cp\u003e修复 \u003ccode\u003econtrib/dblink\u003c/code\u003e 连接启动中的性能退化（Joe Conway）\u003c/p\u003e\n\u003cp\u003e在客户端和服务器编码一致时避免一次不必要的往返。\u003c/p\u003e","id":"9.3.3-7a047f19a28a01d9","identity_text":"Fix performance regression in contrib/dblink connection startup (Joe Conway) Avoid an unnecessary round trip when client and server encodings match.","part":"changes","patch_ids":["99374413eb03c5a4ad8db4510d4da7eb"],"related_changes":[{"db_id":"775f3b33cad27f641eef2602e318afa9","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 contrib/dblink 连接启动中的性能退化","url":"/docs/compare/?release=9.2.7#9.2.7-7a047f19a28a01d9","version":"9.2.7"},{"db_id":"5cb1d3ba7445ae6a191f7724379570f4","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 contrib/dblink 连接启动中的性能退化","url":"/docs/compare/?release=9.1.12#9.1.12-7a047f19a28a01d9","version":"9.1.12"},{"db_id":"4d74dcc2749f5c61e773a56a14b99eea","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复 contrib/dblink 连接启动中的性能退化","url":"/docs/compare/?release=9.0.16#9.0.16-7a047f19a28a01d9","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"},"rule":2,"target":"4d74dcc2749f5c61e773a56a14b99eea","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"},"rule":2,"target":"5cb1d3ba7445ae6a191f7724379570f4","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"},"rule":2,"target":"775f3b33cad27f641eef2602e318afa9","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["0ec530625"],"source_entry_id":"9.3.3/changes/061","source_hash":"77ea0d7446f5da04de1c791bfa39c65606d48621270de5881bca867ddea17e82","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd","text":"修复 contrib/dblink 连接启动中的性能退化（Joe Conway） 在客户端和服务器编码一致时避免一次不必要的往返。","title":"修复 contrib/dblink 连接启动中的性能退化","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["492b68541","50c5770ec","5143dfd57","6c3f040be","866a1f092","f6d6b42f2"],"commit_groups":[["492b68541","50c5770ec","5143dfd57","6c3f040be","866a1f092","f6d6b42f2"]],"commits":[],"cves":[],"db_id":"fd2cac0ffae045f6179466497f87b84c","html":"\u003cp\u003e修复 \u003ccode\u003econtrib/isn\u003c/code\u003e 中 ISMN 值校验位计算错误的问题（Fabien Coelho）\u003c/p\u003e","id":"9.3.3-12dc4e09c6994244","identity_text":"In contrib/isn, fix incorrect calculation of the check digit for ISMN values (Fabien Coelho)","part":"changes","patch_ids":["d15685548c228f14cab17d60ba6d5658"],"related_changes":[{"db_id":"36f14f8752af3dfa35b013a3705d8f0b","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 contrib/isn 中 ISMN 值校验位计算错误的问题","url":"/docs/compare/?release=9.2.7#9.2.7-12dc4e09c6994244","version":"9.2.7"},{"db_id":"9141a6601bbf463730fe47d298a3829b","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"修复 contrib/isn 中 ISMN 值校验位计算错误的问题","url":"/docs/compare/?release=9.1.12#9.1.12-12dc4e09c6994244","version":"9.1.12"},{"db_id":"c4ff74999ccd489cec6330b58a38053a","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"修复 contrib/isn 中 ISMN 值校验位计算错误的问题","url":"/docs/compare/?release=9.0.16#9.0.16-12dc4e09c6994244","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"},"rule":2,"target":"36f14f8752af3dfa35b013a3705d8f0b","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"},"rule":2,"target":"9141a6601bbf463730fe47d298a3829b","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"},"rule":2,"target":"c4ff74999ccd489cec6330b58a38053a","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["50c5770ec"],"source_entry_id":"9.3.3/changes/062","source_hash":"5010fce2bbc4a133e71f4272940db640ee8638e47352441b7663d7c75885bf10","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2","text":"修复 contrib/isn 中 ISMN 值校验位计算错误的问题（Fabien Coelho）","title":"修复 contrib/isn 中 ISMN 值校验位计算错误的问题","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["27902bc91","841a65482"],"commit_groups":[["27902bc91","841a65482"]],"commits":[],"cves":[],"db_id":"2ab0f96d9347ce3a0822167ad064ef89","html":"\u003cp\u003e修复 \u003ccode\u003econtrib/pgbench\u003c/code\u003e 的进度日志，避免缩放因子很大时溢出（Tatsuo Ishii）\u003c/p\u003e","id":"9.3.3-e7760eccc968f5b5","identity_text":"Fix contrib/pgbench's progress logging to avoid overflow when the scale factor is large (Tatsuo Ishii)","part":"changes","patch_ids":["a85422e3e70542e8ec6c095f9d5f810e"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["27902bc91"],"source_entry_id":"9.3.3/changes/063","source_hash":"cb3801f1de847d4fb2c53fb39e27a635484deb61917ee309e91350ebb4229979","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"2999e5cfdfb4051be32cd8c6e795f02106c6ab5cc1cf36826da53ca50f4e9105","text":"修复 contrib/pgbench 的进度日志，避免缩放因子很大时溢出（Tatsuo Ishii）","title":"修复 contrib/pgbench 的进度日志，避免缩放因子很大时溢出","variants":[],"version":"9.3.3"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0950d67ee","27ab1eb7e","69c7a9838"],"commit_groups":[["0950d67ee","27ab1eb7e","69c7a9838"]],"commits":[],"cves":[],"db_id":"517b0a2ebf1fb0debc46d837010e22b7","html":"\u003cp\u003e修复 \u003ccode\u003econtrib/pg_stat_statement\u003c/code\u003e 对 \u003ccode\u003eCURRENT_DATE\u003c/code\u003e 及相关构造的处理（Kyotaro Horiguchi）\u003c/p\u003e","id":"9.3.3-e2ba7295cc1bd643","identity_text":"Fix contrib/pg_stat_statement's handling of CURRENT_DATE and related constructs (Kyotaro Horiguchi)","part":"changes","patch_ids":["864532af57c70a346dbc89c8169246c8"],"related_changes":[{"db_id":"03b3ab07c5bbadb47f48bde12b038782","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"478a4ad21605f5c5031abae99723b1e23b20fad08cfb9c4b76cd742c389a50c0"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"修复 contrib/pg_stat_statement 对 CURRENT_DATE 及相关构造的处理","url":"/docs/compare/?release=9.2.7#9.2.7-e2ba7295cc1bd643","version":"9.2.7"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"478a4ad21605f5c5031abae99723b1e23b20fad08cfb9c4b76cd742c389a50c0"},"rule":2,"target":"03b3ab07c5bbadb47f48bde12b038782","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["0950d67ee"],"source_entry_id":"9.3.3/changes/064","source_hash":"e02eaed490c91e1fb56a9fce6fd3c133e2ccb8e82d2db158adb45209086761a8","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"478a4ad21605f5c5031abae99723b1e23b20fad08cfb9c4b76cd742c389a50c0","text":"修复 contrib/pg_stat_statement 对 CURRENT_DATE 及相关构造的处理（Kyotaro Horiguchi）","title":"修复 contrib/pg_stat_statement 对 CURRENT_DATE 及相关构造的处理","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["00d4f2af8","eb3d350db"],"commit_groups":[["00d4f2af8","eb3d350db"]],"commits":[],"cves":[],"db_id":"bef921a6a01d35774e145cf9f14840a2","html":"\u003cp\u003e改进 \u003ccode\u003econtrib/postgres_fdw\u003c/code\u003e 对连接丢失的错误处理（Tom Lane）\u003c/p\u003e","id":"9.3.3-8dfd8e588e048a5f","identity_text":"Improve lost-connection error handling in contrib/postgres_fdw (Tom Lane)","part":"changes","patch_ids":["e8f6f7a0f7c701057d567d4950bb6b28"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["eb3d350db"],"source_entry_id":"9.3.3/changes/065","source_hash":"3f3c107749507021c5f014b87efe54b61f2339cff215a35c3bc03c23cc57410b","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"3bb8e51ace87a4e40c6037ff31db654011accf9c96ea3cce4a82c7c71240016e","text":"改进 contrib/postgres_fdw 对连接丢失的错误处理（Tom Lane）","title":"改进 contrib/postgres_fdw 对连接丢失的错误处理","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["15699d9bf","2346c383a","526e38751","586bea612","6d969b000","ad6bf0291"],"commit_groups":[["15699d9bf","2346c383a","526e38751","586bea612","6d969b000","ad6bf0291"]],"commits":[],"cves":[],"db_id":"58bd9f078f3ada69900a6b8cbbe2602d","html":"\u003cp\u003e确保仅安装客户端代码的流程按文档说明工作（Peter Eisentraut）\u003c/p\u003e","id":"9.3.3-182deaaf76fb1a8c","identity_text":"Ensure client-code-only installation procedure works as documented (Peter Eisentraut)","part":"changes","patch_ids":["dabeb3e5a477cea65343e6f471110c1b"],"related_changes":[{"db_id":"d17b909c487519e35c91540ad9a14013","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"确保仅安装客户端代码的流程按文档说明工作","url":"/docs/compare/?release=9.2.7#9.2.7-182deaaf76fb1a8c","version":"9.2.7"},{"db_id":"c7b6f1186ffd36c215a6e25af968b3aa","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"确保仅安装客户端代码的流程按文档说明工作","url":"/docs/compare/?release=9.1.12#9.1.12-182deaaf76fb1a8c","version":"9.1.12"},{"db_id":"c303c36187628f862cebe9630133e7d7","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"确保仅安装客户端代码的流程按文档说明工作","url":"/docs/compare/?release=9.0.16#9.0.16-182deaaf76fb1a8c","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"},"rule":2,"target":"c303c36187628f862cebe9630133e7d7","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"},"rule":2,"target":"c7b6f1186ffd36c215a6e25af968b3aa","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"},"rule":2,"target":"d17b909c487519e35c91540ad9a14013","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["586bea612"],"source_entry_id":"9.3.3/changes/066","source_hash":"f5e23ded6f91426b954fd0ae7245d1691dab2ce19f0cdd9e9c01825c8b994e48","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011","text":"确保仅安装客户端代码的流程按文档说明工作（Peter Eisentraut）","title":"确保仅安装客户端代码的流程按文档说明工作","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["1e9876c3b","59d64e7f3","6e96d4db8","ae3c98b9b","d587298b8","dfb4a1a21"],"commit_groups":[["1e9876c3b","59d64e7f3","6e96d4db8","ae3c98b9b","d587298b8","dfb4a1a21"]],"commits":[],"cves":[],"db_id":"0302567255deea4d2411fab39bd02c56","html":"\u003cp\u003e在 Mingw 和 Cygwin 构建中，把 \u003cspan\u003elibpq\u003c/span\u003e DLL 安装到 \u003ccode\u003ebin\u003c/code\u003e 目录（Andrew Dunstan）\u003c/p\u003e\n\u003cp\u003e这与 MSVC 构建长期以来的做法一致。它应该能解决 \u003cspan\u003epsql\u003c/span\u003e 等程序因找不到 DLL 而无法启动的问题。\u003c/p\u003e","id":"9.3.3-49e072b5f4bb2a3c","identity_text":"In Mingw and Cygwin builds, install the libpq DLL in the bin directory (Andrew Dunstan) This duplicates what the MSVC build has long done. It should fix problems with programs like psql failing to start because they can't find the DLL.","part":"changes","patch_ids":["9d06b52bf2870e0983b0a028ceb19583"],"related_changes":[{"db_id":"fee9d6a59e850baf90cda45821eecacf","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"在 Mingw 和 Cygwin 构建中，把 libpq DLL 安装到 bin 目录","url":"/docs/compare/?release=9.2.7#9.2.7-49e072b5f4bb2a3c","version":"9.2.7"},{"db_id":"b6021cbbca322e4b8f2cd2271b75b619","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"在 Mingw 和 Cygwin 构建中，把 libpq DLL 安装到 bin 目录","url":"/docs/compare/?release=9.1.12#9.1.12-49e072b5f4bb2a3c","version":"9.1.12"},{"db_id":"89491f71df83763d94751b95b329fa93","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"在 Mingw 和 Cygwin 构建中，把 libpq DLL 安装到 bin 目录","url":"/docs/compare/?release=9.0.16#9.0.16-49e072b5f4bb2a3c","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"},"rule":2,"target":"89491f71df83763d94751b95b329fa93","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"},"rule":2,"target":"b6021cbbca322e4b8f2cd2271b75b619","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"},"rule":2,"target":"fee9d6a59e850baf90cda45821eecacf","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["1e9876c3b"],"source_entry_id":"9.3.3/changes/067","source_hash":"f7d5416438508338990fb8613b75ad0fc2fab9ab994a785880e329fcdaab4396","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e","text":"在 Mingw 和 Cygwin 构建中，把 libpq DLL 安装到 bin 目录（Andrew Dunstan） 这与 MSVC 构建长期以来的做法一致。它应该能解决 psql 等程序因找不到 DLL 而无法启动的问题。","title":"在 Mingw 和 Cygwin 构建中，把 libpq DLL 安装到 bin 目录","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["1c0bf372f","27942baf4","7e1531a45","e5c22c15d","fad443753"],"commit_groups":[["1c0bf372f","27942baf4","7e1531a45","e5c22c15d","fad443753"]],"commits":[],"cves":[],"db_id":"98dd7d1085b2b4e05b5546f35e08703d","html":"\u003cp\u003e在 Cygwin 构建中避免使用已弃用的 \u003ccode\u003edllwrap\u003c/code\u003e 工具（Marco Atzeri）\u003c/p\u003e","id":"9.3.3-46874437a5da5287","identity_text":"Avoid using the deprecated dllwrap tool in Cygwin builds (Marco Atzeri)","part":"changes","patch_ids":["16605be71037570d0fad52f59b71aba9"],"related_changes":[{"db_id":"1d75a6e6f4b4ab0a85036c110643ff2d","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"在 Cygwin 构建中避免使用已弃用的 dllwrap 工具","url":"/docs/compare/?release=9.2.7#9.2.7-46874437a5da5287","version":"9.2.7"},{"db_id":"2fbbffbfcc77e3b6cb58dfd390835926","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"在 Cygwin 构建中避免使用已弃用的 dllwrap 工具","url":"/docs/compare/?release=9.1.12#9.1.12-46874437a5da5287","version":"9.1.12"},{"db_id":"7edd7a9bd2c1a7a388c02f3986440490","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"在 Cygwin 构建中避免使用已弃用的 dllwrap 工具","url":"/docs/compare/?release=9.0.16#9.0.16-46874437a5da5287","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"},"rule":2,"target":"1d75a6e6f4b4ab0a85036c110643ff2d","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"},"rule":2,"target":"2fbbffbfcc77e3b6cb58dfd390835926","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"},"rule":2,"target":"7edd7a9bd2c1a7a388c02f3986440490","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["27942baf4"],"source_entry_id":"9.3.3/changes/068","source_hash":"67e90d8a54ad13e94bd6202bf9dc78e93282a45968abc4842ce64cf91bc772f7","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240","text":"在 Cygwin 构建中避免使用已弃用的 dllwrap 工具（Marco Atzeri）","title":"在 Cygwin 构建中避免使用已弃用的 dllwrap 工具","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["56c08df55","cec8394b5"],"commit_groups":[["56c08df55","cec8394b5"]],"commits":[],"cves":[],"db_id":"4ea721283f5f3b7c3fd6ba4a409971e2","html":"\u003cp\u003e支持使用 Visual Studio 2013 构建（Brar Piening）\u003c/p\u003e","id":"9.3.3-49ea155f33ac1db4","identity_text":"Enable building with Visual Studio 2013 (Brar Piening)","part":"changes","patch_ids":["1d966e647bd4c6c2268351c83a6c60b2"],"related_changes":[],"relations":[],"section":"变更","section_path":["变更"],"source_commits":["56c08df55"],"source_entry_id":"9.3.3/changes/069","source_hash":"d077410e8fc702f0fd9120a8341af4d1808956bb8d583edf6663e9b84db55c2a","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"10c7d80e280c3edeea102b663c4fc6acdca940d3e8f23f5479fd1d89e27e0414","text":"支持使用 Visual Studio 2013 构建（Brar Piening）","title":"支持使用 Visual Studio 2013 构建","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["289541520","3bf5c16f1","432735cbf","dd5605104","e1e7642bd","f1e522696"],"commit_groups":[["289541520","3bf5c16f1","432735cbf","dd5605104","e1e7642bd","f1e522696"]],"commits":[],"cves":[],"db_id":"6366e113cf58bb2656b7567937084988","html":"\u003cp\u003e不再生成纯文本的 \u003ccode\u003eHISTORY\u003c/code\u003e 和 \u003ccode\u003esrc/test/regress/README\u003c/code\u003e 文件（Tom Lane）\u003c/p\u003e\n\u003cp\u003e这些文本文件与主文档的 HTML 和 PDF 格式重复。维护它们的麻烦远远超过纯文本格式可能的读者。发行版压缩包仍会包含这些名字的文件，但它们只是提示读者查阅主文档的存根。纯文本 \u003ccode\u003eINSTALL\u003c/code\u003e 文件仍将维护，因为它可以说还有使用场景。\u003c/p\u003e","id":"9.3.3-4866656560537de7","identity_text":"Don't generate plain-text HISTORY and src/test/regress/README files anymore (Tom Lane) These text files duplicated the main HTML and PDF documentation formats. The trouble involved in maintaining them greatly outweighs the likely audience for plain-text format. Distribution tarballs will still contain files by these names, but they'll just be stubs directing the reader to consult the main documentation. The plain-text INSTALL file will still be maintained, as there is arguably a use-case for that.","part":"changes","patch_ids":["7d33667521b455963a8c0a83d900998a"],"related_changes":[{"db_id":"151af5bd1019d9736efc077efdcd8826","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"不再生成纯文本的 HISTORY 和 src/test/regress/README 文件","url":"/docs/compare/?release=9.2.7#9.2.7-4866656560537de7","version":"9.2.7"},{"db_id":"ce2a90a400c4464691f3dd8c089042fb","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"不再生成纯文本的 HISTORY 和 src/test/regress/README 文件","url":"/docs/compare/?release=9.1.12#9.1.12-4866656560537de7","version":"9.1.12"},{"db_id":"8f5abd09149c838e8965a43513b33d71","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"不再生成纯文本的 HISTORY 和 src/test/regress/README 文件","url":"/docs/compare/?release=9.0.16#9.0.16-4866656560537de7","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"},"rule":2,"target":"151af5bd1019d9736efc077efdcd8826","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"},"rule":2,"target":"8f5abd09149c838e8965a43513b33d71","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"},"rule":2,"target":"ce2a90a400c4464691f3dd8c089042fb","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["f1e522696"],"source_entry_id":"9.3.3/changes/070","source_hash":"73fd9f7771ad7a52b74eb07cd75d12ee7e46a49abddf81169455f2016c5828d0","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea","text":"不再生成纯文本的 HISTORY 和 src/test/regress/README 文件（Tom Lane） 这些文本文件与主文档的 HTML 和 PDF 格式重复。维护它们的麻烦远远超过纯文本格式可能的读者。发行版压缩包仍会包含这些名字的文件，但它们只是提示读者查阅主文档的存根。纯文本 INSTALL 文件仍将维护，因为它可以说还有使用场景。","title":"不再生成纯文本的 HISTORY 和 src/test/regress/README 文件","variants":[],"version":"9.3.3"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["3212ba534","46cbcd50e","4f975b68b","c0c2d62ac","cb84fddd9","e04641f4b"],"commit_groups":[["3212ba534","46cbcd50e","4f975b68b","c0c2d62ac","cb84fddd9","e04641f4b"]],"commits":[],"cves":[],"db_id":"6f7af8ff0b09719347f315962ff9c3e4","html":"\u003cp\u003e把时区数据文件更新为 \u003cspan\u003etzdata\u003c/span\u003e 版本 2013i，以反映约旦的夏令时法规变更和古巴的历史变更。\u003c/p\u003e\n\u003cp\u003e此外，时区 \u003ccode\u003eAsia/Riyadh87\u003c/code\u003e、\u003ccode\u003eAsia/Riyadh88\u003c/code\u003e 和 \u003ccode\u003eAsia/Riyadh89\u003c/code\u003e 已被移除，因为 IANA 不再维护它们，而且它们从未代表过实际的民用计时实践。\u003c/p\u003e","id":"9.3.3-1f3aa232eb6ba7c2","identity_text":"Update time zone data files to tzdata release 2013i for DST law changes in Jordan and historical changes in Cuba. In addition, the zones Asia/Riyadh87, Asia/Riyadh88, and Asia/Riyadh89 have been removed, as they are no longer maintained by IANA, and never represented actual civil timekeeping practice.","part":"changes","patch_ids":["fd2290b7a70cc6cb66ad232720130caf"],"related_changes":[{"db_id":"67da9ec3694c31e9359907b451b82be8","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"},"kind":"equivalent","label":"9.2.7","source_url":"/docs/release/9.2.7/#id-1.11.6.22.5","title":"把时区数据文件更新为 tzdata 版本 2013i for DST law changes in Jordan and historical changes in Cuba。","url":"/docs/compare/?release=9.2.7#9.2.7-c3663420a561a922","version":"9.2.7"},{"db_id":"4e888fdfc2f702951597a37abbd78ad8","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"},"kind":"equivalent","label":"9.1.12","source_url":"/docs/release/9.1.12/#id-1.11.6.17.5","title":"把时区数据文件更新为 tzdata 版本 2013i for DST law changes in Jordan and historical changes in Cuba。","url":"/docs/compare/?release=9.1.12#9.1.12-c3663420a561a922","version":"9.1.12"},{"db_id":"abe89ecfd07e3e8b4e40f90e03f43376","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"},"kind":"equivalent","label":"9.0.16","source_url":"/docs/release/9.0.16/#id-1.11.6.12.5","title":"把时区数据文件更新为 tzdata 版本 2013i（约旦的夏令时法规变更以及古巴的历史变更）。","url":"/docs/compare/?release=9.0.16#9.0.16-a88b158de6f55ce2","version":"9.0.16"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"},"rule":2,"target":"4e888fdfc2f702951597a37abbd78ad8","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"},"rule":2,"target":"67da9ec3694c31e9359907b451b82be8","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"},"rule":2,"target":"abe89ecfd07e3e8b4e40f90e03f43376","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":["46cbcd50e"],"source_entry_id":"9.3.3/changes/071","source_hash":"2887e332c6e809ef93d1c50205f6bf370b1ba41b7a6fb50be666b8652b03e36a","source_url":"/docs/release/9.3.3/#id-1.11.6.27.5","statement_hash":"69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37","text":"把时区数据文件更新为 tzdata 版本 2013i，以反映约旦的夏令时法规变更和古巴的历史变更。 此外，时区 Asia/Riyadh87、Asia/Riyadh88 和 Asia/Riyadh89 已被移除，因为 IANA 不再维护它们，而且它们从未代表过实际的民用计时实践。","title":"把时区数据文件更新为 tzdata 版本 2013i，以反映约旦的夏令时法规变更和古巴的历史变更。","variants":[],"version":"9.3.3"}],"entry_count":71,"eol":"2018-11-08","eol_date":"2018-11-08","label":"9.3.3","major":"9.3","manual":"9.3","manual_build":"9.3.25","manual_url":"/docs/9.3/release-9-3-3.html","migration_html":"\u003cp\u003e对于运行 9.3.X 的用户，不需要进行转储/恢复。\u003c/p\u003e\n\u003cp\u003e不过，本版本纠正的若干问题可能已经导致外键约束损坏；也就是说，现在可能存在在被引用表中没有匹配行的引用行。在安装此更新后，重新检查这类约束可能是值得的。最简单的方法是删除并重建每个可疑约束；但这需要对两个表都加排他锁，因此在生产数据库中不太可能被接受。另一种办法是对两个表手工执行连接查询来查找不匹配的行。\u003c/p\u003e\n\u003cp\u003e还要注意：复制备库服务器必须先于其主库服务器升级。\u003c/p\u003e\n\u003cp\u003e不过，如果你是从早于 9.3.2 的版本升级，请参见\u003ca href=\"/docs/9.3/release-9-3-2.html\" title=\"E.24. 版本 9.3.2\"\u003e第 E.24 节\u003c/a\u003e。\u003c/p\u003e","minor":3,"placeholder":false,"source_as_of":"","source_url":"/docs/release/9.3.3/","status":"stable","status_label":"Historical","support_days":-2895,"supported":false,"version":"9.3.3"}],"mode":"release","release_count":1,"remaining_cves":[],"security_as_of":"2026-09-26","security_regressions":[],"source_as_of":"2026-09-26","stats":[{"count":71,"key":"all","label":"All changes"},{"count":0,"key":"feature","label":"Features"},{"count":33,"key":"bugfix","label":"Bug fixes"},{"count":8,"key":"security","label":"Security"},{"count":1,"key":"performance","label":"Performance"},{"count":0,"key":"compatibility","label":"Compatibility"},{"count":29,"key":"improvement","label":"Improvements"}],"to_release":{"age_days":4617,"build":"9.3.3","changes_count":71,"compatibility_count":0,"content_hash":"a9b07ead63ed242db533001b03b822b955a3d46ba1c9797fd3db0007523f3dbd","date":"2014-02-20","date_text":"2014-02-20","doc_git":"","doc_loaded_at":"2026-09-26T02:56:46.133805","entry_count":71,"eol":"2018-11-08","eol_date":"2018-11-08","label":"9.3.3","major":"9.3","manual":"9.3","manual_build":"9.3.25","manual_url":"/docs/9.3/release-9-3-3.html","migration_html":"\u003cp\u003e对于运行 9.3.X 的用户，不需要进行转储/恢复。\u003c/p\u003e\n\u003cp\u003e不过，本版本纠正的若干问题可能已经导致外键约束损坏；也就是说，现在可能存在在被引用表中没有匹配行的引用行。在安装此更新后，重新检查这类约束可能是值得的。最简单的方法是删除并重建每个可疑约束；但这需要对两个表都加排他锁，因此在生产数据库中不太可能被接受。另一种办法是对两个表手工执行连接查询来查找不匹配的行。\u003c/p\u003e\n\u003cp\u003e还要注意：复制备库服务器必须先于其主库服务器升级。\u003c/p\u003e\n\u003cp\u003e不过，如果你是从早于 9.3.2 的版本升级，请参见\u003ca href=\"/docs/9.3/release-9-3-2.html\" title=\"E.24. 版本 9.3.2\"\u003e第 E.24 节\u003c/a\u003e。\u003c/p\u003e","minor":3,"placeholder":false,"source_as_of":"","source_url":"/docs/release/9.3.3/","status":"stable","status_label":"Historical","support_days":-2895,"supported":false,"version":"9.3.3"},"total":71,"warnings":[]}