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

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

\n

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

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

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

\n

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

", "compatibility_count": 0, "label": "10.8", "status_label": "历史版本", "eol": "2022-11-10", "age_days": 2701, "support_days": -1420, "entries": [{"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "f6c0c6e0beedf73a4f32b73cc8e209fcd112e3ffeccdf650102108d85690ac32", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/001", "db_id": "56d6db8446f41023a027932d51f76dad", "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7", "relations": [{"rule": 2, "type": "equivalent", "target": "7ff539ab31995c0e78fd5d7b1ca6321e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7"}}, {"rule": 2, "type": "equivalent", "target": "9bd418a48b41e4825da797ada67a744d", "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": "10.8", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "9bd418a48b41e4825da797ada67a744d", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "防止通过选择率估计器绕过行级安全策略", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1767df1e8a5f9607827fd44f927fdb996e1e48243654d4cc97590333923d45e7"}, "url": "/docs/compare/?release=11.3#11.3-35d4445257f1090d", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "7ed92b63bbd8e2c1fbdff69a495f2704aa1fc38fc5cb3c4a9f2a55997f36d2a2", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/002", "db_id": "9d2b24472d79ed5df42bcfc732d0937d", "patch_ids": [], "statement_hash": "25d538475699600d7f5de73f8299c988b0f55edc41736e3691e82959f7df0e33", "relations": [{"rule": 2, "type": "equivalent", "target": "b4823ed87e75e4e261269a8312179694", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "25d538475699600d7f5de73f8299c988b0f55edc41736e3691e82959f7df0e33"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b4823ed87e75e4e261269a8312179694", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "避免在单语句事务中创建带有 ON COMMIT DROP 和标识列的临时表时发生目录损坏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "25d538475699600d7f5de73f8299c988b0f55edc41736e3691e82959f7df0e33"}, "url": "/docs/compare/?release=11.3#11.3-d3a4d63cba165e23", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "950dcc29f57c61c92e5287e0d48db82eb38412b641af26621d6a7370c2e36a36", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/003", "db_id": "38e8ee40ca6faa67809057c1f804a6b2", "patch_ids": [], "statement_hash": "6f2530608c5c90a9ebc0ffa054eb713bd5c567a5191f33528ca67249f6f3b1d8", "relations": [{"rule": 2, "type": "equivalent", "target": "282631db9846ad7eb0615ef51a50153c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f2530608c5c90a9ebc0ffa054eb713bd5c567a5191f33528ca67249f6f3b1d8"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "282631db9846ad7eb0615ef51a50153c", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "避免对分区查询结果关系执行 EPQ 复检时发生崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f2530608c5c90a9ebc0ffa054eb713bd5c567a5191f33528ca67249f6f3b1d8"}, "url": "/docs/compare/?release=11.3#11.3-759795f254b243b7", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "7fafda57a52902b4d2ef54bdeb4cedb0807efb2b16c0f1f9452bd3a303c9be50", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/004", "db_id": "ee33f6a5e3b8f24c278b011a02520dac", "patch_ids": [], "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": "b368d56b37ac4352bd3ef63c0c0289e8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}}, {"rule": 2, "type": "equivalent", "target": "bfa3446f770b34d8aa9361f5fab1cb5c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b368d56b37ac4352bd3ef63c0c0289e8", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复对继承树或分区表执行 UPDATE 或 DELETE 时，每个表都可被排除的情况下的行为", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04270985d752fb6c5f5545b5fa05edecd1190f221b84972e06d714c72cbebdf5"}, "url": "/docs/compare/?release=11.3#11.3-e26b0f16db0644de", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "1a4b29eeb661e8471432857e72eacaf9904b21be2ed8d727d4659138293dfd55", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/005", "db_id": "e131ed931be19881b37fa82de0824a8f", "patch_ids": [], "statement_hash": "7a876748d502629785a24f7787cf6518f68777d7f1868fbabb1f07f6751f1d38", "relations": [{"rule": 2, "type": "equivalent", "target": "e51e9d79477a1138da3523277001c1ce", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a876748d502629785a24f7787cf6518f68777d7f1868fbabb1f07f6751f1d38"}}], "version": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "e51e9d79477a1138da3523277001c1ce", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "避免存在 FOR ALL TABLES 发布时，更新临时表和不记录 WAL 的表抛出不正确的错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a876748d502629785a24f7787cf6518f68777d7f1868fbabb1f07f6751f1d38"}, "url": "/docs/compare/?release=11.3#11.3-ae6752b8665c93f4", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "ef9ea442481cdbcc046a3c0eadf2a540667c4270d04f3803f955edffd5625f49", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/006", "db_id": "15b3195c74a53d643ab8b5015da41bf2", "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88", "relations": [{"rule": 2, "type": "equivalent", "target": "0e7f247e2430c5d23f1325380d1bee17", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}}, {"rule": 2, "type": "equivalent", "target": "576438ba514bda6624f4fcbc74af1247", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "576438ba514bda6624f4fcbc74af1247", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "目标关系为可更新视图时，修复包含多行 VALUES 的 INSERT ... VALUES 命令中对显式 DEFAULT 项的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a664438a604eb308832fc04e0c1e0c1ad228e82d60c50cefc7cd72566abd88"}, "url": "/docs/compare/?release=11.3#11.3-1309f551eab21e73", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-2f43af900aee43f0", "cves": [], "html": "

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

\n

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

", "text": "修复 CREATE VIEW，使其允许零列视图（Ashutosh Sharma） 为与允许零列表的行为保持一致，我们也应该允许这种情况。由于表可以转换为视图，即使存在这一限制，也能创建零列视图，从而导致转储/重载失败。", "title": "修复 CREATE VIEW，使其允许零列视图", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "6a9928f1f7763cd0cb29c2331547d06ed23e1a350a415e7d308a6ec3cd47e0f0", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/007", "db_id": "11b34e728cf080fc41561fcb4d6ad24f", "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74", "relations": [{"rule": 2, "type": "equivalent", "target": "090336ec6d5bd02a548f703772f3ed54", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}}, {"rule": 2, "type": "equivalent", "target": "0ad36899c6cc367ed4b03e73f3a605cd", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "0ad36899c6cc367ed4b03e73f3a605cd", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复 CREATE VIEW，使其允许零列视图", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d8a44c6b03c6c765fc6ca03b1875e81dc8ca03313cefbd60092715a906c0b74"}, "url": "/docs/compare/?release=11.3#11.3-2f43af900aee43f0", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "300f6fa31c322de0723473539bd1ed69da16fd00cad9ffa8985112d8a98a8230", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/008", "db_id": "3ec55572f69e517844a5e9fccff1e699", "patch_ids": [], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f", "relations": [{"rule": 2, "type": "equivalent", "target": "203eb98c0cbd3e07960f297009511131", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "203eb98c0cbd3e07960f297009511131", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "补上对 CREATE TABLE IF NOT EXISTS ... AS EXECUTE ... 缺失的支持", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a7d2a3381045147506d2b61b3c1fe8f087d82842dcebae5b5324a6482ed4a5f"}, "url": "/docs/compare/?release=11.3#11.3-3966034489e2d830", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-dd6917b2eff5e96f", "cves": [], "html": "

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

\n

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

", "text": "确保行级安全策略表达式中的子 SELECT 以正确用户的权限执行（Dean Rasheed） 以前，如果通过视图访问带有 RLS 策略的表，此类检查可能以调用视图的用户身份执行，而非按预期以视图所有者的身份执行。", "title": "确保行级安全策略表达式中的子 SELECT 以正确用户的权限执行", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "7337418c2156eb7edae7daa3a43de1c3a0153210b2ef22a52c1934fce94c0dd3", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/009", "db_id": "39b09b82ea1b638d237ba72e602ff58e", "patch_ids": [], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7", "relations": [{"rule": 2, "type": "equivalent", "target": "538a53875eb204361509c8fe1afe2936", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "538a53875eb204361509c8fe1afe2936", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "确保行级安全策略表达式中的子 SELECT 以正确用户的权限执行", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c608576634231d1a252e598a21a46dd93063525758b135ac711ef531849e6ec7"}, "url": "/docs/compare/?release=11.3#11.3-dd6917b2eff5e96f", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "35ca9d7d07c893896f3cf5ffa3b7bf7c24c2940604e79ef6216f6d02c5406756", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/010", "db_id": "301285ce4093d204e6501892fd9b5151", "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded", "relations": [{"rule": 2, "type": "equivalent", "target": "2086676771c95a609d6b64562e08edb0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}}, {"rule": 2, "type": "equivalent", "target": "35509c0a6100cc945cd7c16a6d72baec", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "35509c0a6100cc945cd7c16a6d72baec", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "按照 SQL:2006 及后续标准的要求，当 xmloption 设置为 content 时，接受 XML 文档作为 xml 类型的有效值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba2336b054e0691b8e1f138516b050e12e01729886d441ba8a6c4e164f66ded"}, "url": "/docs/compare/?release=11.3#11.3-1189aea744777953", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "7c89892584380210adba703ac193e0cfc6ee46019945b49703090ca09682a4b9", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/011", "db_id": "59083f7943af0375b7179837075926ae", "patch_ids": [], "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": "57c110b625e0623530d237e179705f69", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "57c110b625e0623530d237e179705f69", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "改进服务器在启动时对预先存在的共享内存段是否仍在使用的检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2617d85831b9da49d42b8cd73967dc50b47fe7109a983c8dbc23accdc5016185"}, "url": "/docs/compare/?release=11.3#11.3-4923162f8d7b0ab5", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-15dd3db2edf595e4", "cves": [], "html": "

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

