Subject RE: [IBO] TIMESTAMP question
Author Helen Borrie
At 02:35 PM 10/12/2004 +0200, you wrote:

>What happens when a generator reaches it's top limit (which I assume is an
>Integer value), does it wrap to 0 or to it's negative limit? With the speed
>that recording could potentially occur at, this is quite an important factor
>to consider before using a generator to generate a primary key for this

A generator is a 64-bit integer (BigInt) so it will reach its top limit at
9,223,372,036,854,775,807. That's enough for several lifetimes; but if
you live long enough, yes, it will roll over at that point and start
generating duplicates.