Subject Generator
Author Michael Vilhelmsen
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 ?


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