Re: [BUGS] Bug #722: SELECT FOR UPDATE bug

2002-07-29 Thread Stephan Szabo
On Fri, 26 Jul 2002 [EMAIL PROTECTED] wrote: > Pablo Aviles > 27/07/2002 10:58 > > > To: Tom Lane <[EMAIL PROTECTED]> > cc: > Subject: Re: [BUGS] Bug #722: SELECT FOR UPDATE bug > > > Hi, > we are use Postgresql 7.3. &

[BUGS] Bug #722: SELECT FOR UPDATE bug

2002-07-29 Thread paviles
        Subject:        Re: [BUGS] Bug #722: SELECT FOR UPDATE bug [EMAIL PROTECTED] writes: >   SELECT * FROM employees >   WHERE status = 'A' >   LIMIT 1 >   FOR UPDATE; > The problem, in the previous sentence, is block every record on > employees, although we w

Re: [BUGS] Bug #722: SELECT FOR UPDATE bug

2002-07-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > 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. I do not believe that. Could you give a more complete example

[BUGS] Bug #722: SELECT FOR UPDATE bug

2002-07-26 Thread pgsql-bugs
Pablo Avilés Cisneros ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description SELECT FOR UPDATE bug Long Description Hi, I'm encountered a problem with a select for update sentence with postgresql. If I use...: BEGIN TRANSACTION;