{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2019-05-09", "build": "11.3", "major": "11", "minor": 3, "manual": "11", "status": "stable", "doc_git": "", "version": "11.3", "eol_date": "2023-11-09", "date_text": "2019-05-09", "supported": false, "manual_url": "/docs/11/release-11-3.html", "source_url": "/docs/release/11.3/", "entry_count": 63, "placeholder": false, "content_hash": "67b4362c01455339e8d71cfe7046b04bf19d1ef0ac40edb0f050a8cbb90fbdf2", "manual_build": "11.22", "source_as_of": "", "changes_count": 63, "doc_loaded_at": "2026-09-26T02:56:42.383207", "migration_html": "

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

\n

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

", "compatibility_count": 0, "label": "11.3", "status_label": "历史版本", "eol": "2023-11-09", "age_days": 2701, "support_days": -1056}, "groups": [{"date": "2019-05-09", "build": "11.3", "major": "11", "minor": 3, "manual": "11", "status": "stable", "doc_git": "", "version": "11.3", "eol_date": "2023-11-09", "date_text": "2019-05-09", "supported": false, "manual_url": "/docs/11/release-11-3.html", "source_url": "/docs/release/11.3/", "entry_count": 63, "placeholder": false, "content_hash": "67b4362c01455339e8d71cfe7046b04bf19d1ef0ac40edb0f050a8cbb90fbdf2", "manual_build": "11.22", "source_as_of": "", "changes_count": 63, "doc_loaded_at": "2026-09-26T02:56:42.383207", "migration_html": "

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

\n

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

", "compatibility_count": 0, "label": "11.3", "status_label": "历史版本", "eol": "2023-11-09", "age_days": 2701, "support_days": -1056, "entries": [{"id": "11.3-35d4445257f1090d", "cves": ["CVE-2017-7484", "CVE-2019-10130"], "html": "

防止通过选择率估计器绕过行级安全策略（Dean Rasheed）

\n

规划器的某些选择率估计器会将用户定义的操作符应用于 pg_statistic 中的值（例如最常见值）。因此，即使调用用户无权读取某列，可能泄露信息的操作符仍能披露该列中的一些项。在 CVE-2017-7484 中，我们增加了限制来防止这种情况，但没有考虑行级安全的影响。某个用户虽然具有读取某列的 SQL 权限，却因 RLS 策略而无法查看某些行，仍可能通过此类操作符获知这些行的部分内容。本补丁进一步收紧了规则，仅在没有相关 RLS 策略时，才允许将可能泄露信息的操作符应用于统计数据。（CVE-2019-10130）

", "text": "防止通过选择率估计器绕过行级安全策略（Dean Rasheed） 规划器的某些选择率估计器会将用户定义的操作符应用于 pg_statistic 中的值（例如最常见值）。因此，即使调用用户无权读取某列，可能泄露信息的操作符仍能披露该列中的一些项。在 CVE-2017-7484 中，我们增加了限制来防止这种情况，但没有考虑行级安全的影响。某个用户虽然具有读取某列的 SQL 权限，却因 RLS 策略而无法查看某些行，仍可能通过此类操作符获知这些行的部分内容。本补丁进一步收紧了规则，仅在没有相关 RLS 策略时，才允许将可能泄露信息的操作符应用于统计数据。（CVE-2019-10130）", "title": "防止通过选择率估计器绕过行级安全策略", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "b7c94bb2717be449daee0d83662b723551644b3d5a501088d604fcb9fa84b3b3", "section_path": ["变更"], "commit_groups": [["0027ee3c5", "085d64d9d", "1aebfbea8", "93c36145a", "940802830"]], "identity_text": "Prevent row-level security policies from being bypassed via selectivity estimators (Dean Rasheed) Some of the planner's selectivity estimators apply user-defined operators to values found in pg_statistic (e.g., most-common values). A leaky operator therefore can disclose some of the entries in a data column, even if the calling user lacks permission to read that column. In CVE-2017-7484 we added restrictions to forestall that, but we failed to consider the effects of row-level security. A user who has SQL permission to read a column, but who is forbidden to see certain rows due to RLS policy, might still learn something about those rows' contents via a leaky operator. This patch further tightens the rules, allowing leaky operators to be applied to statistics data only when there is no relevant RLS policy. (CVE-2019-10130)", "commit_aliases": ["0027ee3c5", "085d64d9d", "1aebfbea8", "93c36145a", "940802830"], "source_commits": ["0027ee3c5"], "source_entry_id": "11.3/changes/001", "db_id": "9bd418a48b41e4825da797ada67a744d", "patch_ids": ["b4ebc089129bd000de64c7f6f0e6199d"], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7", "relations": [{"rule": 2, "type": "equivalent", "target": "56d6db8446f41023a027932d51f76dad", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7"}}, {"rule": 2, "type": "equivalent", "target": "7ff539ab31995c0e78fd5d7b1ca6321e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7"}}, {"rule": 2, "type": "equivalent", "target": "a6e3722e8822752f3244d263c67c8c64", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7"}}], "version": "11.3", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "56d6db8446f41023a027932d51f76dad", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "防止通过选择率估计器绕过行级安全策略", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7"}, "url": "/docs/compare/?release=10.8#10.8-35d4445257f1090d", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "7ff539ab31995c0e78fd5d7b1ca6321e", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "防止通过选择率估计器绕过行级安全策略", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7"}, "url": "/docs/compare/?release=9.6.13#9.6.13-35d4445257f1090d", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "a6e3722e8822752f3244d263c67c8c64", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "防止通过选择率估计器绕过行级安全策略", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7"}, "url": "/docs/compare/?release=9.5.17#9.5.17-35d4445257f1090d", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}]}, {"id": "11.3-548efb7f6f0895e6", "cves": ["CVE-2019-10129"], "html": "

避免报告分区路由错误时访问已释放的内存（Michael Paquier）

\n

这一错误可能导致崩溃，而且原则上可能被用于泄露服务器内存内容。（CVE-2019-10129）

", "text": "避免报告分区路由错误时访问已释放的内存（Michael Paquier） 这一错误可能导致崩溃，而且原则上可能被用于泄露服务器内存内容。（CVE-2019-10129）", "title": "避免报告分区路由错误时访问已释放的内存", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "f0a43f73f4ebb02245135139a272260da759a0191d4864d4eaf4e8388ab88194", "section_path": ["变更"], "commit_groups": [["52635c276", "91248608a"]], "identity_text": "Avoid access to already-freed memory during partition routing error reports (Michael Paquier) This mistake could lead to a crash, and in principle it might be possible to use it to disclose server memory contents. (CVE-2019-10129)", "commit_aliases": ["52635c276", "91248608a"], "source_commits": ["52635c276"], "source_entry_id": "11.3/changes/002", "db_id": "7f7d6d3b1d63b899873889c66afe143e", "patch_ids": ["b0dc0794fd6357eb8d2bbf61eea3b99d"], "statement_hash": "07ac9560c541d7a3cf0c142c18cd96a5282df1fdaafadea87007e8c07555bf8e", "relations": [], "version": "11.3", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-882384a049110ad1", "cves": [], "html": "

避免对分区表执行 ALTER TABLE 时，发现分区索引可复用而导致目录损坏（Amit Langote，Tom Lane）

\n

例如，当 ALTER COLUMN TYPE 发现不需要物理重写表时，就会发生这种情况。

", "text": "避免对分区表执行 ALTER TABLE 时，发现分区索引可复用而导致目录损坏（Amit Langote，Tom Lane） 例如，当 ALTER COLUMN TYPE 发现不需要物理重写表时，就会发生这种情况。", "title": "避免对分区表执行 ALTER TABLE 时，发现分区索引可复用而导致目录损坏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "1769ecfabc44f544a906c6897407d4c323c92a625847aadda42e15f07f2c3aea", "section_path": ["变更"], "commit_groups": [["02c359eed", "c01eb619a"]], "identity_text": "Avoid catalog corruption when an ALTER TABLE on a partitioned table finds that a partitioned index is reusable (Amit Langote, Tom Lane) This occurs, for example, when ALTER COLUMN TYPE finds that no physical table rewrite is required.", "commit_aliases": ["02c359eed", "c01eb619a"], "source_commits": ["02c359eed"], "source_entry_id": "11.3/changes/003", "db_id": "23bec75fc49b4d916d2c7a11c934f963", "patch_ids": ["30e859f0145c008744927ab80ad9e59b"], "statement_hash": "bed0d3826115e163267e028ed35d8bff3792f6a8e717645b44319e3c1797fbc9", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-d3a4d63cba165e23", "cves": [], "html": "

避免在单语句事务中创建带有 ON COMMIT DROP 和标识列的临时表时发生目录损坏（Peter Eisentraut）

\n

这一隐患被忽略了，因为这种用法实际上没有意义：临时表创建后立即就会被删除。

", "text": "避免在单语句事务中创建带有 ON COMMIT DROP 和标识列的临时表时发生目录损坏（Peter Eisentraut） 这一隐患被忽略了，因为这种用法实际上没有意义：临时表创建后立即就会被删除。", "title": "避免在单语句事务中创建带有 ON COMMIT DROP 和标识列的临时表时发生目录损坏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "fbd3f744915469e07c8159cf5d9fa8d77a2321ee0d3bdb325eb6879c3a47c0b6", "section_path": ["变更"], "commit_groups": [["10b2675d6", "474982fc3", "cd3e27464"]], "identity_text": "Avoid catalog corruption when a temporary table with ON COMMIT DROP and an identity column is created in a single-statement transaction (Peter Eisentraut) This hazard was overlooked because the case is not actually useful, since the temporary table would be dropped immediately after creation.", "commit_aliases": ["10b2675d6", "474982fc3", "cd3e27464"], "source_commits": ["474982fc3"], "source_entry_id": "11.3/changes/004", "db_id": "b4823ed87e75e4e261269a8312179694", "patch_ids": ["feb01387cd97182b2375ff8e0f8accab"], "statement_hash": "25d538475699600d7f5de73f8299c988b0f55edc41736e3691e82959f7df0e33", "relations": [{"rule": 2, "type": "equivalent", "target": "9d2b24472d79ed5df42bcfc732d0937d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "25d538475699600d7f5de73f8299c988b0f55edc41736e3691e82959f7df0e33"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "9d2b24472d79ed5df42bcfc732d0937d", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "避免在单语句事务中创建带有 ON COMMIT DROP 和标识列的临时表时发生目录损坏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "25d538475699600d7f5de73f8299c988b0f55edc41736e3691e82959f7df0e33"}, "url": "/docs/compare/?release=10.8#10.8-d3a4d63cba165e23", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-75903b986c748070", "cves": [], "html": "

修复分区表包含的已删除列多于其分区时，ALTER INDEX ... ATTACH PARTITION 发生的失败（Álvaro Herrera）

", "text": "修复分区表包含的已删除列多于其分区时，ALTER INDEX ... ATTACH PARTITION 发生的失败（Álvaro Herrera）", "title": "修复分区表包含的已删除列多于其分区时，ALTER INDEX ... ATTACH PARTITION 发生的失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "ebda8fa29d6b152b98f177595c9884e6355084ae92c36f0bc171e122061470a3", "section_path": ["变更"], "commit_groups": [["126d63122", "7009f1a2d"]], "identity_text": "Fix failure in ALTER INDEX ... ATTACH PARTITION if the partitioned table contains more dropped columns than its partition does (Álvaro Herrera)", "commit_aliases": ["126d63122", "7009f1a2d"], "source_commits": ["7009f1a2d"], "source_entry_id": "11.3/changes/005", "db_id": "9281153d33e581652536ee06c8f7c540", "patch_ids": ["003a1c05f32f93182b687e2633369868"], "statement_hash": "19199c29491af5eaf97e0e7044a17c9a86439e891d14ad197a112238c4c50f13", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-50d84a36b25eebf3", "cves": [], "html": "

修复某些情况下未能将分区的现有索引附加到新建分区索引的问题（Amit Langote，Álvaro Herrera）

\n

这会导致后续使用该分区索引的 DDL 出现 “index ... not found in partition” 等错误。

", "text": "修复某些情况下未能将分区的现有索引附加到新建分区索引的问题（Amit Langote，Álvaro Herrera） 这会导致后续使用该分区索引的 DDL 出现 “index ... not found in partition” 等错误。", "title": "修复某些情况下未能将分区的现有索引附加到新建分区索引的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "1985675a040943c1a99124aeec62b4c188e391c21031e14abf2d4ef41c2c19c4", "section_path": ["变更"], "commit_groups": [["05b38c7e6", "b1f570b57"]], "identity_text": "Fix failure to attach a partition's existing index to a newly-created partitioned index in some cases (Amit Langote, Álvaro Herrera) This would lead to errors such as index ... not found in partition in subsequent DDL that uses the partitioned index.", "commit_aliases": ["05b38c7e6", "b1f570b57"], "source_commits": ["b1f570b57"], "source_entry_id": "11.3/changes/006", "db_id": "b8c028040f36bb0e36e42a23d2db0dd4", "patch_ids": ["bd4f67bf215fa98dc7673d54fb2c06ef"], "statement_hash": "4552b3da3b8104c29d899d61efefc8f917604841ae4c31b0959245924a747db8", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-759795f254b243b7", "cves": [], "html": "

避免对分区查询结果关系执行 EPQ 复检时发生崩溃（Amit Langote）

\n

当使用 READ COMMITTED 隔离级别，且其他会话并发更新了某些目标行时，就会发生这种情况。

", "text": "避免对分区查询结果关系执行 EPQ 复检时发生崩溃（Amit Langote） 当使用 READ COMMITTED 隔离级别，且其他会话并发更新了某些目标行时，就会发生这种情况。", "title": "避免对分区查询结果关系执行 EPQ 复检时发生崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "fc7fce3bf19a3b2f49b941ec03a3c340c2494c003cb6b8a232f5657a2dfc0097", "section_path": ["变更"], "commit_groups": [["1b5bbe4bc", "a8cb8f124", "b291488da"]], "identity_text": "Avoid crash when an EPQ recheck is performed for a partitioned query result relation (Amit Langote) This occurs when using READ COMMITTED isolation level and another session has concurrently updated some of the target row(s).", "commit_aliases": ["1b5bbe4bc", "a8cb8f124", "b291488da"], "source_commits": ["b291488da"], "source_entry_id": "11.3/changes/007", "db_id": "282631db9846ad7eb0615ef51a50153c", "patch_ids": ["f41233298a4221862aeb7053e8720a74"], "statement_hash": "6f2530608c5c90a9ebc0ffa054eb713bd5c567a5191f33528ca67249f6f3b1d8", "relations": [{"rule": 2, "type": "equivalent", "target": "38e8ee40ca6faa67809057c1f804a6b2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f2530608c5c90a9ebc0ffa054eb713bd5c567a5191f33528ca67249f6f3b1d8"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "38e8ee40ca6faa67809057c1f804a6b2", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "避免对分区查询结果关系执行 EPQ 复检时发生崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f2530608c5c90a9ebc0ffa054eb713bd5c567a5191f33528ca67249f6f3b1d8"}, "url": "/docs/compare/?release=10.8#10.8-759795f254b243b7", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-d5c184501f3a6cc8", "cves": [], "html": "

修复具有已删除属性的多级分区表中的元组路由（Amit Langote，Michael Paquier）

", "text": "修复具有已删除属性的多级分区表中的元组路由（Amit Langote，Michael Paquier）", "title": "修复具有已删除属性的多级分区表中的元组路由", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "dd1eb5f288fbd17264480043a65b762613118e828d23922a25a06ea33231b010", "section_path": ["变更"], "commit_groups": [["6b0208ebc", "964bae4d8"]], "identity_text": "Fix tuple routing in multi-level partitioned tables that have dropped attributes (Amit Langote, Michael Paquier)", "commit_aliases": ["6b0208ebc", "964bae4d8"], "source_commits": ["6b0208ebc"], "source_entry_id": "11.3/changes/008", "db_id": "35a2f731edc08f2447cbc7a441e4913c", "patch_ids": ["5daa90c296f0273c8a628314fa8020ac"], "statement_hash": "7622c68c4b14ea83a176568909ced555c2171544df2b8d9f90b31d8486b9ee98", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-807d7a02fa168ded", "cves": [], "html": "

修复对分区表采用外键约束初始验证的慢速路径时发生的失败（Hadi Moshayedi，Tom Lane，Andres Freund）

\n

只有在无法使用快速路径的少见情况下（例如权限问题），此问题才会显现。

", "text": "修复对分区表采用外键约束初始验证的慢速路径时发生的失败（Hadi Moshayedi，Tom Lane，Andres Freund） 只有在无法使用快速路径的少见情况下（例如权限问题），此问题才会显现。", "title": "修复对分区表采用外键约束初始验证的慢速路径时发生的失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "f9e56846767f615a99b8ad576ccb6592c75bd36c5c0048dd9da05b89eb612c1e", "section_path": ["变更"], "commit_groups": [["46e3442c9", "c2a5fb33d"]], "identity_text": "Fix failure when the slow path of foreign key constraint initial validation is applied to partitioned tables (Hadi Moshayedi, Tom Lane, Andres Freund) This didn't manifest except in the uncommon cases where the fast path can't be used (such as permissions problems).", "commit_aliases": ["46e3442c9", "c2a5fb33d"], "source_commits": ["c2a5fb33d"], "source_entry_id": "11.3/changes/009", "db_id": "27ec38eb8f6e59dd3f435c85ed909a79", "patch_ids": ["73882b9381da89972d9a2ebcb8fc7bdf"], "statement_hash": "b0f461c0921d3af1f5503e2d4bace8aaca5bd59839292f088b10bcabfcfffeb3", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-e26b0f16db0644de", "cves": [], "html": "

修复对继承树或分区表执行 UPDATE 或 DELETE 时，每个表都可被排除的情况下的行为（Amit Langote，Tom Lane）

\n

在这种情况下，如果存在 RETURNING 子句，查询未报告正确的输出列集合；如果存在应当触发的语句级触发器，也未触发它们。

", "text": "修复对继承树或分区表执行 UPDATE 或 DELETE 时，每个表都可被排除的情况下的行为（Amit Langote，Tom Lane） 在这种情况下，如果存在 RETURNING 子句，查询未报告正确的输出列集合；如果存在应当触发的语句级触发器，也未触发它们。", "title": "修复对继承树或分区表执行 UPDATE 或 DELETE 时，每个表都可被排除的情况下的行为", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "06ad67b6e6f4a45c1deb89442a8cb673a6f9b3768b2638cb8a604579f53b2845", "section_path": ["变更"], "commit_groups": [["07fba9ad9", "0fe3f6dd4", "58947fbd5", "714344ae6", "99a1554a2", "ab5fcf2b0"], ["10e3991fa", "159970bca", "67999b354"]], "identity_text": "Fix behavior for an UPDATE or DELETE on an inheritance tree or partitioned table in which every table can be excluded (Amit Langote, Tom Lane) In such cases, the query did not report the correct set of output columns when a RETURNING clause was present, and if there were any statement-level triggers that should be fired, it didn't fire them.", "commit_aliases": ["07fba9ad9", "0fe3f6dd4", "10e3991fa", "159970bca", "58947fbd5", "67999b354", "714344ae6", "99a1554a2", "ab5fcf2b0"], "source_commits": ["07fba9ad9", "10e3991fa"], "source_entry_id": "11.3/changes/010", "db_id": "b368d56b37ac4352bd3ef63c0c0289e8", "patch_ids": ["14ce03dcceb6d4913427b26ae9916ba1", "bcb50de56c4d0b0a5c9be8ed64c5ed97"], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5", "relations": [{"rule": 2, "type": "equivalent", "target": "4edff4dcb3f86c70d97c0946ecaf08df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}}, {"rule": 2, "type": "equivalent", "target": "833c5cc5e991b8517824df64c1aa97bf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}}, {"rule": 2, "type": "equivalent", "target": "bfa3446f770b34d8aa9361f5fab1cb5c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}}, {"rule": 2, "type": "equivalent", "target": "ee33f6a5e3b8f24c278b011a02520dac", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ee33f6a5e3b8f24c278b011a02520dac", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复对继承树或分区表执行 UPDATE 或 DELETE 时，每个表都可被排除的情况下的行为", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}, "url": "/docs/compare/?release=10.8#10.8-e26b0f16db0644de", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "4edff4dcb3f86c70d97c0946ecaf08df", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复对每个表都可被排除的继承树或分区表执行 UPDATE 或 DELETE 时的行为", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}, "url": "/docs/compare/?release=9.6.13#9.6.13-bbd6c7683cf1af8f", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "833c5cc5e991b8517824df64c1aa97bf", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复对每个表都可被排除的继承树或分区表执行 UPDATE 或 DELETE 时的行为", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}, "url": "/docs/compare/?release=9.5.17#9.5.17-bbd6c7683cf1af8f", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "bfa3446f770b34d8aa9361f5fab1cb5c", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复对每个表都可被排除的继承树或分区表执行 UPDATE 或 DELETE 时的行为", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}, "url": "/docs/compare/?release=9.4.22#9.4.22-bbd6c7683cf1af8f", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-afa4c046fbb6fb38", "cves": [], "html": "

直接访问分区且 constraint_exclusion 设置为 on 时，将分区自身的分区约束与所有 CHECK 约束一起用于排除检查（Amit Langote，Tom Lane）

\n

此更改恢复了 v10 中的行为。

", "text": "直接访问分区且 constraint_exclusion 设置为 on 时，将分区自身的分区约束与所有 CHECK 约束一起用于排除检查（Amit Langote，Tom Lane） 此更改恢复了 v10 中的行为。", "title": "直接访问分区且 constraint_exclusion 设置为 on 时，将分区自身的分区约束与所有 CHECK 约束一起用于排除检查", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "eed40564c4128503e8ba424183195f03764f5ef58f3b314ef47a25872232496f", "section_path": ["变更"], "commit_groups": [["11ea45ffe", "e03ff7396"]], "identity_text": "When accessing a partition directly, and constraint_exclusion is set to on, use the partition's partition constraint as well as any CHECK constraints for exclusion checking (Amit Langote, Tom Lane) This change restores the behavior to what it was in v10.", "commit_aliases": ["11ea45ffe", "e03ff7396"], "source_commits": ["11ea45ffe"], "source_entry_id": "11.3/changes/011", "db_id": "cd42a6c30c09b2d409cac1c0ba133e6c", "patch_ids": ["05cb75729d52ab544f99fed658b4133e"], "statement_hash": "5a100599927c4b22cee46036fba7383dc4b0a9a1d9f2fb2917cab1d8bc99eb39", "relations": [], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-c64671fd62c79bf9", "cves": [], "html": "

避免尝试跨事务提交保存游标查询时发生错误而导致服务器崩溃（Tom Lane）

\n

如果过程在具有已打开的显式或隐式游标（例如 PL/pgSQL FOR 循环查询）时尝试提交，就必须先将游标执行完毕并保存其结果，然后才能提交事务。此类执行期间发生错误曾会导致崩溃。

", "text": "避免尝试跨事务提交保存游标查询时发生错误而导致服务器崩溃（Tom Lane） 如果过程在具有已打开的显式或隐式游标（例如 PL/pgSQL FOR 循环查询）时尝试提交，就必须先将游标执行完毕并保存其结果，然后才能提交事务。此类执行期间发生错误曾会导致崩溃。", "title": "避免尝试跨事务提交保存游标查询时发生错误而导致服务器崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "2bcd8327c31d339108a9497f17257ccabaa49bad3a72c50ac62a9065e725d75c", "section_path": ["变更"], "commit_groups": [["0998f32ca", "4d5840cea"]], "identity_text": "Avoid server crash when an error occurs while trying to persist a cursor query across a transaction commit (Tom Lane) If a procedure attempts to commit while it has an open explicit or implicit cursor (for example, a PL/pgSQL FOR-loop query), the cursor must be executed to completion and its results saved before the transaction commit can be performed. An error occurring during such execution led to a crash.", "commit_aliases": ["0998f32ca", "4d5840cea"], "source_commits": ["0998f32ca"], "source_entry_id": "11.3/changes/012", "db_id": "e59727b65aca056453223addc4ecc96f", "patch_ids": ["69870c816f8da91ebb8c5303110c3d9e"], "statement_hash": "2adf4085b728672de4e89f41791fa6a5e4b48f2975d48766788e4299ad71e06c", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-ae6752b8665c93f4", "cves": [], "html": "

避免存在 FOR ALL TABLES 发布时，更新临时表和不记录 WAL 的表抛出不正确的错误（Peter Eisentraut）

\n

对于发布而言，应当忽略此类表，但部分代码未能做到这一点。

", "text": "避免存在 FOR ALL TABLES 发布时，更新临时表和不记录 WAL 的表抛出不正确的错误（Peter Eisentraut） 对于发布而言，应当忽略此类表，但部分代码未能做到这一点。", "title": "避免存在 FOR ALL TABLES 发布时，更新临时表和不记录 WAL 的表抛出不正确的错误", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "d3fcff5c78171a6a16e0b373b0f4c4e5e94407b00d25e85de6e8a72b540383b6", "section_path": ["变更"], "commit_groups": [["05d151e13", "bb385c4fb", "f993bacde"]], "identity_text": "Avoid throwing incorrect errors for updates of temporary tables and unlogged tables when a FOR ALL TABLES publication exists (Peter Eisentraut) Such tables should be ignored for publication purposes, but some parts of the code failed to do so.", "commit_aliases": ["05d151e13", "bb385c4fb", "f993bacde"], "source_commits": ["f993bacde"], "source_entry_id": "11.3/changes/013", "db_id": "e51e9d79477a1138da3523277001c1ce", "patch_ids": ["a71cce51f074e4c2007e650a795f56da"], "statement_hash": "7a876748d502629785a24f7787cf6518f68777d7f1868fbabb1f07f6751f1d38", "relations": [{"rule": 2, "type": "equivalent", "target": "e131ed931be19881b37fa82de0824a8f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a876748d502629785a24f7787cf6518f68777d7f1868fbabb1f07f6751f1d38"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e131ed931be19881b37fa82de0824a8f", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "避免存在 FOR ALL TABLES 发布时，更新临时表和不记录 WAL 的表抛出不正确的错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a876748d502629785a24f7787cf6518f68777d7f1868fbabb1f07f6751f1d38"}, "url": "/docs/compare/?release=10.8#10.8-ae6752b8665c93f4", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-1309f551eab21e73", "cves": [], "html": "

目标关系为可更新视图时，修复包含多行 VALUES 的 INSERT ... VALUES 命令中对显式 DEFAULT 项的处理（Amit Langote，Dean Rasheed）

\n

当可更新视图的列没有默认值，但其底层表有默认值时，单行 INSERT ... VALUES 会使用底层表的默认值。然而，多行情况下以前始终使用 NULL。现在修正为与单行情况一致。

", "text": "目标关系为可更新视图时，修复包含多行 VALUES 的 INSERT ... VALUES 命令中对显式 DEFAULT 项的处理（Amit Langote，Dean Rasheed） 当可更新视图的列没有默认值，但其底层表有默认值时，单行 INSERT ... VALUES 会使用底层表的默认值。然而，多行情况下以前始终使用 NULL。现在修正为与单行情况一致。", "title": "目标关系为可更新视图时，修复包含多行 VALUES 的 INSERT ... VALUES 命令中对显式 DEFAULT 项的处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "f6d7c171aef1f3ec7622f3754c9b0feb7e9f77a1909edb1f9de28eab30ef4f73", "section_path": ["变更"], "commit_groups": [["0a0844630", "133923aeb", "431471e1f", "556fdd49c", "6ccb97337", "ed4653db8"], ["2b1971c03", "41531e42d", "5a73edf05", "90f91bfbd", "d31e421d7", "fbec6fa38"]], "identity_text": "Fix handling of explicit DEFAULT items in an INSERT ... VALUES command with multiple VALUES rows, if the target relation is an updatable view (Amit Langote, Dean Rasheed) When the updatable view has no default for the column but its underlying table has one, a single-row INSERT ... VALUES will use the underlying table's default. In the multi-row case, however, NULL was always used. Correct it to act like the single-row case.", "commit_aliases": ["0a0844630", "133923aeb", "2b1971c03", "41531e42d", "431471e1f", "556fdd49c", "5a73edf05", "6ccb97337", "90f91bfbd", "d31e421d7", "ed4653db8", "fbec6fa38"], "source_commits": ["6ccb97337", "fbec6fa38"], "source_entry_id": "11.3/changes/014", "db_id": "576438ba514bda6624f4fcbc74af1247", "patch_ids": ["761a321d46a9f8c380033e4f323305b9", "fbecd82e0a2cd3325e6e94b61e630c39"], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88", "relations": [{"rule": 2, "type": "equivalent", "target": "0e7f247e2430c5d23f1325380d1bee17", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}}, {"rule": 2, "type": "equivalent", "target": "15b3195c74a53d643ab8b5015da41bf2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}}, {"rule": 2, "type": "equivalent", "target": "5cc5fd553f73b11f507fe1babd643a03", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}}, {"rule": 2, "type": "equivalent", "target": "a3699f71059e2aa38a985fb9255b5413", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "15b3195c74a53d643ab8b5015da41bf2", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "目标关系为可更新视图时，修复包含多行 VALUES 的 INSERT ... VALUES 命令中对显式 DEFAULT 项的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}, "url": "/docs/compare/?release=10.8#10.8-1309f551eab21e73", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "a3699f71059e2aa38a985fb9255b5413", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复目标关系是可更新视图时带多行 VALUES 的 INSERT ... VALUES 命令中显式 DEFAULT 项的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}, "url": "/docs/compare/?release=9.6.13#9.6.13-f65a38c6c6e79393", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "0e7f247e2430c5d23f1325380d1bee17", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复目标关系是可更新视图时带多行 VALUES 的 INSERT ... VALUES 命令中显式 DEFAULT 项的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}, "url": "/docs/compare/?release=9.5.17#9.5.17-f65a38c6c6e79393", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "5cc5fd553f73b11f507fe1babd643a03", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复目标关系是可更新视图时带多行 VALUES 的 INSERT ... VALUES 命令中显式 DEFAULT 项的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}, "url": "/docs/compare/?release=9.4.22#9.4.22-f65a38c6c6e79393", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-2f43af900aee43f0", "cves": [], "html": "

修复 CREATE VIEW，使其允许零列视图（Ashutosh Sharma）

\n

为与允许零列表的行为保持一致，我们也应该允许这种情况。由于表可以转换为视图，即使存在这一限制，也能创建零列视图，从而导致转储/重载失败。

", "text": "修复 CREATE VIEW，使其允许零列视图（Ashutosh Sharma） 为与允许零列表的行为保持一致，我们也应该允许这种情况。由于表可以转换为视图，即使存在这一限制，也能创建零列视图，从而导致转储/重载失败。", "title": "修复 CREATE VIEW，使其允许零列视图", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "b2292133076609755fb0f4b0427aa48d983ecc52bb2a0d4810272f32a9e60f3b", "section_path": ["变更"], "commit_groups": [["0b476cf62", "1f29a1d22", "4eca1905d", "9fdc49d08", "a32ca7883", "b355be443"]], "identity_text": "Fix CREATE VIEW to allow zero-column views (Ashutosh Sharma) We should allow this for consistency with allowing zero-column tables. Since a table can be converted to a view, zero-column views could be created even with the restriction in place, leading to dump/reload failures.", "commit_aliases": ["0b476cf62", "1f29a1d22", "4eca1905d", "9fdc49d08", "a32ca7883", "b355be443"], "source_commits": ["4eca1905d"], "source_entry_id": "11.3/changes/015", "db_id": "0ad36899c6cc367ed4b03e73f3a605cd", "patch_ids": ["402baac3811de98f6ee8c6cd5e4145cf"], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74", "relations": [{"rule": 2, "type": "equivalent", "target": "090336ec6d5bd02a548f703772f3ed54", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}}, {"rule": 2, "type": "equivalent", "target": "11b34e728cf080fc41561fcb4d6ad24f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}}, {"rule": 2, "type": "equivalent", "target": "809afe72287af356ea8f5d551e8473d3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}}, {"rule": 2, "type": "equivalent", "target": "bca14bcec41ac40c919b4698939d3e7a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "11b34e728cf080fc41561fcb4d6ad24f", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复 CREATE VIEW，使其允许零列视图", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}, "url": "/docs/compare/?release=10.8#10.8-2f43af900aee43f0", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "bca14bcec41ac40c919b4698939d3e7a", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复 CREATE VIEW 允许零列视图", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}, "url": "/docs/compare/?release=9.6.13#9.6.13-100bd80868ceba38", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "090336ec6d5bd02a548f703772f3ed54", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复 CREATE VIEW 允许零列视图", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}, "url": "/docs/compare/?release=9.5.17#9.5.17-100bd80868ceba38", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "809afe72287af356ea8f5d551e8473d3", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复 CREATE VIEW 允许零列视图", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}, "url": "/docs/compare/?release=9.4.22#9.4.22-100bd80868ceba38", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-3966034489e2d830", "cves": [], "html": "

补上对 CREATE TABLE IF NOT EXISTS ... AS EXECUTE ... 缺失的支持（Andreas Karlsson）

\n

IF NOT EXISTS 和 EXECUTE 的组合本应能够工作，但语法遗漏了它。

