EC
HV00Q
PostgreSQLERRORNotableForeign Data Wrapper ErrorHIGH confidence

fdw_option_name_not_found

Production Risk

Low — DDL fails; no data is affected.

What this means

A foreign data wrapper option name referenced in CREATE SERVER, CREATE USER MAPPING, or CREATE FOREIGN TABLE was not recognised by the FDW.

Why it happens
  1. 1Typo in option name passed to CREATE SERVER / ALTER SERVER.
  2. 2Option is not supported by the installed FDW version.
  3. 3Option applies to a different object type (e.g. table option used on server).
How to reproduce
trigger — this will error
trigger — this will error
CREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw
  OPTIONS (hoost 'remotehost', port '5432', dbname 'mydb');  -- typo: hoost

expected output

ERROR:  HV00Q: fdw_option_name_not_found

Fix 1

Correct the option name

Correct the option name
CREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw
  OPTIONS (host 'remotehost', port '5432', dbname 'mydb');

Why this works

Uses the correct option name accepted by the FDW.

Fix 2

Check supported options in the FDW documentation

Check supported options in the FDW documentation
SELECT * FROM pg_options_to_table((
  SELECT srvoptions FROM pg_foreign_server WHERE srvname = 'myserver'
));

Why this works

Lists the options already set, helping identify which names are valid.

Sources
Official documentation ↗

PostgreSQL 17 — HV00Q fdw_option_name_not_found

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All PostgreSQL errors