I just downloaded and tested using 3.8.11.1. It and 3.8.8.3 have the same behavior -- do not disable.
Roman ________________________________________ From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Thursday, September 10, 2015 7:53 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] bug in PRAGMA ignore_check_constraints? On 9/10/15, Richard Hipp <drh at sqlite.org> wrote: > On 9/10/15, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote: >> Dear SQLiters, >> >> I am trying to temporarily disable CHECK constraint given in columns of >> table definition. As far as I understand, >> >> PRAGMA ignore_check_constraints='yes'; > > PRAGMA ignore_check_constraints=YES; -- no quotes. > I say that - turns out quotes don't matter. PRAGMA ignore_check_constraints='yes'; works too. What version of SQLite are you running? -- D. Richard Hipp drh at sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
