Re: question

* Tom Lane <tgl@sss.pgh.pa.us> [001215 17:36] wrote:
> 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.)

Actually we got it working, it just took several tries for Sandeep
to understand what I was trying to tell him to do:

ld -shared -o db1trig.so db1trig.o /work/posgresql/lib/libpq.a

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