Alexander V.Nevsky wrote:

> Doug, you surprize me. Generators are multy-users safe namely
> because they are outside transaction control. Look (your approach)
>
> App 1 starts
> App 1 re-set generators - OK, it is lonely
> App 1 makes insert and move generator but don't commit yet
> App 2 starts
> App 2 select max which is less than generator value because insert
> is'nt commited

For his app. that is ok.

> App 2 set generator backwards

Not really. His app. only changes generators when gen < max(pk), and
here we have the opposite.

However, look at the scenario from my other message, I think it fits.

> And about client-side or server-side PK columns filling - guys,
> what about feature request #840210 in FB RFE tracker? ;)))

I like the timestamp: 2003-11-11 11:42 ;)

--
Milan Babuskov
http://fbexport.sourceforge.net