Re: question

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.

Sandeep

> * Sandeep Joshi <sjoshi(at)Zambeel(dot)com> [001215 14:54] wrote:
> > ld -shared -o db1trig.so db1trig.o -L/work/posgresql/lib -static -lpq
> >
> > Using above link line I was able to link and load the library but I get
> > following error
> > ERROR: conneciton bad.
>
> I think using both -shared and -static is an error, you might try
> linking to /work/posgresql/lib/libpq.a or try without as well.