Re: deadlock in single-row select-for-update + update scenario? How could it happen?

[hubert depesz lubaczewski <depesz@xxxxxxxxx>]

On Fri, Aug 22, 2014 at 7:29 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:

On 8/22/2014 9:29 AM, hubert depesz lubaczewski wrote:

select * from table where pkey = <value> limit 1 for update;

why is there a limit 1 in there?    pkey=somevalue should only return a single row.   if it DID return multiple rows, you don't have an ORDER BY, so the limit 1 would be indeterminate.

leftover from some other thing.

depesz