On Tue, 2004-08-17 at 17:27, Tom Lane wrote: > Graeme Hinchliffe <[EMAIL PROTECTED]> writes: > > I have written a trigger in C, and during the course of this I > > discovered that the LOAD command in psql wasn't updating the object when > > I made a change and recompiled. > > As requested by Tom, here is an example of this behaviour. I have just > > added this as a function as it performs the same. > > Thanks for the test case. Unfortunately it works fine here:
damn :) (but in a good way) > This is on RHL 8.0 on i386. What platform are you using exactly? This is RH 9.0 on i386 from RPM's > BTW, the file as given dumps core for me, because you have > > > extern Datum trigf(PG_FUNCTION_ARGS); > > PG_FUNCTION_INFO_V1(trigf); > > Datum testtrig(PG_FUNCTION_ARGS) oops! In the original I did have my function named as trigf, but I changed that so as not to conflict with the other function in my db > and the V1 macro needs to reference testtrig not trigf. However I do > not think this is related to the LOAD problem. It didn't dump core for me, it was quite happy :) I would guess because I have a function called trigf loaded in memory? Do you have any ideas what I am doing or what I have set wrong? -- ----- Graeme Hinchliffe (BSc) Core Internet Systems Designer Zen Internet (http://www.zen.co.uk/) Direct: 0845 058 9074 Main : 0845 058 9000 Fax : 0845 058 9005 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
