RES: < Int4 - limit > - Mailing list pgsql-novice

From Shay Moreno
Subject RES: < Int4 - limit >
Date
Msg-id 5D38890DAE46D41186A800508B6F7187026FFD73@oestmb010-b0.tdk.dk
Whole thread Raw
List pgsql-novice
> 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

pgsql-novice by date:

Previous
From: "phpa"
Date:
Subject: < Int4 - limit >
Next
From: David Olbersen
Date:
Subject: Re: < Int4 - limit >