> On 23 Jul 2016, at 3:33pm, Dan Kennedy <danielk1...@gmail.com> wrote: > >> On 2016/07/23 3:30 PM, Simon Slavin wrote: >> >>> The other way around should fine, though: use a permanent table to ensure >>> that only legitimate values appear in a temporary table. > > The trouble is that some other process may come along and modify the > permanent table, violating the FK constraint in the temporary schema.
Uhhhh ... didn't think of that. Yep, that explains why it works the way it does. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
