On 3 Jul 2009, at 3:28am, James Gregurich wrote: > How do I maintain referential integrity on a INSERT OR REPLACE given > it does not call the delete trigger on the offending rows?
If SQLite decides that it's going to do a REPLACE rather than an INSERT, does it call the triggers for UPDATE ? I think that would be a good way for it to work. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users