Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id E86289FB51E
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue,  3 Apr 2007 09:55:36 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 08476-02-2 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue,  3 Apr 2007 09:55:17 -0300 (ADT)
X-Greylist: delayed 00:06:39.619759 by SQLgrey-1.7.4
Received: from web57105.mail.re3.yahoo.com (web57105.mail.re3.yahoo.com
	[216.252.111.118])
	by postgresql.org (Postfix) with SMTP id C2D8E9FB94D
	for <pgsql-sql@postgresql.org>; Tue,  3 Apr 2007 09:55:22 -0300 (ADT)
Received: (qmail 40142 invoked by uid 60001); 3 Apr 2007 12:48:41 -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=CPc8y5wbci/VorsBbXgqNMm2fGatp+/su+Llj3A9u3Pb2JXXuHdpAJnOKSUnIlP00VZHCPAxn9OItZ9Dl4Xb9np4hcOfkWycymIIUgQ4v5Z5xf1M7n57ggOrTyZd+0Sf+Xz+gGTlrv7lIzVVYI4/Ku2jj/WEb/luFTLZrwJO5HM=;
X-YMail-OSG: 
 5dbpgxEVM1mvYmhVoi9sDeMdWvIXg5Df1InQvRabdl7_ppfPtEGnTrJJ5SJkRp7FxtOle9nCoG2tnidszAvMffYiYQ--
Received: from [201.58.164.249] by web57105.mail.re3.yahoo.com via HTTP;
	Tue, 03 Apr 2007 05:48:41 PDT
X-Mailer: YahooMailRC/476 YahooMailWebService/0.7.41.8
Date: Tue, 3 Apr 2007 05:48:41 -0700 (PDT)
From: Carlos Santos <carloscompels@yahoo.com.br>
Reply-To: Carlos Santos <carlos@compels.net>
Subject: LOCK command inside a TRANSACTION
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1839380692-1175604521=:39515"
Message-ID: <141386.39515.qm@web57105.mail.re3.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/26
X-Sequence-Number: 28026

--0-1839380692-1175604521=:39515
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi!=0AI need Postgresql somehow does this for me:=0A- if an user query a se=
lect on a table, the rows of the table in the result of this select can not=
 be updated or deleted by another user until this one update, delete or dis=
card the changes on those rows.=0A=0AI've found something about the LOCK co=
mmand inside a TRANSACTION but I didn't see how I could do that yet.=0A=0AD=
oes anybody have any ideas?=0A =0ACarlos Henrique Iazzetti Santos =0ACompel=
s Inform=E1tica =0A Santa Rita do Sapuca=ED - MG=0ABrazil=0Awww.compels.net=
=0A=0A=0A=0A=0A__________________________________________________=0AFale co=
m seus amigos  de gra=E7a com o novo Yahoo! Messenger =0Ahttp://br.messenge=
r.yahoo.com/ 
--0-1839380692-1175604521=:39515
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"><span class=3D"postbody">Hi!<br>I need Postgresql somehow does=
 this for me:<br>- if an user query a select on a table, the rows of the ta=
ble in the result of this select can not be updated or deleted by another u=
ser until this one update, delete or discard the changes on those rows.<br>=
<br>I've found something about the LOCK command inside a TRANSACTION but I =
didn't see how I could do that yet.<br><br>Does anybody have any ideas?<br>=
</span><div>&nbsp;</div><span style=3D"color: rgb(0, 96, 191);">Carlos Henr=
ique Iazzetti Santos </span><br style=3D"color: rgb(0, 96, 191);"><span sty=
le=3D"color: rgb(0, 96, 191);">Compels Inform=E1tica </span><br style=3D"co=
lor: rgb(0, 96, 191);"><span style=3D"color: rgb(0, 96, 191);"> Santa Rita =
do Sapuca=ED - MG<br>Brazil<br></span><a rel=3D"nofollow" style=3D"color: r=
gb(0, 96, 191);" target=3D"_blank"
 href=3D"http://www.compels.net">www.compels.net</a><br><div><br></div></di=
v><br>__________________________________________________<br>Fale com seus a=
migos  de gra=E7a com o novo Yahoo! Messenger <br>http://br.messenger.yahoo=
.com/ </body></html>
--0-1839380692-1175604521=:39515--