↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / SQLSTATE

2200B — escape_character_conflict

转义字符与其他字符冲突。

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

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

aliases
未知
class name
Data Exception
condition name
escape_character_conflict
lang
en
sqlstate
2200B

版本定义 PG 18

2200B

速览 {#at-a-glance}

2200B 是 escape_character_conflict;本次固定源码扫描没有解析出原生报告组。

含义 {#meaning}

2200B 是 escape_character_conflict;本次固定源码扫描没有解析出原生报告组。

报文 {#messages}

有界源码扫描没有确认固定 PostgreSQL primary、DETAIL、HINT 或严重性。本页只记录定义与扫描边界,runtime_verification 保持 not_run。

诊断 {#diagnosis}

定位实际的 pattern/escape parser 或扩展,检查其转义规则;本次无路径扫描不能替代部署版本源码检查。

处置 {#response}

找到实际选择该码的组件后,按 parser 的转义规则修正 pattern 和 escape 配置;不要用通用 RAISE 伪造解析器行为,也不要从这条源码边界推断事务恢复。

版本 {#versions}

锁定目录从 7.4 记录该条件,并在列出的正式快照及 19beta3 中出现;固定源码覆盖为 PostgreSQL 18.6。

相关条件 {#related}

22000, 22001, 22003, 22004

来源 {#sources}

详见结构化的证据记录,其中列出固定源码链接与范围限制。

比较版本

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

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": ""
}

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:bf7778ba5e91f3a370caadea2d5b72e0fea7c1e872093a66cffcb3ce93b61dd2

正文语言: zh-Hans · english-manuals:bf7778ba5e91f3a370caadea2d5b72e0fea7c1e872093a66cffcb3ce93b61dd2