The following bug has been logged online:

Bug reference: 1202
Logged by: Enrico

Email address: carrara (AT) pd (DOT) infn.it

PostgreSQL version: 7.4

Operating system: linux Debian Sarge

Description: Primary Key constraint not respected

Details:

Hi, I'm using version 7.4.2.
I created this table (italian text, sorry):

prova=> \d crate
Tabella "public.crate"
Colonna | Tipo | Modificatori
----------+---------+---------------------
code | integer | not null
location | integer | default 1
capacity | integer | not null default 70
Indici:
"code" chiave primaria, btree (code)

("code" is primay key, without oids)

I entered twice the same "code" and I got no error, as you can see:

prova=> select * from crate where code > 500;
code | location | capacity
------+----------+----------
503 | 1 | 48
503 | 1 | 48
501 | 1 | 1
502 | 1 | 1
504 | 1 | 48
(5 righe)

It happened only once, now it correctly says:

prova=> insert into crate (code) values (503);
ERROR: duplicate key violates unique constraint "code"

Thanks.
-E-nrico


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match