On Thu, Aug 21, 2008 at 1:51 PM, Peter Billen <peter@xxxxxxxxxxx> 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