Re: For update

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(dot)otto(at)gmail(dot)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(at)alvh(dot)no-ip(dot)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 <http://www.planetpostgresql.org/>
> > "People get annoyed when you try to debug them." (Larry Wall)
> >
>
>