Re: Update / Lock (and ShareLock) question

From: Augustin Amann <augustin(at)waw(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Update / Lock (and ShareLock) question
Date: 2008-07-11 16:32:50
Message-ID: 48778B32.3020404@waw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane a écrit :
> Augustin Amann <augustin(at)waw(dot)com> writes:
>
>> Tom Lane a écrit :
>>
>>> What that really means is that the first process is waiting for a row
>>> lock that's held by the second one --- that is, it's trying to update a
>>> row that the second transaction has updated and not yet committed.
>>>
>
>
>> I understand. But a dead lock is for me, a situation that sould not
>> appear, event if the storage is slow ... I'm wrong ?
>>
>
> If you're getting deadlocks on these, then what you have is two
> concurrent transactions trying to update the same two tuples in
> different orders. Which is a classic deadlock case, and the only
> fix is to fix your app so that multiple updates are done in some
> consistent order --- or broken into multiple transactions.
>
>
Yes, I understand, but my problem is that no transaction are involved in
our case, just one update same statement ...
I'll look for an hidden transaction (ask the dev, pgpool) :/ ...
Thank you for your confirming that.

Regards,
Augustin.
> regards, tom lane
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-07-11 17:27:51 Re: Default fill factor for tables?
Previous Message Tom Lane 2008-07-11 15:41:20 Re: Default fill factor for tables?