Den 2011-06-15 12:51 skrev Milan Tomeš - Position såhär:

> It's not a bug, it's a feature. Generators aren't under a transaction
> control. So when you get new value from generator it's reserved and is
> not rolled back when you rollback the transaction.

But Lester said this was a transaction inside which the generators
(several) were CREATED. I assume generator CREATION is under transaction
control. Or isn't it?

Regardless of the answer to that question, the behavior should be
identical for all generators.

A suspicion: maybe the generators that were not rolled back (removed on
rollback) were perhaps the only ones that had also been incremented/used
inside the creating transaction?

That would make some kind of sense - generators that are ONLY created
are rolled back, but as soon as you've generated a value with it, it
falls under the "not under transaction control" category, and is left in
existende upon rollback.

But I'm only speculating here...

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64