Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, 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 04:15:20
Message-ID: 15198.1170216920@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Joshua D. Drake" <jd(at)commandprompt(dot)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

In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 2007-01-31 04:15:55
Subject: Re: Index bloat of 4x
Previous:From: Bruce MomjianDate: 2007-01-31 04:14:52
Subject: Re: Index bloat of 4x

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group