On Tue, 2002-01-22 at 12:12, Flemming Frandsen wrote: > John Holland wrote: > > > On Mon, 2002-01-21 at 21:36, Flemming Frandsen wrote: > > > > > and if so, how can the chain be broken? > > > Either the stack will overflow, causing an SQL error to be returned to > > > the client or the server will segfault. > > > > none of the two is true! > > Yes, they are, I've tried both here. > > Depending on what you do in your trigger the server will either tell you > that something is wrong (stack overflow error) or it will crash. >
i was carefull enough not to create a endless loop in the delete and update triggers that i use. i did not explicity try to create a endless loop. > > > you forgot to mention the most important part of the mail: > > which trigger routine statement will break the recursion!! > > No I didn't, I don't know how to detect the recursion. > > -- > Regards Flemming Frandsen aka. Dion/Swamp http://dion.swamp.dk >
