From: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | multi-column primary key insert error ('duplicate' complaint) |
Date: | 2002-08-05 09:48:16 |
Message-ID: | 3D4E49E0.3010605@mega-bucks.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have the following table where I want to use two columns as the primary:
create table MOVIES (
id char(12) unique references PRODUCTS,
volume_id int2 not null default 1,
label_id integer references LABELS(id),
length int2 not null,
primary key(id, volume_id)
);
However when I try the following:
insert into movies values('589000901097','1','1','1');
insert into movies values('589000901097','2','1','1');
I get this error:
ERROR: Cannot insert a duplicate key into unique index movies_id_key
I thought I had defined the primary key to span two columns ... the data
in the first two columns is not a duplicate...
What did I miss?
Thanks!
Jc
From | Date | Subject | |
---|---|---|---|
Next Message | marko.asplund | 2002-08-05 09:57:42 | concept question: PostgreSQL vs. Oracle database |
Previous Message | Richard Huxton | 2002-08-05 09:22:59 | Re: Reviewed: max. no of relations in a database |