Skip site navigation (1) Skip section navigation (2)

Re: Row Lock

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: PostgreSQL <malcus(at)terra(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Row Lock
Date: 2007-11-22 19:12:37
Message-ID: dcc563d10711221112m62d64ae9s3804c6da6c26d03b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Nov 22, 2007 12:31 PM, PostgreSQL <malcus(at)terra(dot)com(dot)br> wrote:
> I'm having a problem with some row locks where one user does the lock
> and another user try to do the same, but of course, the second one will
> be waiting the first user unlock it.
>
> I would like to know if there is a way to discover if that row is locked
> before I try to do the lock.
>
> I have been researching something like ROWID but I couldn't find
> anything useful.

I believe you want the NOWAIT option on your select.

In response to

  • Row Lock at 2007-11-22 18:31:20 from PostgreSQL

pgsql-admin by date

Next:From: LEROUX LudovicDate: 2007-11-23 12:03:25
Subject: problem with drop database or dropdb.exe on windows with postgresql 8.1
Previous:From: PostgreSQLDate: 2007-11-22 18:31:20
Subject: Row Lock

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group