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

HV00N

fdw_unable_to_establish_connection

SQLSTATE: HV00N
Condition name: fdw_unable_to_establish_connection
Class: Foreign Data Wrapper Error (SQL/MED)
Source macro: ERRCODE_FDW_UNABLE_TO_ESTABLISH_CONNECTION
Evidence: Definition only

Analysis & operational context

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

<h1>HV00N — fdw_unable_to_establish_connection</h1>

At a glance

HV00N is the SQL/MED condition for an FDW unable to establish its connection. No direct 18.6 core/contrib HV00N report group was resolved. Do not use the condition name to choose between DNS, authentication, TLS, network, or remote-server causes.

Meaning

The condition name describes a wrapper connection-setup boundary. postgres_fdw and dblink have their own concrete connection and libpq paths, but the 18.6 paths in this batch use other SQLSTATEs; they are not evidence for HV00N.

Messages and diagnostics

No fixed core message is confirmed. Preserve wrapper/driver version, foreign server and user mapping, connection parameters (excluding secrets), local and remote logs, and whether authentication or transport was reached.

Diagnosis

Locate the wrapper's connection function and classify the first failing layer: name resolution, socket/TLS, authentication, protocol negotiation, or remote admission. Compare the wrapper's SQLSTATE with any driver or remote code; they can differ.

Response

Correct the identified endpoint, credentials, network/TLS configuration, or server admission rule, then establish a fresh connection using the wrapper's API. For writes, do not replay an operation until logs show whether a prior connection reached the remote command stage.

Versions

The code is in locked definitions from 9.1.0 through 18.6 and 19 Beta 3; available pre-9 definitions do not contain it. Exact implementation introduction is unknown.

Sources

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

Source evidence

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

HV00N is fdw_unable_to_establish_connection in SQL/MED Class HV.

Method: Read the fixed definition row and macro.

src.errcodes.18.6

No direct HV00N 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 generic FDW API boundary does not identify an emitter for this SQLSTATE. The scan does not cover external wrappers, drivers, remote systems, or user callbacks.

src.calls.REL_18_6 src.fdwapi.18.6

src/backend/utils/errcodes.txt · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7
src/include/foreign/fdwapi.h · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7
raw/calls/REL_18_6.jsonl · ·

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

PG 9.0 → 9.1added

Definition snapshot: english-manuals:3fec2c81730e8e6f86a25be02b3… · English manual source