Re: "select ..... for update of ..." doesn't support full qualified table name?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vlad <marchenko(at)gmail(dot)com>
Cc: Matt Miller <mattm(at)epx(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: "select ..... for update of ..." doesn't support full qualified table name?
Date: 2005-09-06 20:28:13
Message-ID: 20250.1126038493@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vlad <marchenko(at)gmail(dot)com> writes:
> 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.

No, it's supposed to be that way: FOR UPDATE items are table aliases.
Perhaps this isn't adequately documented...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-09-06 20:38:52 Re: Bug or ?
Previous Message Alvaro Herrera 2005-09-06 20:03:34 Re: Shared disk storage