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

Re: Bug #722: SELECT FOR UPDATE bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: paviles(at)its(dot)co(dot)cr, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #722: SELECT FOR UPDATE bug
Date: 2002-07-27 15:58:45
Message-ID: 4583.1027785525@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org 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 of
your problem?

It would also help if you'd state which Postgres version you're using.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Marko MikulicicDate: 2002-07-28 02:53:26
Subject: Money locale currency symbol position
Previous:From: Thomas LockhartDate: 2002-07-27 15:01:27
Subject: Re: Bug #717: timestamp is converted to timestamptz

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