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

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
55000 ERROR

cannot generate DDL for invalid database “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot generate DDL for invalid 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

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

object_not_in_prerequisite_state

PostgreSQL error "manifest requires WAL from non-final timeline n ending at n/n, but this server switched timelines 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 ERROR

WAL summaries are required on timeline n from n/n to n/n, but no su… — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL summaries are required on timeline n from n/n to n/n, but no summaries for that timeline and LSN range exist" (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 neither REPLICA IDENTIT… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication target relation "…" has neither REPLICA IDENTITY index nor PRIMARY KEY and published relation does not have REPLICA IDENTITY FULL" (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 create unique index “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not create unique index … — 55000" (SQLSTATE 55000): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55006 ERROR

database “…” is being accessed by other users — 55006

object_in_use

PostgreSQL error "database "…" is being accessed by other users" (SQLSTATE 55006): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55006 ERROR

cannot drop the currently open database — 55006

object_in_use

PostgreSQL error "cannot drop the currently open database" (SQLSTATE 55006): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55006 ERROR

cannot ALTER TABLE “…” because it has pending trigger events — 55006

object_in_use

PostgreSQL error "cannot ALTER TABLE "…" because it has pending trigger events" (SQLSTATE 55006): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55006 ERROR

Object In Use — SQLSTATE 55006

object_in_use

The operation cannot proceed because the object is currently in use.

Object Not In Prerequisite State
55006 ERROR

database “…” is used by an active logical replication slot — 55006

object_in_use

PostgreSQL error "database "…" is used by an active logical replication slot" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55006 ERROR

database “…” is being used by logical replication subscription — 55006

object_in_use

PostgreSQL error "database "…" is being used by logical replication subscription" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55006 ERROR

database “…” is being used by prepared transactions — 55006

object_in_use

PostgreSQL error "database "…" is being used by prepared transactions" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55006 ERROR

source database “…” is being accessed by other users — 55006

object_in_use

PostgreSQL error "source database "…" is being accessed by other users" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55006 ERROR

cannot change the tablespace of the currently open database — 55006

object_in_use

PostgreSQL error "cannot change the tablespace of the currently open database" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State