multi-column primary key insert error ('duplicate' complaint)

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

Responses

Browse pgsql-general by date

  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