Hi, Because of the actual limitations of Postgresql inheritance mecanism regarding constraints, I'm not willing to use it in my project, although it's exactly the kind of idea I need:
In an order and manufacturing management system, several different items can be ordered, each of them with specific input parameters. Every item has its own table of "specific parameters", now, what is the best use of PK/FK in order to maintain integrity between the order lines and the items specific parameters tables? Has anyone already done that before? Thanks for your help, and for Posgresql by the way, which is really great... ---------------------------------- Philippe Lang Attik System ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])