Join more than 25k Postgres enthusiasts and sign up for our newsletter!

V104: Conflicting key value violates exclusion 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: 23P01 (Class 23 — Integrity Constraint Violation: exclusion_violation)
Urgency: low

Example Postgres Log Output:

ERROR: conflicting key value violates exclusion constraint "reservation_during_excl"
DETAIL: Key (during)=(["2010-01-01 14:45:00","2010-01-01 15:45:00")) conflicts with existing key (during)=(["2010-01-01 11:30:00","2010-01-01 15:00:00")).
STATEMENT: INSERT INTO reservation VALUES ('[2010-01-01 14:45, 2010-01-01 15:45)');

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 →