On 04/10/12 10:44 PM, Atri Sharma wrote:
> We plan to call SQL through SPI from the FDW,which in turn would call
> > the Pl/Java routine.
that seems overly complex. SPI is an internal mechanism used by C
functions that are called from SQL
why not just implement it as....
user application -> SQL -> PLjava FDW functions -> pljava code -> JDBC
-> foreign database
(and of course, back to return the data from said foreign database)
this would look to the user very much like dblink looks now, and have
similar security issues and mitigations.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast