22027 — trim_error
The trim operation rejected its argument or trim specification. No fixed PostgreSQL 18.6 emitting path was resolved in the bounded 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
- aliases
- Unknown
- class name
- Data Exception
- condition name
- trim_error
- lang
- en
- sqlstate
- 22027
Definition PG 18
22027
At a glance {#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 {#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 {#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 {#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 {#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.
Related {#related}
Sources {#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.
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": "22027 is trim_error in SQLSTATE Class 22."
}claims · bounded-source-scope
{
"claim_id": "bounded-source-scope",
"limits": "A bounded scan does not prove no extension or historical path exists.",
"method": "Retain definition evidence without inventing an emitter.",
"position": 1,
"runtime": [],
"sources": [
"src.errcodes.18.6"
],
"statement": "No fixed PostgreSQL 18.6 emitting path was resolved for 22027 in the bounded scan."
}claims · history
{
"claim_id": "history",
"limits": "",
"method": "Use catalogue boundary.",
"position": 2,
"runtime": [],
"sources": [
"src.errcodes.18.6"
],
"statement": "The locked catalogue records 22027 from 7.4 without proving exact implementation introduction."
}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#L202"
}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · english-manuals:3572a7faf27861b97989bcf6e7b9902b86ca68f681b5b83f0fa0ea3107f875d7
Text language: en · english-manuals:3572a7faf27861b97989bcf6e7b9902b86ca68f681b5b83f0fa0ea3107f875d7