> When a GEN_ID() is invoked within a transaction
> and that transaction is subsequently rollbacked,
> does that mean that the id generated within that
> transaction will not be 'rollbacked'

This is correct. The nature of generators is, that they
are running *outside* of transaction control. So, if the
transaction is rollbacked, the generator value isn't
decremented automatically.

I think here is all you should know about generators.
http://www.fingerbird.de/generatorguide.htm


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com