Re: bug in create table with serial

On Wed, 16 Oct 2002, Tom Lane wrote:

> Cristóvão Dalla Costa <cbraga@bsi.com.br> writes:
> > In PostgreSQL 7.3b2, if I create a table like so:
> > create table customers (id serial primary key);
>
> > The id field will be created of type 32 bit integer, yet the upper limit
> > for the sequence will be relative to a 64 bit integer.
>
> So?
>
> AFAICS, you will get a failure when you reach 2^31 items.  Whether the
> failure is "can't fit the value into int4" or "reached sequence maximum"
> doesn't seem very exciting to me ...
>

Unless of course the column's data type was int8.

Kris Jurka