From: | wsheldah(at)lexmark(dot)com |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joe Conway <joseph(dot)conway(at)home(dot)com>, Justin Clift <justin(at)postgresql(dot)org>, PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: First decent PostgreSQL CBT now on techdocs |
Date: | 2001-12-28 18:36:26 |
Message-ID: | 200112281837.NAA05198@interlock2.lexmark.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)pha(dot)pa(dot)us(at)interlock(dot)lexmark(dot)com> on 12/28/2001
01:11:33 PM
To: Tom Lane <tgl%sss(dot)pgh(dot)pa(dot)us(at)interlock(dot)lexmark(dot)com>
cc: Joe Conway <joseph(dot)conway%home(dot)com(at)interlock(dot)lexmark(dot)com>, Justin Clift
<justin%postgresql(dot)org(at)interlock(dot)lexmark(dot)com>, PostgreSQL General Mailing
List <pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com> (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] First decent PostgreSQL CBT now on
techdocs.postgresql.org
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-12-28 18:38:17 | Re: First decent PostgreSQL CBT now on techdocs .postgresql.org |
Previous Message | Bruce Momjian | 2001-12-28 18:35:41 | Re: Problem (bug?) with like |