Re: stored function (possible to access file system or call java program)? - Mailing list pgsql-general

From John R Pierce
Subject Re: stored function (possible to access file system or call java program)?
Date
Msg-id 4E8A2EDC.4060206@hogranch.com
Whole thread Raw
In response to Re: stored function (possible to access file system or call java program)?  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: stored function (possible to access file system or call java program)?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On 10/03/11 2:18 PM, Merlin Moncure wrote:
> hm -- care to comment in more detail?


I've had to custom build it for each platform I've deployed it on, and
it then has dependencies on the exact JDK version and location.   It
currently doesn't work with JDK 6, only 1.5.    It also requires custom
lines be added to postgresql.conf and environment variables defined by
the postgres service startup script.

My first attempt to get it working with 64bit CentOS 6, Sun JDK
1.5.0_22, and PG 9.0.5 failed, although I need to start over and make
sure I didn't mess up a step.

The idea of dragging a whole JVM into the process context of the
postgres server also bothers me, but I must say, that once you DO get it
working, the developers in another division of $job were able to move
some code over from Oracle pljava to Postgres pljava without any
modifications at all.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: stored function (possible to access file system or call java program)?
Next
From: Merlin Moncure
Date:
Subject: Re: stored function (possible to access file system or call java program)?