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
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 |