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

sqlite-users mailing list

Reply via email to