On Fri, 9 Mar 2018 19:42:19 +0000 Simon Slavin <[email protected]> wrote:
> On 9 Mar 2018, at 7:11pm, John Found <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- http://fresh.flatassembler.net http://asm32.info John Found <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
