Re: For update

Поиск
Список
Период
Сортировка
От Ottó Havasvölgyi
Тема Re: For update
Дата
Msg-id 34608c0c0601161333y54d6a285l@mail.gmail.com
обсуждение исходный текст
Ответ на Re: For update  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: For update  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-sql
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ó 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 )

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Owen Jacobson"
Дата:
Сообщение: Re: best way for constants in the database
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: For update