HV005 — fdw_column_name_not_found

At a glance {#at-a-glance}

HV005 is the SQL/MED condition for a foreign column name that the wrapper cannot find in the relevant remote or imported descriptor. No direct HV005 report group was resolved in the PostgreSQL 18.6 core/contrib scan, so the concrete remote system and message remain wrapper-specific.

Meaning and scope {#meaning}

This code concerns name lookup at an FDW boundary: an imported or planned column name is absent from the descriptor the wrapper is using. It is narrower than a missing foreign table and different from a local 42703 undefined column.

Messages and diagnostics {#messages}

No fixed core message is available. Preserve the exact name, case-folding/quoting context, foreign table or remote relation, wrapper version, and whether the failure occurred during import, planning, scan, or modification.

Diagnosis {#diagnosis}

Compare pg_attribute for the foreign table with the wrapper's remote metadata and name-translation rules. Re-run schema discovery or inspect the wrapper's import mapping where applicable. Do not infer a remote column simply from the local target list.

Response {#response}

Correct the foreign-table column definition or the wrapper's name mapping, then refresh the remote schema metadata as its documentation requires. Retry after the descriptor agrees; changing transaction retry policy cannot create a missing column.

Versions {#versions}

HV005 is observed from 9.1.0 through 18.6 and the 19 Beta 3 preview. Pre-9 definition files in the locked scan did not contain it, so the precise introduction is unknown.

Related {#related}

HV007 concerns an invalid column name supplied to a descriptor API; HV008 concerns an invalid ordinal. 42703 is PostgreSQL's local undefined-column condition.

Sources {#sources}

• errcodes.txt — definition, SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.
• FDW callback API — descriptor-consuming callback boundary.
• Structured evidence — bounded scan and source boundary.