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

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

ROW triggers with transition tables are not supported on partitions — 0A000

feature_not_supported

PostgreSQL error "ROW triggers with transition tables are not supported on partitions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ROW triggers with transition tables are not supported on inheritanc… — 0A000

feature_not_supported

PostgreSQL error "ROW triggers with transition tables are not supported on inheritance children" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

TRUNCATE triggers with transition tables are not supported — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

transition tables cannot be specified for triggers with more than o… — 0A000

feature_not_supported

PostgreSQL error "transition tables cannot be specified for triggers with more than one event" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

transition tables cannot be specified for triggers with column lists — 0A000

feature_not_supported

PostgreSQL error "transition tables cannot be specified for triggers with column lists" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported