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 for update;
After extraction:
select * from UNION ALL for update;
In this case it seems as if "for update" is in su
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
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 unfortunate
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/
On Mon, Jan 16, 2006 at 02:05:15PM -0300, Alvaro Herrera wrote:
> Ottó Havasvölgyi wrote:
> > What does this do exactly:
> >
> > select * from where 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
Ottó Havasvölgyi wrote:
> What does this do exactly:
>
> select * from where 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 He
Hello,
What does this do exactly:
select * from where for update;
Will be locked all the tuples in all tables it retrieves?
In 8.0.5 this did not work for me.
Thanks,
Otto
