{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2022-05-12", "build": "10.21", "major": "10", "minor": 21, "manual": "10", "status": "stable", "doc_git": "", "version": "10.21", "eol_date": "2022-11-10", "date_text": "2022-05-12", "supported": false, "manual_url": "/docs/10/release-10-21.html", "source_url": "/docs/release/10.21/", "entry_count": 29, "placeholder": false, "content_hash": "5daa9263a51105d50ed5507473b57f7f42e8dda116a4e676762ee491adfcc2a4", "manual_build": "10.23", "source_as_of": "", "changes_count": 29, "doc_loaded_at": "2026-09-26T02:56:43.207462", "migration_html": "

对于运行 10.X 的用户，不需要执行导出/恢复。

\n

但是，如果是从早于 10.19 的版本升级，请参见第 E.5 节。

", "compatibility_count": 0, "label": "10.21", "status_label": "历史版本", "eol": "2022-11-10", "age_days": 1602, "support_days": -1420}, "groups": [{"date": "2022-05-12", "build": "10.21", "major": "10", "minor": 21, "manual": "10", "status": "stable", "doc_git": "", "version": "10.21", "eol_date": "2022-11-10", "date_text": "2022-05-12", "supported": false, "manual_url": "/docs/10/release-10-21.html", "source_url": "/docs/release/10.21/", "entry_count": 29, "placeholder": false, "content_hash": "5daa9263a51105d50ed5507473b57f7f42e8dda116a4e676762ee491adfcc2a4", "manual_build": "10.23", "source_as_of": "", "changes_count": 29, "doc_loaded_at": "2026-09-26T02:56:43.207462", "migration_html": "

对于运行 10.X 的用户，不需要执行导出/恢复。

\n

但是，如果是从早于 10.19 的版本升级，请参见第 E.5 节。

", "compatibility_count": 0, "label": "10.21", "status_label": "历史版本", "eol": "2022-11-10", "age_days": 1602, "support_days": -1420, "entries": [{"id": "10.21-cc5eedf7a8bed7a1", "cves": ["CVE-2022-1552"], "html": "

将更多操作限制在“安全受限操作”沙箱内（Sergey Shinderuk，Noah Misch）

\n

自动清理、CLUSTER、CREATE INDEX、REINDEX、REFRESH MATERIALIZED VIEW 和 pg_amcheck 激活“安全受限操作”保护机制的时间过晚，甚至在某些代码路径中根本没有激活。在数据库中拥有创建非临时对象权限的用户可以定义一个对象，当自动清理下次处理该对象时，或者当某个超级用户对其运行上述受影响的命令时，该对象会以超级用户权限执行任意 SQL 代码。

\n

PostgreSQL 项目感谢 Alexander Lakhin 报告此问题。（CVE-2022-1552）

", "text": "将更多操作限制在“安全受限操作”沙箱内（Sergey Shinderuk，Noah Misch） 自动清理、CLUSTER、CREATE INDEX、REINDEX、REFRESH MATERIALIZED VIEW 和 pg_amcheck 激活“安全受限操作”保护机制的时间过晚，甚至在某些代码路径中根本没有激活。在数据库中拥有创建非临时对象权限的用户可以定义一个对象，当自动清理下次处理该对象时，或者当某个超级用户对其运行上述受影响的命令时，该对象会以超级用户权限执行任意 SQL 代码。 PostgreSQL 项目感谢 Alexander Lakhin 报告此问题。（CVE-2022-1552）", "title": "将更多操作限制在“安全受限操作”沙箱内", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "ec8f2b56a1bb14f874fe221331d6484c239709239540282865052ef10dd17f9f", "section_path": ["变更"], "commit_groups": [["0abc1a059", "34ff15660", "677a49478", "880511cb0", "88743d581", "f26d57028"], ["35edcc0ce", "48ca2904c", "7f098f7b5", "a117cebd6", "ab49ce7c3", "ef792f785"]], "identity_text": "Confine additional operations within security restricted operation sandboxes (Sergey Shinderuk, Noah Misch) Autovacuum, CLUSTER, CREATE INDEX, REINDEX, REFRESH MATERIALIZED VIEW, and pg_amcheck activated the security restricted operation protection mechanism too late, or even not at all in some code paths. A user having permission to create non-temporary objects within a database could define an object that would execute arbitrary SQL code with superuser permissions the next time that autovacuum processed the object, or that some superuser ran one of the affected commands against it. The PostgreSQL Project thanks Alexander Lakhin for reporting this problem. (CVE-2022-1552)", "commit_aliases": ["0abc1a059", "34ff15660", "35edcc0ce", "48ca2904c", "677a49478", "7f098f7b5", "880511cb0", "88743d581", "a117cebd6", "ab49ce7c3", "ef792f785", "f26d57028"], "source_commits": ["ef792f785", "f26d57028"], "source_entry_id": "10.21/changes/001", "db_id": "1ac54926400c94d0acb3b2bb0d1cb714", "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93", "relations": [{"rule": 2, "type": "equivalent", "target": "670752f6faecb1221ddd1f4e1948ef86", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}}, {"rule": 2, "type": "equivalent", "target": "7c535db7e63d3466361dd5ae7cb611e7", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}}, {"rule": 2, "type": "equivalent", "target": "a5b83ef3758e795df0c7a6b30e6a53c7", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}}, {"rule": 2, "type": "equivalent", "target": "aae3e4d08f49bbe829bd6f85df92c72f", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}}], "version": "10.21", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "7c535db7e63d3466361dd5ae7cb611e7", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "将更多操作限制在“安全受限操作”沙箱内", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}, "url": "/docs/compare/?release=14.3#14.3-a23393de94e369b8", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "a5b83ef3758e795df0c7a6b30e6a53c7", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "将更多操作限制在“安全受限操作”沙箱内", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}, "url": "/docs/compare/?release=13.7#13.7-7c751a4817cbcd26", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "aae3e4d08f49bbe829bd6f85df92c72f", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "将更多操作限制在“安全受限操作”沙箱内", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}, "url": "/docs/compare/?release=12.11#12.11-3bd03835132773e3", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "670752f6faecb1221ddd1f4e1948ef86", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "将更多操作限制在“安全受限操作”沙箱内", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}, "url": "/docs/compare/?release=11.16#11.16-cc5eedf7a8bed7a1", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-e98e47a0677bc818", "cves": [], "html": "

停止将查询提供的列别名用于引用普通表的整行变量的列（Tom Lane）

\n

整行变量（例如在 SELECT 列表顶层以外的上下文中的 tbl.*）产生的元组中的列名，现在始终为关联的命名复合类型的列名（如果有的话）。之前我们曾尝试使其跟踪已应用于该变量所引用的 FROM 条目的任何列别名。但这在语义上是有问题的，因为这样变量的输出实际上根本不是它声称的复合类型。之前处理这种不一致性的尝试产生了糟糕的结果，甚至包括在磁盘上存储不可读的数据，因此放弃了整个想法。

\n

在需要重新标记这些列的情况下，一种变通方法是引入一个额外的子 SELECT 层级，使整行变量引用子 SELECT 的输出而非普通表。这样变量一开始就是 record 类型，就不存在这个问题了。

", "text": "停止将查询提供的列别名用于引用普通表的整行变量的列（Tom Lane） 整行变量（例如在 SELECT 列表顶层以外的上下文中的 tbl.*）产生的元组中的列名，现在始终为关联的命名复合类型的列名（如果有的话）。之前我们曾尝试使其跟踪已应用于该变量所引用的 FROM 条目的任何列别名。但这在语义上是有问题的，因为这样变量的输出实际上根本不是它声称的复合类型。之前处理这种不一致性的尝试产生了糟糕的结果，甚至包括在磁盘上存储不可读的数据，因此放弃了整个想法。 在需要重新标记这些列的情况下，一种变通方法是引入一个额外的子 SELECT 层级，使整行变量引用子 SELECT 的输出而非普通表。这样变量一开始就是 record 类型，就不存在这个问题了。", "title": "停止将查询提供的列别名用于引用普通表的整行变量的列", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "99c7b7b7e7452140890aa20c90b1f59146746c036f4a743d3d5a71904080b9b8", "section_path": ["变更"], "commit_groups": [["13b54d1e0", "1d072bd20", "1f5ef5ae0", "205214c8b", "5e144cc89", "ec62cb0aa"]], "identity_text": "Stop using query-provided column aliases for the columns of whole-row variables that refer to plain tables (Tom Lane) The column names in tuples produced by a whole-row variable (such as tbl.* in contexts other than the top level of a SELECT list) are now always those of the associated named composite type, if there is one. We'd previously attempted to make them track any column aliases that had been applied to the FROM entry the variable refers to. But that's semantically dubious, because really then the output of the variable is not at all of the composite type it claims to be. Previous attempts to deal with that inconsistency had bad results up to and including storing unreadable data on disk, so just give up on the whole idea. In cases where it's important to be able to relabel such columns, a workaround is to introduce an extra level of sub-SELECT, so that the whole-row variable is referring to the sub-SELECT's output and not to a plain table. Then the variable is of type record to begin with and there's no issue.", "commit_aliases": ["13b54d1e0", "1d072bd20", "1f5ef5ae0", "205214c8b", "5e144cc89", "ec62cb0aa"], "source_commits": ["205214c8b"], "source_entry_id": "10.21/changes/002", "db_id": "50113dceb9fd7e3fb916ee60adbc2109", "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b", "relations": [{"rule": 2, "type": "equivalent", "target": "6069c464fb5744df216dbddd8922e7d4", "evidence": {"same_day": true, "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b"}}, {"rule": 2, "type": "equivalent", "target": "8a901fa7a440b29b299f8e2ca29061b7", "evidence": {"same_day": true, "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b"}}, {"rule": 2, "type": "equivalent", "target": "969748cc25edeaff75f516b082da57e6", "evidence": {"same_day": true, "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b"}}, {"rule": 2, "type": "equivalent", "target": "e604c10edd4a506923f4816cc6e383ec", "evidence": {"same_day": true, "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "969748cc25edeaff75f516b082da57e6", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "停止将查询提供的列别名用于引用普通表的整行变量的列", "evidence": {"same_day": true, "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b"}, "url": "/docs/compare/?release=14.3#14.3-0b10ee57de8f9ebf", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "e604c10edd4a506923f4816cc6e383ec", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "停止将查询提供的列别名用于引用普通表的整行变量的列", "evidence": {"same_day": true, "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b"}, "url": "/docs/compare/?release=13.7#13.7-26632bd248f9cfc9", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "6069c464fb5744df216dbddd8922e7d4", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "停止将查询提供的列别名用于引用普通表的整行变量的列", "evidence": {"same_day": true, "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b"}, "url": "/docs/compare/?release=12.11#12.11-2c6dd5678610603a", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "8a901fa7a440b29b299f8e2ca29061b7", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "停止将查询提供的列别名用于引用普通表的整行变量的列", "evidence": {"same_day": true, "patch_ids": ["73e95b142713ae8370b71d093e0175b8"], "statement_hash": "076f7fe9f3f66c54083bec7a655caec7bf6ef6a6221003bf933444156d11078b"}, "url": "/docs/compare/?release=11.16#11.16-e98e47a0677bc818", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-990ad49e6155242e", "cves": [], "html": "

修复 table_to_xmlschema() 及相关函数中 timestamptz 和 timetz 类型的不正确输出（Renan Soares Lopes）

\n

这些类型的 xmlschema 输出包含了格式错误的正则表达式。

", "text": "修复 table_to_xmlschema() 及相关函数中 timestamptz 和 timetz 类型的不正确输出（Renan Soares Lopes） 这些类型的 xmlschema 输出包含了格式错误的正则表达式。", "title": "修复 table_to_xmlschema() 及相关函数中 timestamptz 和 timetz 类型的不正确输出", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "ee777375c37f6ee4eeb6dd445dd55e74b7d15cd24fa19c35edf67a7146c964bc", "section_path": ["变更"], "commit_groups": [["068739fb4", "840729fd1", "84f3ecdaa", "88ae77588", "ae8ec7feb", "e6fd4a3da"]], "identity_text": "Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions (Renan Soares Lopes) The xmlschema output for these types included a malformed regular expression.", "commit_aliases": ["068739fb4", "840729fd1", "84f3ecdaa", "88ae77588", "ae8ec7feb", "e6fd4a3da"], "source_commits": ["e6fd4a3da"], "source_entry_id": "10.21/changes/003", "db_id": "de93d3abf896b187c9efb28d02ee9afa", "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766", "relations": [{"rule": 2, "type": "equivalent", "target": "8431c7c2370d34325416722917ede31c", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}}, {"rule": 2, "type": "equivalent", "target": "a13f3240245934b132260a24490e7277", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}}, {"rule": 2, "type": "equivalent", "target": "cc636bb0e6243df1c5f2fca898a67312", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}}, {"rule": 2, "type": "equivalent", "target": "d8f0644985f5ea7f13e738a7c833da64", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d8f0644985f5ea7f13e738a7c833da64", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复 table_to_xmlschema() 及相关函数中 timestamptz 和 timetz 类型的不正确输出", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}, "url": "/docs/compare/?release=14.3#14.3-ddd5fbca25fa8477", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "a13f3240245934b132260a24490e7277", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复 table_to_xmlschema() 及相关函数中 timestamptz 和 timetz 类型的不正确输出", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}, "url": "/docs/compare/?release=13.7#13.7-f23c634fbff6a135", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "cc636bb0e6243df1c5f2fca898a67312", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复 table_to_xmlschema() 及相关函数中 timestamptz 和 timetz 类型的不正确输出", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}, "url": "/docs/compare/?release=12.11#12.11-a34ad631cde543a1", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "8431c7c2370d34325416722917ede31c", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复 table_to_xmlschema() 及相关函数中 timestamptz 和 timetz 类型的不正确输出", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}, "url": "/docs/compare/?release=11.16#11.16-990ad49e6155242e", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-0c06e5e1ae652414", "cves": [], "html": "

避免解析器在处理零列的 VALUES 子句时发生核心转储（Tom Lane）

", "text": "避免解析器在处理零列的 VALUES 子句时发生核心转储（Tom Lane）", "title": "避免解析器在处理零列的 VALUES 子句时发生核心转储", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "d8c9bbfa3769bd30beff186cfba2696fb194a99e2788b730e649d8f21000200d", "section_path": ["变更"], "commit_groups": [["4eabaffca", "539f8c563", "90e52884e", "91a3a74c6", "ab2f78392", "fe20afaee"]], "identity_text": "Avoid core dump in parser for a VALUES clause with zero columns (Tom Lane)", "commit_aliases": ["4eabaffca", "539f8c563", "90e52884e", "91a3a74c6", "ab2f78392", "fe20afaee"], "source_commits": ["4eabaffca"], "source_entry_id": "10.21/changes/004", "db_id": "ea5846b5805f89f205a3cb35ea04f01b", "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4", "relations": [{"rule": 2, "type": "equivalent", "target": "399a07b8582a635f588993d56e7f3983", "evidence": {"same_day": true, "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4"}}, {"rule": 2, "type": "equivalent", "target": "7a1d51545592f7744cfd3ea29d95c887", "evidence": {"same_day": true, "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4"}}, {"rule": 2, "type": "equivalent", "target": "89acd29803e8cbb389616a17123abf12", "evidence": {"same_day": true, "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4"}}, {"rule": 2, "type": "equivalent", "target": "ecdc57b965639be2a94482f578332144", "evidence": {"same_day": true, "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "399a07b8582a635f588993d56e7f3983", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "避免解析器在处理零列的 VALUES 子句时发生核心转储", "evidence": {"same_day": true, "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4"}, "url": "/docs/compare/?release=14.3#14.3-cebece1bb097e355", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "89acd29803e8cbb389616a17123abf12", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "避免解析器在处理零列的 VALUES 子句时发生核心转储", "evidence": {"same_day": true, "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4"}, "url": "/docs/compare/?release=13.7#13.7-a23dbadc1d425b27", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "ecdc57b965639be2a94482f578332144", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "避免解析器在处理零列的 VALUES 子句时发生核心转储", "evidence": {"same_day": true, "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4"}, "url": "/docs/compare/?release=12.11#12.11-bbda885258fb1bdf", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "7a1d51545592f7744cfd3ea29d95c887", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "避免解析器在处理零列的 VALUES 子句时发生核心转储", "evidence": {"same_day": true, "patch_ids": ["1d4aa3b4331673e8ad7e3d5ebe77894a"], "statement_hash": "235e2c1f113de1334ebc574b76fcbc06e2eba86562782a031663e671dcd878f4"}, "url": "/docs/compare/?release=11.16#11.16-0c06e5e1ae652414", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-54568bf34e4d0d2c", "cves": [], "html": "

修复引用外层查询级别的 GROUPING() 构造的规划器错误（Richard Guo，Tom Lane）

", "text": "修复引用外层查询级别的 GROUPING() 构造的规划器错误（Richard Guo，Tom Lane）", "title": "修复引用外层查询级别的 GROUPING() 构造的规划器错误", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "4386c1bd47bcf6d1e3f336efe3ee163b16ccf0ab52222b68cf823758224ba05e", "section_path": ["变更"], "commit_groups": [["2591ee8ec", "2afa031ac", "48b6035f0", "5de244196", "69c88e2fb", "dfefe38fb"]], "identity_text": "Fix planner errors for GROUPING() constructs that reference outer query levels (Richard Guo, Tom Lane)", "commit_aliases": ["2591ee8ec", "2afa031ac", "48b6035f0", "5de244196", "69c88e2fb", "dfefe38fb"], "source_commits": ["2afa031ac"], "source_entry_id": "10.21/changes/005", "db_id": "2ca934b4db390844f7a472a975c60ddb", "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9", "relations": [{"rule": 2, "type": "equivalent", "target": "386ddf2bbb16a07e9660e3025d749f49", "evidence": {"same_day": true, "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9"}}, {"rule": 2, "type": "equivalent", "target": "9f846d4b1ade0e38644b44a656481903", "evidence": {"same_day": true, "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9"}}, {"rule": 2, "type": "equivalent", "target": "b7d4012a01e5b568d9248e6ab7392672", "evidence": {"same_day": true, "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9"}}, {"rule": 2, "type": "equivalent", "target": "b8e4a307d615db776e0cc68a728f1205", "evidence": {"same_day": true, "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b8e4a307d615db776e0cc68a728f1205", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复引用外层查询级别的 GROUPING() 构造的规划器错误", "evidence": {"same_day": true, "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9"}, "url": "/docs/compare/?release=14.3#14.3-bf88ad7aa945f3f6", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "386ddf2bbb16a07e9660e3025d749f49", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复引用外层查询级别的 GROUPING() 构造的规划器错误", "evidence": {"same_day": true, "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9"}, "url": "/docs/compare/?release=13.7#13.7-9dc139eb0b7a8849", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "9f846d4b1ade0e38644b44a656481903", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复引用外层查询级别的 GROUPING() 构造的规划器错误", "evidence": {"same_day": true, "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9"}, "url": "/docs/compare/?release=12.11#12.11-44e126f786a9682a", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "b7d4012a01e5b568d9248e6ab7392672", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复引用外层查询级别的 GROUPING() 构造的规划器错误", "evidence": {"same_day": true, "patch_ids": ["895aae79c8a50fe997dd20d7dbf563ec"], "statement_hash": "068d9983be7f89629196ba2583fdc9d7cbf57e0767a035a81f1be468300b46e9"}, "url": "/docs/compare/?release=11.16#11.16-54568bf34e4d0d2c", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-4306229ab7c048f6", "cves": [], "html": "

修复具有可返回列和不可返回列的索引上的仅索引扫描计划生成（Tom Lane）

\n

之前的代码会尝试读取不可返回列以及可返回列。这基本上是无害的，因为它实际上并没有对错误的值做任何处理，但它违反了最近添加的拒绝此类计划的错误检查。

", "text": "修复具有可返回列和不可返回列的索引上的仅索引扫描计划生成（Tom Lane） 之前的代码会尝试读取不可返回列以及可返回列。这基本上是无害的，因为它实际上并没有对错误的值做任何处理，但它违反了最近添加的拒绝此类计划的错误检查。", "title": "修复具有可返回列和不可返回列的索引上的仅索引扫描计划生成", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "4e7660838d851df9fa522fa1b43ccb7abd8784a0aec5e83e227dabff2e43da0c", "section_path": ["变更"], "commit_groups": [["0778b24ce", "14ee565f3", "277e744ae", "32e801676", "b6f869bee", "e5691cc91"]], "identity_text": "Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns (Tom Lane) The previous coding could try to read non-returnable columns in addition to the returnable ones. This was fairly harmless because it didn't actually do anything with the bogus values, but it fell foul of a recently-added error check that rejected such a plan.", "commit_aliases": ["0778b24ce", "14ee565f3", "277e744ae", "32e801676", "b6f869bee", "e5691cc91"], "source_commits": ["b6f869bee"], "source_entry_id": "10.21/changes/006", "db_id": "e9ad0f812c136b8ccc25549130b5b91b", "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372", "relations": [{"rule": 2, "type": "equivalent", "target": "1b0812852c836d4e66b06f7612514190", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}}, {"rule": 2, "type": "equivalent", "target": "27a8bf4c09c5ea2d76fb7f98c7ccd2b2", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}}, {"rule": 2, "type": "equivalent", "target": "4f83aeb5cff810bc4a104b3a0c9f2ac4", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}}, {"rule": 2, "type": "equivalent", "target": "8706c720624356138c9ddaea3cb34215", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "27a8bf4c09c5ea2d76fb7f98c7ccd2b2", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复具有可返回列和不可返回列的索引上的仅索引扫描计划生成", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}, "url": "/docs/compare/?release=14.3#14.3-489835e8667c2fae", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "8706c720624356138c9ddaea3cb34215", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复具有可返回列和不可返回列的索引上的仅索引扫描计划生成", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}, "url": "/docs/compare/?release=13.7#13.7-15f44c8cc63b0578", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "4f83aeb5cff810bc4a104b3a0c9f2ac4", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复具有可返回列和不可返回列的索引上的仅索引扫描计划生成", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}, "url": "/docs/compare/?release=12.11#12.11-203c04fd55d9fe6a", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "1b0812852c836d4e66b06f7612514190", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复具有可返回列和不可返回列的索引上的仅索引扫描计划生成", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}, "url": "/docs/compare/?release=11.16#11.16-4306229ab7c048f6", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-5a1d65af0b07877d", "cves": [], "html": "

修复正在执行重新排序的 IndexScan 节点中的查询生命周期内存泄漏（Aliaksandr Kalenik）

", "text": "修复正在执行重新排序的 IndexScan 节点中的查询生命周期内存泄漏（Aliaksandr Kalenik）", "title": "修复正在执行重新排序的 IndexScan 节点中的查询生命周期内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "dfbea564d784578d8985ff0640b98d1c656dbd58c68aba9defccb306bf24cd99", "section_path": ["变更"], "commit_groups": [["0d554775b", "2e9033a54", "3f74daa8d", "7a12a9e3c", "ac2303aa0", "c76665edc"]], "identity_text": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering (Aliaksandr Kalenik)", "commit_aliases": ["0d554775b", "2e9033a54", "3f74daa8d", "7a12a9e3c", "ac2303aa0", "c76665edc"], "source_commits": ["2e9033a54"], "source_entry_id": "10.21/changes/007", "db_id": "8b428e03a852b24df2398da6fce496f9", "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c", "relations": [{"rule": 2, "type": "equivalent", "target": "5e20fe6d76ddabf53f4be2f89d20e818", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}}, {"rule": 2, "type": "equivalent", "target": "67e54ee90f61b5ba4f10c442bccd81e7", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}}, {"rule": 2, "type": "equivalent", "target": "c4dc002e8eff145c0a822b7c88deaea8", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}}, {"rule": 2, "type": "equivalent", "target": "e754f05172c47425f13728c730c2b6cb", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "67e54ee90f61b5ba4f10c442bccd81e7", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复正在执行重新排序的 IndexScan 节点中的查询生命周期内存泄漏", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}, "url": "/docs/compare/?release=14.3#14.3-88ea6eb77fb41d9d", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "e754f05172c47425f13728c730c2b6cb", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复正在执行重新排序的 IndexScan 节点中的查询生命周期内存泄漏", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}, "url": "/docs/compare/?release=13.7#13.7-eea350e990077f35", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "5e20fe6d76ddabf53f4be2f89d20e818", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复正在执行重新排序的 IndexScan 节点中的查询生命周期内存泄漏", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}, "url": "/docs/compare/?release=12.11#12.11-eb0eaa83057dd926", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "c4dc002e8eff145c0a822b7c88deaea8", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复正在执行重新排序的 IndexScan 节点中的查询生命周期内存泄漏", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}, "url": "/docs/compare/?release=11.16#11.16-5a1d65af0b07877d", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-03a41d6793f32fe2", "cves": [], "html": "

修复 ALTER FUNCTION 使其支持在同一命令中同时更改函数的并行属性及其 SET 变量列表（Tom Lane）

\n

如果同一命令还更新了函数的 SET 子句，则并行属性的更改会丢失。

", "text": "修复 ALTER FUNCTION 使其支持在同一命令中同时更改函数的并行属性及其 SET 变量列表（Tom Lane） 如果同一命令还更新了函数的 SET 子句，则并行属性的更改会丢失。", "title": "修复 ALTER FUNCTION 使其支持在同一命令中同时更改函数的并行属性及其 SET 变量列表", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "2016155e75843769013e063c380042c5348cf0f05a47e3a256de2d5818687f0a", "section_path": ["变更"], "commit_groups": [["08a9e7a8c", "344a225cb", "409bcfda6", "481a99811", "9130f8cbb", "f583633bc"]], "identity_text": "Fix ALTER FUNCTION to support changing a function's parallelism property and its SET-variable list in the same command (Tom Lane) The parallelism property change was lost if the same command also updated the function's SET clause.", "commit_aliases": ["08a9e7a8c", "344a225cb", "409bcfda6", "481a99811", "9130f8cbb", "f583633bc"], "source_commits": ["409bcfda6"], "source_entry_id": "10.21/changes/008", "db_id": "00c230d34a27b573997b0dc1960f3741", "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360", "relations": [{"rule": 2, "type": "equivalent", "target": "55b4f7dc72645a632f0c793d8c481f41", "evidence": {"same_day": true, "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360"}}, {"rule": 2, "type": "equivalent", "target": "975fdb3cf8d525dbaf4ca3fcbc3b2405", "evidence": {"same_day": true, "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360"}}, {"rule": 2, "type": "equivalent", "target": "b3f80d8f2c2f7007193f906952927ade", "evidence": {"same_day": true, "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360"}}, {"rule": 2, "type": "equivalent", "target": "da5a5a8908a29a381ee33d3c5f06e62c", "evidence": {"same_day": true, "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b3f80d8f2c2f7007193f906952927ade", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复 ALTER FUNCTION 使其支持在同一命令中同时更改函数的并行属性及其 SET 变量列表", "evidence": {"same_day": true, "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360"}, "url": "/docs/compare/?release=14.3#14.3-bcdb5c5736ea9b79", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "975fdb3cf8d525dbaf4ca3fcbc3b2405", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复 ALTER FUNCTION 使其支持在同一命令中同时更改函数的并行属性及其 SET 变量列表", "evidence": {"same_day": true, "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360"}, "url": "/docs/compare/?release=13.7#13.7-98a1bd07b8159af5", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "da5a5a8908a29a381ee33d3c5f06e62c", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复 ALTER FUNCTION 使其支持在同一命令中同时更改函数的并行属性及其 SET 变量列表", "evidence": {"same_day": true, "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360"}, "url": "/docs/compare/?release=12.11#12.11-3ae4483938d0c9be", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "55b4f7dc72645a632f0c793d8c481f41", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复 ALTER FUNCTION 使其支持在同一命令中同时更改函数的并行属性及其 SET 变量列表", "evidence": {"same_day": true, "patch_ids": ["75b91ef9a22cca08dd625ead6b491f33"], "statement_hash": "efe70f12c08d3944b26c979a7827d252d81dce978e1899c6e0722871bf653360"}, "url": "/docs/compare/?release=11.16#11.16-03a41d6793f32fe2", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-06053beedb5eda2e", "cves": [], "html": "

