↑↓ select ↵ open ⌫ change scope Open full search

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

SQLSTATE / CLASS 01 · WARNING

01004

Read PG 18 manual ↗

string_data_right_truncation

SQLSTATE
01004
Condition name
string_data_right_truncation
Class
Warning
Source macro
ERRCODE_WARNING_STRING_DATA_RIGHT_TRUNCATION
Evidence
Definition only
Analysis & operational context

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

<h1>01004 — string_data_right_truncation</h1>

At a glance

01004 names right truncation reported as a warning condition. No resolved 18.6 core/contrib report group was found, so this page does not assign a particular cast, encoding path, client, or message.

Meaning

The definition names right truncation as a warning condition. Without a resolved call group, the accepted truncation behavior, data preservation, and producer remain unknown.

Messages and diagnostics

No resolved 18.6 message variant was found. Preserve the exact value/column context, declared and received lengths when available, encoding, producer version, and complete diagnostics.

Diagnosis

Locate the source that emitted the code and compare its length and encoding rules with the value being transferred. Distinguish a warning that preserves a truncated value from an error that rejects the statement; the SQLSTATE alone does not decide that behavior.

Response

Use the producer's supported length or encoding adjustment and verify whether data was intentionally truncated. Do not silently retry the same input when information may already have been lost.

Versions

01004 is present from the locked 9.0.23 snapshot through 18.6 and 19 Beta 3, with known_present_by 7.4. The available evidence establishes catalogue presence, not a current core emission path.

Sources

  • errcodes.txt — definition, SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.
  • Structured evidence — fixed sources, message groups, and runtime 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.

01004 is string_data_right_truncation in SQLSTATE Class 01.

Method: Read the fixed errcodes definition row and macro.

src.errcodes.18.6

No resolved 01004 report group was found in the locked PostgreSQL 18.6 core/contrib call scan.

Method: Compare resolved report groups with the fixed macro mapping.

Limits: This scan does not cover external clients, drivers, extensions, remote systems, or other implementations; absence from the scan is not an absolute absence claim.

src.calls.REL_18_6 src.errcodes.18.6

The locked release definitions establish catalogue presence, not a precise introducing release or runtime use.

Method: Compare the canonical release-definition facts with the available history boundary.

Limits: Definition presence is not an emitting-path observation.

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:1884c3cff1f015adb468832ef39… · English manual source