I wonder if it's something to do with the tsearch trigger on food_foods?
Actually, it definitely seems to be the tsearch trigger. The deadlock occurs on every table that uses tsearch trigger, and no table that doesn't.
It's probably not the tsearch trigger itself even, it's probably the fact that the tsearch trigger modifies the row during the update in the second session?
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
