Postgres Pro
Downloads
Home   >   mailing lists

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

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

            regards, tom lane

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