I have a PostgreSQL DB created by a Django model, with a field 'id' that is
automatically created by Django as a primary key, type integer.
I would like to create a new row by doing something like....
INSERT INTO table (a, b, c, d) VALUES ('aa', 'bb', 'cc', 'dd')
where I've been hoping that 'id' would get the next value of id available.
Unfortunately, instead I get a 'duplicate primary key' error saying that
'id' is a duplicate, even though I'm not specifying it explicitly in the
INSERT. What is the proper way to auto-increment a primary key?
pgsql-novice by date
|Next:||From: Thomas Kellerer||Date: 2009-11-19 17:06:50|
|Subject: Re: Noob question: how to auto-increment index field on INSERT?|
|Previous:||From: Thom Brown||Date: 2009-11-19 10:44:14|
|Subject: Re: Using file data as argument to functions called from psql command line|