Where are updates from inside transactions visible?

Поиск
Список
Период
Сортировка
От Rob Richardson
Тема Where are updates from inside transactions visible?
Дата
Msg-id 04A6DB42D2BA534FAC77B90562A6A03DAFA23D@server.rad-con.local
обсуждение исходный текст
Ответ на Re: syncing with a MySQL DB  ("Merlin Moncure" <mmoncure@gmail.com>)
Ответы When are updates from inside transactions visible?  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
Re: Where are updates from inside transactions visible?  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: syncing with a MySQL DB
Следующее
От: "Brandon Metcalf"
Дата:
Сообщение: Re: syncing with a MySQL DB