PostgreSQL Error Reference

Every error, explained

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

3304 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 336 of 3304 errors

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

FOR UPDATE/SHARE in a recursive query is not implemented — 0A000

feature_not_supported

PostgreSQL error "FOR UPDATE/SHARE 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

row expansion via “*” is not supported here — 0A000

feature_not_supported

PostgreSQL error "row expansion via "*" is not supported here" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

source for a multiple-column UPDATE item must be a sub-SELECT or RO… — 0A000

feature_not_supported

PostgreSQL error "source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot compare rows of zero length — 0A000

feature_not_supported

PostgreSQL error "cannot compare rows of zero length" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

OVER is not supported for ordered-set aggregate … — 0A000

feature_not_supported

PostgreSQL error "OVER is not supported for ordered-set aggregate …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

aggregates cannot use named arguments — 0A000

feature_not_supported

PostgreSQL error "aggregates cannot use named arguments" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

aggregate ORDER BY is not implemented for window functions — 0A000

feature_not_supported

PostgreSQL error "aggregate ORDER BY is not implemented for window functions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

FILTER is not implemented for non-aggregate window functions — 0A000

feature_not_supported

PostgreSQL error "FILTER is not implemented for non-aggregate window functions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

WITH query “…” does not have a RETURNING clause — 0A000

feature_not_supported

PostgreSQL error "WITH query "…" does not have a RETURNING clause" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot assign to system column “…” — 0A000

feature_not_supported

PostgreSQL error "cannot assign to system column "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot set an array element to DEFAULT — 0A000

feature_not_supported

PostgreSQL error "cannot set an array element to DEFAULT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot set a subfield to DEFAULT — 0A000

feature_not_supported

PostgreSQL error "cannot set a subfield to DEFAULT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

array of serial is not implemented — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

identity columns are not supported on typed tables — 0A000

feature_not_supported

PostgreSQL error "identity columns are not supported on typed tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

identity columns are not supported on partitions — 0A000

feature_not_supported

PostgreSQL error "identity columns 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

generated columns are not supported on typed tables — 0A000

feature_not_supported

PostgreSQL error "generated columns are not supported on typed tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

primary key constraints are not supported on foreign tables — 0A000

feature_not_supported

PostgreSQL error "primary key constraints are not supported on foreign tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

unique constraints are not supported on foreign tables — 0A000

feature_not_supported

PostgreSQL error "unique constraints are not supported on foreign tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

exclusion constraints are not supported on foreign tables — 0A000

feature_not_supported

PostgreSQL error "exclusion constraints are not supported on foreign tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use an existing index in CREATE TABLE — 0A000

feature_not_supported

PostgreSQL error "cannot use an existing index in CREATE TABLE" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported