"Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > I have a primary key that auto increments and has apparently > overlapped back on to itself. > > INSERT into mytable(id,name) values(NULL,'test'); > > ... is giving me "primary key must be unique" errors. > > How can I reset the sequence for a primary key? The table only has > about 15000 records in it and I've never seen this happen before.. >
There are over 9e18 keys. So if you create 1 billion new rows per second, continuously, it will take you 262 years to exhaust all primary keys. Since SQLite has only been in existance for 7 years, this is clearly impossible so you must be doing something wrong. Perhaps if you provided more details we could help you. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
