Problem with row-level lock

From: Job <Job(at)colliniconsulting(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Problem with row-level lock
Date: 2019-06-19 16:06:09
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A082D27F19C06@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys,

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

Since the client application cannot be control, i need to manage - in order to avoid this situation - the lock of a record due to two updates at the same time.
Is there way to force serializing, i don't know how, the updates on the same row in order to avoid this locks?

Thank you, cheers!

FC

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Bates 2019-06-19 19:31:56 First Time Starting Up PostgreSQL and Having Problems
Previous Message Tom Lane 2019-06-19 14:39:24 Re: psql UPDATE field [tab] expands to DEFAULT?