Re: For update
| От | Ottó Havasvölgyi |
|---|---|
| Тема | Re: For update |
| Дата | |
| Msg-id | 34608c0c0601161551q3207bf82p@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: For update (Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>) |
| Список | pgsql-sql |
Hello,
Oh, I got it. Now in 8.0.6
When the view has UNION ALL, then PostgreSQL reports this: SELECT FOR UPDATE is not allowed in subqueries .
I see why:
select * from <view> for update;
After extraction:
select * from <subquery1> UNION ALL <subquery2> for update;
In this case it seems as if "for update" is in subquery2.
How can this be tricked?
Thanks,
Otto
2006/1/16, Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>:
Hello,Sorry, I have just tried it, and works with 8.0.5. I had missed something then. :(I like PostgreSQL. :)Thanks,Otto
2006/1/16, Alvaro Herrera <alvherre@alvh.no-ip.org>:Ottó Havasvölgyi wrote:
> 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.
Sure, I can try it. Show us the definition and tell us what version are
you using.
--
Alvaro Herrera http://www.PlanetPostgreSQL.org
"People get annoyed when you try to debug them." (Larry Wall)
В списке pgsql-sql по дате отправления: