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

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема Re: Any Plans for cross database queries on the same server?
Дата
Msg-id 45BFAD71.3010105@amsoftwaredesign.com
обсуждение исходный текст
Ответ на Re: Any Plans for cross database queries on the same server?  (Mark Walker <furface@omnicode.com>)
Ответы Re: Any Plans for cross database queries on the same server?  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general
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.

Later,

--
Tony


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

Предыдущее
От: "Karen Hill"
Дата:
Сообщение: Can a function be parameter in PL/PGSQL function?
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: DBMS Engines and Performance