On Nov 22, 2007 12:31 PM, PostgreSQL <malcus@xxxxxxxxxxxx> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
