Postgres Pro
Downloads
Home   >   mailing lists

Thread: < Int4 - limit >

< Int4 - limit >

From
"phpa"
Date:
Hey there,
 
(using postgres 6.5.0 - on Red Hat Linux)
 
I have built a small application which has a table for unique identifiers with a column of type int4.
 
This has one added to it each time a new key is required.  I am a little worried that at some point when the limit of int4 is reached the system will fall over.  Is this the case or is there a work around.
 
 
Thanks for any help.

Re: < Int4 - limit >

From
Peter Eisentraut
Date:
phpa writes:

> Hey there,
>
> (using postgres 6.5.0 - on Red Hat Linux)
>
> I have built a small application which has a table for unique identifiers with a column of type int4.
>
> This has one added to it each time a new key is required.  I am a little worried that at some point when the limit of
int4is reached the system will fall over.  Is this the case or is there a work around. 

int8

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter