Re: "select ..... for update of ..." doesn't support - Mailing list pgsql-general

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.