Re: bug in create table with serial - Mailing list pgsql-bugs

From Tom Lane
Subject Re: bug in create table with serial
Date
Msg-id 6037.1034826254@sss.pgh.pa.us
Whole thread Raw
In response to bug in create table with serial  (Cristóvão Dalla Costa <cbraga@bsi.com.br>)
Responses Re: bug in create table with serial  (Kris Jurka <books@ejurka.com>)
List pgsql-bugs
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


pgsql-bugs by date:

Previous
From: "ir. F.T.M. van Vugt bc."
Date:
Subject: Re: multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)
Next
From: Kris Jurka
Date:
Subject: Re: bug in create table with serial