> > > 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.
