Re: [sqlite] FOREIGN KEY constraint not respected during bulk insert using TRANSACTION

On Fri, 14 Dec 2018 15:05:29 +, Morten Joergensen wrote: > Hi, > > I have two tables, the second with a FOREIGN KEY - ON DELETE > CASCADE to the primary key on the first table. When I do a > transaction inserting a lot of records into the second table > at once, I am allowed to insert

[sqlite] FOREIGN KEY constraint not respected during bulk insert using TRANSACTION

Hi, I have two tables, the second with a FOREIGN KEY - ON DELETE CASCADE to the primary key on the first table. When I do a transaction inserting a lot of records into the second table at once, I am allowed to insert records that do not fulfill the constraint, i.e. having values in the foreign