I have deleted some objects in my database. Now I have objects at id (INTEGER PRIMARY KEY) =1,3,4,5,7,8,9,16,17,20.... . id=2,6,10,.. are empty. I want to defrag the database so that I have objects continuously at id=1,2,3,4,5,6,7,... Is the vacuum function not the right function? Daniel ----- Original Message ----- From: "Ulrik Petersen" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, December 27, 2004 10:40 PM Subject: Re: [sqlite] VACUUM function problem
> D.W. wrote: > > >Thanks for your reply. > >I have just checked the version. It's 2.8.15. > >There's no active transaction. > >Do you have another idea? > > > > > How do you verify that nothing happens? > > Ulrik > > -- > Ulrik Petersen, MA, B.Sc. > University of Aalborg, Denmark > >