Re: First decent PostgreSQL CBT now on techdocs
Looks like someone could take advantage of the broader range of sequence values,
but only if they explicitly created their column as int8 with the default set to
nextval('the_sequence').
Should the serial datatype be changed to create an int8, or a new serial8
datatype created that does this??
--Wes Sheldahl
Bruce Momjian <pgman%candle.pha.pa.us@interlock.lexmark.com> on 12/28/2001
01:11:33 PM
To: Tom Lane <tgl%sss.pgh.pa.us@interlock.lexmark.com>
cc: Joe Conway <joseph.conway%home.com@interlock.lexmark.com>, Justin Clift
<justin%postgresql.org@interlock.lexmark.com>, PostgreSQL General Mailing
List <pgsql-general%postgresql.org@interlock.lexmark.com> (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] First decent PostgreSQL CBT now on
techdocs.postgresql.org
Bruce Momjian <pgman@candle.pha.pa.us> writes:
I do have a question about that. If I do this:
test=> create table test (x serial);
My column is an integer.So it is. When the sequence reaches 2147483648 you'll start getting
ERROR: int8 conversion to int4 is out of range
Uh, so what is the advantage of using int8 sequences internally? Just
the error message?
--
Bruce Momjian | http://candle.pha.pa.us
Looks like someone could take advantage of the broader range of sequence values,
but only if they explicitly created their column as int8 with the default set to
nextval('the_sequence').Should the serial datatype be changed to create an int8, or a new serial8
datatype created that does this??
Tom says we have a new SERIAL8 data type for this. I see it in the
HISTORY file now.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026