Hello, Is there a way to force the range value taken by a primary key?
Suppose I have a table that will never contain more than 2**20 rows. On some occasion, I want new inserted rows to have a pkey in [0, 2**32), on another occasion they would take their value in [2**32, 2*33), etc. In my problem, I can ensure that a range will not be overflowed. So I need to be able to set the pkey range, back and forth depending on the "occasion". I tried to fool the sqlite_sequence table but it didn't work. Is there a way to do this natively? -- jt