Thread: Serial datatype clarification

Pradeep,

>         I just wanted to clarify as to what is the maximum value of a
> SERIAL datatype. In the documentation it is given that with BIGSERIAL it is
> possible to generate 2pow(31) identifiers.

Nope, that would be regular SERIAL.  BIGSSERIAL is 2^62 or so.

> What is the maximum value of a
> SERIAL datatype, and what would happen if I insert a record after the
> maximum value is reached.

You'd get an error.   A SERIAL field is just an INT field; it's not going to
accept out-of-range values.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco