Madison Kelly <linux@xxxxxxxxxxx> writes:
> Douglas McNaught wrote:
>> Madison Kelly <linux@xxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
