Ken MacDonald wrote on 19.11.2009 17:55:
> 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?
You should create the column with the datatype serial
In response to
pgsql-novice by date
|Next:||From: APseudoUtopia||Date: 2009-11-19 17:19:23|
|Subject: Re: Noob question: how to auto-increment index field on INSERT?|
|Previous:||From: Ken MacDonald||Date: 2009-11-19 16:55:49|
|Subject: Noob question: how to auto-increment index field on INSERT?|