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(at)apartia(dot)org - http://www.apartia.fr
"For a list of the ways which technology has failed to improve our
quality of life, press 3."