Re: question

* Sandeep Joshi <sjoshi(at)Zambeel(dot)com> [001215 15:25] wrote:
> 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.

You didn't follow my last suggestion which was to take out -L... and -lpq and
instead use /work/posgresql/lib/libpq.a on the command line.

>
>
> 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.

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."