On 25 Sep, Tom Lane wrote: > [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
