On Thu, Oct 16, 2008 at 2:38 PM, cfobel <[EMAIL PROTECTED]> wrote: > I recently encountered a situation where the sequence for the primary > key of one of my models became out of sync, which caused the following > error when trying to save a new model instance: > > IntegrityError ... 'duplicate key violates unique constraint > "myapp_mymodel_pkey"'
Like you said, if you inserted a record with a manual ID greater than the current sequence value, assuming you're moving forward through a sequence of numbers from lower numbers to greater ones, then you could see this. Or if you actually changed the sequence. You might have ran an 'alter sequence' statement. Switching to MySQL is not going to help you out here. -Dave --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
