I thought enough experimentation would reveal this mystery, but its very
confusing, so I'll ask.
When 2 processes/people are simultaneously working on a table
* does Postgres automatically enforce some sort of locking?
* do the changes made by process A become visible to process B immediately
(of course, the result of a SELECT wouldn't change dynamically, but suppose
process B did another SELECT, would it access process A's records?)
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
pgsql-novice by date
|Next:||From: P.V. Subramanian||Date: 2001-10-05 18:59:13|
|Subject: Why has the trigger been launched|
|Previous:||From: P.V. Subramanian||Date: 2001-10-05 18:52:25|
|Subject: How to find out that a record has been updated|