{"Entry":{"collection":"sqlstate","key":"22P07","name":"22P07","aliases":[],"metadata":{"aliases":[],"case_count":0,"class_code":"22","condition_name":"datum_version_mismatch","condition_names":["datum_version_mismatch"],"depth":"reference","editorial_review":"reviewed","evidence_tier":"source_path_confirmed","introduced":null,"known_present_by":"14.25","macros":["ERRCODE_DATUM_VERSION_MISMATCH"],"name_zh":"数据值版本不匹配","present_in":["14","15","16","17","18","19"],"preview_in":["19"],"primary_macro":"ERRCODE_DATUM_VERSION_MISMATCH","removed":null,"runtime_verification":"","severity_classes":["E"],"snippet_count":0,"source_rev":"sqlstate-20261112:4436530af7c8a50b58a92aa7598f7d6d2e01a7154aedcc94d47eb25c1905c9be","sqlstate":"22P07","status":"active","summary_zh":"复合类型数据与元组描述符的行类型版本不兼容。"}},"Definition":{"Collection":"sqlstate","Key":"22P07","SourceDatabase":"center","Version":"18","SourceTable":"sqlstate","SourceKey":"22P07","SourceRevision":"f5c41f6681c910b3f69951bf6fb97c6d74605d25","Facts":{"aliases":[],"class_name":"Data Exception","condition_name":"datum_version_mismatch","doc":{"anchor":"ERRCODES-TABLE","file":"errcodes-appendix.html","lang":"en","sha256":"34dd34c99a9dc409c0def1e69063854b2e7bdc1b69620fe045e8be525de99803","slug":"18"},"lang":"en","minimum_minor":"18.7","release":{"revision":"f5c41f6681c910b3f69951bf6fb97c6d74605d25","version":"18.7"},"sqlstate":"22P07"},"ManualEvidence":{"doc":{"anchor":"ERRCODES-TABLE","file":"errcodes-appendix.html","lang":"en","sha256":"34dd34c99a9dc409c0def1e69063854b2e7bdc1b69620fe045e8be525de99803","slug":"18"},"release":{"revision":"f5c41f6681c910b3f69951bf6fb97c6d74605d25","version":"18.7"}},"MeasuredEvidence":{}},"Text":{"Collection":"sqlstate","Key":"22P07","SourceDatabase":"center","Version":"","Locale":"zh-Hans","Title":"22P07 数据值版本不匹配","Summary":"复合类型数据与元组描述符的行类型版本不兼容。","BodyHTML":"\u003cp\u003eSQLSTATE \u003ccode\u003e22P07\u003c/code\u003e（\u003ccode\u003edatum_version_mismatch\u003c/code\u003e）属于 \u003ccode\u003e22\u003c/code\u003e 类“数据异常”，源码宏为 \u003ccode\u003eERRCODE_DATUM_VERSION_MISMATCH\u003c/code\u003e。\u003c/p\u003e\n\u003cp\u003e复合类型数据与元组描述符的行类型版本不兼容。 PostgreSQL 19rc2 源码在此处报告“数据创建后，其元组的行类型已被修改”或“解构行类型时使用了过期的元组描述符”，并提示查看服务器日志。排查时应核对此前的类型或表结构变更，以及服务器日志中的详细信息。\u003c/p\u003e\n\u003cp\u003e此错误码已收录于 \u003cstrong\u003e14.25, 15.20, 16.16, 17.12, 18.7, 19rc2\u003c/strong\u003e，而各分支紧邻的上一版 14.24、15.19、16.15、17.11、18.6、19rc1 均未定义它。这些是分别核对的小版本边界：该码已回补至稳定分支，并非 PG19 独有；不能据此认为这些大版本的所有早期小版本都包含它。本次未推进已封存的 PG20 开发快照。\u003c/p\u003e\n\u003cp\u003e定义与报文依据固定发布源码核对，参见 \u003ca href=\"https://github.com/postgres/postgres/blob/dffcca2e3c81178c64d4c1f44543a3507d0b7508/src/backend/access/common/heaptuple.c\" rel=\"nofollow\"\u003ePostgreSQL 19rc2 的 heaptuple.c\u003c/a\u003e。本条目没有新增运行时复现实测。\u003c/p\u003e\n","SourceRevision":"sqlstate-20261112:4436530af7c8a50b58a92aa7598f7d6d2e01a7154aedcc94d47eb25c1905c9be","ContentHash":"09451669ebab68040a3d943279c9f4513519ba003676400a04a2b60248057dd8","Payload":{"body_md":"SQLSTATE `22P07`（`datum_version_mismatch`）属于 `22` 类“数据异常”，源码宏为 `ERRCODE_DATUM_VERSION_MISMATCH`。\n\n复合类型数据与元组描述符的行类型版本不兼容。 PostgreSQL 19rc2 源码在此处报告“数据创建后，其元组的行类型已被修改”或“解构行类型时使用了过期的元组描述符”，并提示查看服务器日志。排查时应核对此前的类型或表结构变更，以及服务器日志中的详细信息。\n\n此错误码已收录于 **14.25, 15.20, 16.16, 17.12, 18.7, 19rc2**，而各分支紧邻的上一版 14.24、15.19、16.15、17.11、18.6、19rc1 均未定义它。这些是分别核对的小版本边界：该码已回补至稳定分支，并非 PG19 独有；不能据此认为这些大版本的所有早期小版本都包含它。本次未推进已封存的 PG20 开发快照。\n\n定义与报文依据固定发布源码核对，参见 [PostgreSQL 19rc2 的 heaptuple.c](https://github.com/postgres/postgres/blob/dffcca2e3c81178c64d4c1f44543a3507d0b7508/src/backend/access/common/heaptuple.c)。本条目没有新增运行时复现实测。\n","description":"datum_version_mismatch","is_stale":false,"manual_versions":["14","15","16","17","18","19"],"name":"数据值版本不匹配","sections":[{"anchor":"meaning","heading":"含义与版本边界","html":"\u003cp\u003eSQLSTATE \u003ccode\u003e22P07\u003c/code\u003e（\u003ccode\u003edatum_version_mismatch\u003c/code\u003e）属于 \u003ccode\u003e22\u003c/code\u003e 类“数据异常”，源码宏为 \u003ccode\u003eERRCODE_DATUM_VERSION_MISMATCH\u003c/code\u003e。\u003c/p\u003e\n\u003cp\u003e复合类型数据与元组描述符的行类型版本不兼容。 PostgreSQL 19rc2 源码在此处报告“数据创建后，其元组的行类型已被修改”或“解构行类型时使用了过期的元组描述符”，并提示查看服务器日志。排查时应核对此前的类型或表结构变更，以及服务器日志中的详细信息。\u003c/p\u003e\n\u003cp\u003e此错误码已收录于 \u003cstrong\u003e14.25, 15.20, 16.16, 17.12, 18.7, 19rc2\u003c/strong\u003e，而各分支紧邻的上一版 14.24、15.19、16.15、17.11、18.6、19rc1 均未定义它。这些是分别核对的小版本边界：该码已回补至稳定分支，并非 PG19 独有；不能据此认为这些大版本的所有早期小版本都包含它。本次未推进已封存的 PG20 开发快照。\u003c/p\u003e\n\u003cp\u003e定义与报文依据固定发布源码核对，参见 \u003ca href=\"https://github.com/postgres/postgres/blob/dffcca2e3c81178c64d4c1f44543a3507d0b7508/src/backend/access/common/heaptuple.c\"\u003ePostgreSQL 19rc2 的 heaptuple.c\u003c/a\u003e。本条目没有新增运行时复现实测。\u003c/p\u003e"}],"summary":"复合类型数据与元组描述符的行类型版本不兼容。","title":"22P07 数据值版本不匹配","translation_source_rev":"dffcca2e3c81178c64d4c1f44543a3507d0b7508"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["14","15","16","17","18","19"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":{"class":"22","class_name":"Data Exception","condition_name":"datum_version_mismatch","english_manuals":{"14":{"aliases":[],"class_name":"Data Exception","condition_name":"datum_version_mismatch","doc":{"anchor":"ERRCODES-TABLE","file":"errcodes-appendix.html","lang":"en","sha256":"1318f2181d4eed44ec35b3c480f46a3053dd592b6105a1cdf3a890891611ec07","slug":"14"},"lang":"en","minimum_minor":"14.25","release":{"revision":"9adcf5f8847e0f485a390b1d3ea40688068d71bd","version":"14.25"},"sqlstate":"22P07"},"15":{"aliases":[],"class_name":"Data Exception","condition_name":"datum_version_mismatch","doc":{"anchor":"ERRCODES-TABLE","file":"errcodes-appendix.html","lang":"en","sha256":"b1f555cab1c471994db7b16d7c73d100ed2bb7d0bbf45086e9d06ccffd206f10","slug":"15"},"lang":"en","minimum_minor":"15.20","release":{"revision":"6a84c5137e820f46f0123276f546eec5b9a56e70","version":"15.20"},"sqlstate":"22P07"},"16":{"aliases":[],"class_name":"Data Exception","condition_name":"datum_version_mismatch","doc":{"anchor":"ERRCODES-TABLE","file":"errcodes-appendix.html","lang":"en","sha256":"027a4423eb0a220e24f4788a1fcc4127abba2f2f85795ba3f0d206d3bc6a74d8","slug":"16"},"lang":"en","minimum_minor":"16.16","release":{"revision":"c0534eb02de050ac1035ad7b3ad7c3f02980f153","version":"16.16"},"sqlstate":"22P07"},"17":{"aliases":[],"class_name":"Data Exception","condition_name":"datum_version_mismatch","doc":{"anchor":"ERRCODES-TABLE","file":"errcodes-appendix.html","lang":"en","sha256":"fbd4d7c8b039fde231c2ecc1b540c07feaebe7897e66a9d6cb2dbdec9a00bda9","slug":"17"},"lang":"en","minimum_minor":"17.12","release":{"revision":"702b3dc86d35bcc08c8e23cffa3c4d9fe9d32c85","version":"17.12"},"sqlstate":"22P07"},"18":{"aliases":[],"class_name":"Data Exception","condition_name":"datum_version_mismatch","doc":{"anchor":"ERRCODES-TABLE","file":"errcodes-appendix.html","lang":"en","sha256":"34dd34c99a9dc409c0def1e69063854b2e7bdc1b69620fe045e8be525de99803","slug":"18"},"lang":"en","minimum_minor":"18.7","release":{"revision":"f5c41f6681c910b3f69951bf6fb97c6d74605d25","version":"18.7"},"sqlstate":"22P07"},"19":{"aliases":[],"class_name":"Data Exception","condition_name":"datum_version_mismatch","doc":{"anchor":"ERRCODES-TABLE","file":"errcodes-appendix.html","lang":"en","sha256":"011541c4573d79dbd3c85ea522652de9c162539e20f2298a900bf508564e6b0b","slug":"19"},"lang":"en","minimum_minor":"19rc2","release":{"revision":"dffcca2e3c81178c64d4c1f44543a3507d0b7508","version":"19rc2"},"sqlstate":"22P07"}},"introduced":null,"known_present_by":"14.25","macros":["ERRCODE_DATUM_VERSION_MISMATCH"],"manual_presence":["14","15","16","17","18","19"],"present_in_snapshots":["14.25","15.20","16.16","17.12","18.7","19rc2"],"preview_in_snapshots":["19rc2"],"primary_macro":"ERRCODE_DATUM_VERSION_MISMATCH","release_boundaries":{"14":{"commit":"9adcf5f8847e0f485a390b1d3ea40688068d71bd","previous_release":"14.24","previous_sha256":"c3c967fa20577f7ded946cb99e1a4706b85bb2476fd32d7e4a133c971a603552","release":"14.25","sha256":"d8a01ebc162a874b800db97e3677f642e6dd6a5161d4a7111821ddc38fd4f555","tag":"REL_14_25"},"15":{"commit":"6a84c5137e820f46f0123276f546eec5b9a56e70","previous_release":"15.19","previous_sha256":"a34b5fccd8a27c92817314dd942b79e76896cd1d9a8d4be21c81b02227850b4a","release":"15.20","sha256":"0000d73a83aa1907cf1fd1262cd781b32086720619892361e35bbc6bfa2a7a83","tag":"REL_15_20"},"16":{"commit":"c0534eb02de050ac1035ad7b3ad7c3f02980f153","previous_release":"16.15","previous_sha256":"1d1d741b7b7c6dfd8275287e31c79befed75f3b9349e1a42ef0ca147c429ff88","release":"16.16","sha256":"9f95161e1438d3f06db7e5a81514b4e59b7ddb221f1f2eac63a804a2c225177f","tag":"REL_16_16"},"17":{"commit":"702b3dc86d35bcc08c8e23cffa3c4d9fe9d32c85","previous_release":"17.11","previous_sha256":"bb53279934510355eb4135a807c90d989f07650bd90f87026a4441f11d3296b1","release":"17.12","sha256":"4fe9deea25725fa04e8374b07587a2f2335cea1b586592be583ae3a1af804571","tag":"REL_17_12"},"18":{"commit":"f5c41f6681c910b3f69951bf6fb97c6d74605d25","previous_release":"18.6","previous_sha256":"6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba","release":"18.7","sha256":"b8b7f9f0e3238bcd0db4de2a938be2ee7a145721974c59fa6b4239eb34581bd2","tag":"REL_18_7"},"19":{"commit":"dffcca2e3c81178c64d4c1f44543a3507d0b7508","previous_release":"19rc1","previous_sha256":"cadb9e83cde9a8699a7e74448891ca623af8579ccc8e11c7e533fb47cbc42f89","release":"19rc2","sha256":"21ed56c2fe97a7f4f324a3d02a984211b04db43a032f1b04046f0511fcac1c14","tag":"REL_19_RC2"}},"removed":null,"severity_classes":["E"],"sqlstate":"22P07","status":"active"},"Evidence":[{"Kind":"sources","Ordinal":0,"ID":"errcodes.14","ServerVersion":null,"Status":null,"Payload":{"commit":"9adcf5f8847e0f485a390b1d3ea40688068d71bd","docs_url":"https://www.postgresql.org/docs/14/errcodes-appendix.html","kind":"upstream_source","location":"204","path":"src/backend/utils/errcodes.txt","position":0,"sha256":"d8a01ebc162a874b800db97e3677f642e6dd6a5161d4a7111821ddc38fd4f555","source_id":"errcodes.14","tag":"REL_14_25","url":"https://github.com/postgres/postgres/blob/9adcf5f8847e0f485a390b1d3ea40688068d71bd/src/backend/utils/errcodes.txt#L204"}},{"Kind":"sources","Ordinal":1,"ID":"errcodes.15","ServerVersion":null,"Status":null,"Payload":{"commit":"6a84c5137e820f46f0123276f546eec5b9a56e70","docs_url":"https://www.postgresql.org/docs/15/errcodes-appendix.html","kind":"upstream_source","location":"204","path":"src/backend/utils/errcodes.txt","position":1,"sha256":"0000d73a83aa1907cf1fd1262cd781b32086720619892361e35bbc6bfa2a7a83","source_id":"errcodes.15","tag":"REL_15_20","url":"https://github.com/postgres/postgres/blob/6a84c5137e820f46f0123276f546eec5b9a56e70/src/backend/utils/errcodes.txt#L204"}},{"Kind":"sources","Ordinal":2,"ID":"errcodes.16","ServerVersion":null,"Status":null,"Payload":{"commit":"c0534eb02de050ac1035ad7b3ad7c3f02980f153","docs_url":"https://www.postgresql.org/docs/16/errcodes-appendix.html","kind":"upstream_source","location":"204","path":"src/backend/utils/errcodes.txt","position":2,"sha256":"9f95161e1438d3f06db7e5a81514b4e59b7ddb221f1f2eac63a804a2c225177f","source_id":"errcodes.16","tag":"REL_16_16","url":"https://github.com/postgres/postgres/blob/c0534eb02de050ac1035ad7b3ad7c3f02980f153/src/backend/utils/errcodes.txt#L204"}},{"Kind":"sources","Ordinal":3,"ID":"errcodes.17","ServerVersion":null,"Status":null,"Payload":{"commit":"702b3dc86d35bcc08c8e23cffa3c4d9fe9d32c85","docs_url":"https://www.postgresql.org/docs/17/errcodes-appendix.html","kind":"upstream_source","location":"204","path":"src/backend/utils/errcodes.txt","position":3,"sha256":"4fe9deea25725fa04e8374b07587a2f2335cea1b586592be583ae3a1af804571","source_id":"errcodes.17","tag":"REL_17_12","url":"https://github.com/postgres/postgres/blob/702b3dc86d35bcc08c8e23cffa3c4d9fe9d32c85/src/backend/utils/errcodes.txt#L204"}},{"Kind":"sources","Ordinal":4,"ID":"errcodes.18","ServerVersion":null,"Status":null,"Payload":{"commit":"f5c41f6681c910b3f69951bf6fb97c6d74605d25","docs_url":"https://www.postgresql.org/docs/18/errcodes-appendix.html","kind":"upstream_source","location":"210","path":"src/backend/utils/errcodes.txt","position":4,"sha256":"b8b7f9f0e3238bcd0db4de2a938be2ee7a145721974c59fa6b4239eb34581bd2","source_id":"errcodes.18","tag":"REL_18_7","url":"https://github.com/postgres/postgres/blob/f5c41f6681c910b3f69951bf6fb97c6d74605d25/src/backend/utils/errcodes.txt#L210"}},{"Kind":"sources","Ordinal":5,"ID":"errcodes.19","ServerVersion":null,"Status":null,"Payload":{"commit":"dffcca2e3c81178c64d4c1f44543a3507d0b7508","docs_url":"https://www.postgresql.org/docs/19/errcodes-appendix.html","kind":"upstream_source","location":"210","path":"src/backend/utils/errcodes.txt","position":5,"sha256":"21ed56c2fe97a7f4f324a3d02a984211b04db43a032f1b04046f0511fcac1c14","source_id":"errcodes.19","tag":"REL_19_RC2","url":"https://github.com/postgres/postgres/blob/dffcca2e3c81178c64d4c1f44543a3507d0b7508/src/backend/utils/errcodes.txt#L210"}}]}