> You might prefer adding an explicit NOT NULL on both "client" and "salesman" > columns. > There is an historical reason why SQLite accepts NULL for primary key > column(s).
Ok, thanks for the hint, I didn't know that either. But it is a very odd behavior, because PRIMARY KEY per definition doesn't mean anything else than UNIQUE NOT NULL. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users