{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2017-08-10", "build": "9.2.22", "major": "9.2", "minor": 22, "manual": "9.2", "status": "stable", "doc_git": "", "version": "9.2.22", "eol_date": "2017-11-09", "date_text": "2017-08-10", "supported": false, "manual_url": "/docs/9.2/release-9-2-22.html", "source_url": "/docs/release/9.2.22/", "entry_count": 32, "placeholder": false, "content_hash": "62cf77a726eb3a38167eca94364ccccea059997af5ef275a82e5edd0d20df322", "manual_build": "9.2.24", "source_as_of": "", "changes_count": 32, "doc_loaded_at": "2026-09-26T02:56:46.946617", "migration_html": "

对于运行 9.2.X 的用户，不需要进行转储/恢复。

但是，如果你使用的外部数据服务器依赖用户密码进行认证，请参见下面的第一条变更日志条目。\n

不过，如果你是从早于 9.2.20 的版本升级，请参见第 E.5 节。

", "compatibility_count": 0, "label": "9.2.22", "status_label": "历史版本", "eol": "2017-11-09", "age_days": 3338, "support_days": -3247}, "groups": [{"date": "2017-08-10", "build": "9.2.22", "major": "9.2", "minor": 22, "manual": "9.2", "status": "stable", "doc_git": "", "version": "9.2.22", "eol_date": "2017-11-09", "date_text": "2017-08-10", "supported": false, "manual_url": "/docs/9.2/release-9-2-22.html", "source_url": "/docs/release/9.2.22/", "entry_count": 32, "placeholder": false, "content_hash": "62cf77a726eb3a38167eca94364ccccea059997af5ef275a82e5edd0d20df322", "manual_build": "9.2.24", "source_as_of": "", "changes_count": 32, "doc_loaded_at": "2026-09-26T02:56:46.946617", "migration_html": "

对于运行 9.2.X 的用户，不需要进行转储/恢复。

但是，如果你使用的外部数据服务器依赖用户密码进行认证，请参见下面的第一条变更日志条目。\n

不过，如果你是从早于 9.2.20 的版本升级，请参见第 E.5 节。

", "compatibility_count": 0, "label": "9.2.22", "status_label": "历史版本", "eol": "2017-11-09", "age_days": 3338, "support_days": -3247, "entries": [{"id": "9.2.22-a79358365b635764", "cves": ["CVE-2017-7486", "CVE-2017-7547"], "html": "

进一步限制\n pg_user_mappings.umoptions\n 的可见性，以保护存储为用户映射选项的密码（Noah Misch）\n

CVE-2017-7486 的修复不正确：它允许用户看到她自己用户映射中的选项，即使她对相关外部服务器没有 USAGE 权限。这种选项可能包含由服务器所有者而非用户自己提供的密码。由于\n information_schema.user_mapping_options\n 在这种情况下不显示选项，pg_user_mappings\n 也不应该。（CVE-2017-7547）\n

此补丁本身只会修复新 initdb 的数据库中的行为。如果希望在现有数据库中应用此更改，需要执行以下操作：\n

  1. 在 postgresql.conf 中添加\n allow_system_table_mods = true 后重启 postmaster。（在支持 ALTER SYSTEM 的版本中，可以用它进行配置更改，但仍需重启。）\n

  2. 在集簇的每个数据库中，以超级用户身份运行以下命令：

    SET search_path = pg_catalog;\nCREATE OR REPLACE VIEW pg_user_mappings AS\nSELECT U.oid AS umid, S.oid AS srvid, S.srvname AS srvname,\n       U.umuser AS umuser,\n       CASE WHEN U.umuser = 0 THEN 'public' ELSE A.rolname END AS usename,\n       CASE WHEN (U.umuser <> 0 AND A.rolname = current_user\n                   AND (pg_has_role(S.srvowner, 'USAGE')\n                        OR has_server_privilege(S.oid, 'USAGE')))\n                OR (U.umuser = 0 AND pg_has_role(S.srvowner, 'USAGE'))\n                OR (SELECT rolsuper FROM pg_authid WHERE rolname = current_user)\n            THEN U.umoptions ELSE NULL END AS umoptions\nFROM pg_user_mapping U\n     LEFT JOIN pg_authid A ON (A.oid = U.umuser)\n     JOIN pg_foreign_server S ON (U.umserver = S.oid);

    \n

  3. 不要忘记包括 template0 和\n template1 数据库，否则漏洞仍会存在于之后创建的数据库中。要修复 template0，需要暂时让它接受连接。在 PostgreSQL 9.5 及之后，可以使用 

    ALTER DATABASE template0 WITH ALLOW_CONNECTIONS true;

    \n 修复 template0 之后再撤销：\n 

    ALTER DATABASE template0 WITH ALLOW_CONNECTIONS false;

    \n 在更早的版本中，改用：\n 

    UPDATE pg_database SET datallowconn = true WHERE datname = 'template0';\nUPDATE pg_database SET datallowconn = false WHERE datname = 'template0';

    \n

  4. 最后，移除 allow_system_table_mods 配置设置，并再次重启 postmaster。\n

", "text": "进一步限制 pg_user_mappings.umoptions 的可见性，以保护存储为用户映射选项的密码（Noah Misch） CVE-2017-7486 的修复不正确：它允许用户看到她自己用户映射中的选项，即使她对相关外部服务器没有 USAGE 权限。这种选项可能包含由服务器所有者而非用户自己提供的密码。由于 information_schema.user_mapping_options 在这种情况下不显示选项，pg_user_mappings 也不应该。（CVE-2017-7547） 此补丁本身只会修复新 initdb 的数据库中的行为。如果希望在现有数据库中应用此更改，需要执行以下操作： 在 postgresql.conf 中添加 allow_system_table_mods = true 后重启 postmaster。（在支持 ALTER SYSTEM 的版本中，可以用它进行配置更改，但仍需重启。） 在集簇的每个数据库中，以超级用户身份运行以下命令： SET search_path = pg_catalog; CREATE OR REPLACE VIEW pg_user_mappings AS SELECT U.oid AS umid, S.oid AS srvid, S.srvname AS srvname, U.umuser AS umuser, CASE WHEN U.umuser = 0 THEN 'public' ELSE A.rolname END AS usename, CASE WHEN (U.umuser <> 0 AND A.rolname = current_user AND (pg_has_role(S.srvowner, 'USAGE') OR has_server_privilege(S.oid, 'USAGE'))) OR (U.umuser = 0 AND pg_has_role(S.srvowner, 'USAGE')) OR (SELECT rolsuper FROM pg_authid WHERE rolname = current_user) THEN U.umoptions ELSE NULL END AS umoptions FROM pg_user_mapping U LEFT JOIN pg_authid A ON (A.oid = U.umuser) JOIN pg_foreign_server S ON (U.umserver = S.oid); 不要忘记包括 template0 和 template1 数据库，否则漏洞仍会存在于之后创建的数据库中。要修复 template0，需要暂时让它接受连接。在 PostgreSQL 9.5 及之后，可以使用 ALTER DATABASE template0 WITH ALLOW_CONNECTIONS true; 修复 template0 之后再撤销： ALTER DATABASE template0 WITH ALLOW_CONNECTIONS false; 在更早的版本中，改用： UPDATE pg_database SET datallowconn = true WHERE datname = 'template0'; UPDATE pg_database SET datallowconn = false WHERE datname = 'template0'; 最后，移除 allow_system_table_mods 配置设置，并再次重启 postmaster。", "title": "进一步限制 pg_user_mappings.umoptions 的可见性，以保护存储为用户映射选项的密码", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "ff27cd86a1c520129bad55afba59e27d5b755a18516a627315cc065cc459d84e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Further restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options (Noah Misch) The fix for CVE-2017-7486 was incorrect: it allowed a user to see the options in her own user mapping, even if she did not have USAGE permission on the associated foreign server. Such options might include a password that had been provided by the server owner rather than the user herself. Since information_schema.user_mapping_options does not show the options in such cases, pg_user_mappings should not either. (CVE-2017-7547) By itself, this patch will only fix the behavior in newly initdb'd databases. If you wish to apply this change in an existing database, you will need to do the following: Restart the postmaster after adding allow_system_table_mods = true to postgresql.conf. (In versions supporting ALTER SYSTEM, you can use that to make the configuration change, but you'll still need a restart.) In each database of the cluster, run the following commands as superuser: SET search_path = pg_catalog; CREATE OR REPLACE VIEW pg_user_mappings AS SELECT U.oid AS umid, S.oid AS srvid, S.srvname AS srvname, U.umuser AS umuser, CASE WHEN U.umuser = 0 THEN 'public' ELSE A.rolname END AS usename, CASE WHEN (U.umuser <> 0 AND A.rolname = current_user AND (pg_has_role(S.srvowner, 'USAGE') OR has_server_privilege(S.oid, 'USAGE'))) OR (U.umuser = 0 AND pg_has_role(S.srvowner, 'USAGE')) OR (SELECT rolsuper FROM pg_authid WHERE rolname = current_user) THEN U.umoptions ELSE NULL END AS umoptions FROM pg_user_mapping U LEFT JOIN pg_authid A ON (A.oid = U.umuser) JOIN pg_foreign_server S ON (U.umserver = S.oid); Do not forget to include the template0 and template1 databases, or the vulnerability will still exist in databases you create later. To fix template0, you'll need to temporarily make it accept connections. In PostgreSQL 9.5 and later, you can use ALTER DATABASE template0 WITH ALLOW_CONNECTIONS true; and then after fixing template0, undo that with ALTER DATABASE template0 WITH ALLOW_CONNECTIONS false; In prior versions, instead use UPDATE pg_database SET datallowconn = true WHERE datname = 'template0'; UPDATE pg_database SET datallowconn = false WHERE datname = 'template0'; Finally, remove the allow_system_table_mods configuration setting, and again restart the postmaster.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/001", "db_id": "1855f0a3638d5064133d7c655b6801a8", "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731", "relations": [{"rule": 2, "type": "equivalent", "target": "1e69271813fc4ef5d63b790ce20c8121", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731"}}, {"rule": 2, "type": "equivalent", "target": "21b6568d8ef3f87de08e2d1aeba27c01", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731"}}, {"rule": 2, "type": "equivalent", "target": "d9c8c2d5f382f57bd292b9414c97967a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731"}}, {"rule": 2, "type": "equivalent", "target": "e1a74c8d75ca403b9d0629f7fef87947", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731"}}], "version": "9.2.22", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "1e69271813fc4ef5d63b790ce20c8121", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "进一步限制 pg_user_mappings.umoptions 的可见性，以保护存储为用户映射选项的密码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731"}, "url": "/docs/compare/?release=9.6.4#9.6.4-a79358365b635764", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "e1a74c8d75ca403b9d0629f7fef87947", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "进一步限制 pg_user_mappings.umoptions 的可见性，以保护存储为用户映射选项的密码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731"}, "url": "/docs/compare/?release=9.5.8#9.5.8-a79358365b635764", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "21b6568d8ef3f87de08e2d1aeba27c01", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "进一步限制 pg_user_mappings.umoptions 的可见性，以保护存储为用户映射选项的密码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731"}, "url": "/docs/compare/?release=9.4.13#9.4.13-a79358365b635764", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "d9c8c2d5f382f57bd292b9414c97967a", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "进一步限制 pg_user_mappings.umoptions 的可见性，以保护存储为用户映射选项的密码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "584ea2bb7fddd675f56f894ca7f8ee8b10adf6d95c678e599dae323c2cdad731"}, "url": "/docs/compare/?release=9.3.18#9.3.18-a79358365b635764", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-49a2f6860ca3f76c", "cves": ["CVE-2017-7546"], "html": "

