Postgres Pro
Downloads
Home   >   mailing lists

serial data type limit - Mailing list pgsql-general

From Sherwin Daganato
Subject serial data type limit
Date
Msg-id fc.000f567200664a3d000f567200664a3d.664acf@fc.emc.com.ph
Whole thread Raw
List pgsql-general
Tree view 
Hi!

I'm new to Pg and I understand that serial data type is an int4 numeric
type.
What will happen to the serial data type if it has reach the limit of int4
(+2147483647)? Will it return zero?

Thanks in advance.

Numeric type | Storage  | Range
int4         | 4 bytes  | -2147483648 to +2147483647

pgsql-general by date:

Previous
From: sridhvenk@yahoo.com
Date:
Subject: Re: Probelm creating a table
Next
From: David Steuber
Date:
Subject: Re: Importing into Postgres from a csv file