Thread: Transactions and *ABORT STATE*

Transactions and *ABORT STATE*

From
zilch@home.se
Date:
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@home.se