SQLSTATE HV00A ERROR Class HV: Foreign Data Wrapper Error (SQL/MED)

fdw_invalid_string_format Fdw Invalid String Format — SQLSTATE HV00A

SQLSTATE HV00A (fdw_invalid_string_format): A foreign data wrapper (SQL/MED) operation failed.

PG 12, 13, 14, 15, 16, 17, 18 Official docs
Last reviewed May 2025 Grounded in source

Symptoms

The server reports SQLSTATE HV00A (fdw_invalid_string_format), a condition in the Foreign Data Wrapper Error (SQL/MED) class.

  • The error is written to the server log and returned to the client carrying SQLSTATE HV00A.
  • Any driver (libpq, JDBC, psycopg, npgsql, pgx) surfaces this code in its error object so you can branch on it programmatically.
  • PL/pgSQL can trap it by name: EXCEPTION WHEN fdw_invalid_string_format THEN.

Environment

Severity: ERROR  |  PostgreSQL versions: 12, 13, 14, 15, 16, 17

Reproduce with the exact statement and read the full message in the server log (raise log_min_messages / set log_min_error_statement for more context).

Root Cause

HV00A belongs to Class HV — Foreign Data Wrapper Error (SQL/MED). In this class, a foreign data wrapper (SQL/MED) operation failed.

The first two characters (HV) identify the error class, so application code can match the whole class via HV000 when the specific code is not needed.

Diagnostic Queries

Recovery

Check the foreign server connection and options, credentials in the user mapping, and that the remote object exists and is reachable.

Reference: PostgreSQL error codes — Class HV (Foreign Data Wrapper Error (SQL/MED)).

Was this helpful?