22010 — invalid_indicator_parameter_value

An indicator parameter value does not satisfy the indicator or descriptor rules of the operation consuming it. The fixed PostgreSQL 18.6 catalogue confirms the condition, but the bounded source scan does not bind it to a native emitter, message template, or severity.

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

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: Unknown
class name: Data Exception
condition name: invalid_indicator_parameter_value
lang: en
sqlstate: 22010

Definition PG 18

At a glance {#at-a-glance}

Meaning {#meaning}

22010 concerns a value carried alongside an operation as an indicator or descriptor field. The condition name alone does not identify a particular API, indicator layout, or server routine; the operation that reports it defines which values are valid.

Diagnosis {#diagnosis}

Capture the complete diagnostic, operation or API owner, parameter position, source type, and actual indicator value. Check initialization, permitted sign and value ranges, and whether a wrapper translates the failure. A NULL or cast diagnostic by itself does not establish 22010, and this fixed-source review does not infer an ECPG emitter from the name.

Response {#response}

Correct the named indicator or descriptor value according to the consuming operation's documented rules, then repeat the operation only after checking its other inputs. If the message comes from a wrapper, repair that wrapper's input mapping rather than assuming a PostgreSQL server-side path.

Versions {#versions}

The locked catalogue records this condition from 7.4; fixed source coverage is PostgreSQL 18.6. The exact implementation introduction date and an emitting path remain unresolved by this bounded review.

Related {#related}

22002, 22004

Sources {#sources}

The fixed definition is confirmed in errcodes.txt. Runtime verification is not_run; the bounded PostgreSQL 18.6 scan does not resolve a native emitting function, so this page does not assert a primary template, severity, transaction effect, or API owner. The structured evidence record retains the definition and scope boundary.

Compare versions

SQLSTATE evidence and recorded runtime versions

claims · identity

{
  "claim_id": "identity",
  "limits": "",
  "method": "Read the fixed errcodes row and macro.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "22010 is invalid_indicator_parameter_value in SQLSTATE Class 22."
}

claims · bounded-source-scope

{
  "claim_id": "bounded-source-scope",
  "limits": "A client/API or extension may own the diagnostic; no emitter is asserted here.",
  "method": "Keep the catalogue definition separate from an unresolved emitter search.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "The bounded PostgreSQL 18.6 source review does not bind 22010 to a native emitter, primary template, severity, or API owner."
}

claims · history

{
  "claim_id": "history",
  "limits": "",
  "method": "Use catalogue presence and history boundaries.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "The locked catalogue records 22010 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#L179"
}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:29bbde396a61a1d209bcfb626a91f1c6a943d84f6be65d4f4fe269bcda8d6ba2

Text language: en · english-manuals:29bbde396a61a1d209bcfb626a91f1c6a943d84f6be65d4f4fe269bcda8d6ba2