Re: Serial Unique question

Douglas McNaught wrote:
> Madison Kelly <linux@alteeve.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