[Pljava-dev] ERROR: must be superuser to examine "dynamic_library_path"

Newbie alert. First, thanks Thomas for this great addition to
PostgreSQL - I appreciate your efforts. I've installed PLJava on Linux
PostgreSQL 8.0 in a little test database. As the "postgres" super user,
I am able to deploy, load examples.jar and run javatest stored
functions. I did not need to set the dynamic_library_path in
postgresql.conf, as the so's where installed in /usr/local/pgsql/lib,
where it apparently already looking.

I've granted "All" to "public" on both the sqlj and javatest schemas.
But whenever I try to run any javatest functions as a user other than
postgres, I get the subject message. Is it possible to configure this
so that I don't need to grant superuser privilege to every user that
wants to execute Java stored procedures?

--
Guy Rouillier

Guy,

>I've granted "All" to "public" on both the sqlj and javatest schemas.
>But whenever I try to run any javatest functions as a user other than
>postgres, I get the subject message. Is it possible to configure this
>so that I don't need to grant superuser privilege to every user that
>wants to execute Java stored procedures?
>
>
I'm afraid that you've encountered a bug. It will be fairly easy to fix
since the code that attempts the access is obsolete. I should have
removed it long ago. Thanks for pointing this out. I'll supply a patch
for it later this week.

If you have the source for the latest beta and know how to compile, you
can comment out the lines 368 and 370 in src/C/pljava/type/Backend.c.
That should fix the problem.

Regards,
Thomas Hallgren