", "text": "避免将并行工作进程的事务计为独立事务（Haribabu Kommi）", "title": "避免将并行工作进程的事务计为独立事务", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "1e5315bd9e60a214f40b043566b71ca112b8bba18fc15f68384d62216743195f", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid counting parallel workers' transactions as separate transactions (Haribabu Kommi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/012", "db_id": "b5de6042d578e46c90c2c435d9ca02bf", "patch_ids": [], "statement_hash": "ec6e44f4b20670b74f3aef5b68e371f7f671a880df345fb56430bf0374354c65", "relations": [{"rule": 2, "type": "equivalent", "target": "a5b3202e83704c37b3f27eafe94408c4", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "a5b3202e83704c37b3f27eafe94408c4", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "避免将并行工作进程的事务计为独立事务", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ec6e44f4b20670b74f3aef5b68e371f7f671a880df345fb56430bf0374354c65"}, "url": "/docs/compare/?release=11.3#11.3-15dd3db2edf595e4", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "b2441add7e3ac25cf9a89351470831f690a009899030ab9898c431d750078379", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/013", "db_id": "b4045e089f599f3829cddf06a819b434", "patch_ids": [], "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": "8ac6289d89d1fbc54793e1be533234c2", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "8ac6289d89d1fbc54793e1be533234c2", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复 GIN 索引 WAL 记录的不兼容问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2cdb1404537cb0788718f43ed5ccc30211424d99e57630b49b5b5931540d269"}, "url": "/docs/compare/?release=11.3#11.3-5e3b663f903c9160", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-1e569c8acf8d1f9d", "cves": [], "html": "

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

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

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

", "text": "避免重建分区的关系缓存条目时发生内存泄漏（Amit Langote，Tom Lane）", "title": "避免重建分区的关系缓存条目时发生内存泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "422729a29aff7888edd211bed70bfa90f479c3ca548b5826ffe071b91552735b", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid memory leak when a partition's relation cache entry is rebuilt (Amit Langote, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/015", "db_id": "6523e925112eefec93f973ef01e868a1", "patch_ids": [], "statement_hash": "37f8cd44f69a7bce19e5300dfd52206c41511cbe10fb2174769a87d06ec50cf2", "relations": [{"rule": 2, "type": "equivalent", "target": "ad5d4a8037a15d16d7ff86be55e784fc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "37f8cd44f69a7bce19e5300dfd52206c41511cbe10fb2174769a87d06ec50cf2"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ad5d4a8037a15d16d7ff86be55e784fc", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "避免重建分区的关系缓存条目时发生内存泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "37f8cd44f69a7bce19e5300dfd52206c41511cbe10fb2174769a87d06ec50cf2"}, "url": "/docs/compare/?release=11.3#11.3-b5451983e23f35f1", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "446b5d4a4807141a9a8905234f5b5173022e035d82d641b31ecdb29f66b67cf6", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/016", "db_id": "4675539e238eceda7f6eac2b399194f8", "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024", "relations": [{"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"}}, {"rule": 2, "type": "equivalent", "target": "f449147b771ac77b4c5587d05127b477", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}}], "version": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f449147b771ac77b4c5587d05127b477", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "在适当情况下，容忍 fsync 和 sync_file_range 调用返回 EINVAL 和 ENOSYS 错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15019ec8507d65e8b4c5f4988b1a8f4b7c460d62b13c984eeb4cb52f0d7e5024"}, "url": "/docs/compare/?release=11.3#11.3-9033975dde4c2264", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "12b62a8cae68dec029b9778fca9724c0ae7867ea30d5e4bdf4eab422c627eff9", "section_path": ["变更"], "commit_groups": [], "identity_text": "Report correct relation name in autovacuum's pg_stat_activity display during BRIN summarize operations (Álvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/017", "db_id": "e80917ba17757c13de977edc70bf4b91", "patch_ids": [], "statement_hash": "e65cc28a7a0675735871b7a261c4cf5657d710cb8739c4b55dde08d8895bd17e", "relations": [{"rule": 2, "type": "equivalent", "target": "9d7a16ced4de45fe5125f2663a88bf2c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e65cc28a7a0675735871b7a261c4cf5657d710cb8739c4b55dde08d8895bd17e"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "9d7a16ced4de45fe5125f2663a88bf2c", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "在 BRIN 汇总操作期间，在自动清理的 pg_stat_activity 显示中报告正确的关系名", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e65cc28a7a0675735871b7a261c4cf5657d710cb8739c4b55dde08d8895bd17e"}, "url": "/docs/compare/?release=11.3#11.3-b4271b76433e0e97", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "4666c11c4c844c640adfe6b0d4e06cf76ba79803f118b3522219496901ae54c3", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/018", "db_id": "1a2c43e83a2ae578bc39dab49a27b002", "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b", "relations": [{"rule": 2, "type": "equivalent", "target": "0cb6b648d9303b8cf23472cad87f142c", "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"}}, {"rule": 2, "type": "equivalent", "target": "eecfb9f41a9c8fbf59fcc48f93a6f07b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "eecfb9f41a9c8fbf59fcc48f93a6f07b", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复从 FULL 外连接向外引用的横向引用导致的 “failed to build any N-way joins” 规划器失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2324a62e170ec26ea193fab5976a1d83ba7b4f8f17fa86e2c806cc06062430b"}, "url": "/docs/compare/?release=11.3#11.3-85bd286d93302cad", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "645f5fd59cdf91f595657fb08da027d27477ddc8eb8f54f4020d7567fbbfb7d8", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/019", "db_id": "d95c8712a535c57e96ddfa2002d3cb85", "patch_ids": [], "statement_hash": "b2b9c591f66af5af1d55bbd2f259057317ad8721504483858b415affd973746a", "relations": [{"rule": 2, "type": "equivalent", "target": "267658a5e60e719010cbcc9405f4c8c7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2b9c591f66af5af1d55bbd2f259057317ad8721504483858b415affd973746a"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "267658a5e60e719010cbcc9405f4c8c7", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复将返回集合的函数应用于可证明为空的关系时的查询规划错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2b9c591f66af5af1d55bbd2f259057317ad8721504483858b415affd973746a"}, "url": "/docs/compare/?release=11.3#11.3-f83ddcd0152434af", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-45a520da4a2291fd", "cves": [], "html": "

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

\n

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

", "text": "执行有关是否允许可能泄漏信息的操作符访问 pg_statistic 数据的规则时，检查正确用户的权限（Dean Rasheed） 通过视图访问底层表时，在决定能否将可能泄漏信息的操作符应用于该表的统计数据时，应考虑视图所有者的权限，而非发出查询的用户的权限。这使规划器关于数据可见性的规则与执行器一致，避免不必要的低效计划。", "title": "执行有关是否允许可能泄漏信息的操作符访问 pg_statistic 数据的规则时，检查正确用户的权限", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "f6fed8f1c7c3167e94357331d31cd2b2db1b899f826c973099a34b94839647cd", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/020", "db_id": "2ac62b291959e2b42bd5d570b4525b29", "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297", "relations": [{"rule": 2, "type": "equivalent", "target": "82a11df8b6eb395c717e913682c85746", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "82a11df8b6eb395c717e913682c85746", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "执行有关是否允许可能泄漏信息的操作符访问 pg_statistic 数据的规则时，检查正确用户的权限", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4ad8181965b1dd7fa6dc7fc11507351f2845cf0cd9d2626ecdd08c9b51d7c297"}, "url": "/docs/compare/?release=11.3#11.3-45a520da4a2291fd", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-60e7e60e1bbf2022", "cves": [], "html": "

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

", "text": "在存在大量相等条件和大量可能相关的外键约束时，加快规划速度（David Rowley）", "title": "在存在大量相等条件和大量可能相关的外键约束时，加快规划速度", "commits": [], "section": "变更", "category": "performance", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "e0d853ffe8f91f07a3fd4de3cfcb85bd58ac79f188675f127eebfef76a1a97cd", "section_path": ["变更"], "commit_groups": [], "identity_text": "Speed up planning when there are many equality conditions and many potentially-relevant foreign key constraints (David Rowley)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/021", "db_id": "8d0293d89a14bb59d91b527fc7972dfa", "patch_ids": [], "statement_hash": "a955702ba63c86002b2b7946f4f1c7d58a442511bf1f94e5ee9ea7ce3f704953", "relations": [{"rule": 2, "type": "equivalent", "target": "51dab45d01a5dbab590304db96f9f1f9", "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": "10.8", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "51dab45d01a5dbab590304db96f9f1f9", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "在存在大量相等条件和大量可能相关的外键约束时，加快规划速度", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a955702ba63c86002b2b7946f4f1c7d58a442511bf1f94e5ee9ea7ce3f704953"}, "url": "/docs/compare/?release=11.3#11.3-60e7e60e1bbf2022", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "1e2022bcc56c5510ba1ab02a7e14269eaa3971e6f926200b3e15efa1160c2963", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid O(N^2) performance issue when rolling back a transaction that created many tables (Tomas Vondra)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/022", "db_id": "6c30ef376fcdedb817a2c92d79c67584", "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57", "relations": [{"rule": 2, "type": "equivalent", "target": "588eab874ea30b97c5da35700ce3cf02", "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": "b52433722fe51b4a45700e2bc72412e5", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "b52433722fe51b4a45700e2bc72412e5", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "避免回滚创建了大量表的事务时发生 O(N^2) 性能问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dd774afe58862ed690f1155b09fb61564db6fbdc63db2c267410f9d14e1abc57"}, "url": "/docs/compare/?release=11.3#11.3-5bdcb5c157afa8cc", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-e7255648e86761df", "cves": [], "html": "

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

", "text": "修复动态共享内存分配中边界情况下的服务器崩溃（Thomas Munro，Robert Haas）", "title": "修复动态共享内存分配中边界情况下的服务器崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "305e0d08df4c1744762805ae107b15022c869fbdf3b57fb686b197116af55223", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix corner-case server crashes in dynamic shared memory allocation (Thomas Munro, Robert Haas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/023", "db_id": "150d10f7f8ac7bef1eeceb36f4dfe92b", "patch_ids": [], "statement_hash": "6ce40a350ea16cd7ab2b614a81b07a55042f15f0669b3e24077c8a33d1a23063", "relations": [{"rule": 2, "type": "equivalent", "target": "a94fdb71ef3f00262fc12818a361b77c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ce40a350ea16cd7ab2b614a81b07a55042f15f0669b3e24077c8a33d1a23063"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a94fdb71ef3f00262fc12818a361b77c", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复动态共享内存分配中边界情况下的服务器崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ce40a350ea16cd7ab2b614a81b07a55042f15f0669b3e24077c8a33d1a23063"}, "url": "/docs/compare/?release=11.3#11.3-e7255648e86761df", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "f3f306810f4c02dd9633359edbd95499e74b1409b66d3f157489d87db45ef5ad", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/024", "db_id": "630d5a03e93105f0f4b107ca566b54e8", "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823", "relations": [{"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"}}, {"rule": 2, "type": "equivalent", "target": "fc58f5aef290612b3a8d9e6d974bd45b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fc58f5aef290612b3a8d9e6d974bd45b", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复动态共享内存管理中的竞争条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0e817a9a5f97725727c724745615d6ffce1f906777c18c78b43d6b725744823"}, "url": "/docs/compare/?release=11.3#11.3-54a3837eaceace0a", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-78fdfc022e6a9cf8", "cves": [], "html": "

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

", "text": "修复热备 postmaster 收到 smart 关闭请求后可能无法关闭的竞争条件（Tom Lane）", "title": "修复热备 postmaster 收到 smart 关闭请求后可能无法关闭的竞争条件", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "266df8dd5e51edfa91f70b86e04c6e0a75e8b3185607ae7712303fe96742ec73", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/025", "db_id": "4210c401558dc70edeb64e47f7c9e0a4", "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab", "relations": [{"rule": 2, "type": "equivalent", "target": "409d1b88be429d1cb8a579ce0c84375a", "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": "7607635df0027eef0b0a3dc43947171d", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "7607635df0027eef0b0a3dc43947171d", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复热备 postmaster 收到 smart 关闭请求后可能无法关闭的竞争条件", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f587038a9e0336073ee0b2d12bbc0afea2a94787d8a65c4080e68f1dfdb88ab"}, "url": "/docs/compare/?release=11.3#11.3-78fdfc022e6a9cf8", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "c009374ae54261953c6db0e914fb9022f16511554b6640c99779aba83decb6b7", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible crash when pg_identify_object_as_address() is given invalid input (Álvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/026", "db_id": "72161c17cb9ec7a261eceabc9771f1a6", "patch_ids": [], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf", "relations": [{"rule": 2, "type": "equivalent", "target": "59848af8f80ec3fd0cee55ef653e5bd9", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "59848af8f80ec3fd0cee55ef653e5bd9", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复 pg_identify_object_as_address() 收到无效输入时可能发生的崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "39fbb4b1e8c4f7e003cdb55379865351448beb4cbfdead4e37d5f47806756adf"}, "url": "/docs/compare/?release=11.3#11.3-fbf3fd803374216d", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "fe93cce9d6ebfc0504c0e962b8976bc5d483d769ebc1b410e2e453e52c8f144e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible could not access status of transaction failures in txid_status() (Thomas Munro)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/027", "db_id": "66d9e356774b2071e1dbebdf5734cddf", "patch_ids": [], "statement_hash": "75c9f260b19476eb36875c67dcdb1c8a8aa2b8fc2e22c9cfb9a91e154de835fc", "relations": [{"rule": 2, "type": "equivalent", "target": "d8c1dbc7d003b6600c3e9a4da77ab5df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75c9f260b19476eb36875c67dcdb1c8a8aa2b8fc2e22c9cfb9a91e154de835fc"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d8c1dbc7d003b6600c3e9a4da77ab5df", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复 txid_status() 中可能发生的 “could not access status of transaction” 失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75c9f260b19476eb36875c67dcdb1c8a8aa2b8fc2e22c9cfb9a91e154de835fc"}, "url": "/docs/compare/?release=11.3#11.3-dc0ddf8aad819a2f", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "db97b43558759b1f4f0ebf1e25cafdaf105be4eb49210119074a47a0aaa16db9", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/028", "db_id": "88fc7b91a4bd261e7cdca2cec81c944d", "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722", "relations": [{"rule": 2, "type": "equivalent", "target": "065b7d60883bb6a234a85b51fd294973", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}}, {"rule": 2, "type": "equivalent", "target": "63fa62fd1be046c468accff4643e3276", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "63fa62fd1be046c468accff4643e3276", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "加强对已编码的 SCRAM-SHA-256 和 MD5 密码的验证", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0336ab8f5fb97c3129d6f26e6a17dec92a1ece6da00397f07bf9f0b576dcb722"}, "url": "/docs/compare/?release=11.3#11.3-954f6844cb0eccce", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "663495130f8a603787ac2d5a09c6d23aafbd215a1b568f48a04d4d56bd2b4856", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/029", "db_id": "6023434703ae142d685b77bcd27e729c", "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c", "relations": [{"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"}}, {"rule": 2, "type": "equivalent", "target": "fd5ae8340036928149041c1a7238147f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fd5ae8340036928149041c1a7238147f", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复对隐含编码不同于数据库编码的 lc_time 设置的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dac2e03503b671109dd1f2fe08367d24646969cabae6dc4cade4a18283d6195c"}, "url": "/docs/compare/?release=11.3#11.3-c71a9dbe067f738c", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "c6c046408f5edba106fddfc8586c3b912c25eb5a519785bd80d81563a0572745", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix incorrect operator_precedence_warning checks involving unary minus operators (Rikard Falkeborn)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/030", "db_id": "ae82d625aa676e49dc809096cbebfbb3", "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3", "relations": [{"rule": 2, "type": "equivalent", "target": "8048f6693e651a4e4b11ab25b96232ce", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3"}}, {"rule": 2, "type": "equivalent", "target": "97ac3fcbca00af0a2809809eed32209e", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "8048f6693e651a4e4b11ab25b96232ce", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复涉及一元负号操作符时不正确的 operator_precedence_warning 检查", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ddd54091b0f8566e299eebf315b21db398fe458e9c8f3d2f21fed85b43909d3"}, "url": "/docs/compare/?release=11.3#11.3-e70623a99d6fa6c4", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-ca03bfca2ae91309", "cves": [], "html": "

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

", "text": "禁止将 NaN 用作浮点服务器参数的值（Tom Lane）", "title": "禁止将 NaN 用作浮点服务器参数的值", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "838d4e4dea8e4d50e6f64aac41e7c9385e42e8f93490e8854a1ba43c376fe140", "section_path": ["变更"], "commit_groups": [], "identity_text": "Disallow NaN as a value for floating-point server parameters (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/031", "db_id": "20ac9b2452da793d7a631f7e776d1b3f", "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9", "relations": [{"rule": 2, "type": "equivalent", "target": "202b7c0247bddc4a0cf76a64f21b4b18", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}}, {"rule": 2, "type": "equivalent", "target": "9b08e2a0268c251e987ab852d608c84d", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "9b08e2a0268c251e987ab852d608c84d", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "禁止将 NaN 用作浮点服务器参数的值", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aa7dd1f41c1543364a7cec8ce5d67330cc2364ea89b8ee2f35140f012a99edd9"}, "url": "/docs/compare/?release=11.3#11.3-ca03bfca2ae91309", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "4751f821662aab51364d887433e28597ef8c431c07bf5cf95102409490717e84", "section_path": ["变更"], "commit_groups": [], "identity_text": "Rearrange REINDEX processing to avoid assertion failures when reindexing individual indexes of pg_class (Andres Freund, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/032", "db_id": "bc73908224b943c5f141199c1d2306a1", "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec", "relations": [{"rule": 2, "type": "equivalent", "target": "0d9c14e676a080463b68aebdc8ecc69e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}}, {"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"}}], "version": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "0d9c14e676a080463b68aebdc8ecc69e", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "重新安排 REINDEX 的处理，以避免重建 pg_class 的单个索引时发生断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acc873989166de02ef21c8fe9f34ee5a8cbf310d5f2df4b945da6d0cd7e5e8ec"}, "url": "/docs/compare/?release=11.3#11.3-d08a1a8f1cd91ea2", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-f174c25fa2ad7ddd", "cves": [], "html": "

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

", "text": "修复参数化虚拟路径引发的规划器断言失败（Tom Lane）", "title": "修复参数化虚拟路径引发的规划器断言失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "54fbca45bd0e063d37c2065a9cdfc94da34c2e8f883733fb53fb0698082c217e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix planner assertion failure for parameterized dummy paths (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/033", "db_id": "9fa7bc07d630d94e6fc53509af4a3fd4", "patch_ids": [], "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": "763b084ad370bf768031dc9ee886a0ab", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}}, {"rule": 2, "type": "equivalent", "target": "95220568334a504ff69e73ababe97e46", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "763b084ad370bf768031dc9ee886a0ab", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复参数化虚拟路径引发的规划器断言失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d3942f88bca7cb4a0f09cf504996ab508f9abaa5a632578c2a4ec56c0bebed7"}, "url": "/docs/compare/?release=11.3#11.3-f174c25fa2ad7ddd", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-d3e4951ffe3d00a9", "cves": [], "html": "

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

\n

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

", "text": "在 SnapBuildInitialSnapshot() 的结果中设置正确的测试函数（Antonin Houska） 核心代码不依赖此项，但某些扩展会依赖。", "title": "在 SnapBuildInitialSnapshot() 的结果中设置正确的测试函数", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "8e602d2a5808e584f84c55f2cfb9c44eb3284fadf43fb72d10004316a67d9b9b", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/034", "db_id": "8bf21069b627d06b340cb848bd0adf31", "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9", "relations": [{"rule": 2, "type": "equivalent", "target": "86bbe9772f7bbfb35b8e92312c6fdd45", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}}, {"rule": 2, "type": "equivalent", "target": "987b55c6c7ecf552eb54f83b28f3b208", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "987b55c6c7ecf552eb54f83b28f3b208", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "在 SnapBuildInitialSnapshot() 的结果中设置正确的测试函数", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "49a0b41fd8592ab28d81663debc0702d3c1646a27f2a1e2b71eda7bbce54e5a9"}, "url": "/docs/compare/?release=11.3#11.3-d3e4951ffe3d00a9", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "b95b4f82cbd470893ba5c84324cf1efd0ef66b8add4c565d4ba765754063e209", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/035", "db_id": "662acfd1ddc55189cb802f96b14e9401", "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a", "relations": [{"rule": 2, "type": "equivalent", "target": "0271baa0447feba739fddee4f248c25c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}}, {"rule": 2, "type": "equivalent", "target": "37ca840f8209b068864585b7d699cb6c", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "37ca840f8209b068864585b7d699cb6c", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复 Windows 上间歇出现的 “could not reattach to shared memory” 会话启动失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27daeb23cb9f84e9a9b19b7c40cdf81af98f8dd9e3a7c0363da150162f38991a"}, "url": "/docs/compare/?release=11.3#11.3-2c7bdaa9af6aad3c", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-6f4dc5d09091fc92", "cves": [], "html": "

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

\n

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

", "text": "修复 Windows 上目录扫描的错误检测（Konstantin Knizhnik） 缺少读取目录的权限等错误未被正确检测或报告；代码反而静默地表现得像目录为空一样。", "title": "修复 Windows 上目录扫描的错误检测", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "793922e5e8360832f4e79d888e91dda9395356e2a9725bb979609ba169580163", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/036", "db_id": "e4c3862436bc6b4e73ed86867da656f8", "patch_ids": [], "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": "75ce8d4b3d89d04e314ebf062c570aa0", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "75ce8d4b3d89d04e314ebf062c570aa0", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复 Windows 上目录扫描的错误检测", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "04a72cd465bc452bb03b4f51a865ad37e770bb85791e82c0bc0d493032103dfe"}, "url": "/docs/compare/?release=11.3#11.3-6f4dc5d09091fc92", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "2221e2190a3df2a271717bf0890f7dfc8f5433bec0439085b27fe35c5b3dade2", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/037", "db_id": "da878acc56f1b903ec2eecfbd8608c61", "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e", "relations": [{"rule": 2, "type": "equivalent", "target": "14fe76d965c6109bd5dcf1cd556ab186", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}}, {"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"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "14fe76d965c6109bd5dcf1cd556ab186", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复 ecpg 中的语法问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "941802537ef4faf94b1af5d8b45429a19a568fbfa19b69e6c8ba2a7b988cfa8e"}, "url": "/docs/compare/?release=11.3#11.3-c1e7da4d67b69bca", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "99a49b1057d0925a6baa16a8a8e21edcea71c495d14d684e67f92acb21d4f12c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Sync ecpg's syntax for CREATE TABLE AS with the server's (Daisuke Higuchi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/038", "db_id": "0e195ddf7d5a9dcca5857af5861f2c6a", "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9", "relations": [{"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"}}, {"rule": 2, "type": "equivalent", "target": "f8ae25d2d03b16b93910ff7ea87dc9e0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9"}}], "version": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f8ae25d2d03b16b93910ff7ea87dc9e0", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "使 ecpg 的 CREATE TABLE AS 语法与服务器一致", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfeb23591eb7d98360b46084e9a1a0b04c03f8877e3aa0bd65887495644bc7b9"}, "url": "/docs/compare/?release=11.3#11.3-bea833ac23f59bb9", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-14e9b48c34ff1783", "cves": [], "html": "

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

", "text": "修复 ecpg 处理包含文件名时可能发生的缓冲区越界（Liu Huailing，Fei Wu）", "title": "修复 ecpg 处理包含文件名时可能发生的缓冲区越界", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/10.8/#id-1.11.6.20.5", "source_hash": "229d5901fe592c11318f48082180d71c3acd64f54a9658294a46998c5db1e24a", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible buffer overruns in ecpg's processing of include filenames (Liu Huailing, Fei Wu)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/039", "db_id": "e234e4958fbc3a9e0648e71255cc22ad", "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30", "relations": [{"rule": 2, "type": "equivalent", "target": "2941fadd1a110588cc87191d329f216c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}}, {"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"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "2941fadd1a110588cc87191d329f216c", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "修复 ecpg 处理包含文件名时可能发生的缓冲区越界", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "491a515d22d16f483cbd23b6ed88a84e4c3e718c03c9c07534bad6e0d1752d30"}, "url": "/docs/compare/?release=11.3#11.3-14e9b48c34ff1783", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "ab33fd11e34a766ceda22864260b04c7c34b56733c05f6dd59aadbef932be1b7", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/040", "db_id": "f7447311cc6dbcb786e5d9de9163669a", "patch_ids": [], "statement_hash": "8ea2747ee64f07ec326167b6fde6762af92da09e716fb87f7b45163e8cfb58f4", "relations": [{"rule": 2, "type": "equivalent", "target": "fe40a0dc99afb02f45fdd0db704459d4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ea2747ee64f07ec326167b6fde6762af92da09e716fb87f7b45163e8cfb58f4"}}], "version": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "fe40a0dc99afb02f45fdd0db704459d4", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "使用远程分组或聚合的查询，其 SELECT 列表项为非相关子查询、外层引用或参数符号时，避免 contrib/postgres_fdw 发生崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ea2747ee64f07ec326167b6fde6762af92da09e716fb87f7b45163e8cfb58f4"}, "url": "/docs/compare/?release=11.3#11.3-daa6f4b9bf02b79d", "source_url": "/docs/release/11.3/#id-1.11.6.24.5"}]}, {"id": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "0018de2a69bfa7ec0a6b9e96531d9475a67f6608ec779cd77c7901808bfb28c9", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid crash in contrib/vacuumlo if an lo_unlink() call failed (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "10.8/changes/041", "db_id": "6c4cfbe3db71d709788446649c097a87", "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6", "relations": [{"rule": 2, "type": "equivalent", "target": "959dc79309a567e72faa1fa8b585aeed", "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": "10.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "959dc79309a567e72faa1fa8b585aeed", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "避免 lo_unlink() 调用失败时 contrib/vacuumlo 发生崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d48c02d02f4ba4b4d7211bf18fbb12b697ebde7894668bf8897e8d81a314e5b6"}, "url": "/docs/compare/?release=11.3#11.3-dd10ad9ce35f17e7", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "32bead039c18520475b739370f7c6d2b9788b1b5024c2cc0ba5c87959f7b12bd", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/042", "db_id": "66914fbb953c15277cd20d87d19d93c0", "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7", "relations": [{"rule": 2, "type": "equivalent", "target": "1cac0d94d4eca624002ecda4f1e6fc3d", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1cac0d94d4eca624002ecda4f1e6fc3d", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "将我们使用的时区库副本同步到 IANA tzcode 2019a 版", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506577051746389a163a87f2fcc5ba09031dfba85eeff25c5ac2441164a52ae7"}, "url": "/docs/compare/?release=11.3#11.3-507a572b53ea47ed", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": "10.8-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/10.8/#id-1.11.6.20.5", "source_hash": "7303a9d96f8ab825cddd9ca160bdb69d3fdadccb03313f2e400c7b9270fec69f", "section_path": ["变更"], "commit_groups": [], "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": [], "source_commits": [], "source_entry_id": "10.8/changes/043", "db_id": "027f2c56262639dcac6f914771caf3e4", "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631", "relations": [{"rule": 2, "type": "equivalent", "target": "1351ea232cdf0da5060ed35675ef291b", "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": "10.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "1351ea232cdf0da5060ed35675ef291b", "kind": "equivalent", "version": "11.3", "label": "11.3", "title": "将时区数据文件更新到 tzdata 2019a 版，以反映巴勒斯坦和梅特拉卡特拉的夏令时法规变更，并修正以色列的历史数据。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "514e67a9a1a1491e3afdd57fd4ed91ef84671240c76dc48dd506ee2f5e657631"}, "url": "/docs/compare/?release=11.3#11.3-4d7f3428373529e9", "source_url": "/docs/release/11.3/#id-1.11.6.24.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": 43}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 27}, {"key": "security", "label": "安全相关", "count": 1}, {"key": "performance", "label": "性能改进", "count": 1}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 14}], "total": 43, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"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": "10.8"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 43, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}