| From: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
|---|---|
| To: | David Johnston <polobo(at)yahoo(dot)com> |
| Cc: | David Gianonatti <david(at)web-tribu(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Inherit trouble |
| Date: | 2011-07-07 01:00:01 |
| Message-ID: | CAKt_ZftEEGV_i8j_A6ay5N+D8bxFqjifdWc7_Z23DJP5GcM8UA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jul 6, 2011 at 3:13 PM, David Johnston <polobo(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jenopob | 2011-07-07 03:07:41 | Re: streaming replication trigger file |
| Previous Message | Simon Riggs | 2011-07-06 23:07:09 | Re: Streaming replication on 9.1-beta2 after pg_restore is very slow |