Re: [sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
On Fri, Aug 12, 2011 at 12:28 AM, Richard Hipp wrote: > On Thu, Aug 11, 2011 at 2:48 PM, Abhinav Upadhyay < > er.abhinav.upadh...@gmail.com> wrote: > >> On Fri, Aug 12, 2011 at 12:05 AM, Michael Stephenson >> wrote: >> > If you use INTEGER PRIMARY KEY, that column becomes your rowids; this >> doe

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Richard Hipp
On Thu, Aug 11, 2011 at 2:48 PM, Abhinav Upadhyay < er.abhinav.upadh...@gmail.com> wrote: > On Fri, Aug 12, 2011 at 12:05 AM, Michael Stephenson > wrote: > > If you use INTEGER PRIMARY KEY, that column becomes your rowids; this > does > > not create a new, separate column in addition to the rowid

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
On Fri, Aug 12, 2011 at 12:05 AM, Michael Stephenson wrote: > If you use INTEGER PRIMARY KEY, that column becomes your rowids; this does > not create a new, separate column in addition to the rowid column. Indeed, but the INTEGER PRIMARY KEY column would count as a user defined column and thus aff

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Michael Stephenson
, August 11, 2011 2:06 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Use of VACUUM On Thu, Aug 11, 2011 at 11:15 PM, Simon Slavin wrote: > > On 11 Aug 2011, at 6:35pm, Abhinav Upadhyay wrote: > >> The documentation page of the VACUUM command says that "The VA

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
On Thu, Aug 11, 2011 at 11:14 PM, Igor Tandetnik wrote: > On 8/11/2011 1:35 PM, Abhinav Upadhyay wrote: >> The documentation page of the VACUUM command says that "The VACUUM >> command may change the ROWIDs of entries in any tables that do not >> have an explicit INTEGER PRIMARY KEY." So what are

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
On Thu, Aug 11, 2011 at 11:15 PM, Simon Slavin wrote: > > On 11 Aug 2011, at 6:35pm, Abhinav Upadhyay wrote: > >> The documentation page of the VACUUM command says that "The VACUUM >> command may change the ROWIDs of entries in any tables that do not >> have an explicit INTEGER PRIMARY KEY." So wh

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Igor Tandetnik
On 8/11/2011 1:35 PM, Abhinav Upadhyay wrote: > The documentation page of the VACUUM command says that "The VACUUM > command may change the ROWIDs of entries in any tables that do not > have an explicit INTEGER PRIMARY KEY." So what are the possible cases > in which the ROWIDs might change ? ROWID

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Richard Hipp
On Thu, Aug 11, 2011 at 1:35 PM, Abhinav Upadhyay < er.abhinav.upadh...@gmail.com> wrote: > Hi, > > The documentation page of the VACUUM command says that "The VACUUM > command may change the ROWIDs of entries in any tables that do not > have an explicit INTEGER PRIMARY KEY." So what are the possi

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Simon Slavin
On 11 Aug 2011, at 6:35pm, Abhinav Upadhyay wrote: > The documentation page of the VACUUM command says that "The VACUUM > command may change the ROWIDs of entries in any tables that do not > have an explicit INTEGER PRIMARY KEY." So what are the possible cases > in which the ROWIDs might change ?

[sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
Hi, The documentation page of the VACUUM command says that "The VACUUM command may change the ROWIDs of entries in any tables that do not have an explicit INTEGER PRIMARY KEY." So what are the possible cases in which the ROWIDs might change ? Thanks Abhinav ___