> > Thoughts? Would making recursive triggers an error rather > than just silently ignoring them break anybody's code?
even if it does, it should. otherwise, people may assume that the functionality exists,and rely on it. > I'm also looking at making DELETE triggers recursive. I can > do that because recursive DELETE triggers are guaranteed to > terminate (you will eventually run out of rows to delete.) > But INSERT or UPDATE triggers might go on forever. There are > also technical issues that make recursive INSERT and UPDATE > triggers more difficult so that I would prefer to delay > implementing them. > > Comments? Would it be useful to have recursive DELETE > triggers even without recursive INSERT or UPDATE triggers? not much IMHO....