对于运行 14.X 的用户，不需要执行导出/恢复。
\n但是，如果是从早于 14.4 的版本升级，请参见第 E.21 节。
", "compatibility_count": 0, "label": "14.5", "status_label": "受支持版本", "eol": "2026-11-12", "age_days": 1511, "support_days": 43}, "groups": [{"date": "2022-08-11", "build": "14.5", "major": "14", "minor": 5, "manual": "14", "status": "stable", "doc_git": "", "version": "14.5", "eol_date": "2026-11-12", "date_text": "2022-08-11", "supported": true, "manual_url": "/docs/14/release-14-5.html", "source_url": "/docs/release/14.5/", "entry_count": 39, "placeholder": false, "content_hash": "8c9bab2fb83d2ede0d0c2e6247511d35860cf5325cdfbef7fc459020acaf99d3", "manual_build": "14.24", "source_as_of": "", "changes_count": 39, "doc_loaded_at": "2026-09-26T02:56:39.341991", "migration_html": "对于运行 14.X 的用户，不需要执行导出/恢复。
\n但是，如果是从早于 14.4 的版本升级，请参见第 E.21 节。
", "compatibility_count": 0, "label": "14.5", "status_label": "受支持版本", "eol": "2026-11-12", "age_days": 1511, "support_days": 43, "entries": [{"id": "14.5-f18192a896faf696", "cves": ["CVE-2022-2625"], "html": "不允许扩展脚本替换不属于该扩展的已有对象（Tom Lane）§
\n此更改防止扩展脚本在存在不属于该扩展的现有对象时执行 CREATE OR REPLACE。在相同情况下，也防止执行 CREATE IF NOT EXISTS。这防止了一种木马攻击形式，即恶意数据库用户可以成为扩展对象的所有者，然后修改它以危害其他用户对该对象的未来使用。作为附带的好处，它还降低了意外替换非预期对象的风险。
PostgreSQL 项目感谢 Sven Klemm 报告此问题。（CVE-2022-2625）
", "text": "不允许扩展脚本替换不属于该扩展的已有对象（Tom Lane）§ 此更改防止扩展脚本在存在不属于该扩展的现有对象时执行 CREATE OR REPLACE。在相同情况下，也防止执行 CREATE IF NOT EXISTS。这防止了一种木马攻击形式，即恶意数据库用户可以成为扩展对象的所有者，然后修改它以危害其他用户对该对象的未来使用。作为附带的好处，它还降低了意外替换非预期对象的风险。 PostgreSQL 项目感谢 Sven Klemm 报告此问题。（CVE-2022-2625）", "title": "不允许扩展脚本替换不属于该扩展的已有对象", "commits": ["5721da7e4"], "section": "变更", "category": "security", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "60af99099da87de8ee9c22ded142ea31df2a5aad0285b3b48f17af6ef173fef3", "section_path": ["变更"], "commit_groups": [["5579726bd", "5721da7e4", "5919bb5a5", "7e92f78ab", "b9b21acc7", "cc7e0feba", "f52d2fbd8"]], "identity_text": "Do not let extension scripts replace objects not already belonging to the extension (Tom Lane) This change prevents extension scripts from doing CREATE OR REPLACE if there is an existing object that does not belong to the extension. It also prevents CREATE IF NOT EXISTS in the same situation. This prevents a form of trojan-horse attack in which a hostile database user could become the owner of an extension object and then modify it to compromise future uses of the object by other users. As a side benefit, it also reduces the risk of accidentally replacing objects one did not mean to. The PostgreSQL Project thanks Sven Klemm for reporting this problem. (CVE-2022-2625)", "commit_aliases": ["5579726bd", "5721da7e4", "5919bb5a5", "7e92f78ab", "b9b21acc7", "cc7e0feba", "f52d2fbd8"], "source_commits": ["5721da7e4"], "source_entry_id": "14.5/changes/001", "db_id": "5cc72a133ee09029810fac6600d4b24c", "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f", "relations": [{"rule": 2, "type": "equivalent", "target": "1bc57e31ad8079f1fc2d7babc99cbeab", "evidence": {"same_day": true, "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f"}}, {"rule": 2, "type": "equivalent", "target": "b431c16c94c765fe7a47a48d80578e21", "evidence": {"same_day": true, "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f"}}, {"rule": 2, "type": "equivalent", "target": "c172e40466de8e721efbf40aee21831e", "evidence": {"same_day": true, "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f"}}, {"rule": 2, "type": "equivalent", "target": "e5ea8ff09e47c80a81863d7cb6ceb15f", "evidence": {"same_day": true, "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f"}}], "version": "14.5", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "b431c16c94c765fe7a47a48d80578e21", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "不允许扩展脚本替换不属于该扩展的已有对象", "evidence": {"same_day": true, "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f"}, "url": "/docs/compare/?release=13.8#13.8-d7fa2ab8d0b929c9", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "c172e40466de8e721efbf40aee21831e", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "不允许扩展脚本替换不属于该扩展的已有对象", "evidence": {"same_day": true, "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f"}, "url": "/docs/compare/?release=12.12#12.12-adff0755b5cd079c", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "e5ea8ff09e47c80a81863d7cb6ceb15f", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "不允许扩展脚本替换不属于该扩展的已有对象", "evidence": {"same_day": true, "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f"}, "url": "/docs/compare/?release=11.17#11.17-bf326130ed8e047c", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "1bc57e31ad8079f1fc2d7babc99cbeab", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "不允许扩展脚本替换不属于该扩展的已有对象", "evidence": {"same_day": true, "patch_ids": ["5ac755dea0e0bf61092444d6a146fda2"], "statement_hash": "71d2ca220b7344a70209e20f13c75fe18a9fdf233fd64998b19c24d0f13c627f"}, "url": "/docs/compare/?release=10.22#10.22-bf326130ed8e047c", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-f59f2e7e9b9053ca", "cves": [], "html": "修复在备库上重放 CREATE DATABASE WAL 记录的问题（Kyotaro Horiguchi，Asim R Praveen，Paul Guo）§ § § §
备库在重放数据库创建 WAL 记录时可能遇到缺失的表空间目录。在此补丁之前，备库在这种情况下会恢复失败；然而，此类目录可能是合法缺失的。创建表空间（作为普通目录），然后在重放达到一致状态后检查它是否已被删除。
", "text": "修复在备库上重放 CREATE DATABASE WAL 记录的问题（Kyotaro Horiguchi，Asim R Praveen，Paul Guo）§ § § § 备库在重放数据库创建 WAL 记录时可能遇到缺失的表空间目录。在此补丁之前，备库在这种情况下会恢复失败；然而，此类目录可能是合法缺失的。创建表空间（作为普通目录），然后在重放达到一致状态后检查它是否已被删除。", "title": "修复在备库上重放 CREATE DATABASE WAL 记录的问题", "commits": ["4d8d85740", "9d5c96d9b", "a3aacb7cb", "e90c4fc88"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "ead3e94789b7769f9089250ea7396293cd9de81ac1b18d16c9a07d11b5283181", "section_path": ["变更"], "commit_groups": [["084318c33", "5a10c262f", "6d20f8c5a", "8348413db", "9a7e26b9c", "9e4f914b5", "a3aacb7cb"], ["2eb3f167f", "3f9c20536", "4349a7615", "b76e136ce", "b998196bb", "c308003d2", "e90c4fc88"], ["4d8d85740", "59be1c942", "658e5d534", "6ffaf75a8", "798d64488", "7cfe688de", "fcd72cf29"], ["6390bc740", "6c1c9f88a", "772e6383d", "782e5631e", "8c5d9ccca", "9d5c96d9b", "ad0e08394"]], "identity_text": "Fix replay of CREATE DATABASE WAL records on standby servers (Kyotaro Horiguchi, Asim R Praveen, Paul Guo) Standby servers may encounter missing tablespace directories when replaying database-creation WAL records. Prior to this patch, a standby would fail to recover in such a case; however, such directories could be legitimately missing. Create the tablespace (as a plain directory), then check that it has been dropped again once replay reaches a consistent state.", "commit_aliases": ["084318c33", "2eb3f167f", "3f9c20536", "4349a7615", "4d8d85740", "59be1c942", "5a10c262f", "6390bc740", "658e5d534", "6c1c9f88a", "6d20f8c5a", "6ffaf75a8", "772e6383d", "782e5631e", "798d64488", "7cfe688de", "8348413db", "8c5d9ccca", "9a7e26b9c", "9d5c96d9b", "9e4f914b5", "a3aacb7cb", "ad0e08394", "b76e136ce", "b998196bb", "c308003d2", "e90c4fc88", "fcd72cf29"], "source_commits": ["4d8d85740", "9d5c96d9b", "a3aacb7cb", "e90c4fc88"], "source_entry_id": "14.5/changes/002", "db_id": "a68c5b8e8a3c41c6a3b3d9fe35ade173", "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a", "relations": [{"rule": 2, "type": "equivalent", "target": "41355a70a70310682ef92e85180635ec", "evidence": {"same_day": true, "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a"}}, {"rule": 2, "type": "equivalent", "target": "643224c00c9a794bf9220e700169829c", "evidence": {"same_day": true, "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a"}}, {"rule": 2, "type": "equivalent", "target": "9ec3497a794ad6e3797d72db3748eb70", "evidence": {"same_day": true, "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a"}}, {"rule": 2, "type": "equivalent", "target": "cff4a80ea9148414435ffb96229c53f1", "evidence": {"same_day": true, "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "9ec3497a794ad6e3797d72db3748eb70", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复在备库上重放 CREATE DATABASE WAL 记录的问题", "evidence": {"same_day": true, "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a"}, "url": "/docs/compare/?release=13.8#13.8-2d0699645b62e662", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "643224c00c9a794bf9220e700169829c", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "修复在备库上重放 CREATE DATABASE WAL 记录的问题", "evidence": {"same_day": true, "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a"}, "url": "/docs/compare/?release=12.12#12.12-faf7fdbb3c2c55ed", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "cff4a80ea9148414435ffb96229c53f1", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "修复在备库上重放 CREATE DATABASE WAL 记录的问题", "evidence": {"same_day": true, "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a"}, "url": "/docs/compare/?release=11.17#11.17-bb29fbeb0cde6e2f", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "41355a70a70310682ef92e85180635ec", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "修复在备库上重放 CREATE DATABASE WAL 记录的问题", "evidence": {"same_day": true, "patch_ids": ["67c24764acf117f28dd2885f53bfe7a8", "9e9b75cc37dbf306fd2682d8081334a8", "bcca38a3322d16d58b2643aa3e2a3ddc", "d2d0c00a6d60eaa9b4b72b2dbb4f4f64"], "statement_hash": "79e7818cc212e9ba7b8f2a2b662296d9e7df77137d8e728d89d02be23027f34a"}, "url": "/docs/compare/?release=10.22#10.22-bb29fbeb0cde6e2f", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-4096adfa7dd3b128", "cves": [], "html": "支持“原位”表空间（Thomas Munro，Michael Paquier，Álvaro Herrera）§ § §
\n通常，PostgreSQL 表空间是指向其他文件系统中某个目录的符号链接。此更改允许表空间直接就是一个普通目录。虽然这对将表分布到不同文件系统上没有帮助，但对测试来说是一种方便的设置。此外，为支持 CREATE DATABASE 的重放修复，这一能力是必需的；该修复会将缺失的表空间临时创建为“原位”表空间。
修复 CREATE INDEX 中的权限检查（Nathan Bossart，Noah Misch）§
CVE-2022-1552 的修复导致 CREATE INDEX 在查找操作符类和其他对象时应用表所有者的权限，而之前使用的是调用用户的权限。这破坏了导出/恢复场景，因为 pg_dump 在重新授予权限之前发出 CREATE INDEX。
在扩展查询协议中，在 CREATE DATABASE 和其他不能在事务块中运行的命令之后强制立即提交（Tom Lane）§
如果客户端在此类命令之后没有立即发送 Sync 消息，而是发送了另一个命令，那么该命令中的任何失败都将导致回滚前面的命令，通常会在磁盘上留下不一致的状态（如缺失或多余的数据库目录）。用于防止这种情况的机制在简单查询消息中的多个命令中有效，但在一系列扩展协议消息中无效。为了防止不一致而不破坏当前可行的使用场景，在此类命令之后强制执行隐式提交。
", "text": "在扩展查询协议中，在 CREATE DATABASE 和其他不能在事务块中运行的命令之后强制立即提交（Tom Lane）§ 如果客户端在此类命令之后没有立即发送 Sync 消息，而是发送了另一个命令，那么该命令中的任何失败都将导致回滚前面的命令，通常会在磁盘上留下不一致的状态（如缺失或多余的数据库目录）。用于防止这种情况的机制在简单查询消息中的多个命令中有效，但在一系列扩展协议消息中无效。为了防止不一致而不破坏当前可行的使用场景，在此类命令之后强制执行隐式提交。", "title": "在扩展查询协议中，在 CREATE DATABASE 和其他不能在事务块中运行的命令之后强制立即提交", "commits": ["3e1297a63"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "00dcb0d092c23be67735f1734f2ef2c351048f2c6c3379b03a51e44986368be9", "section_path": ["变更"], "commit_groups": [["3e1297a63", "6c193c2ac", "964f42aa2", "968b89257", "9e3e1ac45", "a0c632c1d", "f92944137"]], "identity_text": "In extended query protocol, force an immediate commit after CREATE DATABASE and other commands that can't run in a transaction block (Tom Lane) If the client does not send a Sync message immediately after such a command, but instead sends another command, any failure in that command would lead to rolling back the preceding command, typically leaving inconsistent state on-disk (such as a missing or extra database directory). The mechanisms intended to prevent that situation turn out to work for multiple commands in a simple-Query message, but not for a series of extended-protocol messages. To prevent inconsistency without breaking use-cases that work today, force an implicit commit after such commands.", "commit_aliases": ["3e1297a63", "6c193c2ac", "964f42aa2", "968b89257", "9e3e1ac45", "a0c632c1d", "f92944137"], "source_commits": ["3e1297a63"], "source_entry_id": "14.5/changes/005", "db_id": "aae22367a46507293a2ab76dc07b2c3b", "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a", "relations": [{"rule": 2, "type": "equivalent", "target": "13b2307b207f1489a1fc214c029e4fc6", "evidence": {"same_day": true, "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a"}}, {"rule": 2, "type": "equivalent", "target": "4af3dc652b50b6978c359e74e63aadaa", "evidence": {"same_day": true, "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a"}}, {"rule": 2, "type": "equivalent", "target": "578696be03ae87fd68253ee936f8c363", "evidence": {"same_day": true, "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a"}}, {"rule": 2, "type": "equivalent", "target": "ef15108a860a4a2448d9a2acbde6575f", "evidence": {"same_day": true, "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a"}}], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "4af3dc652b50b6978c359e74e63aadaa", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "在扩展查询协议中，在 CREATE DATABASE 和其他不能在事务块中运行的命令之后强制立即提交", "evidence": {"same_day": true, "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a"}, "url": "/docs/compare/?release=13.8#13.8-2c88f5ee118337b1", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "578696be03ae87fd68253ee936f8c363", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "在扩展查询协议中，在 CREATE DATABASE 和其他不能在事务块中运行的命令之后强制立即提交", "evidence": {"same_day": true, "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a"}, "url": "/docs/compare/?release=12.12#12.12-f92ccb5d57e77590", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "ef15108a860a4a2448d9a2acbde6575f", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "在扩展查询协议中，在 CREATE DATABASE 和其他不能在事务块中运行的命令之后强制立即提交", "evidence": {"same_day": true, "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a"}, "url": "/docs/compare/?release=11.17#11.17-e03569ec8da47158", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "13b2307b207f1489a1fc214c029e4fc6", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "在扩展查询协议中，在 CREATE DATABASE 和其他不能在事务块中运行的命令之后强制立即提交", "evidence": {"same_day": true, "patch_ids": ["4dac3f6876215d155f86606aa647fa4a"], "statement_hash": "314dc34edd16eebf72ddf946885d18f40d7a398a77934415fa181cb5794b8a4a"}, "url": "/docs/compare/?release=10.22#10.22-e03569ec8da47158", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-ffb98ecffd437e46", "cves": [], "html": "修复检查事务可见性时的竞态条件（Simon Riggs）§
\nTransactionIdIsInProgress 可能在目标事务被认为可见之前就报告 false，导致各种异常行为。竞态条件窗口通常非常窄，但使用同步复制会使其大幅扩大，因为等待同步副本的过程发生在该窗口中。
修复在按包含非顶层集合返回函数的表达式排序时生成错误计划的问题（Richard Guo，Tom Lane）§ §
", "text": "修复在按包含非顶层集合返回函数的表达式排序时生成错误计划的问题（Richard Guo，Tom Lane）§ §", "title": "修复在按包含非顶层集合返回函数的表达式排序时生成错误计划的问题", "commits": ["1a9ac8492", "445b9020c"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "c5c372f030b6a121b8db163540f394f8c3015a769eba17ca39c6182481fef6bc", "section_path": ["变更"], "commit_groups": [["11e7d626c", "1a9ac8492", "8d38ccafc", "cc1164799"], ["14168d57b", "1aa8dad41", "445b9020c", "da4ed7588"]], "identity_text": "Fix incorrect plans when sorting by an expression that contains a non-top-level set-returning function (Richard Guo, Tom Lane)", "commit_aliases": ["11e7d626c", "14168d57b", "1a9ac8492", "1aa8dad41", "445b9020c", "8d38ccafc", "cc1164799", "da4ed7588"], "source_commits": ["1a9ac8492", "445b9020c"], "source_entry_id": "14.5/changes/007", "db_id": "b35c3d20344124da198983ca1187c855", "patch_ids": ["313de991f3f2eb3aa97d09b1849746b2", "bf26454a53934a989be49f5fd10c077a"], "statement_hash": "3c49ce606afcb695e98babb1587bca6a81ec3019fd0b552856afff60ea519dfa", "relations": [{"rule": 2, "type": "equivalent", "target": "a8f02eedd1ab668d95a3405873810da0", "evidence": {"same_day": true, "patch_ids": ["313de991f3f2eb3aa97d09b1849746b2", "bf26454a53934a989be49f5fd10c077a"], "statement_hash": "3c49ce606afcb695e98babb1587bca6a81ec3019fd0b552856afff60ea519dfa"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "a8f02eedd1ab668d95a3405873810da0", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复在按包含非顶层集合返回函数的表达式排序时生成错误计划的问题", "evidence": {"same_day": true, "patch_ids": ["313de991f3f2eb3aa97d09b1849746b2", "bf26454a53934a989be49f5fd10c077a"], "statement_hash": "3c49ce606afcb695e98babb1587bca6a81ec3019fd0b552856afff60ea519dfa"}, "url": "/docs/compare/?release=13.8#13.8-940f169c9aba5d0f", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}]}, {"id": "14.5-8cef8d1a7c47f759", "cves": [], "html": "修复扩展统计信息的错误权限检查代码（Richard Guo）§
\n如果用户对一个有扩展统计信息的表仅有部分 SELECT 权限，某些查询会出现 “unrecognized node type” 错误。
修复扩展统计信息机制以处理布尔值表达式上的 MCV 类型统计信息（Tom Lane）§
\n统计信息收集工作正常，但 WHERE 中包含此类表达式的查询会出现 “unknown clause type” 错误。
避免在 array 变量上有 MCV 类型扩展统计信息时，constant = ANY(array)
修复 ALTER TABLE ... ENABLE/DISABLE TRIGGER 对分区表上的触发器正确处理递归（Álvaro Herrera，Amit Langote）§ §
在某些情况下，由于命令会尝试调整没有该触发器的子分区上的触发器，会出现 “trigger does not exist” 错误。
", "text": "修复 ALTER TABLE ... ENABLE/DISABLE TRIGGER 对分区表上的触发器正确处理递归（Álvaro Herrera，Amit Langote）§ § 在某些情况下，由于命令会尝试调整没有该触发器的子分区上的触发器，会出现 “trigger does not exist” 错误。", "title": "修复 ALTER TABLE ... ENABLE/DISABLE TRIGGER 对分区表上的触发器正确处理递归", "commits": ["6d9481cd0", "731d514ae"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "a0addba47c48407d5b81493c6457648407f8ee8a1e25bf1b9886faa699e555fa", "section_path": ["变更"], "commit_groups": [["4ad4c1f41", "6d9481cd0", "90a4b6413", "91130dd31", "aa242501a", "d2a74621e"], ["6e7b37264", "731d514ae", "ab8556630", "ce8e06652", "e78fd9084", "ec0925c22"]], "identity_text": "Fix ALTER TABLE ... ENABLE/DISABLE TRIGGER to handle recursion correctly for triggers on partitioned tables (Álvaro Herrera, Amit Langote) In certain cases, a trigger does not exist failure would occur because the command would try to adjust the trigger on a child partition that doesn't have it.", "commit_aliases": ["4ad4c1f41", "6d9481cd0", "6e7b37264", "731d514ae", "90a4b6413", "91130dd31", "aa242501a", "ab8556630", "ce8e06652", "d2a74621e", "e78fd9084", "ec0925c22"], "source_commits": ["6d9481cd0", "731d514ae"], "source_entry_id": "14.5/changes/011", "db_id": "faaee224f65007488a807f2a7bf38ef3", "patch_ids": ["39076a15459c2caebb81674e5f419414", "402b78ae7db53d9c9bce8f503bc7fbf1"], "statement_hash": "4c50215e18cf01f9408632bd107c68d3569f77acdf8c2a5253295e5517664e59", "relations": [{"rule": 2, "type": "equivalent", "target": "049217effaf19616f9ce44e224370b1f", "evidence": {"same_day": true, "patch_ids": ["39076a15459c2caebb81674e5f419414", "402b78ae7db53d9c9bce8f503bc7fbf1"], "statement_hash": "4c50215e18cf01f9408632bd107c68d3569f77acdf8c2a5253295e5517664e59"}}, {"rule": 2, "type": "equivalent", "target": "73eecc7fffb3f0fe25fa654bc70daa66", "evidence": {"same_day": true, "patch_ids": ["39076a15459c2caebb81674e5f419414", "402b78ae7db53d9c9bce8f503bc7fbf1"], "statement_hash": "4c50215e18cf01f9408632bd107c68d3569f77acdf8c2a5253295e5517664e59"}}, {"rule": 2, "type": "equivalent", "target": "bcf61d66120f95715cb98660b331cea7", "evidence": {"same_day": true, "patch_ids": ["39076a15459c2caebb81674e5f419414", "402b78ae7db53d9c9bce8f503bc7fbf1"], "statement_hash": "4c50215e18cf01f9408632bd107c68d3569f77acdf8c2a5253295e5517664e59"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "049217effaf19616f9ce44e224370b1f", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复 ALTER TABLE ... ENABLE/DISABLE TRIGGER 对分区表上的触发器正确处理递归", "evidence": {"same_day": true, "patch_ids": ["39076a15459c2caebb81674e5f419414", "402b78ae7db53d9c9bce8f503bc7fbf1"], "statement_hash": "4c50215e18cf01f9408632bd107c68d3569f77acdf8c2a5253295e5517664e59"}, "url": "/docs/compare/?release=13.8#13.8-8ce78c2bde44ee24", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "bcf61d66120f95715cb98660b331cea7", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "修复 ALTER TABLE ... ENABLE/DISABLE TRIGGER 对分区表上的触发器正确处理递归", "evidence": {"same_day": true, "patch_ids": ["39076a15459c2caebb81674e5f419414", "402b78ae7db53d9c9bce8f503bc7fbf1"], "statement_hash": "4c50215e18cf01f9408632bd107c68d3569f77acdf8c2a5253295e5517664e59"}, "url": "/docs/compare/?release=12.12#12.12-f60aa4735ab171f5", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "73eecc7fffb3f0fe25fa654bc70daa66", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "修复 ALTER TABLE ... ENABLE/DISABLE TRIGGER 对分区表上的触发器正确处理递归", "evidence": {"same_day": true, "patch_ids": ["39076a15459c2caebb81674e5f419414", "402b78ae7db53d9c9bce8f503bc7fbf1"], "statement_hash": "4c50215e18cf01f9408632bd107c68d3569f77acdf8c2a5253295e5517664e59"}, "url": "/docs/compare/?release=11.17#11.17-cf82473ae7bbe72d", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}]}, {"id": "14.5-d20139ccf6eba292", "cves": [], "html": "允许在 ANALYZE 计算扩展统计信息时取消操作（Tom Lane，Justin Pryzby）§
在统计目标较高的某些场景中，可能会花费数秒在不可取消的排序操作中。
", "text": "允许在 ANALYZE 计算扩展统计信息时取消操作（Tom Lane，Justin Pryzby）§ 在统计目标较高的某些场景中，可能会花费数秒在不可取消的排序操作中。", "title": "允许在 ANALYZE 计算扩展统计信息时取消操作", "commits": ["af72b0889"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "e34644ba02f6a84ee671936bf855ce3e703462007a38894475929bbaecb8730b", "section_path": ["变更"], "commit_groups": [["12c99c884", "af72b0889", "e64cdab00"]], "identity_text": "Allow cancellation of ANALYZE while it is computing extended statistics (Tom Lane, Justin Pryzby) In some scenarios with high statistics targets, it was possible to spend many seconds in an un-cancellable sort operation.", "commit_aliases": ["12c99c884", "af72b0889", "e64cdab00"], "source_commits": ["af72b0889"], "source_entry_id": "14.5/changes/012", "db_id": "b1854c24f80c7fac7856a2b5ffa05448", "patch_ids": ["8a629bc1f177f80af3eaf75f8a05dc98"], "statement_hash": "57cb18623fa1c63f55b77f896becb997c081e5bc98c83b7ffa988ed94a8ec723", "relations": [], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "14.5-dbdac5d94e69f085", "cves": [], "html": "改进 jsonpath 类型的语法错误消息（Andrew Dunstan）§
确保 pg_stop_backup() 正确清理会话状态（Fujii Masao）§
此遗漏可能导致会话后续出现断言失败或崩溃。
", "text": "确保 pg_stop_backup() 正确清理会话状态（Fujii Masao）§ 此遗漏可能导致会话后续出现断言失败或崩溃。", "title": "确保 pg_stop_backup() 正确清理会话状态", "commits": ["be2e842c8"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "b674db9aca0a301e1d7300a33f71dc49d484fcce98e8c05c4f4c8a253f20e966", "section_path": ["变更"], "commit_groups": [["0829cc43e", "162ade612", "2497d2b77", "80c3ea918", "b24b2be11", "be2e842c8", "f0eb83f81"]], "identity_text": "Ensure that pg_stop_backup() cleans up session state properly (Fujii Masao) This omission could lead to assertion failures or crashes later in the session.", "commit_aliases": ["0829cc43e", "162ade612", "2497d2b77", "80c3ea918", "b24b2be11", "be2e842c8", "f0eb83f81"], "source_commits": ["be2e842c8"], "source_entry_id": "14.5/changes/014", "db_id": "95eca7a5de12345180e860348dbd3a67", "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d", "relations": [{"rule": 2, "type": "equivalent", "target": "166ebfc51c7d67be124cffd57c5cb1ba", "evidence": {"same_day": true, "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d"}}, {"rule": 2, "type": "equivalent", "target": "1ee18796d0497001f194db9ce35adf3a", "evidence": {"same_day": true, "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d"}}, {"rule": 2, "type": "equivalent", "target": "36286ff75feb888e74c5a788207055ea", "evidence": {"same_day": true, "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d"}}, {"rule": 2, "type": "equivalent", "target": "ee29fc1fb2ef022bc12947255f93c1a9", "evidence": {"same_day": true, "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d"}}], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "ee29fc1fb2ef022bc12947255f93c1a9", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "确保 pg_stop_backup() 正确清理会话状态", "evidence": {"same_day": true, "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d"}, "url": "/docs/compare/?release=13.8#13.8-543f0b09cbac1e90", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "36286ff75feb888e74c5a788207055ea", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "确保 pg_stop_backup() 正确清理会话状态", "evidence": {"same_day": true, "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d"}, "url": "/docs/compare/?release=12.12#12.12-402dd572027e535e", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "166ebfc51c7d67be124cffd57c5cb1ba", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "确保 pg_stop_backup() 正确清理会话状态", "evidence": {"same_day": true, "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d"}, "url": "/docs/compare/?release=11.17#11.17-08d1609b3c37d4ab", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "1ee18796d0497001f194db9ce35adf3a", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "确保 pg_stop_backup() 正确清理会话状态", "evidence": {"same_day": true, "patch_ids": ["b1fd45476180e9386f2944c616c5e77e"], "statement_hash": "6071f35f5437c2f499563ec0517c84f3343e00a5328cb7c3dc148db770cf172d"}, "url": "/docs/compare/?release=10.22#10.22-08d1609b3c37d4ab", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-136bb6cf4c1584b7", "cves": [], "html": "修复 trim_array() 以合理处理零维数组参数（Martin Kalcher）§
修复 FOR [KEY] UPDATE/SHARE 子句中的连接别名匹配（Dean Rasheed）§
在某些边界情况下，可能报告误导性的错误。
", "text": "修复 FOR [KEY] UPDATE/SHARE 子句中的连接别名匹配（Dean Rasheed）§ 在某些边界情况下，可能报告误导性的错误。", "title": "修复 FOR [KEY] UPDATE/SHARE 子句中的连接别名匹配", "commits": ["8d8464445"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "7986127b03cfbd78eae80b4cf48cf2fa58b548737b845a7a1989ea6d03d6828c", "section_path": ["变更"], "commit_groups": [["8ace122d4", "8d367a44d", "8d8464445", "e88b1f1e2", "ea9e59d70", "f890223bc", "f9c655d64"]], "identity_text": "Fix join alias matching in FOR [KEY] UPDATE/SHARE clauses (Dean Rasheed) In corner cases, a misleading error could be reported.", "commit_aliases": ["8ace122d4", "8d367a44d", "8d8464445", "e88b1f1e2", "ea9e59d70", "f890223bc", "f9c655d64"], "source_commits": ["8d8464445"], "source_entry_id": "14.5/changes/016", "db_id": "3fb394ab9724fd0074303e8db8a069af", "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844", "relations": [{"rule": 2, "type": "equivalent", "target": "33a0ffa96161ff679efee8f3682926bf", "evidence": {"same_day": true, "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844"}}, {"rule": 2, "type": "equivalent", "target": "5204ac019fa0bddb8a827b6d68df2f7d", "evidence": {"same_day": true, "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844"}}, {"rule": 2, "type": "equivalent", "target": "d816ce82d3cee8b9bb5c0cde21bd1679", "evidence": {"same_day": true, "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844"}}, {"rule": 2, "type": "equivalent", "target": "f2258166bf086da2829dcf83fb8f4237", "evidence": {"same_day": true, "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "5204ac019fa0bddb8a827b6d68df2f7d", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复 FOR [KEY] UPDATE/SHARE 子句中的连接别名匹配", "evidence": {"same_day": true, "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844"}, "url": "/docs/compare/?release=13.8#13.8-eba370b4b92cab65", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "d816ce82d3cee8b9bb5c0cde21bd1679", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "修复 FOR [KEY] UPDATE/SHARE 子句中的连接别名匹配", "evidence": {"same_day": true, "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844"}, "url": "/docs/compare/?release=12.12#12.12-2ef373d2e5ce3d43", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "33a0ffa96161ff679efee8f3682926bf", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "修复 FOR [KEY] UPDATE/SHARE 子句中的连接别名匹配", "evidence": {"same_day": true, "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844"}, "url": "/docs/compare/?release=11.17#11.17-619de24b25ee8688", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "f2258166bf086da2829dcf83fb8f4237", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "修复 FOR [KEY] UPDATE/SHARE 子句中的连接别名匹配", "evidence": {"same_day": true, "patch_ids": ["0ec3a3c4fef6257945d9b21ba4aada4d"], "statement_hash": "58d609514e55505ba2ea42ca37f04edbd8949a5eb8a8ea5ba984628c7c343844"}, "url": "/docs/compare/?release=10.22#10.22-619de24b25ee8688", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-9746a0c962f430c5", "cves": [], "html": "拒绝 FROM 中列数过多的 ROW() 表达式和函数（Tom Lane）§ §
超过约 1600 列的情况不受支持，且在执行时始终会失败。然而，一些较早的代码在查询超过 32K 列时可能被驱动到断言失败或崩溃。增加一个解析时检查以防止此问题。
", "text": "拒绝 FROM 中列数过多的 ROW() 表达式和函数（Tom Lane）§ § 超过约 1600 列的情况不受支持，且在执行时始终会失败。然而，一些较早的代码在查询超过 32K 列时可能被驱动到断言失败或崩溃。增加一个解析时检查以防止此问题。", "title": "拒绝 FROM 中列数过多的 ROW() 表达式和函数", "commits": ["8df167baa", "d947a8bd5"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "5c5156e780fc142504c6016d871087f1f0b2bc08dea3702bf60433fcfbbadea2", "section_path": ["变更"], "commit_groups": [["331f8b851", "51d8b52fc", "5d280bc89", "83f1793d6", "adc3ae6eb", "d54fc7e67", "d947a8bd5"], ["8dea18372", "8df167baa", "ba2002d02", "d79f00e82", "e6a48014d", "e6e804aa2", "fd96d14d9"]], "identity_text": "Reject ROW() expressions and functions in FROM that have too many columns (Tom Lane) Cases with more than about 1600 columns are unsupported, and have always failed at execution. However, it emerges that some earlier code could be driven to assertion failures or crashes by queries with more than 32K columns. Add a parse-time check to prevent that.", "commit_aliases": ["331f8b851", "51d8b52fc", "5d280bc89", "83f1793d6", "8dea18372", "8df167baa", "adc3ae6eb", "ba2002d02", "d54fc7e67", "d79f00e82", "d947a8bd5", "e6a48014d", "e6e804aa2", "fd96d14d9"], "source_commits": ["8df167baa", "d947a8bd5"], "source_entry_id": "14.5/changes/017", "db_id": "a574a843205170775323459850e52fae", "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62", "relations": [{"rule": 2, "type": "equivalent", "target": "16f5d9da2b9f413365c825f2e4283c9d", "evidence": {"same_day": true, "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62"}}, {"rule": 2, "type": "equivalent", "target": "37645836470f6582296291ad73bcb20b", "evidence": {"same_day": true, "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62"}}, {"rule": 2, "type": "equivalent", "target": "97260449d3cc34ebc0034c6974c57408", "evidence": {"same_day": true, "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62"}}, {"rule": 2, "type": "equivalent", "target": "e8bbd129286519ebb12fe4b5d30e4295", "evidence": {"same_day": true, "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62"}}], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "37645836470f6582296291ad73bcb20b", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "拒绝 FROM 中列数过多的 ROW() 表达式和函数", "evidence": {"same_day": true, "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62"}, "url": "/docs/compare/?release=13.8#13.8-793d7ac117a02eb4", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "97260449d3cc34ebc0034c6974c57408", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "拒绝 FROM 中列数过多的 ROW() 表达式和函数", "evidence": {"same_day": true, "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62"}, "url": "/docs/compare/?release=12.12#12.12-7368d1c80903a4e0", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "e8bbd129286519ebb12fe4b5d30e4295", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "拒绝 FROM 中列数过多的 ROW() 表达式和函数", "evidence": {"same_day": true, "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62"}, "url": "/docs/compare/?release=11.17#11.17-bda3ed8d3015dbbd", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "16f5d9da2b9f413365c825f2e4283c9d", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "拒绝 FROM 中列数过多的 ROW() 表达式和函数", "evidence": {"same_day": true, "patch_ids": ["9055e615d9a8d6d26806e22905ca5034", "9acf44510603fce6c93af6cb53e31aaa"], "statement_hash": "cd2a6593748135ac928288235121b47949547cd1d1b7aafd71504995117bed62"}, "url": "/docs/compare/?release=10.22#10.22-bda3ed8d3015dbbd", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-ff5ce1883e1902b4", "cves": [], "html": "修复使用 FROM 中返回复合类型的函数的视图的导出问题，当视图创建后复合类型的列已被删除时（Tom Lane）§
此疏忽可能导致导出/恢复或 pg_upgrade 失败，因为导出的视图会有过多的函数列别名。
", "text": "修复使用 FROM 中返回复合类型的函数的视图的导出问题，当视图创建后复合类型的列已被删除时（Tom Lane）§ 此疏忽可能导致导出/恢复或 pg_upgrade 失败，因为导出的视图会有过多的函数列别名。", "title": "修复使用 FROM 中返回复合类型的函数的视图的导出问题，当视图创建后复合类型的列已被删除时", "commits": ["da9a28fd5"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "0fefa2a992d73a284527f8d471ed3972fe087ed5631080844031cdde77f95cd8", "section_path": ["变更"], "commit_groups": [["1078742af", "5b5d43513", "6bceacfe8", "b243092a6", "b9654cece", "c1d1e8469", "da9a28fd5"]], "identity_text": "Fix dumping of a view using a function in FROM that returns a composite type, when column(s) of the composite type have been dropped since the view was made (Tom Lane) This oversight could lead to dump/reload or pg_upgrade failures, as the dumped view would have too many column aliases for the function.", "commit_aliases": ["1078742af", "5b5d43513", "6bceacfe8", "b243092a6", "b9654cece", "c1d1e8469", "da9a28fd5"], "source_commits": ["da9a28fd5"], "source_entry_id": "14.5/changes/018", "db_id": "e2dcc3bf7286d828d7ba3b5cfd3c8f7d", "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0", "relations": [{"rule": 2, "type": "equivalent", "target": "866cc719eec09451454e7a881d0656bb", "evidence": {"same_day": true, "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0"}}, {"rule": 2, "type": "equivalent", "target": "a3c3f143ea00efd8aee5476c01cff24b", "evidence": {"same_day": true, "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0"}}, {"rule": 2, "type": "equivalent", "target": "b0a7546bd95b932d12119d39edea4cb7", "evidence": {"same_day": true, "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0"}}, {"rule": 2, "type": "equivalent", "target": "d297883d1dccd1466d1a4375490782d2", "evidence": {"same_day": true, "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "d297883d1dccd1466d1a4375490782d2", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复使用 FROM 中返回复合类型的函数的视图的导出问题，当视图创建后复合类型的列已被删除时", "evidence": {"same_day": true, "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0"}, "url": "/docs/compare/?release=13.8#13.8-48cc646037c6175f", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "a3c3f143ea00efd8aee5476c01cff24b", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "修复使用 FROM 中返回复合类型的函数的视图的导出问题，当视图创建后复合类型的列已被删除时", "evidence": {"same_day": true, "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0"}, "url": "/docs/compare/?release=12.12#12.12-a47b71c4eb5c319c", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "b0a7546bd95b932d12119d39edea4cb7", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "修复使用 FROM 中返回复合类型的函数的视图的导出问题，当视图创建后复合类型的列已被删除时", "evidence": {"same_day": true, "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0"}, "url": "/docs/compare/?release=11.17#11.17-3e0aa695f39794ea", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "866cc719eec09451454e7a881d0656bb", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "修复使用 FROM 中返回复合类型的函数的视图的导出问题，当视图创建后复合类型的列已被删除时", "evidence": {"same_day": true, "patch_ids": ["23656715f1aaeed2e828604f3d8b7601"], "statement_hash": "cda8527744e38b5c9686e7a8611aa75bc84e00fc2d86ca67e43bec0b2e566eb0"}, "url": "/docs/compare/?release=10.22#10.22-3e0aa695f39794ea", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-cf59c3e92047a352", "cves": [], "html": "不允许在逻辑复制 walsender 中执行嵌套备份操作（Fujii Masao）§
", "text": "不允许在逻辑复制 walsender 中执行嵌套备份操作（Fujii Masao）§", "title": "不允许在逻辑复制 walsender 中执行嵌套备份操作", "commits": ["2aedf25eb"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "9d6cb7635a1b958b64458b9bcb9252a027f8f67a91fdd05ab951e624ce84a484", "section_path": ["变更"], "commit_groups": [["286793b98", "2aedf25eb", "5630f39b3", "87e504487", "9fa00e312", "dd831afc4", "ee7964776"]], "identity_text": "Disallow nested backup operations in logical replication walsenders (Fujii Masao)", "commit_aliases": ["286793b98", "2aedf25eb", "5630f39b3", "87e504487", "9fa00e312", "dd831afc4", "ee7964776"], "source_commits": ["2aedf25eb"], "source_entry_id": "14.5/changes/019", "db_id": "a2f00771074c74f91e93f347bc991aeb", "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc", "relations": [{"rule": 2, "type": "equivalent", "target": "0671a83dbc975279e2adbc629f4b0881", "evidence": {"same_day": true, "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc"}}, {"rule": 2, "type": "equivalent", "target": "12f6dea62a2252aa39fd3ebfcd1693d7", "evidence": {"same_day": true, "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc"}}, {"rule": 2, "type": "equivalent", "target": "c57da6ba4c012042e1b9b38ec76482b4", "evidence": {"same_day": true, "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc"}}, {"rule": 2, "type": "equivalent", "target": "d356f4baec5c9357cb3bdd52540d035e", "evidence": {"same_day": true, "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc"}}], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "0671a83dbc975279e2adbc629f4b0881", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "不允许在逻辑复制 walsender 中执行嵌套备份操作", "evidence": {"same_day": true, "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc"}, "url": "/docs/compare/?release=13.8#13.8-efb4d7b81adf76b1", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "c57da6ba4c012042e1b9b38ec76482b4", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "不允许在逻辑复制 walsender 中执行嵌套备份操作", "evidence": {"same_day": true, "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc"}, "url": "/docs/compare/?release=12.12#12.12-04862d9c1fa9861e", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "d356f4baec5c9357cb3bdd52540d035e", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "不允许在逻辑复制 walsender 中执行嵌套备份操作", "evidence": {"same_day": true, "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc"}, "url": "/docs/compare/?release=11.17#11.17-34f2aae635548050", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "12f6dea62a2252aa39fd3ebfcd1693d7", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "不允许在逻辑复制 walsender 中执行嵌套备份操作", "evidence": {"same_day": true, "patch_ids": ["c6cdc4f1fb60b037ac48c606f26c9d5f"], "statement_hash": "4a48572206222346f15cb620f6279d636b79d7fbaf7dfa9a265b328528efcfcc"}, "url": "/docs/compare/?release=10.22#10.22-34f2aae635548050", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-4f5025ba61cf2a50", "cves": [], "html": "修复逻辑复制订阅者中的内存泄漏（Hou Zhijie）§
", "text": "修复逻辑复制订阅者中的内存泄漏（Hou Zhijie）§", "title": "修复逻辑复制订阅者中的内存泄漏", "commits": ["3238b5c33"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "797a2e23dcfd0169d2a58dccdebf0be36789435358b8e142ccf5510fe165a3ee", "section_path": ["变更"], "commit_groups": [["3238b5c33", "3a6ef0cdf", "9e0d9a24e", "ac0e2d387", "d873b5a5a", "ed2a7a6bf"]], "identity_text": "Fix memory leak in logical replication subscribers (Hou Zhijie)", "commit_aliases": ["3238b5c33", "3a6ef0cdf", "9e0d9a24e", "ac0e2d387", "d873b5a5a", "ed2a7a6bf"], "source_commits": ["3238b5c33"], "source_entry_id": "14.5/changes/020", "db_id": "61c5b479075eae8a72f17ca3e8d955b8", "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75", "relations": [{"rule": 2, "type": "equivalent", "target": "18e9aa854000311994dbee2d7fadd023", "evidence": {"same_day": true, "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75"}}, {"rule": 2, "type": "equivalent", "target": "230b4855bf5bb9cd4aaee0a7c0084362", "evidence": {"same_day": true, "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75"}}, {"rule": 2, "type": "equivalent", "target": "7161d023732b23d6f187b47cc5774f22", "evidence": {"same_day": true, "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75"}}, {"rule": 2, "type": "equivalent", "target": "a343fad24b31cd090a93924efc9ed686", "evidence": {"same_day": true, "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "7161d023732b23d6f187b47cc5774f22", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复逻辑复制订阅者中的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75"}, "url": "/docs/compare/?release=13.8#13.8-4d5fbe36cf684b64", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "a343fad24b31cd090a93924efc9ed686", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "修复逻辑复制订阅者中的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75"}, "url": "/docs/compare/?release=12.12#12.12-7716a9d45fa08ec9", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "230b4855bf5bb9cd4aaee0a7c0084362", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "修复逻辑复制订阅者中的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75"}, "url": "/docs/compare/?release=11.17#11.17-d40e79c74a2907a7", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "18e9aa854000311994dbee2d7fadd023", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "修复逻辑复制订阅者中的内存泄漏", "evidence": {"same_day": true, "patch_ids": ["539c7d20a0d1a39e7a676fcb986f4254"], "statement_hash": "3752db30a90495d0ebc9d920f2424cf749723996df3a8f64cf980c78dcba5b75"}, "url": "/docs/compare/?release=10.22#10.22-d40e79c74a2907a7", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-45a45afd89888d85", "cves": [], "html": "修复当目标表是分区表时逻辑复制的副本标识检查（Shi Yu，Hou Zhijie）§ §
\n副本标识列必须为子分区重新识别。
", "text": "修复当目标表是分区表时逻辑复制的副本标识检查（Shi Yu，Hou Zhijie）§ § 副本标识列必须为子分区重新识别。", "title": "修复当目标表是分区表时逻辑复制的副本标识检查", "commits": ["52d5ea9ad", "f0022a77d"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "2a675b9635006ebc77bf9da82253b982acb397543e89e47d0e3e17dca1e8c1db", "section_path": ["变更"], "commit_groups": [["26b3455af", "52d5ea9ad", "5f113d60e"], ["419c72715", "75bfe7434", "f0022a77d"]], "identity_text": "Fix logical replication's checking of replica identity when the target table is partitioned (Shi Yu, Hou Zhijie) The replica identity columns have to be re-identified for the child partition.", "commit_aliases": ["26b3455af", "419c72715", "52d5ea9ad", "5f113d60e", "75bfe7434", "f0022a77d"], "source_commits": ["52d5ea9ad", "f0022a77d"], "source_entry_id": "14.5/changes/021", "db_id": "6b04ed5bfc402ce7b54b88180913805a", "patch_ids": ["b9d2f47ec0afee00da393e1ec09d24e1", "d513d8b74384109ba49eca778824ff23"], "statement_hash": "22dcdfd80dcb21a70117360ce904746a9e95e481d842031f4d9ca5d5f8be33ac", "relations": [{"rule": 2, "type": "equivalent", "target": "f3c63e718eb3a547e233cb579028539a", "evidence": {"same_day": true, "patch_ids": ["b9d2f47ec0afee00da393e1ec09d24e1", "d513d8b74384109ba49eca778824ff23"], "statement_hash": "22dcdfd80dcb21a70117360ce904746a9e95e481d842031f4d9ca5d5f8be33ac"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "f3c63e718eb3a547e233cb579028539a", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复当目标表是分区表时逻辑复制的副本标识检查", "evidence": {"same_day": true, "patch_ids": ["b9d2f47ec0afee00da393e1ec09d24e1", "d513d8b74384109ba49eca778824ff23"], "statement_hash": "22dcdfd80dcb21a70117360ce904746a9e95e481d842031f4d9ca5d5f8be33ac"}, "url": "/docs/compare/?release=13.8#13.8-24eba2504179aff7", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}]}, {"id": "14.5-fa667a1e30f5584c", "cves": [], "html": "修复在发布者上发生模式更改后逻辑复制订阅者未能更新缓存模式数据的问题（Shi Yu，Hou Zhijie）§ §
", "text": "修复在发布者上发生模式更改后逻辑复制订阅者未能更新缓存模式数据的问题（Shi Yu，Hou Zhijie）§ §", "title": "修复在发布者上发生模式更改后逻辑复制订阅者未能更新缓存模式数据的问题", "commits": ["0980adfd4", "d457cb4e8"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "76f2506f4241e819014b9299c029fa78ef401b7a8ab67bea55b59ab3701d51eb", "section_path": ["变更"], "commit_groups": [["0980adfd4", "1f9a7738e", "b7658c24c"], ["16f5a8da7", "5a97b1325", "d457cb4e8"]], "identity_text": "Fix failures to update cached schema data in a logical replication subscriber after a schema change on the publisher (Shi Yu, Hou Zhijie)", "commit_aliases": ["0980adfd4", "16f5a8da7", "1f9a7738e", "5a97b1325", "b7658c24c", "d457cb4e8"], "source_commits": ["0980adfd4", "d457cb4e8"], "source_entry_id": "14.5/changes/022", "db_id": "e2f32b0612035fecd442d60a0afe6d58", "patch_ids": ["856cdf9e48f597159b5a0864c283ebc0", "91022437f378be590a1aa568383269d9"], "statement_hash": "c5f11d08bced2a611bfdb640ac158fdc552db888b7f9565f00036a353ef60bac", "relations": [{"rule": 2, "type": "equivalent", "target": "912f1793aec64568ef2518d0859f36ae", "evidence": {"same_day": true, "patch_ids": ["856cdf9e48f597159b5a0864c283ebc0", "91022437f378be590a1aa568383269d9"], "statement_hash": "c5f11d08bced2a611bfdb640ac158fdc552db888b7f9565f00036a353ef60bac"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "912f1793aec64568ef2518d0859f36ae", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复在发布者上发生模式更改后逻辑复制订阅者未能更新缓存模式数据的问题", "evidence": {"same_day": true, "patch_ids": ["856cdf9e48f597159b5a0864c283ebc0", "91022437f378be590a1aa568383269d9"], "statement_hash": "c5f11d08bced2a611bfdb640ac158fdc552db888b7f9565f00036a353ef60bac"}, "url": "/docs/compare/?release=13.8#13.8-c647584ddb132a84", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}]}, {"id": "14.5-1f1c70c64441db39", "cves": [], "html": "修复 WAL 一致性检查逻辑以正确处理 BRIN_EVACUATE_PAGE 标志（Haiyang Wang）§ §
修复共享 hash 表管理中的错误断言检查（Thomas Munro）§
", "text": "修复共享 hash 表管理中的错误断言检查（Thomas Munro）§", "title": "修复共享 hash 表管理中的错误断言检查", "commits": ["5e7608e81"], "section": "变更", "category": "bugfix", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "910c665638f385284c5d617f7c0037ac1e0e5b2b359ca90e96cc38acc5f3dfb9", "section_path": ["变更"], "commit_groups": [["4f88dbac2", "53df1e28d", "5e7608e81", "7cdd0c2d7", "cd26139a3", "eed959a45"]], "identity_text": "Fix erroneous assertion checks in shared hashtable management (Thomas Munro)", "commit_aliases": ["4f88dbac2", "53df1e28d", "5e7608e81", "7cdd0c2d7", "cd26139a3", "eed959a45"], "source_commits": ["5e7608e81"], "source_entry_id": "14.5/changes/024", "db_id": "8c2b3266b36bfc38f3a68b530b103ccd", "patch_ids": ["bb4de33b3d83d4e3d8554acd4082734d"], "statement_hash": "b30bb46ecf1383660549a7273a4d736b860f47944d3b879cfe1ce9476ec6f674", "relations": [{"rule": 2, "type": "equivalent", "target": "4b8e56a817dba1a8e89b8c85fa676440", "evidence": {"same_day": true, "patch_ids": ["bb4de33b3d83d4e3d8554acd4082734d"], "statement_hash": "b30bb46ecf1383660549a7273a4d736b860f47944d3b879cfe1ce9476ec6f674"}}, {"rule": 2, "type": "equivalent", "target": "53e2c0f64c6a1e0b8a484cf8159e16f9", "evidence": {"same_day": true, "patch_ids": ["bb4de33b3d83d4e3d8554acd4082734d"], "statement_hash": "b30bb46ecf1383660549a7273a4d736b860f47944d3b879cfe1ce9476ec6f674"}}, {"rule": 2, "type": "equivalent", "target": "bd1f5175935214421f392fe00d34300c", "evidence": {"same_day": true, "patch_ids": ["bb4de33b3d83d4e3d8554acd4082734d"], "statement_hash": "b30bb46ecf1383660549a7273a4d736b860f47944d3b879cfe1ce9476ec6f674"}}], "version": "14.5", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b8e56a817dba1a8e89b8c85fa676440", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "修复共享 hash 表管理中的错误断言检查", "evidence": {"same_day": true, "patch_ids": ["bb4de33b3d83d4e3d8554acd4082734d"], "statement_hash": "b30bb46ecf1383660549a7273a4d736b860f47944d3b879cfe1ce9476ec6f674"}, "url": "/docs/compare/?release=13.8#13.8-ac4fa795705798e0", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "bd1f5175935214421f392fe00d34300c", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "修复共享 hash 表管理中的错误断言检查", "evidence": {"same_day": true, "patch_ids": ["bb4de33b3d83d4e3d8554acd4082734d"], "statement_hash": "b30bb46ecf1383660549a7273a4d736b860f47944d3b879cfe1ce9476ec6f674"}, "url": "/docs/compare/?release=12.12#12.12-1630b65f549a89ab", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "53e2c0f64c6a1e0b8a484cf8159e16f9", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "修复共享 hash 表管理中的错误断言检查", "evidence": {"same_day": true, "patch_ids": ["bb4de33b3d83d4e3d8554acd4082734d"], "statement_hash": "b30bb46ecf1383660549a7273a4d736b860f47944d3b879cfe1ce9476ec6f674"}, "url": "/docs/compare/?release=11.17#11.17-f97ce44109c92295", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}]}, {"id": "14.5-de06d103380d3eb5", "cves": [], "html": "避免在 min_dynamic_shared_memory 设置为非默认值时出现断言失败（Thomas Munro）§
安排在 SPI_commit() 中的提交时错误后进行清理，而不是期望调用者来做（Peter Eisentraut，Tom Lane）§ §
正确的清理很复杂，需要使用底层设施，因此已知的调用者没有一个做对了也不足为奇。这导致当 PL 过程执行 COMMIT 但发生失败（如延迟约束检查）时出现异常行为。为了改善情况，将 SPI_commit() 重新定义为启动一个新事务，使其等价于 SPI_commit_and_chain()，只是获得默认事务特性而不是保留先前事务的特性。为了使此更改在 API 层面具有一定透明性，将 SPI_start_transaction() 重新定义为空操作。所有已知的 SPI_commit() 调用者都会立即调用 SPI_start_transaction()，因此它们不会注意到任何变化。类似的说明适用于 SPI_rollback()。
另外修复了 PL/Python，它完全遗漏了对此类错误的任何处理，导致跳出 Python 解释器。据报告这会导致 Python 3.11 崩溃。较旧的 Python 版本会泄漏一些内存，但似乎在其他方面没有问题。
", "text": "安排在 SPI_commit() 中的提交时错误后进行清理，而不是期望调用者来做（Peter Eisentraut，Tom Lane）§ § 正确的清理很复杂，需要使用底层设施，因此已知的调用者没有一个做对了也不足为奇。这导致当 PL 过程执行 COMMIT 但发生失败（如延迟约束检查）时出现异常行为。为了改善情况，将 SPI_commit() 重新定义为启动一个新事务，使其等价于 SPI_commit_and_chain()，只是获得默认事务特性而不是保留先前事务的特性。为了使此更改在 API 层面具有一定透明性，将 SPI_start_transaction() 重新定义为空操作。所有已知的 SPI_commit() 调用者都会立即调用 SPI_start_transaction()，因此它们不会注意到任何变化。类似的说明适用于 SPI_rollback()。 另外修复了 PL/Python，它完全遗漏了对此类错误的任何处理，导致跳出 Python 解释器。据报告这会导致 Python 3.11 崩溃。较旧的 Python 版本会泄漏一些内存，但似乎在其他方面没有问题。", "title": "安排在 SPI_commit() 中的提交时错误后进行清理，而不是期望调用者来做", "commits": ["604651880", "8657946d3"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "4e0452d61683387bdf25de03ac7e1af6f6905d81e370570448e6564fb5017c4c", "section_path": ["变更"], "commit_groups": [["293f5c5f4", "2f6b8c287", "604651880", "cfc86f987"], ["6d61aef5d", "8657946d3", "9af9e2094", "b2c8d5661"]], "identity_text": "Arrange to clean up after commit-time errors within SPI_commit(), rather than expecting callers to do that (Peter Eisentraut, Tom Lane) Proper cleanup is complicated and requires use of low-level facilities, so it's not surprising that no known caller got it right. This led to misbehaviors when a PL procedure issued COMMIT but a failure occurred (such as a deferred constraint check). To improve matters, redefine SPI_commit() as starting a new transaction, so that it becomes equivalent to SPI_commit_and_chain() except that you get default transaction characteristics instead of preserving the prior transaction's characteristics. To make this somewhat transparent API-wise, redefine SPI_start_transaction() as a no-op. All known callers of SPI_commit() immediately call SPI_start_transaction(), so they will not notice any change. Similar remarks apply to SPI_rollback(). Also fix PL/Python, which omitted any handling of such errors at all, resulting in jumping out of the Python interpreter. This is reported to crash Python 3.11. Older Python releases leak some memory but seem okay with it otherwise.", "commit_aliases": ["293f5c5f4", "2f6b8c287", "604651880", "6d61aef5d", "8657946d3", "9af9e2094", "b2c8d5661", "cfc86f987"], "source_commits": ["604651880", "8657946d3"], "source_entry_id": "14.5/changes/026", "db_id": "ecc8451032d4a13317ad11b635d6ad8e", "patch_ids": ["8cd48dcc426d6d1641d9d50ec1e5dded", "d63e3f0c4d521046d55f61fcc7d5a995"], "statement_hash": "064fc46ac8d2c682921224db741428e9e0aa63a1501bd5e3048ce36f06b03faf", "relations": [{"rule": 2, "type": "equivalent", "target": "455644e2a0145c42f0c9333e4fd01322", "evidence": {"same_day": true, "patch_ids": ["8cd48dcc426d6d1641d9d50ec1e5dded", "d63e3f0c4d521046d55f61fcc7d5a995"], "statement_hash": "064fc46ac8d2c682921224db741428e9e0aa63a1501bd5e3048ce36f06b03faf"}}, {"rule": 2, "type": "equivalent", "target": "64ccc747dc6132c2023e21bf601a3dcb", "evidence": {"same_day": true, "patch_ids": ["8cd48dcc426d6d1641d9d50ec1e5dded", "d63e3f0c4d521046d55f61fcc7d5a995"], "statement_hash": "064fc46ac8d2c682921224db741428e9e0aa63a1501bd5e3048ce36f06b03faf"}}, {"rule": 2, "type": "equivalent", "target": "f54e497fe75e4fb33cae3f16e790301d", "evidence": {"same_day": true, "patch_ids": ["8cd48dcc426d6d1641d9d50ec1e5dded", "d63e3f0c4d521046d55f61fcc7d5a995"], "statement_hash": "064fc46ac8d2c682921224db741428e9e0aa63a1501bd5e3048ce36f06b03faf"}}], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "f54e497fe75e4fb33cae3f16e790301d", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "安排在 SPI_commit() 中的提交时错误后进行清理，而不是期望调用者来做", "evidence": {"same_day": true, "patch_ids": ["8cd48dcc426d6d1641d9d50ec1e5dded", "d63e3f0c4d521046d55f61fcc7d5a995"], "statement_hash": "064fc46ac8d2c682921224db741428e9e0aa63a1501bd5e3048ce36f06b03faf"}, "url": "/docs/compare/?release=13.8#13.8-8e85ba9504c8f1c4", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "64ccc747dc6132c2023e21bf601a3dcb", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "安排在 SPI_commit() 中的提交时错误后进行清理，而不是期望调用者来做", "evidence": {"same_day": true, "patch_ids": ["8cd48dcc426d6d1641d9d50ec1e5dded", "d63e3f0c4d521046d55f61fcc7d5a995"], "statement_hash": "064fc46ac8d2c682921224db741428e9e0aa63a1501bd5e3048ce36f06b03faf"}, "url": "/docs/compare/?release=12.12#12.12-a333e7979fea0ee2", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "455644e2a0145c42f0c9333e4fd01322", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "安排在 SPI_commit() 中的提交时错误后进行清理，而不是期望调用者来做", "evidence": {"same_day": true, "patch_ids": ["8cd48dcc426d6d1641d9d50ec1e5dded", "d63e3f0c4d521046d55f61fcc7d5a995"], "statement_hash": "064fc46ac8d2c682921224db741428e9e0aa63a1501bd5e3048ce36f06b03faf"}, "url": "/docs/compare/?release=11.17#11.17-eee4e6dea329b6a4", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}]}, {"id": "14.5-65a49b7693311347", "cves": [], "html": "改进 libpq 在管道模式下对空闲状态的处理（Álvaro Herrera，Kyotaro Horiguchi）§ §
\n这修复了 “message type 0x33 arrived from server while idle” 警告，以及 PQgetResult() 可能丢失查询结束时的 NULL 结果。
避免 ecpglib 在意外的操作顺序下出现核心转储（Tom Lane）§
\n某些操作如 EXEC SQL PREPARE 在建立任何数据库连接之前调用时会崩溃（而不是按预期报告错误）。
在 ecpglib 中，避免冗余的 newlocale() 调用（Noah Misch）§ §
在首次连接时每个进程分配一次 C 区域设置对象，而不是每次查询都创建和释放区域设置对象。这缓解了 AIX 上 libc 的内存泄漏问题，并且可能在所有平台上提供一些性能改善。
", "text": "在 ecpglib 中，避免冗余的 newlocale() 调用（Noah Misch）§ § 在首次连接时每个进程分配一次 C 区域设置对象，而不是每次查询都创建和释放区域设置对象。这缓解了 AIX 上 libc 的内存泄漏问题，并且可能在所有平台上提供一些性能改善。", "title": "在 ecpglib 中，避免冗余的 newlocale() 调用", "commits": ["463a841d7", "5b94e2bd4"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "2419e26c3b726c5dc849845b725819e5d4001357ebfb233577b2bd7902ec99db", "section_path": ["变更"], "commit_groups": [["12b2a2369", "5633836ef", "5b94e2bd4", "5e0b8f3f4", "7a28f7cb0", "b4d7e92bd", "d68b731a1"], ["1cad30e3b", "463a841d7", "8533eb181", "97b005f3f", "a4240139f", "e2bc24283", "f5e4d64bb"]], "identity_text": "In ecpglib, avoid redundant newlocale() calls (Noah Misch) Allocate a C locale object once per process when first connecting, rather than creating and freeing locale objects once per query. This mitigates a libc memory leak on AIX, and may offer some performance benefit everywhere.", "commit_aliases": ["12b2a2369", "1cad30e3b", "463a841d7", "5633836ef", "5b94e2bd4", "5e0b8f3f4", "7a28f7cb0", "8533eb181", "97b005f3f", "a4240139f", "b4d7e92bd", "d68b731a1", "e2bc24283", "f5e4d64bb"], "source_commits": ["463a841d7", "5b94e2bd4"], "source_entry_id": "14.5/changes/029", "db_id": "47946dd7c3b3ec8642a88a11e10e2ec2", "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957", "relations": [{"rule": 2, "type": "equivalent", "target": "126fcc988590ce34debe9efd9d3e0c9e", "evidence": {"same_day": true, "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957"}}, {"rule": 2, "type": "equivalent", "target": "2327feff43ef28a431cbd88343c54217", "evidence": {"same_day": true, "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957"}}, {"rule": 2, "type": "equivalent", "target": "629606c1eade321373cade72312a2bdb", "evidence": {"same_day": true, "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957"}}, {"rule": 2, "type": "equivalent", "target": "b78c9e20bd7c102d32e23b23513c5e4b", "evidence": {"same_day": true, "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957"}}], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "2327feff43ef28a431cbd88343c54217", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "在 ecpglib 中，避免冗余的 newlocale() 调用", "evidence": {"same_day": true, "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957"}, "url": "/docs/compare/?release=13.8#13.8-c91d0b4c7c0b155c", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "b78c9e20bd7c102d32e23b23513c5e4b", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "在 ecpglib 中，避免冗余的 newlocale() 调用", "evidence": {"same_day": true, "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957"}, "url": "/docs/compare/?release=12.12#12.12-f21655e3bfc5a5b4", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "126fcc988590ce34debe9efd9d3e0c9e", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "在 ecpglib 中，避免冗余的 newlocale() 调用", "evidence": {"same_day": true, "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957"}, "url": "/docs/compare/?release=11.17#11.17-d91b900feeeb17f7", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "629606c1eade321373cade72312a2bdb", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "在 ecpglib 中，避免冗余的 newlocale() 调用", "evidence": {"same_day": true, "patch_ids": ["4fbdda9712dcf12c5767702d0bb6bcca", "736a7e2d332c231e6239ad95ff829713"], "statement_hash": "efd9ae1c9c31d6f8c977b248d2a79b8babb63b96e0fd6ad4c3edb4bd221f4957"}, "url": "/docs/compare/?release=10.22#10.22-d91b900feeeb17f7", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-f90b4abebb399737", "cves": [], "html": "在 psql 的 \\watch 命令中，使用 control-C 取消后回显换行符（Pavel Stehule）§
这防止 libedit（也可能是 libreadline）对光标所在列的位置产生混乱。
", "text": "在 psql 的 \\watch 命令中，使用 control-C 取消后回显换行符（Pavel Stehule）§ 这防止 libedit（也可能是 libreadline）对光标所在列的位置产生混乱。", "title": "在 psql 的 \\watch 命令中，使用 control-C 取消后回显换行符", "commits": ["ab7fef0ac"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "2952a6e8c2e2c3c61fa9c86025b1b7aa87898e238a32503562adeb46b9d4f55a", "section_path": ["变更"], "commit_groups": [["09224a35c", "21267b647", "21ed12b14", "31b485f88", "7c5953b7b", "ab7fef0ac", "e5b5b4448"]], "identity_text": "In psql's \\watch command, echo a newline after cancellation with control-C (Pavel Stehule) This prevents libedit (and possibly also libreadline) from becoming confused about which column the cursor is in.", "commit_aliases": ["09224a35c", "21267b647", "21ed12b14", "31b485f88", "7c5953b7b", "ab7fef0ac", "e5b5b4448"], "source_commits": ["ab7fef0ac"], "source_entry_id": "14.5/changes/030", "db_id": "1cd9fa8920774d0a5c399f3631b6d8d5", "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc", "relations": [{"rule": 2, "type": "equivalent", "target": "2e80c2a540fd723d13803b390fff3ebf", "evidence": {"same_day": true, "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc"}}, {"rule": 2, "type": "equivalent", "target": "3ec75a25d9045ca44f4f8485a65a6f83", "evidence": {"same_day": true, "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc"}}, {"rule": 2, "type": "equivalent", "target": "77c3114e5f396f10ef9cc7e388e4cc9d", "evidence": {"same_day": true, "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc"}}, {"rule": 2, "type": "equivalent", "target": "c87c80c89ba5bfdfd5473508e0528b58", "evidence": {"same_day": true, "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc"}}], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "3ec75a25d9045ca44f4f8485a65a6f83", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "在 psql 的 \\watch 命令中，使用 control-C 取消后回显换行符", "evidence": {"same_day": true, "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc"}, "url": "/docs/compare/?release=13.8#13.8-9f00b52f499b73e6", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "77c3114e5f396f10ef9cc7e388e4cc9d", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "在 psql 的 \\watch 命令中，使用 control-C 取消后回显换行符", "evidence": {"same_day": true, "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc"}, "url": "/docs/compare/?release=12.12#12.12-0b7e198cdeff2405", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "c87c80c89ba5bfdfd5473508e0528b58", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "在 psql 的 \\watch 命令中，使用 control-C 取消后回显换行符", "evidence": {"same_day": true, "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc"}, "url": "/docs/compare/?release=11.17#11.17-e0c1ae085e4dc0ca", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "2e80c2a540fd723d13803b390fff3ebf", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "在 psql 的 \\watch 命令中，使用 control-C 取消后回显换行符", "evidence": {"same_day": true, "patch_ids": ["f4597a7fe73f219571c869d939d59d5f"], "statement_hash": "6da98e60977a7bf56505b1cd758ac213477664dc14b057c74665fbcc6d5b5edc"}, "url": "/docs/compare/?release=10.22#10.22-e0c1ae085e4dc0ca", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-91ef2d49c2923303", "cves": [], "html": "修复 pg_upgrade 以检测使用 anyarray 的函数的不可升级用法（Justin Pryzby）§ §
版本 14 将一些内置函数改为接受 anycompatiblearray 类型而不是 anyarray。虽然这大多是透明的，但建立在这些函数之上的用户自定义聚合和操作符必须以完全匹配的类型声明。引用旧签名的对象的存在会导致 pg_upgrade 失败，因此改为在开始升级之前检测并报告此类情况。
修复在 pg_upgrade 使用 --clone 选项时 clone() 失败后可能报告错误的错误条件（Justin Pryzby）§
修复 contrib/pg_stat_statements 以避免在 32 位平台上处理非常大的查询文本文件时出现问题（Tom Lane）§
在 contrib/postgres_fdw 中，当存在 WITH CHECK OPTION 约束时阻止批量插入（Etsuro Fujita）§
如果一次插入多行，此类约束无法被正确检查。
", "text": "在 contrib/postgres_fdw 中，当存在 WITH CHECK OPTION 约束时阻止批量插入（Etsuro Fujita）§ 如果一次插入多行，此类约束无法被正确检查。", "title": "在 contrib/postgres_fdw 中，当存在 WITH CHECK OPTION 约束时阻止批量插入", "commits": ["4a9bc2e0f"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "7ae60a1b66455e16ef4329d0a5f4a68dffc0c739a38ac332325ba12e1906c3b7", "section_path": ["变更"], "commit_groups": [["1d49db259", "4a9bc2e0f", "82593b9a3"]], "identity_text": "In contrib/postgres_fdw, prevent batch insertion when there are WITH CHECK OPTION constraints (Etsuro Fujita) Such constraints cannot be checked properly if more than one row is inserted at a time.", "commit_aliases": ["1d49db259", "4a9bc2e0f", "82593b9a3"], "source_commits": ["4a9bc2e0f"], "source_entry_id": "14.5/changes/034", "db_id": "28b463539095c439a8e2a1b8fbface01", "patch_ids": ["ec926ff294980ad5b6baff53e9e77931"], "statement_hash": "76267d237d4f4c6e865870ad179e7bec3f6ed1ef4ab2d8af59016e62d338d3bf", "relations": [], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "14.5-53e0fbd417b732dd", "cves": [], "html": "修复 contrib/postgres_fdw 以检测异步数据获取查询发送失败的情况（Fujii Masao）§
确保 contrib/postgres_fdw 在发送 regconfig 和其他 reg* 类型的常量时使用正确的模式限定（Tom Lane）§
在 Linux 上分配动态共享内存时阻塞信号（Thomas Munro）§ § §
\n这避免了信号中断 posix_fallocate() 时的问题。
检测 shm_open() 的意外 EEXIST 错误（Thomas Munro）§
这避免了在 Solaris 上可能发生的崩溃。
", "text": "检测 shm_open() 的意外 EEXIST 错误（Thomas Munro）§ 这避免了在 Solaris 上可能发生的崩溃。", "title": "检测 shm_open() 的意外 EEXIST 错误", "commits": ["fb81a93a6"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "967c91ed41cfc13970366dbeb2db1b1ca31240b6d6b5e5411fa320e6c42ad439", "section_path": ["变更"], "commit_groups": [["22b9afaf5", "389869af5", "b436047dc", "f7b69b1e3", "facfd0467", "fb81a93a6", "fef8c7a0c"]], "identity_text": "Detect unexpected EEXIST error from shm_open() (Thomas Munro) This avoids a possible crash on Solaris.", "commit_aliases": ["22b9afaf5", "389869af5", "b436047dc", "f7b69b1e3", "facfd0467", "fb81a93a6", "fef8c7a0c"], "source_commits": ["fb81a93a6"], "source_entry_id": "14.5/changes/038", "db_id": "97bdbf15334583735fd7dc1372ebdb9a", "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb", "relations": [{"rule": 2, "type": "equivalent", "target": "2023604b3df6700bb9152bf411313297", "evidence": {"same_day": true, "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb"}}, {"rule": 2, "type": "equivalent", "target": "2458f2e040419b87029c81371ffebe57", "evidence": {"same_day": true, "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb"}}, {"rule": 2, "type": "equivalent", "target": "30bcec4311a48a371f1114302b77ad59", "evidence": {"same_day": true, "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb"}}, {"rule": 2, "type": "equivalent", "target": "cada2ef1980e0dc609cb18ae8547fc0e", "evidence": {"same_day": true, "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb"}}], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "2458f2e040419b87029c81371ffebe57", "kind": "equivalent", "version": "13.8", "label": "13.8", "title": "检测 shm_open() 的意外 EEXIST 错误", "evidence": {"same_day": true, "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb"}, "url": "/docs/compare/?release=13.8#13.8-3815d1ca3beee396", "source_url": "/docs/release/13.8/#id-1.11.6.21.5"}, {"db_id": "30bcec4311a48a371f1114302b77ad59", "kind": "equivalent", "version": "12.12", "label": "12.12", "title": "检测 shm_open() 的意外 EEXIST 错误", "evidence": {"same_day": true, "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb"}, "url": "/docs/compare/?release=12.12#12.12-fefc17491abe11f6", "source_url": "/docs/release/12.12/#id-1.11.6.16.5"}, {"db_id": "2023604b3df6700bb9152bf411313297", "kind": "equivalent", "version": "11.17", "label": "11.17", "title": "检测 shm_open() 的意外 EEXIST 错误", "evidence": {"same_day": true, "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb"}, "url": "/docs/compare/?release=11.17#11.17-6a9471f7a9f7e765", "source_url": "/docs/release/11.17/#id-1.11.6.10.5"}, {"db_id": "cada2ef1980e0dc609cb18ae8547fc0e", "kind": "equivalent", "version": "10.22", "label": "10.22", "title": "检测 shm_open() 的意外 EEXIST 错误", "evidence": {"same_day": true, "patch_ids": ["3ab9804588596690ab1389eefcd01b41"], "statement_hash": "c2e34a862a51659b92e09e36a09517651a4af5a13fbcf91b0c2919546f91afcb"}, "url": "/docs/compare/?release=10.22#10.22-6a9471f7a9f7e765", "source_url": "/docs/release/10.22/#id-1.11.6.6.6"}]}, {"id": "14.5-bb5e489afdfee862", "cves": [], "html": "避免在 illumos 系统上使用 signalfd()（Thomas Munro）§
这似乎会触发挂起和内核恐慌，因此在修复可用之前避免使用该函数。
", "text": "避免在 illumos 系统上使用 signalfd()（Thomas Munro）§ 这似乎会触发挂起和内核恐慌，因此在修复可用之前避免使用该函数。", "title": "避免在 illumos 系统上使用 signalfd()", "commits": ["e086b5538"], "section": "变更", "category": "improvement", "source_url": "/docs/release/14.5/#ZH-AUTO-RELEASE-14-SECT2-36", "source_hash": "2d720c86c9b094bb20a1a16fb67cf5941cb8ef5db57796261762eaf1afe2d816", "section_path": ["变更"], "commit_groups": [["3ab4fc5dc", "e086b5538"]], "identity_text": "Avoid using signalfd() on illumos systems (Thomas Munro) This appears to trigger hangs and kernel panics, so avoid the function until a fix is available.", "commit_aliases": ["3ab4fc5dc", "e086b5538"], "source_commits": ["e086b5538"], "source_entry_id": "14.5/changes/039", "db_id": "d71138b173a0afef6e9f32d270098bd0", "patch_ids": ["03564a7bd965932a8e7a7f34c17e1c82"], "statement_hash": "48cb83b0d7539aba449edb8da368b840b7ce4555d86c363614be89c4d4970421", "relations": [], "version": "14.5", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": []}]}], "stats": [{"key": "all", "label": "全部变更", "count": 39}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 18}, {"key": "security", "label": "安全相关", "count": 2}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 19}], "total": 39, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2022-1552", "url": "https://www.postgresql.org/support/security/CVE-2022-1552/", "fixed": {"10": "10.21", "11": "11.16", "12": "12.11", "13": "13.7", "14": "14.3"}, "score": 8.8, "title": "修复 CREATE INDEX 中的权限检查", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"10": "10", "11": "11", "12": "12", "13": "13", "14": "14"}, "component": "core server", "published": {"10": "2022-05-12", "11": "2022-05-12", "12": "2022-05-12", "13": "2022-05-12", "14": "2022-05-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Autovacuum, REINDEX , CREATE INDEX , REFRESH MATERIALIZED VIEW , CLUSTER , and pg_amcheck made incomplete efforts to operate safely when a privileged user is maintaining another user's objects. Those commands activated relevant protections too late or not at all. An attacker having permission to create non-temp objects in at least one schema could execute arbitrary SQL functions under a superuser identity.\n\nWhile promptly updating PostgreSQL is the best remediation for most users, a user unable to do that can work around the vulnerability by disabling autovacuum, not manually running the above commands, and not restoring from output of the pg_dump command. Performance may degrade quickly under this workaround. VACUUM is safe, and all commands are fine when a trusted user owns the target object.\n\nThe PostgreSQL project thanks Alexander Lakhin for reporting this problem.", "first_published": "2022-05-12", "fixed_version": "14.3"}, {"id": "CVE-2022-2625", "url": "https://www.postgresql.org/support/security/CVE-2022-2625/", "fixed": {"10": "10.22", "11": "11.17", "12": "12.12", "13": "13.8", "14": "14.5"}, "score": 7.1, "title": "不允许扩展脚本替换不属于该扩展的已有对象", "vector": "AV:N/AC:H/PR:L/UI:R/S:U/C:H/I:H/A:H", "affected": {"10": "10", "11": "11", "12": "12", "13": "13", "14": "14"}, "component": "core server", "published": {"10": "2022-08-11", "11": "2022-08-11", "12": "2022-08-11", "13": "2022-08-11", "14": "2022-08-11"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Some extensions use CREATE OR REPLACE or CREATE IF NOT EXISTS commands. Some don't adhere to the documented rule to target only objects known to be extension members already. An attack requires permission to create non-temporary objects in at least one schema, ability to lure or wait for an administrator to create or update an affected extension in that schema, and ability to lure or wait for a victim to use the object targeted in CREATE OR REPLACE or CREATE IF NOT EXISTS . Given all three prerequisites, the attacker can run arbitrary code as the victim role, which may be a superuser. Known-affected extensions include both PostgreSQL-bundled and non-bundled extensions. PostgreSQL is blocking this attack in the core server, so there's no need to modify individual extensions.\n\nThe PostgreSQL project thanks Sven Klemm for reporting this problem.", "first_published": "2022-08-11", "fixed_version": "14.5"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 39, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}