Check out our free resources, like our pganalyze eBooks and sign up to our newsletter.

V103: New row for relation violates check 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: 23514 (Class 23 — Integrity Constraint Violation: check_violation)
Urgency: low

Example Postgres Log Output:

ERROR: new row for relation "test" violates check constraint "positive_value_check"
DETAIL: Failing row contains (-123).
ERROR: check constraint "valid_tag" is violated by some row
ERROR: column "mycolumn" of table "test" contains values that violate the new constraint
ERROR: value for domain mydomain violates check constraint "mydomain_check"



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 →