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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Rob Richardson
Sent: Tuesday, October 21, 2008 9:58 AM
To: pgsql-general@postgresql.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@postgresql.org) To
make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general