| From: | "Darko Prenosil" <Darko(dot)Prenosil(at)finteh(dot)hr> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Fw: C trigger |
| Date: | 2002-05-08 14:54:22 |
| Message-ID: | 02bc01c1f6a0$40cc0fc0$f600000a@darko |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
----- Original Message -----
From: Darko Prenosil
To: pgsql-general(at)postgresql(dot)org
Sent: Wednesday, May 08, 2002 4:11 PM
Subject: C trigger
In trigger function written in C, expression:
SPI_getvalue(tupleNEW, tupdesc, n) crushes the server !!!
trigdata = (TriggerData *) fcinfo->context
tupleNEW = trigdata->tg_newtuple
Values of tupleNEW, tupdesc, and n are OK because same trigger works
AFTER UPDATE and AFTER DELETE, but not AFTER INSERT
Someone know why ?
Sorry !
I accessed trigdata->tg_newtuple which has no meaning in insert trigger !!!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-05-08 15:02:35 | Re: Performance issues with compaq server |
| Previous Message | Jean-Luc Lachance | 2002-05-08 14:48:16 | Re: Can this be done in one query? |