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 288 of 3908 errors

0A000 ERROR

access method “…” does not support NULLS FIRST/LAST options — 0A000

feature_not_supported

PostgreSQL error "access method "…" does not support NULLS FIRST/LAST options" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot reindex system catalogs concurrently — 0A000

feature_not_supported

PostgreSQL error "cannot reindex system catalogs concurrently" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

can only reindex the currently open database — 0A000

feature_not_supported

PostgreSQL error "can only reindex the currently open database" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot move non-shared relation to tablespace “…” — 0A000

feature_not_supported

PostgreSQL error "cannot move non-shared relation to tablespace "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

CONCURRENTLY cannot be used when the materialized view is not popul… — 0A000

feature_not_supported

PostgreSQL error "CONCURRENTLY cannot be used when the materialized view is not populated" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

invalid publication WHERE expression — 0A000

feature_not_supported

PostgreSQL error "invalid publication WHERE expression" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

only a single relation is allowed in CREATE STATISTICS — 0A000

feature_not_supported

PostgreSQL error "only a single relation is allowed in CREATE STATISTICS" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

statistics creation on system columns is not supported — 0A000

feature_not_supported

PostgreSQL error "statistics creation on system columns is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use different column lists for table “…” in different public… — 0A000

feature_not_supported

PostgreSQL error "cannot use different column lists for table "…" in different publications" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

DROP INDEX CONCURRENTLY does not support dropping multiple objects — 0A000

feature_not_supported

PostgreSQL error "DROP INDEX CONCURRENTLY does not support dropping multiple objects" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

DROP INDEX CONCURRENTLY does not support CASCADE — 0A000

feature_not_supported

PostgreSQL error "DROP INDEX CONCURRENTLY does not support CASCADE" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot drop partitioned index “…” concurrently — 0A000

feature_not_supported

PostgreSQL error "cannot drop partitioned index "…" concurrently" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot truncate foreign table “…” — 0A000

feature_not_supported

PostgreSQL error "cannot truncate foreign table "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot truncate temporary tables of other sessions — 0A000

feature_not_supported

PostgreSQL error "cannot truncate temporary tables of other sessions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot move temporary tables of other sessions — 0A000

feature_not_supported

PostgreSQL error "cannot move temporary tables of other sessions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot rename system column “…” — 0A000

feature_not_supported

PostgreSQL error "cannot rename system column "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter temporary tables of other sessions — 0A000

feature_not_supported

PostgreSQL error "cannot alter temporary tables of other sessions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot change persistence setting twice — 0A000

feature_not_supported

PostgreSQL error "cannot change persistence setting twice" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot have multiple SET ACCESS METHOD subcommands — 0A000

feature_not_supported

PostgreSQL error "cannot have multiple SET ACCESS METHOD subcommands" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot rewrite system relation “…” — 0A000

feature_not_supported

PostgreSQL error "cannot rewrite system relation "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot rewrite table “…” used as a catalog table — 0A000

feature_not_supported

PostgreSQL error "cannot rewrite table "…" used as a catalog table" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot rewrite temporary tables of other sessions — 0A000

feature_not_supported

PostgreSQL error "cannot rewrite temporary tables of other sessions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter type “…” because column “…” uses it — 0A000

feature_not_supported

PostgreSQL error "cannot alter type "…" because column "…" uses it" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter foreign table “…” because column “…” uses its row type — 0A000

feature_not_supported

PostgreSQL error "cannot alter foreign table "…" because column "…" uses its row type" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported