Re: [GENERAL] using ID as a key

Поиск
Список
Период
Сортировка
От
Тема Re: [GENERAL] using ID as a key
Дата
Msg-id Pine.LNX.4.10.10002071127300.12245-100000@picasso.realtyideas.com
обсуждение исходный текст
Ответ на Re: [GENERAL] using ID as a key  (Ed Loehr <eloehr@austin.rr.com>)
Список pgsql-general

On Mon, 7 Feb 2000, Ed Loehr wrote:

> These are resolvable problems.  One way to do a programmatic ID
> generation as David B. suggests is to have a DB server whose purpose
> is to issue "seed numbers" which designate, through use of a
> pre-determined multiplier, a *range* of allocated IDs guaranteed to be
> unique across all seed requesters.  This avoids both of the problems
> raised above (throughput and synchronization).
  .....
> not time-ordered.  A few more details must be handled, and there is
> some maintainance overhead, but it seems to work fairly well.

sounds familiar -- the seed server can be pg, and other servers can be
user-program, and pg's sequence can do this already.
and, it seems not "programmatically at all.




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

Предыдущее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: [GENERAL] using ID as a key
Следующее
От: "Keith G. Murphy"
Дата:
Сообщение: Re: [GENERAL] using ID as a key