serial data type limit

From: "Sherwin Daganato" <win(at)email(dot)com(dot)ph>
To: pgsql-novice(at)postgresql(dot)org
Subject: serial data type limit
Date: 2000-08-26 07:44:01
Message-ID: fc.000f56720067054d000f567200664a3d.67054f@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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-novice by date

  From Date Subject
Next Message Ben Lanson 2000-08-26 09:08:28 Failure to COMMIT -- Timeout?
Previous Message Dan Manczak 2000-08-26 01:05:34 Re: Postgres on NT