Re: N all-way relationship

--- Ryan <pgsql-sql(at)seahat(dot)com> wrote:
> This is largely related to cross referencing part numbers

Why not
table master_part(
part_id int primary key,
part_no not null unique,
... );
table vendor( vendor_no primary key, ... );
table vendor_part(
part_id int primary key default(seq),
vendor_no references vendor,
master_part references master_part( part_id ),
vendor_part,
constraint unique( vendor_no, vendor_part ),
... );

Everything here is nice and normal (use part_id to avoid compound
primary keys). Then use views for all cross referencing.

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com