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 3408 of 3863 errors

55000 ERROR

access method “…” is not of type … — 55000

object_not_in_prerequisite_state

PostgreSQL error "access method "…" is not of type …" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

Object Not In Prerequisite State — SQLSTATE 55000

object_not_in_prerequisite_state

The object is not in a state that permits the operation.

Object Not In Prerequisite State
55000 ERROR

cannot alter constraint “…” on relation “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot alter 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

… is not a member of extension “…” — 55000

object_not_in_prerequisite_state

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

Object Not In Prerequisite State
55000 ERROR

materialized view “…” has not been populated — 55000

object_not_in_prerequisite_state

PostgreSQL error "materialized view "…" has not been populated" (SQLSTATE 55000): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

recovery is not in progress — 55000

object_not_in_prerequisite_state

PostgreSQL error "recovery is not in progress" (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 complete detaching partition “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot complete detaching partition "…"" (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 — 55000

object_not_in_prerequisite_state

PostgreSQL error "publication "…" is defined as FOR ALL TABLES" (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 change table “…” to unlogged because it is part of a publica… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot change table "…" to unlogged because it is part of a publication" (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 attach index “…” as a partition of index “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot attach index "…" as a partition of 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

replication slot “…” cannot be advanced — 55000

object_not_in_prerequisite_state

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

Object Not In Prerequisite State
55000 ERROR

database system identifier differs between the primary and standby — 55000

object_not_in_prerequisite_state

PostgreSQL error "database system identifier differs between the primary and 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

could not import the requested snapshot — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not import the requested snapshot" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

data directory “…” has invalid permissions — 55000

object_not_in_prerequisite_state

PostgreSQL error "data directory "…" has invalid permissions" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

record “…” is not assigned yet — 55000

object_not_in_prerequisite_state

PostgreSQL error "record "…" is not assigned yet" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

recovery is in progress — 55000

object_not_in_prerequisite_state

PostgreSQL error "recovery is in progress" (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 get commit timestamp data — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not get commit timestamp data" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

parallel worker failed to initialize — 55000

object_not_in_prerequisite_state

PostgreSQL error "parallel worker failed to initialize" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

prepared transactions are disabled — 55000

object_not_in_prerequisite_state

PostgreSQL error "prepared transactions are disabled" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

WAL ends before end of online backup — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL ends before end of 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

WAL level not sufficient for making an online backup — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL level not sufficient for making an 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

the standby was promoted during online backup — 55000

object_not_in_prerequisite_state

PostgreSQL error "the standby was promoted 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

backup is not in progress — 55000

object_not_in_prerequisite_state

PostgreSQL error "backup is not in progress" (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 level not sufficient for creating a restore point — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL level not sufficient for creating a restore point" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State