22002 — null_value_no_indicator_parameter

22002 is nullvaluenoindicatorparameter, an ECPG-oriented condition. 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

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: null_value_no_indicator_parameter
lang: en
sqlstate: 22002

Definition PG 18

22002

At a glance {#at-a-glance}

22002 is null_value_no_indicator_parameter, an ECPG-oriented condition. The fixed 18.6 call archive has no resolved native report group in this scan.

Meaning {#meaning}

22002 is null_value_no_indicator_parameter, an ECPG-oriented condition. 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 call scan. runtime_verification is not_run; a client or ECPG implementation that reports this code must supply its own exact diagnostic context.

Diagnosis {#diagnosis}

Locate the ECPG/preprocessor or client path that selected 22002 and inspect its indicator-variable contract; do not infer it from a server column NULL alone.

Response {#response}

Supply the required indicator handling in the actual ECPG interface or correct the client binding. Keep this code separate from ordinary column NOT NULL and PL/pgSQL NULL conditions. No server transaction-recovery rule is inferred from this source-only page.

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": "22002 is null_value_no_indicator_parameter 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 native report group for 22002."
}

claims · meaning-boundary

{
  "claim_id": "meaning-boundary",
  "limits": "No fixed server message template was confirmed.",
  "method": "Compare the condition definition with the bounded emitter scan.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6",
    "src.calls.REL_18_6"
  ],
  "statement": "The condition name describes a NULL indicator-variable contract associated with embedded SQL/client handling; it is not evidence that a server column NULL alone should produce 22002."
}

claims · history

{
  "claim_id": "history",
  "limits": "",
  "method": "Use catalogue boundary.",
  "position": 3,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "The locked catalogue records 22002 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#L196"
}

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

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:9e0eded318fd83dd2ad3cdeaa7c828eb2675b039d533b565f2e369d212213a3a

Text language: en · english-manuals:9e0eded318fd83dd2ad3cdeaa7c828eb2675b039d533b565f2e369d212213a3a