| 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: | Whole Thread | Raw Message | 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 |