On Thu, 7 Sep 2006, Kaloyan Iliev wrote:
> 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 nu
Kaloyan Iliev <[EMAIL PROTECTED]> 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
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 S
