Serial and BigSerial maxvalues

JORGEMAL · #1 (**permalink**) 09-28-11, 18:06

When I define a serial or bigserial field type, a sequence is created. In any case, the maxvalue equals 9223372036854775807 which corresponds to a bigint value. Why?

Respectfully,
Jorge Maldonado

shammat · #2 (**permalink**) 09-28-11, 18:16

Probably because sequences are based on bigint, so there is no way to create a sequence that returns integers.

Quote:

Originally Posted by Postgres manual

Sequences are based on bigint arithmetic, so the range cannot exceed the range of an eight-byte integer

Taken from: http://www.postgresql.org/docs/curre...esequence.html

If you are concerned about this, then use a bigserial type.

Internet Services

Web Development

Digital Marketing

Consumer Tech