Horton

Re: lock related issues...

Mike Mascari <mascarm@mascari.com>

View thread
From: Mike Mascari <mascarm@mascari.com>
To: Chris Bowlby <chris@pgsql.com>
Cc: simon@2ndquadrant.com, pgsql-hackers@postgresql.org
Date: 2004-01-29T03:27:05Z
Lists: pgsql-hackers 
Chris Bowlby wrote:

> Hi Simon,
>
>  Thanks for the confirmation, I just wanted to make sure I was not 
> going ape over it and getting confused.
>
> At 08:04 PM 1/28/04, Simon Riggs wrote:
>
>> >Chris Bowlby writes
>> >  I'm looking for some details on how the locking system works in
>> > relation to transactions dealing with INSERTs and UPDATEs. The version
>> > of PostgreSQL is 7.3.2
>>
>> p.152 of the 7.3.2 Users Guide, section 9.2.1 Read Committed Isolation
>> Level applies to your situation as described
>

A great description of concurrency issues is Tom Lane's O'Reilly 
presentation. After installing PostgreSQL, a message should be output to 
read it:

http://conferences.oreillynet.com/presentations/os2002/lane_tom.tar.gz

Mike Mascari