Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 744 of 3908 errors
22003
ERROR
“…” is out of range for type double precision — 22003
numeric_value_out_of_range
PostgreSQL error ""…" is out of range for type double precision" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.
22003
ERROR
OID out of range — 22003
numeric_value_out_of_range
PostgreSQL error "OID out of range" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.
22003
ERROR
invalid octet value in “macaddr” value: “…” — 22003
numeric_value_out_of_range
PostgreSQL error "invalid octet value in "macaddr" value: "…"" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.
22003
ERROR
block number out of range: % — 22003
numeric_value_out_of_range
PostgreSQL error "block number out of range: %" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.
22003
ERROR
timeout value is out of range — 22003
numeric_value_out_of_range
PostgreSQL error "timeout value is out of range" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.
22003
ERROR
value “…” is out of range for type bigint — 22003
numeric_value_out_of_range
PostgreSQL error "value … is out of range for type bigint — 22003" (SQLSTATE 22003): what it means, common causes, and how to fix it.
22004
ERROR
JSON value must not be null — 22004
null_value_not_allowed
PostgreSQL error "JSON value must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
Null Value Not Allowed — SQLSTATE 22004
null_value_not_allowed
A NULL value was supplied where a non-null value is required.
22004
ERROR
column filter expression must not be null — 22004
null_value_not_allowed
PostgreSQL error "column filter expression must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
namespace URI must not be null — 22004
null_value_not_allowed
PostgreSQL error "namespace URI must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
row filter expression must not be null — 22004
null_value_not_allowed
PostgreSQL error "row filter expression must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
null is not allowed in column “…” — 22004
null_value_not_allowed
PostgreSQL error "null is not allowed in column "…"" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
moving-aggregate transition function must not return null — 22004
null_value_not_allowed
PostgreSQL error "moving-aggregate transition function must not return null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
frame starting offset must not be null — 22004
null_value_not_allowed
PostgreSQL error "frame starting offset must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
frame ending offset must not be null — 22004
null_value_not_allowed
PostgreSQL error "frame ending offset must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
slot name must not be null — 22004
null_value_not_allowed
PostgreSQL error "slot name must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
options array must not be null — 22004
null_value_not_allowed
PostgreSQL error "options array must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
ACL arrays must not contain null values — 22004
null_value_not_allowed
PostgreSQL error "ACL arrays must not contain null values" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
cannot assign null value to an element of a fixed-length array — 22004
null_value_not_allowed
PostgreSQL error "cannot assign null value to an element of a fixed-length array" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
null array element not allowed in this context — 22004
null_value_not_allowed
PostgreSQL error "null array element not allowed in this context" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
cannot accumulate null arrays — 22004
null_value_not_allowed
PostgreSQL error "cannot accumulate null arrays" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
dimension array or low bound array cannot be null — 22004
null_value_not_allowed
PostgreSQL error "dimension array or low bound array cannot be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
dimension values cannot be null — 22004
null_value_not_allowed
PostgreSQL error "dimension values cannot be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
thresholds array must not contain NULLs — 22004
null_value_not_allowed
PostgreSQL error "thresholds array must not contain NULLs" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.