Re: SERIAL datatype

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Peter Billen" <peter(at)clueless(dot)be>
Cc: "ries van Twisk" <pg(at)rvt(dot)dds(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: SERIAL datatype
Date: 2008-08-21 19:55:02
Message-ID: dcc563d10808211255r1d3b204as1db6b46caad98204@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 21, 2008 at 1:51 PM, Peter Billen <peter(at)clueless(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Billen 2008-08-21 20:09:50 Re: SERIAL datatype
Previous Message Scott Marlowe 2008-08-21 19:53:02 Re: SERIAL datatype