Constrain duplicate patterns - Mailing list pgsql-novice

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
...