> 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.
Aglio Database Solutions
In response to
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2004-09-14 23:18:18|
|Subject: Re: can I define a hyperlink as a datatype|
|Previous:||From: Stephan Szabo||Date: 2004-09-14 21:55:25|
|Subject: Re: Create table error|