On 21 Apr 2014, at 6:18pm, Richard Hipp <d...@sqlite.org> wrote: > SQLite does the right thing and enforces NOT NULL on PRIMARY KEY for the > newer WITHOUT ROWID tables. But long ago there was a bug that prevented > enforcement NOT NULL on PRIMARY KEY of ordinary tables and by the time the > bug was discovered we couldn't really fix it without breaking lots of > legacy.
Can it be fixed in SQLite4 ? Can 'NOT NULL' be assumed for PRIMARY KEYs in SQLite4 ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users