Thread: RES: < Int4 - limit >

RES: < Int4 - limit >

From
Shay Moreno
Date:
> 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.

    Shouldn't you just use a sequence for that?  Or recreate your table
with a bigger data type?




--
  _
 / \       Leandro Guimarães Faria Corcete Dutra        +55 (11) 3040 8913
 \ /       Amdocs Brasil Ltda at Tele Danmark                +45 3387 5214
  X   http://terravista.pt./Enseada/1989/     mailto:leandrod@amdocs.com
 / \     Campanha fita ASCII                        mailto:moreno@tdk.dk