Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 912 of 3908 errors
22021
ERROR
invalid byte sequence for encoding “UTF8” — 22021
character_not_in_repertoire
PostgreSQL error "invalid byte sequence for encoding "UTF8" — 22021" (SQLSTATE 22021): what it means, common causes, and how to fix it.
22022
ERROR
Indicator Overflow — SQLSTATE 22022
indicator_overflow
SQLSTATE 22022 (indicator_overflow): A value is invalid for its data type or the operation applied to it.
22023
ERROR
Invalid Parameter Value — SQLSTATE 22023
invalid_parameter_value
A function or setting received an invalid parameter value.
22023
ERROR
cannot extract elements from a scalar — 22023
invalid_parameter_value
PostgreSQL error "cannot extract elements from a scalar" (SQLSTATE 22023): what it means, common causes, and how to fix it.
22023
ERROR
cannot replace existing key — 22023
invalid_parameter_value
PostgreSQL error "cannot replace existing key" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
could not drop relation mapping for subscription “…” — 22023
invalid_parameter_value
PostgreSQL error "could not drop relation mapping for subscription "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
FATAL
recovery aborted because of insufficient parameter settings — 22023
invalid_parameter_value
PostgreSQL error "recovery aborted because of insufficient parameter settings" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
FATAL
database files are incompatible with server — 22023
invalid_parameter_value
PostgreSQL error "database files are incompatible with server" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
invalid value for parameter “…”: “…” — 22023
invalid_parameter_value
PostgreSQL error "invalid value for parameter "…": "…"" (SQLSTATE 22023): what it means, common causes, and how to fix it.
22023
ERROR
parameter “…” requires a Boolean value — 22023
invalid_parameter_value
PostgreSQL error "parameter "…" requires a Boolean value" (SQLSTATE 22023): what it means, common causes, and how to fix it.
22023
ERROR
step size cannot equal zero — 22023
invalid_parameter_value
PostgreSQL error "step size cannot equal zero" (SQLSTATE 22023): what it means, common causes, and how to fix it.
22023
FATAL
“…” is not a valid data directory — 22023
invalid_parameter_value
PostgreSQL error ""…" is not a valid data directory" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
value … out of bounds for option “…” — 22023
invalid_parameter_value
PostgreSQL error "value … out of bounds for option "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
cannot add schema “…” to publication — 22023
invalid_parameter_value
PostgreSQL error "cannot add schema "…" to publication" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
encoding “…” does not match locale “…” — 22023
invalid_parameter_value
PostgreSQL error "encoding "…" does not match locale "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
invalid extension name: “…” — 22023
invalid_parameter_value
PostgreSQL error "invalid extension name: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
invalid extension version name: “…” — 22023
invalid_parameter_value
PostgreSQL error "invalid extension version name: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
cannot use publication WHERE clause for relation “…” — 22023
invalid_parameter_value
PostgreSQL error "cannot use publication WHERE clause for relation "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
cannot use column list for relation “…” in publication “…” — 22023
invalid_parameter_value
PostgreSQL error "cannot use column list for relation "…" in publication "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
cannot set parameter “…” to false for publication “…” — 22023
invalid_parameter_value
PostgreSQL error "cannot set parameter "…" to false for publication "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
cannot add schema to publication “…” — 22023
invalid_parameter_value
PostgreSQL error "cannot add schema to publication "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
“vars” argument is not an object — 22023
invalid_parameter_value
PostgreSQL error ""vars" argument is not an object" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
string is not a valid identifier: “…” — 22023
invalid_parameter_value
PostgreSQL error "string is not a valid identifier: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.
22023
ERROR
could not create locale “…”: the OS error — 22023
invalid_parameter_value
PostgreSQL error "could not create locale "…": the OS error" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.