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

0A000 ERROR

COPY query must not be a utility command — 0A000

feature_not_supported

PostgreSQL error "COPY query must not be a utility command" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY query must have a RETURNING clause — 0A000

feature_not_supported

PostgreSQL error "COPY query must have a RETURNING clause" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

policies not yet implemented for this command — 0A000

feature_not_supported

PostgreSQL error "policies not yet implemented for this command" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

current database cannot be renamed — 0A000

feature_not_supported

PostgreSQL error "current database cannot be renamed" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

option “…” cannot be specified with other options — 0A000

feature_not_supported

PostgreSQL error "option "…" cannot be specified with other options" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

event triggers are not supported for … — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

transaction control statements are not allowed within an extension… — 0A000

feature_not_supported

PostgreSQL error "transaction control statements are not allowed within an extension script" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

extension “…” must be installed in schema “…” — 0A000

feature_not_supported

PostgreSQL error "extension "…" must be installed in schema "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

nested CREATE EXTENSION is not supported — 0A000

feature_not_supported

PostgreSQL error "nested CREATE EXTENSION is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… can only be called from an SQL script executed by CREATE EXTENSION — 0A000

feature_not_supported

PostgreSQL error "… can only be called from an SQL script executed by CREATE EXTENSION" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

nested ALTER EXTENSION is not supported — 0A000

feature_not_supported

PostgreSQL error "nested ALTER EXTENSION is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… is not yet supported in unquoted SQL function body — 0A000

feature_not_supported

PostgreSQL error "… is not yet supported in unquoted SQL function body" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

language “…” does not support inline code execution — 0A000

feature_not_supported

PostgreSQL error "language "…" does not support inline code execution" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot create index on partitioned table “…” concurrently — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot create indexes on temporary tables of other sessions — 0A000

feature_not_supported

PostgreSQL error "cannot create indexes 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 default tablespace for partitioned relations — 0A000

feature_not_supported

PostgreSQL error "cannot specify default tablespace for partitioned relations" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

access method “…” does not support unique indexes — 0A000

feature_not_supported

PostgreSQL error "access method "…" does not support unique indexes" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

access method “…” does not support included columns — 0A000

feature_not_supported

PostgreSQL error "access method "…" does not support included columns" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

access method “…” does not support multicolumn indexes — 0A000

feature_not_supported

PostgreSQL error "access method "…" does not support multicolumn indexes" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

access method “…” does not support exclusion constraints — 0A000

feature_not_supported

PostgreSQL error "access method "…" does not support exclusion constraints" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

unique constraint on partitioned table must include all partitionin… — 0A000

feature_not_supported

PostgreSQL error "unique constraint on partitioned table must include all partitioning columns" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

index creation on system columns is not supported — 0A000

feature_not_supported

PostgreSQL error "index 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

expressions are not supported in included columns — 0A000

feature_not_supported

PostgreSQL error "expressions are not supported in included columns" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

access method “…” does not support ASC/DESC options — 0A000

feature_not_supported

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

Feature Not Supported