"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]
-----------------------------------------------------------------------------

Reply via email to