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