[Pljava-dev] ERROR: schema "sqlj" does not exist

[Nelli Vanan]

Hi there,

I tried to install using the deploy.jar and now I am getting the
following error.

java.sql.SQLException: You must be a superuser to deploy/undeploy pl/Java.
        at org.postgresql.pljava.deploy.Deployer.checkIfConnectedAsSuperuser(Deployer.java:303)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:257)

I am logged in as root.




On Fri, Oct 17, 2008 at 10:08 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
> Hi there,
>
> This is my first time installing pljava.  I unziped the
> "pljava-i686-pc-linux-gnu-pg8.1-1.4.0.tar" to /usr/pljava directory.
> I modified
> the postgresql.conf file and added the following lines
>
> dynamic_library_path ='$libdir:/usr/pljava'
>
> custom_variable_classes = 'pljava'
> pljava.classpath='/usr/pljava/pljava.jar'
>
> And restarted the postgres service.  After that I tried to run the
> sample tests given in the wiki.   But, I am getting the following
> error message
> ERROR:  schema "sqlj" does not exist in the postgres log file.  What is wrong?
>
> Thank you.
>