> On Oct 6, 2017, at 3:13 PM, Roman Fleysher <roman.fleys...@einstein.yu.edu> > wrote: > > Vacuuming seems to belong to a different thread, but let me say that it is > not always warranted. Vacuuming may change/reassign ROWIDs.
The docs say "The VACUUM command may change the ROWIDs of entries in any tables that do not have an explicit INTEGER PRIMARY KEY.” If you don’t declare an explicit primary key, relying on the automatic ‘rowid’ column to provide one sounds like a bad idea to begin with. And it’s easy to work around by declaring a primary key. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users