Re: Error on failed COMMIT - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Error on failed COMMIT
Date
Msg-id CA+TgmoazgZYHyvXhKdNVxKmhJRqy8HcjZJa3j2bdsR3_Wj7=3Q@mail.gmail.com
Whole thread Raw
In response to Re: Error on failed COMMIT  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Responses Re: Error on failed COMMIT  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
On Tue, Feb 25, 2020 at 12:47 PM Vladimir Sitnikov
<sitnikov.vladimir@gmail.com> wrote:
> Noone suggested that "commit leaves the session in a transaction state".
> Of course, every commit should terminate the transaction.
> However, if a commit fails (for any reason), it should produce the relevant ERROR that explains what went wrong
ratherthan silently doing a rollback.
 

OK, I guess I misinterpreted the proposal. That would be much less
problematic -- any driver or application that can't handle ERROR in
response to an attempted COMMIT would be broken already.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: "imai.yoshikazu@fujitsu.com"
Date:
Subject: RE: [Proposal] Add accumulated statistics for wait event
Next
From: Peter Eisentraut
Date:
Subject: Re: RS_EPHEMERAL vs RS_TEMPORARY