[GENERAL] Where are updates from inside transactions visible?

2008-10-21 Thread Rob Richardson
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

Re: [GENERAL] Where are updates from inside transactions visible?

2008-10-21 Thread Craig Ringer
Rob Richardson wrote: 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