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

Поиск
Список
Период
Сортировка
От Brandon Aiken
Тема Re: Any Plans for cross database queries on the same server?
Дата
Msg-id F8E84F0F56445B4CB39E019EF67DACBA44F828@exchsrvr.winemantech.com
обсуждение исходный текст
Ответ на Re: Any Plans for cross database queries on the same server?  (Guido Neitzer <lists@event-s.net>)
Ответы Re: Any Plans for cross database queries on the same server?  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: Guido Neitzer
Дата:
Сообщение: Re: Any Plans for cross database queries on the same server?
Следующее
От: Rich Shepard
Дата:
Сообщение: DBMS Engines and Performance