Re: When are updates from inside transactions visible?

Answering my own question: The change is not visible until the commit,
which is what I was expecting and hoping. I added a couple of buttons
to a dialog box in an application that connected to our database. In
the handler for one button, I began a transaction and updated a value.
In the handler for the other, I committed the transaction. After
clicking the first button, the old value appeared in PGAdmin. After
clicking the second, the new value appeared.

RobR

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Rob Richardson
Sent: Tuesday, October 21, 2008 9:58 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] When are updates from inside transactions visible?

Correction from my previous post. The first word in the title should
have been "when", not "where".

RobR

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To
make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general