Postgres Pro
Downloads
Home   >   mailing lists

The mystery of concurrent access - Mailing list pgsql-novice

From P.V. Subramanian
Subject The mystery of concurrent access
Date
Msg-id F249BGTuAyHsjCGvseE00012728@hotmail.com
Whole thread Raw
Responses Re: The mystery of concurrent access  ("Josh Berkus" <josh@agliodbs.com>)
Re: The mystery of concurrent access  (Jason Earl <jdearl@yahoo.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "P.V. Subramanian"
Date:
Subject: How to find out that a record has been updated
Next
From: "P.V. Subramanian"
Date:
Subject: Why has the trigger been launched