", "text": "补上对 CREATE TABLE IF NOT EXISTS ... AS EXECUTE ... 缺失的支持（Andreas Karlsson） IF NOT EXISTS 和 EXECUTE 的组合本应能够工作，但语法遗漏了它。", "title": "补上对 CREATE TABLE IF NOT EXISTS ... AS EXECUTE ... 缺失的支持", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "a59a4ea9153865f60433578a9032c243f791a0f7b6640119e1e6177342f92a84", "section_path": ["变更"], "commit_groups": [["06cdab9df", "331a613e9", "3a2923a9b", "75aba11ec", "d08fae377"]], "identity_text": "Add missing support for CREATE TABLE IF NOT EXISTS ... AS EXECUTE ... (Andreas Karlsson) The combination of IF NOT EXISTS and EXECUTE should work, but the grammar omitted it.", "commit_aliases": ["06cdab9df", "331a613e9", "3a2923a9b", "75aba11ec", "d08fae377"], "source_commits": ["75aba11ec"], "source_entry_id": "11.3/changes/016", "db_id": "203eb98c0cbd3e07960f297009511131", "patch_ids": ["1b42ea7dd1c02ce4286ece3afb5621d7"], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f", "relations": [{"rule": 2, "type": "equivalent", "target": "3ec55572f69e517844a5e9fccff1e699", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f"}}, {"rule": 2, "type": "equivalent", "target": "ddb60aa2819804230a93287c7c89538c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f"}}, {"rule": 2, "type": "equivalent", "target": "f33e689b9ddd3281c9d28882586453c3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "3ec55572f69e517844a5e9fccff1e699", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "补上对 CREATE TABLE IF NOT EXISTS ... AS EXECUTE ... 缺失的支持", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f"}, "url": "/docs/compare/?release=10.8#10.8-3966034489e2d830", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "ddb60aa2819804230a93287c7c89538c", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "补上对 CREATE TABLE IF NOT EXISTS ... AS EXECUTE ... 的缺失支持", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f"}, "url": "/docs/compare/?release=9.6.13#9.6.13-776d87acfeabfd74", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "f33e689b9ddd3281c9d28882586453c3", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "补上对 CREATE TABLE IF NOT EXISTS ... AS EXECUTE ... 的缺失支持", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f"}, "url": "/docs/compare/?release=9.5.17#9.5.17-776d87acfeabfd74", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}]}, {"id": "11.3-dd6917b2eff5e96f", "cves": [], "html": "

确保行级安全策略表达式中的子 SELECT 以正确用户的权限执行（Dean Rasheed）

\n

以前，如果通过视图访问带有 RLS 策略的表，此类检查可能以调用视图的用户身份执行，而非按预期以视图所有者的身份执行。

", "text": "确保行级安全策略表达式中的子 SELECT 以正确用户的权限执行（Dean Rasheed） 以前，如果通过视图访问带有 RLS 策略的表，此类检查可能以调用视图的用户身份执行，而非按预期以视图所有者的身份执行。", "title": "确保行级安全策略表达式中的子 SELECT 以正确用户的权限执行", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "2aeaa42374d304b4c4741c1aa8b768638ea4710c543b8110acd6fe6afda578d6", "section_path": ["变更"], "commit_groups": [["157dcf534", "1b9a2f458", "2e606d0ad", "db4bc9994", "e2d28c0f4"]], "identity_text": "Ensure that sub-SELECTs appearing in row-level-security policy expressions are executed with the correct user's permissions (Dean Rasheed) Previously, if the table having the RLS policy was accessed via a view, such checks might be executed as the user calling the view, not as the view owner as they should be.", "commit_aliases": ["157dcf534", "1b9a2f458", "2e606d0ad", "db4bc9994", "e2d28c0f4"], "source_commits": ["157dcf534"], "source_entry_id": "11.3/changes/017", "db_id": "538a53875eb204361509c8fe1afe2936", "patch_ids": ["8a241ccb62daab1f8681ceaf0928e373"], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7", "relations": [{"rule": 2, "type": "equivalent", "target": "39b09b82ea1b638d237ba72e602ff58e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7"}}, {"rule": 2, "type": "equivalent", "target": "6e1d531bdedba2cc5761a18194d45b94", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7"}}, {"rule": 2, "type": "equivalent", "target": "93ee07f789c3a4a17d8bef277bec768c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "39b09b82ea1b638d237ba72e602ff58e", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "确保行级安全策略表达式中的子 SELECT 以正确用户的权限执行", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7"}, "url": "/docs/compare/?release=10.8#10.8-dd6917b2eff5e96f", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "93ee07f789c3a4a17d8bef277bec768c", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "确保行级安全策略表达式中出现的子 SELECT 以正确的用户权限执行", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7"}, "url": "/docs/compare/?release=9.6.13#9.6.13-03c882be771d2541", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "6e1d531bdedba2cc5761a18194d45b94", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "确保行级安全策略表达式中出现的子 SELECT 以正确的用户权限执行", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7"}, "url": "/docs/compare/?release=9.5.17#9.5.17-03c882be771d2541", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}]}, {"id": "11.3-1189aea744777953", "cves": [], "html": "

按照 SQL:2006 及后续标准的要求，当 xmloption 设置为 content 时，接受 XML 文档作为 xml 类型的有效值（Chapman Flack）

\n

以前，PostgreSQL 遵循不允许这种用法的 SQL:2003 定义。但这给转储/恢复带来了严重问题：没有任何 xmloption 设置能够接受所有有效的 XML 数据。因此，改为采用 2006 版的定义。

\n

同时修改了 pg_dump，使其在恢复数据时输出 SET xmloption = content，确保即使当前设置为 document，转储/恢复也能正常工作。

", "text": "按照 SQL:2006 及后续标准的要求，当 xmloption 设置为 content 时，接受 XML 文档作为 xml 类型的有效值（Chapman Flack） 以前，PostgreSQL 遵循不允许这种用法的 SQL:2003 定义。但这给转储/恢复带来了严重问题：没有任何 xmloption 设置能够接受所有有效的 XML 数据。因此，改为采用 2006 版的定义。 同时修改了 pg_dump，使其在恢复数据时输出 SET xmloption = content，确保即使当前设置为 document，转储/恢复也能正常工作。", "title": "按照 SQL:2006 及后续标准的要求，当 xmloption 设置为 content 时，接受 XML 文档作为 xml 类型的有效值", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "3833cee169cfe9595a1fb3df3c91425937d06706e00e4085ed901034b9b3f17e", "section_path": ["变更"], "commit_groups": [["06c320c8a", "432356a9d", "4870dce37", "581b890c2", "7c89f350f", "87a44b6cf"], ["08d8cfe3c", "687acb598", "8ba485422", "de922529f"], ["754ffcd42", "78f84fe0f", "849f87a1c", "8d1dadb25", "d7cfd5ee4", "da45927ce"], ["809cccc35", "c4c2958c6", "d5e9e2330", "d88d71e31", "e319f03d1", "f778e537a"]], "identity_text": "Accept XML documents as valid values of type xml when xmloption is set to content, as required by SQL:2006 and later (Chapman Flack) Previously PostgreSQL followed the SQL:2003 definition, which doesn't allow this. But that creates a serious problem for dump/restore: there is no setting of xmloption that will accept all valid XML data. Hence, switch to the 2006 definition. pg_dump is also modified to emit SET xmloption = content while restoring data, ensuring that dump/restore works even if the prevailing setting is document.", "commit_aliases": ["06c320c8a", "08d8cfe3c", "432356a9d", "4870dce37", "581b890c2", "687acb598", "754ffcd42", "78f84fe0f", "7c89f350f", "809cccc35", "849f87a1c", "87a44b6cf", "8ba485422", "8d1dadb25", "c4c2958c6", "d5e9e2330", "d7cfd5ee4", "d88d71e31", "da45927ce", "de922529f", "e319f03d1", "f778e537a"], "source_commits": ["7c89f350f", "849f87a1c", "de922529f", "e319f03d1"], "source_entry_id": "11.3/changes/018", "db_id": "35509c0a6100cc945cd7c16a6d72baec", "patch_ids": ["90f28e21ade1bcd2034bd74c95da680b", "a48aa1b5e346d80e35a44c02dab92dd5", "c37c93b5701ea907a1f9ebb0fafb2ecf", "c57602d1fe51921d1f914421303589fc"], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded", "relations": [{"rule": 2, "type": "equivalent", "target": "2086676771c95a609d6b64562e08edb0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}}, {"rule": 2, "type": "equivalent", "target": "301285ce4093d204e6501892fd9b5151", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}}, {"rule": 2, "type": "equivalent", "target": "635be5d8d80a61f198bc53c9ddeb3db5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}}, {"rule": 2, "type": "equivalent", "target": "d4c9ce5a219d9263adccd0f74ac2b381", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "301285ce4093d204e6501892fd9b5151", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "按照 SQL:2006 及后续标准的要求，当 xmloption 设置为 content 时，接受 XML 文档作为 xml 类型的有效值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}, "url": "/docs/compare/?release=10.8#10.8-1189aea744777953", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "d4c9ce5a219d9263adccd0f74ac2b381", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "在 xmloption 设为 content 时按 SQL:2006 及后续标准的要求接受 XML 文档作为 xml 类型的有效值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}, "url": "/docs/compare/?release=9.6.13#9.6.13-abeef0d12bb90bdd", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "635be5d8d80a61f198bc53c9ddeb3db5", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "在 xmloption 设为 content 时按 SQL:2006 及后续标准的要求接受 XML 文档作为 xml 类型的有效值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}, "url": "/docs/compare/?release=9.5.17#9.5.17-abeef0d12bb90bdd", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "2086676771c95a609d6b64562e08edb0", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "在 xmloption 设为 content 时按 SQL:2006 及后续标准的要求接受 XML 文档作为 xml 类型的有效值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}, "url": "/docs/compare/?release=9.4.22#9.4.22-abeef0d12bb90bdd", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-4923162f8d7b0ab5", "cves": [], "html": "

改进服务器在启动时对预先存在的共享内存段是否仍在使用的检查（Noah Misch）

\n

即使 postmaster.pid 文件已被删除，postmaster 现在也更有可能检测到上一次 postmaster 运行留下的活跃进程。

", "text": "改进服务器在启动时对预先存在的共享内存段是否仍在使用的检查（Noah Misch） 即使 postmaster.pid 文件已被删除，postmaster 现在也更有可能检测到上一次 postmaster 运行留下的活跃进程。", "title": "改进服务器在启动时对预先存在的共享内存段是否仍在使用的检查", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "e149f86d49bbe3a8926ef8ef6f2356f0a222901f0c4d2666606c75968905142c", "section_path": ["变更"], "commit_groups": [["0bdf6d635", "4543ef36f", "4ab02e815", "9f65081cf"], ["3ef5e16c6", "6d81e3c65", "7ef2b313e", "808e1e75f", "c09850992", "c565de643"]], "identity_text": "Improve server's startup-time checks for whether a pre-existing shared memory segment is still in use (Noah Misch) The postmaster is now more likely to detect that there are still active processes from a previous postmaster incarnation, even if the postmaster.pid file has been removed.", "commit_aliases": ["0bdf6d635", "3ef5e16c6", "4543ef36f", "4ab02e815", "6d81e3c65", "7ef2b313e", "808e1e75f", "9f65081cf", "c09850992", "c565de643"], "source_commits": ["0bdf6d635", "7ef2b313e"], "source_entry_id": "11.3/changes/019", "db_id": "57c110b625e0623530d237e179705f69", "patch_ids": ["ac82c86ad138d079dad2d904251ee84c", "e10337d8b3032c4e6db3afd2f0118656"], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185", "relations": [{"rule": 2, "type": "equivalent", "target": "3e0dc8919a53552d0431bcd9bf09c820", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}}, {"rule": 2, "type": "equivalent", "target": "4ecb1a0dfe09a23ba50f012651a2b937", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}}, {"rule": 2, "type": "equivalent", "target": "59083f7943af0375b7179837075926ae", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}}, {"rule": 2, "type": "equivalent", "target": "8e5dcdf0c92c508318fc1d50f92486b4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "59083f7943af0375b7179837075926ae", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "改进服务器在启动时对预先存在的共享内存段是否仍在使用的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}, "url": "/docs/compare/?release=10.8#10.8-4923162f8d7b0ab5", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "3e0dc8919a53552d0431bcd9bf09c820", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "改进服务器启动时对既有共享内存段是否仍在使用的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}, "url": "/docs/compare/?release=9.6.13#9.6.13-f6b97a174960300a", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "4ecb1a0dfe09a23ba50f012651a2b937", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "改进服务器启动时对既有共享内存段是否仍在使用的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}, "url": "/docs/compare/?release=9.5.17#9.5.17-f6b97a174960300a", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "8e5dcdf0c92c508318fc1d50f92486b4", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "改进服务器启动时对既有共享内存段是否仍在使用的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}, "url": "/docs/compare/?release=9.4.22#9.4.22-f6b97a174960300a", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-daf87f94e0397890", "cves": [], "html": "

避免 B-树索引清理逻辑中可能发生的除以零（Piotr Stefaniak，Alexander Korotkov）

\n

这可能导致对是否需要索引清理作出错误判断。

", "text": "避免 B-树索引清理逻辑中可能发生的除以零（Piotr Stefaniak，Alexander Korotkov） 这可能导致对是否需要索引清理作出错误判断。", "title": "避免 B-树索引清理逻辑中可能发生的除以零", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "afa7936871b9808492792a00c2ad590df5713537e74e683ee654939eaf67d00a", "section_path": ["变更"], "commit_groups": [["0d68ad3fc", "1e8719818"]], "identity_text": "Avoid possible division-by-zero in btree index vacuum logic (Piotr Stefaniak, Alexander Korotkov) This could lead to incorrect decisions about whether index cleanup is needed.", "commit_aliases": ["0d68ad3fc", "1e8719818"], "source_commits": ["0d68ad3fc"], "source_entry_id": "11.3/changes/020", "db_id": "2549827d488f51404e1fdbf3ec8a9b77", "patch_ids": ["3a9223640a5f1e8044da7bd2005b29e8"], "statement_hash": "35b761815745e58aa6a4b702f3c64f66d4e721edc8c643d373b88ec54cb80f22", "relations": [], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-15dd3db2edf595e4", "cves": [], "html": "

避免将并行工作进程的事务计为独立事务（Haribabu Kommi）

", "text": "避免将并行工作进程的事务计为独立事务（Haribabu Kommi）", "title": "避免将并行工作进程的事务计为独立事务", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "9ce672575eac5bf454aa683284b73500e5c209c9184114a2553e4b94a5b98613", "section_path": ["变更"], "commit_groups": [["036f7d378", "09630a1e9", "7657072e0", "bdf35744b"]], "identity_text": "Avoid counting parallel workers' transactions as separate transactions (Haribabu Kommi)", "commit_aliases": ["036f7d378", "09630a1e9", "7657072e0", "bdf35744b"], "source_commits": ["036f7d378"], "source_entry_id": "11.3/changes/021", "db_id": "a5b3202e83704c37b3f27eafe94408c4", "patch_ids": ["4bb14bfecb1ae596e991f705e9455840"], "statement_hash": "ec6e44f4b20670b74f3aef5b68e371f7f671a880df345fb56430bf0374354c65", "relations": [{"rule": 2, "type": "equivalent", "target": "b5de6042d578e46c90c2c435d9ca02bf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ec6e44f4b20670b74f3aef5b68e371f7f671a880df345fb56430bf0374354c65"}}, {"rule": 2, "type": "equivalent", "target": "bdeb9705684164be402f50674623b35a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ec6e44f4b20670b74f3aef5b68e371f7f671a880df345fb56430bf0374354c65"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b5de6042d578e46c90c2c435d9ca02bf", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "避免将并行工作进程的事务计为独立事务", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ec6e44f4b20670b74f3aef5b68e371f7f671a880df345fb56430bf0374354c65"}, "url": "/docs/compare/?release=10.8#10.8-15dd3db2edf595e4", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "bdeb9705684164be402f50674623b35a", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "避免把并行工作者的事务计为单独的事务", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ec6e44f4b20670b74f3aef5b68e371f7f671a880df345fb56430bf0374354c65"}, "url": "/docs/compare/?release=9.6.13#9.6.13-171f5ee606e8887d", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}]}, {"id": "11.3-5e3b663f903c9160", "cves": [], "html": "

修复 GIN 索引 WAL 记录的不兼容问题（Alexander Korotkov）

\n

二月份小版本中应用的一项修复对向后兼容性考虑得不够周全。如果使用该小版本的备库读取由更早小版本的主库生成的 GIN 页面删除 WAL 记录，就会出现问题。

", "text": "修复 GIN 索引 WAL 记录的不兼容问题（Alexander Korotkov） 二月份小版本中应用的一项修复对向后兼容性考虑得不够周全。如果使用该小版本的备库读取由更早小版本的主库生成的 GIN 页面删除 WAL 记录，就会出现问题。", "title": "修复 GIN 索引 WAL 记录的不兼容问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "882a4087ee9f704fdcee8bc774d491a772c5509edb7cf89a181f9c42128d69ac", "section_path": ["变更"], "commit_groups": [["89f39736f", "cda5f6575", "d1166af19", "e23d44016", "f8a69a68a"]], "identity_text": "Fix incompatibility of GIN-index WAL records (Alexander Korotkov) A fix applied in February's minor releases was not sufficiently careful about backwards compatibility, leading to problems if a standby server of that vintage reads GIN page-deletion WAL records generated by a primary server of a previous minor release.", "commit_aliases": ["89f39736f", "cda5f6575", "d1166af19", "e23d44016", "f8a69a68a"], "source_commits": ["89f39736f"], "source_entry_id": "11.3/changes/022", "db_id": "8ac6289d89d1fbc54793e1be533234c2", "patch_ids": ["673b5eef4381483b130025a87ec7defa"], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269", "relations": [{"rule": 2, "type": "equivalent", "target": "20969dae2aafde17057cd5669e3da33d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}}, {"rule": 2, "type": "equivalent", "target": "6ade0705a01b6c115e7a5b05799e1e8a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}}, {"rule": 2, "type": "equivalent", "target": "b4045e089f599f3829cddf06a819b434", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}}, {"rule": 2, "type": "equivalent", "target": "bd4626c573fc81d2806704b26461c907", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b4045e089f599f3829cddf06a819b434", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复 GIN 索引 WAL 记录的不兼容问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}, "url": "/docs/compare/?release=10.8#10.8-5e3b663f903c9160", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "bd4626c573fc81d2806704b26461c907", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复 GIN 索引 WAL 记录的不兼容", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}, "url": "/docs/compare/?release=9.6.13#9.6.13-f078328560ba4d63", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "20969dae2aafde17057cd5669e3da33d", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复 GIN 索引 WAL 记录的不兼容", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}, "url": "/docs/compare/?release=9.5.17#9.5.17-f078328560ba4d63", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "6ade0705a01b6c115e7a5b05799e1e8a", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复 GIN 索引 WAL 记录的不兼容", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}, "url": "/docs/compare/?release=9.4.22#9.4.22-f078328560ba4d63", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-1e569c8acf8d1f9d", "cves": [], "html": "

修复在复制连接中执行 SHOW 命令时可能发生的崩溃（Michael Paquier）

", "text": "修复在复制连接中执行 SHOW 命令时可能发生的崩溃（Michael Paquier）", "title": "修复在复制连接中执行 SHOW 命令时可能发生的崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "301f389526a3f358ef79e42223940568a252e24c79292cd257ac8dfcab456eb8", "section_path": ["变更"], "commit_groups": [["512902643", "ab359624b", "c34677fda"]], "identity_text": "Fix possible crash while executing a SHOW command in a replication connection (Michael Paquier)", "commit_aliases": ["512902643", "ab359624b", "c34677fda"], "source_commits": ["512902643"], "source_entry_id": "11.3/changes/023", "db_id": "3ae5a15dadabd90ba56262f4ca9324d0", "patch_ids": ["746ed9d85c0f2a407326bb97733c6f33"], "statement_hash": "cd4653ff1625d4c0852a2d35684b30bd6e99f9471f557461de14d242ce5c92ba", "relations": [{"rule": 2, "type": "equivalent", "target": "5beac01f64fff8f804aa663c575c6c1e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd4653ff1625d4c0852a2d35684b30bd6e99f9471f557461de14d242ce5c92ba"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "5beac01f64fff8f804aa663c575c6c1e", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复在复制连接中执行 SHOW 命令时可能发生的崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd4653ff1625d4c0852a2d35684b30bd6e99f9471f557461de14d242ce5c92ba"}, "url": "/docs/compare/?release=10.8#10.8-1e569c8acf8d1f9d", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-2a2df112d78996cf", "cves": [], "html": "

避免从 portal 中逐行获取数据时发生服务器内存泄漏（Tom Lane）

", "text": "避免从 portal 中逐行获取数据时发生服务器内存泄漏（Tom Lane）", "title": "避免从 portal 中逐行获取数据时发生服务器内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "bb7120434a30ba5c948e93f2db916f320c6dbd921fe4da5704120fdd94dcdf61", "section_path": ["变更"], "commit_groups": [["adf27de8e", "f2004f19e"]], "identity_text": "Avoid server memory leak when fetching rows from a portal one at a time (Tom Lane)", "commit_aliases": ["adf27de8e", "f2004f19e"], "source_commits": ["adf27de8e"], "source_entry_id": "11.3/changes/024", "db_id": "8373f23ac78df0294cb2e61180115b64", "patch_ids": ["2e1b124b5839462762283278d4565729"], "statement_hash": "d0230661c9ef4e9369006545aeeda4dea9a78326bd5a511aef92103570e9ba7c", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-b5451983e23f35f1", "cves": [], "html": "

避免重建分区的关系缓存条目时发生内存泄漏（Amit Langote，Tom Lane）

", "text": "避免重建分区的关系缓存条目时发生内存泄漏（Amit Langote，Tom Lane）", "title": "避免重建分区的关系缓存条目时发生内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "11e58da0591a2975fd3af79ecc671c2423829f56e11306f57aacfdf1c5ef0e82", "section_path": ["变更"], "commit_groups": [["089e4d405", "5f1433ac5", "d4c50b4b1"]], "identity_text": "Avoid memory leak when a partition's relation cache entry is rebuilt (Amit Langote, Tom Lane)", "commit_aliases": ["089e4d405", "5f1433ac5", "d4c50b4b1"], "source_commits": ["089e4d405"], "source_entry_id": "11.3/changes/025", "db_id": "ad5d4a8037a15d16d7ff86be55e784fc", "patch_ids": ["274462418cab20fd42275ae6bb472904"], "statement_hash": "37f8cd44f69a7bce19e5300dfd52206c41511cbe10fb2174769a87d06ec50cf2", "relations": [{"rule": 2, "type": "equivalent", "target": "6523e925112eefec93f973ef01e868a1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "37f8cd44f69a7bce19e5300dfd52206c41511cbe10fb2174769a87d06ec50cf2"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6523e925112eefec93f973ef01e868a1", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "避免重建分区的关系缓存条目时发生内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "37f8cd44f69a7bce19e5300dfd52206c41511cbe10fb2174769a87d06ec50cf2"}, "url": "/docs/compare/?release=10.8#10.8-b5451983e23f35f1", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-9033975dde4c2264", "cves": [], "html": "

在适当情况下，容忍 fsync 和 sync_file_range 调用返回 EINVAL 和 ENOSYS 错误（Thomas Munro，James Sewell）

\n

此前将文件同步失败改为触发 panic 的做法，在某些失败可预见且实质上表示“操作不受支持”的情况下显得过于谨慎。

", "text": "在适当情况下，容忍 fsync 和 sync_file_range 调用返回 EINVAL 和 ENOSYS 错误（Thomas Munro，James Sewell） 此前将文件同步失败改为触发 panic 的做法，在某些失败可预见且实质上表示“操作不受支持”的情况下显得过于谨慎。", "title": "在适当情况下，容忍 fsync 和 sync_file_range 调用返回 EINVAL 和 ENOSYS 错误", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "79ba80fb92d7615c7335d038c2ec0dcfee356d28a57a1d0755682450ef29ac65", "section_path": ["变更"], "commit_groups": [["0ec89a0f6", "4d67357db", "ad714c607", "bcf627834", "ede6b1962", "f16735d80"], ["30dcb6270", "387483e89", "483520eca", "64b8c51bc"]], "identity_text": "Tolerate EINVAL and ENOSYS error results, where appropriate, for fsync and sync_file_range calls (Thomas Munro, James Sewell) The previous change to panic on file synchronization failures turns out to have been excessively paranoid for certain cases where a failure is predictable and essentially means operation not supported.", "commit_aliases": ["0ec89a0f6", "30dcb6270", "387483e89", "483520eca", "4d67357db", "64b8c51bc", "ad714c607", "bcf627834", "ede6b1962", "f16735d80"], "source_commits": ["30dcb6270", "4d67357db"], "source_entry_id": "11.3/changes/026", "db_id": "f449147b771ac77b4c5587d05127b477", "patch_ids": ["22e389f87139a1454ac12e1c49359b3f", "c34b347e5c1bf8389e871244c194ea87"], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024", "relations": [{"rule": 2, "type": "equivalent", "target": "4675539e238eceda7f6eac2b399194f8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}}, {"rule": 2, "type": "equivalent", "target": "5f7b4be0047845cd0dca4e2d076df426", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}}, {"rule": 2, "type": "equivalent", "target": "60a3c6f60382c295c24869812f5f21f0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}}, {"rule": 2, "type": "equivalent", "target": "829e28a01e09bf073befb02bbb654052", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "4675539e238eceda7f6eac2b399194f8", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "在适当情况下，容忍 fsync 和 sync_file_range 调用返回 EINVAL 和 ENOSYS 错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}, "url": "/docs/compare/?release=10.8#10.8-9033975dde4c2264", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "829e28a01e09bf073befb02bbb654052", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "在适当的情况下容忍 fsync 和 sync_file_range 调用的 EINVAL 和 ENOSYS 错误结果", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}, "url": "/docs/compare/?release=9.6.13#9.6.13-29e0a55b05357c67", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "5f7b4be0047845cd0dca4e2d076df426", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "在适当的情况下容忍 fsync 和 sync_file_range 调用的 EINVAL 和 ENOSYS 错误结果", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}, "url": "/docs/compare/?release=9.5.17#9.5.17-29e0a55b05357c67", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "60a3c6f60382c295c24869812f5f21f0", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "在适当的情况下容忍 fsync 和 sync_file_range 调用的 EINVAL 和 ENOSYS 错误结果", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}, "url": "/docs/compare/?release=9.4.22#9.4.22-29e0a55b05357c67", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-b4271b76433e0e97", "cves": [], "html": "

在 BRIN 汇总操作期间，在自动清理的 pg_stat_activity 显示中报告正确的关系名（Álvaro Herrera）

", "text": "在 BRIN 汇总操作期间，在自动清理的 pg_stat_activity 显示中报告正确的关系名（Álvaro Herrera）", "title": "在 BRIN 汇总操作期间，在自动清理的 pg_stat_activity 显示中报告正确的关系名", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "82a41d4ee6d8444f8d4d24dceb841d0aa1960c142636203a7eca45bb3b951a79", "section_path": ["变更"], "commit_groups": [["398cc6fb9", "630de1131", "98098faaf"]], "identity_text": "Report correct relation name in autovacuum's pg_stat_activity display during BRIN summarize operations (Álvaro Herrera)", "commit_aliases": ["398cc6fb9", "630de1131", "98098faaf"], "source_commits": ["630de1131"], "source_entry_id": "11.3/changes/027", "db_id": "9d7a16ced4de45fe5125f2663a88bf2c", "patch_ids": ["90cb9f04e1729eded404d6405b3aa45e"], "statement_hash": "e65cc28a7a0675735871b7a261c4cf5657d710cb8739c4b55dde08d8895bd17e", "relations": [{"rule": 2, "type": "equivalent", "target": "e80917ba17757c13de977edc70bf4b91", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e65cc28a7a0675735871b7a261c4cf5657d710cb8739c4b55dde08d8895bd17e"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e80917ba17757c13de977edc70bf4b91", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "在 BRIN 汇总操作期间，在自动清理的 pg_stat_activity 显示中报告正确的关系名", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e65cc28a7a0675735871b7a261c4cf5657d710cb8739c4b55dde08d8895bd17e"}, "url": "/docs/compare/?release=10.8#10.8-b4271b76433e0e97", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-e6dabeb014574b5f", "cves": [], "html": "

避免启用 GEQO 时尝试规划逐分区连接而发生崩溃（Tom Lane）

", "text": "避免启用 GEQO 时尝试规划逐分区连接而发生崩溃（Tom Lane）", "title": "避免启用 GEQO 时尝试规划逐分区连接而发生崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "8648e3654cd60e090482de8269464fa1220f67de7759e17f1410894d7942c529", "section_path": ["变更"], "commit_groups": [["7ad6498fd", "d70c147fa"]], "identity_text": "Avoid crash when trying to plan a partition-wise join when GEQO is active (Tom Lane)", "commit_aliases": ["7ad6498fd", "d70c147fa"], "source_commits": ["d70c147fa"], "source_entry_id": "11.3/changes/028", "db_id": "21a892f2597c2b4785e3d4ddb954c050", "patch_ids": ["3fab9de8efff88aef869ed7507b4a02c"], "statement_hash": "60fe67e1d75ddddb982419d82ee7e80d22cde06aac18db4570e95c6d997c9197", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-85bd286d93302cad", "cves": [], "html": "

修复从 FULL 外连接向外引用的横向引用导致的 “failed to build any N-way joins” 规划器失败（Tom Lane）

", "text": "修复从 FULL 外连接向外引用的横向引用导致的 “failed to build any N-way joins” 规划器失败（Tom Lane）", "title": "修复从 FULL 外连接向外引用的横向引用导致的 “failed to build any N-way joins” 规划器失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "535579c0326c23ae357551309de09e515d48ba34dcb4faa9ee9307ca73005db1", "section_path": ["变更"], "commit_groups": [["051c71c67", "23791c415", "2f78974e2", "45f8eaa8e", "68e745ed0", "c6df3a28f"]], "identity_text": "Fix failed to build any N-way joins planner failures with lateral references leading out of FULL outer joins (Tom Lane)", "commit_aliases": ["051c71c67", "23791c415", "2f78974e2", "45f8eaa8e", "68e745ed0", "c6df3a28f"], "source_commits": ["68e745ed0"], "source_entry_id": "11.3/changes/029", "db_id": "eecfb9f41a9c8fbf59fcc48f93a6f07b", "patch_ids": ["b0dfa57cf83f0abf0491debaf4e47504"], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b", "relations": [{"rule": 2, "type": "equivalent", "target": "0cb6b648d9303b8cf23472cad87f142c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}}, {"rule": 2, "type": "equivalent", "target": "1a2c43e83a2ae578bc39dab49a27b002", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}}, {"rule": 2, "type": "equivalent", "target": "8192e4ce0a3123f59698b983babe3d1f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}}, {"rule": 2, "type": "equivalent", "target": "dd12ef759ba5ee4b6f1a7945c470ca05", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "1a2c43e83a2ae578bc39dab49a27b002", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复从 FULL 外连接向外引用的横向引用导致的 “failed to build any N-way joins” 规划器失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}, "url": "/docs/compare/?release=10.8#10.8-85bd286d93302cad", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "8192e4ce0a3123f59698b983babe3d1f", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复 FULL 外连接中通向外部横向引用导致的 “failed to build any N-way joins” 规划器失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}, "url": "/docs/compare/?release=9.6.13#9.6.13-208a299c4634aa04", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "0cb6b648d9303b8cf23472cad87f142c", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复 FULL 外连接中通向外部横向引用导致的 “failed to build any N-way joins” 规划器失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}, "url": "/docs/compare/?release=9.5.17#9.5.17-208a299c4634aa04", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "dd12ef759ba5ee4b6f1a7945c470ca05", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复 FULL 外连接中通向外部横向引用导致的 “failed to build any N-way joins” 规划器失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}, "url": "/docs/compare/?release=9.4.22#9.4.22-208a299c4634aa04", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-f83ddcd0152434af", "cves": [], "html": "

修复将返回集合的函数应用于可证明为空的关系时的查询规划错误（Tom Lane，Julien Rouhaud）

\n

在 v10 中，这一疏漏仅导致计划效率略低，但在 v11 中可能引发 “set-valued function called in context that cannot accept a set” 错误。

", "text": "修复将返回集合的函数应用于可证明为空的关系时的查询规划错误（Tom Lane，Julien Rouhaud） 在 v10 中，这一疏漏仅导致计划效率略低，但在 v11 中可能引发 “set-valued function called in context that cannot accept a set” 错误。", "title": "修复将返回集合的函数应用于可证明为空的关系时的查询规划错误", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "05de92f7c5bf76598f069c7d2794ba8fea577ca75e54efbcea00aeda8b739f5d", "section_path": ["变更"], "commit_groups": [["19ff710aa", "1d3385840", "925f46ffb"]], "identity_text": "Fix misplanning of queries in which a set-returning function is applied to a relation that is provably empty (Tom Lane, Julien Rouhaud) In v10, this oversight only led to slightly inefficient plans, but in v11 it could cause set-valued function called in context that cannot accept a set errors.", "commit_aliases": ["19ff710aa", "1d3385840", "925f46ffb"], "source_commits": ["925f46ffb"], "source_entry_id": "11.3/changes/030", "db_id": "267658a5e60e719010cbcc9405f4c8c7", "patch_ids": ["878dc319f39bfa27222871b43fd84480"], "statement_hash": "b2b9c591f66af5af1d55bbd2f259057317ad8721504483858b415affd973746a", "relations": [{"rule": 2, "type": "equivalent", "target": "d95c8712a535c57e96ddfa2002d3cb85", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2b9c591f66af5af1d55bbd2f259057317ad8721504483858b415affd973746a"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d95c8712a535c57e96ddfa2002d3cb85", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复将返回集合的函数应用于可证明为空的关系时的查询规划错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2b9c591f66af5af1d55bbd2f259057317ad8721504483858b415affd973746a"}, "url": "/docs/compare/?release=10.8#10.8-f83ddcd0152434af", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-45a520da4a2291fd", "cves": [], "html": "

执行有关是否允许可能泄漏信息的操作符访问 pg_statistic 数据的规则时，检查正确用户的权限（Dean Rasheed）

\n

通过视图访问底层表时，在决定能否将可能泄漏信息的操作符应用于该表的统计数据时，应考虑视图所有者的权限，而非发出查询的用户的权限。这使规划器关于数据可见性的规则与执行器一致，避免不必要的低效计划。

", "text": "执行有关是否允许可能泄漏信息的操作符访问 pg_statistic 数据的规则时，检查正确用户的权限（Dean Rasheed） 通过视图访问底层表时，在决定能否将可能泄漏信息的操作符应用于该表的统计数据时，应考虑视图所有者的权限，而非发出查询的用户的权限。这使规划器关于数据可见性的规则与执行器一致，避免不必要的低效计划。", "title": "执行有关是否允许可能泄漏信息的操作符访问 pg_statistic 数据的规则时，检查正确用户的权限", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "f5f4ba3aed4626254473cbc0fbe4db725a479ae844175e43f72609c7f6953878", "section_path": ["变更"], "commit_groups": [["01256815a", "3c0999909", "71185228c", "98dad4cd4", "a0905056f", "ca74e3e0f"]], "identity_text": "Check the appropriate user's permissions when enforcing rules about letting a leaky operator see pg_statistic data (Dean Rasheed) When an underlying table is being accessed via a view, consider the privileges of the view owner while deciding whether leaky operators may be applied to the table's statistics data, rather than the privileges of the user making the query. This makes the planner's rules about what data is visible match up with the executor's, avoiding unnecessarily-poor plans.", "commit_aliases": ["01256815a", "3c0999909", "71185228c", "98dad4cd4", "a0905056f", "ca74e3e0f"], "source_commits": ["98dad4cd4"], "source_entry_id": "11.3/changes/031", "db_id": "82a11df8b6eb395c717e913682c85746", "patch_ids": ["6f8115768825c1defb748946405c09e2"], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297", "relations": [{"rule": 2, "type": "equivalent", "target": "2ac62b291959e2b42bd5d570b4525b29", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}}, {"rule": 2, "type": "equivalent", "target": "8ae64947930d744dc7a28f2f3bc0f784", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}}, {"rule": 2, "type": "equivalent", "target": "bb0e3dc3b27ee2c7ae8efe94eddf109a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}}, {"rule": 2, "type": "equivalent", "target": "c21225fa999e76d5dba772549c6fdd9d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "2ac62b291959e2b42bd5d570b4525b29", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "执行有关是否允许可能泄漏信息的操作符访问 pg_statistic 数据的规则时，检查正确用户的权限", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}, "url": "/docs/compare/?release=10.8#10.8-45a520da4a2291fd", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "bb0e3dc3b27ee2c7ae8efe94eddf109a", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "在执行关于让泄漏型操作符看到 pg_statistic 数据的规则时，检查正确用户的权限", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}, "url": "/docs/compare/?release=9.6.13#9.6.13-f0907dba055e192c", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "c21225fa999e76d5dba772549c6fdd9d", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "在执行关于让泄漏型操作符看到 pg_statistic 数据的规则时，检查正确用户的权限", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}, "url": "/docs/compare/?release=9.5.17#9.5.17-f0907dba055e192c", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "8ae64947930d744dc7a28f2f3bc0f784", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "在执行关于让泄漏型操作符看到 pg_statistic 数据的规则时，检查正确用户的权限", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}, "url": "/docs/compare/?release=9.4.22#9.4.22-f0907dba055e192c", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-4fdb53d26a4dc841", "cves": [], "html": "

修复规划器对分组查询的并行安全性评估（Etsuro Fujita）

\n

以前，可以并行执行的目标列表求值工作可能未得到并行执行。

", "text": "修复规划器对分组查询的并行安全性评估（Etsuro Fujita） 以前，可以并行执行的目标列表求值工作可能未得到并行执行。", "title": "修复规划器对分组查询的并行安全性评估", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "b95baf0414d69ad2f38e56a3c74c91215ad9e9424b2c5e50099ff0f8dbf7393b", "section_path": ["变更"], "commit_groups": [["b5afdde6a", "fd1eaf920"]], "identity_text": "Fix planner's parallel-safety assessment for grouped queries (Etsuro Fujita) Previously, target-list evaluation work that could have been parallelized might not be.", "commit_aliases": ["b5afdde6a", "fd1eaf920"], "source_commits": ["fd1eaf920"], "source_entry_id": "11.3/changes/032", "db_id": "dd5738a249491651de525bc1c860e546", "patch_ids": ["73f727d7ec2e619f7540a3ea90da2370"], "statement_hash": "875224c629b7f5615395535dc7a2005cddefb44be80b9c4f29258d0fbe129c6b", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-0b6cfca17ba6fb03", "cves": [], "html": "

修复规划器的唯一索引逻辑中对“内含”索引列的不正确处理（Tom Lane）

\n

这可能导致无法识别带有内含列的唯一索引能够证明查询结果唯一，从而产生低效计划。

", "text": "修复规划器的唯一索引逻辑中对“内含”索引列的不正确处理（Tom Lane） 这可能导致无法识别带有内含列的唯一索引能够证明查询结果唯一，从而产生低效计划。", "title": "修复规划器的唯一索引逻辑中对“内含”索引列的不正确处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "c6ab100c38e3419f10d3c42353ffa3531690d70796d40d581e189ff9aa06e518", "section_path": ["变更"], "commit_groups": [["364857f73", "75c46149f"]], "identity_text": "Fix mishandling of included index columns in planner's unique-index logic (Tom Lane) This could result in failing to recognize that a unique index with included columns proves uniqueness of a query result, leading to a poor plan.", "commit_aliases": ["364857f73", "75c46149f"], "source_commits": ["364857f73"], "source_entry_id": "11.3/changes/033", "db_id": "6adaf9264fa520c10220f4cc8ae81bff", "patch_ids": ["750ef6a61af6e7c5f58a4adbd96272aa"], "statement_hash": "3af6b408b001cdf691d56577d00a04391635efd5918b5bbe1364a4e3037c3c6a", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-b70873e816eb5465", "cves": [], "html": "

修复对数组强制转换表达式的不正确严格性检查（Tom Lane）

\n

例如，这可能允许错误地内联严格 SQL 函数，导致未实施严格性条件。

", "text": "修复对数组强制转换表达式的不正确严格性检查（Tom Lane） 例如，这可能允许错误地内联严格 SQL 函数，导致未实施严格性条件。", "title": "修复对数组强制转换表达式的不正确严格性检查", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "dca2105f5127e2cb5e4b3ccfc4dfc9500231cb9c1f3e2de406f22695c8809e12", "section_path": ["变更"], "commit_groups": [["1571bc0f0", "93ec0c90c"]], "identity_text": "Fix incorrect strictness check for array coercion expressions (Tom Lane) This might allow, for example, incorrect inlining of a strict SQL function, leading to non-enforcement of the strictness condition.", "commit_aliases": ["1571bc0f0", "93ec0c90c"], "source_commits": ["93ec0c90c"], "source_entry_id": "11.3/changes/034", "db_id": "80bb3a1f250ca1c264cc550cb4e6d6e5", "patch_ids": ["194e853e3667ee1eac7ca0bd51ff4670"], "statement_hash": "6fdcb2809a29b36acda797a479b589a0fbbbec8cf10b220bdc931b1557c3e16e", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-60e7e60e1bbf2022", "cves": [], "html": "

在存在大量相等条件和大量可能相关的外键约束时，加快规划速度（David Rowley）

", "text": "在存在大量相等条件和大量可能相关的外键约束时，加快规划速度（David Rowley）", "title": "在存在大量相等条件和大量可能相关的外键约束时，加快规划速度", "commits": [], "section": "变更", "category": "performance", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "bba494012242af7d62f385f17b0a3cf8a8d223ee5dc1f7ced94cde98e104df95", "section_path": ["变更"], "commit_groups": [["09c9dd39e", "affee8b14", "e22bfe94e", "fa86238f1"]], "identity_text": "Speed up planning when there are many equality conditions and many potentially-relevant foreign key constraints (David Rowley)", "commit_aliases": ["09c9dd39e", "affee8b14", "e22bfe94e", "fa86238f1"], "source_commits": ["e22bfe94e"], "source_entry_id": "11.3/changes/035", "db_id": "51dab45d01a5dbab590304db96f9f1f9", "patch_ids": ["ecba17d0f24526c213c2743a1a9f7457"], "statement_hash": "a955702ba63c86002b2b7946f4f1c7d58a442511bf1f94e5ee9ea7ce3f704953", "relations": [{"rule": 2, "type": "equivalent", "target": "8d0293d89a14bb59d91b527fc7972dfa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a955702ba63c86002b2b7946f4f1c7d58a442511bf1f94e5ee9ea7ce3f704953"}}, {"rule": 2, "type": "equivalent", "target": "ba5dabdacfc661f7d7fad521f7e8ccbb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a955702ba63c86002b2b7946f4f1c7d58a442511bf1f94e5ee9ea7ce3f704953"}}], "version": "11.3", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "8d0293d89a14bb59d91b527fc7972dfa", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "在存在大量相等条件和大量可能相关的外键约束时，加快规划速度", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a955702ba63c86002b2b7946f4f1c7d58a442511bf1f94e5ee9ea7ce3f704953"}, "url": "/docs/compare/?release=10.8#10.8-60e7e60e1bbf2022", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "ba5dabdacfc661f7d7fad521f7e8ccbb", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "加快存在许多等值条件和许多潜在相关外键约束时的规划", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a955702ba63c86002b2b7946f4f1c7d58a442511bf1f94e5ee9ea7ce3f704953"}, "url": "/docs/compare/?release=9.6.13#9.6.13-3717779bbca5b580", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}]}, {"id": "11.3-5bdcb5c157afa8cc", "cves": [], "html": "

避免回滚创建了大量表的事务时发生 O(N^2) 性能问题（Tomas Vondra）

", "text": "避免回滚创建了大量表的事务时发生 O(N^2) 性能问题（Tomas Vondra）", "title": "避免回滚创建了大量表的事务时发生 O(N^2) 性能问题", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "0a0799e722dcdd0d1a3fe548c82549fd88eee0f5f98b3980773248d03a7ea6bd", "section_path": ["变更"], "commit_groups": [["0a5dcb87a", "261aa218c", "31737eb43", "5601f9fb9", "6ca015f9f", "fb0b5b0b8"]], "identity_text": "Avoid O(N^2) performance issue when rolling back a transaction that created many tables (Tomas Vondra)", "commit_aliases": ["0a5dcb87a", "261aa218c", "31737eb43", "5601f9fb9", "6ca015f9f", "fb0b5b0b8"], "source_commits": ["fb0b5b0b8"], "source_entry_id": "11.3/changes/036", "db_id": "b52433722fe51b4a45700e2bc72412e5", "patch_ids": ["fda8606b4b7ea8510b532e251dca0a42"], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57", "relations": [{"rule": 2, "type": "equivalent", "target": "588eab874ea30b97c5da35700ce3cf02", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}}, {"rule": 2, "type": "equivalent", "target": "6c30ef376fcdedb817a2c92d79c67584", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}}, {"rule": 2, "type": "equivalent", "target": "af1c93470a8abc26cc75d84110c7f0e4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}}, {"rule": 2, "type": "equivalent", "target": "f8304c42793de38c12b35e00ae63b588", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "6c30ef376fcdedb817a2c92d79c67584", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "避免回滚创建了大量表的事务时发生 O(N^2) 性能问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}, "url": "/docs/compare/?release=10.8#10.8-5bdcb5c157afa8cc", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "af1c93470a8abc26cc75d84110c7f0e4", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "避免回滚创建了许多表的事务时的 O(N^2) 性能问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}, "url": "/docs/compare/?release=9.6.13#9.6.13-665d513f526998a0", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "588eab874ea30b97c5da35700ce3cf02", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "避免回滚创建了许多表的事务时的 O(N^2) 性能问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}, "url": "/docs/compare/?release=9.5.17#9.5.17-665d513f526998a0", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "f8304c42793de38c12b35e00ae63b588", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "避免回滚创建了许多表的事务时的 O(N^2) 性能问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}, "url": "/docs/compare/?release=9.4.22#9.4.22-665d513f526998a0", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-e7255648e86761df", "cves": [], "html": "

修复动态共享内存分配中边界情况下的服务器崩溃（Thomas Munro，Robert Haas）

", "text": "修复动态共享内存分配中边界情况下的服务器崩溃（Thomas Munro，Robert Haas）", "title": "修复动态共享内存分配中边界情况下的服务器崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "2aca7be7e40435bcf82e28525011453a3460b3a1d88ed29baec76b52d3a92958", "section_path": ["变更"], "commit_groups": [["29ddb548f", "406e937d1", "50ae61903"], ["2cfdf24e7", "7215efdc0", "b8386b036"]], "identity_text": "Fix corner-case server crashes in dynamic shared memory allocation (Thomas Munro, Robert Haas)", "commit_aliases": ["29ddb548f", "2cfdf24e7", "406e937d1", "50ae61903", "7215efdc0", "b8386b036"], "source_commits": ["50ae61903", "b8386b036"], "source_entry_id": "11.3/changes/037", "db_id": "a94fdb71ef3f00262fc12818a361b77c", "patch_ids": ["7689f45c342245f1f74125b5602633b8", "b52bc58b00592d5455b06b2238602ecb"], "statement_hash": "6ce40a350ea16cd7ab2b614a81b07a55042f15f0669b3e24077c8a33d1a23063", "relations": [{"rule": 2, "type": "equivalent", "target": "150d10f7f8ac7bef1eeceb36f4dfe92b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ce40a350ea16cd7ab2b614a81b07a55042f15f0669b3e24077c8a33d1a23063"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "150d10f7f8ac7bef1eeceb36f4dfe92b", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复动态共享内存分配中边界情况下的服务器崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ce40a350ea16cd7ab2b614a81b07a55042f15f0669b3e24077c8a33d1a23063"}, "url": "/docs/compare/?release=10.8#10.8-e7255648e86761df", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-54a3837eaceace0a", "cves": [], "html": "

修复动态共享内存管理中的竞争条件（Thomas Munro）

\n

这些问题可能导致 “dsa_area could not attach to segment” 或 “cannot unpin a segment that is not pinned” 错误。

", "text": "修复动态共享内存管理中的竞争条件（Thomas Munro） 这些问题可能导致 “dsa_area could not attach to segment” 或 “cannot unpin a segment that is not pinned” 错误。", "title": "修复动态共享内存管理中的竞争条件", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "fba32d0bd335bb64200694bc6f00f193daf44a963d3b96ec6f672a27040e9f7d", "section_path": ["变更"], "commit_groups": [["0b55aaace", "1d93d1804", "7718a9920"], ["6c0fb9418", "b7c8766d3", "bd195071f", "cb0680573", "cb3d674e1", "faf132449"]], "identity_text": "Fix race conditions in management of dynamic shared memory (Thomas Munro) These could lead to dsa_area could not attach to segment or cannot unpin a segment that is not pinned errors.", "commit_aliases": ["0b55aaace", "1d93d1804", "6c0fb9418", "7718a9920", "b7c8766d3", "bd195071f", "cb0680573", "cb3d674e1", "faf132449"], "source_commits": ["1d93d1804", "faf132449"], "source_entry_id": "11.3/changes/038", "db_id": "fc58f5aef290612b3a8d9e6d974bd45b", "patch_ids": ["4b7437f48a01ac3ffa8f84d0c6fc5db7", "fae0bfa787250496f8cf42cdfa162110"], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823", "relations": [{"rule": 2, "type": "equivalent", "target": "630d5a03e93105f0f4b107ca566b54e8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}}, {"rule": 2, "type": "equivalent", "target": "63fefdc37f83475bd41c2529d4f93aaa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}}, {"rule": 2, "type": "equivalent", "target": "ac4887b5233fd51fdad71c24ae93601a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}}, {"rule": 2, "type": "equivalent", "target": "b713a0c3524da4af76af18c9b9db2a78", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "630d5a03e93105f0f4b107ca566b54e8", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复动态共享内存管理中的竞争条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}, "url": "/docs/compare/?release=10.8#10.8-54a3837eaceace0a", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "b713a0c3524da4af76af18c9b9db2a78", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复动态共享内存管理中的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}, "url": "/docs/compare/?release=9.6.13#9.6.13-50de979ef5d58f5a", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "ac4887b5233fd51fdad71c24ae93601a", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复动态共享内存管理中的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}, "url": "/docs/compare/?release=9.5.17#9.5.17-50de979ef5d58f5a", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "63fefdc37f83475bd41c2529d4f93aaa", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复动态共享内存管理中的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}, "url": "/docs/compare/?release=9.4.22#9.4.22-50de979ef5d58f5a", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-78fdfc022e6a9cf8", "cves": [], "html": "

修复热备 postmaster 收到 smart 关闭请求后可能无法关闭的竞争条件（Tom Lane）

", "text": "修复热备 postmaster 收到 smart 关闭请求后可能无法关闭的竞争条件（Tom Lane）", "title": "修复热备 postmaster 收到 smart 关闭请求后可能无法关闭的竞争条件", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "496112ac9aac808fb1c903ee9d439ab3ec3c26faaaad842d08f6fc47f22d0321", "section_path": ["变更"], "commit_groups": [["0fae84623", "a0bbd012d", "c7e38be4d", "ec537c1e8", "f0c82454d", "f8642fb17"]], "identity_text": "Fix race condition in which a hot-standby postmaster could fail to shut down after receiving a smart-shutdown request (Tom Lane)", "commit_aliases": ["0fae84623", "a0bbd012d", "c7e38be4d", "ec537c1e8", "f0c82454d", "f8642fb17"], "source_commits": ["f8642fb17"], "source_entry_id": "11.3/changes/039", "db_id": "7607635df0027eef0b0a3dc43947171d", "patch_ids": ["8d864f9d32a31d54885ff908a118e54c"], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab", "relations": [{"rule": 2, "type": "equivalent", "target": "409d1b88be429d1cb8a579ce0c84375a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}}, {"rule": 2, "type": "equivalent", "target": "4210c401558dc70edeb64e47f7c9e0a4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}}, {"rule": 2, "type": "equivalent", "target": "5906def93ef172dbb220b101673f9184", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}}, {"rule": 2, "type": "equivalent", "target": "e76ac9b8a7fab050e52964f6710ffe84", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "4210c401558dc70edeb64e47f7c9e0a4", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复热备 postmaster 收到 smart 关闭请求后可能无法关闭的竞争条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}, "url": "/docs/compare/?release=10.8#10.8-78fdfc022e6a9cf8", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "5906def93ef172dbb220b101673f9184", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复热备 postmaster 收到 smart 关闭请求后可能不关闭的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}, "url": "/docs/compare/?release=9.6.13#9.6.13-9e8c059340aa0a9a", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "409d1b88be429d1cb8a579ce0c84375a", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复热备 postmaster 收到 smart 关闭请求后可能不关闭的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}, "url": "/docs/compare/?release=9.5.17#9.5.17-9e8c059340aa0a9a", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "e76ac9b8a7fab050e52964f6710ffe84", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复热备 postmaster 收到 smart 关闭请求后可能不关闭的竞态条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}, "url": "/docs/compare/?release=9.4.22#9.4.22-9e8c059340aa0a9a", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-fbf3fd803374216d", "cves": [], "html": "

修复 pg_identify_object_as_address() 收到无效输入时可能发生的崩溃（Álvaro Herrera）

", "text": "修复 pg_identify_object_as_address() 收到无效输入时可能发生的崩溃（Álvaro Herrera）", "title": "修复 pg_identify_object_as_address() 收到无效输入时可能发生的崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "375ece23e5a052b030f1efbe2fb1fa31dfa5b9d736b3d4fd63443a95669c591a", "section_path": ["变更"], "commit_groups": [["545928bbb", "5721b9b3c", "728ac262d", "ddad002de", "e4542ca96"]], "identity_text": "Fix possible crash when pg_identify_object_as_address() is given invalid input (Álvaro Herrera)", "commit_aliases": ["545928bbb", "5721b9b3c", "728ac262d", "ddad002de", "e4542ca96"], "source_commits": ["728ac262d"], "source_entry_id": "11.3/changes/040", "db_id": "59848af8f80ec3fd0cee55ef653e5bd9", "patch_ids": ["0aa23360d77ae8a503250d0c39c41b76"], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf", "relations": [{"rule": 2, "type": "equivalent", "target": "72161c17cb9ec7a261eceabc9771f1a6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf"}}, {"rule": 2, "type": "equivalent", "target": "96ab96aef752a4b9b7acf02295bbd682", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf"}}, {"rule": 2, "type": "equivalent", "target": "9c832569ec2852a998b291ca6dbb4cf8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "72161c17cb9ec7a261eceabc9771f1a6", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复 pg_identify_object_as_address() 收到无效输入时可能发生的崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf"}, "url": "/docs/compare/?release=10.8#10.8-fbf3fd803374216d", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "9c832569ec2852a998b291ca6dbb4cf8", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复给 pg_identify_object_as_address() 无效输入时可能的崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf"}, "url": "/docs/compare/?release=9.6.13#9.6.13-b4c7fcd8e2c01d2b", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "96ab96aef752a4b9b7acf02295bbd682", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复给 pg_identify_object_as_address() 无效输入时可能的崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf"}, "url": "/docs/compare/?release=9.5.17#9.5.17-b4c7fcd8e2c01d2b", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}]}, {"id": "11.3-dc0ddf8aad819a2f", "cves": [], "html": "

修复 txid_status() 中可能发生的 “could not access status of transaction” 失败（Thomas Munro）

