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 960 of 3908 errors

22023 ERROR

invalid value for floating point option “…”: … — 22023

invalid_parameter_value

PostgreSQL error "invalid value for floating point option "…": …" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid value for enum option “…”: … — 22023

invalid_parameter_value

PostgreSQL error "invalid value for enum option "…": …" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid overflow block number n — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

operator class … has no options — 22023

invalid_parameter_value

PostgreSQL error "operator class … has no options" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

compress method must be defined when leaf type is different from in… — 22023

invalid_parameter_value

PostgreSQL error "compress method must be defined when leaf type is different from input type" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

tid (n, n) is not valid for relation “…” — 22023

invalid_parameter_value

PostgreSQL error "tid (n, n) is not valid for relation "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot retrieve commit timestamp for transaction n — 22023

invalid_parameter_value

PostgreSQL error "cannot retrieve commit timestamp for transaction n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

transaction identifier “…” is too long — 22023

invalid_parameter_value

PostgreSQL error "transaction identifier "…" is too long" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

“…” must be at least twice “…” — 22023

invalid_parameter_value

PostgreSQL error ""…" must be at least twice "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

backup label too long (max n bytes) — 22023

invalid_parameter_value

PostgreSQL error "backup label too long (max n bytes)" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

value too long for restore point (maximum n characters) — 22023

invalid_parameter_value

PostgreSQL error "value too long for restore point (maximum n characters)" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 FATAL

recovery target timeline n does not exist — 22023

invalid_parameter_value

PostgreSQL error "recovery target timeline n does not exist" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

could not set compression worker count to n: … — 22023

invalid_parameter_value

PostgreSQL error "could not set compression worker count to n: …" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_nextoid() can only be used on system catalogs — 22023

invalid_parameter_value

PostgreSQL error "pg_nextoid() can only be used on system catalogs" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

index “…” does not belong to table “…” — 22023

invalid_parameter_value

PostgreSQL error "index "…" does not belong to table "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

column “…” is not of type oid — 22023

invalid_parameter_value

PostgreSQL error "column "…" is not of type oid" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

index “…” is not the index for column “…” — 22023

invalid_parameter_value

PostgreSQL error "index "…" is not the index for column "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_class heap OID value not set when in binary upgrade mode — 22023

invalid_parameter_value

PostgreSQL error "pg_class heap 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

pg_class index OID value not set when in binary upgrade mode — 22023

invalid_parameter_value

PostgreSQL error "pg_class index 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

name or argument lists may not contain nulls — 22023

invalid_parameter_value

PostgreSQL error "name or argument lists may not contain nulls" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unsupported object type “…” — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

name list length must be exactly n — 22023

invalid_parameter_value

PostgreSQL error "name 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

large object OID may not be null — 22023

invalid_parameter_value

PostgreSQL error "large object OID may not be null" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

name list length must be at least n — 22023

invalid_parameter_value

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

Data Exception