The following bug has been logged online:
Bug reference: 3740
Logged by: John
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: WinXP
Description: could not load library ".../pljava.dll
Details:
I have indsert to postgresql.conf
dynamic_library_path = 'C:\\Program
files\\PostgreSQL\\8.2\\share\\pljava'
log_min_messages = 'info'
custom_variable_classes = 'pljava'
pljava.classpath = 'C:\\Program
files\\PostgreSQL\\8.2\\share\\pljava\\pljava.jar'
on command prompt:
set Classpath=C:\Program
files\PostgreSQL\jdbc\postgresql-8.2-506.jdbc4.jar;C:\Program
files\PostgreSQL\share\pljava\deploy.jar;
and:
set PATH=%PATH%;%JAVA_HOME%\jre\bin;%JAVA_HOME%\jre\bin\client
then:
java org.posgtgreslq.pljava.deploy.Deployer -install -user Honza -database
"Klientela 3.13" -password heslo
and answer from command prompt is:
org.postgresql.util.PSQLException: ERROR: could not load library "C:/Program
files/PostgreSQL/8.2/lib/pljava.dll"; unknow error 126 at
org.postgresql.core.v3....and more
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
