42P22 — 无法确定排序规则

操作需要唯一排序规则，但无法确定。

英文手册覆盖始于 PostgreSQL 8.1. 来源历史与运行验证各自保留独立版本边界。

当前阅读 PG 18·选择有来源记录的版本

9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

aliases: 未知
class name: Syntax Error or Access Rule Violation
condition name: indeterminate_collation
lang: en
sqlstate: 42P22

版本定义 PG 18

42P22 — 无法确定排序规则

速览 {#at-a-glance}

42P22（indeterminate_collation）需要唯一排序规则的操作没有明确可用的排序规则。

含义 {#meaning}

当选定操作需要可用的排序规则，但推导结果为空（通常表现为 InvalidOid）时，会报 42P22。这与 42P21 不同：这里的调用方消息指出无法继续的具体操作，而不是列出两个显式排序规则名称。固定核心调用方包括字符串哈希或比较、索引和分区表达式、CTAS 与视图输出列、正则表达式、LIKE/ILIKE 以及格式化函数。

诊断 {#diagnosis}

先读取 primary 消息指出的操作，再追踪字符串表达式到应当选择排序规则的边界。哈希或比较消息指向运算符或值表达式；索引或分区消息指向定义表达式；CTAS 或视图列消息指向输出列；正则、LIKE 和 ILIKE 消息指向模式操作数；%s function 消息会指出格式化函数。固定调用方提供相同的 HINT：Use the COLLATE clause to set the collation explicitly.。应在表达式或声明列的语义边界做明确选择，并把这种缺少排序规则的要求与 42P21 中已知选择之间的冲突区分开。

处理 {#response}

在真正拥有语义选择的表达式或输出列边界添加 COLLATE，必要时重建受影响的索引、分区、视图或 CTAS 定义。在该排序规则下核对比较、哈希、模式、正则和格式化行为；不要为了消除一个调用方错误而全局修改数据库 locale。如果该 ERROR 发生在显式事务中，重试前先 ROLLBACK，或回滚到错误前的保存点；自动提交模式下，连接返回空闲后即可提交修正语句。

消息 {#messages}

固定源码中的代表性消息包括：

ERROR message: could not determine which collation to use for string hashing; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: no collation was derived for column "%s" with collatable type %s; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: could not determine which collation to use for index expression; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: could not determine which collation to use for partition expression; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: could not determine which collation to use for view column "%s"; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: could not determine which collation to use for regular expression; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: could not determine which collation to use for %s function; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: could not determine which collation to use for LIKE; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: could not determine which collation to use for ILIKE; HINT: Use the COLLATE clause to set the collation explicitly.
ERROR message: could not determine which collation to use for string comparison; HINT: Use the COLLATE clause to set the collation explicitly.

占位符由实际对象、列或参数填充。

版本 {#versions}

锁定目录显示该条件最早见于 PostgreSQL 9.1.0；行为说明固定在 PostgreSQL 18.6 源码，目录存在范围不等于每条消息或功能都从该版本开始。

来源 {#sources}

源码消息、行号和证据边界见作者证据。

src/backend/access/hash/hashfunc.c:278-281 (fixed source)
src/backend/commands/createas.c:198-203 (fixed source)
src/backend/commands/indexcmds.c:2105-2108 (fixed source)
src/backend/commands/tablecmds.c:20041-20044 (fixed source)
src/backend/commands/view.c:76-80 (fixed source)
src/backend/regex/regc_pg_locale.c:239-242 (fixed source)
src/backend/utils/adt/like.c:160-163 (fixed source)
src/backend/utils/adt/like.c:191-194 (fixed source)
src/backend/utils/adt/varchar.c:735-738 (fixed source)
src/backend/utils/adt/formatting.c:1654-1658 (fixed source)

比较版本

SQLSTATE 证据与已记录的运行版本

claims · identity.class-and-condition

{
  "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.42P22.18.6"
  ],
  "statement": "42P22 is the indeterminate_collation condition in Class 42."
}

claims · mechanism.selected-source-path

{
  "claim_id": "mechanism.selected-source-path",
  "limits": "Representative confirmed core paths only; not exhaustive historical or extension coverage.",
  "method": "Read selected resolved report groups and the surrounding fixed caller guards, preserving each caller-specific primary and COLLATE hint.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.call.42P22.9663977b60d9074ca1246b2e",
    "src.call.42P22.de5cfc36b17b669d27e71821",
    "src.call.42P22.9001b972a28a8028eebe7eae",
    "src.call.42P22.b8ebf0f4bd61f9bcbbfdb513",
    "src.call.42P22.fcf0f384dd027c687389c530",
    "src.call.42P22.b60a368090edbb3ad28c2b74",
    "src.call.42P22.584d77b09f81511c429fd3bc",
    "src.call.42P22.c024a0dd3694f6694d2b94fc",
    "src.call.42P22.3baebb248e633d9c8e75f53f",
    "src.call.42P22.0c130e4570c3138a788409e1"
  ],
  "statement": "Selected fixed 18.6 callers raise 42P22 when a required operation has no determinate collation: string hashing or comparison, index or partition expressions, CTAS or view output columns, regular expressions, LIKE or ILIKE, and formatting functions."
}

claims · boundary.caller-specific-hint

{
  "claim_id": "boundary.caller-specific-hint",
  "limits": "Selected message-role comparison only; no runtime execution is claimed.",
  "method": "Compare the message roles across the selected hash, DDL, regex, pattern, comparison, and formatting report groups.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.call.42P22.9663977b60d9074ca1246b2e",
    "src.call.42P22.de5cfc36b17b669d27e71821",
    "src.call.42P22.9001b972a28a8028eebe7eae",
    "src.call.42P22.b8ebf0f4bd61f9bcbbfdb513",
    "src.call.42P22.fcf0f384dd027c687389c530",
    "src.call.42P22.b60a368090edbb3ad28c2b74",
    "src.call.42P22.584d77b09f81511c429fd3bc",
    "src.call.42P22.c024a0dd3694f6694d2b94fc",
    "src.call.42P22.3baebb248e633d9c8e75f53f",
    "src.call.42P22.0c130e4570c3138a788409e1"
  ],
  "statement": "The fixed callers attach the same explicit-COLLATE hint while naming the operation that lacks a usable collation; the primary message determines which expression or definition boundary to inspect."
}

claims · versions.catalogue-boundary

{
  "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.42P22.18.6"
  ],
  "statement": "Locked catalogue snapshots show this condition by PostgreSQL 9.1.0; source behavior here is fixed at PostgreSQL 18.6."
}

messages · message.variant-1

{
  "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": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-1",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for string hashing",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for string hashing"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.9663977b60d9074ca1246b2e"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.9663977b60d9074ca1246b2e"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for string hashing",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for string hashing"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-2

{
  "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": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-2",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "no collation was derived for column \"%s\" with collatable type %s",
    "roles": [
      {
        "role": "errmsg",
        "template": "no collation was derived for column \"%s\" with collatable type %s"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.de5cfc36b17b669d27e71821"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.de5cfc36b17b669d27e71821"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "no collation was derived for column \" \" with collatable type",
      "position": 0,
      "role": "",
      "template": "no collation was derived for column \"%s\" with collatable type %s"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-3

{
  "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 explicitly."
    ],
    "id": "message.variant-3",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for index expression",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for index expression"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.9001b972a28a8028eebe7eae"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.9001b972a28a8028eebe7eae"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for index expression",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for index expression"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-4

{
  "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
  "message_id": "message.variant-4",
  "path": "",
  "position": 3,
  "raw": {
    "detail_templates": [],
    "hint_templates": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-4",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for partition expression",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for partition expression"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.b8ebf0f4bd61f9bcbbfdb513"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.b8ebf0f4bd61f9bcbbfdb513"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for partition expression",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for partition expression"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-5

{
  "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
  "message_id": "message.variant-5",
  "path": "",
  "position": 4,
  "raw": {
    "detail_templates": [],
    "hint_templates": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-5",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for view column \"%s\"",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for view column \"%s\""
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.fcf0f384dd027c687389c530"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.fcf0f384dd027c687389c530"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for view column \" \"",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for view column \"%s\""
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-6

{
  "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
  "message_id": "message.variant-6",
  "path": "",
  "position": 5,
  "raw": {
    "detail_templates": [],
    "hint_templates": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-6",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for regular expression",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for regular expression"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.b60a368090edbb3ad28c2b74"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.b60a368090edbb3ad28c2b74"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for regular expression",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for regular expression"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-7

{
  "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
  "message_id": "message.variant-7",
  "path": "",
  "position": 6,
  "raw": {
    "detail_templates": [],
    "hint_templates": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-7",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for %s function",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for %s function"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.584d77b09f81511c429fd3bc"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.584d77b09f81511c429fd3bc"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for function",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for %s function"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-8

{
  "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
  "message_id": "message.variant-8",
  "path": "",
  "position": 7,
  "raw": {
    "detail_templates": [],
    "hint_templates": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-8",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for LIKE",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for LIKE"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.c024a0dd3694f6694d2b94fc"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.c024a0dd3694f6694d2b94fc"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for LIKE",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for LIKE"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-9

{
  "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
  "message_id": "message.variant-9",
  "path": "",
  "position": 8,
  "raw": {
    "detail_templates": [],
    "hint_templates": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-9",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for ILIKE",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for ILIKE"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.3baebb248e633d9c8e75f53f"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.3baebb248e633d9c8e75f53f"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for ILIKE",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for ILIKE"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

messages · message.variant-10

{
  "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
  "message_id": "message.variant-10",
  "path": "",
  "position": 9,
  "raw": {
    "detail_templates": [],
    "hint_templates": [
      "Use the COLLATE clause to set the collation explicitly."
    ],
    "id": "message.variant-10",
    "limits": "Placeholders remain dynamic source fields; no concrete runtime value is claimed.",
    "primary_template": "could not determine which collation to use for string comparison",
    "roles": [
      {
        "role": "errmsg",
        "template": "could not determine which collation to use for string comparison"
      },
      {
        "role": "errhint",
        "template": "Use the COLLATE clause to set the collation explicitly."
      }
    ],
    "severity_source": "ERROR",
    "sources": [
      "src.call.42P22.0c130e4570c3138a788409e1"
    ],
    "sqlstate": "42P22"
  },
  "severity": "ERROR",
  "sources": [
    "src.call.42P22.0c130e4570c3138a788409e1"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "could not determine which collation to use for string comparison",
      "position": 0,
      "role": "",
      "template": "could not determine which collation to use for string comparison"
    },
    {
      "kind": "hint",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 1,
      "role": "",
      "template": "Use the COLLATE clause to set the collation explicitly."
    },
    {
      "kind": "primary",
      "literal": "Use the COLLATE clause to set the collation explicitly.",
      "position": 2,
      "role": "errhint",
      "template": "Use the COLLATE clause to set the collation explicitly."
    }
  ]
}

sources · src.errcodes.42P22.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "line 353",
  "path": "src/backend/utils/errcodes.txt",
  "position": 0,
  "sha256": "6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba",
  "source_id": "src.errcodes.42P22.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/errcodes.txt#L353"
}

sources · src.call.42P22.9663977b60d9074ca1246b2e

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 278-281",
  "path": "src/backend/access/hash/hashfunc.c",
  "position": 1,
  "sha256": "ada1fcc9863e6f9c91b4aed90c37cbc50717a74a1ebdd050c3eb33db46f24f22",
  "source_id": "src.call.42P22.9663977b60d9074ca1246b2e",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/access/hash/hashfunc.c#L278-L281"
}

sources · src.call.42P22.de5cfc36b17b669d27e71821

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 198-203",
  "path": "src/backend/commands/createas.c",
  "position": 2,
  "sha256": "f484080c0ec3d303040d94c15817d7dd86aed8e716afd81b45718d4b4443e9c7",
  "source_id": "src.call.42P22.de5cfc36b17b669d27e71821",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/createas.c#L198-L203"
}

sources · src.call.42P22.9001b972a28a8028eebe7eae

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 2105-2108",
  "path": "src/backend/commands/indexcmds.c",
  "position": 3,
  "sha256": "0bdae365f207ab82865806c5983cac94c5c062e7a61ab7c883ccb7e2015fad36",
  "source_id": "src.call.42P22.9001b972a28a8028eebe7eae",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/indexcmds.c#L2105-L2108"
}

sources · src.call.42P22.b8ebf0f4bd61f9bcbbfdb513

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 20041-20044",
  "path": "src/backend/commands/tablecmds.c",
  "position": 4,
  "sha256": "422dc8e833df4940755973c757e338295822ba3e4c7266c40669f49f96eb15a9",
  "source_id": "src.call.42P22.b8ebf0f4bd61f9bcbbfdb513",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L20041-L20044"
}

sources · src.call.42P22.fcf0f384dd027c687389c530

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 76-80",
  "path": "src/backend/commands/view.c",
  "position": 5,
  "sha256": "53c9efccdefa62fa522cd16315ad925779da1bd76a92324df3ba340c967d953c",
  "source_id": "src.call.42P22.fcf0f384dd027c687389c530",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/view.c#L76-L80"
}

sources · src.call.42P22.b60a368090edbb3ad28c2b74

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 239-242",
  "path": "src/backend/regex/regc_pg_locale.c",
  "position": 6,
  "sha256": "3dab816f911f623d39966e5b3a8f1d82d4f2ff8b697496d754aba52848c54c4e",
  "source_id": "src.call.42P22.b60a368090edbb3ad28c2b74",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/regex/regc_pg_locale.c#L239-L242"
}

sources · src.call.42P22.584d77b09f81511c429fd3bc

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 1654-1658",
  "path": "src/backend/utils/adt/formatting.c",
  "position": 7,
  "sha256": "a22651cc223e93c1879420004027325579fc79a3ba8684408496149164a2220c",
  "source_id": "src.call.42P22.584d77b09f81511c429fd3bc",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/adt/formatting.c#L1654-L1658"
}

sources · src.call.42P22.c024a0dd3694f6694d2b94fc

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 160-163",
  "path": "src/backend/utils/adt/like.c",
  "position": 8,
  "sha256": "7665cf5399a9090f2bd864c7442ae22af68d2bc9368bf06b8ebef48613a1ed08",
  "source_id": "src.call.42P22.c024a0dd3694f6694d2b94fc",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/adt/like.c#L160-L163"
}

sources · src.call.42P22.3baebb248e633d9c8e75f53f

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 191-194",
  "path": "src/backend/utils/adt/like.c",
  "position": 9,
  "sha256": "7665cf5399a9090f2bd864c7442ae22af68d2bc9368bf06b8ebef48613a1ed08",
  "source_id": "src.call.42P22.3baebb248e633d9c8e75f53f",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/adt/like.c#L191-L194"
}

sources · src.call.42P22.0c130e4570c3138a788409e1

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "lines 735-738",
  "path": "src/backend/utils/adt/varchar.c",
  "position": 10,
  "sha256": "aee29b2c745b34a7299d158b8e8c60b2c6c4900a5e3751fd211acea81b431f42",
  "source_id": "src.call.42P22.0c130e4570c3138a788409e1",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/adt/varchar.c#L735-L738"
}

sources · src.calls.REL_18_6.42P22

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_18_6.jsonl",
  "position": 11,
  "sha256": "9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf",
  "source_id": "src.calls.REL_18_6.42P22",
  "tag": "",
  "url": ""
}

来源引用

原始手册引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:52b2e0b9b3b04d5291109d551d813d26f8cdff9daca2dde464a31e08fad33e2b

正文语言: zh-Hans · english-manuals:52b2e0b9b3b04d5291109d551d813d26f8cdff9daca2dde464a31e08fad33e2b

42P22 — 无法确定排序规则

版本定义 PG 18

42P22 — 无法确定排序规则

速览 {#at-a-glance}

含义 {#meaning}

诊断 {#diagnosis}

处理 {#response}

消息 {#messages}

版本 {#versions}

相关 {#related}

来源 {#sources}

比较版本

SQLSTATE 证据与已记录的运行版本

来源引用