42846 — Cannot coerce

42846 is cannot_coerce: no applicable cast connects the source and target types. The selected expression asks for integer to date.

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: Syntax Error or Access Rule Violation
condition name: cannot_coerce
lang: en
sqlstate: 42846

Definition PG 18

42846 — Cannot coerce

At a glance {#at-a-glance}

42846 is cannot_coerce: no applicable cast connects the source and target types. The selected expression asks for integer to date.

Meaning {#meaning}

The fixed primary is cannot cast type %s to %s. It is not 22P02 (a bad value for a valid cast) or 42804 (an expression type mismatch in a target context). Inspect pg_cast and the expression context; the selected autocommit connection remains IDLE after the impossible cast.

Diagnosis {#diagnosis}

Read both source and target types from the diagnostic and inspect pg_cast and the expression context. Confirm whether the application needs a typed literal or a documented conversion function.

Response {#response}

Construct a value in the target type or use a documented conversion function. The case uses DATE '2026-01-01'; it does not invent an integer-to-date business mapping or hide input errors with NULLIF. In an explicit transaction, the failed cast leaves INERROR; roll back or return to a suitable savepoint before retrying. The selected autocommit path returns to IDLE.

Observed diagnostics {#messages}

The selected parse_expr.c group is explicit ERROR with primary cannot cast type %s to %s and no detail or hint.

Representative case {#case}

The registry evaluates SELECT 1::integer::date, then a date-typed literal and asserts the exact returned date.

SELECT 1::integer::date;
SELECT DATE '2026-01-01';

The selected 18.6 and 10.21 runs passed SQLSTATE, severity, state/recovery, repair, cleanup, and isolated-target stop assertions. See case JSON and authored evidence; private manifest and registry hashes are recorded there.

Versions {#versions}

The locked catalogue contains this condition from the 7.4 presence bound through the listed snapshots. The selected natural case passed on PostgreSQL 18.6 and 10.21; that bounded result does not infer every intermediate release or every source branch.

Related {#related}

Sources {#sources}

src.errcodes.REL_18_6 — fixed definition at 724edf9bde9d356724ad384a2e196edc3c9f80f7; SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba (source).
src.cannot-coerce.18.6 — src/backend/parser/parse_expr.c lines 2782–2787 at 724edf9bde9d356724ad384a2e196edc3c9f80f7; blob SHA-256 63c37770872a08978f931c31f801666a08e3bc8e51c2c65ff60151a1d139d55b (source).
src.cannot-coerce.10.23 — src/backend/parser/parse_expr.c lines 2739–2744 at 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; blob SHA-256 2700ba4a37d0715b66be76c900c7da7cf6a4d818eb71178e7b9a51e48e59e136 (source).
src.calls.REL_18_6 / src.calls.REL_10_23 — fixed call scans, SHA-256 9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf / 00d16d3eb01b71ccf1b245c8f3102f9d0ec9f36fb02777b8dd1b99fcb263040c.
manifest.42846 / snippet-registry.42846 — hashes are recorded in evidence/42846.json and each runtime record.

Compare versions

SQLSTATE evidence and recorded runtime versions

cases · impossible_cast

{
  "assertions": [
    "SQLSTATE is 42846 with cannot cast type integer to date",
    "The failed autocommit session remains IDLE",
    "A date-typed literal returns the intended date"
  ],
  "case_id": "impossible_cast",
  "cleanup": "Close the runner connection; no persistent objects are created.",
  "has_snippet": true,
  "position": 0,
  "preconditions": [
    "A runner-owned disposable target is provisioned."
  ],
  "repair": "Use a source type with a documented cast or construct a value in the target type; changing an input string is not the same as making an impossible type cast valid.",
  "trigger": "Explicitly cast an integer expression to date.",
  "versions": [
    "10",
    "18"
  ]
}

claims · identity.class-and-condition

{
  "claim_id": "identity.class-and-condition",
  "limits": "Identity does not identify every backend call that can reuse this SQLSTATE.",
  "method": "Read fixed errcodes.txt and locked catalogue metadata.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.REL_18_6"
  ],
  "statement": "42846 is the cannot_coerce condition in Class 42."
}

claims · mechanism.selected-source-path

{
  "claim_id": "mechanism.selected-source-path",
  "limits": "This is one mechanism boundary, not an exhaustive inventory of the code.",
  "method": "Trace the REL_18_6 and REL_10_23 source-call records at the locked commits.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.cannot-coerce.18.6",
    "src.cannot-coerce.10.23"
  ],
  "statement": "The selected impossible_cast follows a resolved PostgreSQL source-call group; other branches can use different dynamic fields."
}

claims · runtime.representative-case

{
  "claim_id": "runtime.representative-case",
  "limits": "Scope is limited to these statements, psycopg, and two versions.",
  "method": "Run the shared SQL registry and inspect SQLSTATE, severity, state, repair, cleanup, and target stop.",
  "position": 2,
  "runtime": [
    "runtime.syntax2-42846-latest.latest",
    "runtime.syntax2-42846-pg10.pg10"
  ],
  "sources": [
    "manifest.42846",
    "snippet-registry.42846"
  ],
  "statement": "The selected impossible_cast passed on isolated PostgreSQL 18.6 and 10.21 targets."
}

claims · versions.catalogue-boundary

{
  "claim_id": "versions.catalogue-boundary",
  "limits": "Definition presence is not an exact behavioral introduction; two runtime versions do not prove every intermediate behavior.",
  "method": "Read generated facts, fixed calls, and selected summaries.",
  "position": 3,
  "runtime": [],
  "sources": [
    "src.errcodes.REL_18_6",
    "src.calls.REL_18_6",
    "src.calls.REL_10_23"
  ],
  "statement": "The locked catalogue records 42846 from the 7.4 presence bound through the listed snapshots; runtime scope is 18.6 and 10.21."
}

messages · message.impossible_cast

{
  "limits": "",
  "message_id": "message.impossible_cast",
  "path": "",
  "position": 0,
  "raw": {
    "id": "message.impossible_cast",
    "primary_template": "cannot cast type %s to %s",
    "severity_source": "explicit ERROR",
    "sources": [
      "src.cannot-coerce.18.6",
      "src.cannot-coerce.10.23"
    ],
    "sqlstate": "42846"
  },
  "severity": "explicit ERROR",
  "sources": [
    "src.cannot-coerce.18.6",
    "src.cannot-coerce.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "cannot cast type to",
      "position": 0,
      "role": "",
      "template": "cannot cast type %s to %s"
    }
  ]
}

runtimes · runtime.syntax2-42846-latest.latest · 18.6 (Homebrew) · passed

{
  "cases": [
    "impossible_cast"
  ],
  "limits": "",
  "position": 0,
  "raw": {
    "assertions": [
      {
        "expected": "42846",
        "name": "42846 SQLSTATE",
        "observed": "42846",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "42846 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "cannot cast type integer to date",
        "name": "42846 primary diagnostic",
        "observed": "cannot cast type integer to date",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "cannot-coerce error leaves autocommit session usable",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "status": "IDLE",
          "value": "2026-01-01"
        },
        "name": "a date-typed literal repairs the expression",
        "observed": {
          "error": true,
          "status": "IDLE",
          "value": "2026-01-01"
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.42846",
      "kind": "local_artifact",
      "path": "verify/cases/42846/cases.json",
      "sha256": "a73e8b18ce3528c5b74b6770883b20751d98545f358e3fcd64094017f704834d",
      "source_role": "case_manifest"
    },
    "cases": [
      "impossible_cast"
    ],
    "cleanup": {
      "errors": [],
      "passed": true
    },
    "environment": {
      "TimeZone": "Asia/Shanghai",
      "backend_pid": 30179,
      "binary": {
        "bindir": "/opt/homebrew/Cellar/postgresql@18/18.6/bin",
        "pg_config": "/opt/homebrew/bin/pg_config",
        "pg_config_version": "PostgreSQL 18.6 (Homebrew)",
        "postgres": "/opt/homebrew/Cellar/postgresql@18/18.6/bin/postgres"
      },
      "connection_scope": "runner-owned localhost port",
      "current_user": "runner",
      "docker": {},
      "lc_messages": "C",
      "libpq_version": "18.6",
      "locale": "C.UTF-8",
      "log_destination": "csvlog,jsonlog",
      "log_error_verbosity": "verbose",
      "log_min_error_statement": "error",
      "log_min_messages": "error",
      "logging_collector": "on",
      "machine": "arm64",
      "max_connections": "100",
      "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_encoding": "UTF8",
      "server_version": "18.6 (Homebrew)",
      "server_version_num": "180006",
      "target_kind": "latest",
      "wal_level": "logical"
    },
    "id": "runtime.syntax2-42846-latest.latest",
    "observed": {
      "connection_autocommit": true,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "CannotCoerce",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "cannot cast type integer to date",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "parse_expr.c",
        "source_function": "transformTypeCast",
        "source_line": "2787",
        "sqlstate": "42846",
        "statement_position": "18",
        "table_name": null,
        "text": "cannot cast type integer to date\nLINE 1: SELECT 1::integer::date\n                         ^"
      },
      "failed_status": "IDLE",
      "repair_status": "IDLE",
      "repair_value": "2026-01-01"
    },
    "raw": "verify/results/syntax2-42846-latest/latest/raw.jsonl",
    "raw_sha256": "af5badedd6f7288418b8d1458b0f50c1fbf8c8a4e1ebe0320df63427071dcff2",
    "run_id": "syntax2-42846-latest",
    "server_version": "18.6 (Homebrew)",
    "server_version_num": 180006,
    "snippet_registry": {
      "id": "snippet-registry.42846",
      "kind": "local_artifact",
      "path": "verify/cases/42846/snippets.json",
      "sha256": "8c6c979d843ec594c5a9f0a4cc6660713b468a48814f71bd5a4eb8c539aa4c11",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/syntax2-42846-latest/latest/summary.json",
    "summary_sha256": "8cf837715d9427be31279c7369844643aa7a0c7fb9a06d1cda21dc864910ad9c",
    "target": "latest",
    "target_stop": {
      "argv": [
        "/opt/homebrew/Cellar/postgresql@18/18.6/bin/pg_ctl",
        "-D",
        "/Users/vonng/pgcenter/err-code/.cache/runtime/syntax2-42846-latest/latest/data",
        "-m",
        "fast",
        "-w",
        "stop"
      ],
      "elapsed_seconds": 0.115,
      "returncode": 0,
      "stderr": "",
      "stdout": "waiting for server to shut down.... done\nserver stopped\n"
    }
  },
  "run_id": "syntax2-42846-latest",
  "runtime_id": "runtime.syntax2-42846-latest.latest",
  "server_version": "18.6 (Homebrew)",
  "status": "passed",
  "target": "latest"
}

runtimes · runtime.syntax2-42846-pg10.pg10 · 10.21 (Debian 10.21-1.pgdg90+1) · passed

{
  "cases": [
    "impossible_cast"
  ],
  "limits": "",
  "position": 1,
  "raw": {
    "assertions": [
      {
        "expected": "42846",
        "name": "42846 SQLSTATE",
        "observed": "42846",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "42846 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "cannot cast type integer to date",
        "name": "42846 primary diagnostic",
        "observed": "cannot cast type integer to date",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "cannot-coerce error leaves autocommit session usable",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "status": "IDLE",
          "value": "2026-01-01"
        },
        "name": "a date-typed literal repairs the expression",
        "observed": {
          "error": true,
          "status": "IDLE",
          "value": "2026-01-01"
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.42846",
      "kind": "local_artifact",
      "path": "verify/cases/42846/cases.json",
      "sha256": "a73e8b18ce3528c5b74b6770883b20751d98545f358e3fcd64094017f704834d",
      "source_role": "case_manifest"
    },
    "cases": [
      "impossible_cast"
    ],
    "cleanup": {
      "errors": [],
      "passed": true
    },
    "environment": {
      "TimeZone": "Etc/UTC",
      "backend_pid": 80,
      "binary": {},
      "connection_scope": "runner-owned localhost port",
      "current_user": "postgres",
      "docker": {
        "architecture": "arm64",
        "command": "/usr/local/bin/docker",
        "digest": "sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc",
        "id": "sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc",
        "image": "postgres:10",
        "image_created": "2022-06-23T09:11:18.374607054Z",
        "image_ref": "postgres@sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc",
        "log_destination": "csvlog",
        "os": "linux",
        "repo_digests": [
          "postgres@sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc"
        ]
      },
      "lc_messages": "en_US.utf8",
      "libpq_version": "18.6",
      "locale": "C.UTF-8",
      "log_destination": "csvlog",
      "log_error_verbosity": "verbose",
      "log_min_error_statement": "error",
      "log_min_messages": "error",
      "logging_collector": "on",
      "machine": "arm64",
      "max_connections": "100",
      "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_encoding": "UTF8",
      "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
      "server_version_num": "100021",
      "target_kind": "pg10",
      "wal_level": "logical"
    },
    "id": "runtime.syntax2-42846-pg10.pg10",
    "observed": {
      "connection_autocommit": true,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "CannotCoerce",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "cannot cast type integer to date",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "parse_expr.c",
        "source_function": "transformTypeCast",
        "source_line": "2735",
        "sqlstate": "42846",
        "statement_position": "18",
        "table_name": null,
        "text": "cannot cast type integer to date\nLINE 1: SELECT 1::integer::date\n                         ^"
      },
      "failed_status": "IDLE",
      "repair_status": "IDLE",
      "repair_value": "2026-01-01"
    },
    "raw": "verify/results/syntax2-42846-pg10/pg10/raw.jsonl",
    "raw_sha256": "d13f9e7e174d96b9c470b3520adcbe008e9b6a4b3abf755700e80c3f6d32705f",
    "run_id": "syntax2-42846-pg10",
    "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
    "server_version_num": 100021,
    "snippet_registry": {
      "id": "snippet-registry.42846",
      "kind": "local_artifact",
      "path": "verify/cases/42846/snippets.json",
      "sha256": "8c6c979d843ec594c5a9f0a4cc6660713b468a48814f71bd5a4eb8c539aa4c11",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/syntax2-42846-pg10/pg10/summary.json",
    "summary_sha256": "008de923b32d0df980d398c51d793a1d422be893b830f3728af333a5889bad9b",
    "target": "pg10",
    "target_stop": {
      "cleanup": {
        "argv": [
          "/usr/local/bin/docker",
          "rm",
          "-f",
          "-v",
          "sqlstate42846_syntax242846pg10_pg10"
        ],
        "elapsed_seconds": 0.303,
        "returncode": 0,
        "stderr": "",
        "stdout": "sqlstate42846_syntax242846pg10_pg10\n"
      },
      "inspect": {
        "argv": [
          "/usr/local/bin/docker",
          "inspect",
          "sqlstate42846_syntax242846pg10_pg10"
        ],
        "elapsed_seconds": 0.029,
        "returncode": 0,
        "stderr": "",
        "stdout": "[\n    {\n        \"Id\": \"5309521c77165a404061c4f8d4c4b3c4d579e895134aaac3d859743df43ac48d\",\n        \"Created\": \"2026-09-09T16:40:17.461559001Z\",\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\": 63391,\n            \"ExitCode\": 0,\n            \"Error\": \"\",\n            \"StartedAt\": \"2026-09-09T16:40:17.529231335Z\",\n            \"FinishedAt\": \"0001-01-01T00:00:00Z\"\n        },\n        \"Image\": \"sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n        \"ResolvConfPath\": \"/var/lib/docker/containers/5309521c77165a404061c4f8d4c4b3c4d579e895134aaac3d859743df43ac48d/resolv.conf\",\n        \"HostnamePath\": \"/var/lib/docker/containers/5309521c77165a404061c4f8d4c4b3c4d579e895134aaac3d859743df43ac48d/hostname\",\n        \"HostsPath\": \"/var/lib/docker/containers/5309521c77165a404061c4f8d4c4b3c4d579e895134aaac3d859743df43ac48d/hosts\",\n        \"LogPath\": \"/var/lib/docker/containers/5309521c77165a404061c4f8d4c4b3c4d579e895134aaac3d859743df43ac48d/5309521c77165a404061c4f8d4c4b3c4d579e895134aaac3d859743df43ac48d-json.log\",\n        \"Name\": \"/sqlstate42846_syntax242846pg10_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\": \"d69a6c7b6d23752f23ed2bb89fddab02714f95f47ac1c369f1176201f3976c25\",\n                \"Source\": \"/var/lib/docker/volumes/d69a6c7b6d23752f23ed2bb89fddab02714f95f47ac1c369f1176201f3976c25/_data\",\n                \"Destination\": \"/var/lib/postgresql/data\",\n                \"Driver\": \"local\",\n                \"Mode\": \"\",\n                \"RW\": true,\n                \"Propagation\": \"\"\n            }\n        ],\n        \"Config\": {\n            \"Hostname\": \"5309521c7716\",\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\": \"2ed350aa8337298416aba18d1d57336a15b1b744d2397b2cccb5f847eb9364ce\",\n            \"SandboxKey\": \"/var/run/docker/netns/2ed350aa8337\",\n            \"Ports\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"54192\"\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\": \"f510f611c5594d34cc4e82c31453e19635f53980adc78f541d19252ac5b41bf7\",\n                    \"Gateway\": \"172.17.0.1\",\n                    \"IPAddress\": \"172.17.0.53\",\n                    \"MacAddress\": \"5e:f3:db:79:e7:fb\",\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"
      }
    }
  },
  "run_id": "syntax2-42846-pg10",
  "runtime_id": "runtime.syntax2-42846-pg10.pg10",
  "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
  "status": "passed",
  "target": "pg10"
}

sources · src.errcodes.REL_18_6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/utils/errcodes.txt",
  "position": 0,
  "sha256": "6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba",
  "source_id": "src.errcodes.REL_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": "",
  "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": "",
  "url": ""
}

sources · src.cannot-coerce.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/parser/parse_expr.c",
  "position": 3,
  "sha256": "63c37770872a08978f931c31f801666a08e3bc8e51c2c65ff60151a1d139d55b",
  "source_id": "src.cannot-coerce.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_expr.c#L2782-L2787"
}

sources · src.cannot-coerce.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/parser/parse_expr.c",
  "position": 4,
  "sha256": "2700ba4a37d0715b66be76c900c7da7cf6a4d818eb71178e7b9a51e48e59e136",
  "source_id": "src.cannot-coerce.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/parser/parse_expr.c#L2739-L2744"
}

sources · manifest.42846

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/42846/cases.json",
  "position": 5,
  "sha256": "a73e8b18ce3528c5b74b6770883b20751d98545f358e3fcd64094017f704834d",
  "source_id": "manifest.42846",
  "tag": "",
  "url": ""
}

sources · snippet-registry.42846

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/42846/snippets.json",
  "position": 6,
  "sha256": "8c6c979d843ec594c5a9f0a4cc6660713b468a48814f71bd5a4eb8c539aa4c11",
  "source_id": "snippet-registry.42846",
  "tag": "",
  "url": ""
}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:1b61bc930ad916bcbce99b896ac27e90f30eadeece761afca11aa4d62cd6c352

Text language: en · english-manuals:1b61bc930ad916bcbce99b896ac27e90f30eadeece761afca11aa4d62cd6c352