Re: SERIAL datatype - Mailing list pgsql-general

From Alban Hertroys
Subject Re: SERIAL datatype
Date
Msg-id A3D17CAA-E5B1-4812-B836-6ADDEB221FC6@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: SERIAL datatype  (Peter Billen <peter@clueless.be>)
List pgsql-general
On Aug 21, 2008, at 9:51 PM, Peter Billen 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?

DELETEs don't use your sequence so will not exhaust it. In practice
only INSERTs do. I saw you mention sequences in combination with
DELETEs a few times, just making sure you're not confused ;)

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,48b14c10243481755132881!



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: on delete cascade slowing down delete
Next
From: Stefan 'Kaishakunin' Schumacher
Date:
Subject: Re: Array, ANY and Regular Expressions