On 26 Jun 2011, at 10:41pm, Kees Nuyt wrote: > I think Cecil was referring to the fact that some program can > forget to switch foreign_keys to on, and delete rows that are > referenced, or change primary keys.
Ah. Okay. Yes, that can present a problem. There's an argument that switching foreign_keys on should set a bit in the database so it will no longer work with foreign_keys off. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users