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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
