RE: [sqlite] Are DELETE TRIGGERS recursive or not?

Hello Allan, Mark, I am not sure, but I don't think recursive delete triggers apply to your web-page example. I was looking for recursive delete triggers because the information I need to store in a single table is hierarchical in a sense that a record can refer to another record in the same t

RE: [sqlite] Are DELETE TRIGGERS recursive or not?

: Ralf Junker [mailto:[EMAIL PROTECTED] > Sent: 26 October 2005 16:58 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Are DELETE TRIGGERS recursive or not? > > > Hello [EMAIL PROTECTED], > > Thank you! I am very much looking forward to recursive delete > trigg

Re: [sqlite] Are DELETE TRIGGERS recursive or not?

Hello [EMAIL PROTECTED], Thank you! I am very much looking forward to recursive delete triggers for just the very purpose you mentioned! Regards, Ralf >Not at this time. Though work is underway to change this. >We need recusive delete triggers in order to implement >cascadinig deletes for ref

Re: [sqlite] Are DELETE TRIGGERS recursive or not?

Ralf Junker <[EMAIL PROTECTED]> wrote: > I wonder if a DELETE TRIGGER should trigger itself recursively Not at this time. Though work is underway to change this. We need recusive delete triggers in order to implement cascadinig deletes for referential integrity. -- D. Richard Hipp <[EMAIL PR

Re: [sqlite] Are DELETE TRIGGERS recursive or not?

If the trigger were recursive, it would invoke itself forever, even if it's not doing anything because the where clause fails. Regards

[sqlite] Are DELETE TRIGGERS recursive or not?

I wonder if a DELETE TRIGGER should trigger itself recursively in the following scenario: create table f (i integer primary key, p integer, n text); create trigger f_delete after delete on f begin delete from f where p = old.i; end; insert into f values (1, null, '