禁止在所有基于密码的认证方法中使用空密码（Heikki Linnakangas）\n

libpq 忽略空的密码说明，不把它们传输给服务器。因此，如果用户的密码被设为空字符串，就无法通过\n psql 或其他基于\n libpq 的客户端用该密码登录。管理员可能因此认为把密码设为空等同于禁用密码登录。然而，使用修改过的或非\n libpq 的客户端，登录可能是可能的，这取决于配置的认证方法。特别是最常见的方法 md5 接受空密码。更改服务器在所有情况下拒绝空密码。（CVE-2017-7546）\n

", "text": "禁止在所有基于密码的认证方法中使用空密码（Heikki Linnakangas） libpq 忽略空的密码说明，不把它们传输给服务器。因此，如果用户的密码被设为空字符串，就无法通过 psql 或其他基于 libpq 的客户端用该密码登录。管理员可能因此认为把密码设为空等同于禁用密码登录。然而，使用修改过的或非 libpq 的客户端，登录可能是可能的，这取决于配置的认证方法。特别是最常见的方法 md5 接受空密码。更改服务器在所有情况下拒绝空密码。（CVE-2017-7546）", "title": "禁止在所有基于密码的认证方法中使用空密码", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "8248bb9ae98d7c7f6107b1a29e599c5699a3a9932a2023ee4404ccaa41caa29e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Disallow empty passwords in all password-based authentication methods (Heikki Linnakangas) libpq ignores empty password specifications, and does not transmit them to the server. So, if a user's password has been set to the empty string, it's impossible to log in with that password via psql or other libpq-based clients. An administrator might therefore believe that setting the password to empty is equivalent to disabling password login. However, with a modified or non-libpq-based client, logging in could be possible, depending on which authentication method is configured. In particular the most common method, md5, accepted empty passwords. Change the server to reject empty passwords in all cases. (CVE-2017-7546)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/002", "db_id": "69397c3edcff5d4d9add77abd127c3c7", "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70", "relations": [{"rule": 2, "type": "equivalent", "target": "25dc2f083ab66c1e49733c8097ace563", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70"}}, {"rule": 2, "type": "equivalent", "target": "40acd6d17343ed4ffc6e174a3ba3d54b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70"}}, {"rule": 2, "type": "equivalent", "target": "84b04fd1018199fb6cd762ee8453dc5c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70"}}, {"rule": 2, "type": "equivalent", "target": "fa4d8a03c1f22fe89447983939f7c916", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70"}}], "version": "9.2.22", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "40acd6d17343ed4ffc6e174a3ba3d54b", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "禁止在所有基于密码的认证方法中使用空密码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70"}, "url": "/docs/compare/?release=9.6.4#9.6.4-49a2f6860ca3f76c", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "fa4d8a03c1f22fe89447983939f7c916", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "禁止在所有基于密码的认证方法中使用空密码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70"}, "url": "/docs/compare/?release=9.5.8#9.5.8-49a2f6860ca3f76c", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "25dc2f083ab66c1e49733c8097ace563", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "禁止在所有基于密码的认证方法中使用空密码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70"}, "url": "/docs/compare/?release=9.4.13#9.4.13-49a2f6860ca3f76c", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "84b04fd1018199fb6cd762ee8453dc5c", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "禁止在所有基于密码的认证方法中使用空密码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc4bc48394a4dd716143d3fade767645ef394af6f493bf13e77a885e081f3a70"}, "url": "/docs/compare/?release=9.3.18#9.3.18-49a2f6860ca3f76c", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-5dfe6c5122301e0b", "cves": [], "html": "

在 Windows 上，如果在新进程中为共享内存保留地址范围失败，则重试进程创建（Tom Lane、Amit Kapila）\n

这有望修复可能由杀毒产品干扰导致的偶发子进程启动失败。\n

", "text": "在 Windows 上，如果在新进程中为共享内存保留地址范围失败，则重试进程创建（Tom Lane、Amit Kapila） 这有望修复可能由杀毒产品干扰导致的偶发子进程启动失败。", "title": "在 Windows 上，如果在新进程中为共享内存保留地址范围失败，则重试进程创建", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "30173b70198bc163091da081bf7b12117fe6a84d9f59eaf9813b80aaa7bbe4b0", "section_path": ["变更"], "commit_groups": [], "identity_text": "On Windows, retry process creation if we fail to reserve the address range for our shared memory in the new process (Tom Lane, Amit Kapila) This is expected to fix infrequent child-process-launch failures that are probably due to interference from antivirus products.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/003", "db_id": "a5446aca19df9fcf6d2f1d6ee8cecb2c", "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d", "relations": [{"rule": 2, "type": "equivalent", "target": "1f54690bed7a1b61467c57f4ea6f33d6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d"}}, {"rule": 2, "type": "equivalent", "target": "34e6cdf1912ffe330979dc21077c6288", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d"}}, {"rule": 2, "type": "equivalent", "target": "6e4ce1f4ea2cf3f7543b8266c9528f74", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d"}}, {"rule": 2, "type": "equivalent", "target": "faf48774cbb82fce5982d2b859f20fb1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "6e4ce1f4ea2cf3f7543b8266c9528f74", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "在 Windows 上，如果在新进程中为共享内存保留地址范围失败，则重试进程创建", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d"}, "url": "/docs/compare/?release=9.6.4#9.6.4-5dfe6c5122301e0b", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "faf48774cbb82fce5982d2b859f20fb1", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "在 Windows 上，如果在新进程中为共享内存保留地址范围失败，则重试进程创建", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d"}, "url": "/docs/compare/?release=9.5.8#9.5.8-5dfe6c5122301e0b", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "34e6cdf1912ffe330979dc21077c6288", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "在 Windows 上，如果在新进程中为共享内存保留地址范围失败，则重试进程创建", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d"}, "url": "/docs/compare/?release=9.4.13#9.4.13-5dfe6c5122301e0b", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "1f54690bed7a1b61467c57f4ea6f33d6", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "在 Windows 上，如果在新进程中为共享内存保留地址范围失败，则重试进程创建", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2139f207022c720ba8a40fe3f15d9d75de8244c43e8d5a66f48f9a2a377ac6d"}, "url": "/docs/compare/?release=9.3.18#9.3.18-5dfe6c5122301e0b", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-2e59d8bea64c1b73", "cves": [], "html": "

修复 Windows 构建中共享谓词锁哈希表的低概率损坏（Thomas Munro、Tom Lane）\n

", "text": "修复 Windows 构建中共享谓词锁哈希表的低概率损坏（Thomas Munro、Tom Lane）", "title": "修复 Windows 构建中共享谓词锁哈希表的低概率损坏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "7f9cf9390d655655479021cd4c9b40c67193aa46222bd50edc5134b6aa71f607", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix low-probability corruption of shared predicate-lock hash table in Windows builds (Thomas Munro, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/004", "db_id": "61aff00b2cbd0d0a19f4de9c64161e33", "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89", "relations": [{"rule": 2, "type": "equivalent", "target": "6239e85838c4defd9c242c9736aac6dc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89"}}, {"rule": 2, "type": "equivalent", "target": "c80803c6d4d1147a93d5b23d67970907", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89"}}, {"rule": 2, "type": "equivalent", "target": "ccc80b8375366a40f739144083dec4bb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89"}}, {"rule": 2, "type": "equivalent", "target": "eb123644d0d25507fd759fba8b23f35d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "eb123644d0d25507fd759fba8b23f35d", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 Windows 构建中共享谓词锁哈希表的低概率损坏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89"}, "url": "/docs/compare/?release=9.6.4#9.6.4-2e59d8bea64c1b73", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "c80803c6d4d1147a93d5b23d67970907", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 Windows 构建中共享谓词锁哈希表的低概率损坏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89"}, "url": "/docs/compare/?release=9.5.8#9.5.8-2e59d8bea64c1b73", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "6239e85838c4defd9c242c9736aac6dc", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复 Windows 构建中共享谓词锁哈希表低概率损坏的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89"}, "url": "/docs/compare/?release=9.4.13#9.4.13-cb90a7f53e5f1214", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "ccc80b8375366a40f739144083dec4bb", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 Windows 构建中共享谓词锁哈希表的低概率损坏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "146d59d36752d7bcca300d69ea802fadeb6f6b03b524e3a56baca197728b9c89"}, "url": "/docs/compare/?release=9.3.18#9.3.18-2e59d8bea64c1b73", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-63ce467ec91a76ba", "cves": [], "html": "

避免把 SSL 连接的干净关闭当作连接重置来记录（Michael Paquier）\n

