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

Row Lock

From: PostgreSQL <malcus(at)terra(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Row Lock
Date: 2007-11-22 18:31:20
Message-ID: fi4hto$p6j$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-admin
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.

Thank's


Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2007-11-22 19:12:37
Subject: Re: Row Lock
Previous:From: Andrew SullivanDate: 2007-11-22 14:49:43
Subject: Re: [GENERAL] backup of postgres scheduled with cron

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