My specific problem is solved with -

sqlite>  PRAGMA ignore_check_constraints = 1;
sqlite>  PRAGMA integrity_check;
sqlite>  PRAGMA ignore_check_constraints = 0;

An option on integrity_check() to do the same would be nice.

On Mon, Apr 3, 2017 at 11:40 AM, Richard Hipp <[email protected]> wrote:
> On 4/2/17, Simon Slavin <[email protected]> wrote:
>>
>>> On 3 Apr 2017, at 2:11am, David Burgess <[email protected]> wrote:
>>>
>>> (I guess I should re-check
>>> to see if that has changed since 3.7)
>>
>> Yep.  Many speedups in recent versions of SQLite.
>>
>
> But not in triggers :-)
> --
> D. Richard Hipp
> [email protected]
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



-- 
David Burgess
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to