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 Ludovic||Date: 2007-11-23 12:03:25|
|Subject: problem with drop database or dropdb.exe on windows with postgresql 8.1|
|Previous:||From: PostgreSQL||Date: 2007-11-22 18:31:20|
|Subject: Row Lock|