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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: evgeniy(dot)skomorokhov(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence
Date: 2013-11-07 18:41:18
Message-ID: 6157.1383849678@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

evgeniy(dot)skomorokhov(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2013-11-07 18:55:51 Re: BUG #8582: field serial getted incorrect value from automaticaly created its sequence
Previous Message Dan Scott 2013-11-07 18:14:38 Re: BUG #7844: xpath missing entity decoding - bug or feature