Re: bug in create table with serial

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Cristóvão Dalla Costa <cbraga(at)bsi(dot)com(dot)br>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: bug in create table with serial
Date: 2002-10-17 06:14:53
Message-ID: Pine.LNX.4.33.0210170214200.31940-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, 16 Oct 2002, Tom Lane wrote:

> =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <cbraga(at)bsi(dot)com(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message roco 2002-10-17 14:27:12 Fwd: [BUGS] Fwd: FATAL 1: Database dialup does not exist in pg_database
Previous Message Tom Lane 2002-10-17 03:44:14 Re: bug in create table with serial