Forgive me for not digging through the source code myself, but can
anyone tell me if setQuerySnapshot behavior within functions was changed
in 7.3 so that subsequent select statements can see committed data?  I
know there was some talk about changing the behavior, but I'm wondering
if it was ever done. Read committed transactions seem broken without
this ability.

Robert Treat



04 Dec 2002 12:21:14 -0500
Robert Treat <xzilla@users.sourceforge.net>
setQuerySnapshot in plpgsql functions in 7.3
Robert Treat <xzilla@users.sourceforge.net> writes:
> Forgive me for not digging through the source code myself, but can
> anyone tell me if setQuerySnapshot behavior within functions was changed
> in 7.3 so that subsequent select statements can see committed data?

AFAIR, we had some preliminary discussions about that, but no decision
was taken about changing it.

			regards, tom lane

Wed, 04 Dec 2002 15:49:56 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: setQuerySnapshot in plpgsql functions in 7.3 