> 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.....

The only way I can imagine that does not mess/delay concurrent
transactions is to fill those fields and all other fields and
variables that reference them with some kind of reference that
is resolved at commit time.

Big mess!


Have fun,
Paulo Gaspar

> -----Original Message-----
> From: Paul Schmidt [mailto:paul@...]
> Sent: Thursday, November 22, 2001 3:50 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Idea for a new field type for FB 2,0 or IB 7?
>
>
> 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
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>