Fwd: Sizes of sequences and serials - Mailing list pgsql-general

From elein
Subject Fwd: Sizes of sequences and serials
Date
Msg-id 200209270123.g8R1N9Bd068848@pimout1-ext.prodigy.net
Whole thread Raw
Responses Re: Fwd: Sizes of sequences and serials  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm sorry if this gets posted more than once. My ISP smtp servers
have gone whacky on me.

elein

----------  Forwarded Message  ----------

Subject: Sizes of sequences and serials
Date: Thu, 26 Sep 2002 16:44:45 -0700
From: elein  <elein@sbcglobal.net>
To: pgsql-general@postgresql.org
Cc: elein <elein@norcov.com>

According to the documentation, it looks like sequences
are always stored as bigints (if the platform supports them).

Serials, though, seem to be able to be declared as serial
with integer storage or serial8 for bigint storage.

Is the storage for ordinary serials really an int and not
a big int?  Is there a way to create a sequence stored
as an int instead of a big int?  For example by setting
the maximun size?

thanks,
elein@norcov.com

-------------------------------------------------------

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: SQL subquery to supply table name?
Next
From: Joe Conway
Date:
Subject: Re: SQL subquery to supply table name?