PostgreSQL Error Reference

Every error, explained

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

2965 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 408 of 2965 errors

0A000 ERROR

a serializable transaction cannot import a snapshot from a non-seri… — 0A000

feature_not_supported

PostgreSQL error "a serializable transaction cannot import a snapshot from a non-serializable transaction" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

a non-read-only serializable transaction cannot import a snapshot f… — 0A000

feature_not_supported

PostgreSQL error "a non-read-only serializable transaction cannot import a snapshot from a read-only transaction" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot import a snapshot from a different database — 0A000

feature_not_supported

PostgreSQL error "cannot import a snapshot from a different database" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot allocate multiple Perl interpreters on this platform — 0A000

feature_not_supported

PostgreSQL error "cannot allocate multiple Perl interpreters on this platform" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot set system attribute “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

PL/Perl functions cannot return type … — 0A000

feature_not_supported

PostgreSQL error "PL/Perl functions cannot return type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY force null only available using COPY FROM — 0A000

feature_not_supported

PostgreSQL error "COPY force null only available using COPY FROM" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY delimiter must not appear in the NULL specification — 0A000

feature_not_supported

PostgreSQL error "COPY delimiter must not appear in the NULL specification" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

CSV quote character must not appear in the NULL specification — 0A000

feature_not_supported

PostgreSQL error "CSV quote character must not appear in the NULL specification" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot create exclusion constraints on partitioned table “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot match partition key to an index using access method “…” — 0A000

feature_not_supported

PostgreSQL error "cannot match partition key to an index using access method "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

when building statistics on a single expression, statistics kinds m… — 0A000

feature_not_supported

PostgreSQL error "when building statistics on a single expression, statistics kinds may not be specified" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

specifying a table access method is not supported on a partitioned… — 0A000

feature_not_supported

PostgreSQL error "specifying a table access method is not supported on a partitioned table" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

materialized views must not use temporary tables or views — 0A000

feature_not_supported

PostgreSQL error "materialized views must not use temporary tables or views" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

MERGE not supported in WITH query — 0A000

feature_not_supported

PostgreSQL error "MERGE not supported in WITH query" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

generated columns are not supported on partitions — 0A000

feature_not_supported

PostgreSQL error "generated columns 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

exclusion constraints are not supported on partitioned tables — 0A000

feature_not_supported

PostgreSQL error "exclusion constraints are 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

LIKE is not supported for creating foreign tables — 0A000

feature_not_supported

PostgreSQL error "LIKE is not supported for creating foreign tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

huge pages not supported with the current shared_memory_type setting — 0A000

feature_not_supported

PostgreSQL error "huge pages not supported with the current shared_memory_type setting" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

logical decoding cannot be used while in recovery — 0A000

feature_not_supported

PostgreSQL error "logical decoding cannot be used while in recovery" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

client sent proto_version=n but we only support protocol n or lower — 0A000

feature_not_supported

PostgreSQL error "client sent proto_version=n but we only support protocol n or lower" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

client sent proto_version=n but we only support protocol n or higher — 0A000

feature_not_supported

PostgreSQL error "client sent proto_version=n but we only support protocol n or higher" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSERT with ON CONFLICT clause cannot be used with table that has I… — 0A000

feature_not_supported

PostgreSQL error "INSERT with ON CONFLICT clause cannot be used with table that has INSERT or UPDATE rules" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

NEW variables in ON UPDATE rules cannot reference columns that are… — 0A000

feature_not_supported

PostgreSQL error "NEW variables in ON UPDATE rules cannot reference columns that are part of a multiple assignment in the subject UPDATE command" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported