Igor Tandetnik <itandetnik@...> writes: > > Balasubramani Vivekkanandan <bvivekkanandan@...> wrote: > > I am very new database development and sqlite. I have a requirement > > where I want to restrict the size of my integer primary key to 3 bytes. > > In my database, entries will be added and removed very frequently. So If the > > primary key limit of 3 bytes is reached, it should try to reuse the deleted > > entries. > > What purpose exactly is this, rather bizarre, requirement supposed to serve, if you don't mind me asking? > > > Is this possible with sqlite? > > Not automatically. You can implement it in your application code.
sorry that I cant agree but with an extra table to store the latest id, a little TRIGGER gaming and DELETE and REPLACE the job could be done (I believe) but it isn't worth to waste time with this because using the application is much more comfortable. greetings oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users