On Feb 9, 2010, at 8:54 AM, Paul Vercellotti wrote:

>
>
> Hi there,
>
> Are there any restrictions in SQLite on foreign key references in  
> temporary tables?   Is referential integrity enforced between temp  
> tables and persistent ones? (That is, does the referential integrity  
> checking take into account key references in a temp table to a  
> regular table's key?)   Couldn't find anything about this one way or  
> another in the docs.

Both tables in an FK relationship must be in the same database.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to