Re: Serial Unique question

Поиск
Список
Период
Сортировка
От Madison Kelly
Тема Re: Serial Unique question
Дата
Msg-id 4300B930.8080401@alteeve.com
обсуждение исходный текст
Ответ на Re: Serial Unique question  (Douglas McNaught <doug@mcnaught.org>)
Ответы Re: Serial Unique question  (Douglas McNaught <doug@mcnaught.org>)
Re: Serial Unique question  (Sven Willenberger <sven@dmv.com>)
Список 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 по дате отправления:

Предыдущее
От: Douglas McNaught
Дата:
Сообщение: Re: Serial Unique question
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Serial Unique question