Hi, Kernel 7.5.0 Build 014-121-073-298 (just installed the rpm I got from the mysql download site). From the knldiag I think there is a segfault (see attached file).
From your questions I assume that this behaviour is unexpected and my aproach actually goes in the right direction? Thanks Tobias Dittrich Am Dienstag, 13. Juli 2004 09:45 schrieben Sie: > Tobias Dittrich wrote: > > Hi, > > > > I have seen this question asked before on this list, > > but unfortunately the answer deviated a bit from the > > original question - or maybe I just did not understand > > the answer good enough, this is the first time I try > > with triggers and such. > > > > I want to do something like copy the behaviour of the > > mysql TIMESTAMP. That is: the timestamp column holds > > the date (and time) of the last modification of the > > corresponding data row. As I understand for INSERT this > > can be achieved by setting the default column value to > > TIMESTAMP. > > > > For UPDATE the simple aproach: > > CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE > > EXECUTE ( > > UPDATE USER.TEST SET DATUM=TIMESTAMP WHERE > > TEST.ID=:NEW.ID; ) > > does not work. This causes the db kernel to crash every > > time I execute an update on the table - presumably > > because of an endless recursion of the trigger? > > > > But what would be the right aproach to this problem? > > Which kernel-version are we talking about? > How does the traceback of the crash looks like (see > knldiag) ? Did you try (to avoid 'endless' loop) to > specify those columns resulting in the firing of the > trigger? see > http://dev.mysql.com/doc/maxdb/en/a7/41ee0b605911d3a98800 >a0c9449261/frameset.htm ==> > ...FOR TEST AFTER UPDATE (specify all columns except > DATUM) EXECUTE... > > Elke > SAP Labs Berlin > > > Many thanks in advance > > > > Tobias Dittrich > > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] -- Tobias Dittrich - Internet-Entwicklung - __________________________ WAVE Computersysteme-GmbH Philipp-Reis Str. 1 35440 Linden Tel.: +49 (0)6403 / 9050 - 6001 Fax: +49 (0)6403 / 9050 - 5089 mailto: [EMAIL PROTECTED] http://www.wave-computer.de
knldiag.gz
Description: GNU Zip compressed data
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
