Search Postgresql Archives

R: Problem with row-level lock

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 same row - arriving concurrently?

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

Thank you!
Franco





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux