On Thu, 11 Jul 2002, 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?
Not any time soon, there's no real support for making cross db queries
using just the query language right now, and that'd be a prerequisite and
that's not on the near term chart either. Many of the things that people
historically used multiple databases for may be resolvable using schemas
which is coming up soon (7.3).