Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?)



Get your FREE download of MSN Explorer at


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group