Re: Serial Unique question - Mailing list pgsql-general

From Madison Kelly
Subject Re: Serial Unique question
Date
Msg-id 4300B930.8080401@alteeve.com
Whole thread Raw
In response to Re: Serial Unique question  (Douglas McNaught <doug@mcnaught.org>)
Responses Re: Serial Unique question
Re: Serial Unique question
List pgsql-general
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

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Serial Unique question
Next
From: Michael Fuhr
Date:
Subject: Re: Serial Unique question