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
|
| Список | 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 по дате отправления: