Daniel John Debrunner wrote:
Then I think this would lead to a simpler action statement of
UPDATE TEST SET TIMESTAMP = CURRENT_TIMESTAMP WHERE TESTID = OLD.TESTID
A statement trigger might be best in this case, would result in a single
update statement rather than N.
Hmmm....
Well, this (I think) is where we started and from what I understand
from Yip is the case that is always supposed to give us the "Maximum
depth of nested triggers was exceeded error" (DERBY-1652). If the
trigger is defined this way, when the row is updated, it fires the
update trigger which updates the row which fires the update trigger etc...
I added the additional qualifier (
AND INFO != OLD.INFO
to make it stop on the second fire. Is there a better way?
Kathey
