serial data type limit

From: "Sherwin Daganato" <win(at)email(dot)com(dot)ph>
To: pgsql-general(at)postgresql(dot)org
Subject: serial data type limit
Date: 2000-08-24 03:40:57
Message-ID: fc.000f567200664a3d000f567200664a3d.664acf@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-08-24 03:43:45 Re: Count & Distinct
Previous Message richard excite 2000-08-24 02:10:48 2-phase commit