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

0A000 ERROR

cannot execute SQL commands in WAL sender for physical replication — 0A000

feature_not_supported

PostgreSQL error "cannot execute SQL commands in WAL sender for physical replication" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

array must be one-dimensional — 0A000

feature_not_supported

PostgreSQL error "array must be one-dimensional" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
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