Subject RE: [firebird-support] Generator
Author Alan McDonald
> Hi
>
> A Generator is (as I recall) not part of a transaction.
> That means, that if I have a trigger BEFORE INSERT that calls a
> generator to return a number to a field in my table, and I latter in
> the program do a rollback, then the generator is still updated by 1,
> right ?

yes

>
>
> If so - Can I get a Deadlock on this generator, if two machines try to
> insert a record in the same table at the same time (A deadlock on a no
> wait transaction) ?
>
> Regards
> Michael

no - not on the generator
Alan