Re: Transaction rollback - newbie

"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