0LP01 — invalid_grant_operation

SQLSTATE 0LP01 is invalid_grant_operation in Class 0L. 0LP01 means that the GRANT or REVOKE operation is invalid for the object or privilege. The selected sequence case asks for INSERT, which is rejected with the dynamically assembled primary invalid privilege type INSERT for sequence; granting USAGE then succeeds.

English manual coverage begins with PostgreSQL 8.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

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: Unknown
class name: Invalid Grantor
condition name: invalid_grant_operation
lang: en
sqlstate: 0LP01

Definition PG 18

0LP01

At a glance {#at-a-glance}

SQLSTATE 0LP01 is invalid_grant_operation in Class 0L. 0LP01 means that the GRANT or REVOKE operation is invalid for the object or privilege. The selected sequence case asks for INSERT, which is rejected with the dynamically assembled primary invalid privilege type INSERT for sequence; granting USAGE then succeeds.

Meaning {#meaning}

0LP01 means that the GRANT or REVOKE operation is invalid for the object or privilege. The selected sequence case asks for INSERT, which is rejected with the dynamically assembled primary invalid privilege type INSERT for sequence; granting USAGE then succeeds.

Diagnosis {#diagnosis}

Check object kind, privilege matrix, target role, ownership, and whether the statement is a column/default-privilege form. The selected error is an ERROR but leaves the autocommit session IDLE; the post-repair privilege check returns true.

Response {#response}

Rewrite the statement for the object’s supported privileges and verify the resulting ACL. For a sequence, choose the intended USAGE, SELECT, or UPDATE privilege; do not grant a broader privilege or retry unchanged.

Observed diagnostics {#messages}

The structured evidence preserves the message template or dynamic assembly boundary. For this page, do not treat a client exception without a server diagnostic as proof of 0LP01.

Representative case {#case}

The SQL block creates a sequence, attempts the invalid INSERT privilege, grants USAGE, and verifies the effective privilege for the disposable role.

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');

The selected 18.6 run reports SQLSTATE 0LP01, primary invalid privilege type INSERT for sequence, and the asserted recovery state is IDLE before the final probe/repair. Every assertion and cleanup passed on 18.6 and 10.21.

The downloadable case and evidence projections are 0LP01 case JSON and authored evidence. The runner manifest is verify/cases/0LP01/cases.json; the page SQL is checked against its shared registry before publication.

Versions {#versions}

The generated facts table records the locked catalogue snapshots and earliest observed definition. The selected natural runtime scope is PostgreSQL 18.6 and 10.21; this does not infer behavior for every intermediate release.

Related {#related}

Sources {#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.

Compare versions

SQLSTATE evidence and recorded runtime versions

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"
}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:a77d40938c04afc6bcbcb7e794ed1a22e91bb7264f864c9ec2a052bf917c93bd

Text language: en · english-manuals:a77d40938c04afc6bcbcb7e794ed1a22e91bb7264f864c9ec2a052bf917c93bd