On 07/27/2014 12:11 PM, [email protected] wrote: > when enabling foreign_keys via > PRAGMA foreign_keys=ON; > multi row inserts fail when having a foreign key and adding a value as > well as the reference in a transaction fails as well.
Normally, foreign key constraints are checked as soon as each record is inserted/updated/deleted. If you do not want to check these constraints before the end of a transaction, you must make them deferred: <http://www.sqlite.org/foreignkeys.html#fk_deferred> Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
