From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | Yuriy Rusinov <yrusinov(at)gmail(dot)com> |
Cc: | POSTGRES <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Reference with inheritance propagate data |
Date: | 2012-06-12 23:36:11 |
Message-ID: | 1339544171.12295.105.camel@sussancws0025 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 2012-06-13 at 00:38 +0400, Yuriy Rusinov wrote:
> Hello, All !
>
> I have base table q_base_table with column (id bigint) which may be
> inherited by users tables, primary key for both base table and derived
> tables is id. Now I need for another table record_rubricator which has
> to be referenced to base and derived tables, which way I have to do
> it, because postgresql does not allow automatically propagate data ?
One foreign key cannot reference two tables.
Have you considered a design that does not use inheritance? For
instance, the users table could reference q_base_table, and then
record_rubricator could also reference q_base_table?
Also, I don't understand what you mean about propagating data. What data
do you want to propagate?
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2012-06-12 23:40:39 | Re: trigger on view returning created serial |
Previous Message | Rich Shepard | 2012-06-12 22:50:03 | Re: UPDATE Syntax Check |