HV00R — fdw_table_not_found

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.

English manual coverage begins with PostgreSQL 8.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

aliases: Unknown
class name: Foreign Data Wrapper Error (SQL/MED)
condition name: fdw_table_not_found
lang: en
sqlstate: HV00R

Definition PG 18

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.

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 concerns inconsistent descriptor information; HV010 concerns FDW function sequencing; HV00Q is a concrete postgres_fdw remote-schema condition.

Sources {#sources}

errcodes.txt — definition, SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.
fdwapi.h — generic FDW callback boundary.
Structured evidence — fixed 18.6 sources and bounded scan.

Compare versions

SQLSTATE evidence and recorded runtime versions

claims · identity

{
  "claim_id": "identity",
  "limits": "",
  "method": "Read the fixed errcodes definition row and macro.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "HV00R is fdw_table_not_found in SQL/MED Class HV."
}

claims · api-boundary

{
  "claim_id": "api-boundary",
  "limits": "Generic API context is background only and does not prove an emitting path for this SQLSTATE.",
  "method": "Read the fixed FDW callback signatures and FdwRoutine structure.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.fdwapi.18.6"
  ],
  "statement": "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."
}

claims · scan-boundary

{
  "claim_id": "scan-boundary",
  "limits": "This scan does not cover external wrappers, drivers, remote systems, or user callbacks; absence from the scan is not an absolute absence claim.",
  "method": "Compare resolved report groups with the fixed macro mapping.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.calls.REL_18_6",
    "src.errcodes.18.6"
  ],
  "statement": "No resolved HV00R report group was found in the locked PostgreSQL 18.6 core/contrib call scan."
}

claims · history-boundary

{
  "claim_id": "history-boundary",
  "limits": "Definition presence does not prove runtime use.",
  "method": "Compare the canonical release-definition facts with the available pre-9 source boundary.",
  "position": 3,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "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."
}

sources · src.errcodes.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/utils/errcodes.txt",
  "position": 0,
  "sha256": "6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba",
  "source_id": "src.errcodes.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/errcodes.txt"
}

sources · src.fdwapi.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/include/foreign/fdwapi.h",
  "position": 1,
  "sha256": "572ba892e6435ca92d3b3bc84dde5bbd3160cc3a082693daab8daa835c4d2cd7",
  "source_id": "src.fdwapi.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/include/foreign/fdwapi.h"
}

sources · src.calls.REL_18_6

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_18_6.jsonl",
  "position": 2,
  "sha256": "9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf",
  "source_id": "src.calls.REL_18_6",
  "tag": "",
  "url": ""
}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:7319b060f22fd6f6a15dc67e1f23a682a5296fca649686532637916be2bc047e

Text language: en · english-manuals:7319b060f22fd6f6a15dc67e1f23a682a5296fca649686532637916be2bc047e