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

* Jean-Christian Imbeault wrote on Monday, 2002-08-05:

> 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)
> );
>
> ERROR: Cannot insert a duplicate key into unique index movies_id_key
| |
table name |
field name
>
> I thought I had defined the primary key to span two columns ... the data
> in the first two columns is not a duplicate...

There is a unique index on "id" alone, in addition to the
participation in the primary key.

--
Christian Ullrich Registrierter Linux-User #125183

"Deliver."