Re: "select ..... for update of ..." doesn't support full qualified table name? - Mailing list pgsql-general

From Vlad
Subject Re: "select ..... for update of ..." doesn't support full qualified table name?
Date
Msg-id cd70c68105090611335b02c1d0@mail.gmail.com
Whole thread Raw
In response to "select ..... for update of ..." doesn't support full qualified table name?  (Vlad <marchenko@gmail.com>)
Responses Re: "select ..... for update of ..." doesn't support full qualified table name?
List pgsql-general
yes, we actually use table alias as a workaround, I thought that it's
actually looks like error in postgresql parser (or deeper) that needs
to be reported.

thanks.

On 9/6/05, Matt Miller <mattm@epx.com> wrote:
> On Tue, 2005-09-06 at 13:45 -0400, Vlad wrote:
> > SELECT * FROM one.aa, two.bb WHERE one.aa.a = two.bb.b FOR UPDATE OF
> > one.aa;
> >
> > ERROR:  syntax error at or near "." at character 73 (points to the
> > last instance of "one.aa" in SQL query
>
> Try using a table alias, and reference that alias in the "for update of"
> clause.
>

--
Vlad

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 & unicode
Next
From: Alvaro Herrera
Date:
Subject: Re: Insert Ignore or something similar...