PostgreSQL Error Reference

Every error, explained

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

3864 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3600 of 3864 errors

55000 ERROR

WAL summaries are required on timeline n from n/n to n/n, but the s… — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL summaries are required on timeline n from n/n to n/n, but the summaries for that timeline and LSN range are incomplete" (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 set option “…” for a subscription that does not have a slot… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot set option "…" for a subscription that does not have a slot name" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

column “…” of relation “…” is not a generated column — 55000

object_not_in_prerequisite_state

PostgreSQL error "column "…" of relation "…" is not a generated 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

replication slots can only be used if “…” > 0 — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slots can only be used if "…" > 0" (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 slots can only be used if “wal_level” >= “replica” — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slots can only be used if "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

replication slots can only be synchronized to a standby server — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slots can only be synchronized to a standby server" (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 “wal_level” >= “logical” — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical decoding requires "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 ERROR

cannot query or manipulate replication origin when “max_active_repl… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot query or manipulate replication origin when "max_active_replication_origins" is 0" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

exiting from slot synchronization because same name slot “…” alread… — 55000

object_not_in_prerequisite_state

PostgreSQL error "exiting from slot synchronization because same name slot "…" already exists on the standby" (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 synchronization will stop because promotion is tri… — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slot synchronization will stop because promotion is triggered" (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 synchronization will not start because promotion w… — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slot synchronization will not start because promotion was triggered" (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 synchronize replication slots concurrently — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot synchronize replication slots concurrently" (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 set option “…” for enabled subscription — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot set option "…" for enabled subscription" (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 inherited constraint “…” on relation “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot alter inherited constraint "…" on 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

cannot validate NOT ENFORCED constraint — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot validate NOT ENFORCED 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

logical replication target relation “…” has incompatible generated… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication target relation "…" has incompatible generated 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

cannot execute … on partitioned table “…” USING INDEX with no index… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot execute … on partitioned table "…" USING INDEX with no index name" (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 not allowed for disabled subscriptions — 55000

object_not_in_prerequisite_state

PostgreSQL error "… is not allowed for disabled subscriptions" (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 enable retain_dead_tuples if the publisher is running a vers… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot enable retain_dead_tuples if the publisher is running a version earlier than PostgreSQL 19" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

relation “…” type mismatch: source “…”, target “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "relation "…" type mismatch: source "…", target "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

REPACK can only be used if “…” > 0 — 55000

object_not_in_prerequisite_state

PostgreSQL error "REPACK can only be used if "…" > 0" (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 PID n for inactive replication origin with ID n — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot use PID n for inactive replication origin with ID 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

logical replication sequence synchronization failed for subscriptio… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication sequence synchronization failed for subscription "…"" (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 detect conflict as the leader apply worker has exited — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not detect conflict as the leader apply worker has exited" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State