PostgreSQL Error Reference

Every error, explained

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

2792 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 384 of 2792 errors

0A000 ERROR

DEFAULT namespace is not supported — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cached plan must not change result type — 0A000

feature_not_supported

PostgreSQL error "cached plan must not change result type" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot PREPARE a transaction that modified relation mapping — 0A000

feature_not_supported

PostgreSQL error "cannot PREPARE a transaction that modified relation mapping" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 FATAL

conversion between … and … is not supported — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

SET LOCAL TRANSACTION SNAPSHOT is not implemented — 0A000

feature_not_supported

PostgreSQL error "SET LOCAL TRANSACTION SNAPSHOT is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot PREPARE a transaction that has created a cursor WITH HOLD — 0A000

feature_not_supported

PostgreSQL error "cannot PREPARE a transaction that has created a cursor WITH HOLD" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

a snapshot-importing transaction must have isolation level SERIALIZ… — 0A000

feature_not_supported

PostgreSQL error "a snapshot-importing transaction must have isolation level SERIALIZABLE or REPEATABLE READ" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
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

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

with a SEARCH or CYCLE clause, the recursive reference to WITH quer… — 0A000

feature_not_supported

PostgreSQL error "with a SEARCH or CYCLE clause, the recursive reference to WITH query "…" must be at the top level of its right-hand SELECT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 PANIC

cannot PREPARE while holding both session-level and transaction-lev… — 0A000

feature_not_supported

PostgreSQL error "cannot PREPARE while holding both session-level and transaction-level locks on the same object" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

formatting field “…” is only supported in to_char — 0A000

feature_not_supported

PostgreSQL error "formatting field "…" is only supported in to_char" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported