Re: [HACKERS] lock related issues...

2004-01-28 Thread Mike Mascari
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 de

Re: [HACKERS] lock related issues...

2004-01-28 Thread Chris Bowlby
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

Re: [HACKERS] lock related issues...

2004-01-28 Thread Simon Riggs
>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 descr

[HACKERS] lock related issues...

2004-01-28 Thread Chris Bowlby
Hi All, 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 and the connections to the database are going through a JDBC driver. The details of what we are running into are as follows: A p