Re: Serial Unique question

Madison Kelly <linux(at)alteeve(dot)com> writes:

> 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. :)

Do the math. :)

-Doug