On Tue, Apr 10, 2012 at 8:42 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
>> I am considering two paths for doing this:
>> The first one takes the help of the SPI(Server Programming Interface)
>> and the second one directly connects through Pl/Java and JNI(Java
>> Native Interface).
>>
>
> I'd say forget SPI - I don't think it's going to help you here. Just
> concentrate on getting the functionality via a PL/Java wrapper. I wouldn't
> worry too much about jdbc style URLs either, since logically I think you'd
> want to specify the connection parameters via server and FDW options as in
> my example above - that way it would be consistent with other FDWs. But
> that's a piece of bikeshedding for now. Basically, you want to implement the
> handler function to start with.
how do you cross from FDW into a pl/java routine without SPI?
merlin