PostgreSQL Error Reference

Every error, explained

SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.

3243 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 264 of 3243 errors

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
0A000 ERROR

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

feature_not_supported

PostgreSQL error "cannot alter 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
0A000 ERROR

cannot alter system column “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

ALTER TABLE / DROP EXPRESSION must be applied to child tables too — 0A000

feature_not_supported

PostgreSQL error "ALTER TABLE / DROP EXPRESSION must be applied to child tables too" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot refer to non-index column by number — 0A000

feature_not_supported

PostgreSQL error "cannot refer to non-index column by number" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter statistics on included column “…” of index “…” — 0A000

feature_not_supported

PostgreSQL error "cannot alter statistics on included column "…" of index "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

column data type … can only have storage PLAIN — 0A000

feature_not_supported

PostgreSQL error "column data type … can only have storage PLAIN" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot drop system column “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

ALTER TABLE / ADD CONSTRAINT USING INDEX is not supported on partit… — 0A000

feature_not_supported

PostgreSQL error "ALTER TABLE / ADD CONSTRAINT USING INDEX is not supported on partitioned tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot attach table “…” as a partition because it is referenced by… — 0A000

feature_not_supported

PostgreSQL error "cannot attach table "…" as a partition because it is referenced by foreign key "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

system columns cannot be used in foreign keys — 0A000

feature_not_supported

PostgreSQL error "system columns cannot be used in foreign keys" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter type of column “…” twice — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot use non-immediate index “…” as replica identity — 0A000

feature_not_supported

PostgreSQL error "cannot use non-immediate index "…" as replica identity" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use expression index “…” as replica identity — 0A000

feature_not_supported

PostgreSQL error "cannot use expression index "…" as replica identity" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use partial index “…” as replica identity — 0A000

feature_not_supported

PostgreSQL error "cannot use partial index "…" as replica identity" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

column data type … does not support compression — 0A000

feature_not_supported

PostgreSQL error "column data type … does not support compression" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

TRUNCATE FOR EACH ROW triggers are not supported — 0A000

feature_not_supported

PostgreSQL error "TRUNCATE FOR EACH ROW triggers are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSTEAD OF triggers must be FOR EACH ROW — 0A000

feature_not_supported

PostgreSQL error "INSTEAD OF triggers must be FOR EACH ROW" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSTEAD OF triggers cannot have WHEN conditions — 0A000

feature_not_supported

PostgreSQL error "INSTEAD OF triggers cannot have WHEN conditions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSTEAD OF triggers cannot have column lists — 0A000

feature_not_supported

PostgreSQL error "INSTEAD OF triggers cannot have column lists" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported