Re: First decent PostgreSQL CBT now on techdocs.postgresql.org - Mailing list pgsql-general

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