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 BA07B9DC878
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 16 Jan 2006 17:33:11 -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 41340-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 16 Jan 2006 17:33:10 -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 E0ABC9DC838
	for <pgsql-sql@postgresql.org>; Mon, 16 Jan 2006 17:33:06 -0400 (AST)
Received: by xproxy.gmail.com with SMTP id s14so953425wxc
	for <pgsql-sql@postgresql.org>; Mon, 16 Jan 2006 13:33:08 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=YUz8ilWNXbFx/WNT9pSkZl6CttHJBQeLtN7gjd730hQYcL9Bw1mcQgZ71dfwe8KMnJH2A2ygsxOzNdK0zw7tb8HZY9OMtcAw+bvX6RHdRvqhX6bw2R+aVS1kQDOGQKnz3qEbRuuA8kctkrNihn7AlRB9cD22ZRjf/akFNBoa5z4=
Received: by 10.70.68.3 with SMTP id q3mr3029676wxa;
	Mon, 16 Jan 2006 13:33:08 -0800 (PST)
Received: by 10.70.44.7 with HTTP; Mon, 16 Jan 2006 13:33:08 -0800 (PST)
Message-ID: <34608c0c0601161333y54d6a285l@mail.gmail.com>
Date: Mon, 16 Jan 2006 22:33:08 +0100
From: =?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?= <havasvolgyi.otto@gmail.com>
To: =?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?= <havasvolgyi.otto@gmail.com>,
	pgsql-sql@postgresql.org
Subject: Re: For update
In-Reply-To: <20060116170515.GK22228@surnet.cl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_68004_21679819.1137447188419"
References: <34608c0c0601160859g4e077ad9g@mail.gmail.com>
	<20060116170515.GK22228@surnet.cl>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.177 required=5 tests=[AWL=0.176,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.177
X-Spam-Level: 
X-Archive-Number: 200601/96
X-Sequence-Number: 23885

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

Hello,

Huh, it was weeks ago, and I thought it was normal. It was a simple view
with one or two inner joins and without aggragates. Perhaps somebody could
try it. I got an error message, that said I cannot do that. I cannot
remember the exact message unfortunately.

Best Regards,
Otto



2006/1/16, Alvaro Herrera <alvherre@alvh.no-ip.org>:
>
> Ott=F3 Havasv=F6lgyi wrote:
>
> > What does this do exactly:
> >
> > select * from <ViewName> where <condition>  for update;
> >
> > Will be locked all the tuples in all tables it retrieves?
>
> Yes.
>
> > In 8.0.5 this did not work for me.
>
> How did it not work?  Was any error message emitted?  What is the view
> definition?
>
> --
> Alvaro Herrera                           Developer,
> http://www.PostgreSQL.org <http://www.postgresql.org/>
> "MySQL is a toy compared to PostgreSQL."             (Randal L. Schwartz)
>      (http://archives.postgresql.org/pgsql-general/2005-07/msg00517.php)
>

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

<div>Hello,</div>
<div>&nbsp;</div>
<div>Huh, it was weeks ago, and I thought it was normal. It was a&nbsp;simp=
le view with one or two inner joins and&nbsp;without aggragates. Perhaps so=
mebody could try it. I got an error message, that said I cannot do that. I =
cannot remember the exact message unfortunately.
</div>
<div>&nbsp;</div>
<div>Best Regards,</div>
<div>Otto</div>
<div><br><br>&nbsp;</div>
<div><span class=3D"gmail_quote">2006/1/16, Alvaro Herrera &lt;<a onclick=
=3D"return top.js.OpenExtLink(window,event,this)" href=3D"mailto:alvherre@a=
lvh.no-ip.org" target=3D"_blank">alvherre@alvh.no-ip.org</a>&gt;:</span>=20
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Ott=F3 Havasv=F6lgyi wrote:<br><=
br>&gt; What does this do exactly:<br>&gt;<br>&gt; select * from &lt;ViewNa=
me&gt; where &lt;condition&gt;&nbsp;&nbsp;for update;=20
<br>&gt;<br>&gt; Will be locked all the tuples in all tables it retrieves?<=
br><br>Yes.<br><br>&gt; In 8.0.5 this did not work for me.<br><br>How did i=
t not work?&nbsp;&nbsp;Was any error message emitted?&nbsp;&nbsp;What is th=
e view<br>definition?=20
<br><br>--<br>Alvaro Herrera&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Developer, <a onclick=3D"return top.js.O=
penExtLink(window,event,this)" href=3D"http://www.postgresql.org/" target=
=3D"_blank">http://www.PostgreSQL.org</a><br>&quot;MySQL is a toy compared =
to PostgreSQL.&quot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp; (Randal L. Schwartz)
<br>&nbsp;&nbsp;&nbsp;&nbsp; (<a onclick=3D"return top.js.OpenExtLink(windo=
w,event,this)" href=3D"http://archives.postgresql.org/pgsql-general/2005-07=
/msg00517.php" target=3D"_blank">http://archives.postgresql.org/pgsql-gener=
al/2005-07/msg00517.php
</a>)<br></blockquote></div><br>

------=_Part_68004_21679819.1137447188419--