", "text": "避免把 SSL 连接的干净关闭当作连接重置来记录（Michael Paquier）", "title": "避免把 SSL 连接的干净关闭当作连接重置来记录", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "53e88465fcea0477573d776fc07588d69640980c2daf9729a2ba1e5a51c27c03", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid logging clean closure of an SSL connection as though it were a connection reset (Michael Paquier)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/005", "db_id": "796e639d993fe8aa9c00c2a6cb32a298", "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e", "relations": [{"rule": 2, "type": "equivalent", "target": "4f1ca4a9b4544c5f9b0e201f593b00fb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e"}}, {"rule": 2, "type": "equivalent", "target": "7890ed06f30afa11b324e730a77920d4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e"}}, {"rule": 2, "type": "equivalent", "target": "9f43dcd8e33a849f63af81136e8cffc4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e"}}, {"rule": 2, "type": "equivalent", "target": "e26440dbe5fa41f21ec2cfb7ea515129", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "9f43dcd8e33a849f63af81136e8cffc4", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "避免把 SSL 连接的干净关闭当作连接重置来记录", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e"}, "url": "/docs/compare/?release=9.6.4#9.6.4-63ce467ec91a76ba", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "7890ed06f30afa11b324e730a77920d4", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "避免把 SSL 连接的干净关闭当作连接重置来记录", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e"}, "url": "/docs/compare/?release=9.5.8#9.5.8-63ce467ec91a76ba", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "4f1ca4a9b4544c5f9b0e201f593b00fb", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "避免把 SSL 连接的正常关闭记录成连接重置", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e"}, "url": "/docs/compare/?release=9.4.13#9.4.13-4aec39eb8163f31f", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "e26440dbe5fa41f21ec2cfb7ea515129", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "避免把 SSL 连接的干净关闭当作连接重置来记录", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d246a67650b489515d0769bf3b9cfc3687bdf7c9a375177f21867e83ea52ae7e"}, "url": "/docs/compare/?release=9.3.18#9.3.18-63ce467ec91a76ba", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-e308e1857bff9246", "cves": [], "html": "

防止向客户端发送 SSL 会话票据（Tom Lane）\n

此修复防止使用票据感知的客户端 SSL 代码时的重连失败。\n

", "text": "防止向客户端发送 SSL 会话票据（Tom Lane） 此修复防止使用票据感知的客户端 SSL 代码时的重连失败。", "title": "防止向客户端发送 SSL 会话票据", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "2abe4c8fcdb34c7a7eb14003b7ba1b3eb52dd942e31832abe0b4ff675b2c0435", "section_path": ["变更"], "commit_groups": [], "identity_text": "Prevent sending SSL session tickets to clients (Tom Lane) This fix prevents reconnection failures with ticket-aware client-side SSL code.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/006", "db_id": "06ca50c6c2100c6be604facd02221004", "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5", "relations": [{"rule": 2, "type": "equivalent", "target": "5417fe28a58f02892e6f851554b173dd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5"}}, {"rule": 2, "type": "equivalent", "target": "57c80424a5c5a39644fe6b251c9bbd11", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5"}}, {"rule": 2, "type": "equivalent", "target": "78fa3aaa5d85ae9fdccb058afe139d92", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5"}}, {"rule": 2, "type": "equivalent", "target": "a327202592f6a57881437263d94073b8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "a327202592f6a57881437263d94073b8", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "防止向客户端发送 SSL 会话票据", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5"}, "url": "/docs/compare/?release=9.6.4#9.6.4-e308e1857bff9246", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "78fa3aaa5d85ae9fdccb058afe139d92", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "防止向客户端发送 SSL 会话票据", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5"}, "url": "/docs/compare/?release=9.5.8#9.5.8-e308e1857bff9246", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "5417fe28a58f02892e6f851554b173dd", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "防止向客户端发送 SSL 会话票据", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5"}, "url": "/docs/compare/?release=9.4.13#9.4.13-e308e1857bff9246", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "57c80424a5c5a39644fe6b251c9bbd11", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "防止向客户端发送 SSL 会话票据", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3ba606e5da2e161568d30ca0d3743dcd89b79aaa70d26f32a7e248a302af3c5"}, "url": "/docs/compare/?release=9.3.18#9.3.18-e308e1857bff9246", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-3e28052d9d329d76", "cves": [], "html": "

修复 Solaris 上设置tcp_keepalives_idle的代码（Tom Lane）\n

", "text": "修复 Solaris 上设置tcp_keepalives_idle的代码（Tom Lane）", "title": "修复 Solaris 上设置tcp_keepalives_idle的代码", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "fec118f3dcb96c331ac64b99c1c79030261d966062a397ec2b995385687f10f2", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix code for setting guc-tcp-keepalives-idle on Solaris (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/007", "db_id": "edff4867a55a25f16f546d52b212e769", "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a", "relations": [{"rule": 2, "type": "equivalent", "target": "1c7bb3243d9e68418b27efa10792167f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a"}}, {"rule": 2, "type": "equivalent", "target": "3d12e09651fa92dc3d7691e748c23b13", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a"}}, {"rule": 2, "type": "equivalent", "target": "ad20c605290795b78b75dfa2c7ca72c9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a"}}, {"rule": 2, "type": "equivalent", "target": "b1f9de21bc12b73cf6518cf2a56f48d1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "3d12e09651fa92dc3d7691e748c23b13", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 Solaris 上设置tcp_keepalives_idle的代码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a"}, "url": "/docs/compare/?release=9.6.4#9.6.4-3e28052d9d329d76", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "1c7bb3243d9e68418b27efa10792167f", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 Solaris 上设置tcp_keepalives_idle的代码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a"}, "url": "/docs/compare/?release=9.5.8#9.5.8-3e28052d9d329d76", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "ad20c605290795b78b75dfa2c7ca72c9", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复 Solaris 上设置tcp_keepalives_idle的代码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a"}, "url": "/docs/compare/?release=9.4.13#9.4.13-3e28052d9d329d76", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "b1f9de21bc12b73cf6518cf2a56f48d1", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 Solaris 上设置tcp_keepalives_idle的代码", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "03b9947723b04bb6932ea30bfe8dd413ceee29eeaf5f25f5db97c4e93ae4285a"}, "url": "/docs/compare/?release=9.3.18#9.3.18-3e28052d9d329d76", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-57c375774ebad3a1", "cves": [], "html": "

修复统计收集器处理 postmaster 关闭并立即重启之后发出的查询消息（Tom Lane）\n

在上一个 postmaster 关闭之后半秒内发出的统计查询实际上被忽略。\n

", "text": "修复统计收集器处理 postmaster 关闭并立即重启之后发出的查询消息（Tom Lane） 在上一个 postmaster 关闭之后半秒内发出的统计查询实际上被忽略。", "title": "修复统计收集器处理 postmaster 关闭并立即重启之后发出的查询消息", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "9956de488f39f20929da3610321f6e6d5e5f109cf89e802f825285ce4d11ef14", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix statistics collector to honor inquiry messages issued just after a postmaster shutdown and immediate restart (Tom Lane) Statistics inquiries issued within half a second of the previous postmaster shutdown were effectively ignored.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/008", "db_id": "6ea6bdb3b1c0b91370098bb4050cdf5a", "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da", "relations": [{"rule": 2, "type": "equivalent", "target": "35d154df872964bdd172e06e7cc7b5e7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da"}}, {"rule": 2, "type": "equivalent", "target": "52169b7dd014d33786c85566c9719250", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da"}}, {"rule": 2, "type": "equivalent", "target": "c7939f5f09e159955353f7b29c36efbb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da"}}, {"rule": 2, "type": "equivalent", "target": "e6cd54250e39c6ba75fa8dfed50a9202", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "52169b7dd014d33786c85566c9719250", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复统计收集器处理 postmaster 关闭并立即重启之后发出的查询消息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da"}, "url": "/docs/compare/?release=9.6.4#9.6.4-57c375774ebad3a1", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "c7939f5f09e159955353f7b29c36efbb", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复统计收集器处理 postmaster 关闭并立即重启之后发出的查询消息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da"}, "url": "/docs/compare/?release=9.5.8#9.5.8-57c375774ebad3a1", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "35d154df872964bdd172e06e7cc7b5e7", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复统计收集器处理 postmaster 关闭并立即重启之后发出的查询消息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da"}, "url": "/docs/compare/?release=9.4.13#9.4.13-57c375774ebad3a1", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "e6cd54250e39c6ba75fa8dfed50a9202", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复统计收集器处理 postmaster 关闭并立即重启之后发出的查询消息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9a724c19bdc08f44a81e196f42b1ed6ab52256f9249bcd64373d65849332f3da"}, "url": "/docs/compare/?release=9.3.18#9.3.18-57c375774ebad3a1", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-20b9745916abac09", "cves": [], "html": "

确保统计收集器的接收缓冲区大小至少为 100KB（Tom Lane）\n

这降低了默认接收缓冲区大小小于该值的老平台上统计数据丢失的风险。\n

", "text": "确保统计收集器的接收缓冲区大小至少为 100KB（Tom Lane） 这降低了默认接收缓冲区大小小于该值的老平台上统计数据丢失的风险。", "title": "确保统计收集器的接收缓冲区大小至少为 100KB", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "bc28841b783ed44c6a7f1eae3e69ce67b6e58e49c4dccbc3357599103a028c3f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Ensure that the statistics collector's receive buffer size is at least 100KB (Tom Lane) This reduces the risk of dropped statistics data on older platforms whose default receive buffer size is less than that.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/009", "db_id": "cebabf83bae7e2378ddea14ff545ac6f", "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28", "relations": [{"rule": 2, "type": "equivalent", "target": "35b5f7b5058aa8d2a991d9b4a8b37c93", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28"}}, {"rule": 2, "type": "equivalent", "target": "3c2dba8fca8015ec95edd7b7e1ef5a4e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28"}}, {"rule": 2, "type": "equivalent", "target": "45f8a1f14d7479817e647f93ea3147f0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28"}}, {"rule": 2, "type": "equivalent", "target": "8aec425eef081d0f371de4d506db4c6d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "35b5f7b5058aa8d2a991d9b4a8b37c93", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "确保统计收集器的接收缓冲区大小至少为 100KB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28"}, "url": "/docs/compare/?release=9.6.4#9.6.4-20b9745916abac09", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "45f8a1f14d7479817e647f93ea3147f0", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "确保统计收集器的接收缓冲区大小至少为 100KB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28"}, "url": "/docs/compare/?release=9.5.8#9.5.8-20b9745916abac09", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "8aec425eef081d0f371de4d506db4c6d", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "确保统计收集器的接收缓冲区大小至少为 100KB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28"}, "url": "/docs/compare/?release=9.4.13#9.4.13-20b9745916abac09", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "3c2dba8fca8015ec95edd7b7e1ef5a4e", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "确保统计收集器的接收缓冲区大小至少为 100KB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ae98eb03d931632b6d6e716835257b5b32dac76f778e840398a512fcca98ca28"}, "url": "/docs/compare/?release=9.3.18#9.3.18-20b9745916abac09", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-b0bf0f68f2bb1135", "cves": [], "html": "

修复备库刚处理完 XLOG_SWITCH WAL 记录后被提升时可能创建无效 WAL 段的问题（Andres Freund）\n

", "text": "修复备库刚处理完 XLOG_SWITCH WAL 记录后被提升时可能创建无效 WAL 段的问题（Andres Freund）", "title": "修复备库刚处理完 XLOG_SWITCH WAL 记录后被提升时可能创建无效 WAL 段的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "ca9ba11203518b139925d9df40a7e7bb3657cf9076dea7334653f7be30eece14", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible creation of an invalid WAL segment when a standby is promoted just after it processes an XLOG_SWITCH WAL record (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/010", "db_id": "a167acf8e40e68b1306d951f121d3e0f", "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805", "relations": [{"rule": 2, "type": "equivalent", "target": "027472daca45d7d3ca1dda4accfbe514", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805"}}, {"rule": 2, "type": "equivalent", "target": "1ebe514120103dc5eb1fb4461713c100", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805"}}, {"rule": 2, "type": "equivalent", "target": "2f2e0bd47f601d6acf0caa11807655ce", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805"}}, {"rule": 2, "type": "equivalent", "target": "3343b117e454cf984aadbcbf1c224c1b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "2f2e0bd47f601d6acf0caa11807655ce", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复备库刚处理完 XLOG_SWITCH WAL 记录后被提升时可能创建无效 WAL 段的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805"}, "url": "/docs/compare/?release=9.6.4#9.6.4-b0bf0f68f2bb1135", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "3343b117e454cf984aadbcbf1c224c1b", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复备库刚处理完 XLOG_SWITCH WAL 记录后被提升时可能创建无效 WAL 段的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805"}, "url": "/docs/compare/?release=9.5.8#9.5.8-b0bf0f68f2bb1135", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "1ebe514120103dc5eb1fb4461713c100", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复备库在刚处理完XLOG_SWITCHWAL 记录后被提升时可能创建无效 WAL 段的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805"}, "url": "/docs/compare/?release=9.4.13#9.4.13-11f60c94267d3d32", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "027472daca45d7d3ca1dda4accfbe514", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复备库刚处理完 XLOG_SWITCH WAL 记录后被提升时可能创建无效 WAL 段的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba014dc0e788386a8df4ba006edab727e81e02d48fe4daa3f57744df51695805"}, "url": "/docs/compare/?release=9.3.18#9.3.18-b0bf0f68f2bb1135", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-7869db2756522ed5", "cves": [], "html": "

修复 walsender 进程中的 SIGHUP 和\n SIGUSR1 处理（Petr Jelinek、Andres Freund）\n

", "text": "修复 walsender 进程中的 SIGHUP 和 SIGUSR1 处理（Petr Jelinek、Andres Freund）", "title": "修复 walsender 进程中的 SIGHUP 和 SIGUSR1 处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "cbbab86f9386b50e227ff4b330aef07fb65cdbb997cd0fd0d25e39155a1b6feb", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix SIGHUP and SIGUSR1 handling in walsender processes (Petr Jelinek, Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/011", "db_id": "ff38a637d151641073b6f2871680809f", "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1", "relations": [{"rule": 2, "type": "equivalent", "target": "3a37a29c34d6f5d73ccb334bdba07088", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1"}}, {"rule": 2, "type": "equivalent", "target": "56fbd01576e12b75269896592fa2c8c7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1"}}, {"rule": 2, "type": "equivalent", "target": "e495da6486bd8be4e4c26d6e5086beee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1"}}, {"rule": 2, "type": "equivalent", "target": "ff55a48b73c00e42d28e3b52fe55af78", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "3a37a29c34d6f5d73ccb334bdba07088", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 walsender 进程中的 SIGHUP 和 SIGUSR1 处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1"}, "url": "/docs/compare/?release=9.6.4#9.6.4-7869db2756522ed5", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "ff55a48b73c00e42d28e3b52fe55af78", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 walsender 进程中的 SIGHUP 和 SIGUSR1 处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1"}, "url": "/docs/compare/?release=9.5.8#9.5.8-7869db2756522ed5", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "56fbd01576e12b75269896592fa2c8c7", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复 walsender 进程中SIGHUP和SIGUSR1的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1"}, "url": "/docs/compare/?release=9.4.13#9.4.13-e99abd2807b726be", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "e495da6486bd8be4e4c26d6e5086beee", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 walsender 进程中的 SIGHUP 和 SIGUSR1 处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d54f1cf1421f9b2f8f6071ef527eaa84099cd41597a1402c579436e93f1855a1"}, "url": "/docs/compare/?release=9.3.18#9.3.18-7869db2756522ed5", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-d0bce37763b84970", "cves": [], "html": "

修复 postmaster 中竞态条件导致的\n walreceiver 进程不必要的缓慢重启（Tom Lane）\n

", "text": "修复 postmaster 中竞态条件导致的 walreceiver 进程不必要的缓慢重启（Tom Lane）", "title": "修复 postmaster 中竞态条件导致的 walreceiver 进程不必要的缓慢重启", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "d155bf26045724e6fc5a975d34c0203a49c4cabe5fc4c4273be64585a16d9001", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix unnecessarily slow restarts of walreceiver processes due to race condition in postmaster (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/012", "db_id": "df6bb339b676af9421fec5b435f41df0", "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6", "relations": [{"rule": 2, "type": "equivalent", "target": "0cb3087fae06393bc7f76e6cbe7ded78", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6"}}, {"rule": 2, "type": "equivalent", "target": "2c27a0f6cff6d52384428eb46e816ad6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6"}}, {"rule": 2, "type": "equivalent", "target": "56bb12dabc419c87a27717fa34bb3be3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6"}}, {"rule": 2, "type": "equivalent", "target": "bc1b64b2ca3671e5b73d363e398be023", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "56bb12dabc419c87a27717fa34bb3be3", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 postmaster 中竞态条件导致的 walreceiver 进程不必要的缓慢重启", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6"}, "url": "/docs/compare/?release=9.6.4#9.6.4-d0bce37763b84970", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "0cb3087fae06393bc7f76e6cbe7ded78", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 postmaster 中竞态条件导致的 walreceiver 进程不必要的缓慢重启", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6"}, "url": "/docs/compare/?release=9.5.8#9.5.8-d0bce37763b84970", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "2c27a0f6cff6d52384428eb46e816ad6", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复因 postmaster 中的竞争条件导致walreceiver进程不必要地缓慢重启的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6"}, "url": "/docs/compare/?release=9.4.13#9.4.13-d83eb4212e3c77c6", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "bc1b64b2ca3671e5b73d363e398be023", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 postmaster 中竞态条件导致的 walreceiver 进程不必要的缓慢重启", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006bac9dacd1622bc6ddd16acc61ae5fae33eb710b4ea23f3bd2b6df434667b6"}, "url": "/docs/compare/?release=9.3.18#9.3.18-d0bce37763b84970", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-d20765897a51eeb2", "cves": [], "html": "

修复 INSERT 或 UPDATE 对数组之上域类型的列的多个元素赋值的情况（Tom Lane）\n

", "text": "修复 INSERT 或 UPDATE 对数组之上域类型的列的多个元素赋值的情况（Tom Lane）", "title": "修复 INSERT 或 UPDATE 对数组之上域类型的列的多个元素赋值的情况", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "262c834a1f69ff6c6479f9804f5489f9ee38f8fe0ab4f26322e9087e8db3fc0c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix cases where an INSERT or UPDATE assigns to more than one element of a column that is of domain-over-array type (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/013", "db_id": "bec476c995bf0ae2d6c2bbd39a5ee4a6", "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c", "relations": [{"rule": 2, "type": "equivalent", "target": "2cdb0efa2e2249d0e3f9b9dd528ebb36", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c"}}, {"rule": 2, "type": "equivalent", "target": "581f18312c8db068f74644c8f9aaad95", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c"}}, {"rule": 2, "type": "equivalent", "target": "6751805191274189c14b5c574618acf6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c"}}, {"rule": 2, "type": "equivalent", "target": "7fa38e8aef93079d71fc8df9e9eaec2b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "581f18312c8db068f74644c8f9aaad95", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 INSERT 或 UPDATE 对数组之上域类型的列的多个元素赋值的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c"}, "url": "/docs/compare/?release=9.6.4#9.6.4-d20765897a51eeb2", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "6751805191274189c14b5c574618acf6", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 INSERT 或 UPDATE 对数组之上域类型的列的多个元素赋值的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c"}, "url": "/docs/compare/?release=9.5.8#9.5.8-d20765897a51eeb2", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "2cdb0efa2e2249d0e3f9b9dd528ebb36", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复INSERT或UPDATE对域于数组类型列的多于一个元素赋值的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c"}, "url": "/docs/compare/?release=9.4.13#9.4.13-a2678c658d4a7cb7", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "7fa38e8aef93079d71fc8df9e9eaec2b", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 INSERT 或 UPDATE 对数组之上域类型的列的多个元素赋值的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26e8ded4af49c5db7cd20cecd15c614166922479205a4cc5e3f03775d57e2e4c"}, "url": "/docs/compare/?release=9.3.18#9.3.18-d20765897a51eeb2", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-26b8910082bb016e", "cves": [], "html": "

在 ALTER ... RENAME 期间把自动生成的数组类型移开（Vik Fearing）\n

此前我们在 CREATE 期间会把冲突的自动生成数组类型重命名移开；此修复把该行为扩展到重命名操作。\n

", "text": "在 ALTER ... RENAME 期间把自动生成的数组类型移开（Vik Fearing） 此前我们在 CREATE 期间会把冲突的自动生成数组类型重命名移开；此修复把该行为扩展到重命名操作。", "title": "在 ALTER ... RENAME 期间把自动生成的数组类型移开", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "28ff7c30c166288fd0c7f2f598beedc8c28857dbae339712e2e308111d334a87", "section_path": ["变更"], "commit_groups": [], "identity_text": "Move autogenerated array types out of the way during ALTER ... RENAME (Vik Fearing) Previously, we would rename a conflicting autogenerated array type out of the way during CREATE; this fix extends that behavior to renaming operations.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/014", "db_id": "bdc3b303804932fa630f8a8d01e0e891", "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790", "relations": [{"rule": 2, "type": "equivalent", "target": "01a3f42570323f11d8590ebbab6be905", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790"}}, {"rule": 2, "type": "equivalent", "target": "3542438a9e62964cff164ac34edfb00b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790"}}, {"rule": 2, "type": "equivalent", "target": "35c9a1e915045e14f9285575fbf87fd4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790"}}, {"rule": 2, "type": "equivalent", "target": "e0b15344dd65537ca60f9d091cab55fb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "35c9a1e915045e14f9285575fbf87fd4", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "在 ALTER ... RENAME 期间把自动生成的数组类型移开", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790"}, "url": "/docs/compare/?release=9.6.4#9.6.4-26b8910082bb016e", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "3542438a9e62964cff164ac34edfb00b", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "在 ALTER ... RENAME 期间把自动生成的数组类型移开", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790"}, "url": "/docs/compare/?release=9.5.8#9.5.8-26b8910082bb016e", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "e0b15344dd65537ca60f9d091cab55fb", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "在 ALTER ... RENAME 期间把自动生成的数组类型移开", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790"}, "url": "/docs/compare/?release=9.4.13#9.4.13-26b8910082bb016e", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "01a3f42570323f11d8590ebbab6be905", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "在 ALTER ... RENAME 期间把自动生成的数组类型移开", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab43bf4ca4eaf90ab313d6c97c1c22788eecbb002d3a00718cee13d901bdf790"}, "url": "/docs/compare/?release=9.3.18#9.3.18-26b8910082bb016e", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-5d6d8e63b270c702", "cves": [], "html": "

确保 ALTER USER ... SET 接受\n ALTER ROLE ... SET 接受的所有语法变体（Peter Eisentraut）\n

", "text": "确保 ALTER USER ... SET 接受 ALTER ROLE ... SET 接受的所有语法变体（Peter Eisentraut）", "title": "确保 ALTER USER ... SET 接受 ALTER ROLE ... SET 接受的所有语法变体", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "cc0810806d96f90eb3effaed6b45b16332813cae7a55c282dd4342395b102fda", "section_path": ["变更"], "commit_groups": [], "identity_text": "Ensure that ALTER USER ... SET accepts all the syntax variants that ALTER ROLE ... SET does (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/015", "db_id": "2e9124e378f62726adf44d3d5bfc1844", "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02", "relations": [{"rule": 2, "type": "equivalent", "target": "64cd1132715305e1328535ca3f78902f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02"}}, {"rule": 2, "type": "equivalent", "target": "78533c68c579d16f73c607cdc14e8a1f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02"}}, {"rule": 2, "type": "equivalent", "target": "d30198df80a7b55813806adb967331f7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02"}}, {"rule": 2, "type": "equivalent", "target": "e0dfbecb7a9539c1d00387e2230fd26a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e0dfbecb7a9539c1d00387e2230fd26a", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "确保 ALTER USER ... SET 接受 ALTER ROLE ... SET 接受的所有语法变体", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02"}, "url": "/docs/compare/?release=9.6.4#9.6.4-5d6d8e63b270c702", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "d30198df80a7b55813806adb967331f7", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "确保 ALTER USER ... SET 接受 ALTER ROLE ... SET 接受的所有语法变体", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02"}, "url": "/docs/compare/?release=9.5.8#9.5.8-5d6d8e63b270c702", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "78533c68c579d16f73c607cdc14e8a1f", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "确保ALTER USER ... SET接受ALTER ROLE ... SET接受的所有语法变体", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02"}, "url": "/docs/compare/?release=9.4.13#9.4.13-0acb3f4526afe316", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "64cd1132715305e1328535ca3f78902f", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "确保 ALTER USER ... SET 接受 ALTER ROLE ... SET 接受的所有语法变体", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76e3636bc07ca0ae7a9a7e9caafece2b1209327c81fbb02c916a3a229d9dcb02"}, "url": "/docs/compare/?release=9.3.18#9.3.18-5d6d8e63b270c702", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-7e64d6a8ac02ee1d", "cves": [], "html": "

把数据类型 I/O 函数的参数或返回类型从 opaque 更改为正确类型时正确更新依赖信息（Heikki Linnakangas）\n

CREATE TYPE 会更新以这种早已过时风格声明的 I/O\n 函数，但忘记记录对类型的依赖，允许随后的 DROP TYPE\n 留下损坏的函数定义。\n

", "text": "把数据类型 I/O 函数的参数或返回类型从 opaque 更改为正确类型时正确更新依赖信息（Heikki Linnakangas） CREATE TYPE 会更新以这种早已过时风格声明的 I/O 函数，但忘记记录对类型的依赖，允许随后的 DROP TYPE 留下损坏的函数定义。", "title": "把数据类型 I/O 函数的参数或返回类型从 opaque 更改为正确类型时正确更新依赖信息", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "cbf9831d19f3d7de90f27f2bee101c591dfff137d5adaeee25f3409a95a4feef", "section_path": ["变更"], "commit_groups": [], "identity_text": "Properly update dependency info when changing a datatype I/O function's argument or return type from opaque to the correct type (Heikki Linnakangas) CREATE TYPE updates I/O functions declared in this long-obsolete style, but it forgot to record a dependency on the type, allowing a subsequent DROP TYPE to leave broken function definitions behind.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/016", "db_id": "e2f1d6fdaec7559842c2385b6c1b3960", "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95", "relations": [{"rule": 2, "type": "equivalent", "target": "1c71739ec0bc22b2086096c2e708bf8d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95"}}, {"rule": 2, "type": "equivalent", "target": "4ea6d45d75e4f4cbecc3f43197c0e279", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95"}}, {"rule": 2, "type": "equivalent", "target": "ca6de75b0e0794384b1bddc37b7725d6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95"}}, {"rule": 2, "type": "equivalent", "target": "fc3e91d166da9eace934c7ce332d1d1a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "1c71739ec0bc22b2086096c2e708bf8d", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "把数据类型 I/O 函数的参数或返回类型从 opaque 更改为正确类型时正确更新依赖信息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95"}, "url": "/docs/compare/?release=9.6.4#9.6.4-7e64d6a8ac02ee1d", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "4ea6d45d75e4f4cbecc3f43197c0e279", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "把数据类型 I/O 函数的参数或返回类型从 opaque 更改为正确类型时正确更新依赖信息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95"}, "url": "/docs/compare/?release=9.5.8#9.5.8-7e64d6a8ac02ee1d", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "fc3e91d166da9eace934c7ce332d1d1a", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "把数据类型 I/O 函数的参数或返回类型从 opaque 更改为正确类型时正确更新依赖信息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95"}, "url": "/docs/compare/?release=9.4.13#9.4.13-7e64d6a8ac02ee1d", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "ca6de75b0e0794384b1bddc37b7725d6", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "把数据类型 I/O 函数的参数或返回类型从 opaque 更改为正确类型时正确更新依赖信息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3fdc8ebbdbf730a329bf0a859fb389fd46d076d6cc0d55d600ecc892a552e95"}, "url": "/docs/compare/?release=9.3.18#9.3.18-7e64d6a8ac02ee1d", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-53ec6cb2f2c17b5e", "cves": [], "html": "

减少 ANALYZE 处理 tsvector 列时的内存使用（Heikki Linnakangas）\n

", "text": "减少 ANALYZE 处理 tsvector 列时的内存使用（Heikki Linnakangas）", "title": "减少 ANALYZE 处理 tsvector 列时的内存使用", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "c434bb0023e1a14e995397ce09493c80f89024fc24ac21f9a27cb5db75170cbd", "section_path": ["变更"], "commit_groups": [], "identity_text": "Reduce memory usage when ANALYZE processes a tsvector column (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/017", "db_id": "56a90a69a533a8f1b101b1a4530193a8", "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285", "relations": [{"rule": 2, "type": "equivalent", "target": "186cde4e1db0f0be25d5d5bf57d359a3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285"}}, {"rule": 2, "type": "equivalent", "target": "311b3cc3e4fa5b500aa9deca70df0ad1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285"}}, {"rule": 2, "type": "equivalent", "target": "9286e2faff7d6b1fff883e2bd2b97a77", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285"}}, {"rule": 2, "type": "equivalent", "target": "b5fdaa42caf9e6d138b07b5dc501401e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "186cde4e1db0f0be25d5d5bf57d359a3", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "减少 ANALYZE 处理 tsvector 列时的内存使用", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285"}, "url": "/docs/compare/?release=9.6.4#9.6.4-53ec6cb2f2c17b5e", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "b5fdaa42caf9e6d138b07b5dc501401e", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "减少 ANALYZE 处理 tsvector 列时的内存使用", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285"}, "url": "/docs/compare/?release=9.5.8#9.5.8-53ec6cb2f2c17b5e", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "311b3cc3e4fa5b500aa9deca70df0ad1", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "减少ANALYZE处理tsvector列时的内存占用", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285"}, "url": "/docs/compare/?release=9.4.13#9.4.13-5cc7b36574f17ab3", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "9286e2faff7d6b1fff883e2bd2b97a77", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "减少 ANALYZE 处理 tsvector 列时的内存使用", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "365b3b807b5473e4ab75e1425dcf3b1ac225ca482d4cf17dcea8abb928e59285"}, "url": "/docs/compare/?release=9.3.18#9.3.18-53ec6cb2f2c17b5e", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-7274a73af024ab1f", "cves": [], "html": "

修复 money 值乘以或除以整数或浮点数时不必要的精度丢失和草率舍入（Tom Lane）\n

", "text": "修复 money 值乘以或除以整数或浮点数时不必要的精度丢失和草率舍入（Tom Lane）", "title": "修复 money 值乘以或除以整数或浮点数时不必要的精度丢失和草率舍入", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "1356759f728073747d0c1012c60209f92dad9135f097a9b760ff6337d0343c0e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix unnecessary precision loss and sloppy rounding when multiplying or dividing money values by integers or floats (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/018", "db_id": "e7af3496a98b2881c3be33678b312c32", "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5", "relations": [{"rule": 2, "type": "equivalent", "target": "200144e3d3d62f9ce4f389e55d3f4745", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5"}}, {"rule": 2, "type": "equivalent", "target": "4b94c1478911b41eaef82286d2b45208", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5"}}, {"rule": 2, "type": "equivalent", "target": "c7eb7fb2b29170b05a637ca27c2a7539", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5"}}, {"rule": 2, "type": "equivalent", "target": "e18ad23e444eafe61e775b732271dcc6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e18ad23e444eafe61e775b732271dcc6", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 money 值乘以或除以整数或浮点数时不必要的精度丢失和草率舍入", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5"}, "url": "/docs/compare/?release=9.6.4#9.6.4-7274a73af024ab1f", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "4b94c1478911b41eaef82286d2b45208", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 money 值乘以或除以整数或浮点数时不必要的精度丢失和草率舍入", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5"}, "url": "/docs/compare/?release=9.5.8#9.5.8-7274a73af024ab1f", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "200144e3d3d62f9ce4f389e55d3f4745", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复money值与整数或浮点数相乘/相除时不必要的精度损失和草率舍入", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5"}, "url": "/docs/compare/?release=9.4.13#9.4.13-40f89286d4f1ec29", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "c7eb7fb2b29170b05a637ca27c2a7539", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 money 值乘以或除以整数或浮点数时不必要的精度丢失和草率舍入", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8366e04a8cbfa6fcab7fa6659f1c4a822f67b3552f11a185ff2bcc49708c0bc5"}, "url": "/docs/compare/?release=9.3.18#9.3.18-7274a73af024ab1f", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-5118ee67f07e4d53", "cves": [], "html": "

收紧对解析标识符的函数（如\n regprocedurein()）中空白的检查（Tom Lane）\n

根据当前区域，这些函数可能把多字节字符的片段误解释为空白。\n

