> > It won't make any difference to the generator. It will keep

generating

> > BigInts, no matter how many times your Before Insert triggers

cause

> > overflow exceptions.
> > :-)
> >
> > ./hb
> >
>
> true,.. but you will get clashes in the PK 4 times during the hell
> freeze-over period.
> Alan

Alan,

Where has your maths gone?

:)

More like 2^31 times clashes. (2^64 is way bigger than 4 times 2^32
which is only 2^34)

In the end it is a moot point anyway.

Generators won't overflow regardless of how you declare your fields.
But if you declare your field as an integer, as Helen pointed out you
are (hopefully) going to get an overflow exception to prevent the
insert.

Adam