On 1 Apr 2019, at 2:41pm, Simon Slavin <slav...@bigfraud.org> wrote: > BEGIN; > ... CREATE all your INDEXes ... > VACUUM; -- optional > END;
Apologies. The documentation says "A VACUUM will fail if there is an open transaction" I'm not sure whether this means that VACUUM must be outside the transaction, like the particular PRAGMA I used. So it would better to move the VACUUM after the END. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
