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;
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