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

55000 ERROR

no replication origin is configured — 55000

object_not_in_prerequisite_state

PostgreSQL error "no replication origin is configured" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

logical replication target relation “…” is missing replicated colum… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication target relation "…" is missing replicated column: …" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

logical replication target relation “…” uses system columns in REPL… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication target relation "…" uses system columns in REPLICA IDENTITY index" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

publisher did not send replica identity column expected by the logi… — 55000

object_not_in_prerequisite_state

PostgreSQL error "publisher did not send replica identity column expected by the logical replication target relation "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

subscription has no replication slot set — 55000

object_not_in_prerequisite_state

PostgreSQL error "subscription has no replication slot set" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

“…” is already a view — 55000

object_not_in_prerequisite_state

PostgreSQL error ""…" is already a view" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

access to non-system view “…” is restricted — 55000

object_not_in_prerequisite_state

PostgreSQL error "access to non-system view "…" is restricted" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

could not attach to a SharedFileSet that is already destroyed — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not attach to a SharedFileSet that is already destroyed" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

enum … contains no values — 55000

object_not_in_prerequisite_state

PostgreSQL error "enum … contains no values" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

specified data directory “…” is not a directory — 55000

object_not_in_prerequisite_state

PostgreSQL error "specified data directory "…" is not a directory" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

database “…” is not currently accepting connections — 55000

object_not_in_prerequisite_state

PostgreSQL error "database "…" is not currently accepting connections" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

could not attach to dynamic shared area — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not attach to dynamic shared area" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

portal “…” cannot be run — 55000

object_not_in_prerequisite_state

PostgreSQL error "portal "…" cannot be run" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot perform transaction commands inside a cursor loop that is no… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot perform transaction commands inside a cursor loop that is not read-only" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

function “…” is in the wrong language — 55000

object_not_in_prerequisite_state

PostgreSQL error "function "…" is in the wrong language" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

function “…” must not be SECURITY DEFINER — 55000

object_not_in_prerequisite_state

PostgreSQL error "function "…" must not be SECURITY DEFINER" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

could not send message — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not send message" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

could not receive message — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not receive message" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

unable to map dynamic shared memory segment — 55000

object_not_in_prerequisite_state

PostgreSQL error "unable to map dynamic shared memory segment" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

bad magic number in dynamic shared memory segment — 55000

object_not_in_prerequisite_state

PostgreSQL error "bad magic number in dynamic shared memory segment" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

too many message queue testing workers already — 55000

object_not_in_prerequisite_state

PostgreSQL error "too many message queue testing workers already" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

logical replication parallel apply worker for subscription “…” will… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication parallel apply worker for subscription "…" will stop" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

table “…” being attached contains an identity column “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "table "…" being attached contains an identity column "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

WAL summarization is not progressing — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL summarization is not progressing" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State