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
>
>

Reply via email to