Re: < Int4 - limit >

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: phpa <phpa(at)fish(dot)tm>
Cc: <pgsql-novice(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: < Int4 - limit >
Date: 2001-04-19 15:47:58
Message-ID: Pine.LNX.4.30.0104191747400.762-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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 int4 is reached the system will fall over. Is this the case or is there a work around.

int8

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wampler 2001-04-19 15:53:58 Changing from default configuration options in 7.1?
Previous Message Peter Eisentraut 2001-04-19 15:45:20 Re: confirmation of insert/update

Browse pgsql-novice by date

  From Date Subject
Next Message Bob Whitehouse 2001-04-19 21:23:18 Questions about writing functions...
Previous Message Shay Moreno 2001-04-19 10:38:06 Re: Trigger and Function Question