Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 336 of 3262 errors
0A000
ERROR
FOR UPDATE/SHARE in a recursive query is not implemented — 0A000
feature_not_supported
PostgreSQL error "FOR UPDATE/SHARE in a recursive query is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
row expansion via “*” is not supported here — 0A000
feature_not_supported
PostgreSQL error "row expansion via "*" is not supported here" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
source for a multiple-column UPDATE item must be a sub-SELECT or RO… — 0A000
feature_not_supported
PostgreSQL error "source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot compare rows of zero length — 0A000
feature_not_supported
PostgreSQL error "cannot compare rows of zero length" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
OVER is not supported for ordered-set aggregate … — 0A000
feature_not_supported
PostgreSQL error "OVER is not supported for ordered-set aggregate …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
aggregates cannot use named arguments — 0A000
feature_not_supported
PostgreSQL error "aggregates cannot use named arguments" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
aggregate ORDER BY is not implemented for window functions — 0A000
feature_not_supported
PostgreSQL error "aggregate ORDER BY is not implemented for window functions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
FILTER is not implemented for non-aggregate window functions — 0A000
feature_not_supported
PostgreSQL error "FILTER is not implemented for non-aggregate window functions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
WITH query “…” does not have a RETURNING clause — 0A000
feature_not_supported
PostgreSQL error "WITH query "…" does not have a RETURNING clause" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot assign to system column “…” — 0A000
feature_not_supported
PostgreSQL error "cannot assign to system column "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot set an array element to DEFAULT — 0A000
feature_not_supported
PostgreSQL error "cannot set an array element to DEFAULT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot set a subfield to DEFAULT — 0A000
feature_not_supported
PostgreSQL error "cannot set a subfield to DEFAULT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
array of serial is not implemented — 0A000
feature_not_supported
PostgreSQL error "array of serial is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
identity columns are not supported on typed tables — 0A000
feature_not_supported
PostgreSQL error "identity columns are not supported on typed tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
identity columns are not supported on partitions — 0A000
feature_not_supported
PostgreSQL error "identity columns are not supported on partitions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
generated columns are not supported on typed tables — 0A000
feature_not_supported
PostgreSQL error "generated columns are not supported on typed tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
primary key constraints are not supported on foreign tables — 0A000
feature_not_supported
PostgreSQL error "primary key constraints are not supported on foreign tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
unique constraints are not supported on foreign tables — 0A000
feature_not_supported
PostgreSQL error "unique constraints are not supported on foreign tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
exclusion constraints are not supported on foreign tables — 0A000
feature_not_supported
PostgreSQL error "exclusion constraints are not supported on foreign tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot use an existing index in CREATE TABLE — 0A000
feature_not_supported
PostgreSQL error "cannot use an existing index in CREATE TABLE" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
rules on materialized views are not supported — 0A000
feature_not_supported
PostgreSQL error "rules on materialized views are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
conditional UNION/INTERSECT/EXCEPT statements are not implemented — 0A000
feature_not_supported
PostgreSQL error "conditional UNION/INTERSECT/EXCEPT statements are not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot refer to OLD within WITH query — 0A000
feature_not_supported
PostgreSQL error "cannot refer to OLD within WITH query" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot refer to NEW within WITH query — 0A000
feature_not_supported
PostgreSQL error "cannot refer to NEW within WITH query" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.