Using duplicate foreign keys - Mailing list pgsql-general

From Andrus
Subject Using duplicate foreign keys
Date
Msg-id enjdia$12tq$1@news.hub.org
Whole thread Raw
Responses Re: Using duplicate foreign keys  (Erik Jones <erik@myemma.com>)
List pgsql-general
I have multi-company database.
Each company has its own chart of accounts table which are stored in each
company schema.
Some account numbers are used in a common table which is stored in public
schema.

So I need to create duplicate foreign keys like

create temp table company1.chartoffaccounts ( accountnumber int primary
key);
create temp table company2.chartoffaccounts ( accountnumber int primary
key);

create temp table public.commontable ( accountnumber int,
   FOREIGN KEY (accountnumber)   REFERENCES c1hartoffaccounts
(accountnumber)
   FOREIGN KEY (accountnumber)   REFERENCES c2hartoffaccounts
(accountnumber) );


Is it OK to use duplicate foreign keys ? What issues will they cause ?

Andrus.



pgsql-general by date:

Previous
From: "Romulo Hunter"
Date:
Subject: Update to 8.2 in openSUSE 10.2
Next
From: "BigSmoke"
Date:
Subject: Pure PostgreSQL unit tests - test and debug pgsql constraints and procedures/functions