Bug?

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: Raw Message | Whole Thread | 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

Responses

  • Re: Bug? at 2001-11-15 15:24:04 from Doug McNaught
  • Re: Bug? at 2001-11-15 15:54:51 from Stephan Szabo
  • Re: Bug? at 2001-11-15 16:17:22 from Tom Lane

Browse pgsql-general by date

  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)