PostgreSQL Error Reference

Every error, explained

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

2995 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 384 of 2995 errors

0A000 ERROR

regular-expression matching not supported on type bytea — 0A000

feature_not_supported

PostgreSQL error "regular-expression matching not supported on type bytea" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot convert NaN to … — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot convert infinity to … — 0A000

feature_not_supported

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

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