select open change scope Open full search

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

SQLSTATE / CLASS 22 · DATA EXCEPTION

indicator_overflow

SQLSTATE
22022
Condition name
indicator_overflow
Class
Data Exception
Source macro
ERRCODE_INDICATOR_OVERFLOW
Evidence
Definition only
Analysis & operational context

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

<h1>22022</h1>

At a glance

The catalogue condition names an indicator value that cannot fit its interface representation. The bounded PostgreSQL 18.6 source review confirms the definition but does not bind a native emitting report group.

Meaning

22022 is an interface-level indicator-overflow condition, but the fixed source scope here does not identify which client or API owns an emitter. Its condition name must not be turned into an invented ECPG, ordinary SQL cast, or server-column path.

Diagnosis

Use the complete diagnostic and owning interface to determine the indicator type, storage width, and value range. Without a confirmed emitter, this page cannot assign a primary message, severity behavior, transaction effect, or universal server-side repair.

Response

Inspect the actual interface contract and choose an indicator representation that can hold the returned value, following that interface’s documented recovery. Treat this as bounded unknown source coverage rather than applying a generic numeric-overflow fix.

Versions

The locked catalogue records this condition from 7.4; only the PostgreSQL 18.6 definition and bounded source scope are confirmed. No natural runtime observation is claimed for this page.

Sources

The fixed catalogue definition is recorded in the structured evidence record. Its bounded-scan claim deliberately leaves the native emitter, primary text, severity, and transaction behavior unknown; no natural runtime was run.

Source evidence

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

22022 is indicator_overflow in SQLSTATE Class 22.

Method: Read the fixed errcodes row and macro.

src.errcodes.18.6

No fixed PostgreSQL 18.6 emitting report group was resolved for 22022 in the bounded source review.

Method: Retain definition evidence without inventing an ECPG, SQL cast, or server-column emitter.

Limits: A bounded scan does not prove that no extension, client, or historical path exists.

src.errcodes.18.6

The locked catalogue records 22022 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:c530670c73bbcdb0bd387efa05e… · English manual source