X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id DD8009FB7BE
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  7 Sep 2006 12:57:22 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 70753-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  7 Sep 2006 12:57:10 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from danbo.digsys.bg (danbo.digsys.bg [192.92.129.13])
	by postgresql.org (Postfix) with ESMTP id 81E5B9FB359
	for <pgsql-sql@postgresql.org>; Thu,  7 Sep 2006 12:30:08 -0300 (ADT)
Received: from [193.68.6.22] (kaloyan@luke.digsys.bg [193.68.6.22])
	by danbo.digsys.bg (8.11.6/8.10.1) with ESMTP id k87FU3p21312;
	Thu, 7 Sep 2006 18:30:03 +0300 (EEST)
Message-ID: <45003AEE.2000604@faith.digsys.bg>
Date: Thu, 07 Sep 2006 18:29:50 +0300
From: Kaloyan Iliev <news1@faith.digsys.bg>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US;
 rv:1.7.12) Gecko/20060117
X-Accept-Language: bg, en, en-us
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-sql@postgresql.org
Subject: Thanks
References: <44FFDFA6.4080600@faith.digsys.bg> <5031.1157638539@sss.pgh.pa.us>
In-Reply-To: <5031.1157638539@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------020204090604080208070409"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.218 tagged_above=0 required=5 tests=AWL, HTML_50_60,
	HTML_MESSAGE, HTML_TITLE_EMPTY
X-Spam-Level: 
X-Archive-Number: 200609/54
X-Sequence-Number: 26265

This is a multi-part message in MIME format.
--------------020204090604080208070409
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 7bit

Thanks a lot!
It works!

Regards,

  Kaloyan Iliev

Tom Lane wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>
>  
>


--------------020204090604080208070409
Content-Type: text/html; charset=windows-1251
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=windows-1251"
 http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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">&lt;news1@faith.digsys.bg&gt;</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>
</body>
</html>

--------------020204090604080208070409--