PostgreSQL Error Reference

Every error, explained

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

3241 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 288 of 3241 errors

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

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

… is not allowed with UNION/INTERSECT/EXCEPT — 0A000

feature_not_supported

PostgreSQL error "… is not allowed with UNION/INTERSECT/EXCEPT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot access temporary or unlogged relations during recovery — 0A000

feature_not_supported

PostgreSQL error "cannot access temporary or unlogged relations during recovery" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

whole row unique index inference specifications are not supported — 0A000

feature_not_supported

PostgreSQL error "whole row unique index inference specifications are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… cannot be applied to VALUES — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

DECLARE CURSOR must not contain data-modifying statements in WITH — 0A000

feature_not_supported

PostgreSQL error "DECLARE CURSOR must not contain data-modifying statements in WITH" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

materialized views must not use data-modifying statements in WITH — 0A000

feature_not_supported

PostgreSQL error "materialized views must not use data-modifying statements in WITH" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

materialized views may not be defined using bound parameters — 0A000

feature_not_supported

PostgreSQL error "materialized views may not be defined using bound parameters" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

materialized views cannot be unlogged — 0A000

feature_not_supported

PostgreSQL error "materialized views cannot be unlogged" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported