PostgreSQL Error Reference

Every error, explained

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

3328 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 288 of 3328 errors

0A000 ERROR

column data type … does not support compression — 0A000

feature_not_supported

PostgreSQL error "column data type … does not support compression" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

TRUNCATE FOR EACH ROW triggers are not supported — 0A000

feature_not_supported

PostgreSQL error "TRUNCATE FOR EACH ROW triggers are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSTEAD OF triggers must be FOR EACH ROW — 0A000

feature_not_supported

PostgreSQL error "INSTEAD OF triggers must be FOR EACH ROW" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSTEAD OF triggers cannot have WHEN conditions — 0A000

feature_not_supported

PostgreSQL error "INSTEAD OF triggers cannot have WHEN conditions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSTEAD OF triggers cannot have column lists — 0A000

feature_not_supported

PostgreSQL error "INSTEAD OF triggers cannot have column lists" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ROW triggers with transition tables are not supported on partitions — 0A000

feature_not_supported

PostgreSQL error "ROW triggers with transition tables 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

cannot update foreign table “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot delete from foreign table “…” — 0A000

feature_not_supported

PostgreSQL error "cannot delete from foreign table "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot lock rows in foreign table “…” — 0A000

feature_not_supported

PostgreSQL error "cannot lock rows in foreign table "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

function returning setof record called in context that cannot accep… — 0A000

feature_not_supported

PostgreSQL error "function returning setof record called in context that cannot accept type record" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot retrieve a system column in this context — 0A000

feature_not_supported

PostgreSQL error "cannot retrieve a system column in this context" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot COPY to/from client in an SQL function — 0A000

feature_not_supported

PostgreSQL error "cannot COPY to/from client in an SQL function" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… is not allowed in an SQL function — 0A000

feature_not_supported

PostgreSQL error "… is not allowed in an SQL function" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… is not allowed in a non-volatile function — 0A000

feature_not_supported

PostgreSQL error "… is not allowed in a non-volatile function" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

calling procedures with output arguments is not supported in SQL fu… — 0A000

feature_not_supported

PostgreSQL error "calling procedures with output arguments is not supported in SQL functions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

custom scan “…” does not support MarkPos — 0A000

feature_not_supported

PostgreSQL error "custom scan "…" does not support MarkPos" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

lossy distance functions are not supported in index-only scans — 0A000

feature_not_supported

PostgreSQL error "lossy distance functions are not supported in index-only scans" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

RIGHT JOIN is only supported with merge-joinable join conditions — 0A000

feature_not_supported

PostgreSQL error "RIGHT JOIN is only supported with merge-joinable join conditions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

FULL JOIN is only supported with merge-joinable join conditions — 0A000

feature_not_supported

PostgreSQL error "FULL JOIN is only supported with merge-joinable join conditions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

aggregate function … does not support use as a window function — 0A000

feature_not_supported

PostgreSQL error "aggregate function … does not support use as a window function" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

client uses authorization identity, but it is not supported — 0A000

feature_not_supported

PostgreSQL error "client uses authorization identity, but it is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

client requires an unsupported SCRAM extension — 0A000

feature_not_supported

PostgreSQL error "client requires an unsupported SCRAM extension" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

FULL JOIN is only supported with merge-joinable or hash-joinable jo… — 0A000

feature_not_supported

PostgreSQL error "FULL JOIN is only supported with merge-joinable or hash-joinable join conditions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… cannot be applied to the nullable side of an outer join — 0A000

feature_not_supported

PostgreSQL error "… cannot be applied to the nullable side of an outer join" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported