Re: Getting Primary Key Value After Insert

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