Re: Skipping numbers in a sequence.

GH wrote:
>
> >
> > Er, to answer my own question, yes.
> > I seem to have discovered that the maximum maxvalue for a sequence is
> > 9,999,999,999 (i.e. 10 digits) -- which leads one to believe that 10 is
> > the max num of digits for an integer-type column.
> [Must...stop...coding...while...asleep...and....braindead.]
>
> The max for maxvalue is the max(integer) which I believe is 2147483647.

So if you stick with the current standard, you can create ten per second
for the next 6.8 years before you have to worry.

I think that by then PostgreSQL will have INT8 sequences, or you will
have learned enough to implement them yourself :-)

Regards,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267