Russell Shaw wrote:
> Hi,
>
> Is there a way to make postgresql report an error if when
> inserting data, a multiple-column combination is duplicated?
>
> CREATE TABLE parts_vendors (
> part_id integer references parts (part_id),
> vendor_id integer references vendors (vendor_id),
> ...
> )
>
> part_id vendor_id
> ------------------
> 1 3
> 2 5 <--+
> 7 9 |
> 2 5 <--+-- duplicate pattern
> ...
>
Oops, i can just do a select on the various columns
to detect this...