From: cgr_cool_87 at hotmail.com (grub87)
Date: Fri, 3 Jul 2009 16:56:51 -0700 (PDT)
Subject: [Pljava-dev] Installing pljava--pg8.2-1.4.0. on centos 5.3 and
 Postgres 8.2.13
Message-ID: <24329781.post@talk.nabble.com>


Hi i'm trying to install pljava--pg8.2-1.4.0. on centos 5.3, i have already
installed Postgres 8.2.13 and i t works fine, the problem is that when i try
to install pljava it gives the next error message:

(i'm introducing this command on terminal)

$ psql -d postgres -f install.sql

psql:install.sql:1: ERROR:  schema "sqlj" already exists
GRANT
psql:install.sql:6: ERROR:  could not load library
"/usr/local/pgsql/lib/pljava.so": libjvm.so: no se puede abrir el fichero
del objeto compartido: No existe el fichero o el directorio
psql:install.sql:8: ERROR:  function sqlj.java_call_handler() does not exist
psql:install.sql:12: ERROR:  could not load library
"/usr/local/pgsql/lib/pljava.so": libjvm.so: no se puede abrir el fichero
del objeto compartido: No existe el fichero o el directorio
psql:install.sql:14: ERROR:  function sqlj.javau_call_handler() does not
exist
psql:install.sql:23: NOTICE:  CREATE TABLE will create implicit sequence
"jar_repository_jarid_seq1" for serial column "jar_repository.jarid"
psql:install.sql:23: ERROR:  relation "jar_repository" already exists
GRANT
psql:install.sql:32: NOTICE:  CREATE TABLE will create implicit sequence
"jar_entry_entryid_seq1" for serial column "jar_entry.entryid"
psql:install.sql:32: ERROR:  relation "jar_entry" already exists
GRANT
ALTER TABLE
psql:install.sql:43: ERROR:  relation "classpath_entry" already exists
GRANT
psql:install.sql:50: NOTICE:  CREATE TABLE will create implicit sequence
"typemap_entry_mapid_seq1" for serial column "typemap_entry.mapid"
psql:install.sql:50: ERROR:  relation "typemap_entry" already exists
GRANT
psql:install.sql:55: ERROR:  language "java" does not exist
psql:install.sql:59: ERROR:  language "java" does not exist
psql:install.sql:63: ERROR:  language "java" does not exist
psql:install.sql:67: ERROR:  language "java" does not exist
psql:install.sql:71: ERROR:  language "java" does not exist
psql:install.sql:75: ERROR:  language "java" does not exist
psql:install.sql:79: ERROR:  language "java" does not exist
psql:install.sql:83: ERROR:  language "java" does not exist
psql:install.sql:87: ERROR:  language "java" does not exist

First of all i want to know if the version of pljava is correct for the
version of postgresql, and if it also ok that centos is on it latest version
or not. And also i would like to know if the command i'm writing on terminal
is correct. THANKS FOR YOUR HELP!!!
-- 
View this message in context: http://www.nabble.com/Installing-pljava--pg8.2-1.4.0.-on-centos-5.3-and-Postgres-8.2.13-tp24329781p24329781.html
Sent from the PL/Java mailing list archive at Nabble.com.