Re: [sqlite] Avoiding reuse of PrimaryKey values, even in case of truncation

"blackmonkey" wrote in message news:21491295.p...@talk.nabble.com > I have a requirement that the primary keys (auto generated) in a > table never repeat in the life of the database. http://sqlite.org/autoinc.html Igor Tandetnik ___ sqlite-users ma

[sqlite] Avoiding reuse of PrimaryKey values, even in case of truncation

Hi I have a requirement that the primary keys (auto generated) in a table never repeat in the life of the database. It works fine in case a record is deleted from anywhere but the bottom of the table. But in case of truncation it does not work so. Currently what is happening is say I have recor