0LP01 — 无效的授权操作（invalid_grant_operation）

GRANT 或 REVOKE 的权限类型对该对象无效。

英文手册覆盖始于 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 Grantor
condition name: invalid_grant_operation
lang: en
sqlstate: 0LP01

版本定义 PG 18

0LP01 — 无效的授权操作

速览 {#at-a-glance}

SQLSTATE 0LP01 是 Class 0L 中的 invalid_grant_operation。0LP01 表示 GRANT 或 REVOKE 对对象或权限类型无效。选定的序列案例请求 INSERT，服务器通过动态报文组合出 invalid privilege type INSERT for sequence；随后授予 USAGE 成功。

含义 {#meaning}

0LP01 表示 GRANT 或 REVOKE 对对象或权限类型无效。选定的序列案例请求 INSERT，服务器通过动态报文组合出 invalid privilege type INSERT for sequence；随后授予 USAGE 成功。

诊断 {#diagnosis}

检查对象类型、权限矩阵、目标角色、所有权，以及语句是否属于列权限或默认权限形式。选定错误是 ERROR，但自动提交会话保持 IDLE；修复后的权限查询返回 true。

处理 {#response}

按对象支持的权限重写语句并核对 ACL。序列应按意图选择 USAGE、SELECT 或 UPDATE；不要扩大授权，也不要原样重试。

实测诊断 {#messages}

结构化证据保留原始报文模板或动态组装边界。对于本页，只有客户端异常而没有服务器诊断时，不能据此认定 0LP01。

代表案例 {#case}

此 SQL 块创建序列，尝试无效的 INSERT 权限，授予 USAGE，并检查临时角色的有效权限。

CREATE SEQUENCE grant_sequence;
GRANT INSERT ON SEQUENCE grant_sequence TO role;
GRANT USAGE ON SEQUENCE grant_sequence TO role;
SELECT has_sequence_privilege(role_literal, 'grant_sequence', 'USAGE');

18.6 运行记录 SQLSTATE 为 0LP01，主报文 invalid privilege type INSERT for sequence；断言的错误后状态为 IDLE，随后探针/修复成功。18.6 与 10.21 的断言和清理均通过。

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

版本 {#versions}

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

来源 {#sources}

src.acl-invalid-grant-dynamic.18.6 — src/backend/catalog/aclchk.c at REL_18_6 commit 724edf9bde9d356724ad384a2e196edc3c9f80f7; fixed blob SHA-256 9700258318959b47c42edb423418fb511dd3a008023e732f601eecf4c80868f8 (source).
src.acl-invalid-grant-dynamic.10.23 — src/backend/catalog/aclchk.c at REL_10_23 commit 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; fixed blob SHA-256 3a4330bd55ea8c0ec12324d7046ec31d64c920f99196235b84612d6cd1a4b26c (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_grant_operation

{
  "assertions": [
    "The selected server diagnostic has the expected SQLSTATE",
    "The selected recovery/probe assertions pass",
    "Runner-owned resources are cleaned up"
  ],
  "case_id": "invalid_grant_operation",
  "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": "Grant an invalid sequence privilege, then grant USAGE to a disposable role.",
  "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": "0LP01 is the invalid_grant_operation condition in Class 0L."
}

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.acl-invalid-grant-dynamic.18.6",
    "src.acl-invalid-grant-dynamic.10.23"
  ],
  "statement": "The fixed source paths associated with 0LP01 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.0LP01-conn-test-latest.latest",
    "runtime.0LP01-conn-test-pg10.pg10"
  ],
  "sources": [
    "snippet-registry.0LP01",
    "manifest.0LP01"
  ],
  "statement": "The selected invalid_grant_operation case passed with the expected structured diagnostics, recovery assertions, and cleanup on PostgreSQL 18.6 and 10.21."
}

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": 3,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6",
    "src.calls.REL_18_6",
    "src.calls.REL_10_23"
  ],
  "statement": "The locked catalogue records 0LP01 in the listed snapshots; the runtime comparison here is limited to PostgreSQL 18.6 and 10.21."
}

messages · message.invalid-grant-dynamic

{
  "limits": "The primary is dynamically assembled from the object and privilege; the example is an observed instantiation, not a static format string.",
  "message_id": "message.invalid-grant-dynamic",
  "path": "",
  "position": 0,
  "raw": {
    "dynamic_format": "errmsg(errormsg, privilege_to_string(priv))",
    "id": "message.invalid-grant-dynamic",
    "limits": "The primary is dynamically assembled from the object and privilege; the example is an observed instantiation, not a static format string.",
    "observed_primary_example": "invalid privilege type INSERT for sequence",
    "primary_template": null,
    "severity_source": "explicit ERROR",
    "sources": [
      "src.acl-invalid-grant-dynamic.18.6",
      "src.acl-invalid-grant-dynamic.10.23"
    ],
    "sqlstate": "0LP01"
  },
  "severity": "explicit ERROR",
  "sources": [
    "src.acl-invalid-grant-dynamic.18.6",
    "src.acl-invalid-grant-dynamic.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "invalid privilege type INSERT for sequence",
      "position": 0,
      "role": "observed",
      "template": "invalid privilege type INSERT for sequence"
    }
  ]
}

runtimes · runtime.0LP01-conn-test-latest.latest · 18.6 (Homebrew) · passed

{
  "cases": [
    "invalid_grant_operation"
  ],
  "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": "0LP01",
        "name": "grant operation SQLSTATE",
        "observed": "0LP01",
        "passed": true
      },
      {
        "expected": "invalid privilege type INSERT for sequence",
        "name": "grant operation diagnostic",
        "observed": "invalid privilege type INSERT for sequence",
        "passed": true
      },
      {
        "expected": "IDLE, USAGE granted, IDLE",
        "name": "valid sequence privilege repairs path",
        "observed": {
          "after_error": "IDLE",
          "final": "IDLE",
          "granted": true
        },
        "passed": true
      }
    ],
    "case_manifest": "verify/cases/0LP01/cases.json",
    "case_manifest_sha256": "da87dfe02737841ad5fcd3bdcf11a3db4d2d47335fbe3f8710603bc66bc0bb39",
    "cases": [
      "invalid_grant_operation"
    ],
    "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/0LP01-conn-test-latest/latest/data",
          "-m",
          "fast",
          "-w",
          "stop"
        ],
        "elapsed_seconds": 0.111,
        "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.0LP01-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": "InvalidGrantOperation",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "invalid privilege type INSERT for sequence",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "aclchk.c",
        "source_function": "ExecuteGrantStmt",
        "source_line": "587",
        "sqlstate": "0LP01",
        "statement_position": null,
        "table_name": null,
        "text": "invalid privilege type INSERT for sequence"
      },
      "role": "u0lp01_4a1b230fc0",
      "statuses": {
        "after_error": "IDLE",
        "final": "IDLE"
      },
      "valid_privilege": "USAGE"
    },
    "raw": "verify/results/0LP01-conn-test-latest/latest/raw.jsonl",
    "raw_sha256": "8ca360f063bded4bb4b1c964f030d855b1d05623576ceab7b9f9df82ecaacf54",
    "run_id": "0LP01-conn-test-latest",
    "server_version": "18.6 (Homebrew)",
    "server_version_num": 180006,
    "snippet_registry": {
      "path": "verify/cases/0LP01/snippets.json",
      "sha256": "4689f3bc44bd388dbca7965d35b4c04903204e66a0e1c6435dbdf950822f0fda"
    },
    "status": "passed",
    "summary": "verify/results/0LP01-conn-test-latest/latest/summary.json",
    "summary_sha256": "7cd561a0a16c3b4a377ce6d684a8c5929a690b05dc92a64e179a1fad18969885",
    "target": "latest"
  },
  "run_id": "0LP01-conn-test-latest",
  "runtime_id": "runtime.0LP01-conn-test-latest.latest",
  "server_version": "18.6 (Homebrew)",
  "status": "passed",
  "target": "latest"
}

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

{
  "cases": [
    "invalid_grant_operation"
  ],
  "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": "0LP01",
        "name": "grant operation SQLSTATE",
        "observed": "0LP01",
        "passed": true
      },
      {
        "expected": "invalid privilege type INSERT for sequence",
        "name": "grant operation diagnostic",
        "observed": "invalid privilege type INSERT for sequence",
        "passed": true
      },
      {
        "expected": "IDLE, USAGE granted, IDLE",
        "name": "valid sequence privilege repairs path",
        "observed": {
          "after_error": "IDLE",
          "final": "IDLE",
          "granted": true
        },
        "passed": true
      }
    ],
    "case_manifest": "verify/cases/0LP01/cases.json",
    "case_manifest_sha256": "da87dfe02737841ad5fcd3bdcf11a3db4d2d47335fbe3f8710603bc66bc0bb39",
    "cases": [
      "invalid_grant_operation"
    ],
    "cleanup": {
      "case": {
        "errors": [],
        "passed": true
      },
      "target_stop": {
        "cleanup": {
          "argv": [
            "/usr/local/bin/docker",
            "rm",
            "-f",
            "-v",
            "sqlstate0lp01_0LP01conntestpg10_pg10"
          ],
          "elapsed_seconds": 0.286,
          "returncode": 0,
          "stderr": "",
          "stdout": "sqlstate0lp01_0LP01conntestpg10_pg10\n"
        },
        "inspect": {
          "argv": [
            "/usr/local/bin/docker",
            "inspect",
            "sqlstate0lp01_0LP01conntestpg10_pg10"
          ],
          "elapsed_seconds": 0.017,
          "returncode": 0,
          "stderr": "",
          "stdout": "[\n    {\n        \"Id\": \"3f395360a945030c44fc65e00b4737c6694f02ed2b3dbb3c7f4e268fe929bf9f\",\n        \"Created\": \"2026-09-09T14:55:21.496591712Z\",\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\": 54592,\n            \"ExitCode\": 0,\n            \"Error\": \"\",\n            \"StartedAt\": \"2026-09-09T14:55:21.569636712Z\",\n            \"FinishedAt\": \"0001-01-01T00:00:00Z\"\n        },\n        \"Image\": \"sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n        \"ResolvConfPath\": \"/var/lib/docker/containers/3f395360a945030c44fc65e00b4737c6694f02ed2b3dbb3c7f4e268fe929bf9f/resolv.conf\",\n        \"HostnamePath\": \"/var/lib/docker/containers/3f395360a945030c44fc65e00b4737c6694f02ed2b3dbb3c7f4e268fe929bf9f/hostname\",\n        \"HostsPath\": \"/var/lib/docker/containers/3f395360a945030c44fc65e00b4737c6694f02ed2b3dbb3c7f4e268fe929bf9f/hosts\",\n        \"LogPath\": \"/var/lib/docker/containers/3f395360a945030c44fc65e00b4737c6694f02ed2b3dbb3c7f4e268fe929bf9f/3f395360a945030c44fc65e00b4737c6694f02ed2b3dbb3c7f4e268fe929bf9f-json.log\",\n        \"Name\": \"/sqlstate0lp01_0LP01conntestpg10_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\": \"33e2f6e51c57806bfa5b036c0e2dd31e9b11184447ea03f73098a8506b5bc3e1\",\n                \"Source\": \"/var/lib/docker/volumes/33e2f6e51c57806bfa5b036c0e2dd31e9b11184447ea03f73098a8506b5bc3e1/_data\",\n                \"Destination\": \"/var/lib/postgresql/data\",\n                \"Driver\": \"local\",\n                \"Mode\": \"\",\n                \"RW\": true,\n                \"Propagation\": \"\"\n            }\n        ],\n        \"Config\": {\n            \"Hostname\": \"3f395360a945\",\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\": \"75440c9096643596c1104b2140b96d6da84a33d5ff91846f458c0e1318d1e3f6\",\n            \"SandboxKey\": \"/var/run/docker/netns/75440c909664\",\n            \"Ports\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"56636\"\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\": \"218862d9ddac6dc90f6bdd63c03e3f99598b07f17a3e794b91f126fec2975621\",\n                    \"Gateway\": \"172.17.0.1\",\n                    \"IPAddress\": \"172.17.0.53\",\n                    \"MacAddress\": \"c6:7c:78:46:55:e8\",\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.0LP01-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": "InvalidGrantOperation",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "invalid privilege type INSERT for sequence",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "aclchk.c",
        "source_function": "ExecuteGrantStmt",
        "source_line": "550",
        "sqlstate": "0LP01",
        "statement_position": null,
        "table_name": null,
        "text": "invalid privilege type INSERT for sequence"
      },
      "role": "u0lp01_5cf42727d1",
      "statuses": {
        "after_error": "IDLE",
        "final": "IDLE"
      },
      "valid_privilege": "USAGE"
    },
    "raw": "verify/results/0LP01-conn-test-pg10/pg10/raw.jsonl",
    "raw_sha256": "948874e5c9479ae408cf528de73c57fb03410e9dc8eb0d3dd8cf8751a6f19c09",
    "run_id": "0LP01-conn-test-pg10",
    "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
    "server_version_num": 100021,
    "snippet_registry": {
      "path": "verify/cases/0LP01/snippets.json",
      "sha256": "4689f3bc44bd388dbca7965d35b4c04903204e66a0e1c6435dbdf950822f0fda"
    },
    "status": "passed",
    "summary": "verify/results/0LP01-conn-test-pg10/pg10/summary.json",
    "summary_sha256": "dca3d6e0e507a3adbe5bc637b52e8c4f503f6cc813872af135ac542ca1312603",
    "target": "pg10"
  },
  "run_id": "0LP01-conn-test-pg10",
  "runtime_id": "runtime.0LP01-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.acl-invalid-grant-dynamic.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/catalog/aclchk.c",
  "position": 3,
  "sha256": "9700258318959b47c42edb423418fb511dd3a008023e732f601eecf4c80868f8",
  "source_id": "src.acl-invalid-grant-dynamic.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/catalog/aclchk.c#L585-L587"
}

sources · src.acl-invalid-grant-dynamic.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/catalog/aclchk.c",
  "position": 4,
  "sha256": "3a4330bd55ea8c0ec12324d7046ec31d64c920f99196235b84612d6cd1a4b26c",
  "source_id": "src.acl-invalid-grant-dynamic.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/catalog/aclchk.c#L548-L550"
}

sources · manifest.0LP01

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/0LP01/cases.json",
  "position": 5,
  "sha256": "da87dfe02737841ad5fcd3bdcf11a3db4d2d47335fbe3f8710603bc66bc0bb39",
  "source_id": "manifest.0LP01",
  "tag": "workspace",
  "url": "verify/cases/0LP01/cases.json"
}

sources · snippet-registry.0LP01

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/0LP01/snippets.json",
  "position": 6,
  "sha256": "4689f3bc44bd388dbca7965d35b4c04903204e66a0e1c6435dbdf950822f0fda",
  "source_id": "snippet-registry.0LP01",
  "tag": "workspace",
  "url": "verify/cases/0LP01/snippets.json"
}

来源引用

原始手册引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:a77d40938c04afc6bcbcb7e794ed1a22e91bb7264f864c9ec2a052bf917c93bd

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