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.
Sandeep
> I have attached my program which I am trying to load as a trigger
> function.
> I was unsuccessful.
>
> I cannot link due to "elog" and "SPI_*" functions. which library are
> they
> defined in?
>
> I am linking "-lpq" on the command line.
>
> Sandeep
>
> > * Sandeep Joshi <sjoshi@Zambeel.com> [001215 12:43] wrote:
> > >
> > > I need to update a second database through a trigger function
> written
> > > 'C'.
> > >
> > > Is that possible ? how?
> > >
> > > Do I need to go to commercial product for this?
> >
> > No, just reading the documentation should help. :)
> >
> > I imagine you should be able to link to libpq and do the updates
> > using that.
> >
> > --
> > -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
> > "I have the heart of a child; I keep it in a jar on my desk."
>
> ------------------------------------------------------------------------
>
> db1trig.c.errName: db1trig.c.err
> Type: Plain Text (text/plain)
