3F000 — 模式名称无效（invalid_schema_name）

无法解析指定的 schema 名称，该模式不存在。

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

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

8.1 8.2 8.3 8.4 9.0 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: Invalid Schema Name
condition name: invalid_schema_name
lang: en
sqlstate: 3F000

版本定义 PG 18

3F000 — 模式名称无效

速览 {#at-a-glance}

SQLSTATE 3F000 是 Class 3F 中的 invalid_schema_name。3F000 表示已建立会话无法解析 schema 名称。选定的限定表路径得到 schema "<generated>" does not exist；固定的 namespace 和 schema 命令路径还覆盖对象创建等 SQL 阶段的解析，它不只是一个 search_path 提示。

含义 {#meaning}

当 schema 名称本身无法解析时，namespace 查找会发出此条件。限定引用不存在的 schema 时使用 schema "%s" does not exist；未限定的 CREATE 没有可用创建命名空间时使用 no schema has been selected to create in。两者都是 schema 解析分支。普通未限定关系查找不到关系时使用 42P01，即使原因是 search_path 不合适；权限不足则进入 42501。

首先要判断失败的名称是 schema 还是关系。missing_schema.repaired_table 这样的限定引用会要求 namespace 代码解析准确的 schema，可以产生 3F000；没有显式 schema 的 CREATE 在没有可选创建 schema 时也可以产生 3F000。相反，SELECT * FROM missing_table 是未限定关系查找，通常产生 42P01；search_path 只决定搜索哪些关系，不会把该 SQLSTATE 变成 3F000。角色缺少所需权限时进入 42501。即使应用都报告“找不到 schema”，这些分支的修复也不同。

诊断 {#diagnosis}

区分明确缺失的 schema、没有选定创建 schema 的 CREATE、未限定关系查找，以及 42501 权限不足。选定自动提交会话在 ERROR 后保持 IDLE；所有者显式创建目标 schema 和表，插入一行，并在明确命名空间下核对。检查失败命令使用的相同角色和数据库。

使用失败命令的相同角色和数据库检查标识符，例如查看 current_schemas(true)，并确认目标 schema 能否在目录中解析。再核对命令是否限定名称：选定案例有意引用不存在的限定 schema；如果是未限定 CREATE，要检查 search_path 是否有可用创建目标；如果是未限定关系读取，关系缺失应归为 42P01，而不是 3F000。显式事务中的选定 ERROR 可能使事务进入 INERROR；自动提交的 IDLE 不是通用恢复结果。

处理 {#response}

使用迁移或所有者连接执行 CREATE SCHEMA，设置或限定目标命名空间，并用同一角色验证对象。对于 no schema has been selected to create in，应选择允许创建的 schema 或限定 CREATE；对于未限定的缺失关系，应修复关系名或目标 search_path，在关系可解析前应预期 42P01。不要通过添加无关 schema 到 search_path 掩盖命名空间错误；如果名称是有意删除的，应修复迁移或目标，而不是原样重试。

创建或暴露 schema 后，用同一角色重跑准确的限定语句，并核对最终对象。若失败语句位于显式事务中，应先回滚或回到预先设计的保存点，再执行无关 DDL。不要用扩大 schema 权限代替检查应用连接的数据库或使用的标识符。

实测诊断 {#messages}

固定的 namespace 路径在明确缺失 schema 时以 ERROR 发出主报文 schema "%s" does not exist，在未限定 CREATE 没有活动创建命名空间时发出 no schema has been selected to create in。选定的限定表案例没有固定 DETAIL 或 HINT。未限定关系查找不到时是独立的 42P01 relation "%s" does not exist 路径，角色权限不足则是 42501。

选定的动态名称为 c3f000_invalid_schema_name_missing，错误发生在会话建立后，没有固定 DETAIL 或 HINT。这与源码确认的 schema 命令路径，以及启动阶段的客户端失败不同。

代表案例 {#case}

此 SQL 块限定不存在的 schema，创建 schema 与表，插入一行并核对，最后删除临时 schema。

CREATE TABLE missing_schema.repaired_table (id integer);
CREATE SCHEMA missing_schema;
CREATE TABLE missing_schema.repaired_table (id integer);
INSERT INTO missing_schema.repaired_table VALUES (1);
SELECT count(*) FROM missing_schema.repaired_table;
DROP SCHEMA missing_schema CASCADE;

18.6 运行记录 SQLSTATE 为 3F000，主报文 schema "c3f000_invalid_schema_name_missing" does not exist；断言的错误后状态为 IDLE，随后探针/修复成功。18.6 与 10.21 的断言和清理均通过。

可下载的案例与证据投影分别是 3F000 案例 JSON 和 作者证据。运行器清单为 verify/cases/3F000/cases.json；发布前会将页面 SQL 与共享注册表比对。

版本 {#versions}

上面的生成事实表记录锁定的目录快照和最早观察到的定义。本页自然运行范围是 PostgreSQL 18.6 与 10.21，不能据此推断所有中间版本的行为。

来源 {#sources}

src.namespace-missing-schema.18.6 — src/backend/catalog/namespace.c at REL_18_6 commit 724edf9bde9d356724ad384a2e196edc3c9f80f7; fixed blob SHA-256 8c9e6a99e84fa2cec8a9b1de2ecbe3966a13f4ad68c6ccfbfb8134a754d73e56 (source).
src.namespace-missing-schema.10.23 — src/backend/catalog/namespace.c at REL_10_23 commit 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; fixed blob SHA-256 74833354740d0e5679507d07b3c6e41aea01c2cb30adcd1e238bed3ebf96ddc6 (source).
src.namespace-creation-no-schema.10.23 — src/backend/catalog/namespace.c at REL_10_23 commit 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; fixed blob SHA-256 74833354740d0e5679507d07b3c6e41aea01c2cb30adcd1e238bed3ebf96ddc6 (source).
src.parse-relation-undefined-table.10.23 — src/backend/parser/parse_relation.c at REL_10_23 commit 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; fixed blob SHA-256 a34f40fc93fa5df0015fe5af5ee7761ccba2d16a791cda69ae07848ed27616b5 (source).
src.calls.REL_18_6 / src.calls.REL_10_23 — fixed local call scans, SHA-256 9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf / 00d16d3eb01b71ccf1b245c8f3102f9d0ec9f36fb02777b8dd1b99fcb263040c; these scans preserve the resolved call context used by the claims.

比较版本

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

cases · invalid_schema_name

{
  "assertions": [
    "The selected server diagnostic has the expected SQLSTATE",
    "The selected recovery/probe assertions pass",
    "Runner-owned resources are cleaned up"
  ],
  "case_id": "invalid_schema_name",
  "cleanup": "Drop the case schema with an owner connection.",
  "has_snippet": true,
  "position": 0,
  "preconditions": [
    "A runner-owned disposable target is provisioned."
  ],
  "repair": "Follow the case-specific repair statements and verify the resulting state.",
  "trigger": "Use a missing schema-qualified table, create the schema explicitly, and verify one repaired row.",
  "versions": [
    "10",
    "18"
  ]
}

claims · identity.class-and-condition

{
  "claim_id": "identity.class-and-condition",
  "limits": "Directory identity does not identify every backend or client path.",
  "method": "Read the fixed errcodes.txt definition and the locked catalogue metadata.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "3F000 is the invalid_schema_name condition in Class 3F."
}

claims · mechanism.backend-path

{
  "claim_id": "mechanism.backend-path",
  "limits": "Other calls can retain the same SQLSTATE with different context or text.",
  "method": "Trace the resolved source call records at the fixed release commits and compare their dynamic message fields.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.namespace-missing-schema.18.6",
    "src.namespace-missing-schema.10.23"
  ],
  "statement": "The fixed source paths associated with 3F000 report the condition in the mechanism selected for this page."
}

claims · runtime.representative-case

{
  "claim_id": "runtime.representative-case",
  "limits": "This covers the selected case and versions only; it does not generalize to every driver, proxy, or intermediate release.",
  "method": "Run the shared registry case on isolated runner-owned latest and PG10 targets; inspect the final summaries and raw results.",
  "position": 2,
  "runtime": [
    "runtime.3F000-conn-test-latest.latest",
    "runtime.3F000-conn-test-pg10.pg10"
  ],
  "sources": [
    "snippet-registry.3F000",
    "manifest.3F000"
  ],
  "statement": "The selected invalid_schema_name case passed with the expected structured diagnostics, recovery assertions, and cleanup on PostgreSQL 18.6 and 10.21."
}

claims · namespace-branch-boundary

{
  "claim_id": "namespace-branch-boundary",
  "limits": "The selected runtime covers one qualified missing-schema reference; the creation-no-schema and 42P01 contrast branches are source-only and no new runtime was selected.",
  "method": "Read the complete fixed namespace creation and explicit-lookup branches together with parserOpenTable, then compare the selected runtime diagnostics and transaction recovery contract.",
  "position": 3,
  "runtime": [],
  "sources": [
    "src.namespace-missing-schema.18.6",
    "src.namespace-missing-schema.10.23",
    "src.namespace-creation-no-schema.10.23",
    "src.parse-relation-undefined-table.10.23",
    "doc.transactions.18"
  ],
  "statement": "The fixed namespace branches distinguish an explicitly missing schema, which reports 3F000 with schema \"%s\" does not exist, from an unqualified CREATE with no active creation namespace, which reports 3F000 with no schema has been selected to create in. An unqualified relation miss is the parser's 42P01 relation \"%s\" does not exist path, and privilege denial is 42501; search_path does not turn those relation or privilege branches into 3F000."
}

claims · versions.catalogue-boundary

{
  "claim_id": "versions.catalogue-boundary",
  "limits": "Presence in a definition file is not an exact behavioral introduction; the two runtime targets do not prove all middle versions.",
  "method": "Read the generated facts block and locked manifest, then compare the selected target summaries.",
  "position": 4,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6",
    "src.calls.REL_18_6",
    "src.calls.REL_10_23"
  ],
  "statement": "The locked catalogue records 3F000 in the listed snapshots; the runtime comparison here is limited to PostgreSQL 18.6 and 10.21."
}

messages · message.missing-schema

{
  "limits": "",
  "message_id": "message.missing-schema",
  "path": "",
  "position": 0,
  "raw": {
    "id": "message.missing-schema",
    "primary_template": "schema \"%s\" does not exist",
    "severity_source": "explicit ERROR",
    "sources": [
      "src.namespace-missing-schema.18.6",
      "src.namespace-missing-schema.10.23"
    ],
    "sqlstate": "3F000"
  },
  "severity": "explicit ERROR",
  "sources": [
    "src.namespace-missing-schema.18.6",
    "src.namespace-missing-schema.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "schema \" \" does not exist",
      "position": 0,
      "role": "",
      "template": "schema \"%s\" does not exist"
    }
  ]
}

messages · message.creation-no-schema

{
  "limits": "",
  "message_id": "message.creation-no-schema",
  "path": "",
  "position": 1,
  "raw": {
    "id": "message.creation-no-schema",
    "primary_template": "no schema has been selected to create in",
    "severity_source": "explicit ERROR",
    "sources": [
      "src.namespace-creation-no-schema.10.23"
    ],
    "sqlstate": "3F000"
  },
  "severity": "explicit ERROR",
  "sources": [
    "src.namespace-creation-no-schema.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "no schema has been selected to create in",
      "position": 0,
      "role": "",
      "template": "no schema has been selected to create in"
    }
  ]
}

runtimes · runtime.3F000-conn-test-latest.latest · 18.6 (Homebrew) · passed

{
  "cases": [
    "invalid_schema_name"
  ],
  "limits": "Disposable runner-owned target only; this is a bounded mechanism case, not a guarantee for every client or network path.",
  "position": 0,
  "raw": {
    "assertions": [
      {
        "expected": "3F000",
        "name": "schema SQLSTATE",
        "observed": "3F000",
        "passed": true
      },
      {
        "expected": "schema \"c3f000_invalid_schema_name_missing\" does not exist",
        "name": "schema diagnostic",
        "observed": "schema \"c3f000_invalid_schema_name_missing\" does not exist",
        "passed": true
      },
      {
        "expected": "IDLE, one row, IDLE",
        "name": "schema creation repairs path",
        "observed": {
          "after_error": "IDLE",
          "count": 1,
          "final": "IDLE"
        },
        "passed": true
      }
    ],
    "case_manifest": "verify/cases/3F000/cases.json",
    "case_manifest_sha256": "24f38a529b6226fed2c5a75d5d25414c6be4616a8e27cb8a72021aca552d8baa",
    "cases": [
      "invalid_schema_name"
    ],
    "cleanup": {
      "case": {
        "errors": [],
        "passed": true
      },
      "target_stop": {
        "argv": [
          "/opt/homebrew/Cellar/postgresql@18/18.6/bin/pg_ctl",
          "-D",
          "/Users/vonng/pgcenter/err-code/.cache/runtime/3F000-conn-test-latest/latest/data",
          "-m",
          "fast",
          "-w",
          "stop"
        ],
        "elapsed_seconds": 0.107,
        "returncode": 0,
        "stderr": "",
        "stdout": "waiting for server to shut down.... done\nserver stopped\n"
      }
    },
    "environment": {
      "lc_messages": "C",
      "libpq_version": "18.6",
      "locale": "en_US.UTF-8",
      "log_destination": "csvlog,jsonlog",
      "machine": "arm64",
      "platform": "macOS-26.6.2-arm64-arm-64bit-Mach-O",
      "psycopg_version": "3.3.5",
      "python_version": "3.14.6 (main, Jun 10 2026, 10:03:53) [Clang 21.0.0 (clang-2100.0.123.102)]",
      "server_version": "18.6 (Homebrew)",
      "server_version_num": "180006",
      "target_kind": "latest"
    },
    "id": "runtime.3F000-conn-test-latest.latest",
    "kind": "runtime_observation",
    "limits": "Disposable runner-owned target only; this is a bounded mechanism case, not a guarantee for every client or network path.",
    "observed": {
      "connection_autocommit": true,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "InvalidSchemaName",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "schema \"c3f000_invalid_schema_name_missing\" does not exist",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "namespace.c",
        "source_function": "get_namespace_oid",
        "source_line": "3547",
        "sqlstate": "3F000",
        "statement_position": "14",
        "table_name": null,
        "text": "schema \"c3f000_invalid_schema_name_missing\" does not exist\nLINE 1: CREATE TABLE \"c3f000_invalid_schema_name_missing\".\"repaired_...\n                     ^"
      },
      "missing_schema": "c3f000_invalid_schema_name_missing",
      "repaired_table": "c3f000_invalid_schema_name_missing.repaired_table",
      "row_count": 1,
      "statuses": {
        "after_error": "IDLE",
        "final": "IDLE"
      }
    },
    "raw": "verify/results/3F000-conn-test-latest/latest/raw.jsonl",
    "raw_sha256": "9dbd0f3c1d1567ba9285d398eb99ad12283459c859af49a905f1e592425eafad",
    "run_id": "3F000-conn-test-latest",
    "server_version": "18.6 (Homebrew)",
    "server_version_num": 180006,
    "snippet_registry": {
      "path": "verify/cases/3F000/snippets.json",
      "sha256": "a51e3e0d667e45c1ef692589bbddb847d49df0689e12d14616eb23ee036d82ac"
    },
    "status": "passed",
    "summary": "verify/results/3F000-conn-test-latest/latest/summary.json",
    "summary_sha256": "9a561e0b5973596704fbffc8d1ac0fe9fdf28952bf8a6b99c7a389ddd4719ca3",
    "target": "latest"
  },
  "run_id": "3F000-conn-test-latest",
  "runtime_id": "runtime.3F000-conn-test-latest.latest",
  "server_version": "18.6 (Homebrew)",
  "status": "passed",
  "target": "latest"
}

runtimes · runtime.3F000-conn-test-pg10.pg10 · 10.21 (Debian 10.21-1.pgdg90+1) · passed

{
  "cases": [
    "invalid_schema_name"
  ],
  "limits": "Disposable runner-owned target only; this is a bounded mechanism case, not a guarantee for every client or network path.",
  "position": 1,
  "raw": {
    "assertions": [
      {
        "expected": "3F000",
        "name": "schema SQLSTATE",
        "observed": "3F000",
        "passed": true
      },
      {
        "expected": "schema \"c3f000_invalid_schema_name_missing\" does not exist",
        "name": "schema diagnostic",
        "observed": "schema \"c3f000_invalid_schema_name_missing\" does not exist",
        "passed": true
      },
      {
        "expected": "IDLE, one row, IDLE",
        "name": "schema creation repairs path",
        "observed": {
          "after_error": "IDLE",
          "count": 1,
          "final": "IDLE"
        },
        "passed": true
      }
    ],
    "case_manifest": "verify/cases/3F000/cases.json",
    "case_manifest_sha256": "24f38a529b6226fed2c5a75d5d25414c6be4616a8e27cb8a72021aca552d8baa",
    "cases": [
      "invalid_schema_name"
    ],
    "cleanup": {
      "case": {
        "errors": [],
        "passed": true
      },
      "target_stop": {
        "cleanup": {
          "argv": [
            "/usr/local/bin/docker",
            "rm",
            "-f",
            "-v",
            "sqlstate3f000_3F000conntestpg10_pg10"
          ],
          "elapsed_seconds": 0.341,
          "returncode": 0,
          "stderr": "",
          "stdout": "sqlstate3f000_3F000conntestpg10_pg10\n"
        },
        "inspect": {
          "argv": [
            "/usr/local/bin/docker",
            "inspect",
            "sqlstate3f000_3F000conntestpg10_pg10"
          ],
          "elapsed_seconds": 0.017,
          "returncode": 0,
          "stderr": "",
          "stdout": "[\n    {\n        \"Id\": \"b694ead735ee83bb7da85608cdfab90a0f507e23e9df10793cd29acb82a3ebad\",\n        \"Created\": \"2026-09-09T14:55:53.169487505Z\",\n        \"Path\": \"docker-entrypoint.sh\",\n        \"Args\": [\n            \"postgres\",\n            \"-c\",\n            \"listen_addresses=*\",\n            \"-c\",\n            \"log_destination=csvlog\",\n            \"-c\",\n            \"logging_collector=on\",\n            \"-c\",\n            \"log_directory=log\",\n            \"-c\",\n            \"log_filename=postgresql-%Y%m%d%H%M%S.log\",\n            \"-c\",\n            \"log_min_messages=error\",\n            \"-c\",\n            \"log_min_error_statement=error\",\n            \"-c\",\n            \"log_error_verbosity=verbose\",\n            \"-c\",\n            \"wal_level=logical\",\n            \"-c\",\n            \"max_wal_senders=10\",\n            \"-c\",\n            \"max_replication_slots=10\"\n        ],\n        \"State\": {\n            \"Status\": \"running\",\n            \"Running\": true,\n            \"Paused\": false,\n            \"Restarting\": false,\n            \"OOMKilled\": false,\n            \"Dead\": false,\n            \"Pid\": 55126,\n            \"ExitCode\": 0,\n            \"Error\": \"\",\n            \"StartedAt\": \"2026-09-09T14:55:53.249415463Z\",\n            \"FinishedAt\": \"0001-01-01T00:00:00Z\"\n        },\n        \"Image\": \"sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n        \"ResolvConfPath\": \"/var/lib/docker/containers/b694ead735ee83bb7da85608cdfab90a0f507e23e9df10793cd29acb82a3ebad/resolv.conf\",\n        \"HostnamePath\": \"/var/lib/docker/containers/b694ead735ee83bb7da85608cdfab90a0f507e23e9df10793cd29acb82a3ebad/hostname\",\n        \"HostsPath\": \"/var/lib/docker/containers/b694ead735ee83bb7da85608cdfab90a0f507e23e9df10793cd29acb82a3ebad/hosts\",\n        \"LogPath\": \"/var/lib/docker/containers/b694ead735ee83bb7da85608cdfab90a0f507e23e9df10793cd29acb82a3ebad/b694ead735ee83bb7da85608cdfab90a0f507e23e9df10793cd29acb82a3ebad-json.log\",\n        \"Name\": \"/sqlstate3f000_3F000conntestpg10_pg10\",\n        \"RestartCount\": 0,\n        \"Driver\": \"overlayfs\",\n        \"Platform\": \"linux\",\n        \"MountLabel\": \"\",\n        \"ProcessLabel\": \"\",\n        \"AppArmorProfile\": \"\",\n        \"ExecIDs\": null,\n        \"HostConfig\": {\n            \"Binds\": null,\n            \"ContainerIDFile\": \"\",\n            \"LogConfig\": {\n                \"Type\": \"json-file\",\n                \"Config\": {}\n            },\n            \"NetworkMode\": \"bridge\",\n            \"PortBindings\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"\"\n                    }\n                ]\n            },\n            \"RestartPolicy\": {\n                \"Name\": \"no\",\n                \"MaximumRetryCount\": 0\n            },\n            \"AutoRemove\": false,\n            \"VolumeDriver\": \"\",\n            \"VolumesFrom\": null,\n            \"ConsoleSize\": [\n                0,\n                0\n            ],\n            \"CapAdd\": null,\n            \"CapDrop\": null,\n            \"CgroupnsMode\": \"private\",\n            \"Dns\": null,\n            \"DnsOptions\": [],\n            \"DnsSearch\": [],\n            \"ExtraHosts\": null,\n            \"GroupAdd\": null,\n            \"IpcMode\": \"private\",\n            \"Cgroup\": \"\",\n            \"Links\": null,\n            \"OomScoreAdj\": 0,\n            \"PidMode\": \"\",\n            \"Privileged\": false,\n            \"PublishAllPorts\": false,\n            \"ReadonlyRootfs\": false,\n            \"SecurityOpt\": null,\n            \"UTSMode\": \"\",\n            \"UsernsMode\": \"\",\n            \"ShmSize\": 67108864,\n            \"Runtime\": \"runc\",\n            \"Isolation\": \"\",\n            \"CpuShares\": 0,\n            \"Memory\": 0,\n            \"NanoCpus\": 0,\n            \"CgroupParent\": \"\",\n            \"BlkioWeight\": 0,\n            \"BlkioWeightDevice\": [],\n            \"BlkioDeviceReadBps\": [],\n            \"BlkioDeviceWriteBps\": [],\n            \"BlkioDeviceReadIOps\": [],\n            \"BlkioDeviceWriteIOps\": [],\n            \"CpuPeriod\": 0,\n            \"CpuQuota\": 0,\n            \"CpuRealtimePeriod\": 0,\n            \"CpuRealtimeRuntime\": 0,\n            \"CpusetCpus\": \"\",\n            \"CpusetMems\": \"\",\n            \"Devices\": [],\n            \"DeviceCgroupRules\": null,\n            \"DeviceRequests\": null,\n            \"MemoryReservation\": 0,\n            \"MemorySwap\": 0,\n            \"MemorySwappiness\": null,\n            \"OomKillDisable\": null,\n            \"PidsLimit\": null,\n            \"Ulimits\": [],\n            \"CpuCount\": 0,\n            \"CpuPercent\": 0,\n            \"IOMaximumIOps\": 0,\n            \"IOMaximumBandwidth\": 0,\n            \"MaskedPaths\": [\n                \"/proc/acpi\",\n                \"/proc/asound\",\n                \"/proc/interrupts\",\n                \"/proc/kcore\",\n                \"/proc/keys\",\n                \"/proc/latency_stats\",\n                \"/proc/sched_debug\",\n                \"/proc/scsi\",\n                \"/proc/timer_list\",\n                \"/proc/timer_stats\",\n                \"/sys/devices/virtual/powercap\",\n                \"/sys/firmware\"\n            ],\n            \"ReadonlyPaths\": [\n                \"/proc/bus\",\n                \"/proc/fs\",\n                \"/proc/irq\",\n                \"/proc/sys\",\n                \"/proc/sysrq-trigger\"\n            ]\n        },\n        \"Storage\": {\n            \"RootFS\": {\n                \"Snapshot\": {\n                    \"Name\": \"overlayfs\"\n                }\n            }\n        },\n        \"Mounts\": [\n            {\n                \"Type\": \"volume\",\n                \"Name\": \"889e3f6b2813d8aa3a0b13ba521541bb63c280b63532256e95f89298278cd24f\",\n                \"Source\": \"/var/lib/docker/volumes/889e3f6b2813d8aa3a0b13ba521541bb63c280b63532256e95f89298278cd24f/_data\",\n                \"Destination\": \"/var/lib/postgresql/data\",\n                \"Driver\": \"local\",\n                \"Mode\": \"\",\n                \"RW\": true,\n                \"Propagation\": \"\"\n            }\n        ],\n        \"Config\": {\n            \"Hostname\": \"b694ead735ee\",\n            \"Domainname\": \"\",\n            \"User\": \"\",\n            \"AttachStdin\": false,\n            \"AttachStdout\": false,\n            \"AttachStderr\": false,\n            \"ExposedPorts\": {\n                \"5432/tcp\": {}\n            },\n            \"Tty\": false,\n            \"OpenStdin\": false,\n            \"StdinOnce\": false,\n            \"Env\": [\n                \"POSTGRES_HOST_AUTH_METHOD=trust\",\n                \"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/10/bin\",\n                \"GOSU_VERSION=1.14\",\n                \"LANG=en_US.utf8\",\n                \"PG_MAJOR=10\",\n                \"PG_VERSION=10.21-1.pgdg90+1\",\n                \"PGDATA=/var/lib/postgresql/data\"\n            ],\n            \"Cmd\": [\n                \"postgres\",\n                \"-c\",\n                \"listen_addresses=*\",\n                \"-c\",\n                \"log_destination=csvlog\",\n                \"-c\",\n                \"logging_collector=on\",\n                \"-c\",\n                \"log_directory=log\",\n                \"-c\",\n                \"log_filename=postgresql-%Y%m%d%H%M%S.log\",\n                \"-c\",\n                \"log_min_messages=error\",\n                \"-c\",\n                \"log_min_error_statement=error\",\n                \"-c\",\n                \"log_error_verbosity=verbose\",\n                \"-c\",\n                \"wal_level=logical\",\n                \"-c\",\n                \"max_wal_senders=10\",\n                \"-c\",\n                \"max_replication_slots=10\"\n            ],\n            \"Image\": \"postgres@sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n            \"Volumes\": {\n                \"/var/lib/postgresql/data\": {}\n            },\n            \"WorkingDir\": \"\",\n            \"Entrypoint\": [\n                \"docker-entrypoint.sh\"\n            ],\n            \"Labels\": {},\n            \"StopSignal\": \"SIGINT\",\n            \"StopTimeout\": 1\n        },\n        \"NetworkSettings\": {\n            \"SandboxID\": \"18c4a41f3d9dd37eaef70a5593e4f8016ceb96f5dc42e247d17bb543af9adc95\",\n            \"SandboxKey\": \"/var/run/docker/netns/18c4a41f3d9d\",\n            \"Ports\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"56789\"\n                    }\n                ]\n            },\n            \"Networks\": {\n                \"bridge\": {\n                    \"IPAMConfig\": null,\n                    \"Links\": null,\n                    \"Aliases\": null,\n                    \"DriverOpts\": null,\n                    \"GwPriority\": 0,\n                    \"NetworkID\": \"aed51554f8cd8bac69ecd4f073e41e147fda7b458e9d95be2af472651f2e825c\",\n                    \"EndpointID\": \"b903cc8d626b5131d3ac895aedd9d7972d8f9450cf5060eac07362f1f2e410de\",\n                    \"Gateway\": \"172.17.0.1\",\n                    \"IPAddress\": \"172.17.0.53\",\n                    \"MacAddress\": \"6a:1c:ba:fb:14:20\",\n                    \"IPPrefixLen\": 16,\n                    \"IPv6Gateway\": \"\",\n                    \"GlobalIPv6Address\": \"\",\n                    \"GlobalIPv6PrefixLen\": 0,\n                    \"DNSNames\": null\n                }\n            }\n        },\n        \"ImageManifestDescriptor\": {\n            \"mediaType\": \"application/vnd.docker.distribution.manifest.v2+json\",\n            \"digest\": \"sha256:52aada7978f1eef3b6b52a51afb7a3defd69254d00c946cb90d2ceb32b8ffce7\",\n            \"size\": 3246,\n            \"platform\": {\n                \"architecture\": \"arm64\",\n                \"os\": \"linux\",\n                \"variant\": \"v8\"\n            }\n        }\n    }\n]\n"
        }
      }
    },
    "environment": {
      "lc_messages": "en_US.utf8",
      "libpq_version": "18.6",
      "locale": "en_US.UTF-8",
      "log_destination": "csvlog",
      "machine": "arm64",
      "platform": "macOS-26.6.2-arm64-arm-64bit-Mach-O",
      "psycopg_version": "3.3.5",
      "python_version": "3.14.6 (main, Jun 10 2026, 10:03:53) [Clang 21.0.0 (clang-2100.0.123.102)]",
      "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
      "server_version_num": "100021",
      "target_kind": "pg10"
    },
    "id": "runtime.3F000-conn-test-pg10.pg10",
    "image": "postgres:10",
    "kind": "runtime_observation",
    "limits": "Disposable runner-owned target only; this is a bounded mechanism case, not a guarantee for every client or network path.",
    "observed": {
      "connection_autocommit": true,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "InvalidSchemaName",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "schema \"c3f000_invalid_schema_name_missing\" does not exist",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "namespace.c",
        "source_function": "get_namespace_oid",
        "source_line": "3024",
        "sqlstate": "3F000",
        "statement_position": "14",
        "table_name": null,
        "text": "schema \"c3f000_invalid_schema_name_missing\" does not exist\nLINE 1: CREATE TABLE \"c3f000_invalid_schema_name_missing\".\"repaired_...\n                     ^"
      },
      "missing_schema": "c3f000_invalid_schema_name_missing",
      "repaired_table": "c3f000_invalid_schema_name_missing.repaired_table",
      "row_count": 1,
      "statuses": {
        "after_error": "IDLE",
        "final": "IDLE"
      }
    },
    "raw": "verify/results/3F000-conn-test-pg10/pg10/raw.jsonl",
    "raw_sha256": "7dc9d41be4105c27ab544456931505332018143becf021604cbd22e206fc537c",
    "run_id": "3F000-conn-test-pg10",
    "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
    "server_version_num": 100021,
    "snippet_registry": {
      "path": "verify/cases/3F000/snippets.json",
      "sha256": "a51e3e0d667e45c1ef692589bbddb847d49df0689e12d14616eb23ee036d82ac"
    },
    "status": "passed",
    "summary": "verify/results/3F000-conn-test-pg10/pg10/summary.json",
    "summary_sha256": "34a08faf372e7b262ae783c0d50a291d75ee8eece30a72c513f3f65482d6bfaa",
    "target": "pg10"
  },
  "run_id": "3F000-conn-test-pg10",
  "runtime_id": "runtime.3F000-conn-test-pg10.pg10",
  "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
  "status": "passed",
  "target": "pg10"
}

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.calls.REL_18_6

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

sources · src.calls.REL_10_23

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_10_23.jsonl",
  "position": 2,
  "sha256": "00d16d3eb01b71ccf1b245c8f3102f9d0ec9f36fb02777b8dd1b99fcb263040c",
  "source_id": "src.calls.REL_10_23",
  "tag": "REL_10_23",
  "url": ""
}

sources · src.namespace-missing-schema.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/catalog/namespace.c",
  "position": 3,
  "sha256": "8c9e6a99e84fa2cec8a9b1de2ecbe3966a13f4ad68c6ccfbfb8134a754d73e56",
  "source_id": "src.namespace-missing-schema.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/catalog/namespace.c#L3545-L3547"
}

sources · src.namespace-missing-schema.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/catalog/namespace.c",
  "position": 4,
  "sha256": "74833354740d0e5679507d07b3c6e41aea01c2cb30adcd1e238bed3ebf96ddc6",
  "source_id": "src.namespace-missing-schema.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/catalog/namespace.c#L3022-L3024"
}

sources · src.namespace-creation-no-schema.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/catalog/namespace.c",
  "position": 5,
  "sha256": "74833354740d0e5679507d07b3c6e41aea01c2cb30adcd1e238bed3ebf96ddc6",
  "source_id": "src.namespace-creation-no-schema.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/catalog/namespace.c#L2967-L3004"
}

sources · src.parse-relation-undefined-table.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/parser/parse_relation.c",
  "position": 6,
  "sha256": "a34f40fc93fa5df0015fe5af5ee7761ccba2d16a791cda69ae07848ed27616b5",
  "source_id": "src.parse-relation-undefined-table.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/parser/parse_relation.c#L1147-L1184"
}

sources · doc.transactions.18

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "doc/src/sgml/xact.sgml",
  "position": 7,
  "sha256": "b48fbe8bd02ce3d1181a350c88c8baa6e11c73edc90a936e77b180daef328c5c",
  "source_id": "doc.transactions.18",
  "tag": "PG18-docs",
  "url": "https://www.postgresql.org/docs/18/tutorial-transactions.html"
}

sources · manifest.3F000

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/3F000/cases.json",
  "position": 8,
  "sha256": "24f38a529b6226fed2c5a75d5d25414c6be4616a8e27cb8a72021aca552d8baa",
  "source_id": "manifest.3F000",
  "tag": "workspace",
  "url": "verify/cases/3F000/cases.json"
}

sources · snippet-registry.3F000

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/3F000/snippets.json",
  "position": 9,
  "sha256": "a51e3e0d667e45c1ef692589bbddb847d49df0689e12d14616eb23ee036d82ac",
  "source_id": "snippet-registry.3F000",
  "tag": "workspace",
  "url": "verify/cases/3F000/snippets.json"
}

来源引用

原始手册引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:927c57eae7053a43867898150af15e28b8d007f547d9c8e2d0daac4f8c80366a

正文语言: zh-Hans · english-manuals:927c57eae7053a43867898150af15e28b8d007f547d9c8e2d0daac4f8c80366a