Problems with sqlite support with 1.4.8: no such table: uniqueid_temp

[Jeff Mitchell]

Rich wrote:
> On 2008.02.26. 14:39, Jeff Mitchell wrote:
> ...
>   
>> So here's why you get those _temp errors.
>>
>> You said you were doing full rescans.  When the collection scanner is doing an 
>> incremental scan it creates temporary tables populated with old information; 
>> then it drops the normal tables, scans, and copies the info from the temp 
>> tables back (I think I have that sequence right).  However, when doing a full 
>> rescan it drops all tables and just scans directly in, it doesn't create 
>>     
>
> does it really drop tables ? i hope it doesn't, because we tell people 
> to do full rescans all the time and they sort of don't come back 
> complaining about lost statistics...
>   
Several tables are handled separately and are not part of the "normal" 
tables, like the statistics table.

--Jeff