Search Postgresql Archives

Where are updates from inside transactions visible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux