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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
