Re: question

* Sandeep Joshi <sjoshi@Zambeel.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@Zambeel.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@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."