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

From Brandon Aiken
Subject Re: Any Plans for cross database queries on the same server?
Date
Msg-id F8E84F0F56445B4CB39E019EF67DACBA44F828@exchsrvr.winemantech.com
Whole thread Raw
In response to Re: Any Plans for cross database queries on the same server?  (Guido Neitzer <lists@event-s.net>)
Responses Re: Any Plans for cross database queries on the same server?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
I always assumed the general argument is if you need to query different
databases on the same server with the same application, they ought not
to be separate databases because they're clearly related data.

It's kinda like "why isn't there a way to do an exactly one to exactly
one relationship between tables?".  Well, because if one A always means
one B and one B always means one A, shouldn't they ought to be in the
same table already?

--
Brandon Aiken
CS/IT Systems Engineer

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Guido Neitzer
Sent: Tuesday, January 30, 2007 2:22 PM
To: Postgresql General
Subject: Re: [GENERAL] Any Plans for cross database queries on the same
server?

Am 30.01.2007 um 12:11 schrieb Tony Caduto:

> Why?  Seems to me if it was discussed that much it must be a very
> sought after feature.
> How come it's not on the TO Do list for the future at least?
> Is it because of some limitation of the core engine or something?

http://www.postgresql.org/docs/faqs.FAQ.html#item4.17

I guess, nobody has a real interest on that because, if you really
need that, there are work arounds ... E.g. I do a lot of cross
database queries all the day with my apps. It's just handled by the
app server ...

cug

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq


--------------------------------------------------------------------
** LEGAL DISCLAIMER **
Statements made in this email may or may not reflect the views and opinions of Wineman Technology, Inc.
This E-mail message and any attachments may contain legally privileged, confidential or proprietary information. If you
arenot the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended
recipient(s),you are hereby notified that any dissemination, distribution or copying of this E-mail message is strictly
prohibited.If you have received this message in error, please immediately notify the sender and delete this E-mail
messagefrom your computer. 

QS Disclaimer Demo. Copyright (C) Pa-software.
Visit www.pa-software.com for more information.


pgsql-general by date:

Previous
From: Guido Neitzer
Date:
Subject: Re: Any Plans for cross database queries on the same server?
Next
From: Rich Shepard
Date:
Subject: DBMS Engines and Performance