The mystery of concurrent access

From: "P(dot)V(dot) Subramanian" <pvsmian(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: The mystery of concurrent access
Date: 2001-10-05 18:56:10
Message-ID: F249BGTuAyHsjCGvseE00012728@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message P.V. Subramanian 2001-10-05 18:59:13 Why has the trigger been launched
Previous Message P.V. Subramanian 2001-10-05 18:52:25 How to find out that a record has been updated