On Fri, 9 Mar 2018 19:42:19 +0000 Simon Slavin <slav...@bigfraud.org> wrote:
> On 9 Mar 2018, at 7:11pm, John Found <johnfo...@asm32.info> wrote: > > > "insert or replace" succeed without deleting the old rows from B. > > "replace" means "delete the original row, then insert a new one". > > In your code, figure out whether you need INSERT or UPDATE, and do the > appropriate one. > You are right. And Jay Kreibich in his post above. But then the second solution from my post should be the correct behavior. 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. > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- http://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
