Hello,
i am desesperate to get this resolved, you are my only hope
here is the issue:

i am compiling a .so using:

gcc -shared libxx.so -lpcre,

then in my DB, i am trying:

LOAD '/myPath/libxx.so',

it keeps returning me :

ERROR: could not load library "/myPath/libxx.so": libpcre.so : cannot open shared object file: No such file or directory.

the problem is that the libpcre.so does exist and is in my
LD_LIBRARY_PATH,

I really dont understand anything, i even dont know where to look at

at least could u give me some idea how to debug that ? i am thinking to reinstall the postgres ... i need to say that the postgres dameon is started at startup,




---------------------------------
Découvrez un nouveau moyen de poser toutes vos questions quelque soit le sujet ! Yahoo! Questions/Réponses pour partager vos connaissances, vos opinions et vos expériences. Cliquez ici.

didier tanti <tantididier@yahoo.fr> writes:
> ERROR: could not load library "/myPath/libxx.so": libpcre.so : cannot open shared object file: No such file or directory.

> the problem is that the libpcre.so does exist and is in my
> LD_LIBRARY_PATH,

But is it in the postmaster's LD_LIBRARY_PATH? That's what counts here.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly