> > > 3. If you call currval() will it return 20? I would think it does.
>
> Yes it does.
>
> > My understanding is that it will provided your are within a transaction.
>
> As long as you're in the same session you're fine. You would have to go out of
> your way to break it but if you're using some sort of connection pooling you
> wouldn't want to pull a fresh connection from the pool, for example.
Just to clarify, currval() is isolated by the session on not necessarily by a transaction?
Regards,
Richard Broersma Jr.