Sizes of sequences and serials (fwd)

From: Elein Mustain <elein(at)tulip(dot)norcov(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Sizes of sequences and serials (fwd)
Date: 2002-09-27 01:09:27
Message-ID: 200209270109.g8R19Rgj013849@tulip.norcov.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)norcov(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Unixprgrmr 2002-09-27 01:11:43 Fwd: ERRONIOUS .cpg parsing
Previous Message Stephan Szabo 2002-09-27 01:02:10 Re: SQL subquery to supply table name?