Postgres Pro
Downloads
Home   >   mailing lists

serial data type limit - Mailing list pgsql-novice

From Sherwin Daganato
Subject serial data type limit
Date
Msg-id fc.000f56720067054d000f567200664a3d.67054f@fc.emc.com.ph
Whole thread Raw
List pgsql-novice
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-novice by date:

Previous
From: Mathias Göthberg
Date:
Subject: How to make the key in table increase automatically?
Next
From: "Robert B. Easter"
Date:
Subject: Re: Simple question