HV010
Read PG 18 manual ↗fdw_function_sequence_error
- SQLSTATE
- HV010
- Condition name
- fdw_function_sequence_error
- Class
- Foreign Data Wrapper Error (SQL/MED)
- Source macro
- ERRCODE_FDW_FUNCTION_SEQUENCE_ERROR
- Evidence
- Definition only
English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗
At a glance
HV010 indicates that an FDW function was called in an invalid sequence. The fixed 18.6 core/contrib call scan has no resolved HV010 report group, so it does not establish a native callback or message.
Meaning
The condition is about the order or lifecycle of wrapper operations. fdwapi.h defines callback entry points such as planning and foreign-scan callbacks, but that API background does not emit HV010 or define every wrapper's legal sequence.
Messages and diagnostics
No resolved 18.6 core/contrib message variant was found. Keep the complete message, callback name, operation phase, wrapper/driver version, and whether the call followed planning, scan start, iteration, rescan, modification, or cleanup.
Diagnosis
Trace the wrapper's state machine around the failing callback. Verify which object was initialized, whether the callback was repeated or skipped, and whether cleanup ran before a later call. Use the wrapper's own contract and source mapping to decide whether the reported sequence is local or remote.
Response
Restore the sequence required by the installed wrapper and its callback contract, then validate the same operation from a fresh object state. Avoid repeating a callback blindly: a wrapper may have already issued a remote request or released its state.
Versions
HV010 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 prove an exact introduction release.
Sources
errcodes.txt— definition, SHA-2566e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.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.
HV010 is fdw_function_sequence_error in SQL/MED Class HV.
Method: Read the fixed errcodes definition row and macro.
The condition name identifies an FDW function-sequence state. The generic callback API provides phase boundaries only; it does not establish a source path that emits HV010.
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.
No resolved HV010 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.
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/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:77eab0d8265a58167dab614599f… · English manual source