Re: Serial Unique question

From: Madison Kelly <linux(at)alteeve(dot)com>
To: Douglas McNaught <doug(at)mcnaught(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Serial Unique question
Date: 2005-08-15 15:48:00
Message-ID: 4300B930.8080401@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Douglas McNaught wrote:
> Madison Kelly <linux(at)alteeve(dot)com> writes:
>
>
>> I want to use a 'serial uniue' column in a table but there is
>> likely to be many, many inserts and deletes from this column. I was
>> wondering, what happens when the serial value reaches
>> 2,147,483,647'? Does it roll back over to '1' and keep going or
>> will the database start erroring out? This isn't likely to be a
>> problem any time soon, but over the course of a year or more it
>> might be.
>
>
> Use a "bigserial" instead?
>
> -Doug
>

Same issue, delaying a potential problem, not addressing it. :)

Madison

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-08-15 15:52:31 Re: Serial Unique question
Previous Message David Fetter 2005-08-15 15:45:18 Re: Postgresql Books: Which one ?