What PostgreSQL version are you using? Please try this in two psql sessions and see if you see the same thing.
--------------------------------------------------------------------------- [EMAIL PROTECTED] wrote: > 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: [EMAIL PROTECTED] > > [ image/gif is not supported, skipping... ] -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
