Re: BUG #14049: Integer out of range on insert with default id

d(dot)j(dot)yotta(at)gmail(dot)com writes:
> Not sure if this is a bug, but it seems strange to me that the SERIAL
> numeric type is 4 bytes, yet the default backing sequence for which
> nextval() is called is 8 bytes.
> http://www.postgresql.org/docs/9.5/static/datatype-numeric.html

> I'm seeing 'integer out of range' upon inserting into a table where all of
> the parameters look fine. The id parameter is not specified and hence will
> be generated automatically by the sequence, causing the insert to fail if
> the generated id is bigger than maximum int value.

Well, once you've run out of 4-byte integers, that's going to fail one way
or another.

regards, tom lane