finding (and recycling) holes in sequences

Поиск
Список
Период
Сортировка
От Louis-David Mitterrand
Тема finding (and recycling) holes in sequences
Дата
Msg-id 20000625095245.A8162@styx
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: More full text index..
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: JOIN syntax