On 12 May 2019, at 11:56pm, Manuel Rigger <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to