Skip site navigation (1) Skip section navigation (2)

Serial datatype clarification

From: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Serial datatype clarification
Date: 2004-09-14 04:36:46
Message-ID: 77ED2BF75D59D1439F90412CC5B109741192D08F@ie10-sahara.hiso.honeywell.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,
        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. What is the maximum value of a
SERIAL datatype, and what would happen if I insert a record after the
maximum value is reached.
 
With Best Regards
Pradeep Kumar P J 


Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2004-09-14 05:13:19
Subject: Re: having problem connecting to postgreSQL v7.5.
Previous:From: Kumar SDate: 2004-09-14 04:30:17
Subject: can I define a hyperlink as a datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group