Hello everybody,
we just discovered a bug in pgAdmin 4. When closing the Tab in Firefox,
a started transaction stays opened. It can only be killed via a
pg_cancel_backend. We would expect the transaction to be rolled back
instead.
Steps to reproduce:
1. Open a transaction in the query tool
2. close Browser Tab
3. Use pg_stat_activity to verify that process is idle in transaction
Versions:
Windows 10 1803
Firefox 67.0.4 (64-Bit)
pgAdmin 4.10
PostgreSQL server 9.5.4