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

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Any Plans for cross database queries on the same server?
Дата
Msg-id 45BFB159.40700@cox.net
обсуждение исходный текст
Ответ на Re: Any Plans for cross database queries on the same server?  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Ответы Re: Any Plans for cross database queries on the same server?  (Richard Troy <rtroy@ScienceTools.com>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/30/07 14:41, Tony Caduto wrote:
> Mark Walker wrote:
>>  It's sort of a matter of taste, but there are lots of people who like
>> to keep there logic on the server or at least within sql statements,
>> so there's probably a good sized market that your not reaching if you
>> ignore it.
>>
> That is a good point, I and many developers I know like to keep all the
> business logic on the server in stored procedure and functions and
> having this ability as a native part of Postgresql would be a huge
> advantage.
> DBlink is a decent workaround,but it becomes a pain having to wrap
> everything with the dblink syntax, plus there is a little bit of
> overhead involved creating a connection over TCP/IP to run a query on
> the same server.  DBlink is great when you need to connect to a
> different server though.

True distributed transactions would be handy, though.

Many of our design decisions might have been different had they been
available.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFv7FZS9HxQb37XmcRAjtPAJ9/eXPPp7xcOWYPhfkNVYudAeXB+wCfU96x
9ENICnZnVmYj59GB7niatyY=
=aQsm
-----END PGP SIGNATURE-----

В списке pgsql-general по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: DBMS Engines and Performance
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: DBMS Engines and Performance