PostgreSQL Error Reference

Every error, explained

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

578 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 360 of 578 errors

42704 ERROR

index “…” does not exist — 42704

undefined_object

PostgreSQL error "index "…" does not exist" (SQLSTATE 42704): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42704 ERROR

type “…” does not exist — 42704

undefined_object

PostgreSQL error "type "…" does not exist" (SQLSTATE 42704): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42704 ERROR

replication slot “…” does not exist — 42704

undefined_object

PostgreSQL error "replication slot … does not exist — 42704" (SQLSTATE 42704): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42704 ERROR

extension “…” is not available — 42704

undefined_object

PostgreSQL error "extension … is not available — 42704" (SQLSTATE 42704): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42704 ERROR

Undefined Object — SQLSTATE 42704

undefined_object

A referenced object (type, collation, constraint, etc.) does not exist.

Syntax Error or Access Rule Violation
42704 ERROR

constraint “…” of relation “…” does not exist — 42704

undefined_object

PostgreSQL error "constraint … of relation … does not exist — 42704" (SQLSTATE 42704): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42710 ERROR

role “…” already exists — 42710

duplicate_object

PostgreSQL error "role … already exists — 42710" (SQLSTATE 42710): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42710 ERROR

replication slot “…” already exists — 42710

duplicate_object

PostgreSQL error "replication slot … already exists — 42710" (SQLSTATE 42710): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42710 ERROR

role “…” already exists — 42710

duplicate_object

PostgreSQL error "role "…" already exists" (SQLSTATE 42710): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42710 ERROR

type “…” already exists — 42710

duplicate_object

PostgreSQL error "type "…" already exists" (SQLSTATE 42710): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42710 ERROR

constraint “…” for relation “…” already exists — 42710

duplicate_object

PostgreSQL error "constraint "…" for relation "…" already exists" (SQLSTATE 42710): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42710 ERROR

trigger “…” for relation “…” already exists — 42710

duplicate_object

PostgreSQL error "trigger "…" for relation "…" already exists" (SQLSTATE 42710): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42710 ERROR

Duplicate Object — SQLSTATE 42710

duplicate_object

An object with that name already exists.

Syntax Error or Access Rule Violation
42710 ERROR

extension “…” already exists — 42710

duplicate_object

PostgreSQL error "extension … already exists — 42710" (SQLSTATE 42710): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42712 ERROR

Duplicate Alias — SQLSTATE 42712

duplicate_alias

SQLSTATE 42712 (duplicate_alias): The SQL is malformed or references a missing object or privilege.

Syntax Error or Access Rule Violation
42723 ERROR

function … already exists with same argument types — 42723

duplicate_function

PostgreSQL error "function … already exists with same argument types" (SQLSTATE 42723): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42723 ERROR

Duplicate Function — SQLSTATE 42723

duplicate_function

SQLSTATE 42723 (duplicate_function): The SQL is malformed or references a missing object or privilege.

Syntax Error or Access Rule Violation
42725 ERROR

operator is not unique: … — 42725

ambiguous_function

PostgreSQL error "operator is not unique: …" (SQLSTATE 42725): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42725 ERROR

Ambiguous Function — SQLSTATE 42725

ambiguous_function

SQLSTATE 42725 (ambiguous_function): The SQL is malformed or references a missing object or privilege.

Syntax Error or Access Rule Violation
42803 ERROR

aggregate function calls cannot be nested — 42803

grouping_error

PostgreSQL error "aggregate function calls cannot be nested" (SQLSTATE 42803): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42803 ERROR

column “…” must appear in the GROUP BY clause or be used in an aggregate function — 42803

grouping_error

PostgreSQL error "column "…" must appear in the GROUP BY clause or be used in an aggregate function" (SQLSTATE 42803): what it means, common causes, and...

Syntax Error or Access Rule Violation
42803 ERROR

Grouping Error — SQLSTATE 42803

grouping_error

SQLSTATE 42803 (grouping_error): The SQL is malformed or references a missing object or privilege.

Syntax Error or Access Rule Violation
42803 ERROR

aggregate functions are not allowed in WHERE — 42803

grouping_error

PostgreSQL error "aggregate functions are not allowed in WHERE" (SQLSTATE 42803): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation
42804 ERROR

foreign key constraint “…” cannot be implemented — 42804

datatype_mismatch

PostgreSQL error "foreign key constraint "…" cannot be implemented" (SQLSTATE 42804): what it means, common causes, and how to fix it.

Syntax Error or Access Rule Violation