Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 216 of 3910 errors
0A000
ERROR
EXECUTE of SELECT … INTO is not implemented — 0A000
feature_not_supported
PostgreSQL error "EXECUTE of SELECT ... INTO is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot merge into view “…” — 0A000
feature_not_supported
PostgreSQL error "cannot merge into view "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot execute … on relation “…” — 0A000
feature_not_supported
PostgreSQL error "cannot execute … on relation "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot accept a value of type … — 0A000
feature_not_supported
PostgreSQL error "cannot accept a value of type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
tables declared WITH OIDS are not supported — 0A000
feature_not_supported
PostgreSQL error "tables declared WITH OIDS are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
compression method lz4 not supported — 0A000
feature_not_supported
PostgreSQL error "compression method lz4 not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot access temporary indexes of other sessions — 0A000
feature_not_supported
PostgreSQL error "cannot access temporary indexes of other sessions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
hash indexes do not support whole-index scans — 0A000
feature_not_supported
PostgreSQL error "hash indexes do not support whole-index scans" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
only heap AM is supported — 0A000
feature_not_supported
PostgreSQL error "only heap AM is supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot access index “…” while it is being reindexed — 0A000
feature_not_supported
PostgreSQL error "cannot access index "…" while it is being reindexed" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot PREPARE a transaction that has operated on temporary objects — 0A000
feature_not_supported
PostgreSQL error "cannot PREPARE a transaction that has operated on temporary objects" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
cannot PREPARE a transaction that has exported snapshots — 0A000
feature_not_supported
PostgreSQL error "cannot PREPARE a transaction that has exported snapshots" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
return type must be a row type — 0A000
feature_not_supported
PostgreSQL error "return type must be a row type" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
FATAL
standby mode is not supported by single-user servers — 0A000
feature_not_supported
PostgreSQL error "standby mode is not supported by single-user servers" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
gzip compression is not supported by this build — 0A000
feature_not_supported
PostgreSQL error "gzip compression is not supported by this build" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
lz4 compression is not supported by this build — 0A000
feature_not_supported
PostgreSQL error "lz4 compression is not supported by this build" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
zstd compression is not supported by this build — 0A000
feature_not_supported
PostgreSQL error "zstd compression is not supported by this build" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
constant of the type … cannot be used here — 0A000
feature_not_supported
PostgreSQL error "constant of the type … cannot be used here" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
primary keys cannot be expressions — 0A000
feature_not_supported
PostgreSQL error "primary keys cannot be expressions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
user-defined indexes on system catalog tables are not supported — 0A000
feature_not_supported
PostgreSQL error "user-defined indexes on system catalog tables are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
nondeterministic collations are not supported for operator class “…” — 0A000
feature_not_supported
PostgreSQL error "nondeterministic collations are not supported for operator class "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
concurrent index creation on system catalog tables is not supported — 0A000
feature_not_supported
PostgreSQL error "concurrent index creation on system catalog tables is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
concurrent index creation for exclusion constraints is not supported — 0A000
feature_not_supported
PostgreSQL error "concurrent index creation for exclusion constraints is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.
0A000
ERROR
DROP INDEX CONCURRENTLY must be first action in transaction — 0A000
feature_not_supported
PostgreSQL error "DROP INDEX CONCURRENTLY must be first action in transaction" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.