HV00D
Read PG 18 manual ↗fdw_invalid_option_name
- SQLSTATE
- HV00D
- Condition name
- fdw_invalid_option_name
- Class
- Foreign Data Wrapper Error (SQL/MED)
- Source macro
- ERRCODE_FDW_INVALID_OPTION_NAME
- Evidence
- Source path confirmed
English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗
At a glance
HV00D is raised when an FDW option name is not valid in the current wrapper context. PostgreSQL 18.6 has direct paths in file_fdw, postgres_fdw, and the postgres_fdw import option parser.
Meaning and messages
The option is checked against the wrapper's valid options for its context: FDW, server, foreign table, user mapping, or import. The 18.6 primary template is invalid option "%s". file_fdw and postgres_fdw/option.c add Perhaps you meant the option "%s". only when a close match exists; if valid options exist but no close match is found, the source emits no hint, and There are no valid options in this context. is used only when no valid option exists. The postgres_fdw import parser has only the primary message.
Diagnosis
Record the object being altered and the wrapper version, then read that wrapper's validator and option list. Check whether an option belongs on the foreign server, foreign table, or user mapping; identical names can be valid in one scope and invalid in another. Preserve the hint's close match instead of guessing from a different wrapper.
Response
Use the option name and scope accepted by the installed wrapper, or remove the unsupported option. If the option was introduced by a newer extension, align the extension and server versions after confirming that is the cause. Retrying the same definition cannot change validation.
Messages and diagnostics
The fixed 18.6 call groups are file_fdw/file_fdw.c:248-253, postgres_fdw/option.c:110-116, and postgres_fdw/postgres_fdw.c:5491-5493; all are ERROR. Their %s values are dynamic option names and close matches.
Versions
HV00D is present from 9.1.0 through 18.6 and 19 Beta 3. A fixed REL9_6_24 snapshot of the file_fdw and postgres_fdw validators uses the older Valid options in this context are: %s hint, while the fixed 18.6 paths use the closest-match/no-valid-options branches. These two snapshots bound the wording; they do not establish the exact transition release, so match the installed version when comparing logs.
Sources
errcodes.txt— definition, SHA-2566e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.- file_fdw.c, postgres_fdw/option.c, postgres_fdw.c — 18.6 validators.
- file_fdw.c in REL9_6_24 and postgres_fdw/option.c in REL9_6_24 — bounded historical hint comparison; SHA-256 1745225d449f44e9b384e372e8e13d5f5fe141e53d49526760fc1df8a1bf6211 and d7da1cf22cd61619ef2f0cb7ce1a741d4ecb9a03636766e097e2183acdf21d48.
- Structured evidence — exact message roles and source hashes.
Source evidence
Evidence belongs to the frozen source and runtime versions listed here. It is not a runtime verification of the selected manual version.
HV00D is fdw_invalid_option_name in SQL/MED Class HV.
Method: Read the fixed definition row and macro.
file_fdw and postgres_fdw validate option names in their object-specific contexts; the postgres_fdw import parser uses the same condition for an invalid import option.
Method: Read each fixed error branch and its option context.
src.file_fdw.18.6 src.postgres_fdw.option.18.6 src.postgres_fdw.main.18.6
Fixed REL9_6_24 snapshots of file_fdw and postgres_fdw/option.c use the older dynamic hint 'Valid options in this context are: %s' with the same invalid-option ERROR; this is a bounded snapshot comparison, not an exact transition release.
Method: Read the fixed REL9_6_24 error branches at file_fdw.c:240-246 and postgres_fdw/option.c:99-103.
Limits: The two fixed wrapper snapshots establish their own wording only; they do not date the transition or describe every wrapper.
- src/backend/utils/errcodes.txt · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7 - contrib/file_fdw/file_fdw.c · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7 - contrib/postgres_fdw/option.c · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7 - contrib/postgres_fdw/postgres_fdw.c · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7 - contrib/file_fdw/file_fdw.c · REL9_6_24 ·
a4116b8d5a4f68803452d8f1aa3f74f302049a90 - contrib/postgres_fdw/option.c · REL9_6_24 ·
a4116b8d5a4f68803452d8f1aa3f74f302049a90 raw/calls/REL_18_6.jsonl· ·
Message templates
ERROR · contrib/file_fdw/file_fdw.c:247-253
Hint
Perhaps you meant the option "%s".
Hint
There are no valid options in this context.
Primary
invalid option "%s"
When valid options exist but no close match is found, the source emits no hint; the no-valid-options hint is only used when no valid option exists.
ERROR · contrib/postgres_fdw/option.c:110-116
Hint
Perhaps you meant the option "%s".
Hint
There are no valid options in this context.
Primary
invalid option "%s"
When valid options exist but no close match is found, the source emits no hint; the no-valid-options hint is only used when no valid option exists.
ERROR · contrib/postgres_fdw/postgres_fdw.c:5491-5493
Primary
invalid option "%s"
This import-option parser has only the primary message in the fixed 18.6 path; it does not use the validator close-match or no-valid-options hint branches.
ERROR · contrib/file_fdw/file_fdw.c:240-246
Hint
Valid options in this context are: %s
Primary
invalid option "%s"
ERROR · contrib/postgres_fdw/option.c:99-103
Hint
Valid options in this context are: %s
Primary
invalid option "%s"
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:158edd4406efefc4b0795d61054… · English manual source