What happens if the transaction is not committed?

Question

PostgreSQL

What happens if I start a transaction in the code, but for some reason I can’t commit or rollback, what will happen in this case. Will this transaction hang forever and lock some of the data that was used in it? Or will postgres itself remove it at some point?

Answer 1

Will be rolled back at the end of the session (i.e. when the connection with the client is lost) or when the server is rebooted.