To add the guarantee that automatically generated values will never be reused, your only option is:create table foo(id integer primary key autoincrement);
Got involved testing this and forgot what I originally went to look for. You can add "not null" on the end of that, if you want. It's already implicitly not null, but it's still valid syntax and will work as intended. "integer primary key autoincrement" is the magical phrase that must not be broken up. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
