It's one thing for two transactions to deadlock against eachother. It takes special talent to allow a transaction to deadlock against itself, which InnoDB apparently allows.
I have NEVER had issues with PostgreSQL transactions deadlocking against themselves, even with monstrous stored procedures.
I have NEVER had issues with PostgreSQL transactions deadlocking against themselves, even with monstrous stored procedures.