> It would/should have told you immediately that you needed those two > additional indexes, I should think.
Unfortunately not. Someone told me about ".expert" some time ago and it's indeed helpful for me because I never know what indexes to create and why. But for this database everything seemed ok: SQLite version 3.30.1 2019-10-10 20:19:45 Enter ".help" for usage hints. sqlite> pragma foreign_keys=on; sqlite> pragma foreign_keys; 1 sqlite> .expert sqlite> delete from dataset; (no new indexes) (null) sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users