Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence
Дата
Msg-id 6157.1383849678@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #8582: field serial getted incorrect value from automaticaly created its sequence  (evgeniy.skomorokhov@gmail.com)
Ответы Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence
Список pgsql-bugs
Дерево обсуждения 
evgeniy.skomorokhov@gmail.com writes:
> Automaticaly created sequence takes values ​​from the range [1;
> 9223372036854775807] but max value of field which will be filled from
> sequence - max of type integer (2147483647).

If you want a bigint column, use "bigserial".  Not everybody wants
to take that space penalty, though.

            regards, tom lane

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

Предыдущее
От: Dan Scott
Дата:
Сообщение: Re: BUG #7844: xpath missing entity decoding - bug or feature
Следующее
От: John R Pierce
Дата:
Сообщение: Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence