Re: [GENERAL] update trigger not working

2005-10-19 Thread Oliver Elphick
On Wed, 2005-10-19 at 19:26 -0700, CSN wrote: > I'm trying to set up a trigger that simply updates a > field's corresponding timestamp to now() whenever the > field is updated. But it's not working. Trying to > debug, I commented out the inner IF and END and the > log seemed to indicate infinite re

Re: [GENERAL] update trigger not working

2005-10-19 Thread Douglas McNaught
CSN <[EMAIL PROTECTED]> writes: > I'm trying to set up a trigger that simply updates a > field's corresponding timestamp to now() whenever the > field is updated. But it's not working. Trying to > debug, I commented out the inner IF and END and the > log seemed to indicate infinite recursion occur

Re: [GENERAL] update trigger not working

2005-10-19 Thread Mike Nolan
> I'm trying to set up a trigger that simply updates a > field's corresponding timestamp to now() whenever the > field is updated. But it's not working. Trying to > debug, I commented out the inner IF and END and the > log seemed to indicate infinite recursion occurred. My > next guess is that perh