修复使用前导键为表达式的索引进行 CLUSTER 时表行的错误排序（Peter Geoghegan，Thomas Munro）

\n

表会使用正确的数据重建，但其顺序与索引顺序关系不大。

", "text": "修复使用前导键为表达式的索引进行 CLUSTER 时表行的错误排序（Peter Geoghegan，Thomas Munro） 表会使用正确的数据重建，但其顺序与索引顺序关系不大。", "title": "修复使用前导键为表达式的索引进行 CLUSTER 时表行的错误排序", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "03b3e5aa9abdb8d9a0163638d2ce3d8c4ee4183df09683ca26ba595cecfdfd68", "section_path": ["变更"], "commit_groups": [["1272630a2", "5487585e3", "8ab0ebb9a", "a903895b3", "adb2d84fc", "e4521841a"]], "identity_text": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression (Peter Geoghegan, Thomas Munro) The table would be rebuilt with the correct data, but in an order having little to do with the index order.", "commit_aliases": ["1272630a2", "5487585e3", "8ab0ebb9a", "a903895b3", "adb2d84fc", "e4521841a"], "source_commits": ["a903895b3"], "source_entry_id": "10.21/changes/009", "db_id": "00d8cc4d2df09875b843bd1510c7912c", "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca", "relations": [{"rule": 2, "type": "equivalent", "target": "12527d4d3cfb55406276951c18a2d33e", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}}, {"rule": 2, "type": "equivalent", "target": "18154cd75fda1ba65fa17913f5ebe458", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}}, {"rule": 2, "type": "equivalent", "target": "9ef5206aa477e4189e0fc1416397a897", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}}, {"rule": 2, "type": "equivalent", "target": "eeadfde9c6478270c9cc562840a40f6b", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "9ef5206aa477e4189e0fc1416397a897", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复使用前导键为表达式的索引进行 CLUSTER 时表行的错误排序", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}, "url": "/docs/compare/?release=14.3#14.3-2c8715e3c1588e6b", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "eeadfde9c6478270c9cc562840a40f6b", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复使用前导键为表达式的索引进行 CLUSTER 时表行的错误排序", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}, "url": "/docs/compare/?release=13.7#13.7-c19c6dc51403a951", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "18154cd75fda1ba65fa17913f5ebe458", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复使用前导键为表达式的索引进行 CLUSTER 时表行的错误排序", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}, "url": "/docs/compare/?release=12.11#12.11-a09e04543c50e358", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "12527d4d3cfb55406276951c18a2d33e", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复使用前导键为表达式的索引进行 CLUSTER 时表行的错误排序", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}, "url": "/docs/compare/?release=11.16#11.16-06053beedb5eda2e", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-d46c0bc12aa84fc0", "cves": [], "html": "

修复 DROP TABLESPACE 与检查点之间的竞态条件（Nathan Bossart）

\n

由 DROP TABLESPACE 强制执行的检查点有时无法从表空间目录中删除所有失效文件，导致虚假的 “tablespace is not empty” 错误。

", "text": "修复 DROP TABLESPACE 与检查点之间的竞态条件（Nathan Bossart） 由 DROP TABLESPACE 强制执行的检查点有时无法从表空间目录中删除所有失效文件，导致虚假的 “tablespace is not empty” 错误。", "title": "修复 DROP TABLESPACE 与检查点之间的竞态条件", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "a6a6c8ed899cf00055fc2ae0d54410a0a0aedfd5fe64034755909f76919d0d23", "section_path": ["变更"], "commit_groups": [["26e007939", "46d9bfb0a", "51e760e5a", "c918f07dd", "ca522c60a", "fe197872c"]], "identity_text": "Fix race condition between DROP TABLESPACE and checkpointing (Nathan Bossart) The checkpoint forced by DROP TABLESPACE could sometimes fail to remove all dead files from the tablespace's directory, leading to a bogus tablespace is not empty error.", "commit_aliases": ["26e007939", "46d9bfb0a", "51e760e5a", "c918f07dd", "ca522c60a", "fe197872c"], "source_commits": ["fe197872c"], "source_entry_id": "10.21/changes/010", "db_id": "cf4d21840304d304aff136d3ea88a7d0", "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9", "relations": [{"rule": 2, "type": "equivalent", "target": "2bf6b91c631648150e4e43e26aa33c6e", "evidence": {"same_day": true, "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9"}}, {"rule": 2, "type": "equivalent", "target": "818608b6ca9b6d0f3b5aa4e8dc7491e0", "evidence": {"same_day": true, "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9"}}, {"rule": 2, "type": "equivalent", "target": "922f046161bfcd509b36802c54926083", "evidence": {"same_day": true, "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9"}}, {"rule": 2, "type": "equivalent", "target": "fd6b9e4d47ee95e4622eecb9cf4feb20", "evidence": {"same_day": true, "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fd6b9e4d47ee95e4622eecb9cf4feb20", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复 DROP TABLESPACE 与检查点之间的竞态条件", "evidence": {"same_day": true, "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9"}, "url": "/docs/compare/?release=14.3#14.3-0b899d7af1ebf2eb", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "818608b6ca9b6d0f3b5aa4e8dc7491e0", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复 DROP TABLESPACE 与检查点之间的竞态条件", "evidence": {"same_day": true, "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9"}, "url": "/docs/compare/?release=13.7#13.7-340c862841bb984d", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "2bf6b91c631648150e4e43e26aa33c6e", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复 DROP TABLESPACE 与检查点之间的竞态条件", "evidence": {"same_day": true, "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9"}, "url": "/docs/compare/?release=12.11#12.11-1b954988c27be5ff", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "922f046161bfcd509b36802c54926083", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复 DROP TABLESPACE 与检查点之间的竞态条件", "evidence": {"same_day": true, "patch_ids": ["386ae80e6ad0d0afa551c86aa53a9604"], "statement_hash": "820bce9f2666ab0a13baead5fb3257b7ce9ca9a96ef2eef787376c110f8335d9"}, "url": "/docs/compare/?release=11.16#11.16-d46c0bc12aa84fc0", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-f7cf2cc6ed176c44", "cves": [], "html": "

修复与检查点重叠的 TRUNCATE 命令之后崩溃恢复中可能出现的问题（Kyotaro Horiguchi，Heikki Linnakangas，Robert Haas）

\n

TRUNCATE 必须确保在允许检查点完成之前，表的磁盘文件已被截断。否则，从该检查点开始的重放可能会在本应已移除的页面中发现意外数据，从而可能导致重放失败。

", "text": "修复与检查点重叠的 TRUNCATE 命令之后崩溃恢复中可能出现的问题（Kyotaro Horiguchi，Heikki Linnakangas，Robert Haas） TRUNCATE 必须确保在允许检查点完成之前，表的磁盘文件已被截断。否则，从该检查点开始的重放可能会在本应已移除的页面中发现意外数据，从而可能导致重放失败。", "title": "修复与检查点重叠的 TRUNCATE 命令之后崩溃恢复中可能出现的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "9fb04ce5bc8762714e2400ffe74258c86b7b4792e8d8d037673696de2a7d7a55", "section_path": ["变更"], "commit_groups": [["10520f434", "48b398943", "6270ee445", "68e605b9e", "d18c913b7"], ["118f1a332", "1ce14b6b2", "3821d66a7", "412ad7a55", "57f618310", "bbace5697"]], "identity_text": "Fix possible trouble in crash recovery after a TRUNCATE command that overlaps a checkpoint (Kyotaro Horiguchi, Heikki Linnakangas, Robert Haas) TRUNCATE must ensure that the table's disk file is truncated before the checkpoint is allowed to complete. Otherwise, replay starting from that checkpoint might find unexpected data in the supposedly-removed pages, possibly causing replay failure.", "commit_aliases": ["10520f434", "118f1a332", "1ce14b6b2", "3821d66a7", "412ad7a55", "48b398943", "57f618310", "6270ee445", "68e605b9e", "bbace5697", "d18c913b7"], "source_commits": ["48b398943", "57f618310"], "source_entry_id": "10.21/changes/011", "db_id": "bc54b7976f06d5a469cb25f3721c8355", "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b", "relations": [{"rule": 2, "type": "equivalent", "target": "00aede7f60516464bd0e281bb684e25d", "evidence": {"same_day": true, "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b"}}, {"rule": 2, "type": "equivalent", "target": "434938212b1ae0ed20e3bd7a775dd600", "evidence": {"same_day": true, "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b"}}, {"rule": 2, "type": "equivalent", "target": "6828b4b16c705355b907fdd960ed2bf3", "evidence": {"same_day": true, "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b"}}, {"rule": 2, "type": "equivalent", "target": "85baf415d072880c35de92cf6a4c9275", "evidence": {"same_day": true, "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "434938212b1ae0ed20e3bd7a775dd600", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复与检查点重叠的 TRUNCATE 命令之后崩溃恢复中可能出现的问题", "evidence": {"same_day": true, "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b"}, "url": "/docs/compare/?release=14.3#14.3-84d93ac7003937a6", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "6828b4b16c705355b907fdd960ed2bf3", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复与检查点重叠的 TRUNCATE 命令之后崩溃恢复中可能出现的问题", "evidence": {"same_day": true, "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b"}, "url": "/docs/compare/?release=13.7#13.7-7d023ebe4999c3f3", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "85baf415d072880c35de92cf6a4c9275", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复与检查点重叠的 TRUNCATE 命令之后崩溃恢复中可能出现的问题", "evidence": {"same_day": true, "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b"}, "url": "/docs/compare/?release=12.11#12.11-f0a66f75f1134727", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "00aede7f60516464bd0e281bb684e25d", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复与检查点重叠的 TRUNCATE 命令之后崩溃恢复中可能出现的问题", "evidence": {"same_day": true, "patch_ids": ["72a805773d6fe91e21c26ed7a937344e", "ec79c5affdaa35cd40768a8a31343e9e"], "statement_hash": "4fb673c0344e5759880af5596c8bd841a554900c63fc6306a6bc92c4c3859e6b"}, "url": "/docs/compare/?release=11.16#11.16-f7cf2cc6ed176c44", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-601d0017587bdac9", "cves": [], "html": "

修复临时对象清理期间不安全的 toast 数据访问（Andres Freund）

\n

服务器进程退出期间的临时对象删除可能会失败并显示 “FATAL: cannot fetch toast data without an active snapshot”。这通常是无害的，因为下次使用该临时模式时会成功清理。

", "text": "修复临时对象清理期间不安全的 toast 数据访问（Andres Freund） 服务器进程退出期间的临时对象删除可能会失败并显示 “FATAL: cannot fetch toast data without an active snapshot”。这通常是无害的，因为下次使用该临时模式时会成功清理。", "title": "修复临时对象清理期间不安全的 toast 数据访问", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "232a07b3b4a21d079e539991519fd0ac0767338fe8756873eb40a6d45118e0fc", "section_path": ["变更"], "commit_groups": [["0033fc63f", "3faa21bb7", "7bbfe5994", "7c38ef2a5", "c2551483e", "cebc54b90"]], "identity_text": "Fix unsafe toast-data accesses during temporary object cleanup (Andres Freund) Temporary-object deletion during server process exit could fail with FATAL: cannot fetch toast data without an active snapshot. This was usually harmless since the next use of that temporary schema would clean up successfully.", "commit_aliases": ["0033fc63f", "3faa21bb7", "7bbfe5994", "7c38ef2a5", "c2551483e", "cebc54b90"], "source_commits": ["cebc54b90"], "source_entry_id": "10.21/changes/012", "db_id": "8a604d943f999d3621ddd702ae5361bd", "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f", "relations": [{"rule": 2, "type": "equivalent", "target": "032efc6442217e5375f6d528eb22bb61", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}}, {"rule": 2, "type": "equivalent", "target": "1de9775a50fcc38cb20f848f22f0c990", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}}, {"rule": 2, "type": "equivalent", "target": "7fe45e5fb801a18a0572d9b1f633fcfe", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}}, {"rule": 2, "type": "equivalent", "target": "e09ae6f09ca06e58a50e74ead9e74406", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "1de9775a50fcc38cb20f848f22f0c990", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复临时对象清理期间不安全的 toast 数据访问", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}, "url": "/docs/compare/?release=14.3#14.3-180c178af2d9ff42", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "7fe45e5fb801a18a0572d9b1f633fcfe", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复临时对象清理期间不安全的 toast 数据访问", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}, "url": "/docs/compare/?release=13.7#13.7-de75fc488eada203", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "e09ae6f09ca06e58a50e74ead9e74406", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复临时对象清理期间不安全的 toast 数据访问", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}, "url": "/docs/compare/?release=12.11#12.11-5241c5c0dfa9c25e", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "032efc6442217e5375f6d528eb22bb61", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复临时对象清理期间不安全的 toast 数据访问", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}, "url": "/docs/compare/?release=11.16#11.16-601d0017587bdac9", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-f3ac08d06f4d3f00", "cves": [], "html": "

修复当存在缺失的 WAL 续接记录时，备库提升期间出现的 “PANIC: xlog flush request is not satisfied” 失败（Sami Imseih）

", "text": "修复当存在缺失的 WAL 续接记录时，备库提升期间出现的 “PANIC: xlog flush request is not satisfied” 失败（Sami Imseih）", "title": "修复当存在缺失的 WAL 续接记录时，备库提升期间出现的 “PANIC: xlog flush request is not satisfied” 失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "a1be4796461eed2e1836e9955daab5eb72e8a2b60805d7e2f48a375c0c999f0f", "section_path": ["变更"], "commit_groups": [["199cd7b59", "98eb3e06c", "9ade3c09a", "9d92582ab", "c714ebd0e", "caaeb88ff"]], "identity_text": "Fix PANIC: xlog flush request is not satisfied failure during standby promotion when there is a missing WAL continuation record (Sami Imseih)", "commit_aliases": ["199cd7b59", "98eb3e06c", "9ade3c09a", "9d92582ab", "c714ebd0e", "caaeb88ff"], "source_commits": ["9ade3c09a"], "source_entry_id": "10.21/changes/013", "db_id": "e912bf1a48b6907073e2fd8968bbc3a9", "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553", "relations": [{"rule": 2, "type": "equivalent", "target": "4616f6f989728145ab6c6ddc011d81bd", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}}, {"rule": 2, "type": "equivalent", "target": "584a81401b973825070db064f4c5ffed", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}}, {"rule": 2, "type": "equivalent", "target": "bf04d49f808aa1ddd6d6de22354000eb", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}}, {"rule": 2, "type": "equivalent", "target": "efed42fc416ec8b749584b57596f52e1", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "efed42fc416ec8b749584b57596f52e1", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复当存在缺失的 WAL 续接记录时，备库提升期间出现的 “PANIC: xlog flush request is not satisfied” 失败", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}, "url": "/docs/compare/?release=14.3#14.3-67de1df9ca9c590c", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "4616f6f989728145ab6c6ddc011d81bd", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复当存在缺失的 WAL 续接记录时，备库提升期间出现的 “PANIC: xlog flush request is not satisfied” 失败", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}, "url": "/docs/compare/?release=13.7#13.7-f3fabf8f11d45a79", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "584a81401b973825070db064f4c5ffed", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复当存在缺失的 WAL 续接记录时，备库提升期间出现的 “PANIC: xlog flush request is not satisfied” 失败", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}, "url": "/docs/compare/?release=12.11#12.11-a981739bfb0bdb1f", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "bf04d49f808aa1ddd6d6de22354000eb", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复当存在缺失的 WAL 续接记录时，备库提升期间出现的 “PANIC: xlog flush request is not satisfied” 失败", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}, "url": "/docs/compare/?release=11.16#11.16-f3ac08d06f4d3f00", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-4d748db5db165b63", "cves": [], "html": "

修复热备冲突处理中可能出现的自死锁问题（Andres Freund）

\n

在不利的时序条件下，WAL 应用进程可能在等待其他进程释放缓冲区锁时卡住。

", "text": "修复热备冲突处理中可能出现的自死锁问题（Andres Freund） 在不利的时序条件下，WAL 应用进程可能在等待其他进程释放缓冲区锁时卡住。", "title": "修复热备冲突处理中可能出现的自死锁问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "961c052dc8d91c37446693a0b3fd941d3630a688578809beeb02fc41c7ebf541", "section_path": ["变更"], "commit_groups": [["0446d3bf3", "25d5494e2", "a5ede1391", "b1f35a36e", "f74496dd6"], ["2adb8debe", "5ab8e8014", "5c8b14a71", "90abe1e17", "e8a0cf9b2"], ["57c5ad168", "8f1537d10", "9ab3b2bdb", "9cda785b4", "cbc47ad7e", "edfc03ec9"]], "identity_text": "Fix possibility of self-deadlock in hot standby conflict handling (Andres Freund) With unlucky timing, the WAL-applying process could get stuck while waiting for some other process to release a buffer lock.", "commit_aliases": ["0446d3bf3", "25d5494e2", "2adb8debe", "57c5ad168", "5ab8e8014", "5c8b14a71", "8f1537d10", "90abe1e17", "9ab3b2bdb", "9cda785b4", "a5ede1391", "b1f35a36e", "cbc47ad7e", "e8a0cf9b2", "edfc03ec9", "f74496dd6"], "source_commits": ["b1f35a36e", "cbc47ad7e", "e8a0cf9b2"], "source_entry_id": "10.21/changes/014", "db_id": "7c662f5bf745a4d32c2bd4d67e7dcddd", "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225", "relations": [{"rule": 2, "type": "equivalent", "target": "8326850f199485395083b431edd51d72", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}}, {"rule": 2, "type": "equivalent", "target": "9917635a38b20d66db9f32a624027fdc", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}}, {"rule": 2, "type": "equivalent", "target": "bfe754562d7efef753ac505f1ce64640", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}}, {"rule": 2, "type": "equivalent", "target": "cbd21a3d7d5f7b9494e7b9ea5f925594", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "9917635a38b20d66db9f32a624027fdc", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复热备冲突处理中可能出现的自死锁问题", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}, "url": "/docs/compare/?release=14.3#14.3-e3d892048c4eb17c", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "cbd21a3d7d5f7b9494e7b9ea5f925594", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复热备冲突处理中可能出现的自死锁问题", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}, "url": "/docs/compare/?release=13.7#13.7-68e9a1cfd8eb8d19", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "8326850f199485395083b431edd51d72", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复热备冲突处理中可能出现的自死锁问题", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}, "url": "/docs/compare/?release=12.11#12.11-d5cf271c00b45f44", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "bfe754562d7efef753ac505f1ce64640", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复热备冲突处理中可能出现的自死锁问题", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}, "url": "/docs/compare/?release=11.16#11.16-4d748db5db165b63", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-08576c864b54941e", "cves": [], "html": "

确保逻辑复制应用工作进程即使在达到 max_sync_workers_per_subscription 限制时也能重启（Amit Kapila）

\n

限制检查的错误编码导致重启的工作进程立即退出，使得工作进程数量少于应有的数量。

", "text": "确保逻辑复制应用工作进程即使在达到 max_sync_workers_per_subscription 限制时也能重启（Amit Kapila） 限制检查的错误编码导致重启的工作进程立即退出，使得工作进程数量少于应有的数量。", "title": "确保逻辑复制应用工作进程即使在达到 max_sync_workers_per_subscription 限制时也能重启", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "2e2c6914ef16128e00d9342839dad9655c4318b87b889a08f73c9b08151fffb9", "section_path": ["变更"], "commit_groups": [["59348fbde", "82d4a17a1", "a90de822e", "be46985be", "c9dea58e2", "dd4ab6fd6"]], "identity_text": "Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit (Amit Kapila) Faulty coding of the limit check caused a restarted worker to exit immediately, leaving fewer workers than there should be.", "commit_aliases": ["59348fbde", "82d4a17a1", "a90de822e", "be46985be", "c9dea58e2", "dd4ab6fd6"], "source_commits": ["be46985be"], "source_entry_id": "10.21/changes/015", "db_id": "6cb0508f0a9e0afafb73a70f702a7705", "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd", "relations": [{"rule": 2, "type": "equivalent", "target": "4d77101a0dcfa5ea847fb5373636fcc1", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}}, {"rule": 2, "type": "equivalent", "target": "65dc9f700963dfd29d410cfed4b78859", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}}, {"rule": 2, "type": "equivalent", "target": "c8faa35f51a3c0ace4a4fc31fc4be4fa", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}}, {"rule": 2, "type": "equivalent", "target": "d4225ea6fb86c887ba568cca78d6125a", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "d4225ea6fb86c887ba568cca78d6125a", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "确保逻辑复制应用工作进程即使在达到 max_sync_workers_per_subscription 限制时也能重启", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}, "url": "/docs/compare/?release=14.3#14.3-93ffe1cf73218ab0", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "65dc9f700963dfd29d410cfed4b78859", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "确保逻辑复制应用工作进程即使在达到 max_sync_workers_per_subscription 限制时也能重启", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}, "url": "/docs/compare/?release=13.7#13.7-076443b51e6de81b", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "4d77101a0dcfa5ea847fb5373636fcc1", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "确保逻辑复制应用工作进程即使在达到 max_sync_workers_per_subscription 限制时也能重启", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}, "url": "/docs/compare/?release=12.11#12.11-6dc41deb32f0c4ba", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "c8faa35f51a3c0ace4a4fc31fc4be4fa", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "确保逻辑复制应用工作进程即使在达到 max_sync_workers_per_subscription 限制时也能重启", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}, "url": "/docs/compare/?release=11.16#11.16-08576c864b54941e", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-c214b6a229b96154", "cves": [], "html": "

在更新的 WAL 日志中包含未更改的副本标识键列（如果它们以行外方式存储）（Dilip Kumar，Amit Kapila）

\n

否则订阅者无法看到这些值，并且将无法复制该更新。

", "text": "在更新的 WAL 日志中包含未更改的副本标识键列（如果它们以行外方式存储）（Dilip Kumar，Amit Kapila） 否则订阅者无法看到这些值，并且将无法复制该更新。", "title": "在更新的 WAL 日志中包含未更改的副本标识键列（如果它们以行外方式存储）", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "12485a04a0aab01e79b79b45ccf421690a990e3611c9bcedb8b45b77ff8bfbdf", "section_path": ["变更"], "commit_groups": [["04645bbca", "1cd5802ac", "5e01001ff", "b5e060473", "caa231be9", "ce349cf17"]], "identity_text": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line (Dilip Kumar, Amit Kapila) Otherwise subscribers cannot see the values and will fail to replicate the update.", "commit_aliases": ["04645bbca", "1cd5802ac", "5e01001ff", "b5e060473", "caa231be9", "ce349cf17"], "source_commits": ["b5e060473"], "source_entry_id": "10.21/changes/016", "db_id": "e91345693e41d6a01bb1111c14f73dcb", "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e", "relations": [{"rule": 2, "type": "equivalent", "target": "07858b021e0e853308156789e418cd2a", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}}, {"rule": 2, "type": "equivalent", "target": "9a94d67ddddbd742c503f9c8324b18e4", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}}, {"rule": 2, "type": "equivalent", "target": "bf5d4be3e90daa1d7d78f997c974599d", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}}, {"rule": 2, "type": "equivalent", "target": "d788e8137114d6bd76da60ed58066080", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "d788e8137114d6bd76da60ed58066080", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "在更新的 WAL 日志中包含未更改的副本标识键列（如果它们以行外方式存储）", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}, "url": "/docs/compare/?release=14.3#14.3-1969eb606850e557", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "9a94d67ddddbd742c503f9c8324b18e4", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "在更新的 WAL 日志中包含未更改的副本标识键列（如果它们以行外方式存储）", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}, "url": "/docs/compare/?release=13.7#13.7-74763003b2707c52", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "bf5d4be3e90daa1d7d78f997c974599d", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "在更新的 WAL 日志中包含未更改的副本标识键列（如果它们以行外方式存储）", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}, "url": "/docs/compare/?release=12.11#12.11-8cdc19f514753e90", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "07858b021e0e853308156789e418cd2a", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "在更新的 WAL 日志中包含未更改的副本标识键列（如果它们以行外方式存储）", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}, "url": "/docs/compare/?release=11.16#11.16-c214b6a229b96154", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-59e2654695700596", "cves": [], "html": "

