I have several tables with serial and bigserial field types. I ran pgAdmin
III and checked the sequences values and I see that all of them have the
same maximum; serial and bigserial maximum value is 9223372036854775807.
Why do serial and bigserial fields take the same maximum values?
Isn't it supposed that serial maximum value should be 2147483647?
pgsql-novice by date
|Next:||From: Mladen Gogala||Date: 2010-02-28 00:07:36|
|Subject: Browsing through the Postgres source|
|Previous:||From: Tom Lane||Date: 2010-02-26 18:02:17|
|Subject: Re: Special table names |