PostgreSQL Error Reference

Every error, explained

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

2967 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 336 of 2967 errors

0A000 ERROR

array must not contain nulls — 0A000

feature_not_supported

PostgreSQL error "array must not contain nulls" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

array must have even number of elements — 0A000

feature_not_supported

PostgreSQL error "array must have even number of elements" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

logical decoding output plugin “…” produces binary output, but func… — 0A000

feature_not_supported

PostgreSQL error "logical decoding output plugin "…" produces binary output, but function "…" expects textual data" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

user “…” cannot replicate into relation with row-level security ena… — 0A000

feature_not_supported

PostgreSQL error "user "…" cannot replicate into relation with row-level security enabled: "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

multiple actions for rules on SELECT are not implemented — 0A000

feature_not_supported

PostgreSQL error "multiple actions for 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

rules on SELECT must have action INSTEAD SELECT — 0A000

feature_not_supported

PostgreSQL error "rules on SELECT must have action INSTEAD SELECT" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

rules on SELECT must not contain data-modifying statements in WITH — 0A000

feature_not_supported

PostgreSQL error "rules on SELECT 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

event qualifications are not implemented for rules on SELECT — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot have multiple RETURNING lists in a rule — 0A000

feature_not_supported

PostgreSQL error "cannot have multiple RETURNING lists in a rule" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

RETURNING lists are not supported in conditional rules — 0A000

feature_not_supported

PostgreSQL error "RETURNING lists are not supported in conditional rules" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

RETURNING lists are not supported in non-INSTEAD rules — 0A000

feature_not_supported

PostgreSQL error "RETURNING lists are not supported in non-INSTEAD rules" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot convert relation containing dropped columns to view — 0A000

feature_not_supported

PostgreSQL error "cannot convert relation containing dropped columns to view" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

WITH query name “…” appears in both a rule action and the query bei… — 0A000

feature_not_supported

PostgreSQL error "WITH query name "…" appears in both a rule action and the query being rewritten" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot have RETURNING lists in multiple rules — 0A000

feature_not_supported

PostgreSQL error "cannot have RETURNING lists in multiple rules" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot insert into column “…” of view “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot update column “…” of view “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

DO INSTEAD NOTIFY rules are not supported for data-modifying statem… — 0A000

feature_not_supported

PostgreSQL error "DO INSTEAD NOTIFY rules are not supported for 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

DO INSTEAD NOTHING rules are not supported for data-modifying state… — 0A000

feature_not_supported

PostgreSQL error "DO INSTEAD NOTHING rules are not supported for 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

conditional DO INSTEAD rules are not supported for data-modifying s… — 0A000

feature_not_supported

PostgreSQL error "conditional DO INSTEAD rules are not supported for 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

DO ALSO rules are not supported for data-modifying statements in WITH — 0A000

feature_not_supported

PostgreSQL error "DO ALSO rules are not supported for 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

multi-statement DO INSTEAD rules are not supported for data-modifyi… — 0A000

feature_not_supported

PostgreSQL error "multi-statement DO INSTEAD rules are not supported for 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

WITH cannot be used in a query that is rewritten by rules into mult… — 0A000

feature_not_supported

PostgreSQL error "WITH cannot be used in a query that is rewritten by rules into multiple queries" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

conditional utility statements are not implemented — 0A000

feature_not_supported

PostgreSQL error "conditional utility statements are not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

WHERE CURRENT OF on a view is not implemented — 0A000

feature_not_supported

PostgreSQL error "WHERE CURRENT OF on a view is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported