{"Entry":{"collection":"sqlstate","key":"42P21","name":"42P21","aliases":[],"metadata":{"aliases":[],"case_count":0,"class_code":"42","condition_name":"collation_mismatch","condition_names":["collation_mismatch"],"content_hash":"361c05a8b6445ed80e1ad33fd2cf776a13c0ff09b03d7d1539981e4275df4ae8","depth":"reference","editorial_review":"reviewed","evidence_tier":"source_path_confirmed","imported_at":"2026-09-30T17:45:27.778302+08:00","introduced":null,"known_present_by":"9.1.0","macros":["ERRCODE_COLLATION_MISMATCH"],"name_zh":"排序规则不匹配","present_in":["9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19"],"preview_in":["19"],"primary_macro":"ERRCODE_COLLATION_MISMATCH","removed":null,"runtime_verification":"not_run","severity_classes":["E"],"snippet_count":0,"source_rev":"english-manuals:b5d4c7d86be08cb3fc3124799c6c721a76c6e26b8ee8a84e6887686f790435f2","sqlstate":"42P21","status":"active","summary_zh":"参与运算的排序规则不兼容，产生冲突。"}},"Definition":{"Collection":"sqlstate","Key":"42P21","SourceDatabase":"center","Version":"18","SourceTable":"sqlstate","SourceKey":"42P21","SourceRevision":"english-manuals:b5d4c7d86be08cb3fc3124799c6c721a76c6e26b8ee8a84e6887686f790435f2","Facts":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"56dacf78e618ff0fd8c533e05db597b80d7ebbad7f8e512a888217d0640aa328","slug":"18"},"lang":"en","sqlstate":"42P21"},"ManualEvidence":{"doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"56dacf78e618ff0fd8c533e05db597b80d7ebbad7f8e512a888217d0640aa328","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"sqlstate","Key":"42P21","SourceDatabase":"center","Version":"","Locale":"zh-Hans","Title":"42P21 — 排序规则不匹配","Summary":"参与运算的排序规则不兼容，产生冲突。","BodyHTML":"\u003ch1\u003e42P21 — 排序规则不匹配\u003c/h1\u003e\n\u003ch2\u003e速览 {#at-a-glance}\u003c/h2\u003e\n\u003cp\u003e\u003ccode\u003e42P21\u003c/code\u003e（\u003cstrong\u003ecollation_mismatch\u003c/strong\u003e）需要得到兼容结果时，不同排序规则选择可能发生冲突。\u003c/p\u003e\n\u003ch2\u003e含义 {#meaning}\u003c/h2\u003e\n\u003cp\u003e当固定源码路径需要一个兼容的排序规则，却得到不兼容的选择时，会报 \u003ccode\u003e42P21\u003c/code\u003e。隐式选择会先记录为 \u003ccode\u003eCOLLATE_CONFLICT\u003c/code\u003e；调用方允许没有共同排序规则时可以返回 \u003ccode\u003eInvalidOid\u003c/code\u003e，只有确实需要排序规则的调用方才把隐式冲突变成 \u003ccode\u003eERROR\u003c/code\u003e。显式 \u003ccode\u003eCOLLATE\u003c/code\u003e 冲突则立即失败。同一条件还覆盖递归 CTE 输出、继承或子表列定义，以及外键键列兼容性。\u003c/p\u003e\n\u003ch2\u003e诊断 {#diagnosis}\u003c/h2\u003e\n\u003cp\u003e遇到隐式排序规则消息时保留两个名称，并检查调用方是否要求共同排序规则；不同的隐式操作数不会全部立即抛出 \u003ccode\u003e42P21\u003c/code\u003e。遇到显式排序规则消息时，找出两个 \u003ccode\u003eCOLLATE\u003c/code\u003e 子句并统一预期选择。递归查询要比较非递归项与整体列排序规则。继承或分区子表错误要比较父表与子表列定义。外键要比较引用表和被引用表的键列：固定源码允许两边都是确定性排序规则时使用不同排序规则；只要任一排序规则不确定，两边就必须相同。保留 DETAIL 中的名称，不要把它笼统当成转成 text 就能解决的问题。\u003c/p\u003e\n\u003ch2\u003e处理 {#response}\u003c/h2\u003e\n\u003cp\u003e表达式冲突应在表达式边界明确指定一个有意选择的 \u003ccode\u003eCOLLATE\u003c/code\u003e，或统一显式子句及递归非递归项的排序规则。重试 DDL 前先对齐继承列或子表列定义。外键应选择兼容的键列排序规则；只要一侧不确定，就满足两边相同的严格要求，然后重新核对相等比较和索引语义。如果该 \u003ccode\u003eERROR\u003c/code\u003e 发生在显式事务中，修正语句前先 \u003ccode\u003eROLLBACK\u003c/code\u003e，或回滚到错误前的保存点；自动提交模式下连接回到空闲后再重试。\u003c/p\u003e\n\u003ch2\u003e消息 {#messages}\u003c/h2\u003e\n\u003cp\u003e固定源码中的代表性消息包括：\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003ecollation mismatch between implicit collations \u0026#34;%s\u0026#34; and \u0026#34;%s\u0026#34;\u003c/code\u003e; HINT: \u003ccode\u003eYou can choose the collation by applying the COLLATE clause to one or both expressions.\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003ecollation mismatch between explicit collations \u0026#34;%s\u0026#34; and \u0026#34;%s\u0026#34;\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003erecursive query \u0026#34;%s\u0026#34; column %d has collation \u0026#34;%s\u0026#34; in non-recursive term but collation \u0026#34;%s\u0026#34; overall\u003c/code\u003e; HINT: \u003ccode\u003eUse the COLLATE clause to set the collation of the non-recursive term.\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003ecolumn \u0026#34;%s\u0026#34; has a collation conflict\u003c/code\u003e; DETAIL: \u003ccode\u003e\u0026#34;%s\u0026#34; versus \u0026#34;%s\u0026#34;\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003einherited column \u0026#34;%s\u0026#34; has a collation conflict\u003c/code\u003e; DETAIL: \u003ccode\u003e\u0026#34;%s\u0026#34; versus \u0026#34;%s\u0026#34;\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003echild table \u0026#34;%s\u0026#34; has different collation for column \u0026#34;%s\u0026#34;\u003c/code\u003e; DETAIL: \u003ccode\u003e\u0026#34;%s\u0026#34; versus \u0026#34;%s\u0026#34;\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003eforeign key constraint \u0026#34;%s\u0026#34; cannot be implemented\u003c/code\u003e; DETAIL: \u003ccode\u003eKey columns \u0026#34;%s\u0026#34; of the referencing table and \u0026#34;%s\u0026#34; of the referenced table have incompatible collations: \u0026#34;%s\u0026#34; and \u0026#34;%s\u0026#34;.  If either collation is nondeterministic, then both collations have to be the same.\u003c/code\u003e\u003c/li\u003e\n\u003c/ul\u003e\n\u003cp\u003e占位符由实际对象、列或参数填充。\u003c/p\u003e\n\u003ch2\u003e版本 {#versions}\u003c/h2\u003e\n\u003cp\u003e锁定目录显示该条件最早见于 PostgreSQL 9.1.0；行为说明固定在 PostgreSQL 18.6 源码，目录存在范围不等于每条消息或功能都从该版本开始。\u003c/p\u003e\n\u003ch2\u003e相关 {#related}\u003c/h2\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ca href=\"/wiki/sqlstate/42P22/\" rel=\"nofollow\"\u003e\u003ccode\u003e42P22\u003c/code\u003e\u003c/a\u003e\u003c/li\u003e\n\u003cli\u003e\u003ca href=\"/wiki/sqlstate/42P18/\" rel=\"nofollow\"\u003e\u003ccode\u003e42P18\u003c/code\u003e\u003c/a\u003e\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch2\u003e来源 {#sources}\u003c/h2\u003e\n\u003cp\u003e源码消息、行号和证据边界见 \u003ca href=\"#sources\" rel=\"nofollow\"\u003e作者证据\u003c/a\u003e。\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/parser/parse_collate.c:208-234\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L208\" rel=\"nofollow\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/parser/parse_collate.c:804-835\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L804\" rel=\"nofollow\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/parser/parse_cte.c:394-401\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_cte.c#L394\" rel=\"nofollow\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/commands/tablecmds.c:3297-3303\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L3297\" rel=\"nofollow\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/commands/tablecmds.c:3463-3469\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L3463\" rel=\"nofollow\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/commands/tablecmds.c:7292-7298\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L7292\" rel=\"nofollow\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/commands/tablecmds.c:10474-10483\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L10474\" rel=\"nofollow\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003c/ul\u003e\n","SourceRevision":"english-manuals:b5d4c7d86be08cb3fc3124799c6c721a76c6e26b8ee8a84e6887686f790435f2","ContentHash":"c924904e91332cfbdf1169d9c3338f133143120fe3bdcd6dc087257ff954d077","Payload":{"body_md":"# 42P21 — 排序规则不匹配\n\n## 速览 {#at-a-glance}\n\n`42P21`（**collation_mismatch**）需要得到兼容结果时，不同排序规则选择可能发生冲突。\n\n\n## 含义 {#meaning}\n\n当固定源码路径需要一个兼容的排序规则，却得到不兼容的选择时，会报 `42P21`。隐式选择会先记录为 `COLLATE_CONFLICT`；调用方允许没有共同排序规则时可以返回 `InvalidOid`，只有确实需要排序规则的调用方才把隐式冲突变成 `ERROR`。显式 `COLLATE` 冲突则立即失败。同一条件还覆盖递归 CTE 输出、继承或子表列定义，以及外键键列兼容性。\n\n## 诊断 {#diagnosis}\n\n遇到隐式排序规则消息时保留两个名称，并检查调用方是否要求共同排序规则；不同的隐式操作数不会全部立即抛出 `42P21`。遇到显式排序规则消息时，找出两个 `COLLATE` 子句并统一预期选择。递归查询要比较非递归项与整体列排序规则。继承或分区子表错误要比较父表与子表列定义。外键要比较引用表和被引用表的键列：固定源码允许两边都是确定性排序规则时使用不同排序规则；只要任一排序规则不确定，两边就必须相同。保留 DETAIL 中的名称，不要把它笼统当成转成 text 就能解决的问题。\n\n## 处理 {#response}\n\n表达式冲突应在表达式边界明确指定一个有意选择的 `COLLATE`，或统一显式子句及递归非递归项的排序规则。重试 DDL 前先对齐继承列或子表列定义。外键应选择兼容的键列排序规则；只要一侧不确定，就满足两边相同的严格要求，然后重新核对相等比较和索引语义。如果该 `ERROR` 发生在显式事务中，修正语句前先 `ROLLBACK`，或回滚到错误前的保存点；自动提交模式下连接回到空闲后再重试。\n\n## 消息 {#messages}\n\n固定源码中的代表性消息包括：\n\n- **ERROR** message: `collation mismatch between implicit collations \"%s\" and \"%s\"`; HINT: `You can choose the collation by applying the COLLATE clause to one or both expressions.`\n- **ERROR** message: `collation mismatch between explicit collations \"%s\" and \"%s\"`\n- **ERROR** message: `recursive query \"%s\" column %d has collation \"%s\" in non-recursive term but collation \"%s\" overall`; HINT: `Use the COLLATE clause to set the collation of the non-recursive term.`\n- **ERROR** message: `column \"%s\" has a collation conflict`; DETAIL: `\"%s\" versus \"%s\"`\n- **ERROR** message: `inherited column \"%s\" has a collation conflict`; DETAIL: `\"%s\" versus \"%s\"`\n- **ERROR** message: `child table \"%s\" has different collation for column \"%s\"`; DETAIL: `\"%s\" versus \"%s\"`\n- **ERROR** message: `foreign key constraint \"%s\" cannot be implemented`; DETAIL: `Key columns \"%s\" of the referencing table and \"%s\" of the referenced table have incompatible collations: \"%s\" and \"%s\".  If either collation is nondeterministic, then both collations have to be the same.`\n\n占位符由实际对象、列或参数填充。\n\n## 版本 {#versions}\n\n锁定目录显示该条件最早见于 PostgreSQL 9.1.0；行为说明固定在 PostgreSQL 18.6 源码，目录存在范围不等于每条消息或功能都从该版本开始。\n\n## 相关 {#related}\n\n- [`42P22`](/wiki/sqlstate/42P22/)\n- [`42P18`](/wiki/sqlstate/42P18/)\n\n## 来源 {#sources}\n\n源码消息、行号和证据边界见 [作者证据](#sources)。\n\n- `src/backend/parser/parse_collate.c:208-234` ([fixed source](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L208))\n- `src/backend/parser/parse_collate.c:804-835` ([fixed source](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L804))\n- `src/backend/parser/parse_cte.c:394-401` ([fixed source](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_cte.c#L394))\n- `src/backend/commands/tablecmds.c:3297-3303` ([fixed source](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L3297))\n- `src/backend/commands/tablecmds.c:3463-3469` ([fixed source](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L3463))\n- `src/backend/commands/tablecmds.c:7292-7298` ([fixed source](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L7292))\n- `src/backend/commands/tablecmds.c:10474-10483` ([fixed source](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L10474))\n","description":"PostgreSQL SQLSTATE 42P21：来源与诊断参考。","is_stale":false,"name":"排序规则不匹配","sections":[{"anchor":"","heading":"","html":"\u0026lt;h1\u0026gt;42P21 — 排序规则不匹配\u0026lt;/h1\u0026gt;"},{"anchor":"at-a-glance","heading":"速览","html":"\u003cp\u003e\u003ccode\u003e42P21\u003c/code\u003e（\u003cstrong\u003ecollation_mismatch\u003c/strong\u003e）需要得到兼容结果时，不同排序规则选择可能发生冲突。\u003c/p\u003e"},{"anchor":"meaning","heading":"含义","html":"\u003cp\u003e当固定源码路径需要一个兼容的排序规则，却得到不兼容的选择时，会报 \u003ccode\u003e42P21\u003c/code\u003e。隐式选择会先记录为 \u003ccode\u003eCOLLATE_CONFLICT\u003c/code\u003e；调用方允许没有共同排序规则时可以返回 \u003ccode\u003eInvalidOid\u003c/code\u003e，只有确实需要排序规则的调用方才把隐式冲突变成 \u003ccode\u003eERROR\u003c/code\u003e。显式 \u003ccode\u003eCOLLATE\u003c/code\u003e 冲突则立即失败。同一条件还覆盖递归 CTE 输出、继承或子表列定义，以及外键键列兼容性。\u003c/p\u003e"},{"anchor":"diagnosis","heading":"诊断","html":"\u003cp\u003e遇到隐式排序规则消息时保留两个名称，并检查调用方是否要求共同排序规则；不同的隐式操作数不会全部立即抛出 \u003ccode\u003e42P21\u003c/code\u003e。遇到显式排序规则消息时，找出两个 \u003ccode\u003eCOLLATE\u003c/code\u003e 子句并统一预期选择。递归查询要比较非递归项与整体列排序规则。继承或分区子表错误要比较父表与子表列定义。外键要比较引用表和被引用表的键列：固定源码允许两边都是确定性排序规则时使用不同排序规则；只要任一排序规则不确定，两边就必须相同。保留 DETAIL 中的名称，不要把它笼统当成转成 text 就能解决的问题。\u003c/p\u003e"},{"anchor":"response","heading":"处理","html":"\u003cp\u003e表达式冲突应在表达式边界明确指定一个有意选择的 \u003ccode\u003eCOLLATE\u003c/code\u003e，或统一显式子句及递归非递归项的排序规则。重试 DDL 前先对齐继承列或子表列定义。外键应选择兼容的键列排序规则；只要一侧不确定，就满足两边相同的严格要求，然后重新核对相等比较和索引语义。如果该 \u003ccode\u003eERROR\u003c/code\u003e 发生在显式事务中，修正语句前先 \u003ccode\u003eROLLBACK\u003c/code\u003e，或回滚到错误前的保存点；自动提交模式下连接回到空闲后再重试。\u003c/p\u003e"},{"anchor":"messages","heading":"消息","html":"\u003cp\u003e固定源码中的代表性消息包括：\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003ecollation mismatch between implicit collations \"%s\" and \"%s\"\u003c/code\u003e; HINT: \u003ccode\u003eYou can choose the collation by applying the COLLATE clause to one or both expressions.\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003ecollation mismatch between explicit collations \"%s\" and \"%s\"\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003erecursive query \"%s\" column %d has collation \"%s\" in non-recursive term but collation \"%s\" overall\u003c/code\u003e; HINT: \u003ccode\u003eUse the COLLATE clause to set the collation of the non-recursive term.\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003ecolumn \"%s\" has a collation conflict\u003c/code\u003e; DETAIL: \u003ccode\u003e\"%s\" versus \"%s\"\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003einherited column \"%s\" has a collation conflict\u003c/code\u003e; DETAIL: \u003ccode\u003e\"%s\" versus \"%s\"\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003echild table \"%s\" has different collation for column \"%s\"\u003c/code\u003e; DETAIL: \u003ccode\u003e\"%s\" versus \"%s\"\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003e\u003cstrong\u003eERROR\u003c/strong\u003e message: \u003ccode\u003eforeign key constraint \"%s\" cannot be implemented\u003c/code\u003e; DETAIL: \u003ccode\u003eKey columns \"%s\" of the referencing table and \"%s\" of the referenced table have incompatible collations: \"%s\" and \"%s\".  If either collation is nondeterministic, then both collations have to be the same.\u003c/code\u003e\u003c/li\u003e\n\u003c/ul\u003e\n\u003cp\u003e占位符由实际对象、列或参数填充。\u003c/p\u003e"},{"anchor":"versions","heading":"版本","html":"\u003cp\u003e锁定目录显示该条件最早见于 PostgreSQL 9.1.0；行为说明固定在 PostgreSQL 18.6 源码，目录存在范围不等于每条消息或功能都从该版本开始。\u003c/p\u003e"},{"anchor":"related","heading":"相关","html":"\u003cul\u003e\n\u003cli\u003e\u003ca href=\"/wiki/sqlstate/42P22/\"\u003e\u003ccode\u003e42P22\u003c/code\u003e\u003c/a\u003e\u003c/li\u003e\n\u003cli\u003e\u003ca href=\"/wiki/sqlstate/42P18/\"\u003e\u003ccode\u003e42P18\u003c/code\u003e\u003c/a\u003e\u003c/li\u003e\n\u003c/ul\u003e"},{"anchor":"sources","heading":"来源","html":"\u003cp\u003e源码消息、行号和证据边界见 \u003ca href=\"#sources\"\u003e作者证据\u003c/a\u003e。\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/parser/parse_collate.c:208-234\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L208\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/parser/parse_collate.c:804-835\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L804\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/parser/parse_cte.c:394-401\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_cte.c#L394\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/commands/tablecmds.c:3297-3303\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L3297\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/commands/tablecmds.c:3463-3469\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L3463\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/commands/tablecmds.c:7292-7298\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L7292\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003esrc/backend/commands/tablecmds.c:10474-10483\u003c/code\u003e (\u003ca href=\"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L10474\"\u003efixed source\u003c/a\u003e)\u003c/li\u003e\n\u003c/ul\u003e"}],"summary":"参与运算的排序规则不兼容，产生冲突。","title":"42P21 — 排序规则不匹配","translation_source_rev":"d0ff47f3f82c86195e6e4bf855b43bf2560dafdbe1e4d98974df14071b9ab701"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":{"aliases":[],"catalogue_notes":{"earliest_observed":"9.1.0","formal_scope":"9.0.0..18.6","latest_observed":"18.6","matrix_scope":["9.0.23","9.1.24","9.2.24","9.3.25","9.4.26","9.5.25","9.6.24","10.23","11.22","12.22","13.23","14.24","15.19","16.15","17.11","18.6"],"pre9_scope":{"formal_tag_count":191,"maximum_release":"8.4.22","minimum_release":"7.0.0","source_definition_count":153,"source_doc_count":153,"source_file_count":306,"source_scope":"7.4..8.4 definition files; 7.0..7.3 candidate-path source gap probes","source_tag_count":153},"pre9_status":"not_observed","preview_scope":["19beta3"]},"class":"42","class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","condition_names":["collation_mismatch"],"definition_changes":[],"english_manuals":{"10":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"9607b57e9f639b61785677ba4d226f5889fe1d19c8bf55a3337691899a9073cd","slug":"10"},"lang":"en","sqlstate":"42P21"},"11":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"3a024e38263ad77de228eed7930b842b42dc1d5cab9ca3727be8eed872ec9539","slug":"11"},"lang":"en","sqlstate":"42P21"},"12":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"1444bd6a138537cd75be88a220ee9472ac528f0cfc58758e49636d85455efe98","slug":"12"},"lang":"en","sqlstate":"42P21"},"13":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"4a3ef8af218e5736dfde8660ba609e84233b6b3bac7e0210ff8724cf1b27b2db","slug":"13"},"lang":"en","sqlstate":"42P21"},"14":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"1c12e83304e0f4ff64c9d98ca5e3007df6756932ed19867a4fa0e0650f6c5751","slug":"14"},"lang":"en","sqlstate":"42P21"},"15":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"2161f58f6e87f6535b3b1f3d4661427bb6765f4f6b074fcc16fac97594b50599","slug":"15"},"lang":"en","sqlstate":"42P21"},"16":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"928e705933d7c3d018ae3fba9d800b34e6325746d157339dce878473c519d100","slug":"16"},"lang":"en","sqlstate":"42P21"},"17":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"868135520af87351e3ea1ba42656111cbd2d157d98e1fef05ea158ac5729d8b1","slug":"17"},"lang":"en","sqlstate":"42P21"},"18":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"56dacf78e618ff0fd8c533e05db597b80d7ebbad7f8e512a888217d0640aa328","slug":"18"},"lang":"en","sqlstate":"42P21"},"19":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"63fb8d1aa9f494eeab9d0f8542a2b673f7746ee41ae2689d19403cb3cc425a5c","slug":"19"},"lang":"en","sqlstate":"42P21"},"20":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"0d3f602127cd137cf343b32d5fa78f175eeb6cdcb6353b1f6f998ede6cb7b911","slug":"devel"},"lang":"en","sqlstate":"42P21"},"9.1":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"2d118b06c3b644c28b3ddefe9e4bef99a180321582209332372a5318f5bf8d1c","slug":"9.1"},"lang":"en","sqlstate":"42P21"},"9.2":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"2a37575b39c858d37c58fc4de6a16109554fd3306602294180d78faa1170d2cd","slug":"9.2"},"lang":"en","sqlstate":"42P21"},"9.3":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"2214b6869d764f7fba7221aefcdf1ab049b55ad51d63aa52054f3cd2c2533ae9","slug":"9.3"},"lang":"en","sqlstate":"42P21"},"9.4":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"7243e2d653befe88733222ede67958f0c4b7fae967b58eb97807aeb3f32b4096","slug":"9.4"},"lang":"en","sqlstate":"42P21"},"9.5":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"d40bc67cb331f1e4ccc0821ff57832c6c230edb0dce3ba4249defd21ae7ea29d","slug":"9.5"},"lang":"en","sqlstate":"42P21"},"9.6":{"aliases":[],"class_name":"Syntax Error or Access Rule Violation","condition_name":"collation_mismatch","doc":{"anchor":"ERRCODES-APPENDIX","file":"errcodes-appendix.html","lang":"en","sha256":"2ab55e487571c8998ec39b3d1bbae29ac6fc5c310875bee422d9a7b8b3fde5b3","slug":"9.6"},"lang":"en","sqlstate":"42P21"}},"history_boundary":{"earliest_observed":"9.1.0","formal_tag_count":351,"gaps":[{"after":"18.6","before":"18.4","reason":"Non-adjacent release tags or a source gap; no removal is inferred."}],"latest_observed":"18.6","pre_range":{"first_observed":null,"known_lower_bound":null,"last_observed":null,"notes":"No occurrence was observed in the locked 7.4..8.4 definition files. Source gaps for 7.0..7.3 prevent a claim that the code was absent before 7.4.","scanned_formal_release_count":153,"scanned_source_scope":"7.4..8.4 definition files; 7.0..7.3 candidate-path source gap probes","source_gap_majors":["7.0","7.1","7.2","7.3"],"status":"partially_scanned"},"preview_snapshots":["19beta3"],"scanned_from":"9.0.0","scanned_to":"18.6"},"introduced":null,"known_present_by":"9.1.0","macros":["ERRCODE_COLLATION_MISMATCH"],"manual_presence":["9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"pre9_first_observed":null,"pre9_introduction_boundary":null,"pre9_last_observed":null,"pre9_presence_intervals":[],"pre9_status":"not_observed","presence_intervals":[{"end":"9.1.24","end_major":"9.1","end_tag":"REL9_1_24","evidence_count":25,"position":0,"start":"9.1.0","start_major":"9.1","start_tag":"REL9_1_0"},{"end":"9.2.24","end_major":"9.2","end_tag":"REL9_2_24","evidence_count":25,"position":1,"start":"9.2.0","start_major":"9.2","start_tag":"REL9_2_0"},{"end":"9.3.25","end_major":"9.3","end_tag":"REL9_3_25","evidence_count":26,"position":2,"start":"9.3.0","start_major":"9.3","start_tag":"REL9_3_0"},{"end":"9.4.26","end_major":"9.4","end_tag":"REL9_4_26","evidence_count":27,"position":3,"start":"9.4.0","start_major":"9.4","start_tag":"REL9_4_0"},{"end":"9.5.25","end_major":"9.5","end_tag":"REL9_5_25","evidence_count":26,"position":4,"start":"9.5.0","start_major":"9.5","start_tag":"REL9_5_0"},{"end":"9.6.24","end_major":"9.6","end_tag":"REL9_6_24","evidence_count":25,"position":5,"start":"9.6.0","start_major":"9.6","start_tag":"REL9_6_0"},{"end":"10.23","end_major":"10","end_tag":"REL_10_23","evidence_count":24,"position":6,"start":"10.0","start_major":"10","start_tag":"REL_10_0"},{"end":"11.22","end_major":"11","end_tag":"REL_11_22","evidence_count":23,"position":7,"start":"11.0","start_major":"11","start_tag":"REL_11_0"},{"end":"12.22","end_major":"12","end_tag":"REL_12_22","evidence_count":23,"position":8,"start":"12.0","start_major":"12","start_tag":"REL_12_0"},{"end":"13.23","end_major":"13","end_tag":"REL_13_23","evidence_count":24,"position":9,"start":"13.0","start_major":"13","start_tag":"REL_13_0"},{"end":"14.24","end_major":"14","end_tag":"REL_14_24","evidence_count":25,"position":10,"start":"14.0","start_major":"14","start_tag":"REL_14_0"},{"end":"15.19","end_major":"15","end_tag":"REL_15_19","evidence_count":20,"position":11,"start":"15.0","start_major":"15","start_tag":"REL_15_0"},{"end":"16.15","end_major":"16","end_tag":"REL_16_15","evidence_count":16,"position":12,"start":"16.0","start_major":"16","start_tag":"REL_16_0"},{"end":"17.11","end_major":"17","end_tag":"REL_17_11","evidence_count":12,"position":13,"start":"17.0","start_major":"17","start_tag":"REL_17_0"},{"end":"18.4","end_major":"18","end_tag":"REL_18_4","evidence_count":5,"position":14,"start":"18.0","start_major":"18","start_tag":"REL_18_0"},{"end":"18.6","end_major":"18","end_tag":"REL_18_6","evidence_count":1,"position":15,"start":"18.6","start_major":"18","start_tag":"REL_18_6"}],"present_in_snapshots":["9.1.24","9.2.24","9.3.25","9.4.26","9.5.25","9.6.24","10.23","11.22","12.22","13.23","14.24","15.19","16.15","17.11","18.6","19beta3"],"preview_in_snapshots":["19beta3"],"primary_macro":"ERRCODE_COLLATION_MISMATCH","removed":null,"schema_version":2,"severity_classes":["E"],"sources":[{"blob_id":"sha256:2b1d71c453a82488c4e95df84a9ee18dc8fdcb2532a7c56f44f1e8c4265a8132","channel":"formal","code_count":228,"commit":"1f43001424a9da624a89b213d0be606a8212a50a","id":"postgresql:REL9_1_0:src/backend/utils/errcodes.txt","major":"9.1","parsed_path":"raw/definitions/REL9_1_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL9_1_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/1f43001424a9da624a89b213d0be606a8212a50a/src/backend/utils/errcodes.txt","record_count":234,"release":"9.1.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"2b1d71c453a82488c4e95df84a9ee18dc8fdcb2532a7c56f44f1e8c4265a8132","size":29355,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL9_1_0","url":"https://github.com/postgres/postgres/blob/1f43001424a9da624a89b213d0be606a8212a50a/src/backend/utils/errcodes.txt","version":"9.1.0"},{"blob_id":"sha256:271a522fcd18ec45ebe4c1235af0e27a0e9bf0376fda4073b9f4a9c0a00fc711","channel":"formal","code_count":232,"commit":"ef47adb414e46099155c34529a2a5caeea02fc41","id":"postgresql:REL9_2_0:src/backend/utils/errcodes.txt","major":"9.2","parsed_path":"raw/definitions/REL9_2_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL9_2_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/ef47adb414e46099155c34529a2a5caeea02fc41/src/backend/utils/errcodes.txt","record_count":238,"release":"9.2.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"271a522fcd18ec45ebe4c1235af0e27a0e9bf0376fda4073b9f4a9c0a00fc711","size":30387,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL9_2_0","url":"https://github.com/postgres/postgres/blob/ef47adb414e46099155c34529a2a5caeea02fc41/src/backend/utils/errcodes.txt","version":"9.2.0"},{"blob_id":"sha256:f90d801e724191c84e94ae33483e71b4e3c4de5730474d316df4c722a149897d","channel":"formal","code_count":232,"commit":"da645b3a73580ac30cf02e932b42d06157b98229","id":"postgresql:REL9_3_0:src/backend/utils/errcodes.txt","major":"9.3","parsed_path":"raw/definitions/REL9_3_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL9_3_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/da645b3a73580ac30cf02e932b42d06157b98229/src/backend/utils/errcodes.txt","record_count":238,"release":"9.3.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"f90d801e724191c84e94ae33483e71b4e3c4de5730474d316df4c722a149897d","size":30387,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL9_3_0","url":"https://github.com/postgres/postgres/blob/da645b3a73580ac30cf02e932b42d06157b98229/src/backend/utils/errcodes.txt","version":"9.3.0"},{"blob_id":"sha256:1695ec274fb29f0b0875ff674405e775334243835a6f6008e007dfe3a8260bf5","channel":"formal","code_count":232,"commit":"8ca336f4ac3f08a5f23e76c6e9a5f2c8064f5883","id":"postgresql:REL9_4_0:src/backend/utils/errcodes.txt","major":"9.4","parsed_path":"raw/definitions/REL9_4_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL9_4_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/8ca336f4ac3f08a5f23e76c6e9a5f2c8064f5883/src/backend/utils/errcodes.txt","record_count":238,"release":"9.4.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"1695ec274fb29f0b0875ff674405e775334243835a6f6008e007dfe3a8260bf5","size":30387,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL9_4_0","url":"https://github.com/postgres/postgres/blob/8ca336f4ac3f08a5f23e76c6e9a5f2c8064f5883/src/backend/utils/errcodes.txt","version":"9.4.0"},{"blob_id":"sha256:37f728a7e034ef0b05b060a4b82c7dd95c900e4a5501c80bfefd8d679889253b","channel":"formal","code_count":236,"commit":"cdd4ed5449bf317cc71b45a8deee0173822e7592","id":"postgresql:REL9_5_0:src/backend/utils/errcodes.txt","major":"9.5","parsed_path":"raw/definitions/REL9_5_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL9_5_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/cdd4ed5449bf317cc71b45a8deee0173822e7592/src/backend/utils/errcodes.txt","record_count":242,"release":"9.5.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"37f728a7e034ef0b05b060a4b82c7dd95c900e4a5501c80bfefd8d679889253b","size":30798,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL9_5_0","url":"https://github.com/postgres/postgres/blob/cdd4ed5449bf317cc71b45a8deee0173822e7592/src/backend/utils/errcodes.txt","version":"9.5.0"},{"blob_id":"sha256:bf4d94d84c7cfe695cb80e8f009872444574719a80a72e347eb66ef3686b86ef","channel":"formal","code_count":238,"commit":"a721a1ba9cf6c86cb52f1bf325d5a27b64e870d6","id":"postgresql:REL9_6_0:src/backend/utils/errcodes.txt","major":"9.6","parsed_path":"raw/definitions/REL9_6_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL9_6_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/a721a1ba9cf6c86cb52f1bf325d5a27b64e870d6/src/backend/utils/errcodes.txt","record_count":244,"release":"9.6.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"bf4d94d84c7cfe695cb80e8f009872444574719a80a72e347eb66ef3686b86ef","size":31135,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL9_6_0","url":"https://github.com/postgres/postgres/blob/a721a1ba9cf6c86cb52f1bf325d5a27b64e870d6/src/backend/utils/errcodes.txt","version":"9.6.0"},{"blob_id":"sha256:e5d829b24fe63aa69429fa1deb9675051fc8ffd4a8a4651861907a8f12ccb144","channel":"formal","code_count":240,"commit":"5df0e99bea1c3e5fbffa7fbd0982da88ea149bb6","id":"postgresql:REL_10_0:src/backend/utils/errcodes.txt","major":"10","parsed_path":"raw/definitions/REL_10_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_10_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/5df0e99bea1c3e5fbffa7fbd0982da88ea149bb6/src/backend/utils/errcodes.txt","record_count":246,"release":"10.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"e5d829b24fe63aa69429fa1deb9675051fc8ffd4a8a4651861907a8f12ccb144","size":31340,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_10_0","url":"https://github.com/postgres/postgres/blob/5df0e99bea1c3e5fbffa7fbd0982da88ea149bb6/src/backend/utils/errcodes.txt","version":"10.0"},{"blob_id":"sha256:8518be6de92ae135765e295c631c5f525120ca2b132453404b620f9aa595cab4","channel":"formal","code_count":241,"commit":"19f20081df059fef87e14c8e953669bd173dd7f1","id":"postgresql:REL_11_0:src/backend/utils/errcodes.txt","major":"11","parsed_path":"raw/definitions/REL_11_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_11_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/19f20081df059fef87e14c8e953669bd173dd7f1/src/backend/utils/errcodes.txt","record_count":247,"release":"11.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"8518be6de92ae135765e295c631c5f525120ca2b132453404b620f9aa595cab4","size":31453,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_11_0","url":"https://github.com/postgres/postgres/blob/19f20081df059fef87e14c8e953669bd173dd7f1/src/backend/utils/errcodes.txt","version":"11.0"},{"blob_id":"sha256:943259f3e36af1343dd0f090f7c7cec0e8c762b038d68c178aaa9b1b11999bfb","channel":"formal","code_count":257,"commit":"ad1f2885b8c82e0c2d56d7974f012cbecce17a17","id":"postgresql:REL_12_0:src/backend/utils/errcodes.txt","major":"12","parsed_path":"raw/definitions/REL_12_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_12_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/ad1f2885b8c82e0c2d56d7974f012cbecce17a17/src/backend/utils/errcodes.txt","record_count":263,"release":"12.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"943259f3e36af1343dd0f090f7c7cec0e8c762b038d68c178aaa9b1b11999bfb","size":33114,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_12_0","url":"https://github.com/postgres/postgres/blob/ad1f2885b8c82e0c2d56d7974f012cbecce17a17/src/backend/utils/errcodes.txt","version":"12.0"},{"blob_id":"sha256:9a464a3c3c99d2488782d4cdd0d46ce261085a944cb0c21e2d884586fbc8204d","channel":"formal","code_count":258,"commit":"29be9983a64c011eac0b9ee29895cce71e15ea77","id":"postgresql:REL_13_0:src/backend/utils/errcodes.txt","major":"13","parsed_path":"raw/definitions/REL_13_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_13_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/29be9983a64c011eac0b9ee29895cce71e15ea77/src/backend/utils/errcodes.txt","record_count":264,"release":"13.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"9a464a3c3c99d2488782d4cdd0d46ce261085a944cb0c21e2d884586fbc8204d","size":33239,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_13_0","url":"https://github.com/postgres/postgres/blob/29be9983a64c011eac0b9ee29895cce71e15ea77/src/backend/utils/errcodes.txt","version":"13.0"},{"blob_id":"sha256:c3c967fa20577f7ded946cb99e1a4706b85bb2476fd32d7e4a133c971a603552","channel":"formal","code_count":259,"commit":"86a4dc1e6f29d1992a2afa3fac1a0b0a6e84568c","id":"postgresql:REL_14_0:src/backend/utils/errcodes.txt","major":"14","parsed_path":"raw/definitions/REL_14_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_14_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/86a4dc1e6f29d1992a2afa3fac1a0b0a6e84568c/src/backend/utils/errcodes.txt","record_count":265,"release":"14.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"c3c967fa20577f7ded946cb99e1a4706b85bb2476fd32d7e4a133c971a603552","size":33337,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_14_0","url":"https://github.com/postgres/postgres/blob/86a4dc1e6f29d1992a2afa3fac1a0b0a6e84568c/src/backend/utils/errcodes.txt","version":"14.0"},{"blob_id":"sha256:a34b5fccd8a27c92817314dd942b79e76896cd1d9a8d4be21c81b02227850b4a","channel":"formal","code_count":260,"commit":"2a7ce2e2ce474504a707ec03e128fde66cfb8b48","id":"postgresql:REL_15_0:src/backend/utils/errcodes.txt","major":"15","parsed_path":"raw/definitions/REL_15_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_15_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/2a7ce2e2ce474504a707ec03e128fde66cfb8b48/src/backend/utils/errcodes.txt","record_count":266,"release":"15.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"a34b5fccd8a27c92817314dd942b79e76896cd1d9a8d4be21c81b02227850b4a","size":33458,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_15_0","url":"https://github.com/postgres/postgres/blob/2a7ce2e2ce474504a707ec03e128fde66cfb8b48/src/backend/utils/errcodes.txt","version":"15.0"},{"blob_id":"sha256:1d1d741b7b7c6dfd8275287e31c79befed75f3b9349e1a42ef0ca147c429ff88","channel":"formal","code_count":260,"commit":"c372fbbd8e911f2412b80a8c39d7079366565d67","id":"postgresql:REL_16_0:src/backend/utils/errcodes.txt","major":"16","parsed_path":"raw/definitions/REL_16_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_16_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/c372fbbd8e911f2412b80a8c39d7079366565d67/src/backend/utils/errcodes.txt","record_count":266,"release":"16.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"1d1d741b7b7c6dfd8275287e31c79befed75f3b9349e1a42ef0ca147c429ff88","size":33458,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_16_0","url":"https://github.com/postgres/postgres/blob/c372fbbd8e911f2412b80a8c39d7079366565d67/src/backend/utils/errcodes.txt","version":"16.0"},{"blob_id":"sha256:bb53279934510355eb4135a807c90d989f07650bd90f87026a4441f11d3296b1","channel":"formal","code_count":260,"commit":"d7ec59a63d745ba74fba0e280bbf85dc6d1caa3e","id":"postgresql:REL_17_0:src/backend/utils/errcodes.txt","major":"17","parsed_path":"raw/definitions/REL_17_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_17_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/d7ec59a63d745ba74fba0e280bbf85dc6d1caa3e/src/backend/utils/errcodes.txt","record_count":266,"release":"17.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"bb53279934510355eb4135a807c90d989f07650bd90f87026a4441f11d3296b1","size":33392,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_17_0","url":"https://github.com/postgres/postgres/blob/d7ec59a63d745ba74fba0e280bbf85dc6d1caa3e/src/backend/utils/errcodes.txt","version":"17.0"},{"blob_id":"sha256:6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba","channel":"formal","code_count":262,"commit":"3d6a828938a5fa0444275d3d2f67b64ec3199eb7","id":"postgresql:REL_18_0:src/backend/utils/errcodes.txt","major":"18","parsed_path":"raw/definitions/REL_18_0.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_18_0.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/3d6a828938a5fa0444275d3d2f67b64ec3199eb7/src/backend/utils/errcodes.txt","record_count":268,"release":"18.0","release_date":null,"repository":"https://github.com/postgres/postgres.git","sha256":"6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba","size":33739,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_18_0","url":"https://github.com/postgres/postgres/blob/3d6a828938a5fa0444275d3d2f67b64ec3199eb7/src/backend/utils/errcodes.txt","version":"18.0"},{"blob_id":"sha256:cadb9e83cde9a8699a7e74448891ca623af8579ccc8e11c7e533fb47cbc42f89","channel":"preview","code_count":262,"commit":"3638289fb57bdabec00deda98ee9624a35f5d66a","id":"postgresql:REL_19_BETA3:src/backend/utils/errcodes.txt","major":"19","parsed_path":"raw/definitions/REL_19_BETA3.parsed.json","path":"src/backend/utils/errcodes.txt","raw_path":"raw/definitions/REL_19_BETA3.txt","raw_url":"https://raw.githubusercontent.com/postgres/postgres/3638289fb57bdabec00deda98ee9624a35f5d66a/src/backend/utils/errcodes.txt","record_count":268,"release":"19beta3","release_date":"2026-08-13","repository":"https://github.com/postgres/postgres.git","sha256":"cadb9e83cde9a8699a7e74448891ca623af8579ccc8e11c7e533fb47cbc42f89","size":33739,"source_format":"errcodes.txt","source_role":"primary_definition","tag":"REL_19_BETA3","url":"https://github.com/postgres/postgres/blob/3638289fb57bdabec00deda98ee9624a35f5d66a/src/backend/utils/errcodes.txt","version":"19beta3"}],"sqlstate":"42P21","status":"active","usage_evidence":[{"evidence_ids":["postgresql:REL9_1_0:src/backend/utils/errcodes.txt","postgresql:REL9_1_10:src/backend/utils/errcodes.txt","postgresql:REL9_1_11:src/backend/utils/errcodes.txt","postgresql:REL9_1_12:src/backend/utils/errcodes.txt","postgresql:REL9_1_13:src/backend/utils/errcodes.txt","postgresql:REL9_1_14:src/backend/utils/errcodes.txt","postgresql:REL9_1_15:src/backend/utils/errcodes.txt","postgresql:REL9_1_16:src/backend/utils/errcodes.txt","postgresql:REL9_1_17:src/backend/utils/errcodes.txt","postgresql:REL9_1_18:src/backend/utils/errcodes.txt","postgresql:REL9_1_19:src/backend/utils/errcodes.txt","postgresql:REL9_1_1:src/backend/utils/errcodes.txt","postgresql:REL9_1_20:src/backend/utils/errcodes.txt","postgresql:REL9_1_21:src/backend/utils/errcodes.txt","postgresql:REL9_1_22:src/backend/utils/errcodes.txt","postgresql:REL9_1_23:src/backend/utils/errcodes.txt","postgresql:REL9_1_24:src/backend/utils/errcodes.txt","postgresql:REL9_1_2:src/backend/utils/errcodes.txt","postgresql:REL9_1_3:src/backend/utils/errcodes.txt","postgresql:REL9_1_4:src/backend/utils/errcodes.txt","postgresql:REL9_1_5:src/backend/utils/errcodes.txt","postgresql:REL9_1_6:src/backend/utils/errcodes.txt","postgresql:REL9_1_7:src/backend/utils/errcodes.txt","postgresql:REL9_1_8:src/backend/utils/errcodes.txt","postgresql:REL9_1_9:src/backend/utils/errcodes.txt","postgresql:REL9_2_0:src/backend/utils/errcodes.txt","postgresql:REL9_2_10:src/backend/utils/errcodes.txt","postgresql:REL9_2_11:src/backend/utils/errcodes.txt","postgresql:REL9_2_12:src/backend/utils/errcodes.txt","postgresql:REL9_2_13:src/backend/utils/errcodes.txt","postgresql:REL9_2_14:src/backend/utils/errcodes.txt","postgresql:REL9_2_15:src/backend/utils/errcodes.txt","postgresql:REL9_2_16:src/backend/utils/errcodes.txt","postgresql:REL9_2_17:src/backend/utils/errcodes.txt","postgresql:REL9_2_18:src/backend/utils/errcodes.txt","postgresql:REL9_2_19:src/backend/utils/errcodes.txt","postgresql:REL9_2_1:src/backend/utils/errcodes.txt","postgresql:REL9_2_20:src/backend/utils/errcodes.txt","postgresql:REL9_2_21:src/backend/utils/errcodes.txt","postgresql:REL9_2_22:src/backend/utils/errcodes.txt","postgresql:REL9_2_23:src/backend/utils/errcodes.txt","postgresql:REL9_2_24:src/backend/utils/errcodes.txt","postgresql:REL9_2_2:src/backend/utils/errcodes.txt","postgresql:REL9_2_3:src/backend/utils/errcodes.txt","postgresql:REL9_2_4:src/backend/utils/errcodes.txt","postgresql:REL9_2_5:src/backend/utils/errcodes.txt","postgresql:REL9_2_6:src/backend/utils/errcodes.txt","postgresql:REL9_2_7:src/backend/utils/errcodes.txt","postgresql:REL9_2_8:src/backend/utils/errcodes.txt","postgresql:REL9_2_9:src/backend/utils/errcodes.txt","postgresql:REL9_3_0:src/backend/utils/errcodes.txt","postgresql:REL9_3_10:src/backend/utils/errcodes.txt","postgresql:REL9_3_11:src/backend/utils/errcodes.txt","postgresql:REL9_3_12:src/backend/utils/errcodes.txt","postgresql:REL9_3_13:src/backend/utils/errcodes.txt","postgresql:REL9_3_14:src/backend/utils/errcodes.txt","postgresql:REL9_3_15:src/backend/utils/errcodes.txt","postgresql:REL9_3_16:src/backend/utils/errcodes.txt","postgresql:REL9_3_17:src/backend/utils/errcodes.txt","postgresql:REL9_3_18:src/backend/utils/errcodes.txt","postgresql:REL9_3_19:src/backend/utils/errcodes.txt","postgresql:REL9_3_1:src/backend/utils/errcodes.txt","postgresql:REL9_3_20:src/backend/utils/errcodes.txt","postgresql:REL9_3_21:src/backend/utils/errcodes.txt","postgresql:REL9_3_22:src/backend/utils/errcodes.txt","postgresql:REL9_3_23:src/backend/utils/errcodes.txt","postgresql:REL9_3_24:src/backend/utils/errcodes.txt","postgresql:REL9_3_25:src/backend/utils/errcodes.txt","postgresql:REL9_3_2:src/backend/utils/errcodes.txt","postgresql:REL9_3_3:src/backend/utils/errcodes.txt","postgresql:REL9_3_4:src/backend/utils/errcodes.txt","postgresql:REL9_3_5:src/backend/utils/errcodes.txt","postgresql:REL9_3_6:src/backend/utils/errcodes.txt","postgresql:REL9_3_7:src/backend/utils/errcodes.txt","postgresql:REL9_3_8:src/backend/utils/errcodes.txt","postgresql:REL9_3_9:src/backend/utils/errcodes.txt","postgresql:REL9_4_0:src/backend/utils/errcodes.txt","postgresql:REL9_4_10:src/backend/utils/errcodes.txt","postgresql:REL9_4_11:src/backend/utils/errcodes.txt","postgresql:REL9_4_12:src/backend/utils/errcodes.txt","postgresql:REL9_4_13:src/backend/utils/errcodes.txt","postgresql:REL9_4_14:src/backend/utils/errcodes.txt","postgresql:REL9_4_15:src/backend/utils/errcodes.txt","postgresql:REL9_4_16:src/backend/utils/errcodes.txt","postgresql:REL9_4_17:src/backend/utils/errcodes.txt","postgresql:REL9_4_18:src/backend/utils/errcodes.txt","postgresql:REL9_4_19:src/backend/utils/errcodes.txt","postgresql:REL9_4_1:src/backend/utils/errcodes.txt","postgresql:REL9_4_20:src/backend/utils/errcodes.txt","postgresql:REL9_4_21:src/backend/utils/errcodes.txt","postgresql:REL9_4_22:src/backend/utils/errcodes.txt","postgresql:REL9_4_23:src/backend/utils/errcodes.txt","postgresql:REL9_4_24:src/backend/utils/errcodes.txt","postgresql:REL9_4_25:src/backend/utils/errcodes.txt","postgresql:REL9_4_26:src/backend/utils/errcodes.txt","postgresql:REL9_4_2:src/backend/utils/errcodes.txt","postgresql:REL9_4_3:src/backend/utils/errcodes.txt","postgresql:REL9_4_4:src/backend/utils/errcodes.txt","postgresql:REL9_4_5:src/backend/utils/errcodes.txt","postgresql:REL9_4_6:src/backend/utils/errcodes.txt","postgresql:REL9_4_7:src/backend/utils/errcodes.txt","postgresql:REL9_4_8:src/backend/utils/errcodes.txt","postgresql:REL9_4_9:src/backend/utils/errcodes.txt","postgresql:REL9_5_0:src/backend/utils/errcodes.txt","postgresql:REL9_5_10:src/backend/utils/errcodes.txt","postgresql:REL9_5_11:src/backend/utils/errcodes.txt","postgresql:REL9_5_12:src/backend/utils/errcodes.txt","postgresql:REL9_5_13:src/backend/utils/errcodes.txt","postgresql:REL9_5_14:src/backend/utils/errcodes.txt","postgresql:REL9_5_15:src/backend/utils/errcodes.txt","postgresql:REL9_5_16:src/backend/utils/errcodes.txt","postgresql:REL9_5_17:src/backend/utils/errcodes.txt","postgresql:REL9_5_18:src/backend/utils/errcodes.txt","postgresql:REL9_5_19:src/backend/utils/errcodes.txt","postgresql:REL9_5_1:src/backend/utils/errcodes.txt","postgresql:REL9_5_20:src/backend/utils/errcodes.txt","postgresql:REL9_5_21:src/backend/utils/errcodes.txt","postgresql:REL9_5_22:src/backend/utils/errcodes.txt","postgresql:REL9_5_23:src/backend/utils/errcodes.txt","postgresql:REL9_5_24:src/backend/utils/errcodes.txt","postgresql:REL9_5_25:src/backend/utils/errcodes.txt","postgresql:REL9_5_2:src/backend/utils/errcodes.txt","postgresql:REL9_5_3:src/backend/utils/errcodes.txt","postgresql:REL9_5_4:src/backend/utils/errcodes.txt","postgresql:REL9_5_5:src/backend/utils/errcodes.txt","postgresql:REL9_5_6:src/backend/utils/errcodes.txt","postgresql:REL9_5_7:src/backend/utils/errcodes.txt","postgresql:REL9_5_8:src/backend/utils/errcodes.txt","postgresql:REL9_5_9:src/backend/utils/errcodes.txt","postgresql:REL9_6_0:src/backend/utils/errcodes.txt","postgresql:REL9_6_10:src/backend/utils/errcodes.txt","postgresql:REL9_6_11:src/backend/utils/errcodes.txt","postgresql:REL9_6_12:src/backend/utils/errcodes.txt","postgresql:REL9_6_13:src/backend/utils/errcodes.txt","postgresql:REL9_6_14:src/backend/utils/errcodes.txt","postgresql:REL9_6_15:src/backend/utils/errcodes.txt","postgresql:REL9_6_16:src/backend/utils/errcodes.txt","postgresql:REL9_6_17:src/backend/utils/errcodes.txt","postgresql:REL9_6_18:src/backend/utils/errcodes.txt","postgresql:REL9_6_19:src/backend/utils/errcodes.txt","postgresql:REL9_6_1:src/backend/utils/errcodes.txt","postgresql:REL9_6_20:src/backend/utils/errcodes.txt","postgresql:REL9_6_21:src/backend/utils/errcodes.txt","postgresql:REL9_6_22:src/backend/utils/errcodes.txt","postgresql:REL9_6_23:src/backend/utils/errcodes.txt","postgresql:REL9_6_24:src/backend/utils/errcodes.txt","postgresql:REL9_6_2:src/backend/utils/errcodes.txt","postgresql:REL9_6_3:src/backend/utils/errcodes.txt","postgresql:REL9_6_4:src/backend/utils/errcodes.txt","postgresql:REL9_6_5:src/backend/utils/errcodes.txt","postgresql:REL9_6_6:src/backend/utils/errcodes.txt","postgresql:REL9_6_7:src/backend/utils/errcodes.txt","postgresql:REL9_6_8:src/backend/utils/errcodes.txt","postgresql:REL9_6_9:src/backend/utils/errcodes.txt","postgresql:REL_10_0:src/backend/utils/errcodes.txt","postgresql:REL_10_10:src/backend/utils/errcodes.txt","postgresql:REL_10_11:src/backend/utils/errcodes.txt","postgresql:REL_10_12:src/backend/utils/errcodes.txt","postgresql:REL_10_13:src/backend/utils/errcodes.txt","postgresql:REL_10_14:src/backend/utils/errcodes.txt","postgresql:REL_10_15:src/backend/utils/errcodes.txt","postgresql:REL_10_16:src/backend/utils/errcodes.txt","postgresql:REL_10_17:src/backend/utils/errcodes.txt","postgresql:REL_10_18:src/backend/utils/errcodes.txt","postgresql:REL_10_19:src/backend/utils/errcodes.txt","postgresql:REL_10_1:src/backend/utils/errcodes.txt","postgresql:REL_10_20:src/backend/utils/errcodes.txt","postgresql:REL_10_21:src/backend/utils/errcodes.txt","postgresql:REL_10_22:src/backend/utils/errcodes.txt","postgresql:REL_10_23:src/backend/utils/errcodes.txt","postgresql:REL_10_2:src/backend/utils/errcodes.txt","postgresql:REL_10_3:src/backend/utils/errcodes.txt","postgresql:REL_10_4:src/backend/utils/errcodes.txt","postgresql:REL_10_5:src/backend/utils/errcodes.txt","postgresql:REL_10_6:src/backend/utils/errcodes.txt","postgresql:REL_10_7:src/backend/utils/errcodes.txt","postgresql:REL_10_8:src/backend/utils/errcodes.txt","postgresql:REL_10_9:src/backend/utils/errcodes.txt","postgresql:REL_11_0:src/backend/utils/errcodes.txt","postgresql:REL_11_10:src/backend/utils/errcodes.txt","postgresql:REL_11_11:src/backend/utils/errcodes.txt","postgresql:REL_11_12:src/backend/utils/errcodes.txt","postgresql:REL_11_13:src/backend/utils/errcodes.txt","postgresql:REL_11_14:src/backend/utils/errcodes.txt","postgresql:REL_11_15:src/backend/utils/errcodes.txt","postgresql:REL_11_16:src/backend/utils/errcodes.txt","postgresql:REL_11_17:src/backend/utils/errcodes.txt","postgresql:REL_11_18:src/backend/utils/errcodes.txt","postgresql:REL_11_19:src/backend/utils/errcodes.txt","postgresql:REL_11_1:src/backend/utils/errcodes.txt","postgresql:REL_11_20:src/backend/utils/errcodes.txt","postgresql:REL_11_21:src/backend/utils/errcodes.txt","postgresql:REL_11_22:src/backend/utils/errcodes.txt","postgresql:REL_11_2:src/backend/utils/errcodes.txt","postgresql:REL_11_3:src/backend/utils/errcodes.txt","postgresql:REL_11_4:src/backend/utils/errcodes.txt","postgresql:REL_11_5:src/backend/utils/errcodes.txt","postgresql:REL_11_6:src/backend/utils/errcodes.txt","postgresql:REL_11_7:src/backend/utils/errcodes.txt","postgresql:REL_11_8:src/backend/utils/errcodes.txt","postgresql:REL_11_9:src/backend/utils/errcodes.txt","postgresql:REL_12_0:src/backend/utils/errcodes.txt","postgresql:REL_12_10:src/backend/utils/errcodes.txt","postgresql:REL_12_11:src/backend/utils/errcodes.txt","postgresql:REL_12_12:src/backend/utils/errcodes.txt","postgresql:REL_12_13:src/backend/utils/errcodes.txt","postgresql:REL_12_14:src/backend/utils/errcodes.txt","postgresql:REL_12_15:src/backend/utils/errcodes.txt","postgresql:REL_12_16:src/backend/utils/errcodes.txt","postgresql:REL_12_17:src/backend/utils/errcodes.txt","postgresql:REL_12_18:src/backend/utils/errcodes.txt","postgresql:REL_12_19:src/backend/utils/errcodes.txt","postgresql:REL_12_1:src/backend/utils/errcodes.txt","postgresql:REL_12_20:src/backend/utils/errcodes.txt","postgresql:REL_12_21:src/backend/utils/errcodes.txt","postgresql:REL_12_22:src/backend/utils/errcodes.txt","postgresql:REL_12_2:src/backend/utils/errcodes.txt","postgresql:REL_12_3:src/backend/utils/errcodes.txt","postgresql:REL_12_4:src/backend/utils/errcodes.txt","postgresql:REL_12_5:src/backend/utils/errcodes.txt","postgresql:REL_12_6:src/backend/utils/errcodes.txt","postgresql:REL_12_7:src/backend/utils/errcodes.txt","postgresql:REL_12_8:src/backend/utils/errcodes.txt","postgresql:REL_12_9:src/backend/utils/errcodes.txt","postgresql:REL_13_0:src/backend/utils/errcodes.txt","postgresql:REL_13_10:src/backend/utils/errcodes.txt","postgresql:REL_13_11:src/backend/utils/errcodes.txt","postgresql:REL_13_12:src/backend/utils/errcodes.txt","postgresql:REL_13_13:src/backend/utils/errcodes.txt","postgresql:REL_13_14:src/backend/utils/errcodes.txt","postgresql:REL_13_15:src/backend/utils/errcodes.txt","postgresql:REL_13_16:src/backend/utils/errcodes.txt","postgresql:REL_13_17:src/backend/utils/errcodes.txt","postgresql:REL_13_18:src/backend/utils/errcodes.txt","postgresql:REL_13_19:src/backend/utils/errcodes.txt","postgresql:REL_13_1:src/backend/utils/errcodes.txt","postgresql:REL_13_20:src/backend/utils/errcodes.txt","postgresql:REL_13_21:src/backend/utils/errcodes.txt","postgresql:REL_13_22:src/backend/utils/errcodes.txt","postgresql:REL_13_23:src/backend/utils/errcodes.txt","postgresql:REL_13_2:src/backend/utils/errcodes.txt","postgresql:REL_13_3:src/backend/utils/errcodes.txt","postgresql:REL_13_4:src/backend/utils/errcodes.txt","postgresql:REL_13_5:src/backend/utils/errcodes.txt","postgresql:REL_13_6:src/backend/utils/errcodes.txt","postgresql:REL_13_7:src/backend/utils/errcodes.txt","postgresql:REL_13_8:src/backend/utils/errcodes.txt","postgresql:REL_13_9:src/backend/utils/errcodes.txt","postgresql:REL_14_0:src/backend/utils/errcodes.txt","postgresql:REL_14_10:src/backend/utils/errcodes.txt","postgresql:REL_14_11:src/backend/utils/errcodes.txt","postgresql:REL_14_12:src/backend/utils/errcodes.txt","postgresql:REL_14_13:src/backend/utils/errcodes.txt","postgresql:REL_14_14:src/backend/utils/errcodes.txt","postgresql:REL_14_15:src/backend/utils/errcodes.txt","postgresql:REL_14_16:src/backend/utils/errcodes.txt","postgresql:REL_14_17:src/backend/utils/errcodes.txt","postgresql:REL_14_18:src/backend/utils/errcodes.txt","postgresql:REL_14_19:src/backend/utils/errcodes.txt","postgresql:REL_14_1:src/backend/utils/errcodes.txt","postgresql:REL_14_20:src/backend/utils/errcodes.txt","postgresql:REL_14_21:src/backend/utils/errcodes.txt","postgresql:REL_14_22:src/backend/utils/errcodes.txt","postgresql:REL_14_23:src/backend/utils/errcodes.txt","postgresql:REL_14_24:src/backend/utils/errcodes.txt","postgresql:REL_14_2:src/backend/utils/errcodes.txt","postgresql:REL_14_3:src/backend/utils/errcodes.txt","postgresql:REL_14_4:src/backend/utils/errcodes.txt","postgresql:REL_14_5:src/backend/utils/errcodes.txt","postgresql:REL_14_6:src/backend/utils/errcodes.txt","postgresql:REL_14_7:src/backend/utils/errcodes.txt","postgresql:REL_14_8:src/backend/utils/errcodes.txt","postgresql:REL_14_9:src/backend/utils/errcodes.txt","postgresql:REL_15_0:src/backend/utils/errcodes.txt","postgresql:REL_15_10:src/backend/utils/errcodes.txt","postgresql:REL_15_11:src/backend/utils/errcodes.txt","postgresql:REL_15_12:src/backend/utils/errcodes.txt","postgresql:REL_15_13:src/backend/utils/errcodes.txt","postgresql:REL_15_14:src/backend/utils/errcodes.txt","postgresql:REL_15_15:src/backend/utils/errcodes.txt","postgresql:REL_15_16:src/backend/utils/errcodes.txt","postgresql:REL_15_17:src/backend/utils/errcodes.txt","postgresql:REL_15_18:src/backend/utils/errcodes.txt","postgresql:REL_15_19:src/backend/utils/errcodes.txt","postgresql:REL_15_1:src/backend/utils/errcodes.txt","postgresql:REL_15_2:src/backend/utils/errcodes.txt","postgresql:REL_15_3:src/backend/utils/errcodes.txt","postgresql:REL_15_4:src/backend/utils/errcodes.txt","postgresql:REL_15_5:src/backend/utils/errcodes.txt","postgresql:REL_15_6:src/backend/utils/errcodes.txt","postgresql:REL_15_7:src/backend/utils/errcodes.txt","postgresql:REL_15_8:src/backend/utils/errcodes.txt","postgresql:REL_15_9:src/backend/utils/errcodes.txt","postgresql:REL_16_0:src/backend/utils/errcodes.txt","postgresql:REL_16_10:src/backend/utils/errcodes.txt","postgresql:REL_16_11:src/backend/utils/errcodes.txt","postgresql:REL_16_12:src/backend/utils/errcodes.txt","postgresql:REL_16_13:src/backend/utils/errcodes.txt","postgresql:REL_16_14:src/backend/utils/errcodes.txt","postgresql:REL_16_15:src/backend/utils/errcodes.txt","postgresql:REL_16_1:src/backend/utils/errcodes.txt","postgresql:REL_16_2:src/backend/utils/errcodes.txt","postgresql:REL_16_3:src/backend/utils/errcodes.txt","postgresql:REL_16_4:src/backend/utils/errcodes.txt","postgresql:REL_16_5:src/backend/utils/errcodes.txt","postgresql:REL_16_6:src/backend/utils/errcodes.txt","postgresql:REL_16_7:src/backend/utils/errcodes.txt","postgresql:REL_16_8:src/backend/utils/errcodes.txt","postgresql:REL_16_9:src/backend/utils/errcodes.txt","postgresql:REL_17_0:src/backend/utils/errcodes.txt","postgresql:REL_17_10:src/backend/utils/errcodes.txt","postgresql:REL_17_11:src/backend/utils/errcodes.txt","postgresql:REL_17_1:src/backend/utils/errcodes.txt","postgresql:REL_17_2:src/backend/utils/errcodes.txt","postgresql:REL_17_3:src/backend/utils/errcodes.txt","postgresql:REL_17_4:src/backend/utils/errcodes.txt","postgresql:REL_17_5:src/backend/utils/errcodes.txt","postgresql:REL_17_6:src/backend/utils/errcodes.txt","postgresql:REL_17_7:src/backend/utils/errcodes.txt","postgresql:REL_17_8:src/backend/utils/errcodes.txt","postgresql:REL_17_9:src/backend/utils/errcodes.txt","postgresql:REL_18_0:src/backend/utils/errcodes.txt","postgresql:REL_18_1:src/backend/utils/errcodes.txt","postgresql:REL_18_2:src/backend/utils/errcodes.txt","postgresql:REL_18_3:src/backend/utils/errcodes.txt","postgresql:REL_18_4:src/backend/utils/errcodes.txt","postgresql:REL_18_6:src/backend/utils/errcodes.txt","postgresql:REL_19_BETA3:src/backend/utils/errcodes.txt"],"notes":"Presence in a PostgreSQL release definition file is established; runtime throw/use scanning is maintained separately.","scope":"release-definition-catalogue","status":"definition_only"},{"evidence_ids":[],"notes":"No occurrence was found in the locked 7.4..8.4 definition files; 7.0..7.3 source gaps remain explicit.","scope":"pre9-definition-history","status":"unknown"}]},"Evidence":[{"Kind":"claims","Ordinal":0,"ID":"identity.class-and-condition","ServerVersion":null,"Status":null,"Payload":{"claim_id":"identity.class-and-condition","limits":"Identity does not enumerate all source branches or client failures.","method":"Read fixed REL_18_6 errcodes.txt and locked facts.","position":0,"runtime":[],"sources":["src.errcodes.42P21.18.6"],"statement":"42P21 is the collation_mismatch condition in Class 42."}},{"Kind":"claims","Ordinal":1,"ID":"mechanism.selected-source-path","ServerVersion":null,"Status":null,"Payload":{"claim_id":"mechanism.selected-source-path","limits":"Representative confirmed core paths only; not exhaustive historical or extension coverage.","method":"Read complete parse_collate.c derivation context and the selected resolved report groups in parse_cte.c and tablecmds.c.","position":1,"runtime":[],"sources":["src.call.42P21.69245d264e1d0e386e33036f","src.call.42P21.0ba27778e76c3d44b1cc79f6","src.call.42P21.93a028fdb350e0d054f123d8","src.call.42P21.16107e45585553ed56b18241","src.call.42P21.5fcad21fbefb1ae15acf4c73","src.call.42P21.ef5edd918af762963c8e072c","src.call.42P21.04a0360be247ab8ca050e826","src.context.42P21.parse_collate.common"],"statement":"Selected fixed 18.6 paths reject explicit collation conflicts immediately, emit implicit conflicts only when a caller requires one common collation, and check recursive output, inherited or child columns, and foreign-key collation compatibility."}},{"Kind":"claims","Ordinal":2,"ID":"boundary.implicit-none-ok","ServerVersion":null,"Status":null,"Payload":{"claim_id":"boundary.implicit-none-ok","limits":"This is source control-flow evidence, not a natural runtime observation.","method":"Read select_common_collation and the COLLATE_CONFLICT/COLLATE_EXPLICIT branches in fixed parse_collate.c.","position":2,"runtime":[],"sources":["src.context.42P21.parse_collate.common"],"statement":"select_common_collation(..., none_ok=true) may return InvalidOid while retaining an implicit COLLATE_CONFLICT; a later caller that requires a collation can then report a separate indeterminate-collation condition."}},{"Kind":"claims","Ordinal":3,"ID":"versions.catalogue-boundary","ServerVersion":null,"Status":null,"Payload":{"claim_id":"versions.catalogue-boundary","limits":"First observed release is a lower bound, not precise behavioral introduction.","method":"Read locked catalogue facts and definition snapshot.","position":3,"runtime":[],"sources":["src.errcodes.42P21.18.6"],"statement":"Locked catalogue snapshots show this condition by PostgreSQL 9.1.0; source behavior here is fixed at PostgreSQL 18.6."}},{"Kind":"messages","Ordinal":0,"ID":"message.variant-1","ServerVersion":null,"Status":null,"Payload":{"limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","message_id":"message.variant-1","path":"","position":0,"raw":{"detail_templates":[],"hint_templates":["You can choose the collation by applying the COLLATE clause to one or both expressions."],"id":"message.variant-1","limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","primary_template":"collation mismatch between implicit collations \"%s\" and \"%s\"","roles":[{"role":"errmsg","template":"collation mismatch between implicit collations \"%s\" and \"%s\""},{"role":"errhint","template":"You can choose the collation by applying the COLLATE clause to one or both expressions."}],"severity_source":"ERROR","sources":["src.call.42P21.69245d264e1d0e386e33036f"],"sqlstate":"42P21"},"severity":"ERROR","sources":["src.call.42P21.69245d264e1d0e386e33036f"],"templates":[{"kind":"primary","literal":"collation mismatch between implicit collations \" \" and \" \"","position":0,"role":"","template":"collation mismatch between implicit collations \"%s\" and \"%s\""},{"kind":"hint","literal":"You can choose the collation by applying the COLLATE clause to one or both expressions.","position":1,"role":"","template":"You can choose the collation by applying the COLLATE clause to one or both expressions."},{"kind":"primary","literal":"You can choose the collation by applying the COLLATE clause to one or both expressions.","position":2,"role":"errhint","template":"You can choose the collation by applying the COLLATE clause to one or both expressions."}]}},{"Kind":"messages","Ordinal":1,"ID":"message.variant-2","ServerVersion":null,"Status":null,"Payload":{"limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","message_id":"message.variant-2","path":"","position":1,"raw":{"detail_templates":[],"hint_templates":[],"id":"message.variant-2","limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","primary_template":"collation mismatch between explicit collations \"%s\" and \"%s\"","roles":[{"role":"errmsg","template":"collation mismatch between explicit collations \"%s\" and \"%s\""}],"severity_source":"ERROR","sources":["src.call.42P21.0ba27778e76c3d44b1cc79f6"],"sqlstate":"42P21"},"severity":"ERROR","sources":["src.call.42P21.0ba27778e76c3d44b1cc79f6"],"templates":[{"kind":"primary","literal":"collation mismatch between explicit collations \" \" and \" \"","position":0,"role":"","template":"collation mismatch between explicit collations \"%s\" and \"%s\""}]}},{"Kind":"messages","Ordinal":2,"ID":"message.variant-3","ServerVersion":null,"Status":null,"Payload":{"limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","message_id":"message.variant-3","path":"","position":2,"raw":{"detail_templates":[],"hint_templates":["Use the COLLATE clause to set the collation of the non-recursive term."],"id":"message.variant-3","limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","primary_template":"recursive query \"%s\" column %d has collation \"%s\" in non-recursive term but collation \"%s\" overall","roles":[{"role":"errmsg","template":"recursive query \"%s\" column %d has collation \"%s\" in non-recursive term but collation \"%s\" overall"},{"role":"errhint","template":"Use the COLLATE clause to set the collation of the non-recursive term."}],"severity_source":"ERROR","sources":["src.call.42P21.93a028fdb350e0d054f123d8"],"sqlstate":"42P21"},"severity":"ERROR","sources":["src.call.42P21.93a028fdb350e0d054f123d8"],"templates":[{"kind":"primary","literal":"recursive query \" \" column has collation \" \" in non-recursive term but collation \" \" overall","position":0,"role":"","template":"recursive query \"%s\" column %d has collation \"%s\" in non-recursive term but collation \"%s\" overall"},{"kind":"hint","literal":"Use the COLLATE clause to set the collation of the non-recursive term.","position":1,"role":"","template":"Use the COLLATE clause to set the collation of the non-recursive term."},{"kind":"primary","literal":"Use the COLLATE clause to set the collation of the non-recursive term.","position":2,"role":"errhint","template":"Use the COLLATE clause to set the collation of the non-recursive term."}]}},{"Kind":"messages","Ordinal":3,"ID":"message.variant-4","ServerVersion":null,"Status":null,"Payload":{"limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","message_id":"message.variant-4","path":"","position":3,"raw":{"detail_templates":["\"%s\" versus \"%s\""],"hint_templates":[],"id":"message.variant-4","limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","primary_template":"column \"%s\" has a collation conflict","roles":[{"role":"errmsg","template":"column \"%s\" has a collation conflict"},{"role":"errdetail","template":"\"%s\" versus \"%s\""}],"severity_source":"ERROR","sources":["src.call.42P21.16107e45585553ed56b18241"],"sqlstate":"42P21"},"severity":"ERROR","sources":["src.call.42P21.16107e45585553ed56b18241"],"templates":[{"kind":"primary","literal":"column \" \" has a collation conflict","position":0,"role":"","template":"column \"%s\" has a collation conflict"},{"kind":"detail","literal":"\" \" versus \" \"","position":1,"role":"","template":"\"%s\" versus \"%s\""},{"kind":"primary","literal":"\" \" versus \" \"","position":2,"role":"errdetail","template":"\"%s\" versus \"%s\""}]}},{"Kind":"messages","Ordinal":4,"ID":"message.variant-5","ServerVersion":null,"Status":null,"Payload":{"limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","message_id":"message.variant-5","path":"","position":4,"raw":{"detail_templates":["\"%s\" versus \"%s\""],"hint_templates":[],"id":"message.variant-5","limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","primary_template":"inherited column \"%s\" has a collation conflict","roles":[{"role":"errmsg","template":"inherited column \"%s\" has a collation conflict"},{"role":"errdetail","template":"\"%s\" versus \"%s\""}],"severity_source":"ERROR","sources":["src.call.42P21.5fcad21fbefb1ae15acf4c73"],"sqlstate":"42P21"},"severity":"ERROR","sources":["src.call.42P21.5fcad21fbefb1ae15acf4c73"],"templates":[{"kind":"primary","literal":"inherited column \" \" has a collation conflict","position":0,"role":"","template":"inherited column \"%s\" has a collation conflict"},{"kind":"detail","literal":"\" \" versus \" \"","position":1,"role":"","template":"\"%s\" versus \"%s\""},{"kind":"primary","literal":"\" \" versus \" \"","position":2,"role":"errdetail","template":"\"%s\" versus \"%s\""}]}},{"Kind":"messages","Ordinal":5,"ID":"message.variant-6","ServerVersion":null,"Status":null,"Payload":{"limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","message_id":"message.variant-6","path":"","position":5,"raw":{"detail_templates":["\"%s\" versus \"%s\""],"hint_templates":[],"id":"message.variant-6","limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","primary_template":"child table \"%s\" has different collation for column \"%s\"","roles":[{"role":"errmsg","template":"child table \"%s\" has different collation for column \"%s\""},{"role":"errdetail","template":"\"%s\" versus \"%s\""}],"severity_source":"ERROR","sources":["src.call.42P21.ef5edd918af762963c8e072c"],"sqlstate":"42P21"},"severity":"ERROR","sources":["src.call.42P21.ef5edd918af762963c8e072c"],"templates":[{"kind":"primary","literal":"child table \" \" has different collation for column \" \"","position":0,"role":"","template":"child table \"%s\" has different collation for column \"%s\""},{"kind":"detail","literal":"\" \" versus \" \"","position":1,"role":"","template":"\"%s\" versus \"%s\""},{"kind":"primary","literal":"\" \" versus \" \"","position":2,"role":"errdetail","template":"\"%s\" versus \"%s\""}]}},{"Kind":"messages","Ordinal":6,"ID":"message.variant-7","ServerVersion":null,"Status":null,"Payload":{"limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","message_id":"message.variant-7","path":"","position":6,"raw":{"detail_templates":["Key columns \"%s\" of the referencing table and \"%s\" of the referenced table have incompatible collations: \"%s\" and \"%s\".  If either collation is nondeterministic, then both collations have to be the same."],"hint_templates":[],"id":"message.variant-7","limits":"Placeholders remain dynamic source fields; no concrete runtime value is claimed.","primary_template":"foreign key constraint \"%s\" cannot be implemented","roles":[{"role":"errmsg","template":"foreign key constraint \"%s\" cannot be implemented"},{"role":"errdetail","template":"Key columns \"%s\" of the referencing table and \"%s\" of the referenced table have incompatible collations: \"%s\" and \"%s\".  If either collation is nondeterministic, then both collations have to be the same."}],"severity_source":"ERROR","sources":["src.call.42P21.04a0360be247ab8ca050e826"],"sqlstate":"42P21"},"severity":"ERROR","sources":["src.call.42P21.04a0360be247ab8ca050e826"],"templates":[{"kind":"primary","literal":"foreign key constraint \" \" cannot be implemented","position":0,"role":"","template":"foreign key constraint \"%s\" cannot be implemented"},{"kind":"detail","literal":"Key columns \" \" of the referencing table and \" \" of the referenced table have incompatible collations: \" \" and \" \". If either collation is nondeterministic, then both collations have to be the same.","position":1,"role":"","template":"Key columns \"%s\" of the referencing table and \"%s\" of the referenced table have incompatible collations: \"%s\" and \"%s\".  If either collation is nondeterministic, then both collations have to be the same."},{"kind":"primary","literal":"Key columns \" \" of the referencing table and \" \" of the referenced table have incompatible collations: \" \" and \" \". If either collation is nondeterministic, then both collations have to be the same.","position":2,"role":"errdetail","template":"Key columns \"%s\" of the referencing table and \"%s\" of the referenced table have incompatible collations: \"%s\" and \"%s\".  If either collation is nondeterministic, then both collations have to be the same."}]}},{"Kind":"sources","Ordinal":0,"ID":"src.errcodes.42P21.18.6","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"line 352","path":"src/backend/utils/errcodes.txt","position":0,"sha256":"6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba","source_id":"src.errcodes.42P21.18.6","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/errcodes.txt#L352"}},{"Kind":"sources","Ordinal":1,"ID":"src.call.42P21.69245d264e1d0e386e33036f","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"lines 226-232","path":"src/backend/parser/parse_collate.c","position":1,"sha256":"e92a01d1a7279f108ddfac1f0324f6d142b1496360ddac3dfb778564c4226940","source_id":"src.call.42P21.69245d264e1d0e386e33036f","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L226-L232"}},{"Kind":"sources","Ordinal":2,"ID":"src.call.42P21.0ba27778e76c3d44b1cc79f6","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"lines 853-858","path":"src/backend/parser/parse_collate.c","position":2,"sha256":"e92a01d1a7279f108ddfac1f0324f6d142b1496360ddac3dfb778564c4226940","source_id":"src.call.42P21.0ba27778e76c3d44b1cc79f6","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L853-L858"}},{"Kind":"sources","Ordinal":3,"ID":"src.call.42P21.93a028fdb350e0d054f123d8","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"lines 394-401","path":"src/backend/parser/parse_cte.c","position":3,"sha256":"908eef14ac26654fe0b9c176ef50e56ba710b7fcd8e1239b944d7c2152fc2d6b","source_id":"src.call.42P21.93a028fdb350e0d054f123d8","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_cte.c#L394-L401"}},{"Kind":"sources","Ordinal":4,"ID":"src.call.42P21.16107e45585553ed56b18241","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"lines 3297-3303","path":"src/backend/commands/tablecmds.c","position":4,"sha256":"422dc8e833df4940755973c757e338295822ba3e4c7266c40669f49f96eb15a9","source_id":"src.call.42P21.16107e45585553ed56b18241","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L3297-L3303"}},{"Kind":"sources","Ordinal":5,"ID":"src.call.42P21.5fcad21fbefb1ae15acf4c73","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"lines 3463-3469","path":"src/backend/commands/tablecmds.c","position":5,"sha256":"422dc8e833df4940755973c757e338295822ba3e4c7266c40669f49f96eb15a9","source_id":"src.call.42P21.5fcad21fbefb1ae15acf4c73","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L3463-L3469"}},{"Kind":"sources","Ordinal":6,"ID":"src.call.42P21.ef5edd918af762963c8e072c","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"lines 7292-7298","path":"src/backend/commands/tablecmds.c","position":6,"sha256":"422dc8e833df4940755973c757e338295822ba3e4c7266c40669f49f96eb15a9","source_id":"src.call.42P21.ef5edd918af762963c8e072c","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L7292-L7298"}},{"Kind":"sources","Ordinal":7,"ID":"src.call.42P21.04a0360be247ab8ca050e826","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"lines 10474-10483","path":"src/backend/commands/tablecmds.c","position":7,"sha256":"422dc8e833df4940755973c757e338295822ba3e4c7266c40669f49f96eb15a9","source_id":"src.call.42P21.04a0360be247ab8ca050e826","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L10474-L10483"}},{"Kind":"sources","Ordinal":8,"ID":"src.context.42P21.parse_collate.common","ServerVersion":null,"Status":null,"Payload":{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","docs_url":"","kind":"upstream_source","location":"lines 208-234 and 804-835","path":"src/backend/parser/parse_collate.c","position":8,"sha256":"e92a01d1a7279f108ddfac1f0324f6d142b1496360ddac3dfb778564c4226940","source_id":"src.context.42P21.parse_collate.common","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_collate.c#L208"}},{"Kind":"sources","Ordinal":9,"ID":"src.calls.REL_18_6.42P21","ServerVersion":null,"Status":null,"Payload":{"commit":"","docs_url":"","kind":"local_artifact","location":"","path":"raw/calls/REL_18_6.jsonl","position":9,"sha256":"9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf","source_id":"src.calls.REL_18_6.42P21","tag":"","url":""}}]}