Re: [sqlite] A proposal for SQLite version 3.0

[Andrew Francis]

I have an application which depends on INTEGER PRIMARY KEY values 
fitting into 32 bits.

I know that currently, the keys are generated with MAX()+1, but this 
behaviour is "undocumented and liable to change.: Now that rowid's are 
going 64 bit, a truly random INTEGER PRIMARY KEY may not fit into 32 bits.

Could we please see the current behaviour set in stone? I'd like to know 
that generated keys will always fit into 32 bits (provided I don't 
exceed ~4.3 billion records, naturally).

Thanks

--
Andrew Francis
Lead Developer
Family Health Network
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]