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
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 |