Re: Problem with row-level lock

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Job <Job(at)colliniconsulting(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with row-level lock
Date: 2019-06-20 14:49:20
Message-ID: c970db21-1ab7-13b5-0290-0a36aca7119f@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/19/19 9:06 AM, Job wrote:
> Hi guys,
>
> 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?

>
> 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
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-06-20 14:55:35 Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems
Previous Message Brent Bates 2019-06-20 14:43:04 RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems