Re: SERIAL datatype - Mailing list pgsql-general

From Scott Marlowe
Subject Re: SERIAL datatype
Date
Msg-id dcc563d10808211255r1d3b204as1db6b46caad98204@mail.gmail.com
Whole thread Raw
In response to Re: SERIAL datatype  (Peter Billen <peter@clueless.be>)
List pgsql-general
On Thu, Aug 21, 2008 at 1:51 PM, Peter Billen <peter@clueless.be> wrote:
> My concern is not that the table will become full, but that the sequence
> will be exhausted. Doing INSERT, DELETE, INSERT, DELETE ... will exhaust the
> sequence. What will happen then? Do I have to manually re-order my serial
> values and reset the start sequence ID to MAX() + 1?

See my other reply.  short answer:  use bigserial

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: SERIAL datatype
Next
From: Peter Billen
Date:
Subject: Re: SERIAL datatype