How can I know if a row is locked by another transaction.
I have in a transaction like that:
BEGIN;SELECT * FROM compels.teste WHERE id = '1' FOR UPDATE;PS1: where id is the primary key.PS2: The COMMIT command is done after a long time.In this case the row with the primary-key equals to '1' will be locked to other transactions until the COMMIT command be executed.
So, how can I detect if this row is locked?
Tks
Carlos Henrique Iazzetti Santos Compels Informática Santa Rita do Sapucaí - MGwww.compels.net
__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/