Skip site navigation (1) Skip section navigation (2)

Select For Update bug???

From: paviles(at)its(dot)co(dot)cr
To: pgsql-bugs(at)postgresql(dot)org
Subject: Select For Update bug???
Date: 2002-07-26 12:49:32
Message-ID: OF53EAA4CC.73A94DD0-ON06256C02.00807BF1-06256C03.0005DE14@its.co.cr (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi, I'm encountered a problem with a select for update sentence with 
postgresql.

If I use...:
begin transaction;
select * from employees
where status = 'A'
limit 1
for update;
...

The problem, in the previous sentence, is block every record on employees, 
although we want one record, we want limit 1. The bug it seems the limit 
1, because if I dispose the limit 1 line, only the return records are 
blocked.

If I use:
begin transaction;
select * from employees
where  (status = 1) and (id_employee = 123)
order by id_employee
for update;
...
it block every record on employees, although we want one record, we want 
id_employee = 123. The bug it seems the order by line, because if I 
dispose the order by line, only the return records are blocked.

Do you have an alternative way? Is this a bug? Any suggestion?

I'm using Delphi 6 with dbexpress, and the transaction was make with an 
TSQLClientDataSet component after an TSQLConnection

 
Pablo Avilés Cisneros
Technology, ITS 
Software Development Area
Technology, ITS 
San José, Costa Rica
email: paviles(at)its(dot)co(dot)cr
 
 

Responses

pgsql-bugs by date

Next:From: Kathy zhuDate: 2002-07-26 18:00:01
Subject: bug "\! cd"
Previous:From: serge.zangheriDate: 2002-07-26 10:28:17
Subject: share lib libpq++

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group