Actually, it can't be in a transaction. To quote: "A VACUUM will fail if there is an open transaction, or if there are one or more active SQL statements when it is run." (See http://www.sqlite.org/lang_vacuum.html).
Best regards, Peter ________________________________ From: Pete <[email protected]> To: [email protected] Sent: Mon, March 26, 2012 10:14:32 AM Subject: Re: [sqlite] VACUUMing large DBs SHould a VACUUM command be wrapped in a transaction, or is that done automatically? -- Pete _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
