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

HV024

Read PG 18 manual ↗

fdw_invalid_attribute_value

SQLSTATE
HV024
Condition name
fdw_invalid_attribute_value
Class
Foreign Data Wrapper Error (SQL/MED)
Source macro
ERRCODE_FDW_INVALID_ATTRIBUTE_VALUE
Evidence
Definition only
Analysis & operational context

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

<h1>HV024 — fdw_invalid_attribute_value</h1>

At a glance

HV024 identifies an attribute value that an FDW boundary rejects. No resolved HV024 report group was found in the locked PostgreSQL 18.6 core/contrib call scan, so no particular attribute or message is confirmed.

Meaning

An attribute may be a wrapper option, descriptor property, column or connection attribute, depending on the implementation. The SQLSTATE definition does not provide the accepted value set or identify whether validation is local or remote.

Messages and diagnostics

No resolved 18.6 core/contrib message variant was found. Preserve the exact attribute name and value as rendered, operation phase, wrapper/driver version, foreign server/table, and any detail or hint.

Diagnosis

Locate the wrapper or driver validator named by the diagnostic and compare the value with that version's documented or source-defined domain. Distinguish an invalid value from an unknown attribute name (HV00D may be relevant only when the actual SQLSTATE is HV00D).

Response

Use a value accepted by the identified validator, or change the object/remote definition that supplies it. Do not broaden the value or retry unchanged until the validator's supported domain is known.

Versions

HV024 is present in the locked definition snapshots from 9.1.24 through 18.6 and 19 Beta 3, with known_present_by 9.1.0. The available pre-9 definition material does not establish an exact introduction release.

Sources

  • errcodes.txt — definition, SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.
  • fdwapi.h — generic FDW callback boundary.
  • Structured evidence — fixed 18.6 sources and bounded 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.

HV024 is fdw_invalid_attribute_value in SQL/MED Class HV.

Method: Read the fixed errcodes definition row and macro.

src.errcodes.18.6

The condition name identifies an invalid attribute value at an FDW boundary. The attribute domain and validator remain implementation-specific.

Method: Read the fixed FDW callback signatures and FdwRoutine structure.

Limits: Generic API context is background only and does not prove an emitting path for this SQLSTATE.

src.fdwapi.18.6

No resolved HV024 report group was found in the locked PostgreSQL 18.6 core/contrib call scan.

Method: Compare resolved report groups with the fixed macro mapping.

Limits: This scan does not cover external wrappers, drivers, remote systems, or user callbacks; absence from the scan is not an absolute absence claim.

src.calls.REL_18_6 src.errcodes.18.6

The locked release definition snapshots establish presence from the known 9.1.0 boundary; the available pre-9 material does not establish an exact introduction release.

Method: Compare the canonical release-definition facts with the available pre-9 source boundary.

Limits: Definition presence does not prove runtime use.

src.errcodes.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:2984f4fa529edafcc8fd0406e7b… · English manual source