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

0A000 ERROR

COPY quote available only in CSV mode — 0A000

feature_not_supported

PostgreSQL error "COPY quote available only in CSV mode" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY escape available only in CSV mode — 0A000

feature_not_supported

PostgreSQL error "COPY escape available only in CSV mode" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY force quote available only in CSV mode — 0A000

feature_not_supported

PostgreSQL error "COPY force quote available only in CSV mode" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY force quote only available using COPY TO — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

COPY force not null available only in CSV mode — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

COPY force not null only available using COPY FROM — 0A000

feature_not_supported

PostgreSQL error "COPY force not 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 force null available only in CSV mode — 0A000

feature_not_supported

PostgreSQL error "COPY force null available only in CSV mode" (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