Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 768 of 3908 errors
22004
ERROR
array subscript in assignment must not be null — 22004
null_value_not_allowed
PostgreSQL error "array subscript in assignment must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
typmod array must not contain nulls — 22004
null_value_not_allowed
PostgreSQL error "typmod array must not contain nulls" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
initial position must not be null — 22004
null_value_not_allowed
PostgreSQL error "initial position 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 for object key — 22004
null_value_not_allowed
PostgreSQL error "null value not allowed for object key" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
jsonb subscript in assignment must not be null — 22004
null_value_not_allowed
PostgreSQL error "jsonb subscript in assignment must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
path element at position n is null — 22004
null_value_not_allowed
PostgreSQL error "path element at position n is null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
multirange values cannot contain null members — 22004
null_value_not_allowed
PostgreSQL error "multirange values cannot contain null members" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
array of weight must not contain nulls — 22004
null_value_not_allowed
PostgreSQL error "array of weight must not contain nulls" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
lexeme array may not contain nulls — 22004
null_value_not_allowed
PostgreSQL error "lexeme array may not contain nulls" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
weight array may not contain nulls — 22004
null_value_not_allowed
PostgreSQL error "weight array may not contain nulls" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
configuration column “…” must not be null — 22004
null_value_not_allowed
PostgreSQL error "configuration column "…" must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
null values cannot be formatted as an SQL identifier — 22004
null_value_not_allowed
PostgreSQL error "null values cannot be formatted as an SQL identifier" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
neither namespace name nor URI may be null — 22004
null_value_not_allowed
PostgreSQL error "neither namespace name nor URI may be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
SET requires parameter name — 22004
null_value_not_allowed
PostgreSQL error "SET requires parameter name" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
lower bound of FOR loop cannot be null — 22004
null_value_not_allowed
PostgreSQL error "lower bound of FOR loop cannot be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
upper bound of FOR loop cannot be null — 22004
null_value_not_allowed
PostgreSQL error "upper bound of FOR loop cannot be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
BY value of FOR loop cannot be null — 22004
null_value_not_allowed
PostgreSQL error "BY value of FOR loop cannot be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
FOREACH expression must not be null — 22004
null_value_not_allowed
PostgreSQL error "FOREACH expression must not be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
query string argument of EXECUTE is null — 22004
null_value_not_allowed
PostgreSQL error "query string argument of EXECUTE is null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
RAISE statement option cannot be null — 22004
null_value_not_allowed
PostgreSQL error "RAISE statement option cannot be null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
cursor variable “…” is null — 22004
null_value_not_allowed
PostgreSQL error "cursor variable "…" is null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
relative or absolute cursor position is null — 22004
null_value_not_allowed
PostgreSQL error "relative or absolute cursor position is null" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
null value cannot be assigned to variable “…” declared NOT NULL — 22004
null_value_not_allowed
PostgreSQL error "null value cannot be assigned to variable "…" declared NOT NULL" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.
22004
ERROR
null value not allowed — 22004
null_value_not_allowed
PostgreSQL error "null value not allowed" (SQLSTATE 22004, null_value_not_allowed): what it means, common causes, and how to fix it.