X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 707BD9FA474
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  7 Sep 2006 06:00:47 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 91640-02-6 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  7 Sep 2006 09:00:40 +0000 (UTC)
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 86FD29FA2F5
	for <pgsql-sql@postgresql.org>; Thu,  7 Sep 2006 06:00:37 -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 k8790Yp21618
	for <pgsql-sql@postgresql.org>; Thu, 7 Sep 2006 12:00:34 +0300 (EEST)
Message-ID: <44FFDFA6.4080600@faith.digsys.bg>
Date: Thu, 07 Sep 2006 12:00:22 +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: pgsql-sql@postgresql.org
Subject: Problem with FOR UPDATE
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200609/44
X-Sequence-Number: 26255

Hi All,
I have a query in which I want to SELECT FOR UPDATE same rows but only 
from one table.
Firs I try just with SELECT FOR UPDATE but I receive an error
because of the LEFT JOIN - "ERROR:  SELECT FOR UPDATE/SHARE cannot be 
applied to the nullable side of an outer join".
So I decide to use SELECT FOR UPDATE OF <table name> but I then receive 
the error you can see.
Can anyone help me with this query?

Thanks in advance.

  Regards,
    Kaloyan Iliev

rsr=# SELECT
rsr-#        DD.*
rsr-#                                         ( SELECT sum(-amount * 
saldo_sign(credit))
rsr(#                                                   FROM acc_debts ACD1
rsr(#                                                   WHERE 
ACD1.debtid = DD.debtid ) AS saldo,
rsr-#                                                 C.custid,
rsr-#                                                 S.descr_bg
rsr-#                                FROM debts_desc DD LEFT JOIN config 
C ON (DD.conf_id = C.id),
rsr-#                                         acc_debts AD,
rsr-#                                         acc_clients AC,
rsr-#                                         services S
rsr-#                                WHERE DD.debtid = AD.debtid
rsr-#                                       AND DD.closed AND NOT 
DD.paid AND DD.has_invoice AND DD.active AND DD.has_proform AND NOT 
DD.storned
rsr-#                                      AND AD.transact_no = 
AC.transact_no
rsr-#                                                                  
AND AC.ino = 45
rsr-#                                                    FOR UPDATE OF 
debts_desc;
ERROR:  relation "debts_desc" in FOR UPDATE/SHARE clause not found in 
FROM clause
rsr=# select version();
                                            version
------------------------------------------------------------------------------------------------
 PostgreSQL 8.1.4 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC) 
3.4.4 [FreeBSD] 20050518
(1 row)