↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / SQLSTATE

HV00J — fdw_option_name_not_found

dblink 连接选项不在接受的选项集合中。

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

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

9.19.29.39.49.59.61011121314151617181920
aliases
未知
class name
Foreign Data Wrapper Error (SQL/MED)
condition name
fdw_option_name_not_found
lang
en
sqlstate
HV00J

版本定义 PG 18

HV00J — fdw_option_name_not_found

速览 {#at-a-glance}

当 dblink 的连接选项不在接受的 dblink/libpq 选项集合中时，会使用 HV00J。dblink 是独立的 contrib 客户端 API，不是 FDW 回调实现；18.6 核心与 contrib 扫描没有解析出其他 HV00J 报告组。

含义与消息 {#meaning}

在 dblink 的选项解析路径中，ERROR 的主消息为 invalid option "%s"。只有找到相近名称时才提示 Perhaps you meant the option "%s".；若存在合法选项但没有相近候选，源码不发送 hint；只有不存在任何合法选项时才提示 There are no valid options in this context.。固定的 REL9_6_24 dblink 快照显示较早的动态 Valid options in this context are: %s 提示；这只是有界比较，不代表精确的切换版本。

诊断 {#diagnosis}

确认该选项属于 dblink 连接字符串或选项列表，并查看安装版本对应的 libpq 选项名称。保留确切选项名、dblink/libpq 版本，以及错误是否发生在解析连接定义时。不要把 postgres_fdw 的选项表用于 dblink。

处理 {#response}

改用 dblink/libpq 支持的名称，或删除该选项，并保留相近名称提示作为线索。重新校验连接定义即可；无效选项名称是确定性的，不需要重试数据库事务。

诊断边界 {#messages}

确认的实现是 dblink 的选项解析器。本批没有运行自然环境实验，源码证据也不表示远端连接已经成功或失败。

版本 {#versions}

该条件从 9.1.0 到 18.6 以及 19 Beta 3 均存在。固定的 18.6 与 REL9_6_24 dblink 快照显示了不同的提示措辞；它们界定已观察版本，但不确定切换版本。解读日志时应匹配实际安装版本。

相关 {#related}

HV00D 涵盖 file_fdw/postgres_fdw 的选项名称；HV00N 涉及建立连接；HV001 涉及获取 libpq 默认值时的内存分配失败。

来源 {#sources}

  • errcodes.txt — 定义，SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba。
  • dblink.c — 18.6 dblink 选项解析器。
  • REL9_6_24 中的 dblink.c — 有界历史提示比较；SHA-256 ff331aac2153e21aa88cc6c4e656ab00b0593744062270849f27281434db3b55。
  • 结构化证据 — 消息、detail 和 hint 的分组。

比较版本

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

claims · identity
{
  "claim_id": "identity",
  "limits": "",
  "method": "Read the fixed definition row and macro.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "HV00J is fdw_option_name_not_found in SQL/MED Class HV."
}
claims · dblink-option
{
  "claim_id": "dblink-option",
  "limits": "",
  "method": "Read the fixed option-validation branch.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.dblink.18.6"
  ],
  "statement": "dblink uses HV00J in its own connection-option parser; dblink is a separate contrib client API rather than an FDW callback implementation."
}
claims · historical-hint-boundary
{
  "claim_id": "historical-hint-boundary",
  "limits": "This fixed snapshot establishes dblink's wording there; it does not date the transition or generalize to other clients.",
  "method": "Read the fixed REL9_6_24 dblink.c error branch at lines 2017-2021.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.dblink.9.6.24"
  ],
  "statement": "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."
}
messages · dblink-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": "dblink-invalid-option",
  "path": "contrib/dblink/dblink.c:2005-2011",
  "position": 0,
  "raw": {
    "hint_variants": [
      "Perhaps you meant the option \"%s\".",
      "There are no valid options in this context."
    ],
    "id": "dblink-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/dblink/dblink.c:2005-2011",
    "severity": "ERROR",
    "source_ids": [
      "src.dblink.18.6"
    ],
    "sqlstate": "HV00J"
  },
  "severity": "ERROR",
  "sources": [
    "src.dblink.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 · dblink-invalid-option-historical-hint
{
  "limits": "",
  "message_id": "dblink-invalid-option-historical-hint",
  "path": "contrib/dblink/dblink.c:2017-2021",
  "position": 1,
  "raw": {
    "hint_variants": [
      "Valid options in this context are: %s"
    ],
    "id": "dblink-invalid-option-historical-hint",
    "message": "invalid option \"%s\"",
    "path": "contrib/dblink/dblink.c:2017-2021",
    "severity": "ERROR",
    "source_ids": [
      "src.dblink.9.6.24"
    ],
    "sqlstate": "HV00J"
  },
  "severity": "ERROR",
  "sources": [
    "src.dblink.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.dblink.18.6
{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/dblink/dblink.c",
  "position": 1,
  "sha256": "e4cfaec3a0a1e5d23fded584725e0f6cf7a17321ad99e5fe046e8b7f97416f15",
  "source_id": "src.dblink.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/contrib/dblink/dblink.c"
}
sources · src.dblink.9.6.24
{
  "commit": "a4116b8d5a4f68803452d8f1aa3f74f302049a90",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/dblink/dblink.c",
  "position": 2,
  "sha256": "ff331aac2153e21aa88cc6c4e656ab00b0593744062270849f27281434db3b55",
  "source_id": "src.dblink.9.6.24",
  "tag": "REL9_6_24",
  "url": "https://github.com/postgres/postgres/blob/a4116b8d5a4f68803452d8f1aa3f74f302049a90/contrib/dblink/dblink.c#L2017-L2021"
}
sources · src.calls.REL_18_6
{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_18_6.jsonl",
  "position": 3,
  "sha256": "9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf",
  "source_id": "src.calls.REL_18_6",
  "tag": "",
  "url": ""
}

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:98de1e91cc55831ef3297d0a4d00bcf913523f59565ff1fe20feb06b5c6e6c3b

正文语言: zh-Hans · english-manuals:98de1e91cc55831ef3297d0a4d00bcf913523f59565ff1fe20feb06b5c6e6c3b