↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / SQLSTATE

HV00C — fdw_invalid_option_index

HV00C identifies an option index that is invalid for the FDW option collection in use. No direct HV00C report group was resolved in the PostgreSQL 18.6 core/contrib scan, so no specific option array or message is attributed.

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

aliases
Unknown
class name
Foreign Data Wrapper Error (SQL/MED)
condition name
fdw_invalid_option_index
lang
en
sqlstate
HV00C

Definition PG 18

HV00C — fdw_invalid_option_index

At a glance {#at-a-glance}

HV00C identifies an option index that is invalid for the FDW option collection in use. No direct HV00C report group was resolved in the PostgreSQL 18.6 core/contrib scan, so no specific option array or message is attributed.

Meaning {#meaning}

This condition concerns an ordinal into a wrapper's option representation. It is different from HV00D, where the option name is rejected, and from HV00J, whose name says the option was not found in dblink's option set.

Messages and diagnostics {#messages}

No fixed 18.6 message is confirmed. Preserve the option index, option scope (wrapper/server/table/user mapping), wrapper version, and callback or validation phase.

Diagnosis {#diagnosis}

Read the installed wrapper's option enumeration and the code that consumes the index. Check stale cached metadata, an extension/server ABI mismatch, and whether an option list was reordered between planning and execution. Do not treat a SQL option spelling error as an index error without the wrapper source.

Response {#response}

Refresh or rebuild the wrapper-owned option list and use the option API expected by that wrapper. Correct a stale extension or mapping before retrying; changing an unrelated FDW option does not repair an invalid index.

Versions {#versions}

The catalogue observes HV00C from 9.1.0 through 18.6 and in 19 Beta 3. It was not observed in the available pre-9 definition files.

Related {#related}

HV00D is an invalid option name; HV00J is dblink's option-name-not-found condition; HV008 is an invalid foreign-column number.

Sources {#sources}

Compare versions

SQLSTATE evidence and recorded runtime versions

claims · identity
{
  "claim_id": "identity",
  "limits": "",
  "method": "Read the fixed definition row and macro.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "HV00C is fdw_invalid_option_index in SQL/MED Class HV."
}
claims · scan-boundary
{
  "claim_id": "scan-boundary",
  "limits": "The generic FDW API boundary does not identify an emitter for this SQLSTATE. The scan does not cover external wrappers, drivers, remote systems, or user callbacks.",
  "method": "Compare resolved report groups with the macro mapping.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.calls.REL_18_6",
    "src.fdwapi.18.6"
  ],
  "statement": "No direct HV00C report group was resolved in the locked PostgreSQL 18.6 core/contrib call scan."
}
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

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:d90cae1a60ef5f31be306b1e52fe5d14a069555b0c64bc33af26cf0c3c218d89

Text language: en · english-manuals:d90cae1a60ef5f31be306b1e52fe5d14a069555b0c64bc33af26cf0c3c218d89