Re: [sqlite] VACUUM function problem

[Ulrik Petersen]

Hi D.W.,
D.W. wrote:
I use sqlite 2.8.x in combination with PHP.
I want to clean up my database and remove empty spaces.
I used this command: $ok=sqlite_query($sqlite,"VACUUM tablename");
But it doesnt't work. An error message didn't come either.
Does anybody know what is wrong?
Daniel
I hope you're using something later than 2.8.0, because VACUUM was only 
(re)implemented in 2.8.1.  From the docs:

http://www.sqlite.org/lang.html#vacuum
"The index or table name argument is now ignored."
Also from the same page:
"This command will fail if there is an active transaction. This command 
has no effect on an in-memory database."

HTH
Ulrik
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark