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

0A000 ERROR

cannot PREPARE a transaction that has created a cursor WITH HOLD — 0A000

feature_not_supported

PostgreSQL error "cannot PREPARE a transaction that has created a cursor WITH HOLD" (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 have isolation level SERIALIZ… — 0A000

feature_not_supported

PostgreSQL error "a snapshot-importing transaction must have isolation level SERIALIZABLE or REPEATABLE READ" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

a serializable transaction cannot import a snapshot from a non-seri… — 0A000

feature_not_supported

PostgreSQL error "a serializable transaction cannot import a snapshot from a non-serializable transaction" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

a non-read-only serializable transaction cannot import a snapshot f… — 0A000

feature_not_supported

PostgreSQL error "a non-read-only serializable transaction cannot import a snapshot from a read-only transaction" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot import a snapshot from a different database — 0A000

feature_not_supported

PostgreSQL error "cannot import a snapshot from a different database" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot allocate multiple Perl interpreters on this platform — 0A000

feature_not_supported

PostgreSQL error "cannot allocate multiple Perl interpreters on this platform" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot set system attribute “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

PL/Perl functions cannot return type … — 0A000

feature_not_supported

PostgreSQL error "PL/Perl functions cannot return type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

PL/Perl functions cannot accept type … — 0A000

feature_not_supported

PostgreSQL error "PL/Perl functions cannot accept type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

trigger functions can only be called as triggers — 0A000

feature_not_supported

PostgreSQL error "trigger functions can only be called as triggers" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

PL/pgSQL functions cannot accept type … — 0A000

feature_not_supported

PostgreSQL error "PL/pgSQL functions cannot accept type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

could not determine actual return type for polymorphic function “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

PL/pgSQL functions cannot return type … — 0A000

feature_not_supported

PostgreSQL error "PL/pgSQL functions cannot return type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

variable “…” has pseudo-type … — 0A000

feature_not_supported

PostgreSQL error "variable "…" has pseudo-type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

could not determine actual argument type for polymorphic function “…” — 0A000

feature_not_supported

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

Feature Not Supported
0A000 ERROR

cannot COPY to/from client in PL/pgSQL — 0A000

feature_not_supported

PostgreSQL error "cannot COPY to/from client in PL/pgSQL" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

unsupported transaction command in PL/pgSQL — 0A000

feature_not_supported

PostgreSQL error "unsupported transaction command in PL/pgSQL" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

EXECUTE of transaction commands is not implemented — 0A000

feature_not_supported

PostgreSQL error "EXECUTE of transaction commands is not implemented" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

PL/Python functions cannot return type … — 0A000

feature_not_supported

PostgreSQL error "PL/Python functions cannot return type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

PL/Python functions cannot accept type … — 0A000

feature_not_supported

PostgreSQL error "PL/Python functions cannot accept type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

PL/Tcl functions cannot return type … — 0A000

feature_not_supported

PostgreSQL error "PL/Tcl functions cannot return type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

PL/Tcl functions cannot accept type … — 0A000

feature_not_supported

PostgreSQL error "PL/Tcl functions cannot accept type …" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot SET SCHEMA of extension “…” because other extensions prevent it — 0A000

feature_not_supported

PostgreSQL error "cannot SET SCHEMA of extension "…" because other extensions prevent it" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

virtual generated column “…” cannot have a user-defined type — 0A000

feature_not_supported

PostgreSQL error "virtual generated column "…" cannot have a user-defined type" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported