Hello Thomas, yes this did the trick, thanks. But what still puzzles me is that this error only occurs with the datetype timestamp.
Do You have an explanation for this ? Bye, Torsten... Am Donnerstag, 10. Juli 2003 10:28 schrieben Sie: > > Your problem is that the trigger defines a endless recursion, i.e. an > update of DBA.TEST fires the trigger which updates DBA.TEST what fires the > trigger again and so on. On linux platforms this results in a stack > overflow which kills die SAPDB kernel. This a known problem, but be have > not found a solution yet. > To avoid the problem, you must prevent the endless recursion. Inside your > trigger code you can tell the update statement to ignore the trigger : > > UPDATE "DBA"."Test" SET "_mdate"=timestamp WHERE TSTID=:NEW.TSTID IGNORE > TRIGGER; > > I hope this will solve your problem. > > Thomas _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
