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

55000 ERROR

foreign table “…” does not allow deletes — 55000

object_not_in_prerequisite_state

PostgreSQL error "foreign table "…" does not allow deletes" (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 tuple to shared-memory queue — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not send tuple to shared-memory queue" (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 foreign table is restricted — 55000

object_not_in_prerequisite_state

PostgreSQL error "access to non-system foreign table 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

large object descriptor n was not opened for reading — 55000

object_not_in_prerequisite_state

PostgreSQL error "large object descriptor n was not opened for reading" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

large object descriptor n was not opened for writing — 55000

object_not_in_prerequisite_state

PostgreSQL error "large object descriptor n was not opened for writing" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

index “…” is already associated with a constraint — 55000

object_not_in_prerequisite_state

PostgreSQL error "index "…" is already associated with a constraint" (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 advance replication slot to n/n, minimum is n/n — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot advance replication slot to n/n, minimum is n/n" (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 copy a replication slot that doesn’t reserve WAL — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot copy a replication slot that doesn't reserve WAL" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

highest timeline n of the primary is behind recovery timeline n — 55000

object_not_in_prerequisite_state

PostgreSQL error "highest timeline n of the primary is behind recovery timeline n" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

cannot continue WAL streaming, recovery has already ended — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot continue WAL streaming, recovery has already ended" (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 use a logical replication slot for physical replication — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot use a logical replication slot for physical replication" (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 read from logical replication slot “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot read from logical replication slot "…"" (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 execute new commands while WAL sender is in stopping mode — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot execute new commands while WAL sender is in stopping mode" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

the query interface requires a database connection — 55000

object_not_in_prerequisite_state

PostgreSQL error "the query interface requires a database connection" (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 worker slot n is empty, cannot attach — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication worker slot n is empty, cannot attach" (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 worker slot n is already used by another worker… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication worker slot n is already used by another worker, cannot attach" (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 decoding requires a database connection — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical decoding requires a database connection" (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 use physical replication slot for logical decoding — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot use physical replication slot for logical decoding" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

replication slot “…” was not created in this database — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slot "…" was not created in this database" (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 at prepare time requires a … callback — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication at prepare time requires a … callback" (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 streaming requires a … callback — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical streaming requires a … callback" (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 streaming at prepare time requires a … callback — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical streaming at prepare time requires a … callback" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

can no longer get changes from replication slot “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "can no longer get changes from replication slot "…"" (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 setup replication origin when one is already setup — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot setup replication origin when one is already setup" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State