The mystery of concurrent access - Mailing list pgsql-novice

Hi all

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?)

Thanks

PVS

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp