Subject Re: generator ids in uncommitted transactions
Author kapsee
I am using this to keep track of changes so that they can be cached
for example in an application. To do this, it's easy to select all the
rows that have the id greater than the id I saw last time.
Therefore I need to know if any transaction with a lower id might now
commit in the future.


--- In, "Alan McDonald" <alan@m...>
> >
> > Is there any way to find out if there are any uncommitted
> > that have called gen_id on a generator ?
> > Or if I get an id using the gen_id call, can I somehow wait till
> > current transactions either commit or abort ?
> >
> > Thanks!
> >
> uh oh... what are you trying to do... sounds fishy
> Alan