↑↓ 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)

HV006

Read PG 18 manual ↗

fdw_invalid_data_type_descriptors

SQLSTATE
HV006
Condition name
fdw_invalid_data_type_descriptors
Class
Foreign Data Wrapper Error (SQL/MED)
Source macro
ERRCODE_FDW_INVALID_DATA_TYPE_DESCRIPTORS
Evidence
Definition only
Analysis & operational context

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

<h1>HV006 — fdw_invalid_data_type_descriptors</h1>

At a glance

HV006 covers invalid data-type descriptor information at an FDW boundary. PostgreSQL 18.6 defines it but the core/contrib call scan resolved no direct report group, so no bundled wrapper message or natural SQL reproduction is claimed.

Meaning

The condition is about the descriptor metadata itself: a wrapper's type OID, length, precision, typmod, or related descriptor fields can be inconsistent with the callback contract. It is distinct from a single value that fails conversion (HV004).

Messages and diagnostics

No fixed core message was found. Record descriptor field names and values, local and remote relation identities, callback phase, wrapper version, and any remote metadata response. Do not manufacture a message from the condition name.

Diagnosis

Trace the descriptor from schema import/planning through tuple conversion. Inspect the wrapper source for the callback that builds or consumes it, then compare it with fdwapi.h and the wrapper's pinned documentation. A stale extension binary or changed remote schema is a more useful lead than a generic SQL retry.

Response

Refresh or correct the wrapper's descriptor construction and align the foreign-table metadata with the remote schema. If the issue follows an extension upgrade, test the matching wrapper/server ABI. Retry only after the descriptor is corrected.

Versions

The code is present in all locked formal snapshots from 9.1.24 through 18.6 and in 19 Beta 3; the earliest locked definition is 9.1.0. No pre-9 definition observation is available.

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.

HV006 is fdw_invalid_data_type_descriptors in Class HV.

Method: Read the fixed definition row.

src.errcodes.18.6

The locked 18.6 core/contrib scan has no direct HV006 report group; the API boundary is the available implementation context.

Method: Compare callback contract and resolved report groups.

Limits: Concrete descriptor fields belong to the installed wrapper. Generic API context and the absent resolved report group do not establish a source path emitting this SQLSTATE.

src.fdwapi.18.6 src.calls.REL_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:ef2ef995a4bbbe8bffe6cd41eb2… · English manual source