PostgreSQL Error Reference

Every error, explained

SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.

3908 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 984 of 3908 errors

22023 ERROR

argument list length must be exactly n — 22023

invalid_parameter_value

PostgreSQL error "argument list length must be exactly n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized object type “…” — 22023

invalid_parameter_value

PostgreSQL error "unrecognized object type "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

“…” is not an existing enum label — 22023

invalid_parameter_value

PostgreSQL error ""…" is not an existing enum label" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_enum OID value not set when in binary upgrade mode — 22023

invalid_parameter_value

PostgreSQL error "pg_enum OID value not set when in binary upgrade mode" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

ALTER TYPE ADD BEFORE/AFTER is incompatible with binary upgrade — 22023

invalid_parameter_value

PostgreSQL error "ALTER TYPE ADD BEFORE/AFTER is incompatible with binary upgrade" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot add relation “…” to publication — 22023

invalid_parameter_value

PostgreSQL error "cannot add relation "…" to publication" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_type OID value not set when in binary upgrade mode — 22023

invalid_parameter_value

PostgreSQL error "pg_type OID value not set when in binary upgrade mode" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

channel name cannot be empty — 22023

invalid_parameter_value

PostgreSQL error "channel name cannot be empty" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

channel name too long — 22023

invalid_parameter_value

PostgreSQL error "channel name too long" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

payload string too long — 22023

invalid_parameter_value

PostgreSQL error "payload string too long" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

COPY format “…” not recognized — 22023

invalid_parameter_value

PostgreSQL error "COPY format "…" not recognized" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

argument to option “…” must be a list of column names — 22023

invalid_parameter_value

PostgreSQL error "argument to option "…" must be a list of column names" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

argument to option “…” must be a valid encoding name — 22023

invalid_parameter_value

PostgreSQL error "argument to option "…" must be a valid encoding name" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

COPY delimiter cannot be newline or carriage return — 22023

invalid_parameter_value

PostgreSQL error "COPY delimiter cannot be newline or carriage return" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

COPY null representation cannot use newline or carriage return — 22023

invalid_parameter_value

PostgreSQL error "COPY null representation cannot use newline or carriage return" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

COPY delimiter cannot be “…” — 22023

invalid_parameter_value

PostgreSQL error "COPY delimiter cannot be "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

COPY delimiter and quote must be different — 22023

invalid_parameter_value

PostgreSQL error "COPY delimiter and quote must be different" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

OIDs less than n are reserved for system objects — 22023

invalid_parameter_value

PostgreSQL error "OIDs less than n are reserved for system objects" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid connection limit: n — 22023

invalid_parameter_value

PostgreSQL error "invalid connection limit: n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

encoding “…” is not supported with ICU provider — 22023

invalid_parameter_value

PostgreSQL error "encoding "…" is not supported with ICU provider" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_global cannot be used as default tablespace — 22023

invalid_parameter_value

PostgreSQL error "pg_global cannot be used as default tablespace" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

database OID n is already in use by database “…” — 22023

invalid_parameter_value

PostgreSQL error "database OID n is already in use by database "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

data directory with the specified OID n already exists — 22023

invalid_parameter_value

PostgreSQL error "data directory with the specified OID n already exists" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot disallow connections for current database — 22023

invalid_parameter_value

PostgreSQL error "cannot disallow connections for current database" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception