Postgres Pro
Downloads
Home   >   mailing lists

Thread: SERIAL, too low a value

SERIAL, too low a value

From
Daniel Åkerud
Date:
 
I want to create a sequence with a higher value than an int4.
Please explain how to do this, if possible.
If not, this is certainly an issue that has to be targeted real soon, or?
 
---
Daniel Åkerud
 
[ Don't underestimate the power of stupid people in large groups]

Re: SERIAL, too low a value

From
Tom Lane
Date:
=?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

Re: SERIAL, too low a value

From
Daniel Åkerud
Date:
Thanks plenty!

> =?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
>