> I have the $SUBJECT problem loading my own
> module in PostgreSQL. The server is HP-UX/ia64,
> PostgeSQL 8.4.2 was compiled with HP CC.
> pl/PgSQL can be loaded fine.
>
> ...:/usr/local/pgsql/pgsql-cc-8.4/lib# ldd odbclink.so
> libodbc.so.1 => /usr/local/pgsql/runtime/lib/libodbc.so.1
> libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1
> libc.so.1 => /usr/lib/hpux64/libc.so.1
> libdl.so.1 => /usr/lib/hpux64/libdl.so.1
>
> "/usr/local/pgsql/runtime" is a link to "/usr/local/pgsql/pgsql-
> cc-8.4"
>
> ...:/usr/local/pgsql/pgsql-cc-8.4/lib# file plpgsql.so odbclink.so
> plpgsql.so: ELF-64 shared object file - IA64
> odbclink.so: ELF-64 shared object file - IA64
>
> The module compilation was done using "USE_PGXS=1 gmake".
>
> How can I solve this issue?
IIRC, HP/UX doesn't like to dynamic-load shared libraries that use
thread-local storage. Your shared library (odbclink.so) is linked
against libpthread.so.1 so you may be running into that problem. I
would recommend running the HP/UX equivalent of strace to capture more
information about the call to dlopen() (or perhaps shl_load(),
depending on which version of HP/UX you are using).
-- Korry
-----------------------------------------------------------------------
Korry Douglas
Senior Database Dude
EnterpriseDB Corporation
The Enterprise Postgres Company
Phone: (804)241-4301
Mobile: (620) EDB-NERD