Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 336 of 3908 errors
0A000
ERROR
BEFORE trigger’s WHEN condition cannot reference NEW system columns — 0A000
feature_not_supported
PostgreSQL error "BEFORE trigger's WHEN condition cannot reference NEW system columns" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot collect transition tuples from child foreign tables — 0A000
feature_not_supported
PostgreSQL error "cannot collect transition tuples from child foreign tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
specifying constraint deferrability not supported for domains — 0A000
feature_not_supported
PostgreSQL error "specifying constraint deferrability not supported for domains" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
session user cannot be renamed — 0A000
feature_not_supported
PostgreSQL error "session user cannot be renamed" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
current user cannot be renamed — 0A000
feature_not_supported
PostgreSQL error "current user cannot be renamed" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
role “…” cannot have explicit members — 0A000
feature_not_supported
PostgreSQL error "role "…" cannot have explicit members" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
role “…” cannot be a member of any role — 0A000
feature_not_supported
PostgreSQL error "role "…" cannot be a member of any role" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
VACUUM FULL cannot be performed in parallel — 0A000
feature_not_supported
PostgreSQL error "VACUUM FULL cannot be performed in parallel" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
ANALYZE option must be specified when a column list is provided — 0A000
feature_not_supported
PostgreSQL error "ANALYZE option must be specified when a column list is provided" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
… cannot be executed from VACUUM or ANALYZE — 0A000
feature_not_supported
PostgreSQL error "… cannot be executed from VACUUM or ANALYZE" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
VACUUM option DISABLE_PAGE_SKIPPING cannot be used with FULL — 0A000
feature_not_supported
PostgreSQL error "VACUUM option DISABLE_PAGE_SKIPPING cannot be used with FULL" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
PROCESS_TOAST required with VACUUM FULL — 0A000
feature_not_supported
PostgreSQL error "PROCESS_TOAST required with VACUUM FULL" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
views must not contain SELECT INTO — 0A000
feature_not_supported
PostgreSQL error "views must not contain SELECT INTO" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
views must not contain data-modifying statements in WITH — 0A000
feature_not_supported
PostgreSQL error "views must not contain data-modifying statements in WITH" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
set-valued function called in context that cannot accept a set — 0A000
feature_not_supported
PostgreSQL error "set-valued function called in context that cannot accept a set" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
type … does not support subscripted assignment — 0A000
feature_not_supported
PostgreSQL error "type … does not support subscripted assignment" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot insert into foreign table “…” — 0A000
feature_not_supported
PostgreSQL error "cannot insert into foreign table "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot update foreign table “…” — 0A000
feature_not_supported
PostgreSQL error "cannot update foreign table "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot delete from foreign table “…” — 0A000
feature_not_supported
PostgreSQL error "cannot delete from foreign table "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot lock rows in foreign table “…” — 0A000
feature_not_supported
PostgreSQL error "cannot lock rows in foreign table "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
function returning setof record called in context that cannot accep… — 0A000
feature_not_supported
PostgreSQL error "function returning setof record called in context that cannot accept type record" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot retrieve a system column in this context — 0A000
feature_not_supported
PostgreSQL error "cannot retrieve a system column in this context" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot COPY to/from client in an SQL function — 0A000
feature_not_supported
PostgreSQL error "cannot COPY to/from client in an SQL function" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
… is not allowed in an SQL function — 0A000
feature_not_supported
PostgreSQL error "… is not allowed in an SQL function" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.