Notice: We've updated our Privacy Policy, effective November 14, 2024.

V100: Duplicate key value violates unique constraint

Work in Progress

This documentation page is currently being worked on. We apologize for the page being incomplete or not available yet.

Category: Constraint Violations
SQLSTATE: 23505 (Class 23 — Integrity Constraint Violation: unique_violation)
Urgency: low

Example Postgres Log Output:

ERROR: duplicate key value violates unique constraint "test_constraint"
DETAIL: Key (b, c)=(12345, mysecretdata) already exists.
STATEMENT: INSERT INTO a (b, c) VALUES ($1,$2) RETURNING id

Explanation:

...

Recommended Action:

...

Learn More:

No additional resources available.


Download Free eBook: The Top 6 Postgres Log Events
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →