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


---------------------------(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

Reply via email to