On 11.12-07:45, Ana wrote: [ ... ] > I am converting from PHP to Django. In my Postgres database I have > three tables: [ ... ] > duplicate key value violates unique constraint > "fsafety_pathpubcombo_pkey" > > Can anyone please help? This is the first python code I've written.
i would guess that you need to reset your postgres autoindex to something that matches your dataset. for example if you have 10,000 records then the primary keys for 1-10,000 are already duplicate, however, with your a database the index key will be set to something low, thereby inducing the collisions you're talking about. you'll need to do this via 'psql' or another postgres tool. i'm afraid i can't remember the way do to this. maybe it's to delete the underlying sequence and then recreate it with CREATE SEQUENCE <thenameofthe_seq> START <highest_id+1> ; or something. i don't think you can set it directly ... if i remember correctly i backed up a db to sql and figured it out that way. --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---