Re: [GENERAL] Inherit trouble

2011-07-06 Thread Chris Travers
On Wed, Jul 6, 2011 at 3:13 PM, David Johnston wrote: > > The product 9 is a hard drive, so it's inserted in the hard drive table, but > as it inherits product, I see it in product table too. > > Why do i Have this message ? Can you help me ? First you need to have some way to differentiate what

Re: [GENERAL] Inherit trouble

2011-07-06 Thread David Johnston
The product 9 is a hard drive, so it's inserted in the hard drive table, but as it inherits product, I see it in product table too. Why do i Have this message ? Can you help me ? Thank you David Working as designed; foreign keys and unique indexes are only valid for the explicit table the

[GENERAL] Inherit trouble

2011-07-06 Thread David Gianonatti
Hello Everyone, I got trouble with inherit and foreign key. I give you example of what's it likes. I got 4 tables : - order - order_details - product - hard_drive Hard_drive inherit product order_details got order on foreign key order_details got product on foreign key When I try to add an or