| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Bill Chandler <billybobc1210(at)yahoo(dot)com> |
| Cc: | Ragnar Hafstað <gnari(at)simnet(dot)is>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Unique constraint violation on serial column |
| Date: | 2005-04-12 16:04:08 |
| Message-ID: | 20050412160408.GK17283@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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[(at)]dcc(dot)uchile(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Chandler | 2005-04-12 16:21:54 | Re: Unique constraint violation on serial column |
| Previous Message | Bill Chandler | 2005-04-12 15:58:41 | Re: Unique constraint violation on serial column |