HV00R
Read PG 18 manual ↗fdw_table_not_found
- SQLSTATE
- HV00R
- Condition name
- fdw_table_not_found
- Class
- Foreign Data Wrapper Error (SQL/MED)
- Source macro
- ERRCODE_FDW_TABLE_NOT_FOUND
- Evidence
- Definition only
English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗
At a glance
HV00R identifies a table-not-found condition in the FDW class. The locked PostgreSQL 18.6 core/contrib call scan has no resolved HV00R report group, so it does not identify a core emitter, remote catalog, or message template.
Meaning
The condition name points to a table lookup that an FDW operation could not satisfy. That table might be a remote object, a wrapper-side mapping, or another implementation-owned name; the SQLSTATE definition does not choose among them.
Messages and diagnostics
No resolved 18.6 core/contrib message variant was found for HV00R. Preserve the complete diagnostic, wrapper and driver versions, foreign server/table identity, operation phase, and any remote message before interpreting the condition.
Diagnosis
Locate the installed wrapper's table lookup and its SQLSTATE mapping. Check the exact foreign table or remote relation name, database/schema context, mapped user, and whether the failure occurred during planning, execution, or metadata discovery. Do not assume that every zero-row query means this condition.
Response
Correct the table or mapping identified by the wrapper, or use the remote object and server that the operation actually names. If the wrapper cannot establish whether a preceding write completed, inspect remote state before repeating it; changing an unrelated FDW option will not explain the condition.
Versions
HV00R 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-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.
HV00R is fdw_table_not_found in SQL/MED Class HV.
Method: Read the fixed errcodes definition row and macro.
The condition name identifies an FDW table-not-found state, but the fixed scan does not identify whether the table name is remote, mapped, or wrapper-owned.
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 HV00R 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:31fc82ecc526c667316cf95772f… · English manual source