How can I know if a row is Locked? - Mailing list pgsql-sql

From Carlos Santos
Subject How can I know if a row is Locked?
Date
Msg-id 651844.97452.qm@web57110.mail.re3.yahoo.com
Whole thread Raw
Responses Re: How can I know if a row is Locked?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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 by date:

Previous
From: Dmitry Turin
Date:
Subject: We all are looped on Internet: request + transport = invariant
Next
From: "A. Kretschmer"
Date:
Subject: Re: How can I know if a row is Locked?