Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence
Date
Msg-id 6157.1383849678@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8582: field serial getted incorrect value from automaticaly created its sequence  (evgeniy.skomorokhov@gmail.com)
Responses Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Dan Scott
Date:
Subject: Re: BUG #7844: xpath missing entity decoding - bug or feature
Next
From: John R Pierce
Date:
Subject: Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence