Smith, Randall wrote: > Is it impossible to have references from temp tables to main tables?
Yes. > If so, aren't TEMPORARY tables largely useless? Only if you want to use foreign key constraints. > Is there another idiom in SQLite for managing tables that are intended > to have a short life or which should be reliably cleaned up when the > DB closes? You could omit the constraint from the temporary table. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users