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

55000 ERROR

cannot drop replication slot “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot drop 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 alter replication slot “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot alter 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 create not-null constraint “…” on column “…” of table “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot create not-null constraint "…" on column "…" of table "…"" (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 access replication slot “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "can no longer access 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

publication “…” is defined as FOR ALL TABLES, ALL SEQUENCES — 55000

object_not_in_prerequisite_state

PostgreSQL error "publication "…" is defined as FOR ALL TABLES, ALL SEQUENCES" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

publication “…” is defined as FOR ALL SEQUENCES — 55000

object_not_in_prerequisite_state

PostgreSQL error "publication "…" is defined as FOR ALL SEQUENCES" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

publication “…” does not support ALL TABLES operations — 55000

object_not_in_prerequisite_state

PostgreSQL error "publication "…" does not support ALL TABLES operations" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

WAIT FOR must be called without an active or registered snapshot — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAIT FOR must be called without an active or registered snapshot" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

tuple to be updated was already modified by an operation triggered… — 55000

object_not_in_prerequisite_state

PostgreSQL error "tuple to be updated was already modified by an operation triggered by the current command" (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 generated with full_page_writes=off was replayed since last res… — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL generated with full_page_writes=off was replayed since last restartpoint" (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 generated with full_page_writes=off was replayed during online… — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL generated with full_page_writes=off was replayed during online backup" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

ALTER SUBSCRIPTION with refresh and copy_data is not allowed when t… — 55000

object_not_in_prerequisite_state

PostgreSQL error "ALTER SUBSCRIPTION with refresh and copy_data is not allowed when two_phase is enabled" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

logical replication slot “…” exists, but wal_level < logical — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication slot "…" exists, but wal_level < logical" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

physical replication slot “…” exists, but wal_level < replica — 55000

object_not_in_prerequisite_state

PostgreSQL error "physical replication slot "…" exists, but wal_level < replica" (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 convert table “…” to a view because it has triggers — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not convert table "…" to a view because it has triggers" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

logical replication slot “…” exists on the standby, but hot_standby… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication slot "…" exists on the standby, but hot_standby = off" (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 generated with “full_page_writes=off” was replayed since last r… — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL generated with "full_page_writes=off" was replayed since last restartpoint" (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 generated with “full_page_writes=off” was replayed during onlin… — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL generated with "full_page_writes=off" was replayed during online backup" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

this is an incremental backup, not a data directory — 55000

object_not_in_prerequisite_state

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

Object Not In Prerequisite State
55000 ERROR

manifest requires WAL from final timeline n ending at n/n, but this… — 55000

object_not_in_prerequisite_state

PostgreSQL error "manifest requires WAL from final timeline n ending at n/n, but this backup starts at 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 FATAL

logical replication slot “…” exists, but “wal_level” < "replica" — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication slot "…" exists, but "wal_level" < "replica"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

logical replication slot “…” exists on the standby, but “hot_standb… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication slot "…" exists on the standby, but "hot_standby" = "off"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

physical replication slot “…” exists, but “wal_level” < "replica" — 55000

object_not_in_prerequisite_state

PostgreSQL error "physical replication slot "…" exists, but "wal_level" < "replica"" (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 on standby requires “effective_wal_level” >= “logi… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical decoding on standby requires "effective_wal_level" >= "logical" on the primary" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State