Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence - Mailing list pgsql-bugs

On 11/7/2013 10:41 AM, Tom Lane wrote:
> 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.


I think he's suggesting that a sequence generated from a regular serial
probably shouldn't have that 63 bit max_value



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast