PostgreSQL Error Reference

Every error, explained

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

3243 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 360 of 3243 errors

0A000 ERROR

huge pages not supported on this platform — 0A000

feature_not_supported

PostgreSQL error "huge pages not supported on this platform" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 FATAL

unsupported frontend protocol n.n: server supports n.0 to n.n — 0A000

feature_not_supported

PostgreSQL error "unsupported frontend protocol n.n: server supports n.0 to n.n" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

nondeterministic collations are not supported for regular expressions — 0A000

feature_not_supported

PostgreSQL error "nondeterministic collations are not supported for regular expressions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot copy physical replication slot “…” as a logical replication… — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot use … with a logical replication slot — 0A000

feature_not_supported

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

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