If you or anyone reading this can put together a working C trigger example
with a test table and compile and trigger load procedure, I'd like to have it
to play with! I've been trying to use the examples in the docs and the ones
in contrib/spi, but with no luck. I'm using 7.0.3. I notice that the delev
docs have a different C trigger example than the 7.0 docs. I don't know what
the differences are, one returns a HeapTuple and the other a Datum (a
unsigned long)?
Anyhow, some more detailed, up-to-date, docs on some of this would be nice.
If I can learn these structs etc for C triggers, I'll try to write some HTML
page about it how it all works in detail.
On Friday 15 December 2000 18:12, Sandeep Joshi 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.
>
>
> 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.
--
-------- Robert B. Easter reaster@comptechnews.com ---------
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------