R: Problem with row-level lock - Mailing list pgsql-general

From Job
Subject R: Problem with row-level lock
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A082D27F19C07@W2008DC01.ColliniConsulting.lan
Whole thread Raw
In response to Re: Problem with row-level lock  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: R: Problem with row-level lock
List pgsql-general
Dear Adrian,

thank you for the reply!

>> i am struggling with a problem due, sometime, to a double concurrent update on the same row of a table.

>What is the error message you get?

We have no error, but the two queries, in "Lock wait", keep stucked for some minutes before completed.
Are there any parameters useful to "serialize" in some way two different Update queries - for the same field in the
samerow - arriving concurrently? 

I was looking at the lock_timeout parameter: could it be what i am looking for?

Thank you!
Franco


pgsql-general by date:

Previous
From: AYahorau@ibagroup.eu
Date:
Subject: Active connections are terminated because of small wal_sender_timeout
Next
From: Karsten Hilbert
Date:
Subject: Re: Row data is reflected in DETAIL message when constraints fail oninsert/update