Re: Constrain duplicate patterns

I found a way to do it like this

create table parts (part_id int, description character varying(33) constraint part_id unique , primary key (part_id));
create table vendors (vendor_id int, description character varying(33) constraint vendor_id unique, primary key (vendor_id) );
CREATE TABLE parts_vendors ( part_id integer unique references parts (part_id), vendor_id integer unique references vendors (vendor_id));

On Sun, Feb 01, 2004 at 08:11:50PM +1100, Russell Shaw wrote:
> 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...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
joe speigle