I were testing out (using psql) transactions and locking in postgresql using
only BEGIN/UPDATE(on a specific table)/COMMIT&ROLLBACK and notices several
time that instead of waiting it went into *ABORT STATE*. Why is this?
Also I notice that COMMIT'ing a deadlock'ed transaction did nothing but also
did not return any error message. Why?
Thank you very much!
---
Daniel Akerud, zilch(at)home(dot)se