Re: Increment a sequence by more than one

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Increment a sequence by more than one
Дата
Msg-id 6137A8C5-187D-46E8-B9C2-822D05C5DFC2@seespotcode.net
обсуждение исходный текст
Ответ на Re: Increment a sequence by more than one  (Erik Jones <erik@myemma.com>)
Ответы Re: Increment a sequence by more than one  ("Peter Childs" <peterachilds@gmail.com>)
Список pgsql-sql
On Aug 3, 2007, at 15:27 , Erik Jones wrote:

> Is there actually a requirement that the block of 5000 values not  
> have gaps?

Good point.

> If not, why not make the versioned table's id column default to  
> nextval from the same sequence?

Of course, the ids of the two tables could be interleaved in this  
case. This might not be an issue, of course.


Michael Glaesemann
grzm seespotcode net




В списке pgsql-sql по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Increment a sequence by more than one
Следующее
От: Steve Midgley
Дата:
Сообщение: Race condition in resetting a sequence