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

0A000 ERROR

partitioned tables cannot be unlogged — 0A000

feature_not_supported

PostgreSQL error "partitioned tables cannot be unlogged" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ALTER TABLE / SET EXPRESSION is not supported for virtual generated… — 0A000

feature_not_supported

PostgreSQL error "ALTER TABLE / SET EXPRESSION is not supported for virtual generated columns in tables with check constraints" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ALTER TABLE / SET EXPRESSION is not supported for virtual generated… — 0A000

feature_not_supported

PostgreSQL error "ALTER TABLE / SET EXPRESSION is not supported for virtual generated columns in tables that are part of a publication" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter statistics on virtual generated column “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

foreign key constraints on virtual generated columns are not supported — 0A000

feature_not_supported

PostgreSQL error "foreign key constraints on virtual generated columns are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

unsupported … action for foreign key constraint using PERIOD — 0A000

feature_not_supported

PostgreSQL error "unsupported … action for foreign key constraint using PERIOD" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

not-null constraint “…” on partitioned table “…” cannot be NO INHERIT — 0A000

feature_not_supported

PostgreSQL error "not-null constraint "…" on partitioned table "…" cannot be NO INHERIT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

specifying GENERATED not supported for domains — 0A000

feature_not_supported

PostgreSQL error "specifying GENERATED not supported for domains" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

not-null constraints on partitioned tables cannot be NO INHERIT — 0A000

feature_not_supported

PostgreSQL error "not-null constraints on partitioned tables cannot be NO INHERIT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use different values of publish_generated_columns for table… — 0A000

feature_not_supported

PostgreSQL error "cannot use different values of publish_generated_columns 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

cannot modify statistics on system column “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot clear statistics on system column “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot modify statistics for shared relation — 0A000

feature_not_supported

PostgreSQL error "cannot modify statistics for shared relation" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use multi-line header in COPY TO — 0A000

feature_not_supported

PostgreSQL error "cannot use multi-line header in COPY TO" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

CONCURRENTLY option not supported for … — 0A000

feature_not_supported

PostgreSQL error "CONCURRENTLY option not supported for …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot execute … on multiple tables — 0A000

feature_not_supported

PostgreSQL error "cannot execute … on multiple tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… requires an explicit table name — 0A000

feature_not_supported

PostgreSQL error "… requires an explicit table name" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot execute … on a shared catalog — 0A000

feature_not_supported

PostgreSQL error "cannot execute … on a shared catalog" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot execute … on temporary tables of other sessions — 0A000

feature_not_supported

PostgreSQL error "cannot execute … on 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 specify statistics kinds when building univariate statistics — 0A000

feature_not_supported

PostgreSQL error "cannot specify statistics kinds when building univariate statistics" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot enable retain_dead_tuples if the publisher is in recovery — 0A000

feature_not_supported

PostgreSQL error "cannot enable retain_dead_tuples if the publisher is in recovery" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

partitions being merged have different owners — 0A000

feature_not_supported

PostgreSQL error "partitions being merged have different owners" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

function … does not allow RESPECT/IGNORE NULLS — 0A000

feature_not_supported

PostgreSQL error "function … does not allow RESPECT/IGNORE NULLS" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

foreign tables don’t support FOR PORTION OF — 0A000

feature_not_supported

PostgreSQL error "foreign tables don't support FOR PORTION OF" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported