select open change scope Open full search

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

SQLSTATE / CLASS HV · FOREIGN DATA WRAPPER ERROR (SQL/MED)

fdw_invalid_string_format

SQLSTATE
HV00A
Condition name
fdw_invalid_string_format
Class
Foreign Data Wrapper Error (SQL/MED)
Source macro
ERRCODE_FDW_INVALID_STRING_FORMAT
Evidence
Definition only
Analysis & operational context

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

<h1>HV00A — fdw_invalid_string_format</h1>

At a glance

HV00A is the SQL/MED condition for an invalid string format at an FDW boundary. PostgreSQL 18.6's core/contrib call scan found no resolved direct report group, so the format grammar and message must come from the installed wrapper or remote driver.

Meaning

The wrapper rejected a string because its syntax, escaping, encoding, or format fields do not satisfy the wrapper contract. The condition does not identify whether the string was an option, a remote identifier, a serialized value, or a driver response.

Messages and diagnostics

No fixed core message is confirmed. Keep the operation, option or field name, original encoding/quoting, wrapper version, and any remote diagnostic. Do not rewrite the string based only on the condition name.

Diagnosis

Locate the wrapper's parser or conversion function and compare the exact input with its pinned grammar. Check server encoding and escaping only where that wrapper documents them. Distinguish a malformed FDW option from a remote SQL syntax error and from a value-format condition in Class 22.

Response

Correct the string according to the wrapper's documented format, or use its structured option/API instead of hand-built text. Recreate the plan or foreign-table metadata after the change; retrying the unchanged string will reproduce the same validation result.

Versions

HV00A is present in the locked catalogue from 9.1.0 through 18.6 and in 19 Beta 3. It was not observed in the available pre-9 definition files; exact introduction remains unknown.

Sources

Source evidence

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

HV00A is fdw_invalid_string_format in Class HV.

Method: Read the fixed definition row.

src.errcodes.18.6

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

Method: Compare resolved report groups with the macro mapping.

Limits: The rejected string field and grammar belong to the installed wrapper or remote driver. Generic API context and the absent resolved report group do not establish a source path emitting this SQLSTATE.

src.calls.REL_18_6 src.fdwapi.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.

Version history 1
  1. PG 9.0 → 9.1added

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