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