Postgres Pro
Downloads
Home   >   mailing lists

Re: SERIAL, too low a value - Mailing list pgsql-general

From Tom Lane
Subject Re: SERIAL, too low a value
Date
Msg-id 29625.999749439@sss.pgh.pa.us
Whole thread Raw
In response to SERIAL, too low a value  (Daniel Åkerud <zilch@home.se>)
List pgsql-general
Tree view 
=?iso-8859-1?Q?Daniel_=C5kerud?= <zilch@home.se> writes:
> I want to create a sequence with a higher value than an int4.
> Please explain how to do this, if possible.

There's no way in current releases.

> If not, this is certainly an issue that has to be targeted real soon, or?

Sequences are already reimplemented as int8-based for 7.2.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: index naming conventions
Next
From: will trillich
Date:
Subject: Re: !! Newbie question!!!! connecting to multiple databases