PostgreSQL Error Reference

Every error, explained

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

3263 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 312 of 3263 errors

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

… is not allowed with set-returning functions in the target list — 0A000

feature_not_supported

PostgreSQL error "… is not allowed with set-returning functions in the target list" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

… cannot be applied to a join — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

… cannot be applied to a function — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

… cannot be applied to a table function — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

… cannot be applied to a WITH query — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

… cannot be applied to a named tuplestore — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

relation “…” cannot be the target of a modifying statement — 0A000

feature_not_supported

PostgreSQL error "relation "…" cannot be the target of a modifying statement" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

set-returning functions must appear at top level of FROM — 0A000

feature_not_supported

PostgreSQL error "set-returning functions must appear at top level of FROM" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

tablesample method … does not support REPEATABLE — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

TABLESAMPLE clause can only be applied to tables and materialized v… — 0A000

feature_not_supported

PostgreSQL error "TABLESAMPLE clause can only be applied to tables and materialized views" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ON CONFLICT is not supported with system catalog tables — 0A000

feature_not_supported

PostgreSQL error "ON CONFLICT is not supported with system catalog tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ON CONFLICT is not supported on table “…” used as a catalog table — 0A000

feature_not_supported

PostgreSQL error "ON CONFLICT is not supported on table "…" used as a catalog table" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

RANGE with offset PRECEDING/FOLLOWING is not supported for column t… — 0A000

feature_not_supported

PostgreSQL error "RANGE with offset PRECEDING/FOLLOWING is not supported for column type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

WITH clause containing a data-modifying statement must be at the to… — 0A000

feature_not_supported

PostgreSQL error "WITH clause containing a data-modifying statement must be at the top level" (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 left side of the UNION must be a… — 0A000

feature_not_supported

PostgreSQL error "with a SEARCH or CYCLE clause, the left side of the UNION must be a SELECT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

mutual recursion between WITH items is not implemented — 0A000

feature_not_supported

PostgreSQL error "mutual recursion between WITH items is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ORDER BY in a recursive query is not implemented — 0A000

feature_not_supported

PostgreSQL error "ORDER BY in a recursive query is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

OFFSET in a recursive query is not implemented — 0A000

feature_not_supported

PostgreSQL error "OFFSET in a recursive query is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

LIMIT in a recursive query is not implemented — 0A000

feature_not_supported

PostgreSQL error "LIMIT in a recursive query is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported