On Tue, Jun 7, 2011 at 12:11 PM, noah hart <noah.h...@gmail.com> 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users