Thank you, Simon. I saw that foreign keys must be checked separately. I wanted to check the behavior and set up a test database. I use (for now) SQLite 3.8.8.3 and discovered that setting ignore_check_constraints = 'yes' did not disable INT PRIMARY KEY NOT NULL constraint on a column. Is that expected?
Thank you, Roman ________________________________________ From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Thursday, September 10, 2015 6:39 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] PRAGMA integrity_check On 10 Sep 2015, at 11:06pm, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote: > PRAGMA integrity_check is described to check UNIQUE and NOT NULL constraints. > Does it check other CHECK constraints specified in the column definition? I'm 90% sure it does not. You should see this one though: <https://www.sqlite.org/pragma.html#pragma_foreign_key_check> Simon. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
