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).


Andrew Francis
Lead Developer
Family Health Network

--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to