42P22 — Indeterminate collation
42P22 (indeterminate_collation) An operation that needs one collation has no unambiguous collation to use.
English manual coverage begins with PostgreSQL 8.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- aliases
- Unknown
- class name
- Syntax Error or Access Rule Violation
- condition name
- indeterminate_collation
- lang
- en
- sqlstate
- 42P22
Definition PG 18
42P22 — Indeterminate collation
At a glance {#at-a-glance}
42P22 (indeterminate_collation) An operation that needs one collation has no unambiguous collation to use.
Meaning {#meaning}
42P22 is emitted when a selected operation requires a usable collation but derivation produced none, often represented by InvalidOid. This is different from 42P21: the caller-specific message names the operation that cannot proceed instead of presenting two explicit collation names. Fixed core callers include string hashing or comparison, index and partition expressions, CTAS and view output columns, regular expressions, LIKE/ILIKE, and formatting functions.
Diagnosis {#diagnosis}
Read the operation named by the primary message and trace its string expression to the point where collation should be chosen. Hashing or comparison points to the operator or value expression; an index or partition message points to the definition expression; a CTAS or view-column message points to the output column; regex, LIKE, and ILIKE point to the pattern operands; a %s function message names the formatting function. The fixed callers supply the caller-specific HINT Use the COLLATE clause to set the collation explicitly.. Choose the expression or declared-column boundary deliberately, and distinguish this no-collation requirement from a 42P21 conflict between known choices.
Response {#response}
Apply COLLATE at the expression or output-column boundary that owns the semantic choice, then recreate the affected index, partition, view, or CTAS definition when required. Verify comparison, hashing, pattern, regex, and formatting behavior under that collation; do not change the database locale globally just to silence one caller. If this ERROR occurs inside an explicit transaction, issue ROLLBACK or ROLLBACK TO a pre-error savepoint before retrying; autocommit can submit the corrected statement after returning to idle.
Messages {#messages}
Representative fixed-source messages include:
- 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.
Placeholders are filled by the actual object, column, or parameter.
Versions {#versions}
The locked catalogue shows this condition by PostgreSQL 9.1.0; behavior here is fixed to PostgreSQL 18.6 source. Catalogue presence is a range boundary, not proof that every message or feature began in that release.
Related {#related}
Sources {#sources}
Source messages, line anchors, and evidence limits are recorded in authored evidence.
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)
Compare versions
SQLSTATE evidence and recorded runtime versions
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": ""
}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · english-manuals:52b2e0b9b3b04d5291109d551d813d26f8cdff9daca2dde464a31e08fad33e2b
Text language: en · english-manuals:52b2e0b9b3b04d5291109d551d813d26f8cdff9daca2dde464a31e08fad33e2b