On Fri, Aug 22, 2014 at 9:29 AM, hubert depesz lubaczewski <dep...@gmail.com > wrote:
> 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 transaction isolation level is being used? Cheers, Jeff