| From: | Shay Moreno <moreno(at)tdk(dot)dk> |
|---|---|
| To: | "'phpa'" <abe(at)fish(dot)tm>, pgsql-novice(at)postgresql(dot)org |
| Subject: | RES: < Int4 - limit > |
| Date: | 2001-04-18 11:46:12 |
| Message-ID: | 5D38890DAE46D41186A800508B6F7187026FFD73@oestmb010-b0.tdk.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)amdocs(dot)com
/ \ Campanha fita ASCII mailto:moreno(at)tdk(dot)dk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Olbersen | 2001-04-18 16:50:42 | Re: < Int4 - limit > |
| Previous Message | phpa | 2001-04-18 11:11:07 | < Int4 - limit > |