Re: For update - Mailing list pgsql-sql
| From | Ottó Havasvölgyi |
|---|---|
| Subject | Re: For update |
| Date | |
| Msg-id | [email protected] Whole thread Raw |
| In response to | Re: For update (Ottó Havasvölgyi <[email protected]>) |
| List | 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 <[email protected]>:
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 <[email protected]>: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)