Is additional Check Constraint info available?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Is additional Check Constraint info available?

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
Reply | Threaded
Open this post in threaded view
|

Re: Is additional Check Constraint info available?

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
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users