Make commit and rollback async in getTransaction example

Add tests for the documented usage.
Add a real-world example of postgres transactions
Fix references to disposer()