Re: Unique constraint violation on serial column - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Unique constraint violation on serial column
Date
Msg-id 20050412160408.GK17283@dcc.uchile.cl
Whole thread Raw
In response to Re: Unique constraint violation on serial column  (Bill Chandler <billybobc1210@yahoo.com>)
List pgsql-general
On Tue, Apr 12, 2005 at 08:58:41AM -0700, Bill Chandler wrote:
> I did not intend to put explicit values in the
> 'evt_id' column.  I thought the six values in the
> insert command correspond to the 1st six columns in
> the create table command, namely d1, obj_id, d2, val,
> correction and delta and 'evt_id' is set to the
> nextval() automagically.  Is that not correct?

Sorry, I didn't count the fields.  My mistake.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
Tulio: oh, para qué servirá este boton, Juan Carlos?
Policarpo: No, aléjense, no toquen la consola!
Juan Carlos: Lo apretaré una y otra vez.

pgsql-general by date:

Previous
From: Bill Chandler
Date:
Subject: Re: Unique constraint violation on serial column
Next
From: Bill Chandler
Date:
Subject: Re: Unique constraint violation on serial column