Thanks

Thanks a lot!<br /> It works!<br /><br /> Regards,<br /><br />   Kaloyan Iliev<br /><br /> Tom Lane wrote: <blockquote
cite="mid5031.1157638539@sss.pgh.pa.us"type="cite"><pre wrap="">Kaloyan Iliev <a class="moz-txt-link-rfc2396E"
href="mailto:news1@faith.digsys.bg"><news1@faith.digsys.bg></a>writes: </pre><blockquote type="cite"><pre
wrap="">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   </pre></blockquote><pre wrap="">
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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
              <a class="moz-txt-link-freetext"
href="http://archives.postgresql.org">http://archives.postgresql.org</a>

 </pre></blockquote><br />