22027
Read PG 18 manual ↗trim_error
- SQLSTATE
- 22027
- Condition name
- trim_error
- Class
- Data Exception
- Source macro
- ERRCODE_TRIM_ERROR
- Evidence
- Definition only
English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗
At a glance
The trim operation rejected its argument or trim specification. No fixed PostgreSQL 18.6 emitting path was resolved in the bounded scan.
Meaning
The locked definition names trim_error, but the bounded PostgreSQL 18.6 source review did not resolve a native emitter for 22027. This page therefore records the condition identity and diagnostic boundary without assigning a particular SQL trim function, whitespace rule, or primary message.
Diagnosis
If a deployment reports 22027, preserve the complete primary, DETAIL, and HINT together with the invoking function or extension. The condition name alone cannot tell whether the rejected input is the source string, trim set, direction, or a consumer-specific option; do not substitute a guessed whitespace rule.
Response
Use the actual emitter’s diagnostic to correct the trim input or operation. If the source is an extension or a version-specific path, check that implementation’s documented argument rules. If an ERROR occurred in an explicit transaction, roll back or roll back to the existing savepoint before retrying; autocommit can retry the corrected action.
Versions
The locked catalogue records this condition from 7.4. Only the PostgreSQL 18.6 definition row is fixed here; no native emitting path or natural runtime observation is claimed.
Sources
The fixed definition row is src/backend/utils/errcodes.txt#L202. The bounded source review did not resolve a native 22027 emitter; the structured evidence record keeps that unknown scope explicit, and 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.
No fixed PostgreSQL 18.6 emitting path was resolved for 22027 in the bounded scan.
Method: Retain definition evidence without inventing an emitter.
Limits: A bounded scan does not prove no extension or historical path exists.
The locked catalogue records 22027 from 7.4 without proving exact implementation introduction.
Method: Use catalogue boundary.
- src/backend/utils/errcodes.txt · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7
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:84333655b2a2a0e70caffe73163… · English manual source