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 <d...@sqlite.org> wrote:
> On 4/2/17, Simon Slavin <slav...@bigfraud.org> wrote:
>>
>>> On 3 Apr 2017, at 2:11am, David Burgess <dburg...@gmail.com> 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
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



-- 
David Burgess
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to