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 cd70c68105090613571bc89b21@mail.gmail.com
Whole thread Raw
In response to Re: "select ..... for update of ..." doesn't support full qualified table name?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "select ..... for update of ..." doesn't support full qualified table name?
List pgsql-general
Tom,

yes, this part is not well documented - specially double checked
before sendin email to the list.

Though question is - doesn't it seem logical to be able to use full
table names in FOR UPDATE part like I can use them in WHERE part (if I
don't need/want to use an alias)? Is it something postgresql speciffic
or it's SQL standard (pardon my ignorance)?

> > 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...

--
Vlad

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug or ?
Next
From: Tom Lane
Date:
Subject: Re: "select ..... for update of ..." doesn't support full qualified table name?