Re: Transaction rollback - newbie

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "A(dot) Mous" <a(dot)mous(at)shaw(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Transaction rollback - newbie
Date: 2004-11-10 02:38:28
Message-ID: 87wtwutom3.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"A. Mous" <a(dot)mous(at)shaw(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Helgason 2004-11-10 03:15:22 Re: Transaction rollback - newbie
Previous Message John Fabiani 2004-11-10 02:33:55 the column in Update