Re: Postgresql duplicate keys and django problem

2006-10-26 Thread can.xiang
Denis, your suggestion fixed a similar problem bugging me hours. I tried to migrate some (1,000s rows) tables from mysql to postgresql with the build-in model functions, which is absolutely no problem. While when I tried to add new data with manipulator.save(), it always raise "integrity error" o

Re: Postgresql duplicate keys and django problem

2006-10-18 Thread Denis
This can be done using following command sequence: manage.py sqlsequencereset | psql It sets counters to the max value of serial field of every model in your app. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

Re: Postgresql duplicate keys and django problem

2006-10-18 Thread [EMAIL PROTECTED]
I've setval the counters to higher, free numbers and it looks like it works now :) --~--~-~--~~~---~--~~ 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@googlegroup

Re: Postgresql duplicate keys and django problem

2006-10-18 Thread [EMAIL PROTECTED]
Models look like this: # class News(models.Model): news_title = models.CharField(maxlength=255, verbose_name='Tytul') news_text = models.TextField(verbose_name='Tresc') news_more = models.TextField(verbose_name='Rozszerzona Tresc', blank=True, default='')

Re: Postgresql duplicate keys and django problem

2006-10-17 Thread James Bennett
On 10/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Few days ago I've started to get such errors in the Admin Panel when I > want to add something: I'm curious about why you reset the sequence, rather than using setval() to push it up to a working value, but this just sounds like a sequen

Re: Postgresql duplicate keys and django problem

2006-10-17 Thread Michael Radziej
[EMAIL PROTECTED] schrieb: > Few days ago I've started to get such errors in the Admin Panel when I > want to add something: > ## > IntegrityError: ERROR: duplicate key violates unique constraint > "rk_news3_pkey" > > INSERT INTO "rk_news3" > ("news_title","news_t