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

From Tom Lane
Subject Re: Any Plans for cross database queries on the same server?
Date
Msg-id 15198.1170216920@sss.pgh.pa.us
Whole thread Raw
In response to Re: Any Plans for cross database queries on the same server?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
"Joshua D. Drake" <jd@commandprompt.com> writes:
> 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.

FWIW, the SQL committee thinks it's a fine idea --- the SQL-MED section
of the standard is all about this.  (Note MED = "Management of External
Data", or something close to that; not MEDical as one might guess.)

But don't hold your breath waiting for us to implement SQL-MED; it's
not something that seems to be high on the priority list of any active
hackers.  As far as I've heard it's not had that much uptake among
commercial databases either.  (Hm, you don't suppose that Oracle might
be less than excited about exchanging data with non-Oracle DBs?  Naw,
couldn't be...)

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Index bloat of 4x
Next
From: Bruce Momjian
Date:
Subject: Re: Index bloat of 4x