On Wed, 16 Oct 2002, Tom Lane wrote:
> =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
