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!!!
