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