Re: Bug #722: SELECT FOR UPDATE bug - Mailing list pgsql-bugs

pgsql-bugs@postgresql.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