Re: question

Sandeep Joshi <sjoshi@Zambeel.com> writes:
> It results in following error: (just "shared")
> ERROR:  Load of file /var/lib/pgsql/trigger/db1trig.so failed: libpq.so.2.1:
> cannot open shared object file: No such file or directory

> I tried following link line (which specifies "run-time" linking path).
> ld -shared -o db1trig.so db1trig.o -R/work/posgresql/lib -lpq

> This results in following error when  "PQsetdb" is called:

> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.

It looks like you're down to debugging vagaries of the dynamic linker
on your platform :-(.  You might find that the linker sends useful
error messages to stderr --- check the postmaster's logfile.  (If you're
not redirecting the postmaster's stdout/stderr into a logfile, do so.
Don't forget to NOT use -S, or the logfile will never get any output.)

            regards, tom lane