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..

-- 
- Mitchell Vincent

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to