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

From Bruce Momjian
Subject Re: First decent PostgreSQL CBT now on techdocs.postgresql.org
Date
Msg-id 200112281811.fBSIBXe27166@candle.pha.pa.us
Whole thread Raw
In response to Re: First decent PostgreSQL CBT now on techdocs.postgresql.org  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: First decent PostgreSQL CBT now on techdocs.postgresql.org
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

pgsql-general by date:

Previous
From: "Jeffrey W. Baker"
Date:
Subject: postgres processes spending most of their time in the kernel
Next
From: Bruce Momjian
Date:
Subject: Re: First decent PostgreSQL CBT now on techdocs.postgresql.org