On 2006-0829 13:15:02, [EMAIL PROTECTED] wrote:
To my surprise (perhaps "horror") I find that SQLite has for a very long time allowed NULL values in PRIMARY KEY columns. [...]
I understand your concern about legacy programs, but most of us expect PRIMARY KEY to imply NOT NULL... don't we? what about looking for alternative good solutions? we could put the correction code in the source, conditionally compiled (not the default) and with the next major release reverse the condition (new 'corrected' source becomes default and old 'legacy' behaviour still available if desired) ... ? maybe 'the best of both worlds', hope you agree. regards, Mario ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
