On 1 Mar 2012, at 12:38am, Mario Becroft <m...@becroft.co.nz> wrote:

> Just adding my voice to the choir. The constraints are of limited value
> if you can't tell which one failed, and the system is not much more
> 'lite' if the constraints have to be duplicated using CHECK clauses
> anyway.

Me too.  Either as a new standard way of working, or as something which can be 
turned on and off with a PRAGMA.  I accept that SQLite is meant to be fast, but 
having SQLite spit out which check was violated will result in my app running 
faster and more dependably than when I build the same logic into my own code.

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

Reply via email to