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