Re: Reference with inheritance propagate data - Mailing list pgsql-general

From Yuriy Rusinov
Subject Re: Reference with inheritance propagate data
Date
Msg-id CAA5U4szQgdW7knB5Y8f4rY45GR4ZBrCoUBkGcLdY8MGVpNZ9og@mail.gmail.com
Whole thread Raw
In response to Re: Reference with inheritance propagate data  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Reference with inheritance propagate data
Re: Reference with inheritance propagate data
List 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.

pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: Backslashitis
Next
From: Chris Travers
Date:
Subject: Re: Reference with inheritance propagate data