On Tue, Jun 7, 2011 at 12:11 PM, noah hart <[email protected]> wrote:
> Assume that a table has several check restraints, such as a unique index > and > a foreign key. > > When inserting a row that violates more than one of the constraints, is > there any way to tell which of the constraint would have > been violated? > No. The current implementation takes all CHECK constraints for a table, connects them together with AND operators, and evaluates that one expression. If the expression returns FALSE, it raises an exception. > > Thanks, > > Noah Hart > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
