Re: Any Plans for cross database queries on the same server?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
Subject: Re: Any Plans for cross database queries on the same server?
Date: 2007-01-31 02:15:01
Message-ID: 45BFFBA5.6070302@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph S 2007-01-31 02:15:52 Re: VACUUM and open transactions
Previous Message Alvaro Herrera 2007-01-31 01:55:19 Re: VACUUM and open transactions