From: Kaloyan Iliev <news1@faith.digsys.bg>
To: pgsql-sql@postgresql.org
Subject: Problem with FOR UPDATE
Date: Thu, 07 Sep 2006 12:00:22 +0300
Message-ID: <44FFDFA6.4080600@faith.digsys.bg> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: news1@faith.digsys.bg
Subject: Re: Problem with FOR UPDATE
In-Reply-To: <44FFDFA6.4080600@faith.digsys.bg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox