SERIAL FIELD SEQUENCE MAXIMUM VALUE

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SERIAL FIELD SEQUENCE MAXIMUM VALUE
Date: 2010-02-27 23:43:00
Message-ID: f03943a01002271543m69773f71oa713957e151f3c59@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Respectfully,
Jorge Maldonado

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mladen Gogala 2010-02-28 00:07:36 Browsing through the Postgres source
Previous Message Tom Lane 2010-02-26 18:02:17 Re: Special table names