Re: [GENERAL] using ID as a key

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.