Constraint Errors: What Blew Up?

Giganews Newsgroups
Subject: Constraint Errors: What Blew Up?
Posted by:  Gene Wirchenko (gen…@ocis.net)
Date: Mon, 21 May 2012

Dear SQLers:

    If a constraint of some sort is violated, how can I find out
which one?

    Yes, I can parse the error message hoping to find it, but, as
pointed out by Erland, that is subject to the error message being
changed.  I prefer to avoid kludges.

    Is there a function that returns this value?

    Anyone for an error_constraint() function?

Sincerely,

Gene Wirchenko

Replies