", "text": "修复 txid_status() 中可能发生的 “could not access status of transaction” 失败（Thomas Munro）", "title": "修复 txid_status() 中可能发生的 “could not access status of transaction” 失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "2fa651dbcafcd0ec90e8b12f5c49f9b007808ee995770ec0f4c974bcacdde7cb", "section_path": ["变更"], "commit_groups": [["26d4fda37", "339927797", "d2fd7f74e"]], "identity_text": "Fix possible could not access status of transaction failures in txid_status() (Thomas Munro)", "commit_aliases": ["26d4fda37", "339927797", "d2fd7f74e"], "source_commits": ["26d4fda37"], "source_entry_id": "11.3/changes/041", "db_id": "d8c1dbc7d003b6600c3e9a4da77ab5df", "patch_ids": ["fb71b4b2db4e1c6fb9ef70c1adbdf353"], "statement_hash": "75c9f260b19476eb36875c67dcdb1c8a8aa2b8fc2e22c9cfb9a91e154de835fc", "relations": [{"rule": 2, "type": "equivalent", "target": "66d9e356774b2071e1dbebdf5734cddf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75c9f260b19476eb36875c67dcdb1c8a8aa2b8fc2e22c9cfb9a91e154de835fc"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "66d9e356774b2071e1dbebdf5734cddf", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复 txid_status() 中可能发生的 “could not access status of transaction” 失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75c9f260b19476eb36875c67dcdb1c8a8aa2b8fc2e22c9cfb9a91e154de835fc"}, "url": "/docs/compare/?release=10.8#10.8-dc0ddf8aad819a2f", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-33253e183bd5e910", "cves": [], "html": "

修复混用不同 OpenSSL 库版本时尝试使用 SCRAM 认证所导致的认证失败（Michael Paquier，Peter Eisentraut）

\n

如果 libpq 使用 OpenSSL 1.0.1 或更旧版本，而服务器使用 OpenSSL 1.0.2 或更新版本，则协商所用 SASL 机制的过程会出错，导致令人困惑的 “channel binding not supported by this build” 错误消息。

", "text": "修复混用不同 OpenSSL 库版本时尝试使用 SCRAM 认证所导致的认证失败（Michael Paquier，Peter Eisentraut） 如果 libpq 使用 OpenSSL 1.0.1 或更旧版本，而服务器使用 OpenSSL 1.0.2 或更新版本，则协商所用 SASL 机制的过程会出错，导致令人困惑的 “channel binding not supported by this build” 错误消息。", "title": "修复混用不同 OpenSSL 库版本时尝试使用 SCRAM 认证所导致的认证失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "7c0c0f296a68516f7b57c512806c8eb16ffca1345572eda7ed4e998b896f521b", "section_path": ["变更"], "commit_groups": [["87c346a35", "d9bba27c8"]], "identity_text": "Fix authentication failure when attempting to use SCRAM authentication with mixed OpenSSL library versions (Michael Paquier, Peter Eisentraut) If libpq is using OpenSSL 1.0.1 or older while the server is using OpenSSL 1.0.2 or newer, the negotiation of which SASL mechanism to use went wrong, leading to a confusing channel binding not supported by this build error message.", "commit_aliases": ["87c346a35", "d9bba27c8"], "source_commits": ["d9bba27c8"], "source_entry_id": "11.3/changes/042", "db_id": "e6bcf2e46ded7b492215abd73ede9865", "patch_ids": ["c43489e05e0564169a2020e6e2dda3b7"], "statement_hash": "00f39589dc30f02dc0e4e290201642a5784fcd0f59bb5b5cd0e6ee2f3b9b0a3a", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-954f6844cb0eccce", "cves": [], "html": "

加强对已编码的 SCRAM-SHA-256 和 MD5 密码的验证（Jonathan Katz）

\n

只要密码字符串以相应字符开头，就可能被误认为已通过 hash 运算正确转换为 SCRAM-SHA-256 或 MD5 格式。这样的密码会被接受，但之后无法使用。

", "text": "加强对已编码的 SCRAM-SHA-256 和 MD5 密码的验证（Jonathan Katz） 只要密码字符串以相应字符开头，就可能被误认为已通过 hash 运算正确转换为 SCRAM-SHA-256 或 MD5 格式。这样的密码会被接受，但之后无法使用。", "title": "加强对已编码的 SCRAM-SHA-256 和 MD5 密码的验证", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "f463d756cdb1a35d6b32049f4057cd212d3131f41f2013a3e0fff27e9fbdc58e", "section_path": ["变更"], "commit_groups": [["15fe91e70", "20dbc84bd", "7f56d4366", "a82c06f40", "af298f00a", "ccae190b9"]], "identity_text": "Tighten validation of encoded SCRAM-SHA-256 and MD5 passwords (Jonathan Katz) A password string that had the right initial characters could be mistaken for one that is correctly hashed into SCRAM-SHA-256 or MD5 format. The password would be accepted but would be unusable later.", "commit_aliases": ["15fe91e70", "20dbc84bd", "7f56d4366", "a82c06f40", "af298f00a", "ccae190b9"], "source_commits": ["7f56d4366"], "source_entry_id": "11.3/changes/043", "db_id": "63fa62fd1be046c468accff4643e3276", "patch_ids": ["3448b35b1f6749c847456d430b0eeaf2"], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722", "relations": [{"rule": 2, "type": "equivalent", "target": "065b7d60883bb6a234a85b51fd294973", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}}, {"rule": 2, "type": "equivalent", "target": "88fc7b91a4bd261e7cdca2cec81c944d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}}, {"rule": 2, "type": "equivalent", "target": "d0fffaf8c56845733b5b0ae89fb03fd4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}}, {"rule": 2, "type": "equivalent", "target": "d5dd143586ce3867905acd5c5351068b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "88fc7b91a4bd261e7cdca2cec81c944d", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "加强对已编码的 SCRAM-SHA-256 和 MD5 密码的验证", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}, "url": "/docs/compare/?release=10.8#10.8-954f6844cb0eccce", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "065b7d60883bb6a234a85b51fd294973", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "收紧对编码后的 SCRAM-SHA-256 和 MD5 口令的验证", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}, "url": "/docs/compare/?release=9.6.13#9.6.13-40b00fe0c2b0c3b7", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "d5dd143586ce3867905acd5c5351068b", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "收紧对编码后的 SCRAM-SHA-256 和 MD5 口令的验证", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}, "url": "/docs/compare/?release=9.5.17#9.5.17-40b00fe0c2b0c3b7", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "d0fffaf8c56845733b5b0ae89fb03fd4", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "收紧对编码后的 SCRAM-SHA-256 和 MD5 口令的验证", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}, "url": "/docs/compare/?release=9.4.22#9.4.22-40b00fe0c2b0c3b7", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-c71a9dbe067f738c", "cves": [], "html": "

修复对隐含编码不同于数据库编码的 lc_time 设置的处理（Juan José Santamaría Flecha，Tom Lane）

\n

在此类区域设置下，包含非 ASCII 字符的本地化月份名或星期名以前会导致意外错误或错误输出。

", "text": "修复对隐含编码不同于数据库编码的 lc_time 设置的处理（Juan José Santamaría Flecha，Tom Lane） 在此类区域设置下，包含非 ASCII 字符的本地化月份名或星期名以前会导致意外错误或错误输出。", "title": "修复对隐含编码不同于数据库编码的 lc_time 设置的处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "fc8abcb4bf9c610a219a01b7a2319d1ea36fe9be04a11e4dde1a5069bc64b615", "section_path": ["变更"], "commit_groups": [["1e5de9662", "74589026f", "7ad1cd31b", "7c02c3f75", "c0bafc5e5", "e899df6a2"]], "identity_text": "Fix handling of lc_time settings that imply an encoding different from the database's encoding (Juan José Santamaría Flecha, Tom Lane) Localized month or day names that include non-ASCII characters previously caused unexpected errors or wrong output in such locales.", "commit_aliases": ["1e5de9662", "74589026f", "7ad1cd31b", "7c02c3f75", "c0bafc5e5", "e899df6a2"], "source_commits": ["e899df6a2"], "source_entry_id": "11.3/changes/044", "db_id": "fd5ae8340036928149041c1a7238147f", "patch_ids": ["2c24fcefa8b367b2bacdc18903c45df5"], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c", "relations": [{"rule": 2, "type": "equivalent", "target": "6023434703ae142d685b77bcd27e729c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}}, {"rule": 2, "type": "equivalent", "target": "7928a410fb9ffc83b0332e3e8235b74a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}}, {"rule": 2, "type": "equivalent", "target": "88a324d0d1fd64bef65047993db1b1dd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}}, {"rule": 2, "type": "equivalent", "target": "aa42c33d3829f46203fdb823259d21f2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6023434703ae142d685b77bcd27e729c", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复对隐含编码不同于数据库编码的 lc_time 设置的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}, "url": "/docs/compare/?release=10.8#10.8-c71a9dbe067f738c", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "aa42c33d3829f46203fdb823259d21f2", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复对隐含与数据库编码不同的编码的 lc_time 设置的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}, "url": "/docs/compare/?release=9.6.13#9.6.13-7daecba97eeaf800", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "7928a410fb9ffc83b0332e3e8235b74a", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复对隐含与数据库编码不同的编码的 lc_time 设置的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}, "url": "/docs/compare/?release=9.5.17#9.5.17-7daecba97eeaf800", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "88a324d0d1fd64bef65047993db1b1dd", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复对隐含与数据库编码不同的编码的 lc_time 设置的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}, "url": "/docs/compare/?release=9.4.22#9.4.22-7daecba97eeaf800", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-d53eb3eef4207104", "cves": [], "html": "

以与服务器数据目录中其他文件相同的权限创建 current_logfiles 文件（Haribabu Kommi）

\n

以前，它使用 log_file_mode 指定的权限，但这可能给备份工具带来问题。

", "text": "以与服务器数据目录中其他文件相同的权限创建 current_logfiles 文件（Haribabu Kommi） 以前，它使用 log_file_mode 指定的权限，但这可能给备份工具带来问题。", "title": "以与服务器数据目录中其他文件相同的权限创建 current_logfiles 文件", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "f26500e315607d1d38d510fea34cf248e006b306032a3982cd424db2db6ba10f", "section_path": ["变更"], "commit_groups": [["276d2e6c2", "7d7435c5c"]], "identity_text": "Create the current_logfiles file with the same permissions as other files in the server's data directory (Haribabu Kommi) Previously it used the permissions specified by log_file_mode, but that can cause problems for backup utilities.", "commit_aliases": ["276d2e6c2", "7d7435c5c"], "source_commits": ["7d7435c5c"], "source_entry_id": "11.3/changes/045", "db_id": "708245e24a2924c6bd30a468d86383b3", "patch_ids": ["369c68a1410a7d70227389b0dd20d2f6"], "statement_hash": "ea227433452fb3fc07edee44522ec4d31d2573ab74532c2329c6df84621d5257", "relations": [], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-e70623a99d6fa6c4", "cves": [], "html": "

修复涉及一元负号操作符时不正确的 operator_precedence_warning 检查（Rikard Falkeborn）

", "text": "修复涉及一元负号操作符时不正确的 operator_precedence_warning 检查（Rikard Falkeborn）", "title": "修复涉及一元负号操作符时不正确的 operator_precedence_warning 检查", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "27a3bbfb47fa1625a4effdd45cbd0ed4ced2dafb28c324c2d1bb53c47ab10e72", "section_path": ["变更"], "commit_groups": [["4cae471d1", "62d495395", "930930c47", "99bbff5c1", "b9b7fe8ca"]], "identity_text": "Fix incorrect operator_precedence_warning checks involving unary minus operators (Rikard Falkeborn)", "commit_aliases": ["4cae471d1", "62d495395", "930930c47", "99bbff5c1", "b9b7fe8ca"], "source_commits": ["930930c47"], "source_entry_id": "11.3/changes/046", "db_id": "8048f6693e651a4e4b11ab25b96232ce", "patch_ids": ["176aeecd2a4ed5e0f1f128782d4970a3"], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3", "relations": [{"rule": 2, "type": "equivalent", "target": "97ac3fcbca00af0a2809809eed32209e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3"}}, {"rule": 2, "type": "equivalent", "target": "ae82d625aa676e49dc809096cbebfbb3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3"}}, {"rule": 2, "type": "equivalent", "target": "ccc1aad313a449b492c12f6265a46a02", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ae82d625aa676e49dc809096cbebfbb3", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复涉及一元负号操作符时不正确的 operator_precedence_warning 检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3"}, "url": "/docs/compare/?release=10.8#10.8-e70623a99d6fa6c4", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "ccc1aad313a449b492c12f6265a46a02", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复涉及一元减号操作符的不正确 operator_precedence_warning 检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3"}, "url": "/docs/compare/?release=9.6.13#9.6.13-350b4ff9e25a6884", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "97ac3fcbca00af0a2809809eed32209e", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复涉及一元减号操作符的不正确 operator_precedence_warning 检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3"}, "url": "/docs/compare/?release=9.5.17#9.5.17-350b4ff9e25a6884", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}]}, {"id": "11.3-ca03bfca2ae91309", "cves": [], "html": "

禁止将 NaN 用作浮点服务器参数的值（Tom Lane）

", "text": "禁止将 NaN 用作浮点服务器参数的值（Tom Lane）", "title": "禁止将 NaN 用作浮点服务器参数的值", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "6de6b62ae758a01c2f6a2c32b85400caf47db1775fef3459e6a4160aa15caabb", "section_path": ["变更"], "commit_groups": [["5aafedc2f", "ac75959cd", "bc2232f2f", "d8f8183c0", "e04bb2616", "f9ec64df8"]], "identity_text": "Disallow NaN as a value for floating-point server parameters (Tom Lane)", "commit_aliases": ["5aafedc2f", "ac75959cd", "bc2232f2f", "d8f8183c0", "e04bb2616", "f9ec64df8"], "source_commits": ["bc2232f2f"], "source_entry_id": "11.3/changes/047", "db_id": "9b08e2a0268c251e987ab852d608c84d", "patch_ids": ["326a0b6b0017dae299282358c5ad4b6b"], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9", "relations": [{"rule": 2, "type": "equivalent", "target": "202b7c0247bddc4a0cf76a64f21b4b18", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}}, {"rule": 2, "type": "equivalent", "target": "20ac9b2452da793d7a631f7e776d1b3f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}}, {"rule": 2, "type": "equivalent", "target": "e0c82d233af86101f65c057934fb8841", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}}, {"rule": 2, "type": "equivalent", "target": "e482db374a038b89954b3f179d353be4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "20ac9b2452da793d7a631f7e776d1b3f", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "禁止将 NaN 用作浮点服务器参数的值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}, "url": "/docs/compare/?release=10.8#10.8-ca03bfca2ae91309", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "e482db374a038b89954b3f179d353be4", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "禁止把 NaN 用作浮点服务器参数的值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}, "url": "/docs/compare/?release=9.6.13#9.6.13-115e52ef9674b9d6", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "202b7c0247bddc4a0cf76a64f21b4b18", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "禁止把 NaN 用作浮点服务器参数的值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}, "url": "/docs/compare/?release=9.5.17#9.5.17-115e52ef9674b9d6", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "e0c82d233af86101f65c057934fb8841", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "禁止把 NaN 用作浮点服务器参数的值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}, "url": "/docs/compare/?release=9.4.22#9.4.22-115e52ef9674b9d6", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-d08a1a8f1cd91ea2", "cves": [], "html": "

重新安排 REINDEX 的处理，以避免重建 pg_class 的单个索引时发生断言失败（Andres Freund，Tom Lane）

", "text": "重新安排 REINDEX 的处理，以避免重建 pg_class 的单个索引时发生断言失败（Andres Freund，Tom Lane）", "title": "重新安排 REINDEX 的处理，以避免重建 pg_class 的单个索引时发生断言失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "b93137265ee2c7f5353c3bc8e3568e093bee9c023c350e5ce868f8ee7e5e7361", "section_path": ["变更"], "commit_groups": [["14323493d", "17126e089", "3dbb317d3", "670a492c5", "e7418f89f", "f495b65a5"], ["18138066f", "2bb1adfac", "5f8e84ff4", "727c155cf", "d18ef6905", "f912d7dec"], ["40230f0e2", "4b40d40b3", "5409e359f", "d18f5ff90", "d264bb51c", "d8d5e1ae5"]], "identity_text": "Rearrange REINDEX processing to avoid assertion failures when reindexing individual indexes of pg_class (Andres Freund, Tom Lane)", "commit_aliases": ["14323493d", "17126e089", "18138066f", "2bb1adfac", "3dbb317d3", "40230f0e2", "4b40d40b3", "5409e359f", "5f8e84ff4", "670a492c5", "727c155cf", "d18ef6905", "d18f5ff90", "d264bb51c", "d8d5e1ae5", "e7418f89f", "f495b65a5", "f912d7dec"], "source_commits": ["14323493d", "727c155cf", "d264bb51c"], "source_entry_id": "11.3/changes/048", "db_id": "0d9c14e676a080463b68aebdc8ecc69e", "patch_ids": ["3fac1fccf981a35ab50e80795759f93f", "5384f710e5bae2b415aa5b4e02322cc1", "8a30d0e88d11eaa7c2f900fac2e9840e"], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec", "relations": [{"rule": 2, "type": "equivalent", "target": "1cdb74cf37e275a6ba7b8924b8281df4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}}, {"rule": 2, "type": "equivalent", "target": "63abb91462054225b6ba31e96db2124a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}}, {"rule": 2, "type": "equivalent", "target": "7ec1d1430de8b555780666dcfc812d13", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}}, {"rule": 2, "type": "equivalent", "target": "bc73908224b943c5f141199c1d2306a1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "bc73908224b943c5f141199c1d2306a1", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "重新安排 REINDEX 的处理，以避免重建 pg_class 的单个索引时发生断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}, "url": "/docs/compare/?release=10.8#10.8-d08a1a8f1cd91ea2", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "63abb91462054225b6ba31e96db2124a", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "重排 REINDEX 处理，避免对 pg_class 的单个索引重建时断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}, "url": "/docs/compare/?release=9.6.13#9.6.13-656b5b0aaf6ffe67", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "1cdb74cf37e275a6ba7b8924b8281df4", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "重排 REINDEX 处理，避免对 pg_class 的单个索引重建时断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}, "url": "/docs/compare/?release=9.5.17#9.5.17-656b5b0aaf6ffe67", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "7ec1d1430de8b555780666dcfc812d13", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "重排 REINDEX 处理，避免对 pg_class 的单个索引重建时断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}, "url": "/docs/compare/?release=9.4.22#9.4.22-656b5b0aaf6ffe67", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-f174c25fa2ad7ddd", "cves": [], "html": "

修复参数化虚拟路径引发的规划器断言失败（Tom Lane）

", "text": "修复参数化虚拟路径引发的规划器断言失败（Tom Lane）", "title": "修复参数化虚拟路径引发的规划器断言失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "156560248c2711bfba683342009563d0b10fce75fa052f884db98ff3bc3352b5", "section_path": ["变更"], "commit_groups": [["0255329a7", "0a9d7e1f6", "5b866005c", "71288846e", "98f8ffa18", "d4b754c87"]], "identity_text": "Fix planner assertion failure for parameterized dummy paths (Tom Lane)", "commit_aliases": ["0255329a7", "0a9d7e1f6", "5b866005c", "71288846e", "98f8ffa18", "d4b754c87"], "source_commits": ["5b866005c"], "source_entry_id": "11.3/changes/049", "db_id": "763b084ad370bf768031dc9ee886a0ab", "patch_ids": ["8968945d6004d73b20edef69b2e1bc20"], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7", "relations": [{"rule": 2, "type": "equivalent", "target": "16ba931a3c5ed6caf32c69ad5aeaf913", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}}, {"rule": 2, "type": "equivalent", "target": "206722ce8af08e97ab934bf12d20a9ab", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}}, {"rule": 2, "type": "equivalent", "target": "95220568334a504ff69e73ababe97e46", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}}, {"rule": 2, "type": "equivalent", "target": "9fa7bc07d630d94e6fc53509af4a3fd4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "9fa7bc07d630d94e6fc53509af4a3fd4", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复参数化虚拟路径引发的规划器断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}, "url": "/docs/compare/?release=10.8#10.8-f174c25fa2ad7ddd", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "206722ce8af08e97ab934bf12d20a9ab", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复参数化虚拟路径的规划器断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}, "url": "/docs/compare/?release=9.6.13#9.6.13-8f8600b6db21c843", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "16ba931a3c5ed6caf32c69ad5aeaf913", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复参数化虚拟路径的规划器断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}, "url": "/docs/compare/?release=9.5.17#9.5.17-8f8600b6db21c843", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "95220568334a504ff69e73ababe97e46", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复参数化虚拟路径的规划器断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}, "url": "/docs/compare/?release=9.4.22#9.4.22-8f8600b6db21c843", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-d3e4951ffe3d00a9", "cves": [], "html": "

