PostgreSQL Error Reference

Every error, explained

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

3910 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 192 of 3910 errors

0A000 ERROR

unsupported set function return mode — 0A000

feature_not_supported

PostgreSQL error "unsupported set function return mode" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

old GIN indexes do not support whole-index scans nor searches for n… — 0A000

feature_not_supported

PostgreSQL error "old GIN indexes do not support whole-index scans nor searches for nulls" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

prepared transaction belongs to another database — 0A000

feature_not_supported

PostgreSQL error "prepared transaction belongs to another database" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY FROM not supported with row-level security — 0A000

feature_not_supported

PostgreSQL error "COPY FROM not supported with row-level security" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter statistics on non-expression column “…” of index “…” — 0A000

feature_not_supported

PostgreSQL error "cannot alter statistics on non-expression column "…" of index "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

WITH CHECK OPTION is supported only on automatically updatable views — 0A000

feature_not_supported

PostgreSQL error "WITH CHECK OPTION is supported only on automatically updatable views" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ROW variable naming in the REFERENCING clause is not supported — 0A000

feature_not_supported

PostgreSQL error "ROW variable naming in the REFERENCING clause is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot rename trigger “…” on table “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot move tuple across partitions when a non-root ancestor of the… — 0A000

feature_not_supported

PostgreSQL error "cannot move tuple across partitions when a non-root ancestor of the source partition is directly referenced in a foreign key" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

aggregate function calls cannot contain set-returning function calls — 0A000

feature_not_supported

PostgreSQL error "aggregate function calls cannot contain set-returning function calls" (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 … and offset type …" (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 has multiple interpretations… — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

set-returning functions are not allowed in … — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

window function calls cannot contain set-returning function calls — 0A000

feature_not_supported

PostgreSQL error "window function calls cannot contain set-returning function calls" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot copy unfinished logical replication slot “…” — 0A000

feature_not_supported

PostgreSQL error "cannot copy unfinished logical replication slot "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

rule actions on OLD are not implemented — 0A000

feature_not_supported

PostgreSQL error "rule actions on OLD are not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

rule actions on NEW are not implemented — 0A000

feature_not_supported

PostgreSQL error "rule actions on NEW are not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSTEAD NOTHING rules on SELECT are not implemented — 0A000

feature_not_supported

PostgreSQL error "INSTEAD NOTHING rules on SELECT are not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot perform INSERT RETURNING on relation “…” — 0A000

feature_not_supported

PostgreSQL error "cannot perform INSERT RETURNING on relation "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot perform UPDATE RETURNING on relation “…” — 0A000

feature_not_supported

PostgreSQL error "cannot perform UPDATE RETURNING on relation "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot perform DELETE RETURNING on relation “…” — 0A000

feature_not_supported

PostgreSQL error "cannot perform DELETE RETURNING on relation "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

could not determine row type for result of … — 0A000

feature_not_supported

PostgreSQL error "could not determine row type for result of …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot convert value from … to … without time zone usage — 0A000

feature_not_supported

PostgreSQL error "cannot convert value from … to … without time zone usage" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

could not set up XML error handler — 0A000

feature_not_supported

PostgreSQL error "could not set up XML error handler" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported