Re: Problem with FOR UPDATE

Kaloyan Iliev <news1@faith.digsys.bg> writes:
> rsr=# SELECT
> ...
> rsr-#                                FROM debts_desc DD LEFT JOIN config 
> C ON (DD.conf_id = C.id),
> ...
> rsr-#                                                    FOR UPDATE OF 
> debts_desc;
> ERROR:  relation "debts_desc" in FOR UPDATE/SHARE clause not found in 
> FROM clause

Use the alias, ie, DD.  Remember that an alias hides the real name of
that table for all purposes in the current query.
        regards, tom lane