Re: Cross database foreign key workaround?

El Mié 08 Oct 2003 18:46, David Busby escribió:
> List,
>     What are the recommended work arounds for cross database foreign keys?
> As I understand it transactions are not atomic with the TCL method.  I have
> a situation that requires a master database and then a separate database
> for every subscriber.  Subscribers need read/write to both databases.  I
> chose separate databases because there are 20+ large tables that would
> require uid/gid columns, indexes and where conditions to separate
> information by subscriber.  I thought that was too much overhead.  Should I
> just use my application to make changes and ensure references that need to
> take place across databases?  Or should I add a uid/gid to all necessary
> tables, create indexes and update all necessary where clauses?  Ideas?

Use schemas. That's what they are for! (at least thats the main reason we are
using them intensivelly).

--
 19:28:01 up 6 days,  5:05,  2 users,  load average: 0.36, 0.40, 0.36
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------