X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 8349E9DC82A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 16 Jan 2006 12:59:42 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 88998-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 16 Jan 2006 12:59:37 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.197])
	by postgresql.org (Postfix) with ESMTP id C1B129DC868
	for <pgsql-sql@postgresql.org>; Mon, 16 Jan 2006 12:59:36 -0400 (AST)
Received: by xproxy.gmail.com with SMTP id s14so919930wxc
	for <pgsql-sql@postgresql.org>; Mon, 16 Jan 2006 08:59:36 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=odOBB+UL1Y1YmeIawBgXf73b/vWCVMmkjVDVQKORKRCRMbqfNJJzA9ney6h96k6yH2wrz0h69EOIJCymfRKMeEFb/TaEx5TjrLO9WuxMndQiccYTaaplxkwgUBb5dudWPV2xmOe4CQ+tTYAkbaJlQGXwQV6bG9fwu3jLkh+HDTQ=
Received: by 10.70.12.17 with SMTP id 17mr3843647wxl;
	Mon, 16 Jan 2006 08:59:33 -0800 (PST)
Received: by 10.70.44.7 with HTTP; Mon, 16 Jan 2006 08:59:33 -0800 (PST)
Message-ID: <34608c0c0601160859g4e077ad9g@mail.gmail.com>
Date: Mon, 16 Jan 2006 17:59:33 +0100
From: =?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?= <havasvolgyi.otto@gmail.com>
To: pgsql-sql@postgresql.org
Subject: For update
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_64275_12505066.1137430773590"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.182 required=5 tests=[AWL=0.181,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.182
X-Spam-Level: 
X-Archive-Number: 200601/90
X-Sequence-Number: 23879

------=_Part_64275_12505066.1137430773590
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

What does this do exactly:

select * from <ViewName> where <condition>  for update;

Will be locked all the tuples in all tables it retrieves?

In 8.0.5 this did not work for me.

Thanks,
Otto

------=_Part_64275_12505066.1137430773590
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>Hello,</div>
<div>&nbsp;</div>
<div>What does this do&nbsp;exactly:</div>
<div>&nbsp;</div>
<div>select * from &lt;ViewName&gt; where&nbsp;&lt;condition&gt;&nbsp;&nbsp=
;for update;</div>
<div>&nbsp;</div>
<div>Will be locked all the tuples in all tables it retrieves?</div>
<div>&nbsp;</div>
<div>In 8.0.5 this did not work for me.</div>
<div>&nbsp;</div>
<div>Thanks,</div>
<div>Otto</div>

------=_Part_64275_12505066.1137430773590--