Re: [sqlite] Is additional Check Constraint info available?

2011-06-09 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 06/09/2011 10:57 AM, Noah Hart wrote:
> there any way to tell which of the constraint would have been violated? 

No.  Long known issue (since January 2006) with uninformative constraint
failure messages:

  http://www.sqlite.org/src/tktview?name=23b2128201

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk3xLhoACgkQmOOfHg372QSUhgCglhvFQqIzPk7D+ISnkfqH7L6X
V+oAn1TNYK3HfENKu8OeouDmnvYs47fj
=YDkP
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Is additional Check Constraint info available?

2011-06-09 Thread Noah Hart

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? 


Thanks,

Noah Hart
-- 
View this message in context: 
http://old.nabble.com/Is-additional-Check-Constraint-info-available--tp31812082p31812082.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users