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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
        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 


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-2017 The PostgreSQL Global Development Group