在 SnapBuildInitialSnapshot() 的结果中设置正确的测试函数（Antonin Houska）

\n

核心代码不依赖此项，但某些扩展会依赖。

", "text": "在 SnapBuildInitialSnapshot() 的结果中设置正确的测试函数（Antonin Houska） 核心代码不依赖此项，但某些扩展会依赖。", "title": "在 SnapBuildInitialSnapshot() 的结果中设置正确的测试函数", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "19aed8c0727d244b6361a5ec1e25d2e3c79cee068b9468e9cc25d903f77f48f8", "section_path": ["变更"], "commit_groups": [["03cd99a8e", "2ad57e9e9", "56fadbedb", "7ed9285c6", "a80f5c279", "f13188951"]], "identity_text": "Insert correct test function in the result of SnapBuildInitialSnapshot() (Antonin Houska) No core code cares about this, but some extensions do.", "commit_aliases": ["03cd99a8e", "2ad57e9e9", "56fadbedb", "7ed9285c6", "a80f5c279", "f13188951"], "source_commits": ["7ed9285c6"], "source_entry_id": "11.3/changes/050", "db_id": "987b55c6c7ecf552eb54f83b28f3b208", "patch_ids": ["d386fd38d4706ad19eadc8e3a8d402ef"], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9", "relations": [{"rule": 2, "type": "equivalent", "target": "86bbe9772f7bbfb35b8e92312c6fdd45", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}}, {"rule": 2, "type": "equivalent", "target": "8bf21069b627d06b340cb848bd0adf31", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}}, {"rule": 2, "type": "equivalent", "target": "a785311de6afae77f613632178cfabc3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}}, {"rule": 2, "type": "equivalent", "target": "bea9ea54569d0af1252af9a7ccc61ba8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "8bf21069b627d06b340cb848bd0adf31", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "在 SnapBuildInitialSnapshot() 的结果中设置正确的测试函数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}, "url": "/docs/compare/?release=10.8#10.8-d3e4951ffe3d00a9", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "a785311de6afae77f613632178cfabc3", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "在 SnapBuildInitialSnapshot() 的结果中插入正确的测试函数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}, "url": "/docs/compare/?release=9.6.13#9.6.13-fdb886250bb1e0fd", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "bea9ea54569d0af1252af9a7ccc61ba8", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "在 SnapBuildInitialSnapshot() 的结果中插入正确的测试函数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}, "url": "/docs/compare/?release=9.5.17#9.5.17-fdb886250bb1e0fd", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "86bbe9772f7bbfb35b8e92312c6fdd45", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "在 SnapBuildInitialSnapshot() 的结果中插入正确的测试函数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}, "url": "/docs/compare/?release=9.4.22#9.4.22-fdb886250bb1e0fd", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-2c7bdaa9af6aad3c", "cves": [], "html": "

修复 Windows 上间歇出现的 “could not reattach to shared memory” 会话启动失败（Noah Misch）

\n

此前未识别出的一个失败来源，是为进程的默认线程池创建线程栈。现在安排在不同的内存区域分配此类栈。

", "text": "修复 Windows 上间歇出现的 “could not reattach to shared memory” 会话启动失败（Noah Misch） 此前未识别出的一个失败来源，是为进程的默认线程池创建线程栈。现在安排在不同的内存区域分配此类栈。", "title": "修复 Windows 上间歇出现的 “could not reattach to shared memory” 会话启动失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "4749386bc1296bf3a8eefff8d6f6129cd5f85a1c07e3c1ac54c2817ef306637b", "section_path": ["变更"], "commit_groups": [["203886d3a", "57ebbbb8f", "617dc6d29", "7a5677818", "e45a8ff87", "f5989b379"], ["292e2000e", "3105844e2", "3318c4555", "47b6362b5", "4c9e54572", "ba3fb5d4f"]], "identity_text": "Fix intermittent could not reattach to shared memory session startup failures on Windows (Noah Misch) A previously unrecognized source of these failures is creation of thread stacks for a process's default thread pool. Arrange for such stacks to be allocated in a different memory region.", "commit_aliases": ["203886d3a", "292e2000e", "3105844e2", "3318c4555", "47b6362b5", "4c9e54572", "57ebbbb8f", "617dc6d29", "7a5677818", "ba3fb5d4f", "e45a8ff87", "f5989b379"], "source_commits": ["47b6362b5", "e45a8ff87"], "source_entry_id": "11.3/changes/051", "db_id": "37ca840f8209b068864585b7d699cb6c", "patch_ids": ["db663544381a2bcd352a7054a0c23b05", "e599121657a27bfe56fa7500bf44bb02"], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a", "relations": [{"rule": 2, "type": "equivalent", "target": "0271baa0447feba739fddee4f248c25c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}}, {"rule": 2, "type": "equivalent", "target": "662acfd1ddc55189cb802f96b14e9401", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}}, {"rule": 2, "type": "equivalent", "target": "769f1cd5750d5de9bda6b5b9744bd5e7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}}, {"rule": 2, "type": "equivalent", "target": "efdc17c862291077d58e9fd9e55ada6c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "662acfd1ddc55189cb802f96b14e9401", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复 Windows 上间歇出现的 “could not reattach to shared memory” 会话启动失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}, "url": "/docs/compare/?release=10.8#10.8-2c7bdaa9af6aad3c", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "0271baa0447feba739fddee4f248c25c", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复 Windows 上间歇性的 “could not reattach to shared memory” 会话启动失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}, "url": "/docs/compare/?release=9.6.13#9.6.13-f65ca184b9cb865f", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "769f1cd5750d5de9bda6b5b9744bd5e7", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复 Windows 上间歇性的 “could not reattach to shared memory” 会话启动失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}, "url": "/docs/compare/?release=9.5.17#9.5.17-f65ca184b9cb865f", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "efdc17c862291077d58e9fd9e55ada6c", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复 Windows 上间歇性的 “could not reattach to shared memory” 会话启动失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}, "url": "/docs/compare/?release=9.4.22#9.4.22-f65ca184b9cb865f", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-6f4dc5d09091fc92", "cves": [], "html": "

修复 Windows 上目录扫描的错误检测（Konstantin Knizhnik）

\n

缺少读取目录的权限等错误未被正确检测或报告；代码反而静默地表现得像目录为空一样。

", "text": "修复 Windows 上目录扫描的错误检测（Konstantin Knizhnik） 缺少读取目录的权限等错误未被正确检测或报告；代码反而静默地表现得像目录为空一样。", "title": "修复 Windows 上目录扫描的错误检测", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "cb964660a5b4cf06c77af22b022f86e7db123cab072738a12583aabfc8482730", "section_path": ["变更"], "commit_groups": [["754b90f65", "81f5b3283", "8722c4dac", "977f83377", "9aa59e64b", "d95133163"]], "identity_text": "Fix error detection in directory scanning on Windows (Konstantin Knizhnik) Errors, such as lack of permissions to read the directory, were not detected or reported correctly; instead the code silently acted as though the directory were empty.", "commit_aliases": ["754b90f65", "81f5b3283", "8722c4dac", "977f83377", "9aa59e64b", "d95133163"], "source_commits": ["8722c4dac"], "source_entry_id": "11.3/changes/052", "db_id": "75ce8d4b3d89d04e314ebf062c570aa0", "patch_ids": ["16148bf34ce89002d73984fbf714505e"], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe", "relations": [{"rule": 2, "type": "equivalent", "target": "2ec178c47539b29fd83d5a350b84b1e1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}}, {"rule": 2, "type": "equivalent", "target": "6e764e0a7fe284ba94b6ff71ece31c03", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}}, {"rule": 2, "type": "equivalent", "target": "e4c3862436bc6b4e73ed86867da656f8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}}, {"rule": 2, "type": "equivalent", "target": "facd74d550600fed233bff7b2b0c3fe9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e4c3862436bc6b4e73ed86867da656f8", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复 Windows 上目录扫描的错误检测", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}, "url": "/docs/compare/?release=10.8#10.8-6f4dc5d09091fc92", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "facd74d550600fed233bff7b2b0c3fe9", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复 Windows 上目录扫描中的错误检测", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}, "url": "/docs/compare/?release=9.6.13#9.6.13-691c84a1bcf6ce11", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "2ec178c47539b29fd83d5a350b84b1e1", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复 Windows 上目录扫描中的错误检测", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}, "url": "/docs/compare/?release=9.5.17#9.5.17-691c84a1bcf6ce11", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "6e764e0a7fe284ba94b6ff71ece31c03", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复 Windows 上目录扫描中的错误检测", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}, "url": "/docs/compare/?release=9.4.22#9.4.22-691c84a1bcf6ce11", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-c1e7da4d67b69bca", "cves": [], "html": "

修复 ecpg 中的语法问题（Tom Lane）

\n

缺少分号导致 ecpg 程序中的 SET variable = DEFAULT 被错误转换（但 SET variable TO DEFAULT 不受影响），产生服务器会拒绝的语法无效输出。此外，在列出多个类型名的 DROP TYPE 或 DROP DOMAIN 命令中，实际只处理了第一个类型名。

", "text": "修复 ecpg 中的语法问题（Tom Lane） 缺少分号导致 ecpg 程序中的 SET variable = DEFAULT 被错误转换（但 SET variable TO DEFAULT 不受影响），产生服务器会拒绝的语法无效输出。此外，在列出多个类型名的 DROP TYPE 或 DROP DOMAIN 命令中，实际只处理了第一个类型名。", "title": "修复 ecpg 中的语法问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "3c8f5eab765c630680f93cb9c1ca2341d8cad2303fa4a26102c47fc294853a44", "section_path": ["变更"], "commit_groups": [["3a682a21b", "53c2bb78d", "8ec638e69", "904fce2a7", "9e138a401", "de94ed89d"]], "identity_text": "Fix grammar problems in ecpg (Tom Lane) A missing semicolon led to mistranslation of SET variable = DEFAULT (but not SET variable TO DEFAULT) in ecpg programs, producing syntactically invalid output that the server would reject. Additionally, in a DROP TYPE or DROP DOMAIN command that listed multiple type names, only the first type name was actually processed.", "commit_aliases": ["3a682a21b", "53c2bb78d", "8ec638e69", "904fce2a7", "9e138a401", "de94ed89d"], "source_commits": ["de94ed89d"], "source_entry_id": "11.3/changes/053", "db_id": "14fe76d965c6109bd5dcf1cd556ab186", "patch_ids": ["a15a3e885a1c1fe4441e70b78b2498c1"], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e", "relations": [{"rule": 2, "type": "equivalent", "target": "25c98bd39f570fd0745ebfc8014e9e74", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}}, {"rule": 2, "type": "equivalent", "target": "79ffe53da95be83ff64df84ddba3f04a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}}, {"rule": 2, "type": "equivalent", "target": "a53dfb35a7272087867129c0a0a18144", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}}, {"rule": 2, "type": "equivalent", "target": "da878acc56f1b903ec2eecfbd8608c61", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "da878acc56f1b903ec2eecfbd8608c61", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复 ecpg 中的语法问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}, "url": "/docs/compare/?release=10.8#10.8-c1e7da4d67b69bca", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "25c98bd39f570fd0745ebfc8014e9e74", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复 ecpg 中的语法问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}, "url": "/docs/compare/?release=9.6.13#9.6.13-c1e7da4d67b69bca", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "79ffe53da95be83ff64df84ddba3f04a", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复 ecpg 中的语法问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}, "url": "/docs/compare/?release=9.5.17#9.5.17-c1e7da4d67b69bca", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "a53dfb35a7272087867129c0a0a18144", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复 ecpg 中的语法问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}, "url": "/docs/compare/?release=9.4.22#9.4.22-c1e7da4d67b69bca", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-bea833ac23f59bb9", "cves": [], "html": "

使 ecpg 的 CREATE TABLE AS 语法与服务器一致（Daisuke Higuchi）

", "text": "使 ecpg 的 CREATE TABLE AS 语法与服务器一致（Daisuke Higuchi）", "title": "使 ecpg 的 CREATE TABLE AS 语法与服务器一致", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "aa359c0ddd3b86cdb5fa71d26802e336641a893701875fa7bd741b03c5993029", "section_path": ["变更"], "commit_groups": [["10b3299b6", "180606b68", "3530c508c", "e81f0e311", "f647a5fb0"]], "identity_text": "Sync ecpg's syntax for CREATE TABLE AS with the server's (Daisuke Higuchi)", "commit_aliases": ["10b3299b6", "180606b68", "3530c508c", "e81f0e311", "f647a5fb0"], "source_commits": ["3530c508c"], "source_entry_id": "11.3/changes/054", "db_id": "f8ae25d2d03b16b93910ff7ea87dc9e0", "patch_ids": ["8825e53bff9c6b0001041be6b1c61235"], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9", "relations": [{"rule": 2, "type": "equivalent", "target": "0e195ddf7d5a9dcca5857af5861f2c6a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9"}}, {"rule": 2, "type": "equivalent", "target": "3c5385d64b4c237229443c7a1652aa51", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9"}}, {"rule": 2, "type": "equivalent", "target": "f3cdfa49de3bdc7d61931c1702d6903d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "0e195ddf7d5a9dcca5857af5861f2c6a", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "使 ecpg 的 CREATE TABLE AS 语法与服务器一致", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9"}, "url": "/docs/compare/?release=10.8#10.8-bea833ac23f59bb9", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "3c5385d64b4c237229443c7a1652aa51", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "把 ecpg 的 CREATE TABLE AS 语法与服务器的同步", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9"}, "url": "/docs/compare/?release=9.6.13#9.6.13-48ba3a05e703a49f", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "f3cdfa49de3bdc7d61931c1702d6903d", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "把 ecpg 的 CREATE TABLE AS 语法与服务器的同步", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9"}, "url": "/docs/compare/?release=9.5.17#9.5.17-48ba3a05e703a49f", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}]}, {"id": "11.3-14e9b48c34ff1783", "cves": [], "html": "

修复 ecpg 处理包含文件名时可能发生的缓冲区越界（Liu Huailing，Fei Wu）

", "text": "修复 ecpg 处理包含文件名时可能发生的缓冲区越界（Liu Huailing，Fei Wu）", "title": "修复 ecpg 处理包含文件名时可能发生的缓冲区越界", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "cbd7b2408ed7e9af898ecf191acdb1678d6439b32c66f3107ee619fde38358be", "section_path": ["变更"], "commit_groups": [["08cecfaf6", "5469a1e78", "72f725ab2", "8cdce0a45", "e7adda86b", "e7e78f159"], ["0ba09cc02", "12c42a543", "67f6e645e", "773006848", "e7e71b9e1", "ed16ba324"]], "identity_text": "Fix possible buffer overruns in ecpg's processing of include filenames (Liu Huailing, Fei Wu)", "commit_aliases": ["08cecfaf6", "0ba09cc02", "12c42a543", "5469a1e78", "67f6e645e", "72f725ab2", "773006848", "8cdce0a45", "e7adda86b", "e7e71b9e1", "e7e78f159", "ed16ba324"], "source_commits": ["0ba09cc02", "e7adda86b"], "source_entry_id": "11.3/changes/055", "db_id": "2941fadd1a110588cc87191d329f216c", "patch_ids": ["0531fd280d0e19724b6ba1c47a4a49a1", "6fff26393be9afd5424548c6ed3f5a20"], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30", "relations": [{"rule": 2, "type": "equivalent", "target": "7ad257a1239a4b72bea3133099a34bee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}}, {"rule": 2, "type": "equivalent", "target": "8954b81ebb9585589fa23bef78819391", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}}, {"rule": 2, "type": "equivalent", "target": "bf9dd9071e4219db7afd020b0fee9676", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}}, {"rule": 2, "type": "equivalent", "target": "e234e4958fbc3a9e0648e71255cc22ad", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e234e4958fbc3a9e0648e71255cc22ad", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "修复 ecpg 处理包含文件名时可能发生的缓冲区越界", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}, "url": "/docs/compare/?release=10.8#10.8-14e9b48c34ff1783", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "bf9dd9071e4219db7afd020b0fee9676", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "修复 ecpg 处理 include 文件名时可能的缓冲区越界", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}, "url": "/docs/compare/?release=9.6.13#9.6.13-762b4a333d287ebe", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "8954b81ebb9585589fa23bef78819391", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "修复 ecpg 处理 include 文件名时可能的缓冲区越界", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}, "url": "/docs/compare/?release=9.5.17#9.5.17-762b4a333d287ebe", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "7ad257a1239a4b72bea3133099a34bee", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "修复 ecpg 处理 include 文件名时可能的缓冲区越界", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}, "url": "/docs/compare/?release=9.4.22#9.4.22-762b4a333d287ebe", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-debfb22e297ad27e", "cves": [], "html": "

修复未能移除目标数据目录中某些短暂文件而导致的 pg_rewind 失败（Michael Paquier）

", "text": "修复未能移除目标数据目录中某些短暂文件而导致的 pg_rewind 失败（Michael Paquier）", "title": "修复未能移除目标数据目录中某些短暂文件而导致的 pg_rewind 失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "20676bee694b102ec4fee45892b44e5843b813ec5dd18fe3bbd68dee8e1b58a6", "section_path": ["变更"], "commit_groups": [["a7eadaaaa", "dcf2a0db8"]], "identity_text": "Fix pg_rewind failures due to failure to remove some transient files in the target data directory (Michael Paquier)", "commit_aliases": ["a7eadaaaa", "dcf2a0db8"], "source_commits": ["dcf2a0db8"], "source_entry_id": "11.3/changes/056", "db_id": "9a740e708d8159abc7ab1192d580925e", "patch_ids": ["3abe3471178d03f7967b9cab40263b66"], "statement_hash": "c4a80b9674a5a6808dce42bcd2a9a3cae10206932060efe8c95889d98b01e001", "relations": [], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-d85489c6db372d1d", "cves": [], "html": "

让 pg_verify_checksums 验证其指定的数据目录属于正确的 PostgreSQL 版本（Michael Paquier）

", "text": "让 pg_verify_checksums 验证其指定的数据目录属于正确的 PostgreSQL 版本（Michael Paquier）", "title": "让 pg_verify_checksums 验证其指定的数据目录属于正确的 PostgreSQL 版本", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "37d2f82f937387f241ae4391c651da1618f2d396c22256f38edeb18955b44f8d", "section_path": ["变更"], "commit_groups": [["501f58359", "c9ae7f704"]], "identity_text": "Make pg_verify_checksums verify that the data directory it's pointed at is of the right PostgreSQL version (Michael Paquier)", "commit_aliases": ["501f58359", "c9ae7f704"], "source_commits": ["501f58359"], "source_entry_id": "11.3/changes/057", "db_id": "085622c6d912fe312a221121b84ce033", "patch_ids": ["2dc2d53c830b04221d48c8704fd7dc7a"], "statement_hash": "1b836a4d0637002ec3ce84bc798ecbc3d1e799acfbe93266dd97aa6910de03cb", "relations": [], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-daa6f4b9bf02b79d", "cves": [], "html": "

使用远程分组或聚合的查询，其 SELECT 列表项为非相关子查询、外层引用或参数符号时，避免 contrib/postgres_fdw 发生崩溃（Tom Lane）

", "text": "使用远程分组或聚合的查询，其 SELECT 列表项为非相关子查询、外层引用或参数符号时，避免 contrib/postgres_fdw 发生崩溃（Tom Lane）", "title": "使用远程分组或聚合的查询，其 SELECT 列表项为非相关子查询、外层引用或参数符号时，避免 contrib/postgres_fdw 发生崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "39a5550f2a4760bfdbb75edd39d3d8ad904667df39ead176dc10f7fc148f29ef", "section_path": ["变更"], "commit_groups": [["1bf52d688", "8cad5adb9", "c25e638b1"]], "identity_text": "Avoid crash in contrib/postgres_fdw when a query using remote grouping or aggregation has a SELECT-list item that is an uncorrelated sub-select, outer reference, or parameter symbol (Tom Lane)", "commit_aliases": ["1bf52d688", "8cad5adb9", "c25e638b1"], "source_commits": ["1bf52d688"], "source_entry_id": "11.3/changes/058", "db_id": "fe40a0dc99afb02f45fdd0db704459d4", "patch_ids": ["917fd3a05db507b280697c0cd2878feb"], "statement_hash": "8ea2747ee64f07ec326167b6fde6762af92da09e716fb87f7b45163e8cfb58f4", "relations": [{"rule": 2, "type": "equivalent", "target": "f7447311cc6dbcb786e5d9de9163669a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ea2747ee64f07ec326167b6fde6762af92da09e716fb87f7b45163e8cfb58f4"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f7447311cc6dbcb786e5d9de9163669a", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "使用远程分组或聚合的查询，其 SELECT 列表项为非相关子查询、外层引用或参数符号时，避免 contrib/postgres_fdw 发生崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ea2747ee64f07ec326167b6fde6762af92da09e716fb87f7b45163e8cfb58f4"}, "url": "/docs/compare/?release=10.8#10.8-daa6f4b9bf02b79d", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}]}, {"id": "11.3-54f7b3dcd4f63c29", "cves": [], "html": "

更改 contrib/postgres_fdw：如果被选为路由行插入目标的远程分区，同时也是同一命令中稍后将更新的 UPDATE 子计划目标，则报告错误（Amit Langote，Etsuro Fujita）

\n

以前，此类情况会导致服务器崩溃或 UPDATE 结果不正确。让这些情况能够正确工作，留待未来处理。

", "text": "更改 contrib/postgres_fdw：如果被选为路由行插入目标的远程分区，同时也是同一命令中稍后将更新的 UPDATE 子计划目标，则报告错误（Amit Langote，Etsuro Fujita） 以前，此类情况会导致服务器崩溃或 UPDATE 结果不正确。让这些情况能够正确工作，留待未来处理。", "title": "更改 contrib/postgres_fdw：如果被选为路由行插入目标的远程分区，同时也是同一命令中稍后将更新的 UPDATE 子计划目标，则报告错误", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "ce2e89c558373fdf2307eed1824bb42b0d6f44b5cddff3856bc775b2232a85d1", "section_path": ["变更"], "commit_groups": [["5c4704918", "7a3d05534"]], "identity_text": "Change contrib/postgres_fdw to report an error when a remote partition chosen to insert a routed row into is also an UPDATE subplan target that will be updated later in the same command (Amit Langote, Etsuro Fujita) Previously, such situations led to server crashes or incorrect results of the UPDATE. Allowing such cases to work correctly is a matter for future work.", "commit_aliases": ["5c4704918", "7a3d05534"], "source_commits": ["7a3d05534"], "source_entry_id": "11.3/changes/059", "db_id": "b95719fdd7e551d0b9d22cc6829431cc", "patch_ids": ["0d7d039f100c8b0381eca56396b4ba1e"], "statement_hash": "bec145c3eb477210506f389895817bc06aab1343bdc862ddc940566538340e60", "relations": [], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-11ec314a7e41cacc", "cves": [], "html": "

在 contrib/pg_prewarm 中，如果预热因某种原因失败，则避免无限地重新启动后台工作进程（Mithun Cy）

", "text": "在 contrib/pg_prewarm 中，如果预热因某种原因失败，则避免无限地重新启动后台工作进程（Mithun Cy）", "title": "在 contrib/pg_prewarm 中，如果预热因某种原因失败，则避免无限地重新启动后台工作进程", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "683ecd2ebca65c0a670e9eafa8443b85ae87ac0ad19d0791bb76e06bea80a8d5", "section_path": ["变更"], "commit_groups": [["1459e84cb", "fc8b39a46"]], "identity_text": "In contrib/pg_prewarm, avoid indefinitely respawning background worker processes if prewarming fails for some reason (Mithun Cy)", "commit_aliases": ["1459e84cb", "fc8b39a46"], "source_commits": ["fc8b39a46"], "source_entry_id": "11.3/changes/060", "db_id": "f63bc68cdac9fd2b8b86387b868ec7ac", "patch_ids": ["024fdfad7b5b197de75d32deac1c5252"], "statement_hash": "7640e166b25f3a10a34568e3d979c9768a6b323691a15bdb91fedf575d42667a", "relations": [], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.3-dd10ad9ce35f17e7", "cves": [], "html": "

避免 lo_unlink() 调用失败时 contrib/vacuumlo 发生崩溃（Tom Lane）

", "text": "避免 lo_unlink() 调用失败时 contrib/vacuumlo 发生崩溃（Tom Lane）", "title": "避免 lo_unlink() 调用失败时 contrib/vacuumlo 发生崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "0d1eeb62de0c708dcd8996317c1f1421ff7d44d3ad687a614db7d11c6caae887", "section_path": ["变更"], "commit_groups": [["171baf183", "926488822", "99e414cac", "b7ffa0ee8", "bd9396a0b", "e484f0701"]], "identity_text": "Avoid crash in contrib/vacuumlo if an lo_unlink() call failed (Tom Lane)", "commit_aliases": ["171baf183", "926488822", "99e414cac", "b7ffa0ee8", "bd9396a0b", "e484f0701"], "source_commits": ["b7ffa0ee8"], "source_entry_id": "11.3/changes/061", "db_id": "959dc79309a567e72faa1fa8b585aeed", "patch_ids": ["d5d74d345a3808cfd59f2950c7f2de84"], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6", "relations": [{"rule": 2, "type": "equivalent", "target": "6c4cfbe3db71d709788446649c097a87", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}}, {"rule": 2, "type": "equivalent", "target": "a69732f2109198a64bae91eba970a838", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}}, {"rule": 2, "type": "equivalent", "target": "d3932dfc08ca68d56f4861aacf76bfd0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}}, {"rule": 2, "type": "equivalent", "target": "e37020d2cb293ec7451ebd1806d95eba", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}}], "version": "11.3", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "6c4cfbe3db71d709788446649c097a87", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "避免 lo_unlink() 调用失败时 contrib/vacuumlo 发生崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}, "url": "/docs/compare/?release=10.8#10.8-dd10ad9ce35f17e7", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "a69732f2109198a64bae91eba970a838", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "避免 lo_unlink() 调用失败时 contrib/vacuumlo 崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}, "url": "/docs/compare/?release=9.6.13#9.6.13-2dd609f3d7d06f93", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "d3932dfc08ca68d56f4861aacf76bfd0", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "避免 lo_unlink() 调用失败时 contrib/vacuumlo 崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}, "url": "/docs/compare/?release=9.5.17#9.5.17-2dd609f3d7d06f93", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "e37020d2cb293ec7451ebd1806d95eba", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "避免contrib/vacuumlo在lo_unlink()调用失败时崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}, "url": "/docs/compare/?release=9.4.22#9.4.22-18fae14fc45b13d6", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-507a572b53ea47ed", "cves": [], "html": "

将我们使用的时区库副本同步到 IANA tzcode 2019a 版（Tom Lane）

\n

这修正了 zic 的一个小缺陷，它曾使 Africa/Casablanca 时区在 2440 年输出不正确的转换时间；同时添加了对 zic 新选项 -r 的支持。

", "text": "将我们使用的时区库副本同步到 IANA tzcode 2019a 版（Tom Lane） 这修正了 zic 的一个小缺陷，它曾使 Africa/Casablanca 时区在 2440 年输出不正确的转换时间；同时添加了对 zic 新选项 -r 的支持。", "title": "将我们使用的时区库副本同步到 IANA tzcode 2019a 版", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "5ce03e9a0990cf725ba7171a1ba26720e3a5385a40b1fb345e3da4eb34925d67", "section_path": ["变更"], "commit_groups": [["1c61ec7bb", "48f8fa9ce", "578cb33df", "7c22e1388", "a97cfd9b8", "b3904abb4"], ["22ba95536", "28aa0ee4f", "7898d01da", "7f36286c2", "acb897b80", "fd7474151"]], "identity_text": "Sync our copy of the timezone library with IANA tzcode release 2019a (Tom Lane) This corrects a small bug in zic that caused it to output an incorrect year-2440 transition in the Africa/Casablanca zone, and adds support for zic's new -r option.", "commit_aliases": ["1c61ec7bb", "22ba95536", "28aa0ee4f", "48f8fa9ce", "578cb33df", "7898d01da", "7c22e1388", "7f36286c2", "a97cfd9b8", "acb897b80", "b3904abb4", "fd7474151"], "source_commits": ["7898d01da", "a97cfd9b8"], "source_entry_id": "11.3/changes/062", "db_id": "1cac0d94d4eca624002ecda4f1e6fc3d", "patch_ids": ["0774842b6c62843f52e9ea151d654c0b", "9140ed22a7a223a5da8aecd2ba716c6a"], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7", "relations": [{"rule": 2, "type": "equivalent", "target": "66914fbb953c15277cd20d87d19d93c0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}}, {"rule": 2, "type": "equivalent", "target": "a540f8e2894b3487ba1b0ee3d4b78ae1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}}, {"rule": 2, "type": "equivalent", "target": "b9bd08778af7320e7124a439ad867fdc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}}, {"rule": 2, "type": "equivalent", "target": "f3221e5c22baa4d1a9d623ec87df9f02", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "66914fbb953c15277cd20d87d19d93c0", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "将我们使用的时区库副本同步到 IANA tzcode 2019a 版", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}, "url": "/docs/compare/?release=10.8#10.8-507a572b53ea47ed", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "b9bd08778af7320e7124a439ad867fdc", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "把我们的时区库副本与 IANA tzcode 版本 2019a 同步", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}, "url": "/docs/compare/?release=9.6.13#9.6.13-5e343e89c652c29d", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "a540f8e2894b3487ba1b0ee3d4b78ae1", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "把我们的时区库副本与 IANA tzcode 版本 2019a 同步", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}, "url": "/docs/compare/?release=9.5.17#9.5.17-5e343e89c652c29d", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "f3221e5c22baa4d1a9d623ec87df9f02", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "把我们的时区库副本与 IANA tzcode 版本 2019a 同步", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}, "url": "/docs/compare/?release=9.4.22#9.4.22-5e343e89c652c29d", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}, {"id": "11.3-4d7f3428373529e9", "cves": [], "html": "

将时区数据文件更新到 tzdata 2019a 版，以反映巴勒斯坦和梅特拉卡特拉的夏令时法规变更，并修正以色列的历史数据。

\n

Etc/UCT 现在是指向 Etc/UTC 的向后兼容链接，不再是一个会生成缩写 UCT 的独立时区；如今，该缩写通常是拼写错误。PostgreSQL 仍会接受 UCT 作为输入的时区缩写，但不会输出它。

", "text": "将时区数据文件更新到 tzdata 2019a 版，以反映巴勒斯坦和梅特拉卡特拉的夏令时法规变更，并修正以色列的历史数据。 Etc/UCT 现在是指向 Etc/UTC 的向后兼容链接，不再是一个会生成缩写 UCT 的独立时区；如今，该缩写通常是拼写错误。PostgreSQL 仍会接受 UCT 作为输入的时区缩写，但不会输出它。", "title": "将时区数据文件更新到 tzdata 2019a 版，以反映巴勒斯坦和梅特拉卡特拉的夏令时法规变更，并修正以色列的历史数据。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/11.3/#id-1.11.6.24.5", "source_hash": "a6a24017feda6114908df45261339dd255edd30529b0c8459d0fed91147c00bd", "section_path": ["变更"], "commit_groups": [["14c28c3b5", "b25a81c71", "baeb12010", "c1c76431c", "d312de3fc", "f6307baca"]], "identity_text": "Update time zone data files to tzdata release 2019a for DST law changes in Palestine and Metlakatla, plus historical corrections for Israel. Etc/UCT is now a backward-compatibility link to Etc/UTC, instead of being a separate zone that generates the abbreviation UCT, which nowadays is typically a typo. PostgreSQL will still accept UCT as an input zone abbreviation, but it won't output it.", "commit_aliases": ["14c28c3b5", "b25a81c71", "baeb12010", "c1c76431c", "d312de3fc", "f6307baca"], "source_commits": ["f6307baca"], "source_entry_id": "11.3/changes/063", "db_id": "1351ea232cdf0da5060ed35675ef291b", "patch_ids": ["19f551a025ccfaba00557adcf3cfbab6"], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631", "relations": [{"rule": 2, "type": "equivalent", "target": "027f2c56262639dcac6f914771caf3e4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}}, {"rule": 2, "type": "equivalent", "target": "1bf0f111d2174e1c03544c822925f804", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}}, {"rule": 2, "type": "equivalent", "target": "631069fad507d1e77ef53826d517469c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}}, {"rule": 2, "type": "equivalent", "target": "f4398155d8dfdeb71ed3a4ad7ad79968", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}}], "version": "11.3", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "027f2c56262639dcac6f914771caf3e4", "kind": "equivalent", "version": "10.8", "label": "10.8", "title": "将时区数据文件更新到 tzdata 2019a 版，以反映巴勒斯坦和梅特拉卡特拉的夏令时法规变更，并修正以色列的历史数据。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}, "url": "/docs/compare/?release=10.8#10.8-4d7f3428373529e9", "source_url": "/docs/release/10.8/#id-1.11.6.20.5"}, {"db_id": "631069fad507d1e77ef53826d517469c", "kind": "equivalent", "version": "9.6.13", "label": "9.6.13", "title": "更新时区数据文件到 tzdata 版本 2019a，涉及巴勒斯坦和梅特拉卡特拉的夏令时法规变更，以及以色列的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}, "url": "/docs/compare/?release=9.6.13#9.6.13-2c829a625ebc8f26", "source_url": "/docs/release/9.6.13/#id-1.11.6.16.5"}, {"db_id": "f4398155d8dfdeb71ed3a4ad7ad79968", "kind": "equivalent", "version": "9.5.17", "label": "9.5.17", "title": "更新时区数据文件到 tzdata 版本 2019a，涉及巴勒斯坦和梅特拉卡特拉的夏令时法规变更，以及以色列的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}, "url": "/docs/compare/?release=9.5.17#9.5.17-2c829a625ebc8f26", "source_url": "/docs/release/9.5.17/#id-1.11.6.13.5"}, {"db_id": "1bf0f111d2174e1c03544c822925f804", "kind": "equivalent", "version": "9.4.22", "label": "9.4.22", "title": "更新时区数据文件到 tzdata 版本 2019a，涉及巴勒斯坦和梅特拉卡特拉的夏令时法规变更，以及以色列的历史修正。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}, "url": "/docs/compare/?release=9.4.22#9.4.22-2c829a625ebc8f26", "source_url": "/docs/release/9.4.22/#id-1.11.6.9.6"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 63}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 40}, {"key": "security", "label": "安全相关", "count": 2}, {"key": "performance", "label": "性能改进", "count": 1}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 20}], "total": 63, "release_count": 1, "cross_major": false, "cve_count": 3, "cves": [{"id": "CVE-2019-10129", "url": "https://www.postgresql.org/support/security/CVE-2019-10129/", "fixed": {"11": "11.3"}, "score": 6.5, "title": "避免报告分区路由错误时访问已释放的内存", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N", "affected": {"11": "11"}, "component": "core server", "published": {"11": "2019-05-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Prior to this release, a user running PostgreSQL 11 can read arbitrary bytes of server memory by executing a purpose-crafted INSERT statement to a partitioned table.", "first_published": "2019-05-09", "fixed_version": "11.3"}, {"id": "CVE-2017-7484", "url": "https://www.postgresql.org/support/security/CVE-2017-7484/", "fixed": {"9.2": "9.2.21", "9.3": "9.3.17", "9.4": "9.4.12", "9.5": "9.5.7", "9.6": "9.6.3"}, "score": 4.3, "title": "防止通过选择率估计器绕过行级安全策略", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"9.2": "2017-05-11", "9.3": "2017-05-11", "9.4": "2017-05-11", "9.5": "2017-05-11", "9.6": "2017-05-11"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-05-11", "fixed_version": ""}, {"id": "CVE-2019-10130", "url": "https://www.postgresql.org/support/security/CVE-2019-10130/", "fixed": {"10": "10.8", "11": "11.3", "9.5": "9.5.17", "9.6": "9.6.13"}, "score": 3.1, "title": "防止通过选择率估计器绕过行级安全策略", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"10": "10", "11": "11", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"10": "2019-05-09", "11": "2019-05-09", "9.5": "2019-05-09", "9.6": "2019-05-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "PostgreSQL maintains statistics for tables by sampling data available in columns; this data is consulted during the query planning process. Prior to this release, a user able to execute SQL queries with permissions to read a given column could craft a leaky operator that could read whatever data had been sampled from that column. If this happened to include values from rows that the user is forbidden to see by a row security policy, the user could effectively bypass the policy. This is fixed by only allowing a non-leakproof operator to use this data if there are no relevant row security policies for the table.\n\nThe PostgreSQL project thanks Dean Rasheed for reporting this problem.", "first_published": "2019-05-09", "fixed_version": "11.3"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 63, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}