On 21 Nov 2001, at 23:06, 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.
>

How should I know, I do know that some other databases do, but
those are closed source proprietory stuff, so who knows what they
do internally.....

Paul
Paul Schmidt
Tricat Technologies
paul@...
www.tricattechnologies.com