PostgreSQL Error Reference

Every error, explained

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

578 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 48 of 578 errors

08006 ERROR

SSL connection has been closed unexpectedly — 08006

connection_failure

PostgreSQL error "SSL connection has been closed unexpectedly" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

connection to server at “…”, port … failed — 08006

connection_failure

PostgreSQL error "connection to server at "…", port … failed" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

server closed the connection unexpectedly — 08006

connection_failure

PostgreSQL error "server closed the connection unexpectedly" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 FATAL

could not connect to the primary server: connection refused — 08006

connection_failure

PostgreSQL error "could not connect to the primary server: connection refused — 08006" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 FATAL

connection to server was lost — 08006

connection_failure

PostgreSQL error "connection to server was lost — 08006" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 FATAL

SSL SYSCALL error: EOF detected — 08006

connection_failure

PostgreSQL error "SSL SYSCALL error: EOF detected — 08006" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

Connection Failure — SQLSTATE 08006

connection_failure

The connection to the server was lost or could not be completed — a network or availability problem, not a SQL problem.

Connection Exception
08007 ERROR

Transaction Resolution Unknown — SQLSTATE 08007

transaction_resolution_unknown

SQLSTATE 08007 (transaction_resolution_unknown): The client/server connection could not be established or was lost.

Connection Exception
08P01 ERROR

Protocol Violation — SQLSTATE 08P01

protocol_violation

The client/server wire protocol was violated.

Connection Exception
08P01 ERROR

received invalid response to SSL negotiation — 08P01

protocol_violation

PostgreSQL error "received invalid response to SSL negotiation" (SQLSTATE 08P01): what it means, common causes, and how to fix it.

Connection Exception
09000 ERROR

Triggered Action Exception — SQLSTATE 09000

triggered_action_exception

SQLSTATE 09000 (triggered_action_exception): A trigger raised an error while firing.

Triggered Action Exception
0A000 ERROR

cannot alter type of a column used by a view or rule — 0A000

feature_not_supported

PostgreSQL error "cannot alter type of a column used by a view or rule" (SQLSTATE 0A000): 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): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter type of a column used by a view or rule — 0A000

feature_not_supported

PostgreSQL error "cannot alter type of a column used by a view or rule — 0A000" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use subquery in DEFAULT expression — 0A000

feature_not_supported

PostgreSQL error "cannot use subquery in DEFAULT expression" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

set-returning functions are not allowed in WHERE — 0A000

feature_not_supported

PostgreSQL error "set-returning functions are not allowed in WHERE" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

DISTINCT is not implemented for window functions — 0A000

feature_not_supported

PostgreSQL error "DISTINCT is not implemented for window functions" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

SELECT FOR UPDATE/SHARE is not allowed with aggregate functions — 0A000

feature_not_supported

PostgreSQL error "SELECT FOR UPDATE/SHARE is not allowed with aggregate functions" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

FOR UPDATE cannot be applied to the nullable side of an outer join — 0A000

feature_not_supported

PostgreSQL error "FOR UPDATE cannot be applied to the nullable side of an outer join" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

WHERE CURRENT OF is not supported for this table type — 0A000

feature_not_supported

PostgreSQL error "WHERE CURRENT OF is not supported for this table type" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

Feature Not Supported — SQLSTATE 0A000

feature_not_supported

The requested feature is not supported in this context or version.

Feature Not Supported
0A000 ERROR

cannot use column references in default expression — 0A000

feature_not_supported

PostgreSQL error "cannot use column references in default expression — 0A000" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot insert into view “…” — 0A000

feature_not_supported

PostgreSQL error "cannot insert into view … — 0A000" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0B000 ERROR

Invalid Transaction Initiation — SQLSTATE 0B000

invalid_transaction_initiation

SQLSTATE 0B000 (invalid_transaction_initiation): A transaction could not be initiated.

Invalid Transaction Initiation