HV00D — fdw_invalid_option_name

当前上下文不接受该外部数据包装器选项名。

英文手册覆盖始于 PostgreSQL 8.1. 来源历史与运行验证各自保留独立版本边界。

当前阅读 PG 18·选择有来源记录的版本

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

aliases: 未知
class name: Foreign Data Wrapper Error (SQL/MED)
condition name: fdw_invalid_option_name
lang: en
sqlstate: HV00D

版本定义 PG 18

HV00D — fdw_invalid_option_name

速览 {#at-a-glance}

当 FDW 选项名称不符合当前包装器上下文时，会产生 HV00D。PostgreSQL 18.6 在 file_fdw、postgres_fdw 以及 postgres_fdw 的导入选项解析器中都有直接路径。

含义与消息 {#meaning}

包装器会按当前上下文检查选项：可能是 FDW、服务器、外部表、用户映射或导入。18.6 的主消息模板是 invalid option "%s"。file_fdw 与 postgres_fdw/option.c 只有在找到足够相近名称时才提示 Perhaps you meant the option "%s".；若存在合法选项但没有相近候选，源码不发送 hint；只有不存在任何合法选项时才提示 There are no valid options in this context.。postgres_fdw 导入解析器只有主消息。

诊断 {#diagnosis}

记录正在修改的对象和包装器版本，然后查看该包装器的验证逻辑与选项表。确认选项属于服务器、外部表还是用户映射；同名选项可能只在其中一个范围有效。保留消息中的相近名称，不要套用其他包装器的选项表。

处理 {#response}

使用已安装包装器在该范围支持的名称，或删除不支持的选项。若选项来自较新的扩展，先确认版本差异确实是原因，再协调扩展与服务器版本。重复相同定义不会改变验证结果。

消息与诊断 {#messages}

18.6 的确认路径位于 file_fdw、postgres_fdw 选项验证器和 postgres_fdw 导入选项解析器，严重级别均为 ERROR。%s 代表动态选项名称或相近名称；提示会随匹配结果变化。

版本 {#versions}

HV00D 从 9.1.0 到 18.6 以及 19 Beta 3 均存在。固定的 REL9_6_24 file_fdw 与 postgres_fdw 验证器快照使用较早的 Valid options in this context are: %s 提示，而固定的 18.6 路径使用相近名称或无可用选项的提示。这两个快照只界定措辞范围，不能确定具体切换版本；比较日志时应以实际安装版本为准。

来源 {#sources}

errcodes.txt — 定义，SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba。
file_fdw.c、postgres_fdw/option.c、postgres_fdw.c — 18.6 选项验证器。
REL9_6_24 中的 file_fdw.c 与 postgres_fdw/option.c — 有界历史提示比较；SHA-256 分别为 1745225d449f44e9b384e372e8e13d5f5fe141e53d49526760fc1df8a1bf6211 和 d7da1cf22cd61619ef2f0cb7ce1a741d4ecb9a03636766e097e2183acdf21d48。
结构化证据 — 确认的消息角色和来源摘要。

比较版本

SQLSTATE 证据与已记录的运行版本

claims · identity

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

claims · option-validators

{
  "claim_id": "option-validators",
  "limits": "",
  "method": "Read each fixed error branch and its option context.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.file_fdw.18.6",
    "src.postgres_fdw.option.18.6",
    "src.postgres_fdw.main.18.6"
  ],
  "statement": "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."
}

claims · historical-hint-boundary

{
  "claim_id": "historical-hint-boundary",
  "limits": "The two fixed wrapper snapshots establish their own wording only; they do not date the transition or describe every wrapper.",
  "method": "Read the fixed REL9_6_24 error branches at file_fdw.c:240-246 and postgres_fdw/option.c:99-103.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.file_fdw.9.6.24",
    "src.postgres_fdw.option.9.6.24"
  ],
  "statement": "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."
}

messages · hv00d_invalid_option

{
  "limits": "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.",
  "message_id": "hv00d_invalid_option",
  "path": "contrib/file_fdw/file_fdw.c:247-253",
  "position": 0,
  "raw": {
    "hint_variants": [
      "Perhaps you meant the option \"%s\".",
      "There are no valid options in this context."
    ],
    "id": "hv00d_invalid_option",
    "limits": "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.",
    "message": "invalid option \"%s\"",
    "path": "contrib/file_fdw/file_fdw.c:247-253",
    "severity": "ERROR",
    "source_ids": [
      "src.file_fdw.18.6"
    ],
    "sqlstate": "HV00D"
  },
  "severity": "ERROR",
  "sources": [
    "src.file_fdw.18.6"
  ],
  "templates": [
    {
      "kind": "hint",
      "literal": "Perhaps you meant the option \" \".",
      "position": 0,
      "role": "",
      "template": "Perhaps you meant the option \"%s\"."
    },
    {
      "kind": "hint",
      "literal": "There are no valid options in this context.",
      "position": 1,
      "role": "",
      "template": "There are no valid options in this context."
    },
    {
      "kind": "primary",
      "literal": "invalid option \" \"",
      "position": 2,
      "role": "observed",
      "template": "invalid option \"%s\""
    }
  ]
}

messages · hv00d_postgres_option

{
  "limits": "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.",
  "message_id": "hv00d_postgres_option",
  "path": "contrib/postgres_fdw/option.c:110-116",
  "position": 1,
  "raw": {
    "hint_variants": [
      "Perhaps you meant the option \"%s\".",
      "There are no valid options in this context."
    ],
    "id": "hv00d_postgres_option",
    "limits": "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.",
    "message": "invalid option \"%s\"",
    "path": "contrib/postgres_fdw/option.c:110-116",
    "severity": "ERROR",
    "source_ids": [
      "src.postgres_fdw.option.18.6"
    ],
    "sqlstate": "HV00D"
  },
  "severity": "ERROR",
  "sources": [
    "src.postgres_fdw.option.18.6"
  ],
  "templates": [
    {
      "kind": "hint",
      "literal": "Perhaps you meant the option \" \".",
      "position": 0,
      "role": "",
      "template": "Perhaps you meant the option \"%s\"."
    },
    {
      "kind": "hint",
      "literal": "There are no valid options in this context.",
      "position": 1,
      "role": "",
      "template": "There are no valid options in this context."
    },
    {
      "kind": "primary",
      "literal": "invalid option \" \"",
      "position": 2,
      "role": "observed",
      "template": "invalid option \"%s\""
    }
  ]
}

messages · hv00d_import_option

{
  "limits": "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.",
  "message_id": "hv00d_import_option",
  "path": "contrib/postgres_fdw/postgres_fdw.c:5491-5493",
  "position": 2,
  "raw": {
    "id": "hv00d_import_option",
    "limits": "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.",
    "message": "invalid option \"%s\"",
    "path": "contrib/postgres_fdw/postgres_fdw.c:5491-5493",
    "severity": "ERROR",
    "source_ids": [
      "src.postgres_fdw.main.18.6"
    ],
    "sqlstate": "HV00D"
  },
  "severity": "ERROR",
  "sources": [
    "src.postgres_fdw.main.18.6"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "invalid option \" \"",
      "position": 0,
      "role": "observed",
      "template": "invalid option \"%s\""
    }
  ]
}

messages · hv00d_file_fdw_historical_hint

{
  "limits": "",
  "message_id": "hv00d_file_fdw_historical_hint",
  "path": "contrib/file_fdw/file_fdw.c:240-246",
  "position": 3,
  "raw": {
    "hint_variants": [
      "Valid options in this context are: %s"
    ],
    "id": "hv00d_file_fdw_historical_hint",
    "message": "invalid option \"%s\"",
    "path": "contrib/file_fdw/file_fdw.c:240-246",
    "severity": "ERROR",
    "source_ids": [
      "src.file_fdw.9.6.24"
    ],
    "sqlstate": "HV00D"
  },
  "severity": "ERROR",
  "sources": [
    "src.file_fdw.9.6.24"
  ],
  "templates": [
    {
      "kind": "hint",
      "literal": "Valid options in this context are:",
      "position": 0,
      "role": "",
      "template": "Valid options in this context are: %s"
    },
    {
      "kind": "primary",
      "literal": "invalid option \" \"",
      "position": 1,
      "role": "observed",
      "template": "invalid option \"%s\""
    }
  ]
}

messages · hv00d_postgres_option_historical_hint

{
  "limits": "",
  "message_id": "hv00d_postgres_option_historical_hint",
  "path": "contrib/postgres_fdw/option.c:99-103",
  "position": 4,
  "raw": {
    "hint_variants": [
      "Valid options in this context are: %s"
    ],
    "id": "hv00d_postgres_option_historical_hint",
    "message": "invalid option \"%s\"",
    "path": "contrib/postgres_fdw/option.c:99-103",
    "severity": "ERROR",
    "source_ids": [
      "src.postgres_fdw.option.9.6.24"
    ],
    "sqlstate": "HV00D"
  },
  "severity": "ERROR",
  "sources": [
    "src.postgres_fdw.option.9.6.24"
  ],
  "templates": [
    {
      "kind": "hint",
      "literal": "Valid options in this context are:",
      "position": 0,
      "role": "",
      "template": "Valid options in this context are: %s"
    },
    {
      "kind": "primary",
      "literal": "invalid option \" \"",
      "position": 1,
      "role": "observed",
      "template": "invalid option \"%s\""
    }
  ]
}

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.file_fdw.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/file_fdw/file_fdw.c",
  "position": 1,
  "sha256": "d79ec21c08be6a806b0710aab09698678ddb24103d3470702e66ee1523432125",
  "source_id": "src.file_fdw.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/contrib/file_fdw/file_fdw.c"
}

sources · src.postgres_fdw.option.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/postgres_fdw/option.c",
  "position": 2,
  "sha256": "880fd16c3e5cbc56733d1292ffdcc9b0f6cb1e17e72c90e9afa4e359239dc314",
  "source_id": "src.postgres_fdw.option.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/contrib/postgres_fdw/option.c"
}

sources · src.postgres_fdw.main.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/postgres_fdw/postgres_fdw.c",
  "position": 3,
  "sha256": "5f61f89fc1f9d67a204c47fd993db575b2d619449e5238b536b9fb1877037db6",
  "source_id": "src.postgres_fdw.main.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/contrib/postgres_fdw/postgres_fdw.c"
}

sources · src.file_fdw.9.6.24

{
  "commit": "a4116b8d5a4f68803452d8f1aa3f74f302049a90",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/file_fdw/file_fdw.c",
  "position": 4,
  "sha256": "1745225d449f44e9b384e372e8e13d5f5fe141e53d49526760fc1df8a1bf6211",
  "source_id": "src.file_fdw.9.6.24",
  "tag": "REL9_6_24",
  "url": "https://github.com/postgres/postgres/blob/a4116b8d5a4f68803452d8f1aa3f74f302049a90/contrib/file_fdw/file_fdw.c#L240-L246"
}

sources · src.postgres_fdw.option.9.6.24

{
  "commit": "a4116b8d5a4f68803452d8f1aa3f74f302049a90",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/postgres_fdw/option.c",
  "position": 5,
  "sha256": "d7da1cf22cd61619ef2f0cb7ce1a741d4ecb9a03636766e097e2183acdf21d48",
  "source_id": "src.postgres_fdw.option.9.6.24",
  "tag": "REL9_6_24",
  "url": "https://github.com/postgres/postgres/blob/a4116b8d5a4f68803452d8f1aa3f74f302049a90/contrib/postgres_fdw/option.c#L99-L103"
}

sources · src.calls.REL_18_6

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

来源引用

原始手册引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:a71f7d2244cb699e5efe4634733fc2b8dd856bfda03651a4bc5acc51ad24222e

正文语言: zh-Hans · english-manuals:a71f7d2244cb699e5efe4634733fc2b8dd856bfda03651a4bc5acc51ad24222e

HV00D — fdw_invalid_option_name

版本定义 PG 18

HV00D — fdw_invalid_option_name

速览 {#at-a-glance}

含义与消息 {#meaning}

诊断 {#diagnosis}

处理 {#response}

消息与诊断 {#messages}

版本 {#versions}

相关 {#related}

来源 {#sources}

比较版本

SQLSTATE 证据与已记录的运行版本

来源引用