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

0A000 ERROR

cannot reindex temporary tables of other sessions — 0A000

feature_not_supported

PostgreSQL error "cannot reindex 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

cannot reindex invalid index on TOAST table — 0A000

feature_not_supported

PostgreSQL error "cannot reindex invalid index on TOAST table" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot move system relation “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cross-database references are not implemented: … — 0A000

feature_not_supported

PostgreSQL error "cross-database references are not implemented: …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot move objects into or out of temporary schemas — 0A000

feature_not_supported

PostgreSQL error "cannot move objects into or out of temporary schemas" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot move objects into or out of TOAST schema — 0A000

feature_not_supported

PostgreSQL error "cannot move objects into or out of TOAST schema" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

a variadic ordered-set aggregate must use VARIADIC type ANY — 0A000

feature_not_supported

PostgreSQL error "a variadic ordered-set aggregate must use VARIADIC type ANY" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot remove dependency on … because it is a system object — 0A000

feature_not_supported

PostgreSQL error "cannot remove dependency on … because it is a system object" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot PREPARE a transaction that has executed LISTEN, UNLISTEN, or… — 0A000

feature_not_supported

PostgreSQL error "cannot PREPARE a transaction that has executed LISTEN, UNLISTEN, or NOTIFY" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot cluster on index “…” because access method does not support… — 0A000

feature_not_supported

PostgreSQL error "cannot cluster on index "…" because access method does not support clustering" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot cluster on partial index “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot cluster on invalid index “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

nondeterministic collations not supported with this provider — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

current database’s encoding is not supported with this provider — 0A000

feature_not_supported

PostgreSQL error "current database's encoding is not supported with this provider" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use “…” with HEADER in COPY TO — 0A000

feature_not_supported

PostgreSQL error "cannot use "…" with HEADER in COPY TO" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY delimiter must be a single one-byte character — 0A000

feature_not_supported

PostgreSQL error "COPY delimiter must be a single one-byte character" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY quote must be a single one-byte character — 0A000

feature_not_supported

PostgreSQL error "COPY quote must be a single one-byte character" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY escape must be a single one-byte character — 0A000

feature_not_supported

PostgreSQL error "COPY escape must be a single one-byte character" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot perform COPY FREEZE on a partitioned table — 0A000

feature_not_supported

PostgreSQL error "cannot perform COPY FREEZE on a partitioned table" (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 COPY — 0A000

feature_not_supported

PostgreSQL error "DO INSTEAD NOTHING rules are not supported for COPY" (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 COPY — 0A000

feature_not_supported

PostgreSQL error "conditional DO INSTEAD rules are not supported for COPY" (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 COPY — 0A000

feature_not_supported

PostgreSQL error "DO ALSO rules are not supported for COPY" (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 COPY — 0A000

feature_not_supported

PostgreSQL error "multi-statement DO INSTEAD rules are not supported for COPY" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY (SELECT INTO) is not supported — 0A000

feature_not_supported

PostgreSQL error "COPY (SELECT INTO) is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported