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

0A000 ERROR

ICU is not supported in this build — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

collations with different collate and ctype values are not supporte… — 0A000

feature_not_supported

PostgreSQL error "collations with different collate and ctype values are not supported on this platform" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

encoding “…” not supported by ICU — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot add NaN to pg_lsn — 0A000

feature_not_supported

PostgreSQL error "cannot add NaN to pg_lsn" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot subtract NaN from pg_lsn — 0A000

feature_not_supported

PostgreSQL error "cannot subtract NaN from pg_lsn" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot display a value of type … — 0A000

feature_not_supported

PostgreSQL error "cannot display a value of type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot accept a value of a shell type — 0A000

feature_not_supported

PostgreSQL error "cannot accept a value of a shell type" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot display a value of a shell type — 0A000

feature_not_supported

PostgreSQL error "cannot display a value of a shell type" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

MATCH PARTIAL not yet implemented — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

input of anonymous composite types is not implemented — 0A000

feature_not_supported

PostgreSQL error "input of anonymous composite types is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

rule “…” has unsupported event type n — 0A000

feature_not_supported

PostgreSQL error "rule "…" has unsupported event type n" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot look at latest visible tid for relation “…” — 0A000

feature_not_supported

PostgreSQL error "cannot look at latest visible tid for relation "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ctid isn’t of type TID — 0A000

feature_not_supported

PostgreSQL error "ctid isn't of type TID" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

currtid cannot handle views with no CTID — 0A000

feature_not_supported

PostgreSQL error "currtid cannot handle views with no CTID" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

the view has no rules — 0A000

feature_not_supported

PostgreSQL error "the view has no rules" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

only one select rule is allowed in views — 0A000

feature_not_supported

PostgreSQL error "only one select rule is allowed in views" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

timestamps cannot be binned into intervals containing months or years — 0A000

feature_not_supported

PostgreSQL error "timestamps cannot be binned into intervals containing months or years" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

nondeterministic collations are not supported for substring searches — 0A000

feature_not_supported

PostgreSQL error "nondeterministic collations are not supported for substring searches" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

xmlvalidate is not implemented — 0A000

feature_not_supported

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

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