改进逻辑复制订阅者针对不支持的关系种类所给出的错误消息（Tom Lane）

\n

v13 及更新版本的服务器支持发布分区表。更早的服务器版本无法订阅这类表，却给出极具误导性的错误消息：“table XYZ not found on publisher”。现在改为给出更切合问题的消息。

", "text": "改进逻辑复制订阅者针对不支持的关系种类所给出的错误消息（Tom Lane） v13 及更新版本的服务器支持发布分区表。更早的服务器版本无法订阅这类表，却给出极具误导性的错误消息：“table XYZ not found on publisher”。现在改为给出更切合问题的消息。", "title": "改进逻辑复制订阅者针对不支持的关系种类所给出的错误消息", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "ff396e825707f00203d204d748f3c299ce33d1eaa650daefd019b159193677b6", "section_path": ["变更"], "commit_groups": [["17a8c4c3a", "e16db75dd", "efae4401c"]], "identity_text": "Improve logical replication subscriber's error message for an unsupported relation kind (Tom Lane) v13 and later servers support publishing partitioned tables. Older server versions cannot handle subscribing to such a table, and they gave a very misleading error message: table XYZ not found on publisher. Arrange to deliver a more on-point message.", "commit_aliases": ["17a8c4c3a", "e16db75dd", "efae4401c"], "source_commits": ["17a8c4c3a"], "source_entry_id": "10.21/changes/017", "db_id": "e52a5f800d816e2be2ad3cf2997450a6", "patch_ids": ["023b80e98c37293cad69de6381443819"], "statement_hash": "3cf31a83b1affe8f2ef85e580784f32caca4d1c3029b1e88e0fff8475f690d8b", "relations": [{"rule": 2, "type": "equivalent", "target": "b738022dce8f2f228f78b4094161de46", "evidence": {"same_day": true, "patch_ids": ["023b80e98c37293cad69de6381443819"], "statement_hash": "3cf31a83b1affe8f2ef85e580784f32caca4d1c3029b1e88e0fff8475f690d8b"}}, {"rule": 2, "type": "equivalent", "target": "bc654e2301ce954d6752b052c62e7404", "evidence": {"same_day": true, "patch_ids": ["023b80e98c37293cad69de6381443819"], "statement_hash": "3cf31a83b1affe8f2ef85e580784f32caca4d1c3029b1e88e0fff8475f690d8b"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b738022dce8f2f228f78b4094161de46", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "改进逻辑复制订阅者针对不支持的关系种类所给出的错误消息", "evidence": {"same_day": true, "patch_ids": ["023b80e98c37293cad69de6381443819"], "statement_hash": "3cf31a83b1affe8f2ef85e580784f32caca4d1c3029b1e88e0fff8475f690d8b"}, "url": "/docs/compare/?release=12.11#12.11-79ba44c4f79856b8", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "bc654e2301ce954d6752b052c62e7404", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "改进逻辑复制订阅者针对不支持的关系种类所给出的错误消息", "evidence": {"same_day": true, "patch_ids": ["023b80e98c37293cad69de6381443819"], "statement_hash": "3cf31a83b1affe8f2ef85e580784f32caca4d1c3029b1e88e0fff8475f690d8b"}, "url": "/docs/compare/?release=11.16#11.16-59e2654695700596", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-20cc24a6196e88f8", "cves": [], "html": "

禁止在 PL/Perl 函数编译期间执行 SPI 函数（Tom Lane）

\n

可以让 Perl 在 PL/Perl 函数编译期间执行用户定义的代码。但是，这类代码不应该尝试通过 SPI 调用 SQL 操作。那样做会导致崩溃，即使不崩溃也是一个安全隐患，因为我们确实不希望在函数验证期间执行代码。增加了一个检查以给出更友好的错误消息。

", "text": "禁止在 PL/Perl 函数编译期间执行 SPI 函数（Tom Lane） 可以让 Perl 在 PL/Perl 函数编译期间执行用户定义的代码。但是，这类代码不应该尝试通过 SPI 调用 SQL 操作。那样做会导致崩溃，即使不崩溃也是一个安全隐患，因为我们确实不希望在函数验证期间执行代码。增加了一个检查以给出更友好的错误消息。", "title": "禁止在 PL/Perl 函数编译期间执行 SPI 函数", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "614d089b90e96b1174d3c59ddda25a30d57552d0b4ce5d3da73b5933bb97b417", "section_path": ["变更"], "commit_groups": [["0f7b62f29", "31befa6be", "4936747c4", "638300fef", "9b2d762a2", "ac910bb23"]], "identity_text": "Disallow execution of SPI functions during PL/Perl function compilation (Tom Lane) Perl can be convinced to execute user-defined code during compilation of a PL/Perl function. However, it's not okay for such code to try to invoke SQL operations via SPI. That results in a crash, and if it didn't crash it would be a security hazard, because we really don't want code execution during function validation. Put in a check to give a friendlier error message instead.", "commit_aliases": ["0f7b62f29", "31befa6be", "4936747c4", "638300fef", "9b2d762a2", "ac910bb23"], "source_commits": ["4936747c4"], "source_entry_id": "10.21/changes/018", "db_id": "708c5ef046b16665e0cf6c92805f5d03", "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38", "relations": [{"rule": 2, "type": "equivalent", "target": "1a769f4c529fcb545534198ce41903c3", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}}, {"rule": 2, "type": "equivalent", "target": "66a04bbfc201325edeb1e8fe449982c6", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}}, {"rule": 2, "type": "equivalent", "target": "81e7823dbdbf09d737aff84f180d06e4", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}}, {"rule": 2, "type": "equivalent", "target": "9a37b80a76e4afc35be9feda8bc2f008", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "81e7823dbdbf09d737aff84f180d06e4", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "禁止在 PL/Perl 函数编译期间执行 SPI 函数", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}, "url": "/docs/compare/?release=14.3#14.3-d861627a634d055a", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "1a769f4c529fcb545534198ce41903c3", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "禁止在 PL/Perl 函数编译期间执行 SPI 函数", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}, "url": "/docs/compare/?release=13.7#13.7-0088434181bc2fc0", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "9a37b80a76e4afc35be9feda8bc2f008", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "禁止在 PL/Perl 函数编译期间执行 SPI 函数", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}, "url": "/docs/compare/?release=12.11#12.11-819ab4d7947c42d8", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "66a04bbfc201325edeb1e8fe449982c6", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "禁止在 PL/Perl 函数编译期间执行 SPI 函数", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}, "url": "/docs/compare/?release=11.16#11.16-20cc24a6196e88f8", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-bfde73d549cb6897", "cves": [], "html": "

使 libpq 接受 root 拥有的 SSL 私钥文件（David Steele）

\n

此变更使 libpq 对 SSL 密钥文件的安全所有权和权限规则与服务器自 9.6 版本以来使用的规则同步。即，在当前规则的基础上，还允许密钥文件由 root 拥有且权限为 rw-r----- 或更严格的情况。这对于密钥文件的系统级管理很有帮助。

", "text": "使 libpq 接受 root 拥有的 SSL 私钥文件（David Steele） 此变更使 libpq 对 SSL 密钥文件的安全所有权和权限规则与服务器自 9.6 版本以来使用的规则同步。即，在当前规则的基础上，还允许密钥文件由 root 拥有且权限为 rw-r----- 或更严格的情况。这对于密钥文件的系统级管理很有帮助。", "title": "使 libpq 接受 root 拥有的 SSL 私钥文件", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "cd6dc8b0efdc0b311912883089154ee1dfca88f309095aa39e78ab8113b0cd3f", "section_path": ["变更"], "commit_groups": [["143043191", "402279afe", "878e64d0f", "a6bd1f0ee", "fb1d7f451", "fcaf7d725"], ["2a1f84636", "5bb3d91ea", "6599d8f12", "72918ea86", "9050999ef"], ["50f03473e"], ["a59c79564"]], "identity_text": "Make libpq accept root-owned SSL private key files (David Steele) This change synchronizes libpq's rules for safe ownership and permissions of SSL key files with the rules the server has used since release 9.6. Namely, in addition to the current rules, allow the case where the key file is owned by root and has permissions rw-r----- or less. This is helpful for system-wide management of key files.", "commit_aliases": ["143043191", "2a1f84636", "402279afe", "50f03473e", "5bb3d91ea", "6599d8f12", "72918ea86", "878e64d0f", "9050999ef", "a59c79564", "a6bd1f0ee", "fb1d7f451", "fcaf7d725"], "source_commits": ["50f03473e", "9050999ef", "a59c79564", "a6bd1f0ee"], "source_entry_id": "10.21/changes/019", "db_id": "d59b8f6bb4b86a6add76e3338d32c559", "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa", "relations": [{"rule": 2, "type": "equivalent", "target": "40efbc1afccb6d2965c0a4782377380a", "evidence": {"same_day": true, "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa"}}, {"rule": 2, "type": "equivalent", "target": "5b3dfc4baa8d9d9a88e4eeb631f14a6c", "evidence": {"same_day": true, "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa"}}, {"rule": 2, "type": "equivalent", "target": "8f893be62e4b71ecdda4e240472971d4", "evidence": {"same_day": true, "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa"}}, {"rule": 2, "type": "equivalent", "target": "e027c8413edea6b94c95551d13a261d2", "evidence": {"same_day": true, "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e027c8413edea6b94c95551d13a261d2", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "使 libpq 接受 root 拥有的 SSL 私钥文件", "evidence": {"same_day": true, "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa"}, "url": "/docs/compare/?release=14.3#14.3-4bc7b47733ef0ca8", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "5b3dfc4baa8d9d9a88e4eeb631f14a6c", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "使 libpq 接受 root 拥有的 SSL 私钥文件", "evidence": {"same_day": true, "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa"}, "url": "/docs/compare/?release=13.7#13.7-297b099bb3862120", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "40efbc1afccb6d2965c0a4782377380a", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "使 libpq 接受 root 拥有的 SSL 私钥文件", "evidence": {"same_day": true, "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa"}, "url": "/docs/compare/?release=12.11#12.11-dca1831c91e956a7", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "8f893be62e4b71ecdda4e240472971d4", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "使 libpq 接受 root 拥有的 SSL 私钥文件", "evidence": {"same_day": true, "patch_ids": ["5d05ee0842f79cbe3cfb9448688fb812", "68d311af4ee0c128c2582385b06ad7b9", "7a858a06ccfd41824b5d7ec039bb3595", "dc4641b31b9656a9152c8355c58af8df"], "statement_hash": "b507cd40632afc389ac978ecb04756fbab6daceddacee509046469d44d7ca7aa"}, "url": "/docs/compare/?release=11.16#11.16-bfde73d549cb6897", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-b0b2521e22265bc1", "cves": [], "html": "

使 pg_ctl 在等待停止/重启/提升操作时重新检查 postmaster 是否仍然存活（Tom Lane）

\n

pg_ctl 会在发送停止或提升信号时作为副作用验证 postmaster 是否存活，但之后它只是简单地等待磁盘上的状态变化。如果 postmaster 非正常终止且未删除其 PID 文件或更新控制文件， pg_ctl 将一直等到超时。现在改为每隔一段时间重新检查 postmaster 进程是否仍然存在。

", "text": "使 pg_ctl 在等待停止/重启/提升操作时重新检查 postmaster 是否仍然存活（Tom Lane） pg_ctl 会在发送停止或提升信号时作为副作用验证 postmaster 是否存活，但之后它只是简单地等待磁盘上的状态变化。如果 postmaster 非正常终止且未删除其 PID 文件或更新控制文件， pg_ctl 将一直等到超时。现在改为每隔一段时间重新检查 postmaster 进程是否仍然存在。", "title": "使 pg_ctl 在等待停止/重启/提升操作时重新检查 postmaster 是否仍然存活", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "347060c1a43aa846931e3cddfd2a48ed2b9ead82a4965efd2c489d22be7de768", "section_path": ["变更"], "commit_groups": [["1e8c5cf7c", "34523933b", "61c20a5ea", "69cc15c31", "a745b9365", "d0e1fd958"]], "identity_text": "Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions (Tom Lane) pg_ctl would verify that the postmaster is alive as a side-effect of sending the stop or promote signal, but then it just naively waited to see the on-disk state change. If the postmaster died uncleanly without having removed its PID file or updated the control file, pg_ctl would wait until timeout. Instead make it recheck every so often that the postmaster process is still there.", "commit_aliases": ["1e8c5cf7c", "34523933b", "61c20a5ea", "69cc15c31", "a745b9365", "d0e1fd958"], "source_commits": ["34523933b"], "source_entry_id": "10.21/changes/020", "db_id": "34e228fe7feaf05f81e9c42f38121b9d", "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da", "relations": [{"rule": 2, "type": "equivalent", "target": "4dfa47cd00fd62c8e09003015eead70b", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}}, {"rule": 2, "type": "equivalent", "target": "90cf21300bd071aadc57d55aebd19b4c", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}}, {"rule": 2, "type": "equivalent", "target": "9bc45a590ac3fb2d68c48c532cc62b14", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}}, {"rule": 2, "type": "equivalent", "target": "c7a94a5f0922f7af615dda1c9d643669", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "c7a94a5f0922f7af615dda1c9d643669", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "使 pg_ctl 在等待停止/重启/提升操作时重新检查 postmaster 是否仍然存活", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}, "url": "/docs/compare/?release=14.3#14.3-d026366bb6adde15", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "4dfa47cd00fd62c8e09003015eead70b", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "使 pg_ctl 在等待停止/重启/提升操作时重新检查 postmaster 是否仍然存活", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}, "url": "/docs/compare/?release=13.7#13.7-c4dcfd3502a7107a", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "9bc45a590ac3fb2d68c48c532cc62b14", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "使 pg_ctl 在等待停止/重启/提升操作时重新检查 postmaster 是否仍然存活", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}, "url": "/docs/compare/?release=12.11#12.11-57b7c908c94fa0ec", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "90cf21300bd071aadc57d55aebd19b4c", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "使 pg_ctl 在等待停止/重启/提升操作时重新检查 postmaster 是否仍然存活", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}, "url": "/docs/compare/?release=11.16#11.16-b0b2521e22265bc1", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-0aee1aa24169d35b", "cves": [], "html": "

确保 contrib/pageinspect 函数能够处理全零页面（Michael Paquier）

\n

这是一个合理的边界情况，但该模块大多未做准备。安排返回 null 或不返回行，视情况而定；这比抛出错误更有用。

", "text": "确保 contrib/pageinspect 函数能够处理全零页面（Michael Paquier） 这是一个合理的边界情况，但该模块大多未做准备。安排返回 null 或不返回行，视情况而定；这比抛出错误更有用。", "title": "确保 contrib/pageinspect 函数能够处理全零页面", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "3c71af0afb3c78575ff18a244d86eff488b3cd659294f1600341c9c1f0014e2d", "section_path": ["变更"], "commit_groups": [["12d32b7bc", "2275d044d", "5378d55cb", "79fed072b", "cd4868a57", "df6bbe73b"]], "identity_text": "Ensure that contrib/pageinspect functions cope with all-zero pages (Michael Paquier) This is a legitimate edge case, but the module was mostly unprepared for it. Arrange to return nulls, or no rows, as appropriate; that seems more useful than raising an error.", "commit_aliases": ["12d32b7bc", "2275d044d", "5378d55cb", "79fed072b", "cd4868a57", "df6bbe73b"], "source_commits": ["12d32b7bc"], "source_entry_id": "10.21/changes/021", "db_id": "e551302d98b39d821362609674fcc686", "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14", "relations": [{"rule": 2, "type": "equivalent", "target": "6191ffd8e15d53d8989da3a4601b97f4", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}}, {"rule": 2, "type": "equivalent", "target": "ac629facc0ab6d2ce561818a9622e876", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}}, {"rule": 2, "type": "equivalent", "target": "bfe0b6dd19d5cc9a5935136923c14453", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}}, {"rule": 2, "type": "equivalent", "target": "fa0abcafe43664b59c9c2d2232e9842f", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "6191ffd8e15d53d8989da3a4601b97f4", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "确保 contrib/pageinspect 函数能够处理全零页面", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}, "url": "/docs/compare/?release=14.3#14.3-73e8847f0bbbd8ec", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "bfe0b6dd19d5cc9a5935136923c14453", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "确保 contrib/pageinspect 函数能够处理全零页面", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}, "url": "/docs/compare/?release=13.7#13.7-6a5b3a08c8e30123", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "ac629facc0ab6d2ce561818a9622e876", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "确保 contrib/pageinspect 函数能够处理全零页面", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}, "url": "/docs/compare/?release=12.11#12.11-7ceeb7a6a550aad4", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "fa0abcafe43664b59c9c2d2232e9842f", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "确保 contrib/pageinspect 函数能够处理全零页面", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}, "url": "/docs/compare/?release=11.16#11.16-0aee1aa24169d35b", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-d95c03b3654d08f6", "cves": [], "html": "

在 contrib/pageinspect 中，增加对不正确页面“特殊空间”内容的防御，收紧对正确页面大小的检查，并增加一些缺失的索引类型正确性检查（Michael Paquier，Justin Pryzby，Julien Rouhaud）

\n

这些变更减少了该模块在处理错误数据时崩溃的可能性。

", "text": "在 contrib/pageinspect 中，增加对不正确页面“特殊空间”内容的防御，收紧对正确页面大小的检查，并增加一些缺失的索引类型正确性检查（Michael Paquier，Justin Pryzby，Julien Rouhaud） 这些变更减少了该模块在处理错误数据时崩溃的可能性。", "title": "在 contrib/pageinspect 中，增加对不正确页面“特殊空间”内容的防御，收紧对正确页面大小的检查，并增加一些缺失的索引类型正确性检查", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "4f9d12d928b7966f4e999f5821757ffa76818b3809cb1ef058de7bf4635e062a", "section_path": ["变更"], "commit_groups": [["028a3c6b1", "07e343513", "09c97746d", "4477dcb20", "5cb770210", "dc5b3bdae"], ["076f4d953", "2389ee8dd", "af8a8eb54", "b61e6214c", "c42b88932", "d3a9b83c3"], ["1a2fdf86a", "27d384441", "291e517a4", "3d4d6dee0", "5ca2aa2f2", "ab80b0fbb"]], "identity_text": "In contrib/pageinspect, add defenses against incorrect page special space contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type (Michael Paquier, Justin Pryzby, Julien Rouhaud) These changes make it less likely that the module will crash on bad data.", "commit_aliases": ["028a3c6b1", "076f4d953", "07e343513", "09c97746d", "1a2fdf86a", "2389ee8dd", "27d384441", "291e517a4", "3d4d6dee0", "4477dcb20", "5ca2aa2f2", "5cb770210", "ab80b0fbb", "af8a8eb54", "b61e6214c", "c42b88932", "d3a9b83c3", "dc5b3bdae"], "source_commits": ["07e343513", "ab80b0fbb", "c42b88932"], "source_entry_id": "10.21/changes/022", "db_id": "b78c4305db7549066a102a9ff77dc776", "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1", "relations": [{"rule": 2, "type": "equivalent", "target": "060ab6b486e576912a33b8a5be3d7986", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}}, {"rule": 2, "type": "equivalent", "target": "098e6bf95bd71cfb98640d7744439858", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}}, {"rule": 2, "type": "equivalent", "target": "dde9027e9aa0573fa1221a6edbd691cb", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}}, {"rule": 2, "type": "equivalent", "target": "f3ec0de8907ed8bd48aa2e24d2ff9051", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "060ab6b486e576912a33b8a5be3d7986", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "在 contrib/pageinspect 中，增加对不正确页面“特殊空间”内容的防御，收紧对正确页面大小的检查，并增加一些缺失的索引类型正确性检查", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}, "url": "/docs/compare/?release=14.3#14.3-3c9236b5f498c8a3", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "f3ec0de8907ed8bd48aa2e24d2ff9051", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "在 contrib/pageinspect 中，增加对不正确页面“特殊空间”内容的防御，收紧对正确页面大小的检查，并增加一些缺失的索引类型正确性检查", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}, "url": "/docs/compare/?release=13.7#13.7-f0da7fa66068ee81", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "dde9027e9aa0573fa1221a6edbd691cb", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "在 contrib/pageinspect 中，增加对不正确页面“特殊空间”内容的防御，收紧对正确页面大小的检查，并增加一些缺失的索引类型正确性检查", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}, "url": "/docs/compare/?release=12.11#12.11-517cbd25e017e26a", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "098e6bf95bd71cfb98640d7744439858", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "在 contrib/pageinspect 中，增加对不正确页面“特殊空间”内容的防御，收紧对正确页面大小的检查，并增加一些缺失的索引类型正确性检查", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}, "url": "/docs/compare/?release=11.16#11.16-d95c03b3654d08f6", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-c0f49ecd4f77bed1", "cves": [], "html": "

在 contrib/postgres_fdw 中，在请求远程排序查询之前验证 ORDER BY 子句是否可以安全传送，并在必要时包含 USING 子句（Ronan Dunklau）

\n

此修复防止了远程服务器可能按与我们意图不同的顺序排序的情况。虽然有时这只是表面问题，但如果远程数据被用作本地执行的合并连接的输入，则可能产生完全错误的结果。

", "text": "在 contrib/postgres_fdw 中，在请求远程排序查询之前验证 ORDER BY 子句是否可以安全传送，并在必要时包含 USING 子句（Ronan Dunklau） 此修复防止了远程服务器可能按与我们意图不同的顺序排序的情况。虽然有时这只是表面问题，但如果远程数据被用作本地执行的合并连接的输入，则可能产生完全错误的结果。", "title": "在 contrib/postgres_fdw 中，在请求远程排序查询之前验证 ORDER BY 子句是否可以安全传送，并在必要时包含 USING 子句", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "d2be6feb02a1aa45e7ead6752fd744d7758df99cf0294ac2dd3f3cf8c5a9f533", "section_path": ["变更"], "commit_groups": [["728fc0f9a", "79df1d20c", "989d3e4a2", "9f9489aa2", "b9eb0412f", "f3dd9fe1d"]], "identity_text": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary (Ronan Dunklau) This fix prevents situations where the remote server might sort in a different order than we intend. While sometimes that would be only cosmetic, it could produce thoroughly wrong results if the remote data is used as input for a locally-performed merge join.", "commit_aliases": ["728fc0f9a", "79df1d20c", "989d3e4a2", "9f9489aa2", "b9eb0412f", "f3dd9fe1d"], "source_commits": ["728fc0f9a"], "source_entry_id": "10.21/changes/023", "db_id": "eaca980b6aa1c3fc4733353accc0ad86", "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f", "relations": [{"rule": 2, "type": "equivalent", "target": "0a310b1d6edafdd573a1fa8c9864b4fc", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}}, {"rule": 2, "type": "equivalent", "target": "3a5681320ca0fff47d6360af1bffaa6b", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}}, {"rule": 2, "type": "equivalent", "target": "4d12d497d451885c60889308c95c0823", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}}, {"rule": 2, "type": "equivalent", "target": "b840abba475c1568c0a88b3a8610386f", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "0a310b1d6edafdd573a1fa8c9864b4fc", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "在 contrib/postgres_fdw 中，在请求远程排序查询之前验证 ORDER BY 子句是否可以安全传送，并在必要时包含 USING 子句", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}, "url": "/docs/compare/?release=14.3#14.3-b9c8663e58947d88", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "4d12d497d451885c60889308c95c0823", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "在 contrib/postgres_fdw 中，在请求远程排序查询之前验证 ORDER BY 子句是否可以安全传送，并在必要时包含 USING 子句", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}, "url": "/docs/compare/?release=13.7#13.7-37691f3afe89cc39", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "b840abba475c1568c0a88b3a8610386f", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "在 contrib/postgres_fdw 中，在请求远程排序查询之前验证 ORDER BY 子句是否可以安全传送，并在必要时包含 USING 子句", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}, "url": "/docs/compare/?release=12.11#12.11-cca701d7ed235a61", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "3a5681320ca0fff47d6360af1bffaa6b", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "在 contrib/postgres_fdw 中，在请求远程排序查询之前验证 ORDER BY 子句是否可以安全传送，并在必要时包含 USING 子句", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}, "url": "/docs/compare/?release=11.16#11.16-c0f49ecd4f77bed1", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-4d9c19b5fc311dd7", "cves": [], "html": "

清理在 clang 的 -fsanitize=undefined 检查下出现的各种失败（Tom Lane，Andres Freund，Zhihong Yu）

\n

这些变更大多只是为了形式上符合 C 和 POSIX 标准的字面要求，不太可能对生产构建产生任何影响。

", "text": "清理在 clang 的 -fsanitize=undefined 检查下出现的各种失败（Tom Lane，Andres Freund，Zhihong Yu） 这些变更大多只是为了形式上符合 C 和 POSIX 标准的字面要求，不太可能对生产构建产生任何影响。", "title": "清理在 clang 的 -fsanitize=undefined 检查下出现的各种失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "2a0c008202219e7c52c16c16a45c466017effe9a40c61f2ac87504151c032db3", "section_path": ["变更"], "commit_groups": [["0fbdfaf79", "18c04d157", "4b0696b36", "566e1c04d", "5c9d17e94", "97031f440"], ["1a027e6b7", "46ab07ffd", "b0bc196e5", "cfbe87bd6", "f2087e26e", "f727b6ea8"], ["1c6bb380e", "2121d5809", "5f4615b9d", "8014c61eb", "89a94c24a", "c5b60a68c"], ["2a9193726", "6a767bc2e", "7c163aa93", "a77dddb42", "e52e9bd57", "e71c76fca"], ["3ac7d0241", "61a007fee", "81045e1e1", "c0f99bb52"]], "identity_text": "Clean up assorted failures under clang's -fsanitize=undefined checks (Tom Lane, Andres Freund, Zhihong Yu) Most of these changes are just for pro-forma compliance with the letter of the C and POSIX standards, and are unlikely to have any effect on production builds.", "commit_aliases": ["0fbdfaf79", "18c04d157", "1a027e6b7", "1c6bb380e", "2121d5809", "2a9193726", "3ac7d0241", "46ab07ffd", "4b0696b36", "566e1c04d", "5c9d17e94", "5f4615b9d", "61a007fee", "6a767bc2e", "7c163aa93", "8014c61eb", "81045e1e1", "89a94c24a", "97031f440", "a77dddb42", "b0bc196e5", "c0f99bb52", "c5b60a68c", "cfbe87bd6", "e52e9bd57", "e71c76fca", "f2087e26e", "f727b6ea8"], "source_commits": ["18c04d157", "2a9193726", "3ac7d0241", "5f4615b9d", "cfbe87bd6"], "source_entry_id": "10.21/changes/024", "db_id": "353fc8fa668aded1c66902f54af68647", "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942", "relations": [{"rule": 2, "type": "equivalent", "target": "1ba55827f92e2c6ea9cfec3ca73ab12e", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}}, {"rule": 2, "type": "equivalent", "target": "a0790335ab7f1b0c63f65ceb5ab63a5c", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}}, {"rule": 2, "type": "equivalent", "target": "d228dc7accd64617730fb4fcbf8aae50", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}}, {"rule": 2, "type": "equivalent", "target": "f6600566bc0907e18a48fb7684eacda6", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1ba55827f92e2c6ea9cfec3ca73ab12e", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "清理在 clang 的 -fsanitize=undefined 检查下出现的各种失败", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}, "url": "/docs/compare/?release=14.3#14.3-cc9c7d2bfe015357", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "f6600566bc0907e18a48fb7684eacda6", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "清理在 clang 的 -fsanitize=undefined 检查下出现的各种失败", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}, "url": "/docs/compare/?release=13.7#13.7-38fb84e955f1b0fe", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "d228dc7accd64617730fb4fcbf8aae50", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "清理在 clang 的 -fsanitize=undefined 检查下出现的各种失败", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}, "url": "/docs/compare/?release=12.11#12.11-195a4e6ea629c9ef", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "a0790335ab7f1b0c63f65ceb5ab63a5c", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "清理在 clang 的 -fsanitize=undefined 检查下出现的各种失败", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}, "url": "/docs/compare/?release=11.16#11.16-4d9c19b5fc311dd7", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-3ce5bdb727e32a3c", "cves": [], "html": "

修复 PL/Perl 使其能在不支持嵌套在表达式中的语句的 C 编译器上构建（Tom Lane）

", "text": "修复 PL/Perl 使其能在不支持嵌套在表达式中的语句的 C 编译器上构建（Tom Lane）", "title": "修复 PL/Perl 使其能在不支持嵌套在表达式中的语句的 C 编译器上构建", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "7fef476c77e9f9da02f0ea8597373dfa7042bbcb9de7e7137d54742a151396a1", "section_path": ["变更"], "commit_groups": [["1a8b6f055", "3a6e3a890", "5ea3b99de", "d5c2a91e5", "e327291e4", "eba0f095c"]], "identity_text": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions (Tom Lane)", "commit_aliases": ["1a8b6f055", "3a6e3a890", "5ea3b99de", "d5c2a91e5", "e327291e4", "eba0f095c"], "source_commits": ["1a8b6f055"], "source_entry_id": "10.21/changes/025", "db_id": "6fafea750d6291d1e58805ed19286913", "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7", "relations": [{"rule": 2, "type": "equivalent", "target": "8526092f304acb2e40c18ccdadfd4900", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}}, {"rule": 2, "type": "equivalent", "target": "95fc5e39fc229c01b37b16cc4d19feb7", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}}, {"rule": 2, "type": "equivalent", "target": "96b56feff8862e295303f535aa5944ac", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}}, {"rule": 2, "type": "equivalent", "target": "dfbd146779579adaf8b4852554ca08d6", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "95fc5e39fc229c01b37b16cc4d19feb7", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复 PL/Perl 使其能在不支持嵌套在表达式中的语句的 C 编译器上构建", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}, "url": "/docs/compare/?release=14.3#14.3-e20812ae73528fc9", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "96b56feff8862e295303f535aa5944ac", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复 PL/Perl 使其能在不支持嵌套在表达式中的语句的 C 编译器上构建", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}, "url": "/docs/compare/?release=13.7#13.7-a40674cdee3d1d18", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "dfbd146779579adaf8b4852554ca08d6", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复 PL/Perl 使其能在不支持嵌套在表达式中的语句的 C 编译器上构建", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}, "url": "/docs/compare/?release=12.11#12.11-f9c55ea5b95087d8", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "8526092f304acb2e40c18ccdadfd4900", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复 PL/Perl 使其能在不支持嵌套在表达式中的语句的 C 编译器上构建", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}, "url": "/docs/compare/?release=11.16#11.16-3ce5bdb727e32a3c", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-f517b6acdae5a3bd", "cves": [], "html": "

修复在 Windows 上不使用 MSVC 构建时 pg_dumpall 可能的构建失败（Andres Freund）

", "text": "修复在 Windows 上不使用 MSVC 构建时 pg_dumpall 可能的构建失败（Andres Freund）", "title": "修复在 Windows 上不使用 MSVC 构建时 pg_dumpall 可能的构建失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "d815a143273ef0323037a78adc32c685d1d70ce8d62dd15d00b72b530f610dc4", "section_path": ["变更"], "commit_groups": [["083031aa9", "097786fbb", "2d608c960", "4553b960f", "cd1951ba0", "f183e23cc"]], "identity_text": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build (Andres Freund)", "commit_aliases": ["083031aa9", "097786fbb", "2d608c960", "4553b960f", "cd1951ba0", "f183e23cc"], "source_commits": ["083031aa9"], "source_entry_id": "10.21/changes/026", "db_id": "7a559b3239971072b49defcf79e20758", "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c", "relations": [{"rule": 2, "type": "equivalent", "target": "136dec1ec7cc4cd6cd615874cc7d068d", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}}, {"rule": 2, "type": "equivalent", "target": "b135168dd83c102cae7007b575a5a268", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}}, {"rule": 2, "type": "equivalent", "target": "dd0986eb3f544ad27adf0fbc2b79d8d0", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}}, {"rule": 2, "type": "equivalent", "target": "ea09b650605ce0e5102cfb939e448aac", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}}], "version": "10.21", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "136dec1ec7cc4cd6cd615874cc7d068d", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "修复在 Windows 上不使用 MSVC 构建时 pg_dumpall 可能的构建失败", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}, "url": "/docs/compare/?release=14.3#14.3-c8ab89c0f28e83c6", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "b135168dd83c102cae7007b575a5a268", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "修复在 Windows 上不使用 MSVC 构建时 pg_dumpall 可能的构建失败", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}, "url": "/docs/compare/?release=13.7#13.7-21e3f1962bbc0d9b", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "dd0986eb3f544ad27adf0fbc2b79d8d0", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "修复在 Windows 上不使用 MSVC 构建时 pg_dumpall 可能的构建失败", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}, "url": "/docs/compare/?release=12.11#12.11-a9beb79d03d2529d", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "ea09b650605ce0e5102cfb939e448aac", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "修复在 Windows 上不使用 MSVC 构建时 pg_dumpall 可能的构建失败", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}, "url": "/docs/compare/?release=11.16#11.16-f517b6acdae5a3bd", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-38a44190a83cd337", "cves": [], "html": "

在 Windows 构建中，使用 gendef 代替 pexports 来构建 DEF 文件（Andrew Dunstan）

\n

这使构建过程适应了最近的 MSys 工具链。

", "text": "在 Windows 构建中，使用 gendef 代替 pexports 来构建 DEF 文件（Andrew Dunstan） 这使构建过程适应了最近的 MSys 工具链。", "title": "在 Windows 构建中，使用 gendef 代替 pexports 来构建 DEF 文件", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "d131788538dc97fe3aba58e38dfb3ef44136d9818a8ed017b46b05142a368e98", "section_path": ["变更"], "commit_groups": [["3a5034b5e", "622ab6a34", "64dd64807", "92f60f536", "a5eef80c2", "c76164ea0", "e2d104e19", "ea09a75e1", "eec7c640f"]], "identity_text": "In Windows builds, use gendef instead of pexports to build DEF files (Andrew Dunstan) This adapts the build process to work on recent MSys tool chains.", "commit_aliases": ["3a5034b5e", "622ab6a34", "64dd64807", "92f60f536", "a5eef80c2", "c76164ea0", "e2d104e19", "ea09a75e1", "eec7c640f"], "source_commits": ["a5eef80c2"], "source_entry_id": "10.21/changes/027", "db_id": "55e5a5f8857f60ac511eb488d2861179", "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481", "relations": [{"rule": 2, "type": "equivalent", "target": "38602682966155948dd26cd8216edbb9", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}}, {"rule": 2, "type": "equivalent", "target": "57262888cf6c5f577a5b3183ebff660b", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}}, {"rule": 2, "type": "equivalent", "target": "cc44da5011e0a29d2b43d6eb82ebb151", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}}, {"rule": 2, "type": "equivalent", "target": "d0633561b5bfb357c77b8a40fd8f5e25", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "57262888cf6c5f577a5b3183ebff660b", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "在 Windows 构建中，使用 gendef 代替 pexports 来构建 DEF 文件", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}, "url": "/docs/compare/?release=14.3#14.3-81a042fc4b04b977", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "d0633561b5bfb357c77b8a40fd8f5e25", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "在 Windows 构建中，使用 gendef 代替 pexports 来构建 DEF 文件", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}, "url": "/docs/compare/?release=13.7#13.7-2427c69aa60b6085", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "cc44da5011e0a29d2b43d6eb82ebb151", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "在 Windows 构建中，使用 gendef 代替 pexports 来构建 DEF 文件", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}, "url": "/docs/compare/?release=12.11#12.11-83962fae8e47a715", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "38602682966155948dd26cd8216edbb9", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "在 Windows 构建中，使用 gendef 代替 pexports 来构建 DEF 文件", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}, "url": "/docs/compare/?release=11.16#11.16-38a44190a83cd337", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-6d6e197535142550", "cves": [], "html": "

防止在 MinGW 下构建的程序中对 shell 通配符模式进行额外展开（Andrew Dunstan）

\n

出于某种原因，MinGW 提供的 C 库默认会展开程序命令行参数中的 shell 通配符字符。这令人困惑，尤其是因为在 MSVC 下不会发生这种情况，因此将其关闭。

", "text": "防止在 MinGW 下构建的程序中对 shell 通配符模式进行额外展开（Andrew Dunstan） 出于某种原因，MinGW 提供的 C 库默认会展开程序命令行参数中的 shell 通配符字符。这令人困惑，尤其是因为在 MSVC 下不会发生这种情况，因此将其关闭。", "title": "防止在 MinGW 下构建的程序中对 shell 通配符模式进行额外展开", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "647cad159320258c6741294702f4e8fded4d6272b23bdf18680a772162b5fa5a", "section_path": ["变更"], "commit_groups": [["01f2bc5af", "58887d58c", "71f394667", "b787c554c", "b90ce0dd7", "d9cede2c3"]], "identity_text": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW (Andrew Dunstan) For some reason the C library provided by MinGW will expand shell wildcard characters in a program's command-line arguments by default. This is confusing, not least because it doesn't happen under MSVC, so turn it off.", "commit_aliases": ["01f2bc5af", "58887d58c", "71f394667", "b787c554c", "b90ce0dd7", "d9cede2c3"], "source_commits": ["58887d58c"], "source_entry_id": "10.21/changes/028", "db_id": "cb5bc30d2bb9bca6ad937c232ba3f3d3", "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7", "relations": [{"rule": 2, "type": "equivalent", "target": "24641f84a59b30379e129e690ef2b967", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}}, {"rule": 2, "type": "equivalent", "target": "3132fffa1766a85302e18428b852d9c1", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}}, {"rule": 2, "type": "equivalent", "target": "f4ddbc73c7844f2cbb2ee355f9e76775", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}}, {"rule": 2, "type": "equivalent", "target": "f89d93baa0ca465846f88287eb623da7", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f89d93baa0ca465846f88287eb623da7", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "防止在 MinGW 下构建的程序中对 shell 通配符模式进行额外展开", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}, "url": "/docs/compare/?release=14.3#14.3-051c3424c7635887", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "24641f84a59b30379e129e690ef2b967", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "防止在 MinGW 下构建的程序中对 shell 通配符模式进行额外展开", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}, "url": "/docs/compare/?release=13.7#13.7-193de4c12bd1c5bc", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "f4ddbc73c7844f2cbb2ee355f9e76775", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "防止在 MinGW 下构建的程序中对 shell 通配符模式进行额外展开", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}, "url": "/docs/compare/?release=12.11#12.11-4ad00e23c24660ab", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "3132fffa1766a85302e18428b852d9c1", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "防止在 MinGW 下构建的程序中对 shell 通配符模式进行额外展开", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}, "url": "/docs/compare/?release=11.16#11.16-6d6e197535142550", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "10.21-dcc627d2380a86cd", "cves": [], "html": "

将时区数据文件更新到 tzdata 2022a 版，以反映巴勒斯坦的夏令时法规变更，并修正智利和乌克兰的历史数据。

", "text": "将时区数据文件更新到 tzdata 2022a 版，以反映巴勒斯坦的夏令时法规变更，并修正智利和乌克兰的历史数据。", "title": "将时区数据文件更新到 tzdata 2022a 版，以反映巴勒斯坦的夏令时法规变更，并修正智利和乌克兰的历史数据。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.21/#id-1.11.6.7.6", "source_hash": "374b7062073fb98931de10bcb6cfef6466c93ac50034e4e9da292b550624f982", "section_path": ["变更"], "commit_groups": [["2bb9f7501", "77ee14ed9", "ab3479bf5", "bc334ec9f", "da72ff09b", "e9735d1af"]], "identity_text": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine.", "commit_aliases": ["2bb9f7501", "77ee14ed9", "ab3479bf5", "bc334ec9f", "da72ff09b", "e9735d1af"], "source_commits": ["bc334ec9f"], "source_entry_id": "10.21/changes/029", "db_id": "70f22e6f1a90f4854ab95213c75fb6cc", "patch_ids": ["afac83603605cad010e22cefc1e1d288"], "statement_hash": "320242e940840f8474c5dcb98b4e7d093764d82123a1dc0f25d3d49fff8aab8f", "relations": [{"rule": 2, "type": "equivalent", "target": "39da68ea256e3f02b57d4a358143919b", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}}, {"rule": 2, "type": "equivalent", "target": "488b0c51a051523d2d93074eff3f63d6", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"], "statement_hash": "320242e940840f8474c5dcb98b4e7d093764d82123a1dc0f25d3d49fff8aab8f"}}, {"rule": 2, "type": "equivalent", "target": "9f6b656c627674cf49a116215c8cad0f", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}}, {"rule": 2, "type": "equivalent", "target": "b1e39c9b8af63dee0774bd1afb5933d8", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}}], "version": "10.21", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b1e39c9b8af63dee0774bd1afb5933d8", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "将时区数据文件更新为 tzdata 2022a 版本，包含巴勒斯坦的夏令时规则变更，以及智利和乌克兰的历史修正。", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}, "url": "/docs/compare/?release=14.3#14.3-f0d1b98fe7331ec6", "source_url": "/docs/release/14.3/#ZH-AUTO-RELEASE-14-SECT2-40"}, {"db_id": "9f6b656c627674cf49a116215c8cad0f", "kind": "equivalent", "version": "13.7", "label": "13.7", "title": "将时区数据文件更新为 tzdata 2022a 版本，包含巴勒斯坦的夏令时规则变更，以及智利和乌克兰的历史修正。", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}, "url": "/docs/compare/?release=13.7#13.7-6acaf1c4d3653dec", "source_url": "/docs/release/13.7/#id-1.11.6.22.5"}, {"db_id": "39da68ea256e3f02b57d4a358143919b", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "将时区数据文件更新为 tzdata 2022a 版本，包含巴勒斯坦的夏令时规则变更，以及智利和乌克兰的历史修正。", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}, "url": "/docs/compare/?release=12.11#12.11-f733876a271a1f8c", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "488b0c51a051523d2d93074eff3f63d6", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "将时区数据文件更新到 tzdata 2022a 版，以反映巴勒斯坦的夏令时法规变更，并修正智利和乌克兰的历史数据。", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"], "statement_hash": "320242e940840f8474c5dcb98b4e7d093764d82123a1dc0f25d3d49fff8aab8f"}, "url": "/docs/compare/?release=11.16#11.16-dcc627d2380a86cd", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 29}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 14}, {"key": "security", "label": "安全相关", "count": 1}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 14}], "total": 29, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2022-1552", "url": "https://www.postgresql.org/support/security/CVE-2022-1552/", "fixed": {"10": "10.21", "11": "11.16", "12": "12.11", "13": "13.7", "14": "14.3"}, "score": 8.8, "title": "将更多操作限制在“安全受限操作”沙箱内", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"10": "10", "11": "11", "12": "12", "13": "13", "14": "14"}, "component": "core server", "published": {"10": "2022-05-12", "11": "2022-05-12", "12": "2022-05-12", "13": "2022-05-12", "14": "2022-05-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Autovacuum, REINDEX , CREATE INDEX , REFRESH MATERIALIZED VIEW , CLUSTER , and pg_amcheck made incomplete efforts to operate safely when a privileged user is maintaining another user's objects. Those commands activated relevant protections too late or not at all. An attacker having permission to create non-temp objects in at least one schema could execute arbitrary SQL functions under a superuser identity.\n\nWhile promptly updating PostgreSQL is the best remediation for most users, a user unable to do that can work around the vulnerability by disabling autovacuum, not manually running the above commands, and not restoring from output of the pg_dump command. Performance may degrade quickly under this workaround. VACUUM is safe, and all commands are fine when a trusted user owns the target object.\n\nThe PostgreSQL project thanks Alexander Lakhin for reporting this problem.", "first_published": "2022-05-12", "fixed_version": "10.21"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 29, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}