Re: Usability or Data Bug in SERIAL column declarations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: elein <elein(at)varlena(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Usability or Data Bug in SERIAL column declarations
Date: 2004-10-28 00:30:37
Message-ID: 26280.1098923437@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

elein <elein(at)varlena(dot)com> writes:
> In both cases sequences are created as int8 values with
> a maximum of 9223372036854775807.

> BUG: The assignment of the table containing the int4 column
> will overflow at 2147483648 (max integer size).

I don't think this is really a problem.

You are going to have errors when you run out of int4-sized identifiers
in either case. If we reduce the sequence's maximum, that just means
one more thing you'll have to fix in order to recover.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Anthony 2004-10-28 00:41:36 SSL password problem in PG-WIN32
Previous Message elein 2004-10-28 00:21:53 Usability or Data Bug in SERIAL column declarations