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 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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
22004 ERROR

Null Value Not Allowed — SQLSTATE 22004

null_value_not_allowed

A NULL value was supplied where a non-null value is required.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception
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.

Data Exception