>
> 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 :-)
Alan