Re: [SQL] Problem with FOR UPDATE

2006-09-07 Thread Stephan Szabo
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

Re: [SQL] Problem with FOR UPDATE

2006-09-07 Thread Tom Lane
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