Re: [GENERAL] Triggers in C - Segmentation Fault

2006-05-15 Thread Martijn van Oosterhout
The core file usually appears in the data directory of the backend. If you still can't find it, you can try attaching gdb to the running backend. After the connection has started, find the backend (not the postmaster) and attach using: gdb -p Once connected, type "cont" and proceed with the act

Re: [GENERAL] Triggers in C - Segmentation Fault

2006-05-15 Thread Chris Coleman
Hi, I have done the below command and restarted the server and built my triggers with the -g command using gcc, but I cannot seem to find any core files nor any reference to where postgres may place them. Where would they normally appear? Cheers Chris Probably the easiest thing to do is make s

Re: [GENERAL] Triggers in C - Segmentation Fault

2006-05-12 Thread Martijn van Oosterhout
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

[GENERAL] Triggers in C - Segmentation Fault

2006-05-12 Thread Chris Coleman
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 erro