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

From Vladimir Sitnikov
Subject Re: Error on failed COMMIT
Date
Msg-id CAB=Je-GqPtOG-W6A8gkDHb5swQK8YZ+JLzAZbi_5v=JE4UD2hw@mail.gmail.com
Whole thread Raw
In response to Re: Error on failed COMMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom>I think we still end up concluding that altering this behavior has more
Tom>downside than upside.

What is the downside?

Applications, drivers, and poolers already expect that commit might produce an error and terminate the transaction at the same time.

"The data is successfully committed to the database if and only if commit returns without error".
^^^ the above is way easier to reason about than "user must check multiple unrelated outcomes to tell if the changes are committed or not".

Vladimir

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: plan cache overhead on plpgsql expression
Next
From: "曾文旌(义从)"
Date:
Subject: Re: [Proposal] Global temporary tables