On Wed, Jul 6, 2011 at 3:13 PM, David Johnston <polobo@yahoo.com> 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 goes in the
tables if they need to be partitioned that way.
Then you can create an inheriting table for the fkey maps too and use
rules to select which table a row goes into. Note: Use DO INSTEAD
not DO ALSO rules. DO ALSO with inserts are big foot guns.
Best Wishes,
Chris Travers