I do not believe NOT NULL is a CHECK constraint, though you could use gender TEXT CHECK(typeof(gender) <> 'null') is and would work much the same way, though possibly with less?efficiency.
Peter? On Thursday, September 10, 2015 4:48 PM, 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'; should do it. However this example demonstrates that it is not: CREATE TABLE subject( ? subjectID? INT, ? gender? ? TEXT NOT NULL ); CREATE TABLE input( ? subjectID? INT, ? gender? ? TEXT ); INSERT INTO input(subjectID, gender) VALUES (1, 'female'); INSERT INTO input(subjectID, gender) VALUES (2, 'male'); INSERT INTO input(subjectID) VALUES (3); PRAGMA ignore_check_constraints='yes'; INSERT INTO subject (rowid) SELECT rowid FROM input; Error: NOT NULL constraint failed: subject.gender I am using SQLite 3.8.11.1. Am I misusing the PRAGMA? Thank you, Roman _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users