Re: Is this a commit problem? - Mailing list pgsql-hackers

From markw@osdl.org
Subject Re: Is this a commit problem?
Date
Msg-id 200309251844.h8PIiM132127@mail.osdl.org
Whole thread Raw
In response to Re: Is this a commit problem?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 25 Sep, Tom Lane wrote:
> markw@osdl.org writes:
>> I take it PQexec() should wait until the COMMIT finishes?
> 
> Yeah, it does.  Where is the next iteration of the transaction coming
> from?
> 
> Another thought occurred to me --- you said you have many parallel
> instances of this transaction, but they affect different rows because
> they have different keys.  Is it possible there's a logic bug that
> occasionally allows parallel transactions to be fired with the same key?

Yeah, that thought has crossed my mind.  I did catch an addition error
in my logic that contributed to additional rollbacks. ;)  But I did try
to be diligent and output everything that was going on in the
transaction to make sure there weren't any parallel transactions with
the same key.  I feel confident that the logic is correct.

Mark


pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: pgsql procedures??
Next
From: Tom Lane
Date:
Subject: Re: Question on adding new indexes to Postgresql