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

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

… is not allowed with DISTINCT clause — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

… is not allowed with GROUP BY clause — 0A000

feature_not_supported

PostgreSQL error "… is not allowed with GROUP BY clause" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… is not allowed with HAVING clause — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

… is not allowed with aggregate functions — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

… is not allowed with window functions — 0A000

feature_not_supported

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

Feature Not Supported