Re: question

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

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