Skip site navigation (1) Skip section navigation (2)

Re: Skipping numbers in a sequence.

From: GH <grasshacker(at)over-yonder(dot)net>
To: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Skipping numbers in a sequence.
Date: 2000-11-26 10:47:34
Message-ID: 20001126044734.B43137@over-yonder.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
On Sun, Nov 26, 2000 at 11:33:39PM +1300, some SMTP stream spewed forth: 
> 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.

Bu...bu...but, *that's not the /point/*! ;-))

heh.
I hate it when my noble efforts are shot down by realism and sensible
thinking. ;-)

The truly funny thing about it all is that I have since dropped the whole
bloody column from the table. Who needs a single unique column, anyway?
The sad truth is that I need to re-do a large part of the schema using
foreign keys and some other things. 


Thanks for all your efforts.

gh

 
> 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

In response to

pgsql-novice by date

Next:From: Dmitri TouretskyDate: 2000-11-26 18:35:02
Subject: One more simple question...
Previous:From: Andrew McMillanDate: 2000-11-26 10:33:39
Subject: Re: Skipping numbers in a sequence.

pgsql-general by date

Next:From: Michael AnsleyDate: 2000-11-26 11:34:16
Subject: RE: [HACKERS] Indexing for geographic objects?
Previous:From: Andrew McMillanDate: 2000-11-26 10:33:39
Subject: Re: Skipping numbers in a sequence.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group