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