Re: Auto incrementing primary keys

On Feb 18, 2008 12:16 PM, Steve Atkins <steve(at)blighty(dot)com> wrote:
>
> On Feb 18, 2008, at 9:56 AM, Raymond O'Donnell wrote:
>
> > On 18/02/2008 17:46, Raymond O'Donnell wrote:
> >
> >> Well, that depends on your usage, so only you can answer that.
> >> According to the docs, "serial" creates an integer column, which
> >> will give you 2147483647 values - how quickly will you use that lot
> >> up? If you think you will run out, by all means use bigserial.
> >
> > Actually, that isn't quite right - just looked at the docs for
> > CREATE SEQUENCE, and the default maximum value is 2^63-1.
>
> That's the maximum value for the sequence itself, but a "serial" is
> just an integer, so the 2^31-1 limit before wraparound still applies.

Look up bigserial