Simon Slavin <slavins@...> writes: > I bet you a slap up dinner at the best hotel in the world if you still care about this issue in even a hundred > thousand years time.
No, I do not care. My current device will not exceed 2^64 in its lifetime, so I do not need any triggers. May be in the future computer speed will increase so much as to make 2^64 insufficient. At least sqlite documentation does specify what will happen in this case: SQLITE_FULL will be returned if AUTOINCREMENT was specified or rowid will be chosen at random if AUTOINCREMENT was not specified. May be then this second table approach will be useful, but now I do not care. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
