Postgres Pro
Downloads
Home   >   mailing lists

SERIAL FIELD SEQUENCE MAXIMUM VALUE - Mailing list pgsql-novice

From JORGE MALDONADO
Subject SERIAL FIELD SEQUENCE MAXIMUM VALUE
Date
Msg-id f03943a01002271543m69773f71oa713957e151f3c59@mail.gmail.com
Whole thread Raw
Responses Re: SERIAL FIELD SEQUENCE MAXIMUM VALUE
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Special table names
Next
From: Eric McKeeth
Date:
Subject: Re: SERIAL FIELD SEQUENCE MAXIMUM VALUE