| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Serial datatype clarification |
| Date: | 2004-09-14 23:07:16 |
| Message-ID: | 200409141607.17010.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-09-14 23:18:18 | Re: can I define a hyperlink as a datatype |
| Previous Message | Stephan Szabo | 2004-09-14 21:55:25 | Re: Create table error |