", "text": "收紧对解析标识符的函数（如 regprocedurein()）中空白的检查（Tom Lane） 根据当前区域，这些函数可能把多字节字符的片段误解释为空白。", "title": "收紧对解析标识符的函数（如 regprocedurein()）中空白的检查", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "633bc19eda34e87630e4885f11cb3a40498de1b0af7fcd3ed26a6f91a9754586", "section_path": ["变更"], "commit_groups": [], "identity_text": "Tighten checks for whitespace in functions that parse identifiers, such as regprocedurein() (Tom Lane) Depending on the prevailing locale, these functions could misinterpret fragments of multibyte characters as whitespace.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/019", "db_id": "835321b9bb87e7c0b5749d5c3a0a71eb", "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807", "relations": [{"rule": 2, "type": "equivalent", "target": "3c0a5921b737f2e58d32771afebaa81e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807"}}, {"rule": 2, "type": "equivalent", "target": "51131f8d3f132e0ebe995be51a7e214b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807"}}, {"rule": 2, "type": "equivalent", "target": "7dc7725bf5e33baf9a4661587b0e8778", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807"}}, {"rule": 2, "type": "equivalent", "target": "9efb4404669223331c80f16eb8181e0e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "51131f8d3f132e0ebe995be51a7e214b", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "收紧对解析标识符的函数（如 regprocedurein()）中空白的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807"}, "url": "/docs/compare/?release=9.6.4#9.6.4-5118ee67f07e4d53", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "7dc7725bf5e33baf9a4661587b0e8778", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "收紧对解析标识符的函数（如 regprocedurein()）中空白的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807"}, "url": "/docs/compare/?release=9.5.8#9.5.8-5118ee67f07e4d53", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "9efb4404669223331c80f16eb8181e0e", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "收紧对解析标识符的函数（如 regprocedurein()）中空白的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807"}, "url": "/docs/compare/?release=9.4.13#9.4.13-5118ee67f07e4d53", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "3c0a5921b737f2e58d32771afebaa81e", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "收紧对解析标识符的函数（如 regprocedurein()）中空白的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "33a525d2ff427c75198e734de5916d99da60fdf6f04405fd1a0236afacf40807"}, "url": "/docs/compare/?release=9.3.18#9.3.18-5118ee67f07e4d53", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-474980cb5fb146b9", "cves": [], "html": "

编译 PL/Perl 时使用来自 Perl 的相关\n #define 符号（Ashutosh Sharma、Tom Lane）\n

这避免了可移植性问题（通常表现为库加载期间的“握手”不匹配），在使用最近 Perl 版本时。\n

", "text": "编译 PL/Perl 时使用来自 Perl 的相关 #define 符号（Ashutosh Sharma、Tom Lane） 这避免了可移植性问题（通常表现为库加载期间的“握手”不匹配），在使用最近 Perl 版本时。", "title": "编译 PL/Perl 时使用来自 Perl 的相关 #define 符号", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "0b4e4b61fdb7b9a4a0051c63bbe228a449d95c13b1d5a18fdb396979f7417f1d", "section_path": ["变更"], "commit_groups": [], "identity_text": "Use relevant #define symbols from Perl while compiling PL/Perl (Ashutosh Sharma, Tom Lane) This avoids portability problems, typically manifesting as a handshake mismatch during library load, when working with recent Perl versions.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/020", "db_id": "9d939394d3ef977b355d5067c31096da", "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e", "relations": [{"rule": 2, "type": "equivalent", "target": "305da47f50ed8f0ce3a821641c6f95b6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e"}}, {"rule": 2, "type": "equivalent", "target": "c22a12a11473dfddf3f84f1ae9150cfb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e"}}, {"rule": 2, "type": "equivalent", "target": "c77f2092d00b5020f4fa8133a9904bef", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e"}}, {"rule": 2, "type": "equivalent", "target": "e1497c1373601f3a52ad6e5179cebd31", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "305da47f50ed8f0ce3a821641c6f95b6", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "编译 PL/Perl 时使用来自 Perl 的相关 #define 符号", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e"}, "url": "/docs/compare/?release=9.6.4#9.6.4-474980cb5fb146b9", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "c77f2092d00b5020f4fa8133a9904bef", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "编译 PL/Perl 时使用来自 Perl 的相关 #define 符号", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e"}, "url": "/docs/compare/?release=9.5.8#9.5.8-474980cb5fb146b9", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "c22a12a11473dfddf3f84f1ae9150cfb", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "编译 PL/Perl 时使用来自 Perl 的相关 #define 符号", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e"}, "url": "/docs/compare/?release=9.4.13#9.4.13-474980cb5fb146b9", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "e1497c1373601f3a52ad6e5179cebd31", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "编译 PL/Perl 时使用来自 Perl 的相关 #define 符号", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ffb54d766224c3c9334c048e9778b417e5a58e08157d45b8ccb288415adb02e"}, "url": "/docs/compare/?release=9.3.18#9.3.18-474980cb5fb146b9", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-f6dd38d2b91f2552", "cves": [], "html": "

在 psql 中，修复\n COPY FROM STDIN 以键盘 EOF 信号结束后再尝试另一个 COPY FROM STDIN 时失败的问题（Thomas Munro）\n

这种错误行为在 BSD 衍生平台（包括 macOS）上观察到，但在大多数其他平台上没有。\n

", "text": "在 psql 中，修复 COPY FROM STDIN 以键盘 EOF 信号结束后再尝试另一个 COPY FROM STDIN 时失败的问题（Thomas Munro） 这种错误行为在 BSD 衍生平台（包括 macOS）上观察到，但在大多数其他平台上没有。", "title": "在 psql 中，修复 COPY FROM STDIN 以键盘 EOF 信号结束后再尝试另一个 COPY FROM STDIN 时失败的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "6b52d7d3094513dd149c8e45546113a2f20acf28034466840205591871159104", "section_path": ["变更"], "commit_groups": [], "identity_text": "In psql, fix failure when COPY FROM STDIN is ended with a keyboard EOF signal and then another COPY FROM STDIN is attempted (Thomas Munro) This misbehavior was observed on BSD-derived platforms (including macOS), but not on most others.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/021", "db_id": "848a728f38402af058ade6e9b1bebe80", "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb", "relations": [{"rule": 2, "type": "equivalent", "target": "6004f396e99c733a1e660e68647024bc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb"}}, {"rule": 2, "type": "equivalent", "target": "97b6de864a42aee7da373e5fe0c118fd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb"}}, {"rule": 2, "type": "equivalent", "target": "b68ddd9f7cc23e1e7f98a7342cfb1006", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb"}}, {"rule": 2, "type": "equivalent", "target": "ef425a41068590fd5bab895976085ff8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "97b6de864a42aee7da373e5fe0c118fd", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "在 psql 中，修复 COPY FROM STDIN 以键盘 EOF 信号结束后再尝试另一个 COPY FROM STDIN 时失败的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb"}, "url": "/docs/compare/?release=9.6.4#9.6.4-f6dd38d2b91f2552", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "6004f396e99c733a1e660e68647024bc", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "在 psql 中，修复 COPY FROM STDIN 以键盘 EOF 信号结束后再尝试另一个 COPY FROM STDIN 时失败的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb"}, "url": "/docs/compare/?release=9.5.8#9.5.8-f6dd38d2b91f2552", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "ef425a41068590fd5bab895976085ff8", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "在 psql 中，修复 COPY FROM STDIN 以键盘 EOF 信号结束后再尝试另一个 COPY FROM STDIN 时失败的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb"}, "url": "/docs/compare/?release=9.4.13#9.4.13-f6dd38d2b91f2552", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "b68ddd9f7cc23e1e7f98a7342cfb1006", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "在 psql 中，修复 COPY FROM STDIN 以键盘 EOF 信号结束后再尝试另一个 COPY FROM STDIN 时失败的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e63d43415c19dc213f64879bb7ecdaf630d9c466c9416e88c9b29aa4d2645bdb"}, "url": "/docs/compare/?release=9.3.18#9.3.18-f6dd38d2b91f2552", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-9548977f836b5c39", "cves": [], "html": "

修复 pg_dump 不再为空操作符类发出无效 SQL（Daniel Gustafsson）\n

", "text": "修复 pg_dump 不再为空操作符类发出无效 SQL（Daniel Gustafsson）", "title": "修复 pg_dump 不再为空操作符类发出无效 SQL", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "3ec4a7de0a72285f6c479332a28c4b09b3a831724479c15dbdf388c18866086c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_dump to not emit invalid SQL for an empty operator class (Daniel Gustafsson)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/022", "db_id": "86c3940da42bf99013987523bdf3df4a", "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518", "relations": [{"rule": 2, "type": "equivalent", "target": "070697fb947119da494553bda2f124c7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518"}}, {"rule": 2, "type": "equivalent", "target": "840b295f4eeb4c935d37f6c1a782f8cc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518"}}, {"rule": 2, "type": "equivalent", "target": "c29c869ad06caa372ac1b5711b9554d1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518"}}, {"rule": 2, "type": "equivalent", "target": "e0228a65ed5fca34bd88526c45df6259", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c29c869ad06caa372ac1b5711b9554d1", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 pg_dump 不再为空操作符类发出无效 SQL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518"}, "url": "/docs/compare/?release=9.6.4#9.6.4-9548977f836b5c39", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "e0228a65ed5fca34bd88526c45df6259", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 pg_dump 不再为空操作符类发出无效 SQL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518"}, "url": "/docs/compare/?release=9.5.8#9.5.8-9548977f836b5c39", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "070697fb947119da494553bda2f124c7", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复pg_dump对空操作符类不再输出无效 SQL 的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518"}, "url": "/docs/compare/?release=9.4.13#9.4.13-c14b0269dd70314b", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "840b295f4eeb4c935d37f6c1a782f8cc", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 pg_dump 不再为空操作符类发出无效 SQL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7de335b3642bf82226d51ea151046738e5a2e1ee3b0e1ec54d6e083213dc5518"}, "url": "/docs/compare/?release=9.3.18#9.3.18-9548977f836b5c39", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-c3797e4f36dc9e64", "cves": [], "html": "

修复 pg_dump 在 Windows 上输出到 stdout（Kuntal Ghosh）\n

由于未把文件描述符置为二进制模式，写到 stdout 的压缩纯文本转储会包含损坏的数据。\n

", "text": "修复 pg_dump 在 Windows 上输出到 stdout（Kuntal Ghosh） 由于未把文件描述符置为二进制模式，写到 stdout 的压缩纯文本转储会包含损坏的数据。", "title": "修复 pg_dump 在 Windows 上输出到 stdout", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "1e07ceefb0c2a6a52cf883a9235c4e3da389a369f46c45194ec29e674915c716", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_dump output to stdout on Windows (Kuntal Ghosh) A compressed plain-text dump written to stdout would contain corrupt data due to failure to put the file descriptor into binary mode.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/023", "db_id": "a47aefe46f376f522844b44b005ddbf3", "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9", "relations": [{"rule": 2, "type": "equivalent", "target": "1abe0946f2900b04706de5182f471b42", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9"}}, {"rule": 2, "type": "equivalent", "target": "6b7b01759bbaa4b8b22a137cfd58d1e7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9"}}, {"rule": 2, "type": "equivalent", "target": "b852a6409848994688858c75c3f50002", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9"}}, {"rule": 2, "type": "equivalent", "target": "e5bf0664cfdd70643c866d5227375b63", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b852a6409848994688858c75c3f50002", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 pg_dump 在 Windows 上输出到 stdout", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9"}, "url": "/docs/compare/?release=9.6.4#9.6.4-c3797e4f36dc9e64", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "e5bf0664cfdd70643c866d5227375b63", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 pg_dump 在 Windows 上输出到 stdout", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9"}, "url": "/docs/compare/?release=9.5.8#9.5.8-c3797e4f36dc9e64", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "6b7b01759bbaa4b8b22a137cfd58d1e7", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复 pg_dump 在 Windows 上输出到 stdout", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9"}, "url": "/docs/compare/?release=9.4.13#9.4.13-c3797e4f36dc9e64", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "1abe0946f2900b04706de5182f471b42", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 pg_dump 在 Windows 上输出到 stdout", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "111dfbac0a7cce000d1f37b9a65b7a13f5aa5031add8144bf1fc6cc6f2a8b7d9"}, "url": "/docs/compare/?release=9.3.18#9.3.18-c3797e4f36dc9e64", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-f12dd04738e5aab4", "cves": [], "html": "

修复 pg_get_ruledef() 为列被重命名的视图的\n ON SELECT 规则打印正确输出（Tom Lane）\n

某些边界情况下 pg_dump 依靠\n pg_get_ruledef() 转储视图，因此这个错误可能导致转储/恢复失败。\n

", "text": "修复 pg_get_ruledef() 为列被重命名的视图的 ON SELECT 规则打印正确输出（Tom Lane） 某些边界情况下 pg_dump 依靠 pg_get_ruledef() 转储视图，因此这个错误可能导致转储/恢复失败。", "title": "修复 pg_get_ruledef() 为列被重命名的视图的 ON SELECT 规则打印正确输出", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "801653f9a1887b5e87221929323f5f90fdd82e4ca771e80f414334685bdf7bf5", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_get_ruledef() to print correct output for the ON SELECT rule of a view whose columns have been renamed (Tom Lane) In some corner cases, pg_dump relies on pg_get_ruledef() to dump views, so that this error could result in dump/reload failures.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/024", "db_id": "fc89b5ce5ebfa7e39fc68278673e0a30", "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0", "relations": [{"rule": 2, "type": "equivalent", "target": "379c63a4fbb4dcdaffaa11bbc7213eca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0"}}, {"rule": 2, "type": "equivalent", "target": "ad3786d2a2b785ec36e6295358ad1500", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0"}}, {"rule": 2, "type": "equivalent", "target": "e7a4d12b68f9153446325e58a125f61b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0"}}, {"rule": 2, "type": "equivalent", "target": "f2edaf5cc2e703873f5b089f4871f5c0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "379c63a4fbb4dcdaffaa11bbc7213eca", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 pg_get_ruledef() 为列被重命名的视图的 ON SELECT 规则打印正确输出", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0"}, "url": "/docs/compare/?release=9.6.4#9.6.4-f12dd04738e5aab4", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "ad3786d2a2b785ec36e6295358ad1500", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 pg_get_ruledef() 为列被重命名的视图的 ON SELECT 规则打印正确输出", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0"}, "url": "/docs/compare/?release=9.5.8#9.5.8-f12dd04738e5aab4", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "e7a4d12b68f9153446325e58a125f61b", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复 pg_get_ruledef() 为列被重命名的视图的 ON SELECT 规则打印正确输出", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0"}, "url": "/docs/compare/?release=9.4.13#9.4.13-f12dd04738e5aab4", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "f2edaf5cc2e703873f5b089f4871f5c0", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 pg_get_ruledef() 为列被重命名的视图的 ON SELECT 规则打印正确输出", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "deecfeb804338f704500141f633f4aec3463888f5113fef22d14390c82c3a0e0"}, "url": "/docs/compare/?release=9.3.18#9.3.18-f12dd04738e5aab4", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-7d3ecdbba5e8d785", "cves": [], "html": "

修复 FROM 子句中函数表达式不能反解析为看起来像函数调用的东西时的转储（Tom Lane）\n

", "text": "修复 FROM 子句中函数表达式不能反解析为看起来像函数调用的东西时的转储（Tom Lane）", "title": "修复 FROM 子句中函数表达式不能反解析为看起来像函数调用的东西时的转储", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "1e4e2026b02189eb0345e09f0659c356d834aea12a26610a7c37353f60bb0a5f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix dumping of function expressions in the FROM clause in cases where the expression does not deparse into something that looks like a function call (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/025", "db_id": "5d279250db704303c3619d09775e014d", "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6", "relations": [{"rule": 2, "type": "equivalent", "target": "18b23ab20491f4af49f50eb180188cc8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6"}}, {"rule": 2, "type": "equivalent", "target": "27c42f004a817bb395e89624d4c8565b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6"}}, {"rule": 2, "type": "equivalent", "target": "a365a08bf964ae0b5d013c3af4a2b944", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6"}}, {"rule": 2, "type": "equivalent", "target": "b4620d508b6c65d987d28869d58a5933", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a365a08bf964ae0b5d013c3af4a2b944", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 FROM 子句中函数表达式不能反解析为看起来像函数调用的东西时的转储", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6"}, "url": "/docs/compare/?release=9.6.4#9.6.4-7d3ecdbba5e8d785", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "18b23ab20491f4af49f50eb180188cc8", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 FROM 子句中函数表达式不能反解析为看起来像函数调用的东西时的转储", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6"}, "url": "/docs/compare/?release=9.5.8#9.5.8-7d3ecdbba5e8d785", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "b4620d508b6c65d987d28869d58a5933", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复FROM子句中函数表达式在表达式无法反向解析为类似函数调用形式时的转储", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6"}, "url": "/docs/compare/?release=9.4.13#9.4.13-56b4ce7fa2730c8c", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "27c42f004a817bb395e89624d4c8565b", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 FROM 子句中函数表达式不能反解析为看起来像函数调用的东西时的转储", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514d845021b6bb0da9cd37acb09aa6168f6a17568b4501fe630c77b40aba9cb6"}, "url": "/docs/compare/?release=9.3.18#9.3.18-7d3ecdbba5e8d785", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-5fa98197263eb565", "cves": [], "html": "

修复 pg_basebackup 在 Windows 上输出到\n stdout（Haribabu Kommi）\n

由于未把文件描述符置为二进制模式，写到 stdout 的备份会包含损坏的数据。\n

", "text": "修复 pg_basebackup 在 Windows 上输出到 stdout（Haribabu Kommi） 由于未把文件描述符置为二进制模式，写到 stdout 的备份会包含损坏的数据。", "title": "修复 pg_basebackup 在 Windows 上输出到 stdout", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "238ed6ca5fbb7ff76080c7c45a4a51d2249a2ae423e7ff5e46f54a1279e26383", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_basebackup output to stdout on Windows (Haribabu Kommi) A backup written to stdout would contain corrupt data due to failure to put the file descriptor into binary mode.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/026", "db_id": "0fb0d233c8ad9c02e201adbd5a151955", "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029", "relations": [{"rule": 2, "type": "equivalent", "target": "02eb1abc2b9a20b762b97b41818a87d7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029"}}, {"rule": 2, "type": "equivalent", "target": "89dda01ba3a5a13f897a1a2eeedc22c3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029"}}, {"rule": 2, "type": "equivalent", "target": "b8cb17a32cde2cf63f99f0b6568d654f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029"}}, {"rule": 2, "type": "equivalent", "target": "d4936f7a2cda683f2cdaf1bd900d931c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "89dda01ba3a5a13f897a1a2eeedc22c3", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 pg_basebackup 在 Windows 上输出到 stdout", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029"}, "url": "/docs/compare/?release=9.6.4#9.6.4-5fa98197263eb565", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "d4936f7a2cda683f2cdaf1bd900d931c", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 pg_basebackup 在 Windows 上输出到 stdout", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029"}, "url": "/docs/compare/?release=9.5.8#9.5.8-5fa98197263eb565", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "b8cb17a32cde2cf63f99f0b6568d654f", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复 pg_basebackup 在 Windows 上输出到 stdout", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029"}, "url": "/docs/compare/?release=9.4.13#9.4.13-5fa98197263eb565", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "02eb1abc2b9a20b762b97b41818a87d7", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 pg_basebackup 在 Windows 上输出到 stdout", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a286d052154c786c12f9b5a6cf0098abf3c0ae0510a93fdee6d012c92518b029"}, "url": "/docs/compare/?release=9.3.18#9.3.18-5fa98197263eb565", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-057eae6ce988e826", "cves": [], "html": "

修复 pg_upgrade 确保结束 WAL 记录不具有wal_level = minimum（Bruce Momjian）\n

这一条件可能阻止升级后的备库服务器重新连接。\n

", "text": "修复 pg_upgrade 确保结束 WAL 记录不具有wal_level = minimum（Bruce Momjian） 这一条件可能阻止升级后的备库服务器重新连接。", "title": "修复 pg_upgrade 确保结束 WAL 记录不具有wal_level = minimum", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "8af34ac22cb25c7d6e41286bbfa7c0e4d78353f8506e5473d2ddee65f64bb091", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_upgrade to ensure that the ending WAL record does not have guc-wal-level = minimum (Bruce Momjian) This condition could prevent upgraded standby servers from reconnecting.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/027", "db_id": "9ae680ee51cfb93f20beb90598dc48c1", "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb", "relations": [{"rule": 2, "type": "equivalent", "target": "5fffffcb249499b6b89e60eb86efe93f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb"}}, {"rule": 2, "type": "equivalent", "target": "70779e891888cb9fd45c465d792baee9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb"}}, {"rule": 2, "type": "equivalent", "target": "cc2cb7fef069b9f35fc77bf5ea661129", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb"}}, {"rule": 2, "type": "equivalent", "target": "ed0d7539c7cc60379dde8603ba837426", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed0d7539c7cc60379dde8603ba837426", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "修复 pg_upgrade 确保结束 WAL 记录不具有wal_level = minimum", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb"}, "url": "/docs/compare/?release=9.6.4#9.6.4-057eae6ce988e826", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "cc2cb7fef069b9f35fc77bf5ea661129", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复 pg_upgrade 确保结束 WAL 记录不具有wal_level = minimum", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb"}, "url": "/docs/compare/?release=9.5.8#9.5.8-057eae6ce988e826", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "5fffffcb249499b6b89e60eb86efe93f", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复 pg_upgrade 确保结束 WAL 记录不具有wal_level = minimum", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb"}, "url": "/docs/compare/?release=9.4.13#9.4.13-057eae6ce988e826", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "70779e891888cb9fd45c465d792baee9", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复 pg_upgrade 确保结束 WAL 记录不具有wal_level = minimum", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c939478b340113005a516c99e5cc921f83bdac881bef19fa965653f828e0acdb"}, "url": "/docs/compare/?release=9.3.18#9.3.18-057eae6ce988e826", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-206b0d511840b329", "cves": [], "html": "

用 gcc 构建共享库时始终使用 -fPIC 而不是\n -fpic（Tom Lane）\n

这在有差别的平台上支持更大的扩展库。\n

", "text": "用 gcc 构建共享库时始终使用 -fPIC 而不是 -fpic（Tom Lane） 这在有差别的平台上支持更大的扩展库。", "title": "用 gcc 构建共享库时始终使用 -fPIC 而不是 -fpic", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "edbf85494b16e0bcd114636e44d8cebf7d3865f9d3c483cef4b83ffa178e58ec", "section_path": ["变更"], "commit_groups": [], "identity_text": "Always use -fPIC, not -fpic, when building shared libraries with gcc (Tom Lane) This supports larger extension libraries on platforms where it makes a difference.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/028", "db_id": "09be3ad89f8721a50b41d56c4f7a06ab", "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf", "relations": [{"rule": 2, "type": "equivalent", "target": "283f393e01a328dd5c4a3b42e8f2fe97", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf"}}, {"rule": 2, "type": "equivalent", "target": "4dc83f6692ada3a0722e84b153a661f6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf"}}, {"rule": 2, "type": "equivalent", "target": "7f021a07a0f5f6e98690d6b7807ca400", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf"}}, {"rule": 2, "type": "equivalent", "target": "88836e2b0a18775d156de14ee0ec0b35", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "88836e2b0a18775d156de14ee0ec0b35", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "用 gcc 构建共享库时始终使用 -fPIC 而不是 -fpic", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf"}, "url": "/docs/compare/?release=9.6.4#9.6.4-206b0d511840b329", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "4dc83f6692ada3a0722e84b153a661f6", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "用 gcc 构建共享库时始终使用 -fPIC 而不是 -fpic", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf"}, "url": "/docs/compare/?release=9.5.8#9.5.8-206b0d511840b329", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "7f021a07a0f5f6e98690d6b7807ca400", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "用 gcc 构建共享库时始终使用 -fPIC 而不是 -fpic", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf"}, "url": "/docs/compare/?release=9.4.13#9.4.13-206b0d511840b329", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "283f393e01a328dd5c4a3b42e8f2fe97", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "用 gcc 构建共享库时始终使用 -fPIC 而不是 -fpic", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d1126f9dcefe9dbbdaaa697b8efdbaf4769c29b2b78282fc8b5f6348e9c6fbf"}, "url": "/docs/compare/?release=9.3.18#9.3.18-206b0d511840b329", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-69451b099858f87c", "cves": [], "html": "

修复我们的 Microsoft MSVC 构建脚本中花括号未转义的问题，以避免较新的 Perl 版本发出警告或报错（Andrew Dunstan）\n

", "text": "修复我们的 Microsoft MSVC 构建脚本中花括号未转义的问题，以避免较新的 Perl 版本发出警告或报错（Andrew Dunstan）", "title": "修复我们的 Microsoft MSVC 构建脚本中花括号未转义的问题，以避免较新的 Perl 版本发出警告或报错", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "add7aa12330082b78bbc913f076517b645273bfa59ce9f9500ce2fe230526a0a", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix unescaped-braces issue in our build scripts for Microsoft MSVC, to avoid a warning or error from recent Perl versions (Andrew Dunstan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/029", "db_id": "4ebf055fc0f1622d2b26c0dc0abac9b3", "patch_ids": [], "statement_hash": "85697ddd7fe7a5cc0c583b4c537576bda41c058cc4284d94c86008e4d0fda332", "relations": [{"rule": 2, "type": "equivalent", "target": "6d43a93afe0a245e8d369355009a0bf6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "85697ddd7fe7a5cc0c583b4c537576bda41c058cc4284d94c86008e4d0fda332"}}, {"rule": 2, "type": "equivalent", "target": "9f3041d3ac459eeae44c28d96e0df4df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "85697ddd7fe7a5cc0c583b4c537576bda41c058cc4284d94c86008e4d0fda332"}}, {"rule": 2, "type": "equivalent", "target": "ad88fd873fbabad73980ae1c2e27202a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "85697ddd7fe7a5cc0c583b4c537576bda41c058cc4284d94c86008e4d0fda332"}}], "version": "9.2.22", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6d43a93afe0a245e8d369355009a0bf6", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "修复我们的 Microsoft MSVC 构建脚本中花括号未转义的问题，以避免较新的 Perl 版本发出警告或报错", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "85697ddd7fe7a5cc0c583b4c537576bda41c058cc4284d94c86008e4d0fda332"}, "url": "/docs/compare/?release=9.5.8#9.5.8-69451b099858f87c", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "ad88fd873fbabad73980ae1c2e27202a", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "修复我们用于 Microsoft MSVC 的构建脚本中未转义花括号的问题，以避免较新 Perl 版本发出警告或错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "85697ddd7fe7a5cc0c583b4c537576bda41c058cc4284d94c86008e4d0fda332"}, "url": "/docs/compare/?release=9.4.13#9.4.13-538386859358c376", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "9f3041d3ac459eeae44c28d96e0df4df", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "修复我们的 Microsoft MSVC 构建脚本中花括号未转义的问题，以避免较新的 Perl 版本发出警告或报错", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "85697ddd7fe7a5cc0c583b4c537576bda41c058cc4284d94c86008e4d0fda332"}, "url": "/docs/compare/?release=9.3.18#9.3.18-69451b099858f87c", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-0d6cc60c08d63989", "cves": [], "html": "

