Hi Im engineering a PG database with my workmate.
Unfortunately the inheritance feature seems not to be able to solve my problem.
I have a table "order" with an orderID, each order has 1 to n types of
articles, like services and supply articles with the same PK.
The PK is order_number and position, the PK must be unique over all
article-tables. All articles have 1 to n packages.
I have a table art as the "mother-table". All article-tables inherit the PK and
some other columns from that table.
My problem is now that i dont know how i can make the PK on art unique and make
a FK from packages to art.
At the moment im thinking about a workaround using triggers, but i wanted to
know some other opinions on that matter first.
Thanks in advance,
Mario
---------------------------------
NEU: Fragen stellen - Wissen, Meinungen und Erfahrungen teilen. Jetzt auf
Yahoo! Clever.
