Re: Disable Transaction - plans ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Disable Transaction - plans ?
Date
Msg-id 132.1003971146@sss.pgh.pa.us
Whole thread Raw
In response to Re: Disable Transaction - plans ?  ("Dominic J. Eidson" <sauron@the-infinite.org>)
List pgsql-general
Thomas Lockhart <lockhart@fourpalms.org> writes:
> There is a client-side termination handshake, and it could be tied to
> that. If we can distinguish between an intentional exit and an
> unexpected termination, then istm that a commit would be safe to apply
> for the former.

I assert that we cannot safely determine that; it's too easy for a
client logic error to tell libpq to close the connection at the wrong
time, and we should NOT default to committing when that happens.

I think a client using this mode should be expected to send an explicit
commit command before exiting.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disable Transaction - plans ?
Next
From: Alex Pilosov
Date:
Subject: Re: Record