Search Postgresql Archives

Re: dblink syntax question for remotely invoking void-returning procedures

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Take a stab at plproxy if you want to remotly call functions. Should be much better suited than dblink for that.

Regards
Asko

On Mon, Jan 26, 2009 at 4:07 PM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
On 1/24/09, Ian Sollars <ian.sollars@xxxxxxxxx> wrote:
> Hello everyone,
>
> I've got some questions about dblink that I couldn't find answers to in the
> documentation. Any help would be much appreciated.
>
> I need to invoke a function on a remote server that returns either void or
> text, and I'm trying to find a nice way of doing it.
>

did you try this?
perform * from dblink('test', 'select inserttest()') as t1(test text);

Anyways, I never write void returning functions.  Another problem with
them (for example) is that they can't be called using the binary query
protocol.  These are minor nits since the workaround is easy.

merlin

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux