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!
