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