PostgreSQL Error Reference

Every error, explained

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

2769 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 336 of 2769 errors

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

function returning record called in context that cannot accept type… — 0A000

feature_not_supported

PostgreSQL error "function returning record called in context that cannot accept type record" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot access temporary tables of other sessions — 0A000

feature_not_supported

PostgreSQL error "cannot access temporary tables of other sessions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

a snapshot-importing transaction must not be READ ONLY DEFERRABLE — 0A000

feature_not_supported

PostgreSQL error "a snapshot-importing transaction must not be READ ONLY DEFERRABLE" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot call function “…” via fastpath interface — 0A000

feature_not_supported

PostgreSQL error "cannot call function "…" via fastpath interface" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot execute … within a background process — 0A000

feature_not_supported

PostgreSQL error "cannot execute … within a background process" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

CREATE STATISTICS only supports relation names in the FROM clause — 0A000

feature_not_supported

PostgreSQL error "CREATE STATISTICS only supports relation names in the FROM clause" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

text search parser does not support headline creation — 0A000

feature_not_supported

PostgreSQL error "text search parser does not support headline creation" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

aclinsert is no longer supported — 0A000

feature_not_supported

PostgreSQL error "aclinsert is no longer supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

aclremove is no longer supported — 0A000

feature_not_supported

PostgreSQL error "aclremove is no longer supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

slices of fixed-length arrays not implemented — 0A000

feature_not_supported

PostgreSQL error "slices of fixed-length arrays not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

updates on slices of fixed-length arrays not implemented — 0A000

feature_not_supported

PostgreSQL error "updates on slices of fixed-length arrays not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

removing elements from multidimensional arrays is not supported — 0A000

feature_not_supported

PostgreSQL error "removing elements from multidimensional arrays is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

searching for elements in multidimensional arrays is not supported — 0A000

feature_not_supported

PostgreSQL error "searching for elements in multidimensional arrays is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

encoding conversion from … to ASCII not supported — 0A000

feature_not_supported

PostgreSQL error "encoding conversion from … to ASCII not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

could not determine actual enum type — 0A000

feature_not_supported

PostgreSQL error "could not determine actual enum type" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

“EEEE” not supported for input — 0A000

feature_not_supported

PostgreSQL error ""EEEE" not supported for input" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

materialize mode required, but it is not allowed in this context — 0A000

feature_not_supported

PostgreSQL error "materialize mode required, but it is not allowed in this context" (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 ILIKE — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

case insensitive matching not supported on type bytea — 0A000

feature_not_supported

PostgreSQL error "case insensitive matching not supported on type bytea" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

regular-expression matching not supported on type bytea — 0A000

feature_not_supported

PostgreSQL error "regular-expression matching not supported on type bytea" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported