On 9/3/17 10:16 AM, Joseph L. Casale wrote:
-----Original Message-----
From: sqlite-users [mailto:[email protected]] On
Behalf Of R Smith
Sent: Sunday, September 3, 2017 7:51 AM
To: [email protected]
Subject: Re: [sqlite] SQLITE bug
Lastly, a comment I've made possibly more than once on this list: There
is no imperative to trust the SQL engine with ID assignments. You are
free to (and I prefer to) assign IDs yourself.
What exactly do you feel you benefit by taking ownership of the ID, specifically
that of which you feel supersedes the obvious perils in the cases you noted?
One BIG example of a place to overrule the default ID assignment via
auto-increment is in restoring a backup. Here, you NEED to ID to be the
same as before so Foreign keys in other tables stay pointing to the
right record.
--
Richard Damon
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
