serial data type

From: "Omid Mahboubi" <omid(at)oztell(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: serial data type
Date: 2002-12-11 01:45:08
Message-ID: 1035.203.27.92.188.1039571108.ozinbox@ozinbox.oztralia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

When creating a field of type SERIAL, the default values for the
sequence created are max_value=9223372036854775807 and min_value=1
but the field type created in the table will be int4(-2147483648 to
+2147483647).

I was wondering if this would cause any problems since only positive
numbers upto 2147483647 would be used in the int4 field, but the
sequence keeps on auto-incrementing to values above that limit.

Are there any advantages if I implicitly set max_value=2147483647?

I would appreciate any help regarding this issue.

Thanks in advance,
Omid

Browse pgsql-general by date

  From Date Subject
Next Message Doug Fields 2002-12-11 02:03:49 Urgent need of (paid) PostgreSQL support in New York City area
Previous Message Greg Copeland 2002-12-11 01:15:54 Re: [mail] Re: 7.4 Wishlist