Re: Reference with inheritance propagate data

From: Yuriy Rusinov <yrusinov(at)gmail(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: POSTGRES <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reference with inheritance propagate data
Date: 2012-06-14 09:08:08
Message-ID: CAA5U4szQgdW7knB5Y8f4rY45GR4ZBrCoUBkGcLdY8MGVpNZ9og@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, Jeff !

>
> 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?

Unfortunately not, because this design does not developed by me and
these changes will result to inefficiency of all project.
>
> Also, I don't understand what you mean about propagating data. What data
> do you want to propagate?

We're need common numeration for primary key for all users tables, but
others columns may be different for tables.

--
Best regards,
Sincerely yours,
Yuriy Rusinov.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-06-14 09:40:01 Re: Reference with inheritance propagate data
Previous Message Raghavendra 2012-06-14 09:03:56 Re: Backslashitis