Re: question

Sandeep Joshi <sjoshi(at)Zambeel(dot)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