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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
