Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group