At 11/21/2001 10:05 PM (Wednesday), Robert F. Tulloch wrote:

>lester@... wrote:
> > > As for a true series type Auto incrementing field, that would be
> > > nice, but should probably be implemented as a serial generator,
> > > that is a generator that guarantees there are no holes in the series,
> > > we could then use a similar mechanism.
> >
> > But that is simply not practical - some transactions in the
> > real work will be rolled back - how do you fill the hole,
> > since it will now be out of sequence.
>
> You just do all this with SP's and your own code.

Yuck!

Around here I sometimes use the term "technically insane" to label ideas
which just don't make practical, economic, or architectural sense from a
technical or systems point of view. (It is similar to "legally insane" and
is not really similar to "psychologically insane".)

Trying to maintain an unbroken sequence of generated values is as good an
example of technically insane as I have ever seen!