P.V.,
> 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?)
Please read:
http://www.postgresql.org/idocs/index.php?mvcc.html
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco