↑↓ select ↵ open ⌫ change scope Open full search

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

SQLSTATE / CLASS 22 · DATA EXCEPTION

22010

Read PG 18 manual ↗

invalid_indicator_parameter_value

SQLSTATE
22010
Condition name
invalid_indicator_parameter_value
Class
Data Exception
Source macro
ERRCODE_INVALID_INDICATOR_PARAMETER_VALUE
Evidence
Definition only
Analysis & operational context

English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗

At a glance

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.

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

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

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

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.

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.

Source evidence

Evidence belongs to the frozen source and runtime versions listed here. It is not a runtime verification of the selected manual version.

22010 is invalid_indicator_parameter_value in SQLSTATE Class 22.

Method: Read the fixed errcodes row and macro.

src.errcodes.18.6

The bounded PostgreSQL 18.6 source review does not bind 22010 to a native emitter, primary template, severity, or API owner.

Method: Keep the catalogue definition separate from an unresolved emitter search.

Limits: A client/API or extension may own the diagnostic; no emitter is asserted here.

src.errcodes.18.6

The locked catalogue records 22010 from 7.4 without proving an exact implementation introduction date.

Method: Use catalogue presence and history boundaries.

src.errcodes.18.6

Message templates

No extracted message template is attached to this condition.

Reproduction & repair cases

No reproduction case is attached to this condition.

Recorded runtime evidence

No runtime observation is attached to this entry.

Definition snapshot: english-manuals:c1674fb90151c8a1fb94f5a9424… · English manual source