Re: Unique check errors when using postgres and explicit ids

2007-07-31 Thread Kai Kuehne
Hi Russel, On 8/1/07, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > Yes. The problem is cause by the way that Postgres (and Oracle, AFAIK) > allocates primary keys. > > [postgres sequence explanation] > > > (Wondering why there is db-dump.py when dumpdata works.. > > but wayne.) > > It was a s

Re: Unique check errors when using postgres and explicit ids

2007-07-31 Thread Russell Keith-Magee
On 8/1/07, Kai Kuehne <[EMAIL PROTECTED]> wrote: > > Is this the 'normal' behavior of postgres? I've never used it > before but this seems very odd to me. I'm deleting the whole > database and creating it new every time. After deleting I'm doing this: > > >>> manage.py syncdb > >>> db-dump.py load

Re: Unique check errors when using postgres and explicit ids

2007-07-31 Thread Kai Kuehne
Hi Russell On 8/1/07, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > > On 8/1/07, Kai Kuehne <[EMAIL PROTECTED]> wrote: > > > I'm using django SVN and the windows version of psycopg2. > > Postgres is running on linux (version 8.1.8). It doesn't work on > > webfaction either, so this information

Re: Unique check errors when using postgres and explicit ids

2007-07-31 Thread Kai Kuehne
On 8/1/07, Kevin Menard <[EMAIL PROTECTED]> wrote: > I would have to agree with lenducha's synopsis. If the sequence is > not updated, you will run into duplicate ID problems. The easiest > thing to do right now is update all of your sequence curvals to be > something large, where large is defin

Re: Unique check errors when using postgres and explicit ids

2007-07-31 Thread Russell Keith-Magee
On 8/1/07, Kai Kuehne <[EMAIL PROTECTED]> wrote: > I'm using django SVN and the windows version of psycopg2. > Postgres is running on linux (version 8.1.8). It doesn't work on > webfaction either, so this information shouldn't be that helpful. Without seeing the exact error, I can think of two p

Re: Unique check errors when using postgres and explicit ids

2007-07-31 Thread Kevin Menard
On 7/31/07, Kai Kuehne <[EMAIL PROTECTED]> wrote: > > Hi list, > I have a question regarding data imports with django > and postgres. > I used the database for my current application and used > the db-dump script from here: > http://www.djangosnippets.org/snippets/14/ > > When I load data into the

Unique check errors when using postgres and explicit ids

2007-07-31 Thread Kai Kuehne
Hi list, I have a question regarding data imports with django and postgres. I used the database for my current application and used the db-dump script from here: http://www.djangosnippets.org/snippets/14/ When I load data into the database, I cannot insert new data afterwards. (Some weird unique