↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / SQLSTATE

2200B — escape_character_conflict

2200B is escapecharacterconflict. The fixed 18.6 call archive has no resolved native report group in this scan.

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
Data Exception
condition name
escape_character_conflict
lang
en
sqlstate
2200B

Definition PG 18

2200B

At a glance {#at-a-glance}

2200B is escape_character_conflict. The fixed 18.6 call archive has no resolved native report group in this scan.

Meaning {#meaning}

2200B is escape_character_conflict. The fixed 18.6 call archive has no resolved native report group in this scan.

Messages {#messages}

No fixed PostgreSQL primary, DETAIL, HINT, or severity was confirmed in the bounded source scan. This page is definition/scan-boundary reference only; runtime_verification remains not_run.

Diagnosis {#diagnosis}

Locate the pattern/escape parser or extension that selected the code and inspect its escape-character rules. A no-path scan is an evidence boundary, not an absence claim.

Response {#response}

Correct the actual pattern and escape configuration according to the deployed parser after locating the component that selected the code. Do not manufacture this SQLSTATE with a generic RAISE to stand in for parser behavior, and do not infer transaction recovery from this source-only boundary.

Versions {#versions}

The locked catalogue records this condition from 7.4 in the listed formal snapshots and 19beta3; fixed source coverage is PostgreSQL 18.6.

Related {#related}

22000, 22001, 22003, 22004

Sources {#sources}

See the fixed source links and scope limits in the structured evidence record.

Compare versions

SQLSTATE evidence and recorded runtime versions

claims · identity
{
  "claim_id": "identity",
  "limits": "",
  "method": "Read fixed definition.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "2200B is escape_character_conflict in SQLSTATE Class 22."
}
claims · bounded-scan
{
  "claim_id": "bounded-scan",
  "limits": "This does not exclude an ECPG, extension, wrapper, or other unscanned path.",
  "method": "Search fixed call records for the macro.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.calls.REL_18_6"
  ],
  "statement": "The bounded REL_18_6 call archive contains no resolved report group for 2200B."
}
claims · meaning-boundary
{
  "claim_id": "meaning-boundary",
  "limits": "No fixed native message template was confirmed.",
  "method": "Keep definition and emitter evidence separate.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6",
    "src.calls.REL_18_6"
  ],
  "statement": "The condition name identifies a conflict in the escape-character contract; the actual parser and primary message must be captured before prescribing a quoting repair."
}
claims · history
{
  "claim_id": "history",
  "limits": "",
  "method": "Use catalogue boundary.",
  "position": 3,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "The locked catalogue records 2200B from 7.4 without proving an exact implementation introduction date."
}
sources · src.errcodes.18.6
{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/utils/errcodes.txt",
  "position": 0,
  "sha256": "6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba",
  "source_id": "src.errcodes.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/errcodes.txt#L170"
}
sources · src.calls.REL_18_6
{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_18_6.jsonl",
  "position": 1,
  "sha256": "9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf",
  "source_id": "src.calls.REL_18_6",
  "tag": "",
  "url": ""
}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:bf7778ba5e91f3a370caadea2d5b72e0fea7c1e872093a66cffcb3ce93b61dd2

Text language: en · english-manuals:bf7778ba5e91f3a370caadea2d5b72e0fea7c1e872093a66cffcb3ce93b61dd2