From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | geoff(at)metalogicplc(dot)com |
Cc: | "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: FW: FW: Linking databases. |
Date: | 2002-07-11 17:01:33 |
Message-ID: | 3D2DB9ED.4020305@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Geoff wrote:
> I don't think either COPY or PG_DUMP will help in this case...
>
> I have a users table in database ADMIN with a primary key user_id. I have a
> users_access table in database LIVE which I was hoping to have a foreign key
> user_id reference the user_id column in the ADMIN database, so If I deleted
> a user it would cascade and delete the users_access records.....
>
> are you saying this is impossible? if so, are their plans for this to be
> made a feature in a future release?
>
See contrib/dblink for a possible workaround. Note that if you want to
use it for INSERT/UPDATE/DELETE, you'll have to grab the latest version
out of CVS.
There doesn't seem to be much support for a native cross-database access
among the core developers, so I don't think you'll see that soon. As I
think others have mentioned, the next release (7.3) will support
multiple schemas in one database which might be a solution for you.
HTH,
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-07-11 17:24:36 | Re: Forcing Disconnection |
Previous Message | Arguile | 2002-07-11 16:33:35 | Re: Disabling case sensitivity |