finding (and recycling) holes in sequences - Mailing list pgsql-sql

From Louis-David Mitterrand
Subject finding (and recycling) holes in sequences
Date
Msg-id 20000625095245.A8162@styx
Whole thread Raw
List pgsql-sql
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." 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: More full text index..
Next
From: "Oliver Elphick"
Date:
Subject: JOIN syntax