42710 — Duplicate object

42710 is duplicate_object: a definition collides with an occupied object name. The selected path is a second CREATE TYPE ... AS ENUM; the same SQLSTATE is reused by other object-definition paths, so first identify the object kind and schema.

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: duplicate_object
lang: en
sqlstate: 42710

Definition PG 18

42710 — Duplicate object

At a glance {#at-a-glance}

42710 is duplicate_object: a definition collides with an occupied object name. The selected path is a second CREATE TYPE ... AS ENUM; the same SQLSTATE is reused by other object-definition paths, so first identify the object kind and schema.

Meaning {#meaning}

The DefineEnum path reports type "%s" already exists; this is a catalog-definition collision, not a row-level unique violation. CREATE OR REPLACE is not a universal repair. Inspect pg_type joined to pg_namespace, ownership, and migration order. The selected autocommit error leaves IDLE; an explicit transaction must be rolled back before more commands.

Diagnosis {#diagnosis}

Inspect the exact object kind and schema first. For a type, query pg_type joined to pg_namespace; for a relation use to_regclass, and for a routine inspect pg_proc and pg_get_function_identity_arguments. Check ownership and migration order.

Response {#response}

Choose an intentionally free name, or use an object-specific alter/replace operation only when the existing owner is yours. The case repairs by creating a distinct ENUM. A preflight check does not remove a concurrent-create race, and dropping an unknown object is unsafe. In an explicit transaction, the failed definition leaves INERROR; roll back or return to a suitable savepoint before retrying. The selected autocommit case remains IDLE.

Observed diagnostics {#messages}

CREATE TYPE in this ENUM branch has explicit ERROR severity and no hint; other 42710 branches have different templates, including a heap.c relation/type hint that does not belong here.

Representative case {#case}

This disposable case creates an ENUM, repeats its definition, checks the code and state, then creates a distinct type and verifies both catalog entries.

CREATE TYPE syntax_schema.duplicate_object_type AS ENUM ('first');
CREATE TYPE syntax_schema.duplicate_object_type AS ENUM ('first');
CREATE TYPE syntax_schema.duplicate_object_type_repaired AS ENUM ('first');
SELECT count(*) FROM pg_type t JOIN pg_namespace n ON n.oid = t.typnamespace WHERE n.nspname = 'syntax_schema_name' AND t.typname IN ('duplicate_object_type', 'duplicate_object_type_repaired');

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.duplicate-enum.18.6 — src/backend/commands/typecmds.c lines 1219–1221 at 724edf9bde9d356724ad384a2e196edc3c9f80f7; blob SHA-256 60d1e9754646e100f6b74aa367ad8c2c52386c400df721707423d329209c47eb (source).
src.duplicate-enum.10.23 — src/backend/commands/typecmds.c lines 1139–1141 at 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; blob SHA-256 fa1dfb766f7a3117eb677461ede774d5ba7c25324cbbd2a200435fa9c9c8e863 (source).
src.calls.REL_18_6 / src.calls.REL_10_23 — fixed call scans, SHA-256 9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf / 00d16d3eb01b71ccf1b245c8f3102f9d0ec9f36fb02777b8dd1b99fcb263040c.
manifest.42710 / snippet-registry.42710 — hashes are recorded in evidence/42710.json and each runtime record.

Compare versions

SQLSTATE evidence and recorded runtime versions

cases · duplicate_object_type

{
  "assertions": [
    "SQLSTATE is 42710 with the duplicate type message and its naming hint",
    "The failed autocommit session remains IDLE",
    "Creating a nonconflicting type and inspecting pg_type succeeds"
  ],
  "case_id": "duplicate_object_type",
  "cleanup": "Drop the runner schema and all types it owns.",
  "has_snippet": true,
  "position": 0,
  "preconditions": [
    "A runner-owned disposable target is provisioned."
  ],
  "repair": "Use a distinct type name after confirming the existing type; do not drop an unknown owner's object.",
  "trigger": "Create the same ENUM type name twice in the runner schema.",
  "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": "42710 is the duplicate_object 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.duplicate-enum.18.6",
    "src.duplicate-enum.10.23"
  ],
  "statement": "The selected duplicate_object_type 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.duplicate-enum.18.6",
    "src.duplicate-enum.10.23",
    "snippet-registry.42710"
  ],
  "statement": "ENUM type definitions collide by name; inspect pg_type/pg_namespace and use a deliberate distinct name."
}

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

messages · message.duplicate_object_type

{
  "limits": "",
  "message_id": "message.duplicate_object_type",
  "path": "",
  "position": 0,
  "raw": {
    "id": "message.duplicate_object_type",
    "primary_template": "type \"%s\" already exists",
    "severity_source": "explicit ERROR",
    "sources": [
      "src.duplicate-enum.18.6",
      "src.duplicate-enum.10.23"
    ],
    "sqlstate": "42710"
  },
  "severity": "explicit ERROR",
  "sources": [
    "src.duplicate-enum.18.6",
    "src.duplicate-enum.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "type \" \" already exists",
      "position": 0,
      "role": "",
      "template": "type \"%s\" already exists"
    }
  ]
}

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

{
  "cases": [
    "duplicate_object_type"
  ],
  "limits": "",
  "position": 0,
  "raw": {
    "assertions": [
      {
        "expected": "42710",
        "name": "42710 SQLSTATE",
        "observed": "42710",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "42710 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "type \"duplicate_object_type\" already exists",
        "name": "42710 primary diagnostic",
        "observed": "type \"duplicate_object_type\" already exists",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "duplicate type leaves autocommit session usable",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "status": "IDLE",
          "types": 2
        },
        "name": "nonconflicting type name repairs definition",
        "observed": {
          "error": true,
          "status": "IDLE",
          "types": 2
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.42710",
      "kind": "local_artifact",
      "path": "verify/cases/42710/cases.json",
      "sha256": "e1a0995c62ad92498ded1bd168d5473c915f688f4e932ea5d1ead43323444ebb",
      "source_role": "case_manifest"
    },
    "cases": [
      "duplicate_object_type"
    ],
    "cleanup": {
      "errors": [],
      "passed": true
    },
    "environment": {
      "TimeZone": "Asia/Shanghai",
      "backend_pid": 29705,
      "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-42710-latest2.latest",
    "observed": {
      "connection_autocommit": true,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "DuplicateObject",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "type \"duplicate_object_type\" already exists",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "typecmds.c",
        "source_function": "DefineEnum",
        "source_line": "1221",
        "sqlstate": "42710",
        "statement_position": null,
        "table_name": null,
        "text": "type \"duplicate_object_type\" already exists"
      },
      "failed_status": "IDLE",
      "repair_status": "IDLE",
      "type_count": 2
    },
    "raw": "verify/results/syntax2-42710-latest2/latest/raw.jsonl",
    "raw_sha256": "8ea85c4db8480cc96261acfd58ac9ff67c0f95ea73d5ca59889c909883829782",
    "run_id": "syntax2-42710-latest2",
    "server_version": "18.6 (Homebrew)",
    "server_version_num": 180006,
    "snippet_registry": {
      "id": "snippet-registry.42710",
      "kind": "local_artifact",
      "path": "verify/cases/42710/snippets.json",
      "sha256": "4dbc1b9fe7efb15ec5ff4bcb2a31e9335c9e9df1fdd51ab494917007f52ce3c5",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/syntax2-42710-latest2/latest/summary.json",
    "summary_sha256": "dba3c477be2c7d8c1c6e9256f75617cb8f300c761981c88f5905c9af53fb4a33",
    "target": "latest",
    "target_stop": {
      "argv": [
        "/opt/homebrew/Cellar/postgresql@18/18.6/bin/pg_ctl",
        "-D",
        "/Users/vonng/pgcenter/err-code/.cache/runtime/syntax2-42710-latest2/latest/data",
        "-m",
        "fast",
        "-w",
        "stop"
      ],
      "elapsed_seconds": 0.112,
      "returncode": 0,
      "stderr": "",
      "stdout": "waiting for server to shut down.... done\nserver stopped\n"
    }
  },
  "run_id": "syntax2-42710-latest2",
  "runtime_id": "runtime.syntax2-42710-latest2.latest",
  "server_version": "18.6 (Homebrew)",
  "status": "passed",
  "target": "latest"
}

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

{
  "cases": [
    "duplicate_object_type"
  ],
  "limits": "",
  "position": 1,
  "raw": {
    "assertions": [
      {
        "expected": "42710",
        "name": "42710 SQLSTATE",
        "observed": "42710",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "42710 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "type \"duplicate_object_type\" already exists",
        "name": "42710 primary diagnostic",
        "observed": "type \"duplicate_object_type\" already exists",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "duplicate type leaves autocommit session usable",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "status": "IDLE",
          "types": 2
        },
        "name": "nonconflicting type name repairs definition",
        "observed": {
          "error": true,
          "status": "IDLE",
          "types": 2
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.42710",
      "kind": "local_artifact",
      "path": "verify/cases/42710/cases.json",
      "sha256": "e1a0995c62ad92498ded1bd168d5473c915f688f4e932ea5d1ead43323444ebb",
      "source_role": "case_manifest"
    },
    "cases": [
      "duplicate_object_type"
    ],
    "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-42710-pg10.pg10",
    "observed": {
      "connection_autocommit": true,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "DuplicateObject",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "type \"duplicate_object_type\" already exists",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "typecmds.c",
        "source_function": "DefineEnum",
        "source_line": "1141",
        "sqlstate": "42710",
        "statement_position": null,
        "table_name": null,
        "text": "type \"duplicate_object_type\" already exists"
      },
      "failed_status": "IDLE",
      "repair_status": "IDLE",
      "type_count": 2
    },
    "raw": "verify/results/syntax2-42710-pg10/pg10/raw.jsonl",
    "raw_sha256": "a66df6911c3b1985953a097e11cdd5015be79742b4baf3e295bc6cf5e194d2b4",
    "run_id": "syntax2-42710-pg10",
    "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
    "server_version_num": 100021,
    "snippet_registry": {
      "id": "snippet-registry.42710",
      "kind": "local_artifact",
      "path": "verify/cases/42710/snippets.json",
      "sha256": "4dbc1b9fe7efb15ec5ff4bcb2a31e9335c9e9df1fdd51ab494917007f52ce3c5",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/syntax2-42710-pg10/pg10/summary.json",
    "summary_sha256": "f334cd92f6f8b68f32cf54c2f2c94733e9560d6c3a4a6a655ebcbda633e73ce5",
    "target": "pg10",
    "target_stop": {
      "cleanup": {
        "argv": [
          "/usr/local/bin/docker",
          "rm",
          "-f",
          "-v",
          "sqlstate42710_syntax242710pg10_pg10"
        ],
        "elapsed_seconds": 0.284,
        "returncode": 0,
        "stderr": "",
        "stdout": "sqlstate42710_syntax242710pg10_pg10\n"
      },
      "inspect": {
        "argv": [
          "/usr/local/bin/docker",
          "inspect",
          "sqlstate42710_syntax242710pg10_pg10"
        ],
        "elapsed_seconds": 0.019,
        "returncode": 0,
        "stderr": "",
        "stdout": "[\n    {\n        \"Id\": \"eae5e7ed2ee2a1ce3d4c7adc62ca55b40e46da008f5754aa3335cacf714ddc8c\",\n        \"Created\": \"2026-09-09T16:39:55.588704797Z\",\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\": 61978,\n            \"ExitCode\": 0,\n            \"Error\": \"\",\n            \"StartedAt\": \"2026-09-09T16:39:55.676537255Z\",\n            \"FinishedAt\": \"0001-01-01T00:00:00Z\"\n        },\n        \"Image\": \"sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n        \"ResolvConfPath\": \"/var/lib/docker/containers/eae5e7ed2ee2a1ce3d4c7adc62ca55b40e46da008f5754aa3335cacf714ddc8c/resolv.conf\",\n        \"HostnamePath\": \"/var/lib/docker/containers/eae5e7ed2ee2a1ce3d4c7adc62ca55b40e46da008f5754aa3335cacf714ddc8c/hostname\",\n        \"HostsPath\": \"/var/lib/docker/containers/eae5e7ed2ee2a1ce3d4c7adc62ca55b40e46da008f5754aa3335cacf714ddc8c/hosts\",\n        \"LogPath\": \"/var/lib/docker/containers/eae5e7ed2ee2a1ce3d4c7adc62ca55b40e46da008f5754aa3335cacf714ddc8c/eae5e7ed2ee2a1ce3d4c7adc62ca55b40e46da008f5754aa3335cacf714ddc8c-json.log\",\n        \"Name\": \"/sqlstate42710_syntax242710pg10_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\": \"8cd9cb696f498fac43da42375332185b9038ae516104c96989100fb922031fa5\",\n                \"Source\": \"/var/lib/docker/volumes/8cd9cb696f498fac43da42375332185b9038ae516104c96989100fb922031fa5/_data\",\n                \"Destination\": \"/var/lib/postgresql/data\",\n                \"Driver\": \"local\",\n                \"Mode\": \"\",\n                \"RW\": true,\n                \"Propagation\": \"\"\n            }\n        ],\n        \"Config\": {\n            \"Hostname\": \"eae5e7ed2ee2\",\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\": \"a5c7381d8e61e8ecd17de61a57d1f8114d5528ee43b7c0e17e73fbc760b8c26f\",\n            \"SandboxKey\": \"/var/run/docker/netns/a5c7381d8e61\",\n            \"Ports\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"54033\"\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\": \"88c29bf9c4f23d1669823973e5c6ee202d3cfbbaf1bf4d55f643a8be318bedcc\",\n                    \"Gateway\": \"172.17.0.1\",\n                    \"IPAddress\": \"172.17.0.53\",\n                    \"MacAddress\": \"3a:8f:29:1f:77:54\",\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-42710-pg10",
  "runtime_id": "runtime.syntax2-42710-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.duplicate-enum.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/typecmds.c",
  "position": 3,
  "sha256": "60d1e9754646e100f6b74aa367ad8c2c52386c400df721707423d329209c47eb",
  "source_id": "src.duplicate-enum.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/typecmds.c#L1219-L1221"
}

sources · src.duplicate-enum.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/typecmds.c",
  "position": 4,
  "sha256": "fa1dfb766f7a3117eb677461ede774d5ba7c25324cbbd2a200435fa9c9c8e863",
  "source_id": "src.duplicate-enum.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/commands/typecmds.c#L1139-L1141"
}

sources · manifest.42710

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

sources · snippet-registry.42710

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

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:98e10ea171dd89a00bd0886e01479413fa364d9f946b5243bfdddfc9b05eeb1d

Text language: en · english-manuals:98e10ea171dd89a00bd0886e01479413fa364d9f946b5243bfdddfc9b05eeb1d