"Andrew Finkenstadt" <[EMAIL PROTECTED]> wrote: > I realize that FTS1/2 has this slight flaw with the text indexes recording > the _rowid_ of a table, in the expectation that a rowid was permanent. That > would have caught me unawares, as in Oracle a ROWID is permanent... even if > the row has migrated, there's a migrate record at the place where the row > used to be. > > Does the same renumbering during VACUUM (auto or otherwise) apply to the > explicitly identified integer primary key column when it is named "id", or > named "pkey"?
No. INTEGER PRIMARY KEY columns keep the same value through a vacuum. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
