22000 — data_exception

数据异常的通用类别，具体原因见成员码。

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

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

8.1 8.2 8.3 8.4 9.0 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: Data Exception
condition name: data_exception
lang: en
sqlstate: 22000

版本定义 PG 18

22000

速览 {#at-a-glance}

固定 array_append 路径要求数组参数为空或一维，否则报告维度错误；其他 Data Exception 路径有各自的消息。

含义 {#meaning}

固定 array_append 路径要求数组参数为空或一维，否则报告维度错误；其他 Data Exception 路径有各自的消息。

报文 {#messages}

已确认的 guard 以 ERROR 严重性报告 primary：argument must be empty or one-dimensional array。该源码路径没有独立的 DETAIL 或 HINT。本页只有源码证据，没有自然运行观察。

诊断 {#diagnosis}

先看完整消息、array_append 调用和参数类型。已确认的路径拒绝既非空又非一维的数组参数；其他 Data Exception 路径需按各自消息定位。

处置 {#response}

修正数组形状或改用接受目标维度的函数契约，先校验参数再执行。这是 ERROR：显式事务中要回滚整个事务，或回滚到调用前建立的保存点后再继续。不要把所有 Data Exception 当成同一种修复；本页没有运行案例。

版本 {#versions}

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

来源 {#sources}

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

比较版本

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

claims · identity

{
  "claim_id": "identity",
  "limits": "",
  "method": "Read fixed definition.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "22000 is data_exception in SQLSTATE Class 22."
}

claims · mechanism.array-append

{
  "claim_id": "mechanism.array-append",
  "limits": "This confirms one core array path, not every Data Exception caller.",
  "method": "Read the complete array_userfuncs.c branch.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.path.array-append"
  ],
  "statement": "array_append accepts an empty or one-dimensional array; a multi-dimensional argument emits 22000 with the dimensionality message."
}

claims · history

{
  "claim_id": "history",
  "limits": "",
  "method": "Use catalogue boundary.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "The locked catalogue records 22000 from 7.4 without proving an exact implementation introduction date."
}

messages · message.array

{
  "limits": "",
  "message_id": "message.array",
  "path": "",
  "position": 0,
  "raw": {
    "id": "message.array",
    "primary_template": "argument must be empty or one-dimensional array",
    "severity_source": "ERROR",
    "sources": [
      "src.path.array-append"
    ],
    "sqlstate": "22000"
  },
  "severity": "ERROR",
  "sources": [
    "src.path.array-append"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "argument must be empty or one-dimensional array",
      "position": 0,
      "role": "",
      "template": "argument must be empty or one-dimensional array"
    }
  ]
}

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#L161"
}

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

sources · src.path.array-append

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/utils/adt/array_userfuncs.c",
  "position": 2,
  "sha256": "dc14f95e12c92360f8b10c7546d8af4a0b41a6a0431efc2a4f5b236155eadb50",
  "source_id": "src.path.array-append",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/adt/array_userfuncs.c#L173-L175"
}

来源引用

原始手册引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:b1ec08024ec4db456ecace958837ce2cfc60a162d9952b4d94dc496422cf84fa

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