"Daniel Zingaro"
<[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I'm wondering if anyone can help me understand the discrepancy here.
> Are recursive triggers required to implement some FK constraints?
I can't think of any reason why, except perhaps if you have foreign keys
referring to the same table, forming a tree-like structure. As in
create table tree(nodeid integer primary key, nodeinfo text,
parentid integer);
where parentid is a foreign key into tree(nodeid) (in other words,
parent of a node is itself a node). With such a table, it is reasonable
to expect that deleting a node deletes the whole subtree under it - but
that's impossible to achieve with triggers in SQLite.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
