Re: Is this a commit problem?

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