Thread

Re: First decent PostgreSQL CBT now on techdocs

wsheldah@lexmark.com — 2001-12-28T18:36:26Z

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

Re: First decent PostgreSQL CBT now on techdocs .postgresql.org

Bruce Momjian <pgman@candle.pha.pa.us> — 2001-12-28T18:38:17Z

> 
> 
> 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