Re: Transaction rollback - newbie - Mailing list pgsql-general

From Doug McNaught
Subject Re: Transaction rollback - newbie
Date
Msg-id 87wtwutom3.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Transaction rollback - newbie  ("A. Mous" <a.mous@shaw.ca>)
Responses Re: Transaction rollback - newbie
List pgsql-general
"A. Mous" <a.mous@shaw.ca> writes:

> Hi,
>
> I've got clients connected to pgsql via ODBC.  If they lose their connection
> abruptly, all un-committed transactions are automatically rolled-back (I'm
> assuming) but is there anything left behind that needs to be cleaned up on
> the server side with regards to the uncommitted transaction(s)?

No.  When the connection goes away, the backend will log an error,
roll back the transaction and exit cleanly.

-Doug

pgsql-general by date:

Previous
From: John Fabiani
Date:
Subject: the column in Update
Next
From: David Helgason
Date:
Subject: Re: Transaction rollback - newbie