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

55000 ERROR

table “…” is not a member of the extension being created — 55000

object_not_in_prerequisite_state

PostgreSQL error "table "…" is not a member of the extension being created" (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 move extension “…” into schema “…” because the extension con… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot move extension "…" into schema "…" because the extension contains the schema" (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 add schema “…” to extension “…” because the schema contains… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot add schema "…" to extension "…" because the schema contains the 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

foreign-data wrapper “…” has no handler — 55000

object_not_in_prerequisite_state

PostgreSQL error "foreign-data wrapper "…" has no handler" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

currval of sequence “…” is not yet defined in this session — 55000

object_not_in_prerequisite_state

PostgreSQL error "currval of sequence "…" is not yet defined in this session" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

lastval is not yet defined in this session — 55000

object_not_in_prerequisite_state

PostgreSQL error "lastval is not yet defined in this session" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

sequence must have same owner as table it is linked to — 55000

object_not_in_prerequisite_state

PostgreSQL error "sequence must have same owner as table it is linked to" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

sequence must be in same schema as table it is linked to — 55000

object_not_in_prerequisite_state

PostgreSQL error "sequence must be in same schema as table it is linked to" (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 … for enabled subscription — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot set … 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 enable subscription that does not have a slot name — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot enable 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 “…” must be declared NOT NULL before identit… — 55000

object_not_in_prerequisite_state

PostgreSQL error "column "…" of relation "…" must be declared NOT NULL before identity can be added" (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 already an identity column — 55000

object_not_in_prerequisite_state

PostgreSQL error "column "…" of relation "…" is already an identity 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

column “…” of relation “…” already has a default value — 55000

object_not_in_prerequisite_state

PostgreSQL error "column "…" of relation "…" already has a default value" (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 an identity column — 55000

object_not_in_prerequisite_state

PostgreSQL error "column "…" of relation "…" is not an identity 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 use a deferrable primary key for referenced table “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot use a deferrable primary key for referenced 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

cannot use a deferrable unique constraint for referenced table “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot use a deferrable unique constraint for referenced 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

cannot detach partitions concurrently when a default partition exists — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot detach partitions concurrently when a default partition exists" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

partitioned table “…” was removed concurrently — 55000

object_not_in_prerequisite_state

PostgreSQL error "partitioned table "…" was removed 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

partition “…” was removed concurrently — 55000

object_not_in_prerequisite_state

PostgreSQL error "partition "…" was removed 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

tablespace “…” is not empty — 55000

object_not_in_prerequisite_state

PostgreSQL error "tablespace "…" is not empty" (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 directory or symbolic link — 55000

object_not_in_prerequisite_state

PostgreSQL error ""…" is not a directory or symbolic link" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

ON CONFLICT does not support deferrable unique constraints/exclusio… — 55000

object_not_in_prerequisite_state

PostgreSQL error "ON CONFLICT does not support deferrable unique constraints/exclusion constraints as arbiters" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

foreign table “…” does not allow inserts — 55000

object_not_in_prerequisite_state

PostgreSQL error "foreign table "…" does not allow inserts" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

foreign table “…” does not allow updates — 55000

object_not_in_prerequisite_state

PostgreSQL error "foreign table "…" does not allow updates" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State