42883 — Undefined function

42883 is undefined_function: lookup found no compatible function for the requested name and input types. The same condition is also used by the parser's undefined-operator branch. The case calls a schema-qualified integer function signature before it exists.

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: undefined_function
lang: en
sqlstate: 42883

Definition PG 18

42883 — Undefined function

At a glance {#at-a-glance}

42883 is undefined_function: lookup found no compatible function for the requested name and input types. The same condition is also used by the parser's undefined-operator branch. The case calls a schema-qualified integer function signature before it exists.

Meaning {#meaning}

The parser resolves name, schema visibility, input types, and overloads together. The selected function group reports function %s does not exist and hints that no function matches the name and argument types; a sibling parse_oper.c branch reports operator does not exist: %s with the corresponding operator hint under the same SQLSTATE. Distinguish 42725 (candidates but ambiguous) and 42846 (a chosen expression cannot be cast). Inspect pg_proc/identity arguments for functions and pg_operator plus operand types for operators. An extension-provided routine or operator may simply be unavailable on this server or version, so availability is part of the diagnosis.

Diagnosis {#diagnosis}

Capture the fully rendered name and signature. Query pg_proc with pg_get_function_identity_arguments for functions, and inspect pg_operator and both operand types for operators. Verify current_schema and search_path without assuming a different path is correct; check whether the object is a function, procedure, operator, or extension-provided feature. For extension/version candidates, inspect installed extension metadata and server_version_num before changing SQL.

Response {#response}

Call the intended signature explicitly, or create that exact function in the intended schema when you own the API. If the missing object is supplied by an extension or newer server feature, install or enable the intended dependency only when it is part of the deployment contract; do not create a substitute merely because the lookup failed. Do not blindly alter search_path or add casts, since they can select another routine or operator. The case creates missing_function(integer) and returns 42. In an explicit transaction, the error leaves INERROR until rollback or a suitable savepoint; the selected autocommit error leaves IDLE.

Observed diagnostics {#messages}

The selected parser function group is explicit ERROR: primary function %s does not exist, hint No function matches the given name and argument types. You might need to add explicit type casts. The source-only operator group is also ERROR: primary operator does not exist: %s; with two known operand types its hint is No operator matches the given name and argument types. You might need to add explicit type casts., while a missing operand uses the singular type form. These are distinct producers sharing 42883.

Representative case {#case}

The runner calls the missing schema-qualified function, checks the expanded signature and state, creates the exact integer signature, and repeats the call.

SELECT syntax_schema.missing_function(41);
CREATE FUNCTION syntax_schema.missing_function(integer) RETURNS integer LANGUAGE SQL AS 'SELECT $1 + 1';
SELECT syntax_schema.missing_function(41);

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.undefined-function.18.6 — src/backend/parser/parse_func.c lines 629–636 at 724edf9bde9d356724ad384a2e196edc3c9f80f7; blob SHA-256 48314eab022297478ac4e49786afaff2621ab7b1d7b50e156668cf477961384f (source).
src.undefined-function.10.23 — src/backend/parser/parse_func.c lines 521–528 at 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; blob SHA-256 f1b4af88565ca01dbad2b244cd26b42f34764b3f1343b22a9231e271fb0742f2 (source).
src.undefined-operator.18.6 — src/backend/parser/parse_oper.c lines 619–644 at 724edf9bde9d356724ad384a2e196edc3c9f80f7; blob SHA-256 3866ce3302c2a4bd22d0f1d113a4bbc627278a618d5e7b83660e36240cbdd0a8 (source).
src.undefined-operator.10.23 — src/backend/parser/parse_oper.c lines 706–728 at 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; blob SHA-256 5802db6d55bdb41f9cad4957384fa2c2ddbb4dc902c33f5f57e8a07760761d10 (source).
src.calls.REL_18_6 / src.calls.REL_10_23 — fixed call scans, SHA-256 9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf / 00d16d3eb01b71ccf1b245c8f3102f9d0ec9f36fb02777b8dd1b99fcb263040c.
manifest.42883 / snippet-registry.42883 — hashes are recorded in evidence/42883.json and each runtime record.

Compare versions

SQLSTATE evidence and recorded runtime versions

cases · missing_function_resolution

{
  "assertions": [
    "SQLSTATE is 42883 and the diagnostic names the missing function signature",
    "The failed autocommit session remains IDLE",
    "Creating the exact integer signature then returns 42"
  ],
  "case_id": "missing_function_resolution",
  "cleanup": "Drop the runner schema and its function.",
  "has_snippet": true,
  "position": 0,
  "preconditions": [
    "A runner-owned disposable target is provisioned."
  ],
  "repair": "Check schema visibility, function/operator name, argument types, and overload resolution; create or call the intended signature rather than blindly changing search_path.",
  "trigger": "Call a schema-qualified function with an integer argument before that signature exists.",
  "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": "42883 is the undefined_function 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.undefined-function.18.6",
    "src.undefined-function.10.23"
  ],
  "statement": "The selected missing_function_resolution follows a resolved PostgreSQL source-call group; other branches can use different dynamic fields."
}

claims · mechanism.reader-boundary

{
  "claim_id": "mechanism.reader-boundary",
  "limits": "The claim describes the selected path and does not generalize to every branch sharing this SQLSTATE.",
  "method": "Combine the selected source call, registry SQL, and passed structured assertions.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.undefined-function.18.6",
    "src.undefined-function.10.23",
    "src.undefined-operator.18.6",
    "src.undefined-operator.10.23",
    "snippet-registry.42883"
  ],
  "statement": "Resolve function or operator name, schema visibility, exact argument types, overloads, and extension/server feature availability before changing search_path or casts."
}

claims · mechanism.operator-resolution

{
  "claim_id": "mechanism.operator-resolution",
  "limits": "The selected runtime exercises the function producer; operator resolution and extension/version availability remain source-only here.",
  "method": "Read the complete fixed op_error branch in both locked parse_oper.c snapshots.",
  "position": 3,
  "runtime": [],
  "sources": [
    "src.undefined-operator.18.6",
    "src.undefined-operator.10.23"
  ],
  "statement": "parse_oper.c reuses 42883 for an unresolved operator and formats the operator signature with a plural or singular operand-type hint depending on which argument types are known."
}

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": 4,
  "runtime": [
    "runtime.syntax2-42883-latest.latest",
    "runtime.syntax2-42883-pg10.pg10"
  ],
  "sources": [
    "manifest.42883",
    "snippet-registry.42883"
  ],
  "statement": "The selected missing_function_resolution 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": 5,
  "runtime": [],
  "sources": [
    "src.errcodes.REL_18_6",
    "src.calls.REL_18_6",
    "src.calls.REL_10_23"
  ],
  "statement": "The locked catalogue records 42883 from the 7.4 presence bound through the listed snapshots; runtime scope is 18.6 and 10.21."
}

messages · message.missing_function_resolution

{
  "limits": "",
  "message_id": "message.missing_function_resolution",
  "path": "",
  "position": 0,
  "raw": {
    "hint_template": "No function matches the given name and argument types. You might need to add explicit type casts.",
    "id": "message.missing_function_resolution",
    "primary_template": "function %s does not exist",
    "severity_source": "explicit ERROR",
    "sources": [
      "src.undefined-function.18.6",
      "src.undefined-function.10.23"
    ],
    "sqlstate": "42883"
  },
  "severity": "explicit ERROR",
  "sources": [
    "src.undefined-function.18.6",
    "src.undefined-function.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "function does not exist",
      "position": 0,
      "role": "",
      "template": "function %s does not exist"
    },
    {
      "kind": "hint",
      "literal": "No function matches the given name and argument types. You might need to add explicit type casts.",
      "position": 1,
      "role": "",
      "template": "No function matches the given name and argument types. You might need to add explicit type casts."
    }
  ]
}

messages · message.missing_operator_resolution

{
  "limits": "",
  "message_id": "message.missing_operator_resolution",
  "path": "",
  "position": 1,
  "raw": {
    "hint_variants": [
      {
        "condition": "both operand types are known",
        "template": "No operator matches the given name and argument types. You might need to add explicit type casts."
      },
      {
        "condition": "one operand type is unknown",
        "template": "No operator matches the given name and argument type. You might need to add an explicit type cast."
      }
    ],
    "id": "message.missing_operator_resolution",
    "primary_template": "operator does not exist: %s",
    "severity_source": "explicit ERROR",
    "sources": [
      "src.undefined-operator.18.6",
      "src.undefined-operator.10.23"
    ],
    "sqlstate": "42883"
  },
  "severity": "explicit ERROR",
  "sources": [
    "src.undefined-operator.18.6",
    "src.undefined-operator.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "operator does not exist:",
      "position": 0,
      "role": "",
      "template": "operator does not exist: %s"
    },
    {
      "kind": "hint",
      "literal": "No operator matches the given name and argument types. You might need to add explicit type casts.",
      "position": 1,
      "role": "",
      "template": "No operator matches the given name and argument types. You might need to add explicit type casts."
    },
    {
      "kind": "hint",
      "literal": "No operator matches the given name and argument type. You might need to add an explicit type cast.",
      "position": 2,
      "role": "",
      "template": "No operator matches the given name and argument type. You might need to add an explicit type cast."
    }
  ]
}

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

{
  "cases": [
    "missing_function_resolution"
  ],
  "limits": "",
  "position": 0,
  "raw": {
    "assertions": [
      {
        "expected": "42883",
        "name": "42883 SQLSTATE",
        "observed": "42883",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "42883 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "missing_function(integer) does not exist",
        "name": "undefined function diagnostic includes name and signature",
        "observed": "function c42883_missing_function_resolution.missing_function(integer) does not exist",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "undefined function leaves autocommit session usable",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "status": "IDLE",
          "value": 42
        },
        "name": "creating the exact integer signature repairs lookup",
        "observed": {
          "error": true,
          "status": "IDLE",
          "value": 42
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.42883",
      "kind": "local_artifact",
      "path": "verify/cases/42883/cases.json",
      "sha256": "93525c5a0711f2feb9107b0b42d678bcb93ea48221f10894788c3b27568f3178",
      "source_role": "case_manifest"
    },
    "cases": [
      "missing_function_resolution"
    ],
    "cleanup": {
      "errors": [],
      "passed": true
    },
    "environment": {
      "TimeZone": "Asia/Shanghai",
      "backend_pid": 29899,
      "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-42883-latest.latest",
    "observed": {
      "connection_autocommit": true,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "UndefinedFunction",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": "No function matches the given name and argument types. You might need to add explicit type casts.",
        "message_primary": "function c42883_missing_function_resolution.missing_function(integer) does not exist",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "parse_func.c",
        "source_function": "ParseFuncOrColumn",
        "source_line": "636",
        "sqlstate": "42883",
        "statement_position": "8",
        "table_name": null,
        "text": "function c42883_missing_function_resolution.missing_function(integer) does not exist\nLINE 1: SELECT \"c42883_missing_function_resolution\".missing_function...\n               ^\nHINT:  No function matches the given name and argument types. You might need to add explicit type casts."
      },
      "failed_status": "IDLE",
      "repair_status": "IDLE",
      "repair_value": 42
    },
    "raw": "verify/results/syntax2-42883-latest/latest/raw.jsonl",
    "raw_sha256": "05d9c68eedf0bf0cbdce86869d7037172b39f1e671883b6e1d69d95ddd882b32",
    "run_id": "syntax2-42883-latest",
    "server_version": "18.6 (Homebrew)",
    "server_version_num": 180006,
    "snippet_registry": {
      "id": "snippet-registry.42883",
      "kind": "local_artifact",
      "path": "verify/cases/42883/snippets.json",
      "sha256": "9b85f7d06d85ecf0a5389f6f507c1b62bbd9c94ab183cb26c0f29d015f90cecc",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/syntax2-42883-latest/latest/summary.json",
    "summary_sha256": "cf925fb0bb74077a48829156d677b2da804f9f12307524991e293765ea70da1e",
    "target": "latest",
    "target_stop": {
      "argv": [
        "/opt/homebrew/Cellar/postgresql@18/18.6/bin/pg_ctl",
        "-D",
        "/Users/vonng/pgcenter/err-code/.cache/runtime/syntax2-42883-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"
    }
  },
  "run_id": "syntax2-42883-latest",
  "runtime_id": "runtime.syntax2-42883-latest.latest",
  "server_version": "18.6 (Homebrew)",
  "status": "passed",
  "target": "latest"
}

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

{
  "cases": [
    "missing_function_resolution"
  ],
  "limits": "",
  "position": 1,
  "raw": {
    "assertions": [
      {
        "expected": "42883",
        "name": "42883 SQLSTATE",
        "observed": "42883",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "42883 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "missing_function(integer) does not exist",
        "name": "undefined function diagnostic includes name and signature",
        "observed": "function c42883_missing_function_resolution.missing_function(integer) does not exist",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "undefined function leaves autocommit session usable",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "status": "IDLE",
          "value": 42
        },
        "name": "creating the exact integer signature repairs lookup",
        "observed": {
          "error": true,
          "status": "IDLE",
          "value": 42
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.42883",
      "kind": "local_artifact",
      "path": "verify/cases/42883/cases.json",
      "sha256": "93525c5a0711f2feb9107b0b42d678bcb93ea48221f10894788c3b27568f3178",
      "source_role": "case_manifest"
    },
    "cases": [
      "missing_function_resolution"
    ],
    "cleanup": {
      "errors": [],
      "passed": true
    },
    "environment": {
      "TimeZone": "Etc/UTC",
      "backend_pid": 79,
      "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-42883-pg10.pg10",
    "observed": {
      "connection_autocommit": true,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "UndefinedFunction",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": "No function matches the given name and argument types. You might need to add explicit type casts.",
        "message_primary": "function c42883_missing_function_resolution.missing_function(integer) does not exist",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "parse_func.c",
        "source_function": "ParseFuncOrColumn",
        "source_line": "528",
        "sqlstate": "42883",
        "statement_position": "8",
        "table_name": null,
        "text": "function c42883_missing_function_resolution.missing_function(integer) does not exist\nLINE 1: SELECT \"c42883_missing_function_resolution\".missing_function...\n               ^\nHINT:  No function matches the given name and argument types. You might need to add explicit type casts."
      },
      "failed_status": "IDLE",
      "repair_status": "IDLE",
      "repair_value": 42
    },
    "raw": "verify/results/syntax2-42883-pg10/pg10/raw.jsonl",
    "raw_sha256": "25a6a146fe2e7f8817e7de1146163ad2a3160930ff323b2ec73c09c91ba792e3",
    "run_id": "syntax2-42883-pg10",
    "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
    "server_version_num": 100021,
    "snippet_registry": {
      "id": "snippet-registry.42883",
      "kind": "local_artifact",
      "path": "verify/cases/42883/snippets.json",
      "sha256": "9b85f7d06d85ecf0a5389f6f507c1b62bbd9c94ab183cb26c0f29d015f90cecc",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/syntax2-42883-pg10/pg10/summary.json",
    "summary_sha256": "9bbf9a4f3ea09105a2419552ea3d117bf5c87bd255e82b5851c60d0256b6fbcf",
    "target": "pg10",
    "target_stop": {
      "cleanup": {
        "argv": [
          "/usr/local/bin/docker",
          "rm",
          "-f",
          "-v",
          "sqlstate42883_syntax242883pg10_pg10"
        ],
        "elapsed_seconds": 0.306,
        "returncode": 0,
        "stderr": "",
        "stdout": "sqlstate42883_syntax242883pg10_pg10\n"
      },
      "inspect": {
        "argv": [
          "/usr/local/bin/docker",
          "inspect",
          "sqlstate42883_syntax242883pg10_pg10"
        ],
        "elapsed_seconds": 0.027,
        "returncode": 0,
        "stderr": "",
        "stdout": "[\n    {\n        \"Id\": \"15ffa60d9f5a929d02b4f4abf0cce5477969d5a3f18109046e30a3a2a4654f7c\",\n        \"Created\": \"2026-09-09T16:40:18.918149127Z\",\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\": 63564,\n            \"ExitCode\": 0,\n            \"Error\": \"\",\n            \"StartedAt\": \"2026-09-09T16:40:18.98895921Z\",\n            \"FinishedAt\": \"0001-01-01T00:00:00Z\"\n        },\n        \"Image\": \"sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n        \"ResolvConfPath\": \"/var/lib/docker/containers/15ffa60d9f5a929d02b4f4abf0cce5477969d5a3f18109046e30a3a2a4654f7c/resolv.conf\",\n        \"HostnamePath\": \"/var/lib/docker/containers/15ffa60d9f5a929d02b4f4abf0cce5477969d5a3f18109046e30a3a2a4654f7c/hostname\",\n        \"HostsPath\": \"/var/lib/docker/containers/15ffa60d9f5a929d02b4f4abf0cce5477969d5a3f18109046e30a3a2a4654f7c/hosts\",\n        \"LogPath\": \"/var/lib/docker/containers/15ffa60d9f5a929d02b4f4abf0cce5477969d5a3f18109046e30a3a2a4654f7c/15ffa60d9f5a929d02b4f4abf0cce5477969d5a3f18109046e30a3a2a4654f7c-json.log\",\n        \"Name\": \"/sqlstate42883_syntax242883pg10_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\": \"42ef8ca21d1480e7df35b45cd92dc9c343255f5017d77574afbbb8ab321e1cc7\",\n                \"Source\": \"/var/lib/docker/volumes/42ef8ca21d1480e7df35b45cd92dc9c343255f5017d77574afbbb8ab321e1cc7/_data\",\n                \"Destination\": \"/var/lib/postgresql/data\",\n                \"Driver\": \"local\",\n                \"Mode\": \"\",\n                \"RW\": true,\n                \"Propagation\": \"\"\n            }\n        ],\n        \"Config\": {\n            \"Hostname\": \"15ffa60d9f5a\",\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\": \"1218f9a4d8d184d51175e7e16a981cddf8ec1a3b19c2381fe8bb261b5974ea56\",\n            \"SandboxKey\": \"/var/run/docker/netns/1218f9a4d8d1\",\n            \"Ports\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"54206\"\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\": \"725ba9a6e763e9f9497e03d31936819fbde0ec034bad0708e951bd54715a2bd8\",\n                    \"Gateway\": \"172.17.0.1\",\n                    \"IPAddress\": \"172.17.0.53\",\n                    \"MacAddress\": \"86:92:85:2b:c9:88\",\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-42883-pg10",
  "runtime_id": "runtime.syntax2-42883-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.undefined-function.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/parser/parse_func.c",
  "position": 3,
  "sha256": "48314eab022297478ac4e49786afaff2621ab7b1d7b50e156668cf477961384f",
  "source_id": "src.undefined-function.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_func.c#L629-L636"
}

sources · src.undefined-function.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/parser/parse_func.c",
  "position": 4,
  "sha256": "f1b4af88565ca01dbad2b244cd26b42f34764b3f1343b22a9231e271fb0742f2",
  "source_id": "src.undefined-function.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/parser/parse_func.c#L521-L528"
}

sources · src.undefined-operator.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/parser/parse_oper.c",
  "position": 5,
  "sha256": "3866ce3302c2a4bd22d0f1d113a4bbc627278a618d5e7b83660e36240cbdd0a8",
  "source_id": "src.undefined-operator.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/parser/parse_oper.c#L619-L644"
}

sources · src.undefined-operator.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/parser/parse_oper.c",
  "position": 6,
  "sha256": "5802db6d55bdb41f9cad4957384fa2c2ddbb4dc902c33f5f57e8a07760761d10",
  "source_id": "src.undefined-operator.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/parser/parse_oper.c#L706-L728"
}

sources · manifest.42883

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/42883/cases.json",
  "position": 7,
  "sha256": "93525c5a0711f2feb9107b0b42d678bcb93ea48221f10894788c3b27568f3178",
  "source_id": "manifest.42883",
  "tag": "",
  "url": ""
}

sources · snippet-registry.42883

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

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:edaf07829cfd330fdbbef7bc48a8f7f688ae4c691b8f5f7752c06689106a4354

Text language: en · english-manuals:edaf07829cfd330fdbbef7bc48a8f7f688ae4c691b8f5f7752c06689106a4354