Where are updates from inside transactions visible?

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Where are updates from inside transactions visible?
Date: 2008-10-21 13:51:12
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03DAFA23D@server.rad-con.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings again!

Suppose I have a table named "myTable" with fields named "item" and
"value". Item X has a value of 1. Inside a C++ application, I begin a
transaction, open the table, change Item X's value to 2, and go to
sleep. The transaction is still active. In PGAdmin, I open an SQL
window and execute "select * from myTable". What value do I see for
item X? Will it still be 1 because the transaction in which it was
changed to 2 is still open?

Thanks again!

RobR

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Metcalf 2008-10-21 13:54:30 Re: syncing with a MySQL DB
Previous Message Merlin Moncure 2008-10-21 13:40:35 Re: syncing with a MySQL DB