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 possible cases > in which the ROWIDs might change ? > In the current implementation, I think the only way you can get the ROWIDs to change is to compile SQLite with the SQLITE_OMIT_XFER_OPT compile-time option. But, we reserve the right to change this in future releases. In other words, future releases of SQLite might be more aggressive about renumbering rowids. So do not depend on the current behavior. If you need to preserve rowids, then declare an INTEGER PRIMARY KEY column. > > Thanks > Abhinav > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
