Re: [sqlite] Foreign Key Constraints

2008-10-22 Thread Igor Tandetnik
"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

Re: [sqlite] Foreign Key Constraints

2008-10-21 Thread D. Richard Hipp
On Oct 21, 2008, at 10:33 PM, Daniel Zingaro wrote: > > However, then, on the SQLite wiki, I found that there is a way to > implement FK constraints using triggers!: > http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers > > I'm wondering if anyone can help me understand the discrepancy here.

[sqlite] Foreign Key Constraints

2008-10-21 Thread Daniel Zingaro
Hi all, I've just joined this list hoping to learn more about SQLite. I'm using SQLite to teach the SQL portion of a college databases course. The one thing that concerns me a little is the lack of foreign key constraints. (I've been yapping about referential integrity for weeks and really