Re: Any Plans for cross database queries on the same server? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Any Plans for cross database queries on the same server?
Date
Msg-id 45BFFBA5.6070302@commandprompt.com
Whole thread Raw
In response to Re: Any Plans for cross database queries on the same server?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Any Plans for cross database queries on the same server?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Any Plans for cross database queries on the same server?  (David Fetter <david@fetter.org>)
List pgsql-general
Peter Eisentraut wrote:
> This has been discussed about ten thousand times, and the answer is
> still no.
>
>
Actually the answer is: Check the TODO list. It is listed under Exotic
features, so the answer is, no we can't yes we would like to.

That being said, I think it is a dumb feature. If you have data in one
database, that requires access to another database within the same
cluster. You designed your database incorrectly and should be using schemas.

If you have data in one database that requires access to another
database that is not in the same cluster (which happens alot) use dbi-link.

Joshua D. Drake




pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: VACUUM and open transactions
Next
From: Joseph S
Date:
Subject: Re: VACUUM and open transactions