I notice that the foreign key clause (http://www.sqlite.org/syntaxdiagrams.html#foreign-key-clause) does not include a conflict clause (http://www.sqlite.org/syntaxdiagrams.html#conflict-clause). I always specify "ON CONFLICT ROLLBACK" with my other constraints, but what will happen when a foreign key violation occurs within a transaction? Will we see the default "ABORT" behavior as with other constraints? How do I get it to rollback the entire transaction in such a case?
Thanks, -Robert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users