Subject | RE: [firebird-support] Generator |
---|---|
Author | Alan McDonald |
Post date | 2005-04-12T10:51:50Z |
> Hiyes
>
> 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 ?
>no - not on the generator
>
> 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
Alan