On 12 May 2019, at 11:56pm, Manuel Rigger <rigger.man...@gmail.com> wrote:

> Is this intended?

Yes.  Because the temp database disappears when you close your connection. So 
you would open a database and find that either a parent or a child table had 
disappeared.  Which would mean the database was corrupt.

Actually it's not limited to temp.  All FOREIGN KEY relationships must be 
between two tables in the same database.  Because if they were in different 
databases you might load one database and not the other.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to