Just wondering when/if Richard
will make SQLite having referential Integrity a priority.
Is it on the TODO list? Is it #1 or #100 on this TODO list.
Because almost all other common databases have this.
 
Once it has this feature I think that it will become even more popular.
 
Signing off
Great Fan of SQLite
P.
> From: danielk1...@gmail.com> To: sqlite-users@sqlite.org> Date: Sat, 31 Jan 
> 2009 00:28:05 +0700> Subject: Re: [sqlite] Foreign key support> > > On Jan 
> 31, 2009, at 12:25 AM, Adam DeVita wrote:> > > Good day,> >> > If I write 
> into the sqlite3 using the analyzer:> >> > create table mysns (SN int primary 
> key, desc text);> > insert into mysns (SN, desc) values (1,2);> > create 
> table t2 (mynum int, desc2 text, SN references mysns(SN) );> >> > insert into 
> t2 (mynum, desc2, SN) values (1,"two", 3);> >> > This insert didn't produce 
> an error, despite the fact 3 isn't in table> > mysns. Why?> > Foreign keys 
> are not supported. See the first entry in> this list:> > 
> http://www.sqlite.org/omitted.html> > > >> >> > regards,> > Adam> > 
> _______________________________________________> > sqlite-users mailing list> 
> > sqlite-users@sqlite.org> > 
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > 
> _______________________________________________> sqlite-users mailing list> 
> sqlite-users@sqlite.org> 
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_________________________________________________________________
Windows Liveā„¢: Keep your life in sync. 
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_022009
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to