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)