Subject Re: generator ids in uncommitted transactions
Author Adam
--- In, "kapsee" <kapil.surlaker@g...>
> Is there any way to find out if there are any uncommitted transactions
> that have called gen_id on a generator ?


> Or if I get an id using the gen_id call, can I somehow wait till all
> current transactions either commit or abort ?

You don't need to.

Generator calls are transaction independent. Even if the uncommitted
transactions are rolled back, it does not hurt anything.

Generators are bigints (64 bit integers). That is huge. You will not
run out of them any time soon.