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

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

cannot convert circle with radius zero to polygon — 0A000

feature_not_supported

PostgreSQL error "cannot convert circle with radius zero to polygon" (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 LIKE — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

collation provider LIBC is not supported on this platform — 0A000

feature_not_supported

PostgreSQL error "collation provider LIBC is 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

gtsvector_in not implemented — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

ttdummy (…): you cannot change … and/or … columns (use set_ttdummy) — 0A000

feature_not_supported

PostgreSQL error "ttdummy (…): you cannot change … and/or … columns (use set_ttdummy)" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY DEFAULT only available using COPY FROM — 0A000

feature_not_supported

PostgreSQL error "COPY DEFAULT 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 DEFAULT specification — 0A000

feature_not_supported

PostgreSQL error "COPY delimiter must not appear in the DEFAULT 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 DEFAULT specification — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

NULL specification and DEFAULT specification cannot be the same — 0A000

feature_not_supported

PostgreSQL error "NULL specification and DEFAULT specification cannot be the same" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

BUFFER_USAGE_LIMIT cannot be specified for VACUUM FULL — 0A000

feature_not_supported

PostgreSQL error "BUFFER_USAGE_LIMIT cannot be specified for VACUUM FULL" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ONLY_DATABASE_STATS cannot be specified with a list of tables — 0A000

feature_not_supported

PostgreSQL error "ONLY_DATABASE_STATS cannot be specified with a list of tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ONLY_DATABASE_STATS cannot be specified with other VACUUM options — 0A000

feature_not_supported

PostgreSQL error "ONLY_DATABASE_STATS cannot be specified with other VACUUM options" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use JSON format with non-string output types — 0A000

feature_not_supported

PostgreSQL error "cannot use JSON format with non-string output types" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot set JSON encoding for non-bytea output types — 0A000

feature_not_supported

PostgreSQL error "cannot set JSON encoding for non-bytea output types" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

returning SETOF types is not supported in SQL/JSON functions — 0A000

feature_not_supported

PostgreSQL error "returning SETOF types is not supported in SQL/JSON functions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use JSON FORMAT ENCODING clause for non-bytea input types — 0A000

feature_not_supported

PostgreSQL error "cannot use JSON FORMAT ENCODING clause for non-bytea input types" (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 server only supports protocol n or… — 0A000

feature_not_supported

PostgreSQL error "client sent proto_version=n but server only supports 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 server only supports protocol n or… — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

COPY … requires CSV mode — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

tag filtering is not supported for login event triggers — 0A000

feature_not_supported

PostgreSQL error "tag filtering is not supported for login event triggers" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported