# HV00R — fdw_table_not_found

> PostgreSQL SQLSTATE HV00R names a table-not-found condition at an FDW boundary; the installed wrapper determines which table lookup and diagnostic are involved.
---

# HV00R — fdw_table_not_found

## At a glance {#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.

<!-- BEGIN SQLSTATE FACTS: generated by scripts/generate.py; do not edit -->

| Field | Value |
| --- | --- |
| SQLSTATE | `HV00R` |
| Condition | `fdw_table_not_found` |
| Status | `active` |
| Known present by | `9.1.0` |
| Locked snapshots | `9.1.24, 9.2.24, 9.3.25, 9.4.26, 9.5.25, 9.6.24, 10.23, 11.22, 12.22, 13.23, 14.24, 15.19, 16.15, 17.11, 18.6, 19beta3` |
| Macros | `ERRCODE_FDW_TABLE_NOT_FOUND` |
| Aliases | `—` |

<!-- source facts: data/errcodes/HV00R.json -->
<!-- END SQLSTATE FACTS -->

## Meaning {#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 {#messages}

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 {#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 {#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 {#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.

## Related {#related}

[`HV021`](../hv021/) concerns inconsistent descriptor information; [`HV010`](../hv010/) concerns FDW function sequencing; [`HV00Q`](../hv00q/) is a concrete postgres_fdw remote-schema condition.

## Sources {#sources}

- [`errcodes.txt`](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/errcodes.txt#L482) — definition, SHA-256 `6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba`.
- [`fdwapi.h`](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/include/foreign/fdwapi.h#L24-L55) — generic FDW callback boundary.
- [Structured evidence](../data/evidence/hv00r.json) — fixed 18.6 sources and bounded scan.