Re: Constrain duplicate patterns

Michael Glaesemann wrote:
>
> On Feb 1, 2004, at 6:06 PM, Russell Shaw wrote:
>
>> Hi,
>>
>> Is there a way to make postgresql report an error if when
>> inserting data, a multiple-column combination is duplicated?
>
> I believe you're looking for UNIQUE(part_id, vendor_id), if you want to
> prevent this from happening. If you just want it to report an error, but
> allow the insert/update anyway, maybe a trigger? Not sure about that
> though.

Hi,
Thanks. I used this:

create table parts_vendors (
     part_id integer references parts (part_id),
     vendor_id integer references vendors (vendor_id),
     unique(part_id,vendor_id)
)