HV00J
Read PG 18 manual ↗fdw_option_name_not_found
- SQLSTATE
- HV00J
- Condition name
- fdw_option_name_not_found
- Class
- Foreign Data Wrapper Error (SQL/MED)
- Source macro
- ERRCODE_FDW_OPTION_NAME_NOT_FOUND
- Evidence
- Source path confirmed
English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗
At a glance
HV00J is used by dblink's connection-option validation when an option name is not in the accepted dblink/libpq option set. dblink is a separate contrib client API, not an FDW callback implementation. The 18.6 core/contrib scan found no other resolved HV00J group.
Meaning and messages
At dblink.c:2005-2011, dblink reports ERROR with invalid option "%s". It adds Perhaps you meant the option "%s". only when a close match is available; 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. A fixed REL9_6_24 dblink snapshot shows the older dynamic Valid options in this context are: %s hint; this is a bounded comparison, not an exact transition claim.
Diagnosis
Identify whether the option belongs to a dblink connection string/option list and check the installed libpq option names. Keep the exact option name, dblink/libpq versions, and whether the failure occurred while parsing a connection definition. Do not apply postgres_fdw option tables to dblink.
Response
Replace the name with the accepted dblink/libpq option or remove it, preserving the close-match hint as a guide. Validate the connection definition again; an invalid option name is deterministic and does not call for a database transaction retry.
Diagnosis boundary
The confirmed implementation is dblink's option parser at contrib/dblink/dblink.c:2005-2011; no natural runtime was run in this batch, and the source does not establish remote connection success or failure.
Versions
The code is present from 9.1.0 through 18.6 and 19 Beta 3. The fixed 18.6 and REL9_6_24 dblink snapshots show different hint wording; they bound the observed versions without dating the transition. Match the installed version when interpreting a log.
Sources
errcodes.txt— definition, SHA-2566e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.- dblink.c — 18.6 dblink option parser.
- dblink.c in REL9_6_24 — bounded historical hint comparison; SHA-256 ff331aac2153e21aa88cc6c4e656ab00b0593744062270849f27281434db3b55.
- Structured evidence — exact message/detail/hint grouping.
Source evidence
Evidence belongs to the frozen source and runtime versions listed here. It is not a runtime verification of the selected manual version.
HV00J is fdw_option_name_not_found in SQL/MED Class HV.
Method: Read the fixed definition row and macro.
dblink uses HV00J in its own connection-option parser; dblink is a separate contrib client API rather than an FDW callback implementation.
Method: Read the fixed option-validation branch.
The fixed REL9_6_24 dblink option parser uses 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 dblink.c error branch at lines 2017-2021.
Limits: This fixed snapshot establishes dblink's wording there; it does not date the transition or generalize to other clients.
- src/backend/utils/errcodes.txt · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7 - contrib/dblink/dblink.c · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7 - contrib/dblink/dblink.c · REL9_6_24 ·
a4116b8d5a4f68803452d8f1aa3f74f302049a90 raw/calls/REL_18_6.jsonl· ·
Message templates
ERROR · contrib/dblink/dblink.c:2005-2011
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/dblink/dblink.c:2017-2021
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:81e537b1e40eebea435e4f2688d… · English manual source