{"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":"en","Title":"22P07 Datum version mismatch","Summary":"A composite datum and its tuple descriptor have incompatible row-type versions.","BodyHTML":"\u003cp\u003eSQLSTATE \u003ccode\u003e22P07\u003c/code\u003e (\u003ccode\u003edatum_version_mismatch\u003c/code\u003e) belongs to class \u003ccode\u003e22\u003c/code\u003e, Data Exception. Its source macro is \u003ccode\u003eERRCODE_DATUM_VERSION_MISMATCH\u003c/code\u003e.\u003c/p\u003e\n\u003cp\u003eA composite datum and its tuple descriptor have incompatible row-type versions. In PostgreSQL 19rc2, the source reports either “row type of datum tuple was altered after the datum\u0026#39;s creation” or “using outdated tuple descriptor when deforming row type”, and directs the reader to the server log for details. Inspect the preceding type or table definition changes and the server log when diagnosing this condition.\u003c/p\u003e\n\u003cp\u003eThe code is present in \u003cstrong\u003e14.25, 15.20, 16.16, 17.12, 18.7, 19rc2\u003c/strong\u003e. It is absent from each immediately preceding release: 14.24, 15.19, 16.15, 17.11, 18.6 and 19rc1. These are separate branch boundaries; the code was backpatched to supported branches and is not exclusive to PostgreSQL 19. Earlier minor releases within these major versions do not define it. The retained PostgreSQL 20 development snapshot has not been advanced by this update.\u003c/p\u003e\n\u003cp\u003eDefinition and message evidence comes from the fixed release sources, including \u003ca href=\"https://github.com/postgres/postgres/blob/dffcca2e3c81178c64d4c1f44543a3507d0b7508/src/backend/access/common/heaptuple.c\" rel=\"nofollow\"\u003ePostgreSQL 19rc2 heaptuple.c\u003c/a\u003e. No runtime reproduction was performed for this entry.\u003c/p\u003e\n","SourceRevision":"sqlstate-20261112:4436530af7c8a50b58a92aa7598f7d6d2e01a7154aedcc94d47eb25c1905c9be","ContentHash":"099a23d5a43c44f313d88c85848206e94eaf27a08811f9e0d4c879da82a43286","Payload":{"body_md":"SQLSTATE `22P07` (`datum_version_mismatch`) belongs to class `22`, Data Exception. Its source macro is `ERRCODE_DATUM_VERSION_MISMATCH`.\n\nA composite datum and its tuple descriptor have incompatible row-type versions. In PostgreSQL 19rc2, the source reports either “row type of datum tuple was altered after the datum's creation” or “using outdated tuple descriptor when deforming row type”, and directs the reader to the server log for details. Inspect the preceding type or table definition changes and the server log when diagnosing this condition.\n\nThe code is present in **14.25, 15.20, 16.16, 17.12, 18.7, 19rc2**. It is absent from each immediately preceding release: 14.24, 15.19, 16.15, 17.11, 18.6 and 19rc1. These are separate branch boundaries; the code was backpatched to supported branches and is not exclusive to PostgreSQL 19. Earlier minor releases within these major versions do not define it. The retained PostgreSQL 20 development snapshot has not been advanced by this update.\n\nDefinition and message evidence comes from the fixed release sources, including [PostgreSQL 19rc2 heaptuple.c](https://github.com/postgres/postgres/blob/dffcca2e3c81178c64d4c1f44543a3507d0b7508/src/backend/access/common/heaptuple.c). No runtime reproduction was performed for this entry.\n","description":"datum_version_mismatch","is_stale":false,"manual_versions":["14","15","16","17","18","19"],"name":"Datum version mismatch","sections":[{"anchor":"meaning","heading":"Meaning and version boundaries","html":"\u003cp\u003eSQLSTATE \u003ccode\u003e22P07\u003c/code\u003e (\u003ccode\u003edatum_version_mismatch\u003c/code\u003e) belongs to class \u003ccode\u003e22\u003c/code\u003e, Data Exception. Its source macro is \u003ccode\u003eERRCODE_DATUM_VERSION_MISMATCH\u003c/code\u003e.\u003c/p\u003e\n\u003cp\u003eA composite datum and its tuple descriptor have incompatible row-type versions. In PostgreSQL 19rc2, the source reports either “row type of datum tuple was altered after the datum's creation” or “using outdated tuple descriptor when deforming row type”, and directs the reader to the server log for details. Inspect the preceding type or table definition changes and the server log when diagnosing this condition.\u003c/p\u003e\n\u003cp\u003eThe code is present in \u003cstrong\u003e14.25, 15.20, 16.16, 17.12, 18.7, 19rc2\u003c/strong\u003e. It is absent from each immediately preceding release: 14.24, 15.19, 16.15, 17.11, 18.6 and 19rc1. These are separate branch boundaries; the code was backpatched to supported branches and is not exclusive to PostgreSQL 19. Earlier minor releases within these major versions do not define it. The retained PostgreSQL 20 development snapshot has not been advanced by this update.\u003c/p\u003e\n\u003cp\u003eDefinition and message evidence comes from the fixed release sources, including \u003ca href=\"https://github.com/postgres/postgres/blob/dffcca2e3c81178c64d4c1f44543a3507d0b7508/src/backend/access/common/heaptuple.c\"\u003ePostgreSQL 19rc2 heaptuple.c\u003c/a\u003e. No runtime reproduction was performed for this entry.\u003c/p\u003e"}],"summary":"A composite datum and its tuple descriptor have incompatible row-type versions.","title":"22P07 Datum version mismatch","translation_source_rev":""}},"RequestedLocale":"en","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"}}]}