Re: SPI problem - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: SPI problem
Date
Msg-id 2956.1088564622@sss.pgh.pa.us
Whole thread Raw
In response to SPI problem  ("Alastair Bell" Turner "" <bell@tangent.co.za>)
List pgsql-interfaces
"Alastair Bell" Turner "" <bell@tangent.co.za> writes:
> I'm trying to build a c trigger with the Server Programming Interface and
> not having a lot of joy.

I think what you need to return from a trigger is PointerGetDatum() of a
HeapTuple.  TupleGetDatum is a different animal that is *not* used for
trigger results, for mostly-historical reasons.

There are several working examples in the contrib/ modules.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Greg Markham
Date:
Subject: Embedded SQL timestamp Question (ECPG)
Next
From: Carlos Ojea Castro
Date:
Subject: Re: : query using kylix (delphi)