| From: | Rasmus Resen Amossen <NOSPAM(at)hey(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Bug? |
| Date: | 2001-11-15 02:02:41 |
| Message-ID: | 3BF32241.F4C0AFF6@hey.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am using postgresql-7.0.3 and is now having a strange problem!!!
I got a table with a "serial" attribute. For example
CREATE TABLE test (
id SERIAL NOT NULL,
val INT
);
The the following insertions creates an error:
INSERT INTO test(id,val) VALUES (1,1);
INSERT INTO test(val) VALUES (1);
Error:
Cannot insert a duplicate key into unique index test_id_key
After that I can just reåeat the second line and insert without errors.
Is this bug fixed in newer versions?
--
Rasmus Resen Amossen | stud.mat.dat at the University of Copenhagen
Jagtvej 120, -244 | http://www.math.ku.dk/muh
2200 Kbh. N | http://www.ruf.adr.dk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sunit Bhatia | 2001-11-15 03:04:24 | Database server crash ! URGENT ! |
| Previous Message | Justin Clift | 2001-11-15 01:54:56 | Re: Sourceforge on Oracle? (WAY OT) |