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