How can I know if a row is Locked?

Поиск
Список
Период
Сортировка
От Carlos Santos
Тема How can I know if a row is Locked?
Дата
Msg-id 651844.97452.qm@web57110.mail.re3.yahoo.com
обсуждение исходный текст
Ответы Re: How can I know if a row is Locked?
Список pgsql-sql
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í - MG
www.compels.net


__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/

В списке pgsql-sql по дате отправления:

Предыдущее
От: Dmitry Turin
Дата:
Сообщение: We all are looped on Internet: request + transport = invariant
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: How can I know if a row is Locked?