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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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