Thread: finding (and recycling) holes in sequences

finding (and recycling) holes in sequences

From
Louis-David Mitterrand
Date:
If one has a unique-id generating sequence that sometimes is bound to
have holes in it (ie: it could happen that a nextval(seq) happens
without a corresponding INSERT in the table), then how could one
efficiently scan for these holes to recycle them in subsequent INSERTs?

I'm just looking for a "standard" way of doing this if such a thing
exists.

TIA

-- 
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr

"For a list of the ways which technology has failed to improve our
quality of life, press 3."