Postgres Pro
Downloads
Home   >   mailing lists

Serial datatype clarification - Mailing list pgsql-novice

From Pradeepkumar, Pyatalo (IE10)
Subject Serial datatype clarification
Date
Msg-id 77ED2BF75D59D1439F90412CC5B109741192D08F@ie10-sahara.hiso.honeywell.com
Whole thread Raw
Responses Re: Serial datatype clarification
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Kumar S
Date:
Subject: can I define a hyperlink as a datatype
Next
From: Michael Glaesemann
Date:
Subject: Re: having problem connecting to postgreSQL v7.5.