Re: [INTERFACES] Re: interface to NeoWebscript 3.0 - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] Re: interface to NeoWebscript 3.0
Date
Msg-id 21324.928247478@sss.pgh.pa.us
Whole thread Raw
In response to Re: interface to NeoWebscript 3.0  ("Thilo Riessner" <thilo@riessner.de>)
List pgsql-interfaces
"Thilo Riessner" <thilo@riessner.de> writes:
> I am using Postgres 6.4.1 and NeoWebscript 
> 3.0 . NeoWebscript asks for libpgtcl.so.1.0 in the file http.conf in the etc 
> subdirectory of the installation directory. I canged it to libpgtcl.so 
> because there was just a libpgtcl.so.2.0 in my distribution of postgres. 

There is a reason why the major version numbers are different: they're
not binary-compatible.  If this is a binary distribution of
NeoWebscript, you will need a newer NeoWebscript (or an older Postgres).
But if you are working from source it shouldn't matter.

> couldn't load file "/usr/lib/pgsql/lib/libpgtcl.so": 
> /usr/lib/pgsql/lib/libpgtcl.so: undefined symbol: Tcl_GetFile

Hmm, that suggests that you've got problems with your local version
of Tcl being different from what libpgtcl was compiled for.  Is this
libpgtcl one that you compiled yourself on your machine, or did you get
a binary distribution from somewhere else?  Or, perhaps you have more
than one version of Tcl installed, and NeoWebscript is picking a
different one than Postgres' configure script found?

The thing that usually gets people who are trying to dynamically load
libpgtcl is that libpgtcl.so depends on libpq.so, and many systems have
dynamic loaders that are not very bright about resolving second-level
dependencies like that.  This is not your current problem because
Tcl_GetFile is not a symbol in libpq, but if you still have problems
after you fix the Tcl version issue then you will need to look at
making sure that your system knows where libpq.so is.  There are
different incantations for that on different platforms --- see the
Postgres FAQ.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: "Brendan McKenna"
Date:
Subject: pgsql_perl5 fails to compile
Next
From: Benoit Foucher
Date:
Subject: Isolation level support with JDBC