Re: Usability or Data Bug in SERIAL column declarations - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Usability or Data Bug in SERIAL column declarations
Date
Msg-id 26280.1098923437@sss.pgh.pa.us
Whole thread Raw
In response to Usability or Data Bug in SERIAL column declarations  (elein <elein@varlena.com>)
Responses Re: Usability or Data Bug in SERIAL column declarations  (elein <elein@varlena.com>)
List pgsql-bugs
elein <elein@varlena.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

pgsql-bugs by date:

Previous
From: elein
Date:
Subject: Usability or Data Bug in SERIAL column declarations
Next
From: elein
Date:
Subject: Re: Usability or Data Bug in SERIAL column declarations