Hi,
I got a question on how postgres handle an interrupted transaction, regarding rollback, commit.
We do have a rather unstable connection to our db and sometime a transaction/session will be disconnected but the process is still visible on the server.
How will postgres handle an update transaction from a client to the server that is disconnected?
- will the query be rollbacked automatically ??
- is it safe to just kill the hanging process on the server?
Regards
Jan Lindgren, Stabilizer