Hi, thx for your response. Unfortunatelly the choice n. 1 (the PRAGMA setting) is deprecated So it will no more available in new version of sqlite. I should not use use to avoid to lost compatibility with new versions of sqlite.
Also in my scripts I should to hypotize that the environment variable could not always be set, so the default path became the /var/tmp instead of the /tmp. A. 2016-02-01 10:46 GMT+01:00 Clemens Ladisch <clemens at ladisch.de>: > Andrea Peri wrote: >> After some searches, I found the trouble is due to the vacuum command >> that is going to use >> the /var/tmp folder for temporary files. >> >> I like to say to the sqlite to use instead the /tmp. >> [...] >> Unfortunatelly I do not found in the documentation no one alternative >> to the deprecated temp_store_directory. > > This is OS dependent. > > In your case, SQLite's temporary directory is > 1. whatever is set with the PRAGMA temp_store_directory command; or > 2. whatever is set with the SQLITE_TMPDIR environment variable; or > 3. whatever is set with the TMPDIR environment variable; or > 4. /var/tmp; or > 5. /usr/tmp; or > 6. /tmp. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- ----------------- Andrea Peri . . . . . . . . . qwerty ????? -----------------