Re: sequences w/o holes

On Dec 19, 2005, at 20:14 , Marian Naghen wrote:

> Can anyones suggest some readings about implementing
> sequences w/o holes ?

Check the mailing list archives. In short, if you want to guarantee
no holes, you don't use sequences. IIRC, the process is:
1. Set up another table (foo) that holds the current value.
2. To grab a new value, increment the current value in foo and use
the current value in your insert within a transaction.

If you delete rows from your table, you'll need to do some updating
if you want to maintain having no holes.

Michael Glaesemann
grzm myrealbox com