Re: Usability or Data Bug in SERIAL column declarations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Usability or Data Bug in SERIAL column declarations
Дата
Msg-id 26280.1098923437@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Usability or Data Bug in SERIAL column declarations  (elein <elein@varlena.com>)
Ответы Re: Usability or Data Bug in SERIAL column declarations  (elein <elein@varlena.com>)
Список pgsql-bugs
elein <elein@varlena.com> writes:
> In both cases sequences are created as int8 values with
> a maximum of 9223372036854775807.

> BUG: The assignment of the table containing the int4 column
> will overflow at 2147483648 (max integer size).

I don't think this is really a problem.

You are going to have errors when you run out of int4-sized identifiers
in either case.  If we reduce the sequence's maximum, that just means
one more thing you'll have to fix in order to recover.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: elein
Дата:
Сообщение: Usability or Data Bug in SERIAL column declarations
Следующее
От: elein
Дата:
Сообщение: Re: Usability or Data Bug in SERIAL column declarations