I have developer with pg 9.3.5, which is reporing something really strange.
He runs importer, which does, in single transaction: begin; select * from table where pkey = <value> limit 1 for update; update table set ... where pkey = <the same_value>; commit; and two backends running the same transaction deadlock. I checked for duplicated rows with the same pkey value - none are there. And frankly - I'm out of ideas. What could be wrong in such case? Detailed logs, with just some obfuscation: https://depesz.privatepaste.com/0594a93459 depesz
