On 9 Mar 2018, at 7:49pm, John Found <[email protected]> wrote: > In the current implementation "insert or replace" behave as the foreign > constraint is deferred. > But according to documentation, all foreign constraints in SQLite are > immediate by default.
John, The documentation suggests that in SQLite foreign keys are not deferred by default. Section 4.2 of <https://sqlite.org/foreignkeys.html> talks about this and shows how to set up a foreign key to be deferred: create table B ( aid references A(id) on delete cascade DEFERRABLE INITIALLY DEFERRED, ulti_data) Assuming you are using atomic commit (not using BEGIN/COMMIT, so SQLite "inserts" them around that single statement) I /think/ this should allow your code to work the way you intended. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
