Re: bug in create table with serial

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 ...
        regards, tom lane