HV00A — fdw_invalid_string_format

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.

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

9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

aliases: Unknown
class name: Foreign Data Wrapper Error (SQL/MED)
condition name: fdw_invalid_string_format
lang: en
sqlstate: HV00A

Definition PG 18

HV00A — fdw_invalid_string_format

At a glance {#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 {#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 {#messages}

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 {#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 {#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 {#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.

Related {#related}

HV00D concerns an unrecognized option name; HV004 concerns a data-type mismatch. A core text/value format error may use a Class 22 code instead.

Sources {#sources}

errcodes.txt — definition, SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.
fdwapi.h — callback boundary.
Structured evidence — bounded scan and source boundary.

Compare versions

SQLSTATE evidence and recorded runtime versions

claims · identity

{
  "claim_id": "identity",
  "limits": "",
  "method": "Read the fixed definition row.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "HV00A is fdw_invalid_string_format in Class HV."
}

claims · scan-boundary

{
  "claim_id": "scan-boundary",
  "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.",
  "method": "Compare resolved report groups with the macro mapping.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.calls.REL_18_6",
    "src.fdwapi.18.6"
  ],
  "statement": "No direct HV00A report group was resolved in the locked PostgreSQL 18.6 core/contrib call scan."
}

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"
}

sources · src.fdwapi.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/include/foreign/fdwapi.h",
  "position": 1,
  "sha256": "572ba892e6435ca92d3b3bc84dde5bbd3160cc3a082693daab8daa835c4d2cd7",
  "source_id": "src.fdwapi.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/include/foreign/fdwapi.h"
}

sources · src.calls.REL_18_6

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_18_6.jsonl",
  "position": 2,
  "sha256": "9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf",
  "source_id": "src.calls.REL_18_6",
  "tag": "",
  "url": ""
}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:e0837b9e9628ea8a5b85b944adcf9f09387d6f4685fad24fe0f07fdc2873615f

Text language: en · english-manuals:e0837b9e9628ea8a5b85b944adcf9f09387d6f4685fad24fe0f07fdc2873615f