On 11/18/2015 00:45, Dominique Devienne wrote: > True. But that's in the case where FK constraints validation is deferred to > the transaction end.
Why does SQLite defer constraint violation errors? Is there a benefit? This only complicates things, I would rather see the statement fail immediately. Yuri