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

Reply via email to