Re: Triggers in C - Segmentation Fault

On Thu, May 11, 2006 at 10:28:37AM +0100, Chris Coleman wrote:
> Hi,
>
> I have written a couple of trigger functions in C that utilise the SPI
> interface.  They are both row level triggers, one a before trigger and
> one an after trigger.
>
> If the triggers are called with an update statement that only affects
> one row then both are excecuted correctly and without error.  But if I
> try to update multiple rows then this fails.

Probably the easiest thing to do is make sure your functions are
compiled with debugging and enable core dump by running "ulimit -S -c
unlimited" before starting the server. You can then use gdb to
pin-point where it dies...

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.