Re: For update

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: For update
Date: 2006-01-16 17:05:15
Message-ID: 20060116170515.GK22228@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ottó Havasvölgyi 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
"MySQL is a toy compared to PostgreSQL." (Randal L. Schwartz)
(http://archives.postgresql.org/pgsql-general/2005-07/msg00517.php)

In response to

  • For update at 2006-01-16 16:59:33 from Ottó Havasvölgyi

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2006-01-16 17:29:39 Re: For update
Previous Message Andreas Seltenreich 2006-01-16 17:02:25 Re: psql client: technique for applying default values to :variables?