On 19 Apr 2010, at 2:03am, Jean-Christophe Deschamps wrote: > Contrary to what occurs in other engines, SQLite seems to > assert constraints at insert/delete time, ignoring the fact that > (insert or delete) trigger will increment or decrement the upper part > of the tree interval on HI and LO keys (in the case of a nested tree).
This /should/ be handled properly if you make appropriate use of the BEFORE or AFTER words in your TRIGGERs. Can you verify whether you are doing so in this case ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
