Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 0AA2B9FB405
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Apr 2007 08:27:41 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 88280-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Apr 2007 08:27:32 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from web57110.mail.re3.yahoo.com (web57110.mail.re3.yahoo.com
	[216.252.111.123])
	by postgresql.org (Postfix) with SMTP id 372BF9FB232
	for <pgsql-sql@postgresql.org>; Fri, 13 Apr 2007 08:27:36 -0300 (ADT)
Received: (qmail 97637 invoked by uid 60001); 13 Apr 2007 11:27:34 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=Sbu6gIAFMnN0D6cyNgpGElHcKw6LYb2JF5nmOjoReODZAFlb8jCjHt5SzopvIo1XnL7anxmRS81TjDEhRgBVg4qJeSFg2CGI+Zqt0WvSsiWa5NGsBpXXebkuO2jyEqfrmXwPlB7dlcww4nS2ch0bOz1esHdaer3RmYUklTtc/JA=;
X-YMail-OSG: 
 e0asH6kVM1kKM_0omCVE7rmdDifLviJGhFD8xi1tOrIzJdSGyla6c3Pl3KjxmG4Uig--
Received: from [201.58.99.64] by web57110.mail.re3.yahoo.com via HTTP;
	Fri, 13 Apr 2007 04:27:34 PDT
X-Mailer: YahooMailRC/478 YahooMailWebService/0.7.41.10
Date: Fri, 13 Apr 2007 04:27:34 -0700 (PDT)
From: Carlos Santos <carloscompels@yahoo.com.br>
Reply-To: Carlos Santos <carlos@compels.net>
Subject: How can I know if a row is Locked?
To: Lista PostgreSQL SQL <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-714722056-1176463654=:97452"
Message-ID: <651844.97452.qm@web57110.mail.re3.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/140
X-Sequence-Number: 28140

--0-714722056-1176463654=:97452
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

How can I know if a row is locked by another transaction.=0AI have in a tra=
nsaction like that:=0A=0ABEGIN;=0ASELECT * FROM compels.teste WHERE id =3D =
'1' FOR UPDATE;=0A=0APS1: where id is the primary key.=0APS2: The COMMIT co=
mmand is done after a long time.=0A=0AIn this case the row with the primary=
-key equals to '1' will be locked to other transactions until the COMMIT co=
mmand be executed.=0ASo, how can I detect if this row is locked?=0A=0ATks=
=0A =0ACarlos Henrique Iazzetti Santos =0ACompels Inform=E1tica =0A Santa R=
ita do Sapuca=ED - MG=0Awww.compels.net=0A=0A=0A=0A=0A_____________________=
_____________________________=0AFale com seus amigos  de gra=E7a com o novo=
 Yahoo! Messenger =0Ahttp://br.messenger.yahoo.com/ 
--0-714722056-1176463654=:97452
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman,new york,times,serif;fon=
t-size:12pt">How can I know if a row is locked by another transaction.<br>I=
 have in a transaction like that:<br><br style=3D"color: rgb(0, 128, 255);"=
><span style=3D"color: rgb(0, 128, 255);">BEGIN;</span><br style=3D"color: =
rgb(0, 128, 255);"><span style=3D"color: rgb(0, 128, 255);">SELECT * FROM c=
ompels.teste WHERE id =3D '1' FOR UPDATE;</span><br><br style=3D"font-style=
: italic;"><span style=3D"font-style: italic;">PS1: where id is the primary=
 key.</span><br style=3D"font-style: italic;"><span style=3D"font-style: it=
alic;">PS2: The COMMIT command is done after a long time.</span><br><br>In =
this case the row with the primary-key equals to '1' will be locked to othe=
r transactions until the COMMIT command be executed.<br>So, how can I detec=
t if this row is locked?<br><br>Tks<br><div>&nbsp;</div><span style=3D"colo=
r: rgb(0, 96, 191);">Carlos Henrique
 Iazzetti Santos </span><br style=3D"color: rgb(0, 96, 191);"><span style=
=3D"color: rgb(0, 96, 191);">Compels Inform=E1tica </span><br style=3D"colo=
r: rgb(0, 96, 191);"><span style=3D"color: rgb(0, 96, 191);"> Santa Rita do=
 Sapuca=ED - MG</span><br><a rel=3D"nofollow" style=3D"color: rgb(0, 96, 19=
1);" target=3D"_blank" href=3D"http://www.compels.net">www.compels.net</a><=
br><div><br></div></div><br>_______________________________________________=
___<br>Fale com seus amigos  de gra=E7a com o novo Yahoo! Messenger <br>htt=
p://br.messenger.yahoo.com/ </body></html>
--0-714722056-1176463654=:97452--