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

Thank you, Merlin and Asko for your responses :-) Because my whole project
is using PL/Proxy I should have realised I could use that instead of dblink
in this case.

Thanks again,

- Ian

2009/1/26 Asko Oja <ascoja(at)gmail(dot)com>

> 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(at)gmail(dot)com>wrote:
>
>> On 1/24/09, Ian Sollars <ian(dot)sollars(at)gmail(dot)com> 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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>