At 07:27 AM 26/07/2005 +1000, you wrote:

> >
> > OK, just curious. :-)
> >
> > > -----Original Message-----
> > > From: firebird-support@yahoogroups.com
> > > [mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
> > > Sent: 25. juli 2005 16:55
> > > To: firebird-support@yahoogroups.com
> > > Subject: RE: [firebird-support] Re: The only user
> > >
> > > At 04:40 PM 25/07/2005 +0200, you wrote:
> > > >What happens when a generator goes beyond 2,147,483,648. Does it
> > > >restart at zero or generate an error?
> > >
> > > Neither. It goes to 2,147,483,649. A generator is a BigInt
> > > and will roll over when it surpasses
> > > 9,223,372,036,854,775,808 - around the same time as Hell freezes over.
> > >
> > > ./hb
> > >
>
>just make sure you're putting the gen value into a BIGINT and not an INT in
>your table :-)

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