Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.