Zitat:
What is the maximum value of a generator?
Generators store and return 64-bit values in all versions of Firebird. This gives us a value range of:
-263 .. 263-1 or -9,223,372,036,854,775,808 .. 9,223,372,036,854,775,807
So if you use a generator with starting value 0 to feed a NUMERIC(18) or BIGINT column (both
types represent 64-bit integers), and you would insert 1000 rows per second, it would take around 300
million years (!) before it rolls over. As it is pretty unlikely mankind will still walk on this planet by
then (and still use Firebird databases), that's nothing to be really worried about.
Quelle:
http://www.firebirdsql.org/pdfmanual...ator-Guide.pdf