On Wed, Jul 6, 2011 at 3:13 PM, David Johnston <polobo@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