在 MSVC 构建中，处理 openssl 库不在\n VC 子目录内的情况（Andrew Dunstan）\n

", "text": "在 MSVC 构建中，处理 openssl 库不在 VC 子目录内的情况（Andrew Dunstan）", "title": "在 MSVC 构建中，处理 openssl 库不在 VC 子目录内的情况", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "28641a96d7cc184cde78b427001e336cd3b75bd5d71640543213785cf2681003", "section_path": ["变更"], "commit_groups": [], "identity_text": "In MSVC builds, handle the case where the openssl library is not within a VC subdirectory (Andrew Dunstan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/030", "db_id": "4987cc700fdf507f6d116cb8c00a95f2", "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143", "relations": [{"rule": 2, "type": "equivalent", "target": "2ffe419c5f7176f78b624e77d8ed0445", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143"}}, {"rule": 2, "type": "equivalent", "target": "5ba5c3c618b18840b6e7ea4b065e8eff", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143"}}, {"rule": 2, "type": "equivalent", "target": "b1e8c52cd265fcb98d29ef30f720c81d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143"}}, {"rule": 2, "type": "equivalent", "target": "e2a259345722af9b05ae29fa2570b75e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "5ba5c3c618b18840b6e7ea4b065e8eff", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "在 MSVC 构建中，处理 openssl 库不在 VC 子目录内的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143"}, "url": "/docs/compare/?release=9.6.4#9.6.4-0d6cc60c08d63989", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "2ffe419c5f7176f78b624e77d8ed0445", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "在 MSVC 构建中，处理 openssl 库不在 VC 子目录内的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143"}, "url": "/docs/compare/?release=9.5.8#9.5.8-0d6cc60c08d63989", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "b1e8c52cd265fcb98d29ef30f720c81d", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "MSVC 构建中，处理openssl库不在VC子目录内的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143"}, "url": "/docs/compare/?release=9.4.13#9.4.13-41e2b916a89271ec", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "e2a259345722af9b05ae29fa2570b75e", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "在 MSVC 构建中，处理 openssl 库不在 VC 子目录内的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "829536b9e1207eaea1aa6d43b85a8d8d1203c2f68ea907fb959d536c744d5143"}, "url": "/docs/compare/?release=9.3.18#9.3.18-0d6cc60c08d63989", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-52a5f74194c8f736", "cves": [], "html": "

在 MSVC 构建中，为 libxml2 头文件添加正确的包含路径（Andrew Dunstan）\n

这修复了以前需要移动标准 Windows 安装的\n libxml2 中某些东西的需要。\n

", "text": "在 MSVC 构建中，为 libxml2 头文件添加正确的包含路径（Andrew Dunstan） 这修复了以前需要移动标准 Windows 安装的 libxml2 中某些东西的需要。", "title": "在 MSVC 构建中，为 libxml2 头文件添加正确的包含路径", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "ee6d89baad1b1a7a6d4b8b4e231e2d94017d008a8eb28c0a68a5cec2597a4b56", "section_path": ["变更"], "commit_groups": [], "identity_text": "In MSVC builds, add proper include path for libxml2 header files (Andrew Dunstan) This fixes a former need to move things around in standard Windows installations of libxml2.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/031", "db_id": "02e85494d7f70ee9aec00724e9cea8e9", "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840", "relations": [{"rule": 2, "type": "equivalent", "target": "5a23348b20eaec0a5ee2ec9cf24180ca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840"}}, {"rule": 2, "type": "equivalent", "target": "69a1c1ee3e2fd1046eb41dae764406d3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840"}}, {"rule": 2, "type": "equivalent", "target": "8461d768f61b233b5f9b20907c2a131a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840"}}, {"rule": 2, "type": "equivalent", "target": "cf9983c3fe174fb913939e9666d03f02", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "8461d768f61b233b5f9b20907c2a131a", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "在 MSVC 构建中，为 libxml2 头文件添加正确的包含路径", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840"}, "url": "/docs/compare/?release=9.6.4#9.6.4-52a5f74194c8f736", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "69a1c1ee3e2fd1046eb41dae764406d3", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "在 MSVC 构建中，为 libxml2 头文件添加正确的包含路径", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840"}, "url": "/docs/compare/?release=9.5.8#9.5.8-52a5f74194c8f736", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "cf9983c3fe174fb913939e9666d03f02", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "在 MSVC 构建中，为 libxml2 头文件添加正确的包含路径", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840"}, "url": "/docs/compare/?release=9.4.13#9.4.13-52a5f74194c8f736", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "5a23348b20eaec0a5ee2ec9cf24180ca", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "在 MSVC 构建中，为 libxml2 头文件添加正确的包含路径", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e49ed0bfe8704825a620f2bcb44dd827a5eef57c3287c696e45f75ec61938840"}, "url": "/docs/compare/?release=9.3.18#9.3.18-52a5f74194c8f736", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}, {"id": "9.2.22-09717ca3220cfa78", "cves": [], "html": "

在 MSVC 构建中，识别名为 tcl86.lib 的 Tcl 库（Noah Misch）\n

", "text": "在 MSVC 构建中，识别名为 tcl86.lib 的 Tcl 库（Noah Misch）", "title": "在 MSVC 构建中，识别名为 tcl86.lib 的 Tcl 库", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.2.22/#id-1.11.6.7.6", "source_hash": "9e9b9be854a8e8386188f3722c64ef4d896eb9e386d369944538d95425c75bf8", "section_path": ["变更"], "commit_groups": [], "identity_text": "In MSVC builds, recognize a Tcl library that is named tcl86.lib (Noah Misch)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.22/changes/032", "db_id": "c6c010717f86305f92265081e43c02b4", "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be", "relations": [{"rule": 2, "type": "equivalent", "target": "09853f1b92e62eeb03a0337b392cd00e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be"}}, {"rule": 2, "type": "equivalent", "target": "3f75c573c809644f4849abb7e6e49a14", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be"}}, {"rule": 2, "type": "equivalent", "target": "8426debdeb9bf3af83fe18cea868f692", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be"}}, {"rule": 2, "type": "equivalent", "target": "d64aeca94e20b7f5038e441bcca2f806", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be"}}], "version": "9.2.22", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "3f75c573c809644f4849abb7e6e49a14", "kind": "equivalent", "version": "9.6.4", "label": "9.6.4", "title": "在 MSVC 构建中，识别名为 tcl86.lib 的 Tcl 库", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be"}, "url": "/docs/compare/?release=9.6.4#9.6.4-09717ca3220cfa78", "source_url": "/docs/release/9.6.4/#id-1.11.6.25.5"}, {"db_id": "09853f1b92e62eeb03a0337b392cd00e", "kind": "equivalent", "version": "9.5.8", "label": "9.5.8", "title": "在 MSVC 构建中，识别名为 tcl86.lib 的 Tcl 库", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be"}, "url": "/docs/compare/?release=9.5.8#9.5.8-09717ca3220cfa78", "source_url": "/docs/release/9.5.8/#id-1.11.6.22.5"}, {"db_id": "d64aeca94e20b7f5038e441bcca2f806", "kind": "equivalent", "version": "9.4.13", "label": "9.4.13", "title": "MSVC 构建中，识别名为tcl86.lib的 Tcl 库", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be"}, "url": "/docs/compare/?release=9.4.13#9.4.13-9c59be30dd25ecf3", "source_url": "/docs/release/9.4.13/#id-1.11.6.18.5"}, {"db_id": "8426debdeb9bf3af83fe18cea868f692", "kind": "equivalent", "version": "9.3.18", "label": "9.3.18", "title": "在 MSVC 构建中，识别名为 tcl86.lib 的 Tcl 库", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3e9444c9c8bf49af68d89b8883507380c88b2b428202c8575e8196a31db9c1be"}, "url": "/docs/compare/?release=9.3.18#9.3.18-09717ca3220cfa78", "source_url": "/docs/release/9.3.18/#id-1.11.6.12.5"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 32}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 17}, {"key": "security", "label": "安全相关", "count": 2}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 13}], "total": 32, "release_count": 1, "cross_major": false, "cve_count": 3, "cves": [{"id": "CVE-2017-7547", "url": "https://www.postgresql.org/support/security/CVE-2017-7547/", "fixed": {"9.2": "9.2.22", "9.3": "9.3.18", "9.4": "9.4.13", "9.5": "9.5.8", "9.6": "9.6.4"}, "score": 8.5, "title": "进一步限制 pg_user_mappings.umoptions 的可见性，以保护存储为用户映射选项的密码", "vector": "AV:N/AC:H/PR:L/UI:N/S:C/C:H/I:H/A:H", "affected": {"9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"9.2": "2017-08-10", "9.3": "2017-08-10", "9.4": "2017-08-10", "9.5": "2017-08-10", "9.6": "2017-08-10"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-08-10", "fixed_version": "9.2.22"}, {"id": "CVE-2017-7486", "url": "https://www.postgresql.org/support/security/CVE-2017-7486/", "fixed": {"9.2": "9.2.21", "9.3": "9.3.17", "9.4": "9.4.12", "9.5": "9.5.7", "9.6": "9.6.3"}, "score": 8.5, "title": "进一步限制 pg_user_mappings.umoptions 的可见性，以保护存储为用户映射选项的密码", "vector": "AV:N/AC:H/PR:L/UI:N/S:C/C:H/I:H/A:H", "affected": {"9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"9.2": "2017-05-11", "9.3": "2017-05-11", "9.4": "2017-05-11", "9.5": "2017-05-11", "9.6": "2017-05-11"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-05-11", "fixed_version": "9.2.21"}, {"id": "CVE-2017-7546", "url": "https://www.postgresql.org/support/security/CVE-2017-7546/", "fixed": {"9.2": "9.2.22", "9.3": "9.3.18", "9.4": "9.4.13", "9.5": "9.5.8", "9.6": "9.6.4"}, "score": 8.1, "title": "禁止在所有基于密码的认证方法中使用空密码", "vector": "AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H", "affected": {"9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"9.2": "2017-08-10", "9.3": "2017-08-10", "9.4": "2017-08-10", "9.5": "2017-08-10", "9.6": "2017-08-10"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-08-10", "fixed_version": "9.2.22"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 32, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}